Association for Biology Laboratory Education

No, It’s Not about Pipetting!
 

Stephanie Mel & Stanley M. Lo

Tested Studies in Laboratory Teaching, 2018, Volume 39

Abstract

This lab exercise integrates a basic lab skill with simple math functions and statistical analysis using Excel. At the conclusion of the exercise, students will have determined that pipetting correctly vs. incorrectly results in statistically different volumes (masses) of water. In the first lab meeting, students are taught how to use micropipettors correctly, by depressing the plunger to the first stop to draw up liquid, and then depressing to the second stop to release the liquid. Each group of students correctly pipettes two specific volumes in duplicate (60 µL, 120 µL) into separate pre-weighed eppendorf tubes. They also pipette the same volumes incorrectly, by depressing the plunger to the second stop and drawing up the liquid. Students then determine the mass of water in each of the eppendorf tubes. To do this, they enter their data into a shared Google spreadsheet and they learn to use simple math functions in Excel to subtract the mass of the empty tubes from the tubes + water (see Figure 1). The data for the entire class is entered into the same shared spreadsheet so students can sort and align the four sets of data (60 uL correct and incorrect, 120 uL correct and incorrect) using the Sort function on Excel. They then calculate the averages and standard deviations of each of the four data sets using the AVERAGE and STD (Standard Deviation) functions in Excel. Finally, they perform t-tests (again using Excel) on the 60 uL and 120 uL data sets. The resulting p-values clearly show that pipetting incorrectly leads to significantly larger volumes than pipetting correctly. This exercise is very accessible to beginning students and is used in a lab class for incoming freshmen. Typically the students have no experience with lab skills, statistical analysis or Excel. Our students work in groups of 4, so each student within the group pipettes water for one of the data points (i.e. 60 uL correct, 60 uL incorrect, 120 uL correct, 120 uL incorrect). They work together to weigh the tubes, enter the data into the shared spreadsheets, and do the calculations. A more detailed protocol is available upon request by emailing the author at smel@ucsd.edu.

Keywords:  Excel data analysis, pipetting

University of Wisconsin, Madison (2017)