How are grades calculated in Gradebook?

Course grade calculations depend on your gradebook's organization and grade entry setting, points (described here) or percentages:

  • No categories (default) - Each gradebook item is assigned a simple point value. The course grade is determined by the student's total score divided by the total points possible.
  • Categories only - Categories are used to group gradebook items, where items are assigned a simple point or percentage value. Similar to a gradebook with No categories, the course grade is determined by the student's total score divided by the total points possible. This structure provides the option to drop the lowest grade(s), keep the highest grade(s), or drop the highest grade(s) within a Category.
  • Categories and weighting- Items are grouped into categories, where each Category is assigned a percentage of the course grade. The total score of all items in a Category will comprise the Category's percentage of the course grade. This structure provides the option to drop the lowest grade(s), keep the highest grade(s), or drop the highest grade(s) within a Category.

No Categories

Image of gradebook with no categories

In a default gradebook with No categories, course grades are calculated for each student by dividing the sum of the scores received for all graded items by the total points possible for those items.

Note: Ungraded items are not included in a student's course grade. Leaving a grade entry blank reduces the total points possible by the point value of the ungraded item for that student.

In the example pictured above, most students were graded out of 200 total points. However, Aimee has not received a grade for Homework 2 (100 points possible).  Thus, their current course grade is calculated with 87/100 =  87%.

Categories Only

With Categories only, course grades are calculated the same as in a gradebook with No categories (described above). However, if all items in a Category have the same total point value, you can automatically drop the lowest or highest grades or keep the highest grades within that Category. Dropped grades are omitted from the course grade calculation, and the total points possible in the Category are reduced by the point value(s) of the omitted item(s).

By using the Keep Highest option instead of the Drop Lowest to drop the lowest grade(s), no grades will be dropped in the Category until the number of items kept is exceeded.

See below for example calculations when grades in a Category are dropped or kept.

Note: You must assign each item to a Category for the item to be included in students' course grades.

Grades can only be entered in Gradebook items; you cannot enter grades into a Category with no items.

Ungraded items are not included in a student's course grade.  Leaving a grade entry blank reduces the total points possible by the point value of the ungraded item for that student.

Categories with Drop Lowest/Highest

Image of dropped gradebook items

Pictured above is a Gradebook with two categories: Assignments and Quizzes. The Assignments Category drops the lowest grade, and includes two assignments, each worth 10 points. The Quizzes Category includes Quiz 1 (10 points) and Quiz 2 (20 points). There are 40 points possible because only one assignment and the two quiz grades are included in the course grade calculation.

In the example, Albert received the following grades:

Assignments:

  • Assignment 1 (10 points)
  • Assignment 2 (8 points) (lowest grade - dropped)

Quizzes: (not pictured)

  • Quiz 1 (9 points)
  • Quiz 2 (19 points)

Since the Assignment 2 grade is dropped, Albert's course grade is 95%:

  • 10 + 9 + 19 = 38 points earned
  • 38/40 = 0.95

Categories with Keep Highest

Image of gradebook with keep highest scores.

Pictured above is a Gradebook with two categories: Assignments and Quizzes (not shown). The Assignments Category keeps the two highest grades, and includes three assignments, each worth 10 points. The Quizzes Category includes Quiz 1 (10 points) and Quiz 2 (20 points). There are 50 points possible because only two assignments and the two quiz grades are included in the course grade calculation.

Before the third assignment grade is entered, Student 0181 received the following grades:

Assignments:

  • Assignment 1 (10 points) (1st highest grade - kept)
  • Assignment 2 (8 points) (2nd highest grade - kept)

Quizzes:

  • Quiz 1 (9 points)
  • Quiz 2 (19 points)

No grades are dropped yet because we have used the Keep Highest option, so Student Five's grade is 92%:

  • 10 + 8 + 9 + 19 = 46 points earned
  • 46/50 = 0.92

In comparison, if Drop Lowest were used instead, Student 0181's grade would have been calculated as only 36 points earned out of 40 points (95%), as shown in the example above where the lowest grade of two assignment is dropped.

Categories & Weighting

Use Categories & Weighting to group Gradebook items into Categories, and weight each Category as a percentage of the total course grade. The sum total of all Category percentages must equal 100%.

For example, if Exams are worth 20% of the course grade, the Exams Category (20%) could include a Midterm Exam (50 points) and Final Exam (100 points).

Each student's course grade is the sum of the categories' weighted averages. See below for additional information about dropping and keeping grades, and for example calculations.

Note: You must assign each item to a Category for the item to be included in students' course grades.

Grades can only be entered in Gradebook items; you cannot enter grades into a Category with no items.

Ungraded items are not included in a student's course grade. If any grade entry is left blank, the total points possible within the Category are reduced by the point value(s) of the ungraded item(s) for that student.

Dropping and Keeping Grades

If all items in a Category have the same total point value, you can automatically drop the lowest or highest grades or keep the highest grades within that Category. Dropped grades are omitted from the course grade calculation, and the total points possible in the Category are reduced by the point value(s) of the omitted item(s).

By using the Keep Highest option instead of Drop Lowest to drop the lowest grade(s), no grades will be dropped in the Category until the number of items kept is exceeded.

Categories & Weighting - example calculations

Below is an example of how a gradebook with three weighted categories, Exams (20%), Assignments (40%), and Quizzes (40%), would calculate a student's grade.

Image of example calculations for categories and weighting.

The Gradebook calculates the weighted average in each Category by doing the following:

  1. Totaling the student's scores for all graded items in the Category
    • In the example, in Exams, Student 0181 earned: Final Exam (95 points) + Midterm Exam (40 points) = 135 points
  2. Totaling the point values for all graded items in the Category
    • Final Exam (95 points) + Midterm Exam (40 points) = 150 total points
  3. Dividing the student's score by the total points and then multiplying that number by 100 to determine the Category average:
    Student 0181's Category average in Exams is 90%:
    • 135/150 = 0.90
    • 0.90 x 100 = 90%
  4. Applying the weight to the Category average
    Because the Exams Category is worth 20% of the course grade, Student 0181's weighted average is 18:
    • To get 20% of a number, multiply the number by 0.2.
    • 90 x 0.2 = 18

Tip: The Category average is shown in a column to the right of the Gradebook items in that Category.

The Gradebook totals the weighted averages to produce the course grade.

If Student 0181 received a Category average of 75% for Assignments and 85% for Quizzes, that student's course grade would be 82%, calculated as follows:

  • Exams (20%) weighted average (shown above) = 18
  • Assignments (40%) weighted average = 0.4 x 82.5 = 33
  • Quizzes (40%) weighted average = 0.4 x 93 = 37.2
  • Course Grade = 18 + 33 + 37 = 88