Lesson Plan
Curated OER

Loving Literature

For Teachers 1st
First graders, after having "Are You My Mother?" by P.D. Eastman read to them, participate in group discussions or independentally work to analyze a spreadsheet to identify essential elements in the story and graph their data. In...
Lesson Plan
Curated OER

Thanksgiving Dinner

For Teachers 4th - 6th
Pupils plan a traditional Thanksgiving dinner. In this Thanksgiving lesson plan, students compare and contrast the first Thanksgiving to Thanksgiving celebrations today. Pupils plan a traditional Thanksgiving dinner and research the...
Lesson Plan
Curated OER

Graphing Population Around the World

For Teachers 9th - 12th
Students define specific vocabulary necessary for understanding population data. They collect, analyze, and interpret specific data. They utilize computer programs in order to create graphs of collected data.
Lesson Plan
Curated OER

Candy is Dandy

For Teachers 6th - 9th
Students investigate color distribution in bags of M&Ms They sort and classify the contents of a bag of M&Ms and summarize their findings on a worksheet. Students convert the numbers into charts and make predictions about color...
Lesson Plan
Curated OER

How do We Treat Our Environment?

For Teachers 7th
Seventh graders explore the concept of collecting data. In this data collection instructional activity, 7th graders survey others about their environmental habits. Students graph their data.
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

Immigration and Citizenship

For Teachers 5th - 9th
Students make graphs showing Canada's immigration patterns over time. Then students play the role of an immigrant seeking citizenship and perform a mock citizenship ceremony.
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

WebQuest: Thrills and Spills- Pick Your Park!

For Teachers 4th - 6th
Students participate in a WebQuest in which they must determine which amusement park is the "median priced" park. Students visit park websites to accumulate prices for parking, activities, restaurants, and gift shops.
Lesson Plan
Curated OER

Building Arrays Using Excel Spreadsheets

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

What's Your Favorite? Survey And Graphing Project

For Teachers 6th
Sixth graders create and edit spreadsheet documents using all data types, formulas and functions, and chart information. They collect and organize data that be portrayed in a graph that they create using EXCEL.
Lesson Plan
Curated OER

Making a Spreadsheet

For Teachers 5th - 8th
Students explore spreadsheet software.  In this personal finance and computer technology lesson, students develop a vacation spreadsheet on the computer.  Students represent hotel, food, transportation, and entertainment costs...
Lesson Plan
Curated OER

Check Out Lights and Shields with Beads

For Teachers 5th - 8th
Students explore Ultraviolet detecting beads and conduct several investigations with them.  In this investigative activity students participate in an experiment to see the harmful effects of UV light and discuss their findings. 
Lesson Plan
Curated OER

Finding Patterns with the Hundreds Chart

For Teachers 2nd - 3rd
Students review their numbers up to one hundred. Using a chart, they compare and predict patterns that might be in the numbers. They practice skip counting and grouping numbers. Using a spreadsheet, they graph different sets of numbers...
Lesson Plan
Curated OER

Graphing Data on Ellis Island

For Teachers 3rd
Third graders use data to make a bar graph. In this graphing and social studies lesson, 3rd graders use data about where Ellis Island immigrants came from to complete a bar graph on Microsoft Excel.
Lesson Plan
Statistics Education Web

NFL Quarterback Salaries

For Students 9th - 12th Standards
Use statistics to decide if NFL quarterbacks earn their salaries! Learners study correlation coefficients after using technology to calculate regression equations. Through the data, they learn the meaning of correlation and correlation...
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

Pets Galore!

For Teachers 4th
Fourth graders conduct a class survey on the number of pets that the 4th grade owns and they record that data in their math notebooks. They make a bar graph displaying the results using a spreadsheet through Microsoft Excel.
Lesson Plan
Curated OER

The President's Fitness Challenge

For Teachers 7th - 8th
Students identify, from a chart, the distance from the standard depending on age, in the sit-ups portion of The Presidents Fitness Challenge. They will also be able to compare their personal findings with their classmates.
Lesson Plan
Curated OER

Are You My Little Peanut?

For Teachers 4th
Fourth graders explore the mass and length of peanuts by pretending to parent a peanut. In this mode, median and range lesson plan students graph their measurements and then use them to find the mode, median and range. Students discuss...
Lesson Plan
Curated OER

Quarter, Nickel, Dime....

For Teachers 4th - 6th
An engaging game called, "Quarter, Nickel, and Dime" is presented in this math lesson. Players are given an envelope with slips of paper that represent the three coins. In pairs, they play the game 18 times, and the whole class charts...
Lesson Plan
Curated OER

It's In The Chocolate Chips

For Teachers 6th - 8th
Students investigate which brand of chocolate chip cookies contains the most chocolate. They analyze and compare data using Microsoft Word and Microsoft Excel. They communicate the results with Microsoft PowerPoint.
Lesson Plan
Curated OER

Exploring Linear Equations And Scatter Plots - Chapter 5 Review

For Teachers 6th - 7th
Students complete rolling stocks experiment, and collect and enter data on the computer. They enter data on graphing calculators, complete scatter plot by hand with line of best fit, and discuss different graphing methods.
Lesson Plan
National Wildlife Federation

Get Your Techno On

For Teachers 9th - 12th Standards
Desert regions are hotter for multiple reasons; the lack of vegetation causes the sun's heat to go straight into the surface and the lack of moisture means none of the heat is being transferred into evaporation. This concept, and other...