Curated OER
A Comparison Study of Water Vapor Data to Precipitation over North America
Learners use NASA satellite data to compare water vapor over the United States. In this data analysis activity students use an Excel spreadsheet to map their data.
Curated OER
Cross Cultural Transportation and Resources Exchange
Students examine various modes of transportation. They explore regional transportation options and discover options available in their area. Students survey types of transportation people use in their area. Using spreadsheet data,...
Curated OER
Using Electronic Manipulatives in Multiplication
Factor polynomials using electronic manipulatives. Your class will create a spreadsheet in excel and use it to multiply and perform basic operations and solve problems correctly. They create a visual to go along with each multiplication...
Curated OER
Three Squirrels and a Pile of Nuts
Students solve story problems using a spreadsheet in combination with various problem-solving strategies. Working in teams of three, students create attempt to solve a story problem using three different methods; using manipulative,...
Curated OER
Managing a Checkbook
How do grown ups do it? Teach your upper graders the ins and outs of personal finance by having them use their algebra skills to balance a checkbook. They examine the financial side of math, set up a checking account, and balance their...
Curated OER
Fitness plan: number 3
Students monitor their fitness levels for six weeks of their P.E. course through the use of an Excel spreadsheet. They also research the obesity epidemic among youth in the U.S. today, presenting their findings to the class. This lesson...
Curated OER
Application and Modeling of Standard Deviation
The first activity in this resource has learners computing the mean and standard deviation of two different data sets and drawing conclusions based on their results. The second activity has them using a dice-rolling simulation to...
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
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
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
Body Proportion
Fourth graders measure the height and arm span of various classmates. They use a spreadsheet to design a graph that shows the class measurements from tallest to shortest in metric and standard systems.
Curated OER
Education for Global Peace
Students survey the class and graph the results. In this graphing and data collection lesson, students conduct a survey to see where their shirts were produced. Individuals use software to graph the results and create a written...
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
Comparing Weather Conditions
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.
Curated OER
Around and Around
Young scholars 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...
Curated OER
A RealSim Surface Look at Descriptive Statistics
Students 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...
National Council of Teachers of Mathematics
National Debt and Wars
Take a functional approach to the national debt. Learners collect information about the national debt by decade and plot the data. They determine whether an exponential curve is a good fit for the data by comparing the percent changes...
Curated OER
An Introduction to Functions
Students investigate the growth and decay of an exponential function. In this algebra lesson plan, students apply properties of exponent solve problems. They identify any patterns they see in the graphs.
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
Weather Or Not
Students use the internet to find pen pals to share in their weather experiment. Individually, they research the high and low temperatures for cities within the United States and email the results to their pen pal. They also develop a...
Curated OER
Cell Size Changes
High schoolers examine the behavior of living cells treated with different types of stimuli. They watch an online movie, examine wet mount slides under a microscope, take an online quiz, and analyze data.