+
Lesson Plan
Curated OER

Flavorful Spreadsheets

For Teachers 4th - 8th
Students create a spreadsheet which includes a bar graph. They sort and classify information and use the average function on a spreadsheet. They research Skittles candy and summarize their findings on a spreadsheet.
+
Lesson Plan
Curated OER

The Hundred Penny Box

For Teachers 6th
Sixth graders research payload specialists and see how many are men and how many are women and what countries they come from. They then create an excel spreadsheet to reflect data they found and must have two graphs for interpretation.
+
Lesson Plan
Curated OER

Scale Basketball

For Teachers 7th - 8th
Students discuss scale diagrams and maps as well as the use of spreadsheets to find the best scale to use in a model before practicing scale and ratio problems on their own.
+
Lesson Plan
Curated OER

Computer Technology- Spreadsheets

For Teachers 7th - 9th
Learners will be learning about how to create a budget. Give them the worksheet and have the students come up with how many items they will need for their Thanksgiving party and how much they think the items are worth. When they have...
+
Lesson Plan
Curated OER

Graphing With a Spreadsheet

For Teachers 4th
Fourth graders review how to create bar, line and circle graphs. Using jelly beans, they collect data and present it in a bar graph form. They enter the same data into a spreadsheet and watch as the program creates the same graph. They...
+
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

Tourism in London

For Teachers 5th - 8th
Learners discuss the tourist attractions that are in London. They examine how data can be manipulated by completing a worksheet. They plan a trip to a London attraction after conducting Internet research.
+
Lesson Plan
Curated OER

Home, Home in the City

For Teachers 7th - 9th
Students create a spreadsheet that organizes housing information in the Houston area. They write a formula to determine the average price of homes in the Houston area.
+
Lesson Plan
Curated OER

Calculating & Graphing Using a Spreadsheet

For Teachers 11th - 12th
Young scholars use the lab apparatus to calculate the average velocity and average acceleration at several points and record the data. They use the spreadsheets to plot distance vs. time, velocity vs. time and acceleration vs. time graphs.
+
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...
+
Lesson Plan
Curated OER

Best Buy!!

For Teachers 6th - 8th
Young scholars use newspaper ads to determine the best buy on products. They enter the information into a spreadsheet and then use word processing software to complete a written analysis, complete with graphs.
+
Lesson Plan
Curated OER

Probability Using M & M's

For Teachers 6th - 8th
Students develop an understanding of probability by sorting bags of M & M's by color and recording the results in percents. The data is entered onto a spreasdsheet and graphed.
+
Lesson Plan
Curated OER

Chart/Graph

For Teachers 3rd - 8th
Students create a class survey, place the data in a spreadsheet and graph the information.
+
Lesson Plan
Curated OER

Home on the Biome

For Teachers 5th
Fifth graders study six major biomes, graph temperature and rainfall, and present their findings to the class.
+
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

Graphing With Second Graders

For Teachers 2nd
Second graders sort M & M's and then enter the data into a spreadsheet in order to create a simple graph. After printing the spreadsheet generated graph, have students compare the printed graph with their paper graph.
+
Lesson Plan
Curated OER

A Self Directed Inquiry into the Identification of Unknowns

For Teachers 9th - 12th
Students gain experience in designing an experiment and use logic in selecting specific tests for unknowns. Students recognize the use of spreadsheets in helping one to make clear comparisons.
+
Lesson Plan
Curated OER

Spreadsheets in Science

For Teachers 4th
Fourth graders create spreadsheets, explore patterns and make predictions based on the information. They select the appropriate graph to display the spreadsheet data. They search and sort prepared data bases to gain knowledge for...