Spreadsheet Data Analysis Terms and Shortened Tutorial 4
Author(s): Jennifer Buntz
Dine College
1333 total view(s), 643 download(s)
Description
Students gained graphing skills, general Excel skills and some knowledge about the students’ t-test. My students had a very wide range or abilities coming into this work, but I think that all got something from it. They worked together out of class to complete Tutorials 1-3 as homework, which of course has its benefits (teamwork, cooperation and reinforcing the material) and minuses (copying others work without understanding it). By working together out of class, they learned the mechanics of what to do in Excel. I removed the null hypothesis from Tutorial 4 and also keep only the long-hand calculation of a “t” value, and emphasize how to determine significance using the table. My students needed more help understanding what the “t” value means. During the second half of the semester, students used these skills to analyze data they collected in lab - pooled class results from an enzyme lab.
Cite this work
Researchers should cite this work as follows:
- Buntz, J. (2018). Spreadsheet Data Analysis Terms and Shortened Tutorial 4. HHMI BioInteractive FMN (2017), QUBES Educational Resources. doi:10.25334/Q43D59