Lesson Plan
Curated OER

Shoe Showdown

For Teachers 3rd
Third graders use rulers to measure their shoe size in inches and centimeters. They then enter the class shoe measurements into an excel data base and graph the results of both to make the comparison.
Lesson Plan
Curated OER

What's Playing Tonight?

For Teachers 5th - 9th
Students collect data and visually represent it. They conduct a survey of favorite movies. Using a spreadsheet, students organize the data and create bar and circle graphs. Students answer statistical questions regarding the data.
Lesson Plan
Curated OER

Excel Lesson

For Teachers 4th - 5th
Students explore data and Excel spreadsheets. They collect data about political candidates. Students enter the data into a chart on Excel. They create a graph using the data and Excel.
Lesson Plan
Curated OER

Solving Polynomial Equations

For Teachers 9th - 12th
Students demonstrate how to use spreadsheets as a tool for analyzing, visualizing and solving mathematical problems. Students obtain fundamental grasp of cubic equations and other polynomial equations.
Lesson Plan
Curated OER

Spreadsheet Function Machine

For Teachers 7th - 8th
Students create a spreadsheet to analyze functions. In this algebra lesson plan, students use spreadsheets to find the intersection of systems of equations. They identify the dependent and independent function as it relates to a line.
Lesson Plan
Curated OER

Touring the Regions of the United States

For Teachers 5th
Fifth graders explore the regions of the United States. They use maps, research on the Internet and use measurements and estimations. Students create a presentation using spreadsheets and publishing software.
Worksheet
Curated OER

Piecewise Linear Functions and Excel

For Students Higher Ed
In this linear function worksheet, students use Excel worksheets to solve piecewise linear functions. They plot functions and produce piecewise linear functions. This six-page worksheet contains detailed instructions on how to use...
Lesson Plan
2
2
Federal Reserve Bank

Expense Tracking

For Students 9th - 12th Standards
Where does all your money go? Individuals keep a record of the money they spend over the course of 30 days. They then categorize where they are spending their money and write an essay detailing their findings.
Lesson Plan
EngageNY

Normal Distributions (part 2)

For Students 10th - 12th Standards
From z-scores to probability. Learners put together the concepts from the previous lessons to determine the probability of a given range of outcomes. They make predictions and interpret them in the context of the problem.
Lesson Plan
Curated OER

Bones and Math

For Teachers 5th - 12th
students identify and explore the connection between math and the bones of the human body. Students collect data about bones from their classmates and from adults, apply formulas that relate this data to a person's height, and organize...
Lesson Plan
Curated OER

Math: The Bone connection

For Teachers 5th - 12th
Young scholars examine the connection between bones of the human body and math. In groups, they locate bones and determine which instruments are used for measuring. Students organize their findings and create spreadsheets for calculating...
Worksheet
Curated OER

Experiment-Using Formulas and Spreadsheets

For Students 9th
In this Algebra I worksheet, 9th graders track information relating to a sporting event and create a spreadsheet and appropriate formulas used to track data.  The one page worksheet contains the assignment and...
Lesson Plan
Curated OER

The Solar Cycle

For Teachers 7th - 12th
Students research the solar cycle. In this Science lesson, students use the internet to investigate the solar cycle. Students produce a spreadsheet and graph from the information collected.
Lesson Plan
Curated OER

Electronic Spreadsheets & Iditarod 2000

For Teachers 6th - 8th
Students use the Internet for gathering information for Iditarod race journals. They use a spreadsheet program for entering data and making charts for showing changes in speeds achieved over a period of four weeks in timed writings in...
Lesson Plan
Curated OER

Creating a Bar Graph Using a Spreadsheet: Dice Rolling Probabilities

For Teachers 10th
Tenth graders explore the concept of spreadsheets. They create a simple spreadsheet and chart from given data. Students perform basic formatting procedures on their chart. They use spreadsheet functions to perform calculations.
Lesson Plan
Curated OER

Holiday Cards using Publisher

For Teachers 2nd - 6th
Learners create a holiday card using technology. In this technology instructional activity, students use Publisher templates to create a holiday card. Learners organize, design, and edit their card.
Lesson Plan
Curated OER

Using Calculators And Spreadsheets

For Teachers Higher Ed
Students discuss the advantages of using calculators and spreadsheets in balancing checkbooks. They also identify the pros and cons of using these tools in adult education classrooms.
Lesson Plan
Curated OER

Spreadsheets in Science

For Teachers 4th
Fourth graders create spreadsheets, explore patterns and make predictions based on the information. They select the appropriate graph to display the spreadsheet data. They search and sort prepared data bases to gain knowledge for...
Lesson Plan
Curated OER

Using Computer for Statistical Analysis

For Teachers 6th - 12th
Students examine the use for spreadsheets in analyzing data. They make spreadsheets that display and calculate a given data set such as temperature change.
Lesson Plan
Curated OER

Calculating & Graphing Using a Spreadsheet

For Teachers 11th - 12th
Students use the lab apparatus to calculate the average velocity and average acceleration at several points and record the data. They use the spreadsheets to plot distance vs. time, velocity vs. time and acceleration vs. time graphs.
Lesson Plan
Curated OER

Flavorful Spreadsheets

For Teachers 4th - 8th
Students create a spreadsheet which includes a bar graph. They sort and classify information and use the average function on a spreadsheet. They research Skittles candy and summarize their findings on a spreadsheet.
Lesson Plan
Curated OER

Geoboard Area

For Teachers 3rd - 6th
Students explore the basic geometric shapes and geometric shape vocabulary through the use of geoboards and virtual geoboards. They create a variety of shapes with a partner, build ten different rectangles on their geoboards, and...
Lesson Plan
Curated OER

Fantasy Basketball

For Teachers 6th - 8th
Learners play Fantasy Basketball in order to practice locating Internet information and using technology tools to display data; students demonstrate an understanding and use of graphing, probability, and statistics.
Lesson Plan
Curated OER

Great Graphing

For Teachers 7th - 8th
Students collect data, use a computer spreadsheet program to create various graphs, and compare the graphs. They state the findings of each graph in writing and decide which graph type best represents the data.