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

Basic Excel

For Teachers 1st - 4th
Students explore basic Excel spreadsheets.  For 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

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

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

Excel temperature Graphs

For Teachers 4th - 6th
Students gather data about the weather in Nome, Alaska. In this Nome Temperature lesson plan, students create an excel graph to explore the weather trends in Nome.  Students will find the average weather and add a trend line to...
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

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.