## 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:

### Amylase Copy Number and Diet

Version: 2.0.0

### Spreadsheet Tutorial 1: Adapted to Anatomy and Physiology

Version: 1.0.0 Adapted From: Spreadsheet Tutorial 1 -- Formulae, Functions, and Averages | HHMI BioInteractive v1.0

### Spreadsheet Data Analysis Terms and Shortened Tutorial 4

Version: 1.0.0 Adapted From: Spreadsheet Data Analysis Tutorial Series v1.0

### Expanded Graphing Tutorial

Version: 1.0.0 Adapted From: Spreadsheet Data Analysis Tutorial Series v1.0

### Using HHMI Tutorials to Prepare Students for Investigating Authentic Datasets in Biology

Version: 1.0.0 Adapted From: Spreadsheet Data Analysis Tutorial Series v1.0

### Tutorial Combination and Online Implementation

Version: 1.0.0 Adapted From: Spreadsheet Data Analysis Tutorial Series v1.0

### Tutorial Combination and Assessment

Version: 1.0.0 Adapted From: Spreadsheet Data Analysis Tutorial Series v1.0