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.
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

M & M Madness

For Teachers K
Students work with the mathematics unit of collection, organization, and presentation of data. For this math and technology lesson plan, students use Valentine M & M’s and The Graph Club to sort and graph the various colored M &...
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

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

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

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

Jellybean Graphs

For Teachers 2nd
Second graders predict and graph data based on the color of jelly beans they think are in a handful. In this prediction lesson plan, 2nd graders will predict how many of each color jellybean are in a handful. Then they graph these...
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 lesson, 2nd graders interview family members about their reading habits. They then use a graphing computer...
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 activity, 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

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...
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 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

Are You Full of Hot Air?

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

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

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

Excel Turns Data Into Information

For Teachers 3rd - 8th
Learners use excel to analyze data. In this technology lesson, students enter data into the excel program to find averages and organize data.
Lesson Plan
Curated OER

Graphing With Paper and Computers

For Teachers 4th
Fourth graders construct bar graphs. In this graphing lesson, 4th graders create bar graphs in connection with the story, The Copycat Fish. After creating the initial graphs on paper, students use MS Excel to create graphs.
Lesson Plan
Curated OER

Keypals and You

For Teachers 6th - 12th
Students collect and compare data received from keypals. They use electronic mail to exchange information with keypals and rrite a paper comparing similarities and differences between themselves and their keypals. In addition, use a...
Lesson Plan
Curated OER

Oil and its Everyday Uses

For Teachers 4th - 6th
Explore the properties of oil through an experiment. They use the scientific process to investigate oil, participate in experiments, watch videos,and use information from the internet to determine how oil has changed our...