1 - 12 of 16 results

Setting Up Your Data for Success

This highly customizable activity guides students through organizing and documenting spreadsheet data during a class investigation.

Science Practices
Skill Builders
High School — General
High School — AP/IB
College

Using Data to Investigate Elephant Evolution

In this activity, students work with authentic research data to explore the impact of poaching on African elephants.

Evolution
Science Practices
Lessons
High School — General
High School — AP/IB
College

Nutrient Cycling in the Serengeti

In this activity, students engage with an example from the Serengeti ecosystem to illustrate the exchange of nutrients between plants, animals, and the environment.

Microbiology
Ecology
Earth Science
Card Activities
High School — General
High School — AP/IB
College

Monkey Social Status and Immune Response

This activity guides the analysis of a published scientific figure from a study on how social status affects the expression of genes involved in immune system processes.

Genetics
Anatomy & Physiology
Science Practices
Data Points
High School — General
High School — AP/IB
College

Maternal Microbiota Impacts Offspring Immune System

This activity analyzes a published scientific figure from a study assessing if the microbiota from a mother affects the immune systems of the developing offspring.

Microbiology
Anatomy & Physiology
Science Practices
Data Points
High School — General
High School — AP/IB
College

HIV Receptors and Co-receptors

This demonstration models the first step of the HIV life cycle: the binding of HIV envelope proteins to receptors on human helper T cells.

Microbiology
Anatomy & Physiology
Science Practices
Labs & Demos
High School — General
High School — AP/IB
College

Spreadsheet Tutorial 4: t-Test

In this activity, students explore different ways of calculating t-values and performing t-tests using built-in functions in Excel or Google Sheets. Students apply what they learned by plotting beak size measurements of Galapágos finches collected before and after a drought.

Evolution
Science Practices
Lessons
High School — General
High School — AP/IB
College

Spreadsheet Tutorial 5: Histogram

In this activity, students explore different ways of constructing a histogram using Excel or Google Sheets. Students apply what they learned by plotting beak size measurements of Galapágos finches before and after a drought.

Evolution
Science Practices
Lessons
High School — General
High School — AP/IB
College

Spreadsheet Tutorial 2: Autofill Data, Cell References, and Standard Deviation

In this activity, students use the built-in functions in Excel or Google Sheets to explore different ways of filling in cells with a series of numbers, copying and pasting formulae, and referencing individual cells to use in calculations. Students apply what they learned by making different calculations with beak size measurements of Galapágos finches.

Evolution
Science Practices
Lessons
High School — General
High School — AP/IB
College

Spreadsheet Tutorial 3: Column Graphs, Error Bars, and Standard Error of the Mean

In this activity, students explore different ways of creating simple bar graphs and adding error bars from calculated statistical values using built-in functions in Excel or Google Sheets. Students apply what they learned by plotting beak size measurements of Galapágos finches collected before and after a drought.

Evolution
Science Practices
Lessons
High School — General
High School — AP/IB
College

Spreadsheet Tutorial 1: Formulae, Functions, and Averages

In this activity, students use the built-in functions in Excel or Google Sheets to calculate the mean and median. Students apply what they learned to a dataset beak measurements of Galapágos finches.

Evolution
Science Practices
Lessons
High School — General
High School — AP/IB
College

Coral Reefs and Global Warming

This activity allows students to use authentic scientific data to make claims about the threat of coral bleaching for reefs around the world.

Environmental Science
Earth Science
Science Practices
Lessons
High School — AP/IB
College