Curated OER
Which Color Will You Pick?
Students create a spreadsheet to chart the different colors found in a package of M&M's or Skittles. They collect data, create appropriate charts, and use percentages to describe quantities.
Curated OER
The People Behind the Numbers
Tenth graders brainstorm potential definitions for "developed" and "developing" countries. They work in groups of four and research using Web sites listed to find information about their country then they create a spreadsheet which...
Curated OER
Pumped Up Gas Prices
Learners calculate gas prices. In this transportation instructional activity, 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...
Curated OER
Heat of an Unknown Metal
Eighth graders complete labs to find the specific heat of many different types of substances, and use characteristic property to identify an unknown metal. CBL be used to determine energy lost or gained, and students complete a...
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
Acceleration, Drag, Gravity, Motion, Forces, and Friction
Eighth graders build and run mousetrap cars in order to measure distance, time, and mass for their cars. They use these measurements to calculate average speed and kinetic energy, then create a slide show to visually explain how the car...
Curated OER
Why Would I Owe My Soul to the Company Store?
Sixth graders listen to "Sixteen Tons" by Tennessee Ernie Ford and discuss what it means to owe one's soul to a store. In this mathematics instructional activity, 6th graders determine what a miner's income was minus his expenses...
Curated OER
How Do Plants Grow?
Young scholars investigate plant growth. In this plant growth lesson, students investigate what would happen to plants if they did not have water and sunlight. Young scholars conduct experiments to determine what plants need. Students...
Curated OER
Comparing Amount of Rainfall in Different Geographical Areas
Third graders create rain gauges and take them home. Individually, they record the rainfall amounts at all of their homes over a 2-week period and then bring the data back to class so they can compare the different amounts of rainfall...
Curated OER
Put Your Heart Into It
First graders sort Valentine candies according to kind. Data is inserted into a spreadsheet and displayed in various graphic formats.
Curated OER
Running a Business
Students discuss spreadsheets and how they work. They then imagine they are owners of a store, determine twenty items that they would sell, and create spreadsheets to record amounts of each item sold in a two-week period. After entering...
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
Around and Around
Students create a spreadsheet to record information about circular objects. They measure and record information from a variety of objects. Students calculate the ratio of the circumference to the diameter of each object. They find the...
Curated OER
Your Just Desserts
Students write letters to town officials and local businesses asking for favorite dessert recipes. They tabulate their responses in a spreadsheet. Students turn their survey results into colorful graphs.
Curated OER
Ladybugs in the Garden
Fifth graders estimate the size a population (ecosystems) Students make a chart from information collected then create a graph (line or bar) from this information. Students do a lesson where they observed, examine, and record data...
Curated OER
Home, Home in the City
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.
Curated OER
Careers
Eighth graders research careers on the computer to determine which career they are interested in. They create a spreadsheet using the Excel program and calculate the budget for their desired lifestyle and determine if this income is...
Curated OER
Tallahassee Project
Sixth graders gather information from technological sources such as TV, radio, and Internet as well as from newspapers and maps and produce a final printed report. They use the data to create a spreadsheet and read a Florida state...
Curated OER
Sweet Car Dreams
Students rebuild two different makes of cars. They calculate the cost of rebuilding the car. They create a spreadsheet to track their progress and costs.
Curated OER
Computer Science: Pendulum
Learners 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
Create A Business and A Life
Students look through a phone book and pick a business they think they would enjoy. They brainstorm ideas about the needs of a business. They set their prices to payback their investment into the new business.
Curated OER
Doughnuts to $ Database
Fifth graders are selling Krispy Kreme doughnuts to raise money for their overnight camping trip. They use a database to set to keep track of and record additions to their daily sales. Students then follow the step by step directions to...
Curated OER
Excel Lesson Plan Coin Statistics
Second graders determine the difference between making a prediction and determining actual information. They design a spreadsheet for a coin flipping activity on which they include their predictions and what actual happens when they flip...
Curated OER
Make Your Health Count
Students write down the meals they have eaten in the past few days and then research the calorie and fat content of at least 5 of the food items. They create a poster with the information they found and then put that information into a...