Curated OER
The Viewing Tube
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...
Curated OER
Louisville's Best Field Day Park
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...
Curated OER
Moving Day!
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...
Curated OER
Buying a Car
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...
Curated OER
Hopes and Dreams: A Spreadsheet Lesson Using Excel
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.
Curated OER
Super Spreadsheets
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.
Curated OER
What's Your Line?
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.
Curated OER
It's 'ELEMENT' ary
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.
Curated OER
Spreadsheet Project: Planning a Party
Students create a spreadsheet and stay within a budget as they plan a class party for the next holiday.
Curated OER
Using Computers to Produce Spreadsheets and Bar Graphs
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.
Curated OER
Topic 6: Evaluating and Presenting Results
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.
Curated OER
Computer Science: Pendulum
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...
Curated OER
The Transformer
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...
Curated OER
World Education Statistics
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...
Curated OER
Spreadsheet Graphs
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...
Curated OER
Twelve Days of Christmas
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...
Curated OER
The Hundred Penny Box
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.
Curated OER
Home on the Biome
Fifth graders study six major biomes, graph temperature and rainfall, and present their findings to the class.
Curated OER
Graphing With Second Graders
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.
Curated OER
Spreadsheets in Science
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...