Grading Revised Essay Work

[jflores26]

Is there a way to calculate a weighted average grade for first and revised drafts, say for example in a composition course? Here's the scenario: a student turns in a paper, then decides to submit a revision after receiving feedback. The instructor grades both papers. The "final" grade will then be calculated as such: 30% from the first draft, and 70% from the revised paper.  I was just wondering if there was a way to set this up on gradebook, or if I will have to do this outside of Canvas (say, Excel), then enter the scores manually.

[nwilson7 · Accepted solution]

@jflores26 There really is not a way to do this in Canvas.  Since you are open to the idea of doing it in Excel, that can be done very easily.  This is ultimately the formula that you would use: =(A1*0.3)+(B1*0.7) 

You can replace any of these values based on where your scores are but using your example, the score for the first submission is in cell A1 and the ".3" is weighting it 30%.  Then the score of the revised version is in cell B1 which is being weighted at 70% (.7).  I uploaded an excel sheet you can use with everything in place.  You can use the top right corner in green to enter your weights (make sure they add to 100) and the weighted score will update accordingly so you do not have to edit any of the formulas.

Hope this helps!

-Nick

[jflores26]

Thank you so much for the response and sharing your file! Much appreciated! 😊 Yes, I am aware that this can be done on Excel, but I was just hoping there was a way that this calculation can be set up on Canvas Gradebook so that there are fewer steps for the instructor.