Support

Support Options

  • Knowledge Base

    Find information on common questions and issues.

  • Support Messages

    Check on the status of your correspondences with members of the QUBES team.

Contact Us

About you
About the problem

Tutorial Combination and Assessment

By Cheryl Squair

University of Hawaii at Manoa

The tutorial adaptation specifically addresses data types (i.e., numeric versus categorical variables) and the types of graphs that are used to summarize the different data types.

Listed in Teaching Materials | resource by group HHMI BioInteractive FMN (2017)

Version 1.0.0 - published on 17 Jan 2018 doi:10.25334/Q48T03 - cite this

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

Adapted from: Spreadsheet Data Analysis Tutorial Series v 1.0

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.

Contents

Cite this work

Researchers should cite this work as follows:

Tags

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.

HHMI BioInteractive FMN (2017)

HHMI BioInteractive FMN (2017) group image

When watching a resource, you will be notified when a new version is released.