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,...
Curated OER
Probability
Here is a classic activity used to introduce your class to the concept of probability and data collection. They will roll one die 30 times, then record and discuss the results. Great introduction, but too shallow to be considered a...
Curated OER
Identifying Ozone Variations over Different Locations
Students analyze ozone data. In this atmosphere lesson, students will use a NASA resource to gather data for different regions of the Earth. Students will then create a graph for their data and answer related questions.
Curated OER
Populations and Life Cycles
Students explore biology by researching ocean statistics. In this data analysis lesson, students conduct a snail examination experiment utilizing live pouch snails. Students collect data about the snails over the course of six weeks and...
Curated OER
Graphing Iron Data
Students 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.
American Statistical Association
You and Michael
Investigate the relationship between height and arm span. Young statisticians measure the heights and arm spans of each class member and create a scatter plot using the data. They draw a line of best fit and use its slope to explain the...
Rice University
Introductory Statistics
Statistically speaking, the content covers several grades. Featuring all of the statistics typically covered in a college-level Statistics course, the expansive content spans from sixth grade on up to high school. Material...
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...
Curated OER
Data-gathering Activities Relating to Trees in Their Environment
Students gather data relating to trees in their environment. In this biology lesson plan, students determine heights of trees and their ages. A canopy map will indicate optimal growing areas for the tree.
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...
Curated OER
Photosynthesis
Students recognize the importance of plants as they perform an experiment involving photosynthesis. Students determine the optimum wavelength of light for photosynthesis by exposing plants to different colors of light, collecting data,...
Curated OER
Biological and Agricultural Engineering
Eighth graders explore mathematics by conducting a series of investigations using a colorimeter. In this math lesson, 8th graders explain the purpose of food irradiation. They collect data and graph them.
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...
Curated OER
Endocrine Disruptors in Our Drinking Water: Should We Be Concerned?
Students investigate the different hormone contaminants in the water supply. In this math lesson, students analyze data tables and graphs. They demonstrate exponential growth and decay using frog populations.
Curated OER
Water Quality Data Analysis
Students develop a process for analyzing collected bayou data.
They find the mathematical relationships among various biological factors.
Students, work collaboratively using technology in their data analysis.
Curated OER
Monopoly Graphs
Students relate the concepts of linear functions to the game of monopoly. For this algebra lesson, students solve problems with ratio and proportion. They collect data and graph it.
Curated OER
Conductivity of salt Solutions
Students investigate the concentration level of solutions. In this math/science activity, students identify three different ionic compounds. They predict the conductivity of each using their collected data.
Curated OER
Probability: The Study of Chance
Students practice the basic principles of probability by conducting an experiment, determining if a game is fair, collecting data, interpreting data, displaying data, conducting analysis, and stating and applying the rule for probability.
Curated OER
Scientific Graphs
Students organize data collected from their experiments using graphs. In this statistics and biology lesson, students organize their scientific data from an article into readable graphs. They define the usefulness of their graph and...
Curated OER
A Statistical Study of Three Biomes
Students collect data from one of three selected biomes. Data are then organized and statistically analyzed. This project engages students of different backgrounds grouped cooperatively in a relevant outdoor hands-on learning experience.
Curated OER
The Great Pollinators
Students discover the reproductive parts of a plant. In this biology lesson, students identify and categorize several different plants they dissect in class. Students record their information using a data chart.
Curated OER
Probability: the Study of Chance
Students experiment to determine if a game is fair, collect data, interpret data, display data, and state and apply the rule for probability. Students use a simple game for this experiment.
Curated OER
Modeling Drug Assimilation in the Human Body
Young scholars investigate the accumulation of drugs in the body. In this algebra lesson, students collect data on drug retention and assimilation. They use their data to predict the behavior and effects of drugs.
Curated OER
Trouble in the Troposphere
Students Use data sets from MY NASA DATA to produce graphs comparing monthly and yearly ozone averages of several U.S. cities. They analyze and evaluate the data and predict trends based on the data. In addition, they discuss and...