Curated OER
Weather, Weather, Everywhere!
Sixth graders collect weather data to compare temperatures around the world. Using the Internet, learners collect data, put it into spreadsheets, and analyze and graph the results. An interesting way to cover the topic of weather.
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
Solving Polynomial Equations
Students demonstrate how to use spreadsheets as a tool for analyzing, visualizing and solving mathematical problems. Students obtain fundamental grasp of cubic equations and other polynomial equations.
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
Multiplication Tables Using Microsoft Excel
Eighth graders are introduced to Microsoft Excel as a computer application software program. They create multiplication tables in Microsoft Excel. Students work in small groups. They discuss the $ (anchor) function in Microsoft Excel.
Curated OER
Super Spreadsheets
Young scholars discover information about each of the fifty states in the United States. In groups, they create a spreadsheet organizing the information to show to the class. They discover different ways to display the data and...
Curated OER
Electronic Spreadsheets & Iditarod 2000
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...
Curated OER
Life Through Time: The Heart of the Phanerozoic
Students gain a deeper understanding of geological time and the evolution of life on Earth. They use iMovie to tell a complex story of a discrete time period with narration and images.
Curated OER
Introduction to Spreadsheets
Sixth graders utilize Excel or other spreadsheet software to create both text and numerical valued columns to produce a Christmas or birthday wish list. They study the difference between text and numerical values for column use and...
Curated OER
Simple Bar Graphs Using Excel
Students create original survey questions, and develop a bar graph of the data on paper. They input the survey data using two variables onto an Excel bar graph spreadsheet.
Curated OER
Building Arrays Using Excel Spreadsheets
Students create arrays using Microsoft Excel. In this technology-based math instructional activity, students expand their knowledge of multiplication by creating arrays on the computer using a spreadsheet program such as Microsoft Excel.
Curated OER
Holiday Cards using Publisher
Learners create a holiday card using technology. In this technology instructional activity, students use Publisher templates to create a holiday card. Learners organize, design, and edit their card.
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...
Curated OER
Using Computer for Statistical Analysis
Students examine the use for spreadsheets in analyzing data. They make spreadsheets that display and calculate a given data set such as temperature change.
Curated OER
Calculating & Graphing Using a Spreadsheet
Students 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.
Curated OER
Flavorful Spreadsheets
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.
Curated OER
Graphically Speaking
Students discover the links between population and Congressional representation. In this government lesson, students research population statistics and create spreadsheets that compare population to the number of Congress members per state.
Curated OER
Fantasy Basketball
Learners play Fantasy Basketball in order to practice locating Internet information and using technology tools to display data; students demonstrate an understanding and use of graphing, probability, and statistics.
Curated OER
Income Levels & Social Class: Is It All About Cash?
Young scholars graph data and interpret that data after reading information about lifestyles and income levels. They calculate percentages, set up spreadsheets and calculate columnar data.
Curated OER
How Much Is It?
Learners explore foreign currencies. In this foreign currencies lesson, students simulate travel to another country and determine the value of the US dollar compared to other countries. Learners use a conversion table and search Internet...
Curated OER
Are You Here Today?
Students recognize their own name in print and the names of their classmates. They use one to one correspondence to determine who has not checked in, completed their field, and if absent indicate that on the form. Students tally the...
Curated OER
Let's Get Linear
Math whizzes utilize spreadsheets to examine linear modeling. They roll marbles down a ramp from three different heights and measure how far they roll. They use Excel to record their data and create a plot of their data.
Curated OER
Million Dollar House
Fourth graders use a combination of calculators and spread sheet software to furnish their own million dollar horse without going over the specified amount of a million. The goal being to create a house that came to the exact amount of...
Curated OER
Is That Your Final Answer?
This unit on integers includes a pre-test, a post-test, four spreadsheets, and links to an interactive web-site to support the learning of integer operations. Access to computers and the Internet are imperative to this unit. The lessons...