This excel file was created to alleviate the small stresses involved when trying to determine "Should I curve this assignment?" type of small stresses. This excel spreadsheet is designed automatically display the results of curving an assessment with three different avenues of thought: 1) "Do I reward those who have prepared to a greater extent to those who have decided not to prepare". 2) Do I want a quick-and-easy "everyone is getting the same amount of points" curve. Or 3) "Well that test didn't turn out as well balance as I thought, I need to increase to overall grade average for this assessment" type of curve.
1) The multiplier approach: This sheet takes the scores from an assignment and basically multiplies the total to sway results in favor of those who prepared well and scored well on the assessment. For instance, an assignment worth 100 points. StudentA scores a 90/100, StudentB scores 20/100. With this approach the scores are multiplied by a factor like 1.10, StudentA would now receive a 99/100 while StudentB receives a 22/100. StudentA: 9 point bump, StudentB: 2 points.
2) This is the basic everyone-gets-5-points to their score. StudentA: 5 point bump, StudentB: 5 points as well.
3) The Standard deviation approach: This method looks at the class average as a whole. Is the class average too low for your liking, say a 50% average score? Reset the average to a 70%. This method allows for a little more fine tuning and allows for you to compare 2 different class averages at the same time. It also graphs your scores for that true "bell curve" ideal...if you want that sort of thing.
All sheet included offer some degree of fine-tuning. They are set up in standard 5 point/percent increments with a "custom range" section that allows you to hone in on that ideal value for your assessment. All class scores are color coded to allow for fast and easy comparison of results and grade range totals are calculated so you can easily see how the curve will affect grade distribution.