Support

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

• Spreadsheet Tutorial 1 -- Formulae, Functions, and Averages | HHMI BioInteractive (v1.0)

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

• Spreadsheet Tutorial 2 - Autofill Data, Cell References, and Standard Deviation (v1.0)

  Generate a table with autofill, and use absolute cell reference to calculate variance and standard deviation.

• Spreadsheet Tutorial 3 - Column Graphs, Error Bars, and Standard Error of the Mean (v1.0)

  Generate a column or bar graph with standard error bars.

• Spreadsheet Tutorial 4: t-Test (v1.0)

  Calculate t-values and perform t-tests using built-in functions.

• Spreadsheet Tutorial 5: Histogram (v1.0)

  Generate a histogram using a variety of methods.

• License terms

Researchers should cite this work as follows:

• Newtoff, K. N., Squair, C., Homer-Drummond, S. M., Goulet, T. (2018). Expanded Graphing Tutorial. HHMI BioInteractive FMN (2017), QUBES Educational Resources. doi:10.25334/Q45M37

  BibTex | EndNote

1. High School
2. introductory
3. Scientific Methodology
4. Scientific Process
5. Statistics and Math
6. Teaching material
7. Undergraduate