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

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, Teaching material, 1 Hour
166
118
0
03.10.2019
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, Teaching material, Undergraduate
359
175
0
02.21.2018
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, Teaching material, Undergraduate
286
100
0
02.20.2018

Expanded Graphing Tutorial

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

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

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, Teaching material, High School, Undergraduate
447
101
1
01.18.2018
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, Teaching material, Undergraduate
392
120
0
01.17.2018
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, Teaching material, Undergraduate
238
79
0
01.17.2018

Tutorial Combination and Assessment

Cheryl Squair

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

The tutorial adaptation specifically addresses data types (i.e., numeric versus categorical variables) and the types of graphs that are used to summarize the different data types.
Scientific Process, Statistics and Math, Scientific Methodology, introductory, Teaching material, Undergraduate, Homework
254
115
0
01.17.2018