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

Weather

For Teachers 5th - 7th
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...
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

Gummy Bear Math

For Teachers 1st
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,...
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

Temperature High and Lows

For Teachers 5th - 8th
Students gather high and low temperature readings through email. In this temperature graphing lesson, students use a spreadsheet to input data for a graph. students interpret the graphs to compare and contrast the data from different...
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

Twelve Days of Christmas

For Teachers 6th - 8th
Young scholars 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

The Hot Dog Stand

For Teachers 6th - 8th
Students run a computer simulation. They collect data as they work and use the data to create an annual report for their business. Several different simulations could be used for this project. It is desirable for students to do this...
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

Journalism

For Teachers 7th - 10th
Learners insert raw data about Ad sales into an Excel chart. They use raw data in a letter to local businesses by using the Mail Merge program. They represent data using tables and graphs.
Lesson Plan
Curated OER

Is the Hudson River Too Salty to Drink?

For Teachers 6th - 9th
Students explore reasons for varied salinity in bodies of water. In this geographical inquiry lesson plan, students use a variety of visual and written information including maps, data tables, and graphs, to form a hypothesis as to why...
Lesson Plan
Curated OER

Fly Away With Averages

For Teachers 3rd - 5th
Students study mean, median, and mode. They construct paper airplanes and test them to see how far they fly. They measure the distance and then find the averages of their throws. They use spreadsheet software to record the data in a...
Lesson Plan
Curated OER

Have I Been Hacked?

For Teachers 6th - 12th
Students investigate how effective SNEAK strategies are in detecting hackers. In this technology lesson, students explain the ethical issues about hacking. They graph and analyze their experimental results.
Lesson Plan
Curated OER

Don't Settle for a Byte... Get the Megabyte on Technology

For Teachers 4th - 12th
Students use word processing, presentation, and spreadsheet software. In this multi-day computer software usage lesson, students complete a research project that requires the use of a word processor, Excel, FrontPage, and PowerPoint to...
Lesson Plan
Curated OER

Texas Regions and Native Americans of Texas

For Teachers 4th
Fourth graders research to find the regions of Texas.  In this technology lesson, 4th graders create a Kid Pix project showing the location of various regions of Texas.  Students show where in those regions Native American...
eBook
Khan Academy

Khan Academy: Representing Graphs

For Students 9th - 10th
There are several ways to represent graphs, each with its advantages and disadvantages. Some situations, or algorithms that we want to run with graphs as input, call for one representation, and others call for a different representation....