Howard Hughes Medical Institute
Spreadsheet Tutorial 4: t-Test
The t-test tutorial will fit your needs to a T. After calculating the mean, sum of squares, standard deviation, and variance of two data sets on a spreadsheet, scholars learn to calculate the t-values. They then learn to use the TTEST...
Howard Hughes Medical Institute
Spreadsheet Tutorial 5: Histogram
A professional-looking histogram is just a few clicks away. The last installment of a five-part Spreadsheet Data Analysis series focuses on histograms. Learners work through a tutorial to see how spreadsheets can help make frequency...
Howard Hughes Medical Institute
Spreadsheet Tutorial 3: Column Graphs, Error Bars, and Standard Error of the Mean
There's absolutely no error in using the tutorial! Learners use spreadsheets to create column or bar graphs with error bars. They also learn how to calculate the standard error of the mean in the tutorial. This is the third installment...
Howard Hughes Medical Institute
Spreadsheet Tutorial 2: Autofill Data, Cell References, and Standard Deviation
If you've always wanted to know more about spreadsheets, here's a perfect resource for you. A self-paced tutorial introduces how to autofill and copy formulas in a Google sheet or Excel spreadsheet. It also shows users how to find range,...
Teach Engineering
Searching for Bigfoot and Others Like Him
Individuals create a GIS data layer in Google Earth that displays information about where one might find seven different cryptids. The class members research to find data on cryptid sightings they can include in their data...
Curated OER
A Model Solar System
If Earth is modeled by a grapefruit, what planet could be represented by a golf ball? This activity uses everyday and not-so-everyday objects to create a model of the Solar System.
PBL Pathways
Do Homework?
To complete homework or not to complete homework ... that is the question. Decide whether it makes a difference on finals by doing homework. Individuals create a scatter plot and find a line of best fit for data on the percent of...
Center for Math and Science Education
Solar System Launch
Trying to understand the vastness of outer space can be quite a challenge for young scientists. Help put things in perspective with this cross-curricular activity as students work in pairs creating scaled models of...
Teach Engineering
Air Pollution in the Pacific Northwest
Scholars investigate levels of nitrogen dioxide in the Pacific Northwest by examining the role of nitrogen in air pollution and how remote sensing can be used to measure nitrogen levels. An Excel spreadsheet calculates the difference...
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...
Agile Mind
Isabella’s Credit Card
An in-depth activity that involves a real-world problem about credit card debt. Learners are given a scenario in which Isabella plans to stop using her credit card and pay off the balance by paying a fixed amount each month. The first...
Howard Hughes Medical Institute
Human Impacts on Biodiversity
Have you always wanted to take your science class on an amazing field trip they will never forget? Now you can! Observe the wildlife in an African savanna through trail cameras with a five-part data analysis activity. Learners analyze...
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...
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...
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...
Conneticut Department of Education
Personal Finance Project Resource Book
Balancing a budget, paying taxes, and buying a home may feel out of reach for your high schoolers, but in their adult years they will thank you for the early tips. A set of five lessons integrates applicable money math...
101 Questions
Coins in a Circle
Round and round you'll go! Learners watch as different-sized circles fill with coins. They collect data and then make a prediction about the number of coins that will fit in a large circular rug.
It's About Time
Metals and Nonmetals
Did you know you can melt the metal gallium with just the heat of your hand? Pupils observe and test materials in order to classify them as metal or non-metal. A reading passage and analysis questions wrap up the lesson.
Curated OER
Sunrise, Sunset
What locations on Earth get the longest number of hours of daylight in the summer? Hint: It's not the equator! Use real-world sunrise and sunset data to develop trigonometric models that can be used to estimate the number of hours of...
Teach Engineering
Energy Perspectives
The data says ... the resource is great to use. Using Microsoft Excel, pupils analyze data from the US Department of Energy in the fifth lesson of a 25-part Energy Systems and Solutions unit. Each group looks at a different data set and...
Teach Engineering
Understanding the Air through Data Analysis
Is there a correlation or causation relationship between air pollutants? Groups develop a hypothesis about the daily variation of air pollutants, specifically ozone and CO2. Using Excel to analyze the data, the groups evaluate their...
Curated OER
Viral Marketing
What is "viral marketing" and how does it relate to mathematics? Young mathematicians use exponential functions to develop a mathematical model for a business advertising campaign. Learners then see how their campaigns increase...
Curated OER
Build a Black History Database/Timeline
Students research famous people and events in Black History then break the biographies and events down into specific information related to dates in history. They
Georgia State University
Georgia State University: Creating Spreadsheets Using Ms Excel
This Georgia State University site gives in outline form the basic principles of using spreadsheet software. At the end of the outlines, specific uses for spreadsheets in recordkeeping are suggested.