Curving Grades

Methods:

Curve exam score

• If the highest percentage grade in the class was 80%, the difference is 20%. You can add 20 percentage points to each student's test score.

• If the exam is worth 10 points and the highest score is 7 points, the difference is 3 points. You can add 3 points to each student's test score.

You can review quiz statistics and create and view reports to help you analyze your students situation.

Curving quiz/exam grades

Navigate to Grades (spreadsheet view). In the example below, no one scored more than 64 out of 100 on the Exam 1. Students also did not do well on exams 2 and 3.

Open

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.

Open

Adjust final scores (Adjusted Final Grade)

1. Export the gradebook to Excel and open file.

2. Create a new curved grade column.

3. 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

1. Press the Enter key. The cell updates to show the original test grade with the additional points added to it.

2. 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.

3. 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).

4. In Excel, select save the file a .CSV. Follow these steps to import the adjusted gradebook to eLC. .