John Varine's blog

Compiling Student Data

To assist in grading the lab results for this and other quantitative labs that we did, I created Excel spreadsheets where the students’ results could be entered. The spreadsheet then did all the required calculations and compared the students’ results to the theoretical value. This made grading the lab reports much quicker and more accurate, flagged incorrect student calculations, allowed a much more complete discussion of the lab results and permitted “what if” questions to be discussed.