Lesson Plan
Curated OER

Excel temperature Graphs

For Teachers 4th - 6th
Students gather data about the weather in Nome, Alaska. For this Nome Temperature lesson, students create an excel graph to explore the weather trends in Nome.  Students will find the average weather and add a trend line to their...
Lesson Plan
Curated OER

Interpreting Data and Statistics

For Teachers 9th - 11th
Students define terms and analyze data. In this statistics lesson, students plot their data using bar and line graphs. They analyze their data after they graph it and apply the results to the Great Depression.
Lesson Plan
Curated OER

Graphs

For Teachers 8th - 9th
Students graph ordered pairs to model the relationship between numbers. After observing the patterns in ordered pairs, they describe the relationship, and create graphs from a data table. Students describe intervals in the graph, and...
Lesson Plan
Curated OER

Green Food Graph

For Teachers K - 2nd
Learners explore graph making by investigating St. Patrick's day food. In this holiday food instructional activity, students discuss their favorite green foods in honor of St. Patrick's day. Learners create a graph based on the data of...
Lesson Plan
Curated OER

Modeling Linear Relationships

For Teachers 8th - 10th
Students graph lines using the slope and y-intercept. In this algebra lesson, students create data using tables and equations. They use their data to make predictions and draw conclusion.
Lesson Plan
Curated OER

Energy Conservation Lesson 1: Fossil Fuels and the Ticking Clock

For Teachers 2nd - 5th
Students explore energy production by participating in a class discussion. In this renewable energy lesson, students discuss the differences between solar, coal, wind and fossil fuel energy sources and why some are better for the...
Lesson Plan
Curated OER

Rouge River Data

For Teachers 3rd - 5th
Students participate in using Excel sofware in order to create graphs. They create the graphs using data that they gathered during the Rouge River Field Trip they attended. The produce bar graphs from the excel spreadsheets.
Lesson Plan
Curated OER

Graphing Pockets

For Teachers 2nd
Second graders explore graphing. They count the number of pockets on their clothes and use Microsoft Excel to enter their data. Students create a class graph displaying their findings.
Lesson Plan
Curated OER

Line Graphs

For Teachers 7th
Seventh graders create a line graph and identify when to use line graphs. In this line graphs lesson plan, 7th graders analyze the average temperatures of various cities. Students graph the data they collected.
Lesson Plan
Curated OER

Discovering Pi

For Teachers 7th - 8th
Young scholars develop a formula that describes the functional relationship of the circumference of a circle to its diameter. Working with a partner, they measure the diameter and circumference of circular objects in order to discover...
Lesson Plan
Curated OER

The Fat and the Lean

For Teachers 8th - 11th
Students collect data on calorie intake. In this algebra lesson, students use the collection of data to make better eating decisions. They investigate the nutritional value in food using a graph and draw conclusion from their findings.
Lesson Plan
Curated OER

Taste the Rainbow

For Teachers 6th - 8th
Students practice estimating and graphing by utilizing Skittles.  In this statistics instructional activity, students complete worksheets based on the likelihood of a certain color of skittle coming out of the bag.  Students...
Lesson Plan
Curated OER

Lines of Fit

For Teachers 9th - 11th
Students solve equations dealing with best fit lines. In this algebra lesson, students solve problems by analyzing data from a scatterplot, and define it as positive, negative or no correlation. They classify slopes the same way as...
Lesson Plan
Curated OER

Patterns In Hexagon Tables

For Teachers 6th
Sixth graders construct a rule about the number of sides found in a pattern of hexagons. In this mathematical problem solving lesson, 6th graders observe different hexagon patterns and create a rule about the relationship between the...
Lesson Plan
Curated OER

Baseball Relationships - Using Scatter Plots

For Teachers 6th - 10th
Students use graphing calculators to create scatter plots of given baseball data. They also determine percentages and ratios, slope, y-intercepts, etc. all using baseball data and statistics.
Lesson Plan
Curated OER

Line 'Em Up!

For Teachers 3rd - 5th
Students find coordinate points on a grid and create a line graph with those points. This lesson should ideally be used during a unit on various types of graphs. They make and use coordinate systems to specify locations and to describe...
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
Mathematics Assessment Project

Mean, Median, Mode, and Range

For Teachers 5th - 8th Standards
What a find! Here is a lesson, designed to meet sixth grade math Common Core standards, that focuses on the calculation of different measures of center for the scores from a penalty shoot-out competition. An independent...
Lesson Plan
Curated OER

Can you Find the Expression

For Teachers 10th - 11th
Students collect data from measurements and weights for this experiment. In this algebra instructional activity, students analyze graphs they create form their data to find the expression representing the data. They label which graph...
Lesson Plan
Curated OER

Bar Me In

For Teachers 4th
Fourth graders watch a video about constructing bar graphs. They create their own graph and interpret it.
Lesson Plan
Curated OER

California Here We Come!

For Teachers 4th - 7th
A highly relevant and great cross-curricular project! In teams, your class will plot a course from the East Coast to Sacramento, California passing through all of the state capital cities along the way. As part of the journey, teams...
Lesson Plan
Curated OER

Graphing

For Teachers 5th
Fifth graders create graphs based on climate in South Carolina. They read and interpret information in a chart and construct a graphy from the information in the chart. They create a spreadsheet using Excel and publish 2 graphs.
Lesson Plan
Curated OER

Monster Graph Activity

For Teachers 7th
Seventh graders engage in a activity which take the fear out of graphing. They create and draw conclusions from data found in a Monster graph.
Lesson Plan
Curated OER

Algebra: Do You See What I See?

For Teachers 9th - 12th
Students discover how to find the mean, median, and mode from sets of data. By using statistical techniques such as whisker plots and bar graphs, they display the data gleaned from problems. Individually, students complete projects...