Lesson Plan
Curated OER

Student News And Weather Channel

For Teachers 5th
Fabulous! Your 5th graders should love this project. As an ongoing lesson throughout the year students use temperature probes to record outside temperature and then document their data using spreadsheets. They use their weather data and...
Lesson Plan
Curated OER

Graphing Our Marbles

For Teachers K
Students collect information pertaining to marble colors found in their bag; then creating a spreadsheet in order to make a chart representing their findings using Microsoft Excel. Students will present their results to small groups.
Lesson Plan
Curated OER

Surname Survey

For Teachers 3rd - 12th
Students use data from the U.S. Census Bureau to determine whether last names in a local phone directory reflect the Census Bureau's list of the most common surnames in the country. In this surnames lesson plan, students use the Internet...
Lesson Plan
Curated OER

Gummy Bear Math

For Teachers 1st
First graders predict, collect data, and create a graph based on gummy bear colors they are given. In this graphing lesson plan, 1st graders first predict how many colors of gummy bears there are. They then count the colors, graph them,...
Lesson Plan
Kenan Fellows

Designing and Analyzing Data Collected from Wearable Devices to Solve Problems in Health Care

For Teachers 9th - 12th Standards
Wearable devices have become more the norm than the exception. Learners analyze data from a sample device with a regression analysis in a helpful hands-on lesson. Their focus is to determine if there is a connection between temperature...
Lesson Plan
Curated OER

M & M Madness

For Teachers 1st
M&M's are always a great manipulative to use when teaching math. In this graphing lesson plan, learners predict how many of each color of M & M's there are. They count up each color and plug the data into a graph using the...
Lesson Plan
Curated OER

Creating a Spreadsheet and Graph

For Teachers 4th - 5th
Students create graphs in Excel.  In this spreadsheet lesson, students input data into spreadsheet cells then use the graphing feature of the Excel program to produce colorful graphs of the data.  The directions to create the...
Lesson Plan
Curated OER

First Grade Shoe Sizes

For Teachers 3rd
Third graders collect shoe size data from classmates in their room and another third grade. They predict what the most common shoe size will be. They place the data in an spreadsheet on the computer. They design a graph using the...
Lesson Plan
Curated OER

Graph Lesson

For Teachers 1st
First graders collect data on different eye colors of each student in their classroom. They input the data that they gathered in an Excel spreadsheet and then create a graph in Excel.
Lesson Plan
Curated OER

Beginning Graphs in MS Excel

For Teachers 3rd - 5th
Students practice creating graphs in Microsoft Excel. In this technology lesson, students conduct a random survey and collect data. Students use the Microsoft Excel program to create a bar graph of the data.
Activity
1
1
Teach Engineering

Energy on a Roller Coaster

For Teachers 9th - 12th Standards
Roll with your class into the idea of conservation of energy. Pupils use a roller coaster track to collect data to reinforce the concept of conservation of energy and the influence of friction. Class members then create a graph from...
Lesson Plan
Curated OER

Tally Charts and Graphs

For Teachers 4th
Fourth graders play the game 'Data Picking', where they collect data, place the data into a tally chart, and choose the circle graph that best represents the data. They go to the Mathfrog website and select 'Picking'. Students choose...
Lesson Plan
Curated OER

Countdown to Disaster

For Teachers 2nd - 5th
Students discover the potential dangers of weather in their hometown.  In this environmental lesson plan, students research Hurricane Hugo and the devastation it caused South Carolina in 1989.  Students record weather data from...
Organizer
Curated OER

Tides at the Battery, NY

For Students 7th - 12th
Skill in using Excel and increasing proficiency in manipulating data are challenged with this data analysis work.  A web link supplies data and step-by-step instructions help learners create a graph.  There are many extension...
Lesson Plan
Curated OER

Time Management

For Teachers 3rd - 6th
Students record their daily activities and graph the results using the educational software program called Inspiration. This lesson plan is intended for the upper-elementary classroom and includes resource links and activity extensions.
Lesson Plan
Curated OER

Biological and Agricultural Engineering

For Teachers 8th
Eighth graders explore mathematics by conducting a series of investigations using a colorimeter. In this math lesson, 8th graders explain the purpose of food irradiation. They collect data and graph them.
Lesson Plan
Curated OER

Creating Circle Graphs with Microsoft Excel

For Teachers 7th
Seventh graders will learn how to construct circle graphs using paper and pencil. Then they will learn how to construct circle graphs using Microsoft Excel. This lesson uses technology and shows learners how to cross skills into the...
Lesson Plan
Curated OER

Graphing Favorite Fruit

For Teachers 3rd
Third graders take poll and sort data, enter the data to create a spreadsheet and create bar and pie graphs.
Lesson Plan
Curated OER

The Solar Cycle

For Teachers 7th - 12th
Learners research the solar cycle. In this Science lesson plan, students use the internet to investigate the solar cycle. Learners produce a spreadsheet and graph from the information collected.
Lesson Plan
Curated OER

"who Lives in Your House?"

For Teachers 4th
Fourth graders collect data about the people and animals living in their homes, and the students' shoe sizes. They work in groups to enter the information into a database from which they create graphs. They analyze the data to find the...
Lesson Plan
Curated OER

MAISA and the REMC Association of Michigan

For Teachers 5th - 7th
Students complete online research to study geography's impact on weather. In this geography and weather lesson, students research weather in their city for ten days using an online website. Students bookmark the site, enter data into a...
Lesson Plan
Curated OER

Forces and Graphing

For Teachers 6th - 8th
Middle schoolers analyze graphs to determine relationships between variables and rates of change. They determine the basic concepts about static reaction forces. They determine the slope and equation of a line.
Lesson Plan
1
1
Teach Engineering

The Challenge Question

For Teachers 7th - 9th Standards
A research position becomes a modeling job. The introductory lesson in a series of nine presents the challenge of analyzing a set of bivariate data. The class brainstorms what the data may represent. Pupils must decide what is needed to...
Lesson Plan
Teach Engineering

Fun with Air-Powered Pneumatics

For Teachers 7th - 12th Standards
How high did the ball go? Engineering teams build a working pneumatic system that launches a ball into the air. The teams vary the amount of pressure and determine the accompanying height of the ball. An extension of building a device to...