Resource Image

Spreadsheet Data Analysis Terms and Shortened Tutorial 4

Author(s): Jennifer Buntz

Dine College

1104 total view(s), 510 download(s)

0 comment(s) (Post a comment)

Summary:
Introductory students are asked to learn terms for descriptive statistics and complete a matching exercise. Tutorial 4 was shorted to just the full calculations of t values.

Licensed under CC Attribution-NonCommercial-NoDerivatives 4.0 International according to these terms

Version 1.0.0 - published on 20 Feb 2018 doi:10.25334/Q43D59 - cite this

Adapted from: Spreadsheet Data Analysis Tutorial Series v 1.0

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: