HHMI BioInteractive

Spreadsheet Tutorials

These tutorials are designed to show essential data analysis techniques using a spreadsheet program such as Excel. Follow the tutorials in sequence to learn the fundamentals of using a spreadsheet program to organize data, use formulae and functions to calculate statistical values including mean, standard deviation, standard error of the mean, 95% confidence intervals, plot graphs with error bars, perform t-tests, and plot the data as histograms.

HHMI BioInteractive Resources:

Spreadsheet Tutorials Main Page

Math and Statistics Teacher Guide

Educator Publications of Modified Resources:

The first of these modifications were produced by participants in the 2017 HHMI/QUBES Faculty Mentoring Network. Instructors collaborated to use these materials in different course contexts and with different student groups. They have shared their materials and insights into teaching with these materials: