Curving quiz/exam grades
...
A quick way to curve these exams would be to edit the grade item and reduce the maximum points possible to in this example 64. This will vary according to your scenario or approach.
...
Adjust final scores (Adjusted Final Grade)
Export the gradebook to Excel and open file.
Create a new curved grade column.
Type a formula that will add a certain number of points to the original final grade. In this example, we are adding 10 points to the Adjusted Final Grade. The formula in the cell isÂ
=D2+10
...
Press the Enter key. The cell updates to show the original test grade with the additional points added to it.
Apply the formula to the remaining cells by dragging the fill handle to the last cell in the column that you want to copy the formula to. Release the mouse to copy the formula to the selected cells and update their contents with new point totals. The formula automatically recognizes that the cell contents are part of a series and adjusts the formula for all cells in the column.
Once the step above is complete, you can either share the results of the new column with the students (informing them of the change, of course) or copy them over the original Adjusted Final Grade column (D2 in the example above).
In Excel, select save the file a .CSV. Follow these steps to import the adjusted gradebook to eLC. .