Week 8: Mechanisms of antibody production

Lab outline

• Filtering data in Excel

• Worksheet overview

• Experimental design feedback

• To-do for next week

I will be recording attendance for the remainder of the semester- I talked with Dr. Lohman and he agrees that we both need to keep track of attendance to make sure we’re able to assess the progress of everyone in the class and reach out if people are struggling. I’m not adding a lab attendance grade, but Dave might use lab attendance in his course attendance grade.

Filtering data in Excel

XLOOKUP()

XLOOKUP()

• What am I trying to find?

• Where am I trying to find it?

• What do I want to return when I find it?

• What do I want to return if I don’t find it?

FILTER

FILTER

• What range of data do you want to filter?

• What range of values do you want to filter by?

• What condition do those values need to satisfy?

• What value do you use if the condition isn’t satisfied?

Experimental design feedback

To-do

• Upload Lab Worksheet and Excel spreadsheet to Blackboard by next lab (03/20)

• Start data collection/data collection planning

• Weekly lab survey is your ticket out

• Speaker questions before the end of class on Monday