Curated OER
Appalachia: Physical Fitness
Students plan a family fitness outing. In this physical education lesson, students will research possible physical activities which might be completed by a family during a daily-long outing in the Appalachian area. Students will...
Curated OER
The Hot Dog Stand - An Annual Report
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...
Curated OER
Look Into My Eyes!
Students explore collecting, analyzing, and graphing information. They collect data on the various eye colors of their classmates. Students tally the results and create a graph.
Curated OER
Influence of Beauty, The Beauty of Influence
Tenth graders explore the influence of art on modern societies. Through the internet, they assess paintings of advertisements for commercial products and social-political beliefs. Using spreadsheet software, the class compares and...
Foundation for Water & Energy Education
How Can a Dam Affect a River? Activity B
Second in a pair of activities, young ecologists continue to examine the food pyramid of a freshwater ecosystem. They take a look at the food pyramid drawn in Activity A and consider what would happen if a reservoir was created on the...
Curated OER
Paper Tower Challenge
Student explore the challenge of building a tower using paper. They build their tower using paper and record the height of their tower. Young scholars collect and record the heights of other towers and use that data to create a spreadsheet.
Curated OER
Color Matters
Students create a spreadsheet to chart favorite colors, then collect data, create appropriate charts, and use percentages to describe quantities.
Curated OER
Texas Weather Report
Students use provided links to observe selected weather sites and collect temperature and precipitation data for listed cities. They enter the information onto their spreadsheet. Students study maps of the Texas natural reagions,...
Curated OER
What Colors Are Your Skittles?
Students record the numbers of each color in their own Skittles. They compare their results with their partner. Students create a spreadsheet to chart the different colors found in a package of Skittles. They create a PowerPoint...
Curated OER
Graphing
Fifth graders create graphs based on climate in South Carolina. They read and interpret information in a chart and construct a graphy from the information in the chart. They create a spreadsheet using Excel and publish 2 graphs.
Curated OER
Escape The Hangman
Seventh graders investigate the concept of probability. They use the game of hangman to create engagement and context for conducting the lesson. They create a spreadsheet with data that is given. Students make predictions based on data.
Curated OER
Calculating Orbital Speeds
Students are introduced to the regularities of planetary motion. They create a spreadsheet to calculate the speed of any orbiting body at apogee and perigee. Students then use the spreadsheet to compare the speeds of planets, moons,...
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
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.
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 instructional activity, students research population statistics and create spreadsheets that compare population to the number of Congress...
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 lesson, 6th graders determine what a miner's income was minus his expenses graphing findings in a...
Curated OER
How Do Plants Grow?
Students investigate plant growth. In this plant growth lesson plan, students investigate what would happen to plants if they did not have water and sunlight. Students conduct experiments to determine what plants need. Students create a...
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
Young scholars 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.