Lesson Plan
Curated OER

Rockefeller's Revenge: Exxon and Mobil Unite

For Teachers 6th - 12th Standards
Study the impact and possible outcomes of the Exxon-Mobil merger in your language arts, social studies, or economics class. Secondary learners evaluate a series of graphs, write a paragraph interpreting the data, and engage in class...
Lesson Plan
Curated OER

Simple Bar Graphs Using Excel

For Teachers 6th - 8th
Students create original survey questions, and develop a bar graph of the data on paper. They input the survey data using two variables onto an Excel bar graph spreadsheet.
Lesson Plan
Curated OER

Creating Circle Graphs using Excel

For Teachers 5th
Fifth graders evaluate data from a circle graph that compares time spent on various activities. They use the computer to manipulate their own data as they compare, examine, create and evaluate data using circle graphs.
Lesson Plan
Curated OER

Graph It

For Teachers 5th - 8th
Elementary and middle schoolers engage in a lesson of graphing in quadrant I of the coordinate plain. They use the graph to create shapes and symbols. While using a graphing calculator, they locate the points on the coordinate plane. In...
Lesson Plan
Curated OER

Favorite Apple Graph

For Teachers 1st
First graders record their favorite type of apple in the form of a graph. They each try one slice of a Red Delicious, Golden Delicious, and Granny Smith apple, select their favorite type, and create a class graph using the data collected.
Lesson Plan
Curated OER

Data Analysis Challenge

For Teachers 5th - 6th
In this data analysis worksheet, young scholars work with a partner to collect information for a survey. The information is then compiled into a graph. Learners must indicate their survey question, the target audience, predict the...
Lesson Plan
Curated OER

Basic Excel

For Teachers 1st - 4th
Students explore basic Excel spreadsheets.  In this spreadsheet lesson plan, students enter Alaska weather information and  perform calculations. Students title the columns on the spreadsheet and format the cells. ...
Lesson Plan
Curated OER

Skittle it Up

For Teachers 6th - 8th
Students make a graph. In this graphing and Excel lesson, students work in groups and are given a bag of skittles. Students count the number of each color skittle and create a table in Excel. Students learn how to make a pie graph using...
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
Polar Trec

How Much Data is Enough?

For Teachers 6th - 12th Standards
The next time you read a magazine or watch the news, make note of how many graphs you see because they are everywhere! Here, scholars collect, enter, and graph data using computers. The graphs are then analyzed to aid in discussion of...
Lesson Plan
Towson University

Looking Backwards, Looking Forward

For Teachers 6th - 8th Standards
How do scientists know what Earth's climate was like millions of years ago? Young environmental scholars discover how researchers used proxy data to determine the conditions present before written record. Grouped pupils gain experience...
Lesson Plan
Curated OER

Fast Food Survey Using Bar Graphs

For Teachers 2nd
Second graders create a bar graph to pictorically represent the data collected from a survey of students. They use Excel to electronically create the graphs and data tallies. They then interpret their data using sentences to explain.
Lesson Plan
Curated OER

Using Spreadsheets and Graphs

For Teachers 3rd
Third graders explore mathematics by utilizing computers. In this graphing lesson, 3rd graders gather class data based on a particular topic such as the "favorite candy" of the class. Students utilize this information and computers to...
Lesson Plan
Curated OER

Hopes and Dreams: A Spreadsheet Lesson Using Excel

For Teachers 4th
Fourth graders read "The Far Away Drawer" by Harriet Diller and discuss the story as a class. After discussion, 4th graders create a t-shirt GLYPH about their hopes and dreams,share their information with the class and create spreadsheets.
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

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

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

Making Data Visualizations

For Teachers 9th - 12th
Relax ... now visualize the data. Introduce pupils to creating charts from a single data set. Using chart tools included in spreadsheet programs class members create data visualizations that display data. The...
Lesson Plan
Curated OER

What's Your Shoe Size? Linear Regression with MS Excel

For Teachers 8th - 12th
Learners collect and analyze data. In this statistics instructional activity, pupils create a liner model of their data and analyze it using central tendencies. They find the linear regression using a spreadsheet.
Lesson Plan
Curated OER

Graphing and Analyzing Biome Data

For Teachers 4th - 6th
Students explore biome data. In this world geography and weather data analysis lesson plan, students record data about weather conditions in North Carolina, Las Vegas, and Brazil. Students convert Fahrenheit degrees to Celsius degrees...
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

What's Up With My Class

For Teachers 6th - 8th
Middle schoolers collect data about their class and they use Excel spreadsheet to display their tables and graphs about the class. They answer survey questions and collect their data. Students create a graph of their choice to display...
Lesson Plan
Curated OER

Farm Stories, Animal Webbing, Favorite Farm Animal Graph

For Teachers K
Students brainstorm animals they would expect to see on a farm. They save these on a Kidspiration web. Students watch or read a farm story. They discuss the characters. Students vote for their favorite farm animal and crate a graph using...
Lesson Plan
Curated OER

Apple Graph

For Teachers K - 1st
Students sample three types of apples. They choose their favorite apple. They create a graph, charting the favorite apples of their classmates. They answer a series of questions.