Lesson Plan
American Institutes for Research

Digital Smiles

For Teachers 4th - 6th
Explore metric measurement, recording data, and creating an electronic spreadsheet displaying results with your math class. Scholars will measure the length of their smiles, record the measurements, and represent the results on an...
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.
Worksheet
Curated OER

Exploring Online Data Analysis Tools Project Interactivate- Plop It

For Students 5th - 7th
In this data analysis worksheet, students access an online data analysis tool at the given web site. They collect name length data for classmates and enter it into the tool. The find and manipulate the data to determine how the median is...
Lesson Plan
Curated OER

Collecting Data and Graphing

For Teachers 8th
Eighth graders, in groups, count the different colors of M&M's in each kind of package and then draw a pictograph to show the results. Each group writes a program to show their results and then compare the manually-drawn and computer...
Activity
Howard Hughes Medical Institute

Spreadsheet Tutorial 1: Formulae, Functions, and Averages

For Students 9th - 12th
Spread your knowledge of spreadsheets. The first of five tutorials in the Spreadsheet Data Analysis unit introduces the basics of spreadsheets. It shows future data analysts how to organize and format tables, and how to use functions to...
Unit Plan
Newspaper Association of America

By the Numbers: Mathematical Connections in Newspapers for Middle-Grade Students

For Teachers 6th - 8th Standards
A cross-curricular resource teaches and reinforces mathematical concepts with several activities that use parts of a newspaper. Scholars use scavenger hunts to find the different ways math is used in the paper along with using data...
Lesson Plan
Curated OER

Statistics Newscast in Math Class

For Teachers 7th - 9th
Learners study sports teams, gather data about the teams, and create a newscast about their data. In this sports analysis lesson, students research two teams and define their statistical data. Learners compare the two teams, make...
Lesson Plan
Curated OER

Baseball Stats

For Teachers 6th - 8th
Students explore data sheets and statistics in baseball. They use baseball data available on the Internet to develop an understanding of the different ways in which data can be analyzed.
Lesson Plan
Curated OER

Then and Now

For Teachers 3rd - 4th
Students conduct research and use census data to compare different times and places. In this census instructional activity, students interpret data from charts and graphs, comparing census information from two time periods as well as...
Lesson Plan
Curated OER

Using Computers to Produce Spreadsheets and Bar Graphs

For Teachers 4th - 12th
Students review graphing terminology and how to plot data points, how to input data into a spreadsheet, and how to make a chart using a computer.
Lesson Plan
Curated OER

Fly Away With Averages

For Teachers 3rd - 5th
Students study mean, median, and mode. They construct paper airplanes and test them to see how far they fly. They measure the distance and then find the averages of their throws. They use spreadsheet software to record the data in a...
Lesson Plan
Curated OER

Using Averages to Create Graphs Through Excel

For Teachers 6th
Sixth graders create and use a spreadsheet to make graphs which will be used to analyze Progress Report and Final Report Card grades. They practice finding the mean, median, mode, and range of a data set. Students also incorporate column...
Lesson Plan
Curated OER

Historical Temperatures

For Teachers 6th - 9th
Young scholars research historical regional temperatures for their current season. In this historical weather lesson, students conduct weather station and Internet research to learn about historical regional temperatures. Young scholars...
Lesson Plan
Curated OER

Home, Home in the City

For Teachers 7th - 9th
Students create a spreadsheet that organizes housing information in the Houston area. They write a formula to determine the average price of homes in the Houston area.