+
Lesson Plan
Curated OER

Pumped Up Gas Prices

For Teachers 4th - 12th
Students spend one month keeping track of the mileage and gasoline amounts they or their family has used. Information is entered into a spreadsheet to help calculate the average gas prices over time.
+
Lesson Plan
Curated OER

Finding Mean, Mode and Median in the Computer Lab

For Teachers 5th - 12th
Students create spreadsheets which will display and figure mean, median, and mode of a set of numbers.
+
Lesson Plan
Curated OER

Comparing Weather Conditions

For Teachers 4th - 5th
Students conduct research on temperature, wind speed and weather conditions from a variety of areas. They organize their findings on worksheets and spreadsheets and discuss various examples of databases.
+
Lesson Plan
Curated OER

Toy Planet

For Teachers 4th - 6th
Students design a toy store, supply it with merchandise (on paper) and create advertisements. They also manage the store's debits and credits by using a spreadsheet. They consider how to promote the sale of their merchandise.
+
Lesson Plan
Curated OER

Space Presents Problems

For Teachers 6th - 8th
Students use the internet to research problems related to space. They complete a questionaire to direct their research before beginning. They create a database of moon and planet characteristics.
+
Lesson Plan
Curated OER

Fluctuations in the Price of Oil

For Teachers 11th - Higher Ed
Students examine the fluctuating gas prices and the effect it has on the Canadian economy by reviewing an online database that contains information on the retail price of gas for Canada's largest cities.
+
Lesson Plan
Curated OER

Our Animal Friends

For Teachers 4th - 8th
Students use the internet to find information pertaining to the benefits of pets. They list their results on a database. They find and record data on the percent of households that own pets as well as the top six species of pets. Once...
+
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

How Many M&M's

For Teachers 4th - 6th
Students explore sets and collections. Students find the colors of M&M's and the amount of M&M's each student has. They organize this information into an Excel spreadsheet. Students use the chart wizard to create a graph.
+
Lesson Plan
Curated OER

Technology as a Tool of Science

For Teachers 9th - 12th
Students monitor streams, take stream surveys, collect chemical and macro-invertebrate and stream discharge data. Using a digital camera, students observe the percentage of various types of vegetation on the flood plan, riparian area and...
+
Lesson Plan
Curated OER

Marsville

For Teachers 6th
Sixth graders use the Internet and other media to locate and collect information about Mars and build a database of information. They listen and participate in demonstrations presented by Eglin Air Force Base professionals. They then are...
+
Lesson Plan
Curated OER

Behold the Wonder of Creation

For Teachers 5th
Fifth graders explore and become familiar with U.S. National Parks. They research several parks and compile the information they find into a spreadsheet. They plan and write a report/booklet about one of the U.S. National parks.
+
Lesson Plan
Curated OER

The Breathtaking Nature of the Urban Explosion, Part 2

For Teachers 9th - 12th
Young scholars explore ozone levels. They measure the concentrations of ground-level ozone in the atmosphere. Students observe changes in the concentrations of ozone over time. Young scholars complete a data sheet to record ozone...
+
Lesson Plan
Curated OER

Pumped Up Gas Prices

For Teachers 3rd - 6th
Students calculate gas prices. In this transportation lesson, students tally the mileage and gas costs of their car for one months. They figure out how much was spent on gas and create a graph showing average gas prices over time. 
+
Lesson Plan
Curated OER

The Hot Dog Stand - An Annual Report

For Teachers 6th - 8th
Students run a computer simulation and collect data as they work and use the data to create an annual report for their business. It is desirable for students to do this project individually, but it could be done as a class using a large...
+
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

Atlatl Lessons Grade 4-12

For Teachers 4th - 12th
Students experiment with velocity, ratios, and rates. In this data management lesson, students throw a dart with and without using an atlatl and collect and record various data. Students construct ratios based on the data and determine...
+
Lesson Plan
Curated OER

Building A Portfolio

For Teachers K - 4th
Learners gather images that are part of portfolio to be shared throughout the course of one school year. They complete written reflections based upon the images that are attained. The primary sources for the images is using a digital...
+
Lesson Plan
Curated OER

Pizza! Pizza!

For Teachers 3rd
Third graders tally, sort, and organize pizza orders from monthly school sales. They create an advertising campaign to promote the School Pizza Sale, record the data in graph form, compare and contrast the tallies throughout the year,...
+
Lesson Plan
Space Awareness

The Climate in Numbers and Graphs

For Teachers 6th - 10th Standards
Weather versus climate: weather relates to short time periods while climate averages the weather of a period of many years. Scholars learn about average temperature and precipitation in various climate zones and then apply statistics...
+
Interactive
Curated OER

Wetland Inventory and Map Project

For Students 6th - 10th
In this wetlands inventory and map project activity, students do research on the wetlands and complete a map project about it. Students follow 6 sets of directions with Internet links.
+
Lesson Plan
Curated OER

Polling and Statistics

For Teachers 8th - 10th
Learners investigate polling. In this statistics lesson, students collect data-on polling and graph their data on a coordinate plane. They identify biased and non-biased polling.
+
Lesson Plan
Curated OER

Multiplication Tables Using Microsoft Excel

For Teachers 8th
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.
+
Lesson Plan
Curated OER

What Color Are Your Skittles?

For Teachers 7th - 10th
Students create spreadsheets and manipulate data. They collect data, create appropriate graphs and use percentages to describe quantities. Students compare and contrast data. They use spreadsheets to generate a pie chart.