Lesson Plan
American Statistical Association

Scatter It! (Using Census Results to Help Predict Melissa’s Height)

For Teachers 6th - 8th Standards
Pupils use the provided census data to guess the future height of a child. They organize and plot the data, solve for the line of best fit, and determine the likely height and range for a specific age. 
Lesson Plan
Curated OER

kind of Bean

For Teachers 3rd
Third graders sort different types of beans and collect the data. They create a data table, put the information on the data table and then graph their results. They answer follow-up questions.
Lesson Plan
Curated OER

Excel Turns Data Into Information

For Teachers 3rd - 8th
Students use excel to analyze data. In this technology lesson, students enter data into the excel program to find averages and organize data.
Lesson Plan
Curated OER

It's Your Life - Safe or Sorry/Safety Issues

For Teachers 6th - 8th
Students examine and chart data about safety hazards and unsafe situations. In this safety hazard lesson, students examine newspapers and web sites to investigate injuries from safety hazards. They make a spreadsheet using the data and...
Lesson Plan
Curated OER

The Viewing Tube

For Teachers 5th - 8th
Looking for an excellent instructional activity that incorporates math, science, and technology? Groups of three students use a viewing tube to perform an experiment, and discover how to organize their data into an Excel...
Lesson Plan
Curated OER

Historical Pollution in the Hudson: Part 2

For Teachers 9th
Ninth graders practice how to format and enter data into an Excel spreadsheet, make a graph, and interpret graphed data. They recognize how the pollution in the Hudson River has changed over time, and explain the consequences of these...
Lesson Plan
Curated OER

Graphing on the Computer

For Teachers 6th - 8th
Students create a bar graph on the computer using given information from the teacher. They create a bar graph using their own information chart (they need to create one on separate paper first). They utilize Microsoft Excel for this...
Lesson Plan
Curated OER

Going Graph-y

For Teachers 2nd
Second graders listen to and dicuss the story Where the Wild Things Are. They play a pantomime game and act out various feelings so their classmates can guess. They listen for the frequency of certain words, and record their findings on...
Lesson Plan
Curated OER

Does cloud type affect rainfall?

For Teachers 7th - 9th
Student use MY NASA DATA to obtain precipitation and cloud type data. They create graphs of data within MY NASA DATA. Young scholars compare different cloud types, compare precipitation, and cloud type data They qualitatively describe...
Lesson Plan
Curated OER

Populations Lab - Cultures Lesson: Statistics / Sampling Patterns

For Teachers 9th
Ninth graders examine the application of statistical sampling, data collection, analysis, and representation that exists in schooling and teenage lifestyles in Japan and the United States.
Lesson Plan
Curated OER

Using Spreadsheets and Graphs

For Teachers 3rd
Third graders explore mathematics by utilizing computers. In this graphing lesson, 3rd graders gather class data based on a particular topic such as the "favorite candy" of the class. Students utilize this information and computers to...
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.
Lesson Plan
Curated OER

Using Excel To Teach Probability And Graphing

For Teachers 3rd - 8th
Students engage in the use of technology to investigate the mathematical concepts of probability and graphing. They use the skills of predicting an outcome to come up with reasonable possibilities. Students also practice using a...
Lesson Plan
Curated OER

Bias in Statistics

For Teachers 7th - 8th
Students work to develop surveys and collect data. They display the data using circle graphs, histograms, box and whisker plots, and scatter plots. Students use multimedia tools to develop a visual presentation to display their data.
Lesson Plan
Curated OER

Counting

For Teachers 1st
First graders explore collecting data. They collect data using a data collection sheet and enter the data into Excel. Students create graphs using Excel. They share their graphs with the class.
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

How Big Is Your Head?

For Teachers 4th - 5th
Students explore measurement by measuring classmates' heads. They record their measurements and they put the measurements in order from smallest to largest. Students figure the mean, median, mode, maximum, minimum, and range of their...
Lesson Plan
Curated OER

Lemonade Business

For Teachers 12th
Twelfth graders use all features of Microsoft Excel and Microsoft Power Point to create charts and graphs. They use charts and graphs to make a Power Point Presentation.
Lesson Plan
Curated OER

Remembering Our Veterans

For Teachers 8th
Eighth graders research a variety of military statistics while using the theme of Remebering Our Veterans. They use data management to plan and create a PowerPoint presentation with their findings. They incorporate different types of...
Lesson Plan
Curated OER

What Can I Afford?

For Teachers 6th - 8th
Students explore the concept of cell phone plans. In this cell phone plan instructional activity, students research the cost of cell phones. Students compare various cell phone plans and decide on which phone plan is best for them.
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

This is the Way We Go To School

For Teachers 2nd
Second graders create and utilize a graph using the Excel computer program. They gather data regarding how the students get to school, tally the numbers for the class, and create a bar graph on paper and using Excel.
Lesson Plan
Curated OER

Using SWMP Data

For Teachers 9th - 12th
Students are introduced to the SWMP system which tracks short-and long-term changes in water. Using this data, they plot and interpret the data on a graph to determine how human activities are lowering the water quality. They also...
Lesson Plan
Curated OER

Remembering Our Veterans Data Management Project

For Teachers 7th
Seventh graders utilize data collected from various sources based on Canadian military statistics to consolidate their understanding of data management. Students plan and create a PowerPoint presentation using this data including in...