Lesson Plan
Curated OER

Creating a Spreadsheet and Graph

For Teachers 4th - 5th
Students create graphs in Excel.  In this spreadsheet lesson, students input data into spreadsheet cells then use the graphing feature of the Excel program to produce colorful graphs of the data.  The directions to create the...
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

First Grade Shoe Sizes

For Teachers 3rd
Third graders collect shoe size data from classmates in their room and another third grade. They predict what the most common shoe size will be. They place the data in an spreadsheet on the computer. They design a graph using the...
Lesson Plan
Curated OER

M & M Madness

For Teachers 1st
M&M's are always a great manipulative to use when teaching math. In this graphing lesson plan, learners predict how many of each color of M & M's there are. They count up each color and plug the data into a graph using the...
Lesson Plan
Curated OER

Graph Lesson

For Teachers 1st
First graders collect data on different eye colors of each student in their classroom. They input the data that they gathered in an Excel spreadsheet and then create a graph in Excel.
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

Graphing Favorite Fruit

For Teachers 3rd
Third graders take poll and sort data, enter the data to create a spreadsheet and create bar and pie graphs.
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

Time Management

For Teachers 6th - 9th
Students plot activities for a 24 hour day. They record their information on a spread sheet program. Students list categories they use and write equations for cells that add cells of each category together. Students create a pie chart of...
Lesson Plan
Curated OER

Unit 2: Lesson 7

For Teachers 6th - 8th
Students are introduced to spreadsheets. They conduct a survey of television viewing time of different shows based on different age categories. Students work in small groups. They collect, data and interpret the data from a survey.
Lesson Plan
Curated OER

Just Graph It!

For Teachers 4th
Fourth graders evaluate various graphs for the best way to reflect statistical data. They use a spreadsheet to organize data and generate varied graphic representations. They select the graph they feel best shows their results.
Lesson Plan
Curated OER

Timed Multiplication Test Graphs

For Teachers 8th - 10th
Students use the tools of data analysis for managing information. They solve problems by generating, collecting, organizing, displaying histograms on bar graphs, circle graphs, line graphs, pictographs and charts. Students determine...
Lesson Plan
Curated OER

Graph It!

For Teachers 1st
First graders use organized data to construct real object graphs, picture graphs, and bar-type 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

How Long...?

For Teachers 3rd - 5th
Students explore measurement. They use appropriate units of measurement for different sized objects. Students collect their data and enter it into an Excel data base. They graph their findings and analyze their outcomes.
Lesson Plan
Curated OER

Using a Statistical Procedure To Search A Database For Out of the Ordinary Values

For Teachers 7th - 10th
Students develop a spreadsheet containing formulas and find summaries for them.  For this investigative lesson students choose a topic, investigate it and use MS Excel to sort data. 
Lesson Plan
Curated OER

Toy Dissection Graph

For Teachers 3rd - 6th
Students explore simple machines and how they are made. They examine the parts of the simple machine and collect information about its parts. Using Excel, students create circle and bar graphs from the collected data.
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

And the Survey Says...

For Teachers 7th - 8th
Students use technology to input, retrieve, organize, manipulate, evaluate, and communicate information; apply appropriate technologies to critical thinking, creative expression, and decision-making skills. They collect and explore data...
Lesson Plan
Curated OER

Body Part Measurements

For Teachers 2nd
Second graders participate in a review of how to use rulers and yard sticks while collecting measurement information. They measure assigned body parts and chart the data on collection sheets. They make a spreadsheet with the information...
Lesson Plan
Curated OER

Are We Alone

For Teachers 7th
Seventh graders collect/analyze data and draw conclusions; support reasoning by using a variety of evidence; construct logical arguments; access information at remote sites using telecommunications; apply the concept of percent;...
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

And the Winner Is...

For Teachers 3rd
Third graders participate in an election project. They collect data to create a spreadsheet from which a graph is generated.