1330 total view(s), 1678 download(s)
Liesl McCormick - BMI Dataset.xlsx(XLSX | 57 KB)
Liesl McCormick - Spreadsheet Assessment.docx(DOCX | 599 KB)- Liesl McCormick - Spreadsheet Tutorial Excel.xlsx(XLSX | 421 KB)
- McCormick Teaching Notes.docx(DOCX | 13 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 Pacific University by Liesl V. McCormick.
- Course: Biol201L Introductory Biology: Flow of Information Lab
- Course Level: An introductory biology lab course for both majors and non-majors.
- Instructional Setting: Lab - Students enroll in lecture and laboratory concurrently. Lab meets for 3 hours once a week, and has approximately 24 students per section.
- Implementation Timeframe: The spreadsheet tutorial was implemented as an online resource, accessed by students outside of class time. The tutorial was made available the first week of the semester, and students had to take a related assessment by the end of the fourth week of the semester.
Notes
I adapted the first three spreadsheet tutorials, and combined them into a single streamlined tutorial. This tutorial features the tabs: Read this First, Basics, Organize, Format, Formulae, Functions, Ranges, Sorting, Standard Deviation, FIlling Cells, Copying Formulae, Bar Graph, Bar Graph 2, and Error Bars, along with three practice exercises. These topics were chosen to fit with the skills that the students enrolled in this lab section work with during the semester.
I wrote a new 10 question multiple choice assessment to be completed after working through the tutorials. This assessment was delivered through Moodle, and had no time limit. Students could attempt the assessment twice before the due date, and only their highest score was recorded. Incorrect answers directed students back to the tab in the tutorial where they could practice that particular skill.
For the exercises embedded within the tutorial, I kept the Darwin’s finches dataset. For the exercises included in the assessment, I used a portion of a dataset from Gapminder.org about BMI in the United States over the past few decades. I provided students with this modified dataset in a spreadsheet program, and had them work with the data to answer the assessment questions.
Cite this work
Researchers should cite this work as follows:
- McCormick, L. V. (2018). Tutorial Combination and Online Implementation. HHMI BioInteractive FMN (2017), QUBES Educational Resources. doi:10.25334/Q41092