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...
Howard Hughes Medical Institute
Seed Dispersal in Tropical Forests
How do seeds get around? It's not like plants can control seed dispersal—or can they? Dig deeper into the amazing mechanisms of seed dispersal observed in tropical plants through interactives, a video, and plenty of hands-on data...
Curated OER
Why Are The Shore Birds Dying?
Students engage in a field study of birds and how they are in danger harm due to environmental factors. They list different possible causes in a prediction activity. The observations are done while writing up data and connecting it to 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
Gravity Versus The Mighty Egg - Biology Teaching Thesis
Students are able to describe the principles of gravity. They name other places in the real world where we compensate for gravity. Students design a shock absorber with limited materials and explain how it works to protect an egg. They...
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.
Curated OER
Biology Jeopardy
Play Jeopardy as you review what might possibly be an entire year's high school biology course! The vast variety of questions requires that you read through the slides to make sure that they all relate to your curriculum. You could make...
McGraw Hill
Population Biology
The carrying capacity of an environment varies based on the organisms that live there. Using a virtual lab simulation, scholars test two protists living in their own environments and a third environment where both protists live. They...
Curated OER
Biology Project: Gone Fishing
Students write a scientific article using data and prediction skills. In this scientific writing lesson, students access data about fishing off the coast of New Jersey. They look at satellite data, fluorometry and CTD data over a 3 -4...
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...
Howard Hughes Medical Institute
EarthViewer
Can you imagine Washington DC and London as close neighbors occupying the same continent? Learners will be fascinated as they step back in time and discover the evolution of the earth's continents and oceans from 4.5 billion years ago to...
Science 4 Inquiry
The Ups and Downs of Populations
Life has its ups and downs ... especially if you're an animal! Biology scholars engage in a population study through an inquiry-based lesson. Pupils work together to explore the factors that affect deer populations, then examine 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 comes from a...
Curated OER
Observing and Recording Biological Data
Students create their own definition of life. They identify the eight characteristics of life in organisms. They compare and contrast the characteristics of living and nonliving things.
Virginia Department of Education
Energy and ATP
Take charge of your biology class by using this exciting analogy to relate the ATP process with batteries. Pupils use batteries and rubber bands to simulate the phosphate bonds between molecules in the body. They measure the distance in...
NOAA
Biological Oceanographic Investigations – Keep Away
As of 2015, there are 53,481 oil wells in the Gulf of Mexico. Scholars determine how species diversity is impacted based on the ecosystem's distance from a drilling platform. It focuses on finding the mean of data sets and creating bar...
Chicago Botanic Garden
Impacts of Climate on Forest Succession
Part two in a series of four explores the effects of climate on succession or the changing of plant species in a forest. Groups review how to identify trees and then spend a day in the field collecting extensive data on trees to...
NOAA
Biological Oceanographic Investigations – Signals from the Deep
The Deepwater Horizon oil spill directly impacted an area of the Gulf of Mexico the size of Oklahoma. A marine biology lesson looks at the impact of an oil spill on the deeper parts of the ocean. Scholars download actual data collected...
Florida International University
Counting FishStix
How do we count the fish in the ocean? An engaging lesson models how to estimate fish populations with observational surveys. Class members begin by studying the behavior of fish on the coral reef in the oceans. They then become the fish...
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
Who Has the Data? Monitoring Coral Reefs
Learners access data to characterize coral reefs. For this scientific research lesson, students access data and explain the need for such data when monitoring coral reefs. They will identify and explain three major threats to coral reefs.
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.