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
- 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.