Howard Hughes Medical Institute
Spreadsheet Tutorial 1: Formulae, Functions, and Averages
Spread your knowledge of spreadsheets. The first of five tutorials in the Spreadsheet Data Analysis unit introduces the basics of spreadsheets. It shows future data analysts how to organize and format tables, and how to use functions to...
Earth Watch Institute
Entering Local Groundhog Data in an Excel Spreadsheet
Here is a cross-curricular ecology and technology lesson; your learners create spreadsheets depicting the location and number of groundhog dens in a local park. They research groundhogs and analyze data about where the groundhog...
Curated OER
A Comparison Study of Water Vapor Data to Precipitation over North America
Students use NASA satellite data to compare water vapor over the United States. In this data analysis instructional activity students use an Excel spreadsheet to map their data.
Curated OER
Using a Spreadsheet to Understand Density
Students use density to identify what metal a gold colored weight is made of. They use a spreadsheet to graph the experimental density of common metals and compare the know densities to their calculated density of the known metal.
Curated OER
Lesson Plan Outline for Rainbow Science
Young scientists study light reflection and refraction as they determine the critical angle, the rainbow angle, and color separation in rainbows. Teams record the data they collect in a shared spreadsheet and discuss results with the class.
Curated OER
Student News And Weather Channel
Fabulous! Your 5th graders should love this project. As an ongoing lesson throughout the year students use temperature probes to record outside temperature and then document their data using spreadsheets. They use their weather data and...
Curated OER
Graphing Data from the Chemistry Laboratory
High schoolers graph and analyze data using a spreadsheet.
Curated OER
Measuring Rainfall and Relationships Between pH, Alkalinity and Suspended Solids in the Pago River
Eleventh graders test the pH and alkalinity of Pago River. In this ecology lesson, 11th graders collect data and use spreadsheet to graph results. They analyze and share their findings with the class.
California Academy of Science
Optimal and Sustainable: Renewable Energy Revamp
More than 100 cities around the world have shifted from fossil fuels to renewable energy sources. Scholars investigate a city wanting to make this switch, but needs help determining how to make the shift. Groups consider all options,...
Curated OER
Global Warming Statistics
Students research real-time and historic temperature data of U.S. and world locations, and analyze the data using mean, median, and mode averages. They graph the data and draw conclusions by analyzing the data. A spreadsheet is used to...
Curated OER
Seeing What You Cannot See--RADAR
Student imitate mapping the ocean floor using the basic concepts of radar. Then they explain what radar is and how it workds. All of their measurements are recorded on a data sheet. Then the data is entered into a spreadsheet program. A...
Curated OER
Quick Concept Demonstrations
Students research the nervous system. Demonstrations on how to pick up keyed information in text is shown daily and weekly. Reviewed for content is Nerve Impulse, Polarization and Depolarization and perception. A spreadsheet will graph...
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
Fabulous Fossils
Seventh graders investigate how fossils are formed and discuss how scientists determine the appearance of ancient plants and animals. They make fossils of everyday objects for others to identify. They make spreadsheets to display fossil...
Curated OER
Eyes on the Estuaries
Students study estuaries and compare several ones in the U.S. In this estuary instructional activity students interpret data and compare the distribution of different species.
Curated OER
Predicting Monthly Precipitation
Students should log onto, and collect data from, a specific site on the Internet. They average and compare the data using the Excel spreadsheet program, make predictions from their data, and determine the percent error of their predictions.
Curated OER
Comparing Weather Conditions
Young scholars 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.
Curated OER
Have Fun With Technical Report Writing
Students use Clarisworks Word Processing and Spreadsheet, Quick-Take Camera and Software, and produce a publishable technical paper.
Curated OER
How to Make a Chili Dog
Students practice sequencing skills. They discuss what makes a hotdog and the proper sequence for performing the task. Using computer technology, students create a multimedia show that deomonstrates the basic directions for making a...
Curated OER
A RealSim Surface Look at Descriptive Statistics
Learners explore the concepts of mean and variance. They observe properties of materials to their basic atomic or molecular structure. Students use spreadsheet software to record, tabulate and analyze collected information.
Curated OER
Investigating Properties of Water: Temperature
Investigate how temperature affects the density of water and stratification that occurs in bodies of water when temperatures vary. Water of differing temperatures is given different colors to see the layers that form. The lesson is meant...
Curated OER
Teaching About the Properties of Water
Students use video, Internet research, graphs and tables, worksheets and hands-on experiments to investigate the properties of water in a lake environment. They work under direction or through an inquiry process.
Curated OER
It's In The Chocolate Chips
Students investigate which brand of chocolate chip cookies contains the most chocolate. They analyze and compare data using Microsoft Word and Microsoft Excel. They communicate the results with Microsoft PowerPoint.
Curated OER
Teaching about Data Interpretation
Students explore a variety of relevant lake water chemistry questions, compose responses, and present their results in a poster format. They, in pairs, answer questions about lake chemistry which are imbedded in this plan.