Curated OER
Credit Cards: The Good, the Bad, and the ugly
Students study how dangerous credit cards can be. They see why it is important to pay off credit card bills as soon as they can. They use MS Excel to display and understand the data. They fill out questions using the data from their...
Curated OER
What's Your Shoe Size? Linear Regression with MS Excel
Learners collect and analyze data. For this statistics lesson, pupils create a liner model of their data and analyze it using central tendencies. They find the linear regression using a spreadsheet.
Curated OER
What's Playing Tonight?
Young scholars collect data and visually represent it. They conduct a survey of favorite movies. Using a spreadsheet, students organize the data and create bar and circle graphs. Young scholars answer statistical questions regarding the...
Concord Consortium
Broken Spreadsheet II
Work in reverse with the product becoming the given. Using a spreadsheet image of the graph of a trigonometric function, young scholars investigate methods of creating spreadsheet data that results in the given graph. The catch? The data...
Concord Consortium
Flying High
Some planes are just more efficient than others. Young mathematicians use data on the number of seats, airborne speed, flight length, fuel consumption, and operating cost for airplanes to analyze their efficiency. They select and use...
Curated OER
What's Up With My Class
Students collect data about their class and they use Excel spreadsheet to display their tables and graphs about the class. They answer survey questions and collect their data. Students create a graph of their choice to display the...
American Institutes for Research
Digital Smiles
Explore metric measurement, recording data, and creating an electronic spreadsheet displaying results with your math class. Scholars will measure the length of their smiles, record the measurements, and represent the results on an...
Curated OER
Analyzing Discrete and Continuous Data in a Spreadsheet
You are what you eat! Your statisticians keep a log of what they eat from anywhere between a day to more than a week, keeping track of a variety of nutritional information using a spreadsheet. After analyzing their own data, individuals...
Curated OER
Graphing Iron Data
Learners apply a data set to create a graph show how iron ore impacts an ecosystem. They explain how the iron effects the distribution and abundance of phytoplankton in coastal ecosystems using spreadsheet software.
Curated OER
Data Lesson Vital Information
Students prepare and collect data and use excel and create a graph. They collect data about the number of pattern blocks that are put on tables. Students then record that data in Excel.
Curated OER
Bungee Jump Lab
Student apply linear relationships to the real world. They use Ken and Barbie dolls and experiment to find the line of best fit. They collect data, analyze data, and make predictions from it. The students also use Microsoft Power Point...
Curated OER
Data Handling
In this data handling worksheet, 6th graders solve and complete 4 various types of problems. First, they draw a bar chart to represent the information provided in the table shown. Then, students show beneath the table how to work out the...
Howard Hughes Medical Institute
Scientific Inquiry Using WildCam Gorongosa
How do scientists determine what questions to ask to meet their research goals? Help your class develop an inquiry mindset with a lesson based on studies in the Gorongosa National Park. Partners create their own research questions by...
Polar Trec
Ozone Data Comparison over the South Pole
Did you know the hole in the ozone is seasonal and filled by January every year? The instructional activity uses scientific measurements of the ozone over the South Pole to understand patterns. Scholars learn that the hole grew bigger...
Las Cumbres Observatory
Plotting an Asteroid Light Curve
Data can tell us a lot about celestial objects that are just too far away to study otherwise. Learners examine data on the brightness of an asteroid to predict its rotation rate. Graphing the data reveals a periodic pattern that allows...
Concord Consortium
Heights and Weights
Height is dependent on weight—or is it the other way around? Given data from a physicians handbook, individuals compare the height and weight of males and females at different areas. They calculate differences and ratios to assist with...
Las Cumbres Observatory
Plotting a Supernova Light curve
Supernovas burn for a short time but can give scientists extensive information about the universe. Learners analyze given data about the change in the light magnitude of a supernova. They look for patterns in the data and use them to...
Curated OER
Sea Level Trends ~ Ocean Front Property: An "Immerging" Market
Young oceanographers take a look at sea level data from several cities over a few centuries. They use the data to fuel a discussion about what kind of changes are taking place and the impact they are having on the coastal ecosystems....
Curated OER
Historical Population Changes in the US
Students conduct research on historical population changes in the U.S. They conduct Internet research on the Historical Census Data Browser, create a bar graph and data table using a spreadsheet program, and display and interpret their...
NASA
Space Shuttle Ascent: Mass vs. Time
Set the stage for groups of rocket scientists to explore the change in mass of the space shuttle during ascent. Teams work together to graph actual launch data in order to determine the rate of propellent burn.
Curated OER
Trends of Snow Cover and Temperature in Alaska
Students gather historical snow cover and temperature data from the MY NASA DATA Web site. They compare this data to data gathered using ground measurements from the ALISON Web site for Shageluk Lake. They graph both sets of data and...
Space Awareness
The Climate in Numbers and Graphs
Weather versus climate: weather relates to short time periods while climate averages the weather of a period of many years. Scholars learn about average temperature and precipitation in various climate zones and then apply statistics...
Balanced Assessment
Solar Elements
Let your brilliance shine like the sun. Future mathematicians and scientists consider given data on the abundance of different elements in the sun. The assessment task requires consideration of how these different abundances relate to...
Chicago Botanic Garden
Micro-GEEBITT Climate Activity
A truly hands-on and inquiry based learning activity bridges all the lessons in the series together. Beginning with a discussion on average global temperatures, young meteorologists use real-world data to analyze climate trends in order...