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...
Lesson Plan
Curated OER

Be Sharp and Never Flat

For Teachers 2nd - 4th
An outstanding lesson on music awaits your young composers! They learn about patterns found in music, the different sections of an orchestra, and see the differences between musicians and a composer. Excellent streamed videos and good...
Lesson Plan
Polar Trec

Temperature Profile above the South Pole

For Teachers 5th - 8th Standards
Collecting and understanding data is a big part of understanding the world and how it changes. To better grasp what temperatures are changing and how they affect global populations, learners create a graph based on the date provided....
Activity
Fort Bend Independent School District

Data Analysis - AP Statistics

For Students 11th - Higher Ed Standards
What better way to study survey design than to design your own survey! Bring a versatile data analysis project to your AP Statistics class, and encourage them to apply the practices from their instructions to a real-world survey...
Activity
2
2
Teach Engineering

Creepy Silly Putty

For Teachers 10th - 12th Standards
It might be silly to determine the creep rate of putty but groups will enjoy making different formulations of silly putty and playing with them to understand how the different mixtures behave. The second part of the activity has groups...
Lesson Plan
Curated OER

Food for Thought

For Teachers 3rd
Third graders conduct a survey of their class' favorite foods voting on 3-4 favorites overall. They then go to the computer lab and examine how to produce a horizontal bar graph by graphing the favorite foods of the class.
Lesson Plan
Curated OER

How Do Plants Grow?

For Teachers 3rd - 5th
Students investigate plant growth. In this plant growth lesson, students investigate what would happen to plants if they did not have water and sunlight. Students conduct experiments to determine what plants need. Students create a...
Lesson Plan
Curated OER

How Do You Get to School?

For Teachers 3rd
Third graders talk about all the various ways they get to school. They make a list of all the bus numbers that the students use. They also list all the other methods of transportation used and solidify a hypothesis.
Lesson Plan
Curated OER

Dental Detectives

For Teachers 1st
First graders explore the theme of dental health and hygeine. They make tooth loss predictions, count lost teeth, and graph tooth loss. In addition, they listen to dental health stories, read online stories, create spreadsheets, and play...
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...