+
Lesson Plan
Curated OER

The Viewing Tube

For Teachers 5th - 8th
Looking for an excellent lesson that incorporates math, science, and technology? Groups of three students use a viewing tube to perform an experiment, and discover how to organize their data into an Excel spreadsheet.  This is a...
+
Lesson Plan
Curated OER

Louisville's Best Field Day Park

For Teachers 7th - 12th
Young scholars create a survey to hand out to determine the best field day park. Using their local area, they select five parks, if possible, that meet the criteria and calculate the distance and estimated time travel. They use this...
+
Lesson Plan
Curated OER

Moving Day!

For Teachers 8th
Eighth graders continue their geometry unit by focusing on volume. Using data, they create a spreadsheet, estimate and calculate volume. They solve real-life problems and round their answers to the hundredths place. They also practice...
+
Lesson Plan
Curated OER

Buying a Car

For Teachers 8th
Eighth graders create spreadsheets to calculate payments. They create a list of items they would like to purchase that require monthly payments. They simulate buying a car and create a spreadsheet to determine the amount of the monthly...
+
Lesson Plan
Curated OER

Hopes and Dreams: A Spreadsheet Lesson Using Excel

For Teachers 4th
Fourth graders read "The Far Away Drawer" by Harriet Diller and discuss the story as a class. After discussion, 4th graders create a t-shirt GLYPH about their hopes and dreams,share their information with the class and create spreadsheets.
+
Lesson Plan
Curated OER

Super Spreadsheets

For Teachers 6th - 8th
Students develop a spreadsheet containing statistical data. They describe and interpret the data to make conclusions. They review the differences between an unorganized spreadsheet verses an organized one.
+
Lesson Plan
Curated OER

What's Your Line?

For Teachers 5th
Fifth graders collect temperature readings over a period of time, enter the information into a spreadsheet and choose the appropriate graph to display the results.
+
Lesson Plan
Curated OER

It's 'ELEMENT' ary

For Teachers 6th - 8th
Pupils, using a Web site about the periodic table of elements, create spreadsheets representing elements and their properties. They also create graphs that compare the physical properties of the elements.
+
Lesson Plan
Curated OER

Spreadsheet Project: Planning a Party

For Teachers 9th - 12th
Students create a spreadsheet and stay within a budget as they plan a class party for the next holiday.
+
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

Topic 6: Evaluating and Presenting Results

For Teachers 8th - 9th
Learners construct spreadsheets from raw data. In this spreadsheet construction lesson, students compile data into Microsoft Excel. Learners familiarize themselves with entering and presenting data in a spreadsheet.
+
Lesson Plan
Curated OER

Computer Science: Pendulum

For Teachers 7th - 9th
Students investigate the basic properties of pendulums as a function of spreadsheets. Working in groups, they measure the period for a pendulum at six different lengths and record the results. They prepare a file using Microsoft Excel...
+
Lesson Plan
Curated OER

The Transformer

For Teachers 4th
Fourth graders practice measuring different objects in inches. Individually, they estimate the length of the same object in centimeters and then calculate the actual length. They compare and contrast their estimate to the actual length...
+
Lesson Plan
Curated OER

World Education Statistics

For Teachers 9th - 12th
Students use a spreadsheet from The Digest of Education Statistics and convert the statistics to percentages, and create a chart of their new data. Students discuss their findings about the disparities in educational spending among...
+
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

Twelve Days of Christmas

For Teachers 6th - 8th
Middle schoolers 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...
+
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

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

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

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...