Resources: Compare
#283, v1.0
#286, v1.0.0
Title
Old Version | New Version | ||
---|---|---|---|
1 | Spreadsheet Data Analysis Tutorial Series | 1 | Tutorial Combination and Assessment |
Authors
Old Version | New Version | ||
---|---|---|---|
1 | HHMI BioInteractive () | 1 | HHMI BioInteractive () |
2 | Kristine Grayson (University of Richmond) | 2 | Kristine Grayson (University of Richmond) |
3 | Hayley Orndorf () | ||
4 | Cheryl Squair (University of Hawaii at Manoa) |
Description
Old Version | New Version | ||
---|---|---|---|
1 | <p>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.</p> | 1 | <p>The module was implemented at the <a href="http://manoa.hawaii.edu/">University of Hawai'i</a> at Mānoa by Cheryl Squair.</p> |
2 | |||
3 | <ul> | ||
4 | <li><strong>Course</strong>: Biology 171L - Introduction to Biology 1 Lab</li> | ||
5 | <li><strong>Course Level</strong>: Lower division biology majors</li> | ||
6 | <li><strong>Instructional Setting</strong>: Lab</li> | ||
7 | <li><strong>Implementation Timeframe</strong>: The tutorials were used to introduce students to spreadsheet skills, prior to our lab on data analysis, in the third week of the semester. All four tutorials were assigned to students as homework one week prior to the lab.</li> | ||
8 | </ul> |
Attachments
1 | file — ./spreadsheet tutorial cropped image.PNG | 1 | file — ./Squair/Spreadsheet Tutorial x_ Data Types and Graph Selection.xlsx |
---|---|---|---|
2 | link — Spreadsheet Data Analysis Tutorials | HHMI BioInteractive | 2 | file — ./Squair/Squair Teaching Notes.docx |
3 | publication — Spreadsheet Tutorial 1 -- Formulae, Functions, and Averages | HHMI BioInteractive | 3 | file — ./Squair/Squair-Tutorial-x-homework-KEY.docx |
4 | publication — Spreadsheet Tutorial 2 - Autofill Data, Cell References, and Standard Deviation | 4 | file — ./Squair/Squair-Tutorial-x-homework.docx |
5 | publication — Spreadsheet Tutorial 3 - Column Graphs, Error Bars, and Standard Error of the Mean | 5 | publication — Spreadsheet Tutorial 1 -- Formulae, Functions, and Averages | HHMI BioInteractive |
6 | publication — Spreadsheet Tutorial 4: t-Test | 6 | publication — Spreadsheet Tutorial 2 - Autofill Data, Cell References, and Standard Deviation |
7 | publication — Spreadsheet Tutorial 5: Histogram | 7 | publication — Spreadsheet Tutorial 3 - Column Graphs, Error Bars, and Standard Error of the Mean |