Lesson Plan
2
2
Google

Graphing with Google Docs & Forms

For Teachers K - 3rd Standards
Get to know your class and teach about data analysis all with the help of Google Docs. Using student-generated questions, create a class survey using Google Forms. Reserve time in the computer lab for learners to complete the form and,...
Lesson Plan
Curated OER

Using GLOBE Data to Study the Earth System (College Level)

For Teachers 7th - 12th
Students use the GLOBE Website to locate and study environmental data. They use the GLOBE Graphing Tool to display data. Students describe the role of solar energy in the annual fluctuations of soil moisture. They describe reservoirs and...
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

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

Using Computer for Statistical Analysis

For Teachers 6th - 12th
Students examine the use for spreadsheets in analyzing data. They make spreadsheets that display and calculate a given data set such as temperature change.
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

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

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

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

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

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

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

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 Using Excel

For Teachers 5th
Fifth graders complete a series of graphs by gathering information and using Excel to graph the information.  In this graphing lesson plan, 5th graders graph favorite desserts of the class. Student put their results into the...
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

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

M & M Madness

For Teachers 2nd
Second graders graph M & M's by color. In this graphing lesson plan, 2nd graders first predict how many of each color they think are in a handful of M & M's. Then they graph the amounts of each color on a computer program....
Lesson Plan
Curated OER

Twelve Days of Christmas

For Teachers 6th - 8th
Students create charts and graphs using a spreadsheet. They chart the number of each gift given day by day from the song, "The Twelve Days of Christmas." They create a bar graph and a circle graph from their data on the spreadsheet.
Lesson Plan
Curated OER

Moooooove into Graphing

For Teachers 1st
First graders explore graphing software and create their own graph of farm animals. Then students analyze their graph using the teacher made worksheet which is imbedded in this lesson plan. Great lesson!
Lesson Plan
Curated OER

Spreadsheet Graphs

For Teachers Higher Ed
Students create graphs using information from spreadsheets. They select a topic from the following choices: website use, digital cameras, spreadsheets, calculators or educational software. They tally the class results and create an...
Lesson Plan
Curated OER

Planet Protectors

For Teachers 6th - 8th
Students explore ways to protect the earth.  In this environmental issues and technology lesson, students investigate the water quality in their community and compare their findings to the water quality in other geographic...
Lesson Plan
Curated OER

Pea+Nut = Math

For Teachers 2nd - 6th
Learners utilize peanuts to practice fractions.  In this math model lesson, students solve multiplication problems and fractions with real peanuts.  Learners use drawing software to graph data from the math equations.
Lesson Plan
Curated OER

What Do I Want To Be When I Grow Up?

For Teachers 6th - 9th
Students divide careers into clusters.  In this vocational technology lesson, students prepare a PowerPoint presentation of one of the six career clusters.  Working in small groups, students organize a variety of careers into...
Lesson Plan
Curated OER

Electronic Spreadsheets & Iditarod 2000

For Teachers 6th - 8th
Students use the Internet for gathering information for Iditarod race journals. They use a spreadsheet program for entering data and making charts for showing changes in speeds achieved over a period of four weeks in timed writings in...