Curated OER
Flame Test
Students conduct a flame test on different substances. In this chemistry lesson, students predict the element present based on the color emitted during the flame test. They explain how different elements produce different colors.
Curated OER
Chemical Changes by Gems
Seventh graders observe that heat is produced when two substances are combined. They brainstorm how, and then experiment to find out which of two chemicals created the heat.
Curated OER
Flip a Coin
Students are introduced to the concept of probability. In groups, they make a prediction about how many times a coin might show heads or tails when flipped. They carry out the experiment and record their results to compare it to their...
Curated OER
Radioactive Decay/Half Life
Students demonstrate radioactive decay using candy corns. In this Physics lesson, students make predictions, collect data and form conclusions about patterns in radioactive decay.
Curated OER
Sea Floor Spreading II
Students import ocean bathymetry data from text files. They then graph these observations along with model predictions to assess the model's ability to simulate observed topographic features of the North Atlantic. Students use Excel to...
Curated OER
Power In The Wind
Middle schoolers experiment designing graphs of selected readings from the Nebraska sites from the Power in the Wind study. They choose whether or not to put their data in a spreadsheet program to make a computer-generated graph or to...
Curated OER
Composting
Eighth graders collect data from Bottle Biology compost columns and record using Excel spreadsheet.
Curated OER
Scavenger Hunt
Students collect data about lighting conditions around a room using a light sensor and RCX. They use software to upload and analyze the data in order to draw conclusions about light intensity in the room.
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
The Ghost of Populations Past
Students study population distribution and survivorship curves by collecting data regarding age of death of humans from either tombstones, newspapers, or other community resources. Students analyze data by creating graphs and population...
Curated OER
Phenomenal Weather-Related Statistics
Eighth graders research, collect and interpret data about weather statistics. They record that data on spreadsheets. they create Powerpoint presentations on their individual or group research.
Curated OER
Comparing Amount of Rainfall in Different Geographical Areas
Students construct rain gauges and use them to log rainfall in their school zone, local city, and region and then compare and discuss them by plotting this information.
Curated OER
TV Viewing
Students test a hypothesis to see if there is a direct correlation between number of hours of TV viewing and academic grade. They collect and compile data to enter on a spreadsheet and create a word processing document supporting their...
Curated OER
Calendar & Weather Book
Second graders track weather patterns through the school year. They take daily readings and record them in a weather book.
Curated OER
Pumped Up Gas Prices
Young scholars 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.
Curated OER
Weather for Health
Ninth graders encounter various types of numerical information (represented in multiple ways), much of which is abstract and difficult to comprehend. In this lesson plan, 9th graders will convert given information into bar graphs. In the...
Curated OER
Inventors Unit Survey
Students develop and conduct a survey for their inventors unit. They create a five question survey and tally the survey results, and create a graph using Microsoft Word and Graph Club 2.0.
Curated OER
Sea Floor Spreading II
Students import ocean bathymetry data form either the topex web site or text files. They then graph these observations along with model predictions to assess the model's ability to sumulate the observed topographic features of the North...
Curated OER
Teaching about Diel Temperature Variation
Young scholars explore temperature variation in lakes and deal with the data.
Curated OER
Weather... Or Not
Students observe and discuss the local weather patterns, researching cloud types and weather patterns for cities on the same latitude on the Internet. They record the data for 6-8 weeks on a graph, and make weather predictions for their...
Curated OER
Water Flow Through Local Soils
Middle schoolers examine the relationship between particle size and rate of water flow through soil. They collect soil samples, make predictions, conduct a water flow experiment, analyze the data, and answer conclusion questions.
Curated OER
Thank You... Thomas Edison!
Students investigate the life of Thomas Edison. They research how he made a difference. They understand that accurate data collection is important for math. They create a chart using spreadsheet data.
Curated OER
Technology Integration Lesson Plan: Music Database
Eighth graders gather information on fifteen of their favorite songs, create database with fields representing different attributes, explore and sort their databases, and create charts and graphs showing amount of play time vs. popularity.
Curated OER
Virtual Field Trip
Students calculate gasoline cost per mile on a virtual field trip. They calculate the gasoline costs and travel time for each of the 2 routes, and record on a data sheet. They use Excel to create data tables for mileage, gasoline...