# HHMI BioInteractive

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:

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

Rebecca Orr, Ruth Buskirk, Kristin Harvey

Version: 2.0.0

An adapted module from HHMI Spreadsheet Tutorials using amylase data for students to gain data analysis and excel skills
Scientific Process, Statistics and Math, Scientific Methodology, Activity Length, 1 Hour
795
721
0
0
03.2019

Aylin Marz

Version: 1.0.0

Adapted the examples to Anatomy and Physiology relevant topics and implemented in BIO165L Anatomy and Physiology I Laboratory for non-majors.
Resources @ HHMI - BioInteractive, summary statistics, Scientific Process, Scientific Methodology, Introductory, Undergraduate
1.0K
431
0
0
02.2018

### Spreadsheet Data Analysis Terms and Shortened Tutorial 4

Jennifer Buntz

Introductory students are asked to learn terms for descriptive statistics and complete a matching exercise. Tutorial 4 was shorted to just the full calculations of t values.
Scientific Process, Statistics and Math, Scientific Methodology, Introductory, Undergraduate
801
296
0
0
02.2018

### Expanded Graphing Tutorial

Kiersten Nicole Newtoff, Cheryl Squair, Sharon Maureen Homer-Drummond, Tamar Goulet

The tutorial has two approaches for teaching about graph building and choosing the appropriate graph for different data types, a scaffolding approach and a exploration approach which can be utilized depending on how you wish to use the resource.
Scientific Process, Statistics and Math, Scientific Methodology, Introductory, High School, Undergraduate
1.1K
266
0
0
01.2018

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

Kaitlin Bonner

HHMI tutorial modules were modified and condensed to bring all students up to the same skill level, and students took a pre-assessment to demonstrate adequate preparation for class.
Scientific Process, Statistics and Math, Scientific Methodology, Introductory, Undergraduate
998
362
0
0
01.2018

### Tutorial Combination and Online Implementation

Liesl V McCormick

The two key features of my implementation is the fact that the tutorial was implemented in an online setting, and I added an assessment (also implemented in an online setting).
online, Scientific Process, Statistics and Math, Scientific Methodology, Introductory, Lab, Undergraduate
785
1.1K
0
0
01.2018

Cheryl Squair