1074 total view(s), 522 download(s)
Spreadsheet Tutorial x_ Data Types and Graph Selection.xlsx(XLSX | 51 KB)
Squair Teaching Notes.docx(DOCX | 15 KB)
Squair-Tutorial-x-homework-KEY.docx(DOCX | 103 KB)
Squair-Tutorial-x-homework.docx(DOCX | 76 KB)
- Spreadsheet Tutorial 1 -- Formulae, Functions, and Averages | HHMI BioInteractive (v1.0)
- Spreadsheet Tutorial 2 - Autofill Data, Cell References, and Standard Deviation (v1.0)
- Spreadsheet Tutorial 3 - Column Graphs, Error Bars, and Standard Error of the Mean (v1.0)
- License terms
Description
The module was implemented at the University of Hawai'i at Mānoa by Cheryl Squair.
- Course: Biology 171L - Introduction to Biology 1 Lab
- Course Level: Lower division biology majors
- Instructional Setting: Lab
- Implementation Timeframe: 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.
Notes
I implemented Tutorials 1, 2 and 3 with no changes. Students in our course do not cover any statistics beyond mean, median, mode and standard deviation. Consequently, I excluded the tutorials on t-test and regression. Many students appear to have a fuzzy or incomplete understanding of different types of data. To address this, I developed an additional tutorial to explicitly cover different data types and how those data are graphed. I typically only generate scatter plots, line and bar graphs. I did not cover histograms in our course, primarily because of the challenges associated with generating them in spreadsheet programs such as MS Excel. In the past, the students spent so much time trying to construct bins, that they forgot the purpose of binning.
Cite this work
Researchers should cite this work as follows:
- Squair, C. (2018). Tutorial Combination and Assessment. HHMI BioInteractive FMN (2017), QUBES Educational Resources. doi:10.25334/Q48T03