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
Curated OER

Great Graphing

For Teachers 7th - 8th
Learners 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

Data! Data! Graph that Data!

For Teachers 5th
Fifth graders create data graphs using Microsoft Excel. In this data collection lesson, 5th graders create and conduct a survey, then use Excel to organize and graph their data.
Lesson Plan
Curated OER

Graph Frenzy!!

For Teachers 6th - 7th
Students brainstorm for a survey question to ask classmates. They survey their classmates. They enter the results into a spreadsheet and create the best graph for the information. They share their graphs with the class.
Lesson Plan
Curated OER

Are You Full of Hot Air?

For Teachers 2nd - 3rd Standards
Explore the concept of measuring and recording circumference. In this physical science and measurement lesson, young learners blow up balloons, measure the circumference, and record the data on an interactive graphing website.
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 3: Column Graphs, Error Bars, and Standard Error of the Mean

For Students 9th - 12th
There's absolutely no error in using the tutorial! Learners use spreadsheets to create column or bar graphs with error bars. They also learn how to calculate the standard error of the mean in the tutorial. This is the third installment...
Lesson Plan
1
1
Earth Watch Institute

Entering Local Groundhog Data in an Excel Spreadsheet

For Teachers 4th
Here is a cross-curricular ecology and technology lesson; your learners create spreadsheets depicting the location and number of groundhog dens in a local park. They research groundhogs and analyze data about where the groundhog...
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 lesson, students interpret data from charts and graphs, comparing census information from two time periods as well as from two different...
Lesson Plan
Curated OER

Creek Detectives WISE On-line Research Community

For Teachers 5th - 8th
Students investigate ways people cause harm to the environment. In this environmental lesson plan, students explore a case study on the Internet. Students explore all of the online activities and collect data for a presentation.
Activity
Curated OER

A Research Project and Article For the Natural Inquirer

For Teachers 4th - 10th
Get your class to use the scientific process to solve a scientific problem. They utilize the Natural Inquirer magazine to identify a research question which they write an introduction to and collect data to answer. They use graphs,...
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 plan, students enter data into the excel program to find averages and organize data.
Lesson Plan
Curated OER

How to Graph in Excel

For Teachers 4th
Fourth graders construct data graphs on the Microsoft Excel program. In this statistics lesson, 4th graders formulate questions and collect data. Students represent their results by using Excel.
Lesson Plan
Curated OER

Identifying Ozone Variations over Different Locations

For Teachers 7th - 12th
Learners analyze ozone data.  In this atmosphere lesson, students will use a NASA resource to gather data for different regions of the Earth.  Learners will then create a graph for their data and answer related questions. 
Lesson Plan
Curated OER

Graphing Family Reading Habits

For Teachers 2nd
Second graders collect data from their families about their reading habits and graph them. In this graphing family reading habits instructional activity, 2nd graders interview family members about their reading habits. They then use a...
Lesson Plan
Curated OER

Gingerbread Man Math

For Teachers K
Students collect and explore gingerbread man data. In this math and technology lesson plan, students examine how to organize and interpret data in three formats: objects, pictures, and graphs.  
Lesson Plan
Curated OER

Graphing With Candy

For Teachers 3rd - 5th
Students gather information and interpret the results using a tally chart, a table, and a bar graph.
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

Countdown to Disaster

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

M & M Madness

For Teachers K
Students work with the mathematics unit of collection, organization, and presentation of data. In this math and technology lesson plan, students use Valentine M & M’s and The Graph Club to sort and graph the various colored M & M’s.
Lesson Plan
Curated OER

EXCEL It!

For Teachers 5th - 8th
Students surf the Web gathering information about graphs. The data collected is incorporated into an Excel spreadsheet and graphs of varying nature generated to further enhance student understanding.
Lesson Plan
Curated OER

The Solar Cycle

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

Excel temperature Graphs

For Teachers 4th - 6th
Students gather data about the weather in Nome, Alaska. In this Nome Temperature lesson, students create an excel graph to explore the weather trends in Nome.  Students will find the average weather and add a trend line to their graph.