Each course is structured differently, and in ours, we added attendance above and beyond quizzes. Thus, it was possible to have a percentage greater than 100. This might have complicated things later for the final grade, but Excel can handle it easily. We ll talk about that later. Next, we consider exams.
Most intro courses give a large number of exams.
This is for several reasons, but mostly to give the students a lot of feedback on how well they understand the material and decrease the weight of each exam so that they are not penalized as much for mistakes. As mistakes do occur, and there are lots of freshmen in Psych 1101, we curved most of the exams. Each of the exams is the same for our purposes, so now we get to the hard part for many people. Dropping grades can be done many ways, but this is the simplest way that can handle multiple zeros or other odd numbers. If you notice, I have created a set of columns that repeat data.