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.
Adapted from: Spreadsheet Data Analysis Tutorial Series v 1.0
In one classroom, a scaffolding approach was used where students knew they needed to make a certain type of graph given a set of data. Each type of graph had a brief introduction and explained the different types of variables and then students used that information to make the graph. The week before this lesson, students completed Tutorial 1 to introduce Excel before working on this graphing tutorial. From the original resource, the “exploration” tabs were deleted. After each tutorial, students answered questions for points on the Learning Management System (LMS).
- Graphing Tutorial.xlsx(XLSX | 143 KB)
- Spreadsheet Data Analysis Tutorials | HHMI BioInteractive
This introduction to spreadsheet programs describes the basic organization of a worksheet, how to organize and format your data, how to perform simple mathematical calculations, how to use built-in mathematical functions, and how to select and...
Generate a table with autofill, and use absolute cell reference to calculate variance and standard deviation.
Generate a column or bar graph with standard error bars.
Calculate t-values and perform t-tests using built-in functions.
Generate a histogram using a variety of methods.
- License terms
Cite this work
Researchers should cite this work as follows: