Curated OER
Create a Graph Online
Scholars create colorful bar, line, or pie graphs. They decide on a survey question to ask or a type of data to gather. From there, they collect information and data. They display this data in bar, line, or pie graphs that they create...
Curated OER
Graph Frenzy!!
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.
Howard Hughes Medical Institute
Spreadsheet Tutorial 3: Column Graphs, Error Bars, and Standard Error of the Mean
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...
Earth Watch Institute
Entering Local Groundhog Data in an Excel Spreadsheet
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...
Curated OER
Great Graphing
Students 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.
Curated OER
M & M Madness
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.
Curated OER
Data! Data! Graph that Data!
Fifth graders create data graphs using Microsoft Excel. For this data collection lesson, 5th graders create and conduct a survey, then use Excel to organize and graph their data.
Curated OER
Graphing With Candy
Students gather information and interpret the results using a tally chart, a table, and a bar graph.
Curated OER
kind of Bean
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.
Curated OER
Are You Full of Hot Air?
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.
Curated OER
Gummy Bear Math
First graders predict, collect data, and create a graph based on gummy bear colors they are given. For this graphing lesson plan, 1st graders first predict how many colors of gummy bears there are. They then count the colors, graph them,...
Curated OER
How to Graph in Excel
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.
Curated OER
Jellybean Graphs
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...
Curated OER
Graphing Family Reading Habits
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...
Curated OER
Excel Turns Data Into Information
Students use excel to analyze data. For this technology lesson, students enter data into the excel program to find averages and organize data.
Curated OER
Graphing With Paper and Computers
Fourth graders construct bar graphs. For 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.
Curated OER
Using Computers to Produce Spreadsheets and Bar Graphs
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.
Curated OER
Collecting Data and Graphing
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...
Curated OER
Identifying Ozone Variations over Different Locations
Students analyze ozone data. In this atmosphere lesson, students will use a NASA resource to gather data for different regions of the Earth. Students will then create a graph for their data and answer related questions.
Curated OER
Weather
Learners create a spreadsheet and chart using data collected. In this weather lesson, students select five cities from their state, including the city they live in. Learners take daily temperature readings from all five...
Curated OER
The Solar Cycle
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.
Curated OER
Graphing
Students gather statistical information on a chosen topic and place it into a spreadsheet. Using th Excel chart wizard, students create tables, graphs and charts of their information. They interpret the data and share it with the class.
Curated OER
EXCEL It!
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.
Curated OER
Excel temperature Graphs
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.