Lesson Plan
Statistics Education Web

Walk the Line

For Students 9th - 12th Standards
How confident are you? Explore the meaning of a confidence interval using class collected data. Learners analyze data and follow the steps to determine a 95 percent confidence interval. They then interpret the meaning of the confidence...
Lesson Plan
Curated OER

Conversation Heart Graphing

For Teachers 6th
Sixth graders review the different types of graphs (bar, line, pictograph) They predict the data set they can garner several boxes of conversation hearts. Students record their data using an Excel spreadsheet. They create a graph based...
Lesson Plan
1
1
Earth Watch Institute

Entering Local Groundhog Data in an Excel Spreadsheet

For Teachers 4th
Here is a cross-curricular ecology and technology lesson; your learners create spreadsheets depicting the location and number of groundhog dens in a local park. They research groundhogs and analyze data about where the groundhog...
Lesson Plan
Curated OER

Introduction to Limits

For Teachers 9th - 12th
High schoolers practice using graphing calculators and spreadsheets as they explore numeric limits using sequences and functions. They complete a sequencing worksheet, and determine which sequence corresponds to story a story called...
Lesson Plan
Curated OER

Drawing One and Two Playing Cards With Replacement

For Teachers 6th - 9th
Math whizzes use data from simulations to make theoretical generalizations and discuss possible relationships between several given events. They use a simple card game to generate data to be analyzed.
Lesson Plan
Curated OER

Marvelous Math -- Colorful Fractions

For Teachers 2nd - 6th
Students begin the lesson by discovering that a fraction is one part of a whole. In groups, they practice reducting larger fractions into small fractions and discovering they are equal. They use blocks to identify the relationship...
Lesson Plan
Curated OER

Building Arrays Using Excel Spreadsheets

For Teachers 3rd - 5th
Students create arrays using Microsoft Excel. In this technology-based math instructional activity, students expand their knowledge of multiplication by creating arrays on the computer using a spreadsheet program such as Microsoft Excel.
Lesson Plan
Curated OER

Simple Bar Graphs Using Excel

For Teachers 6th - 8th
Students create original survey questions, and develop a bar graph of the data on paper. They input the survey data using two variables onto an Excel bar graph spreadsheet.
Lesson Plan
Curated OER

Temperature High and Lows

For Teachers 5th - 8th
Students gather high and low temperature readings through email. In this temperature graphing lesson, students use a spreadsheet to input data for a graph. students interpret the graphs to compare and contrast the data from different...
Lesson Plan
Curated OER

Moving Day!

For Teachers 8th
Eighth graders continue their geometry unit by focusing on volume. Using data, they create a spreadsheet, estimate and calculate volume. They solve real-life problems and round their answers to the hundredths place. They also practice...
Lesson Plan
Curated OER

Louisville's Best Field Day Park

For Teachers 7th - 12th
Students create a survey to hand out to determine the best field day park. Using their local area, they select five parks, if possible, that meet the criteria and calculate the distance and estimated time travel. They use this...
Lesson Plan
Curated OER

First Class First? Using Data to Explore the Tragedy of the Titanic

For Teachers 9th - 12th
Students analyze and interpret data related to the crew and passengers of the Titanic. They research information on a Titanic database to illustrate specific statistical conclusions, and whether or not social status affected the outcome.
Lesson Plan
Curated OER

Interpreting Data and Statistics using Graphs

For Teachers 7th
Seventh graders interpret data. In this lesson on types of graphs, 7th graders construct, interpret, and analyze different graphs. This lesson includes worksheets and resources.
Lesson Plan
Curated OER

Weather, Weather, Everywhere!

For Teachers 6th
Sixth graders collect weather data to compare temperatures around the world. Using the Internet, learners collect data, put it into spreadsheets, and analyze and graph the results. An interesting way to cover the topic of weather.
Lesson Plan
Curated OER

Discovering Pi

For Teachers 6th
Sixth graders measure circumference and diameter to the nearest eighth of an inch, record measurements on a spreadsheet, and use the internet to complete a "scavenger hunt" of facts concerning pi.
Lesson Plan
Curated OER

Penny Pushing

For Teachers 5th
Fifth graders use an Excel spreadsheet to show them how to enter the amount of pennies they bring each week to school for a fundraising project. They count their pennies each Friday and enter the total amount in the correct columns. In...
Lesson Plan
Curated OER

Buying a Car

For Teachers 8th
Eighth graders create spreadsheets to calculate payments. They create a list of items they would like to purchase that require monthly payments. They simulate buying a car and create a spreadsheet to determine the amount of the monthly...
Lesson Plan
Curated OER

Mmm, Mmm, M&M's

For Teachers 3rd - 5th
Here is another version of the classic M&M math lesson. In this one, upper graders utilize the ClarisWorks Spreadsheet program in order to document the data they come up with from their bags of M&M's. After making their initial...
Lesson Plan
Curated OER

ExplorA-Pond: 6th Grade Area and Random Number Tables

For Teachers 6th
Sixth graders estimate surface area of a pond using a random number table.
Lesson Plan
Curated OER

Two-Variable Linear Inequalities

For Teachers 9th - 11th
Here is an engaging lesson plan on solving equations with two variables. Have the class rewrite linear equations in the slope intercept form, y=mx + b. They graph the lines using the slope and y-intercepts.
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.