After a quiz is already taken, I want to drop some of the top scores to improve the grade of students lower in the distribution. Can I export the grade book, adjust the spreadsheet column by multiplying it be a factor like (initial point total/new point total), save the spreadsheet as a CSV file, and import it back to Canvas? This will change the entire column and the total column. For example, suppose I give a 10 point quiz, and student A gets 10, B gets 8, and C gets 5. If I use all the points to determine the grade distribution, A gets an A, B gets a B, and C gets an F. If I drop the 10 and use 8 as the top score, then 8 is equal to 100%. A gets 10(10/8) = 12.5 = 125%, B gets 8(10/8) = 10 = 100%, and C gets 5(10/8) = 62.5 = 62.5%, and isn't so demoralized.
... View more