Lesson Plan
Curated OER

Frequency Words

For Teachers 1st
First graders use a graph to answer questions about the frequency of words. Using rhymes, they fill in a chart about the data they collected. In groups, they use their word wall words to identify them in a book.
Lesson Plan
Curated OER

Your Just Desserts

For Teachers 6th - 8th
Middle schoolers write letters to town officials and local businesses asking for favorite dessert recipes. They tabulate their responses in a spreadsheet. Students turn their survey results into colorful graphs.
Lesson Plan
Curated OER

Topic 6: Evaluating and Presenting Results

For Teachers 8th - 9th
Students construct spreadsheets from raw data. In this spreadsheet construction instructional activity, students compile data into Microsoft Excel. Students familiarize themselves with entering and presenting data in a spreadsheet.
Lesson Plan
Curated OER

Using My Nasa Data To Determine Volcanic Activity

For Teachers 8th - 12th
Students use NASA satellite data of optical depth as a tool to determine volcanic activity on Reunion Island during 2000-2001. They access the data and utilize Excel to create a graph that has optical depth as a function of time for the...
Lesson Plan
Curated OER

Skyscraper Capers

For Teachers 5th - 8th
Pupils discuss skyscrapers and listen as the teacher introduces the project. They use the Internet to perform research on one skyscraper. Students use information they gather to create a brochure of their building . They create an Excel...
Lesson Plan
Curated OER

Virtual Field Trip

For Teachers 4th - 6th
Students calculate gasoline cost per mile on a virtual field trip. They calculate the gasoline costs and travel time for each of the 2 routes, and record on a data sheet. They use Excel to create data tables for mileage, gasoline...
Lesson Plan
Curated OER

Motion of a Bowling Ball

For Teachers 5th - 10th
Students experiment with distance, speed, and motion by graphing the motion of a bowling ball. In this distance versus time graphing lesson, students observe the speed and distance of a rolling ball and graph their findings. They then...
Lesson Plan
Curated OER

Statistical Pictures of School and Life

For Teachers 9th - 10th
Students explore how mathematical data is used to summarize and illustrate everyday life. They apply mathematical concepts and skills to analyze data. Students conduct a five question survey of 50 people or more and graph the data.
Lesson Plan
Curated OER

Don't Lose Your Load!

For Teachers 9th - 11th
Students create graphs using collected data. In this algebra instructional activity, students use spreadsheet in Excel to create graphs to interpret their data and make predictions. They rewrite word problems using algebraic expressions.
Lesson Plan
Curated OER

The Kangaroo Conundrum: A Study of a Quadratic Function

For Teachers 8th - 11th
Students play a game and collect data for their graph. In this algebra instructional activity, students solve quadratic equations and identify properties of their graph. They describe the pattern created by the graph and the game.
Lesson Plan
Curated OER

Pedestrian Safety for Students

For Teachers 3rd - 4th
Students create a spreadsheet. In this spreadsheet lesson, students take the responses they received from a pedestrian safety survey to create their spreadsheet. Then they turn this information into a graph.
Lesson Plan
Curated OER

The Racing Heart

For Teachers 5th
Fifth graders locate their own pulse rate from their carotid or radial artery, and graph their pulse rates after completing various exercise activities. They graph their data on a pie graph using Microsoft Excel software.
Lesson Plan
Curated OER

Graphing Speed

For Teachers 9th - 12th
Students use LOGAL motion detector probe and observe a generated graph as a student performs various standard motions, and make measurements of time and distance. They suggest various time and distance measurements which a student can...
Lesson Plan
Curated OER

US Historical Climate: Excel Statistical

For Teachers 11th - Higher Ed
Learners import US Historical Climate Network mean temperature data into Excel from a station of their choice. They are guided through the activity on how to use Excel for statistical calculations, graphing, and linear trend estimates.
Lesson Plan
Curated OER

Graphing Weights and Measures

For Teachers 4th - 6th
Learners practice gathering, averaging, and graphing data. They practice converting measurements to the metric system. Students graph their results and present them to the class.
Lesson Plan
Curated OER

Graphing and Analysis of Water Quality Reports

For Teachers 9th - 11th
Students practice making graphs and interpreting them. They compare and contrast different sets of data. They use Microsoft Excel to create different types of graphs.
Lesson Plan
Curated OER

Temperature Graphing

For Teachers 5th
Fifth graders analyze temperature variations throughout the world by using computer graphing of select major national and international cities.
Lesson Plan
Curated OER

Temperature Graphing

For Teachers 6th - 8th
Students analyze temperature variations throughout the world by using computer graphing of select major national and international cities. After analyzing their findings, students write a paragraph explaining their data.
Lesson Plan
Curated OER

Graphing the Standard Curve

For Teachers 7th - 8th
Srudents demonstrate analysis of colorimetric assay results by analyzing them using a computer graphing program and demonstrate application of standard curves by finding other areas of science that can utilize standard curves in analysis...
Lesson Plan
Curated OER

Creation and Interpretation of Voter Participation Graph

For Teachers 9th
Ninth graders research information about voter participation in the United States based on age. They develop generalizations about voting patterns in the U.S and use Microsoft Excel to analyze the information.
Lesson Plan
Curated OER

Graphing and Demography: The Domestic Slave Trade

For Teachers 9th - 12th
Students create graphs or charts based on the data a narrative imbedded in this plan. They make them either by hand or by using Excel or a similar database program. This lesson plan utilizes technology in a meaningful way.
Lesson Plan
Curated OER

Delicious Graphing

For Teachers 4th
Fourth graders sort trail mix by type and use that information to create different types of graphs for comparing.
Lesson Plan
Curated OER

Microsoft Excel Lesson Plan

For Teachers 5th
Fifth graders collect, organize, interpret data. In addition, they compare different textures, color including graphical representations such as bar graph, line graph .Students also describe the uses of rocks and how to use that to...
Lesson Plan
Curated OER

Virtual Field Trip / Route, Mileage and Gasoline Cost Graphs

For Teachers 4th - 6th
Students use a spreadsheet program to graph and compare milage, gasoline costs and travel time for two travel routes in their virtual field trip in Michigan. They determine the most economical route based on the graphs and calculations.

Other popular searches