1 - 12 of 14 results
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
Sampling and Normal Distribution

This interactive simulation allows students to graph and analyze sample distributions taken from a normally distributed population.

Science Practices
Click & Learn
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
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
Mapping Genes to Traits in Dogs Using SNPs

In this activity, students identify single nucleotide polymorphisms (SNPs) that are correlated with different traits in dogs to identify genes associated with those traits.

Genetics
Evolution
Science Practices
Card Activities
High School — General
High School — AP/IB
College
Lizard Evolution Virtual Lab

This interactive, modular lab explores the evolution of the anole lizards in the Caribbean through data collection and analysis.

Anatomy & Physiology
Evolution
Science Practices
Virtual Labs
High School — General
High School — AP/IB
College
Evolution in Action: Data Analysis

These two activities allow students to analyze a data set of measurements taken from two populations of Galápagos finches. The activities support concepts covered in the short film The Beak of the Finch.

Evolution
Science Practices
Lessons
High School — General
High School — AP/IB
College
Mendelian Genetics, Probability, Pedigree, and Chi-Square Statistics

In this activity, students apply concepts pertaining to the genetics of sickle cell disease and its relationship to malaria explored in the short film The Making of the Fittest: Natural Selection in Humans.

Genetics
Evolution
Science Practices
Lessons
High School — AP/IB
College
Using Genetic Crosses to Analyze a Stickleback Trait

In this hands-on activity, students analyze the results of genetic crosses between stickleback fish with different traits. It complements the film Evolving Switches, Evolving Bodies.

Genetics
Evolution
Science Practices
Card Activities
High School — General
High School — AP/IB
Diet and the Evolution of Salivary Amylase

This activity engages students in analyzing authentic scientific data that explore the effects of different diets on the evolution of an enzyme that breaks down starch.

Evolution
Science Practices
Lessons
High School — AP/IB
College