# Difference between revisions of "Calculate grades in Gradebook"

Line 12: | Line 12: | ||

In the example pictured above, Student Five earned a total of 72 points out of 80 total points possible. His course grade is 72/80 = 0.90 (90%). | In the example pictured above, Student Five earned a total of 72 points out of 80 total points possible. His course grade is 72/80 = 0.90 (90%). | ||

− | ''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. | + | ''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 80 total points. However, Student Three has not received a grade for Homework 2 (10 points possible). Thus, her course grade is 59/70 = 0.8429 (84.29%).'' | + | ''In the example pictured above, most students were graded out of 80 total points. However, Student Three has not received a grade for Homework 2 (10 points possible). Thus, her course grade is 59/70 = 0.8429 (84.29%).'' |

+ | ==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 '''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 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=== | ||

+ | [[File:Categories with Drop Lowest-Highest.png|frame|center]] | ||

+ | |||

+ | 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 our example, Student Five received the following grades: | ||

+ | |||

+ | Assignments: | ||

+ | *Assignment 1 (10 points) | ||

+ | *Assignment 2 (8 points) (lowest grade - dropped) | ||

+ | |||

+ | Quizzes: | ||

+ | *Quiz 1 (9 points) | ||

+ | *Quiz 2 (19 points) | ||

+ | |||

+ | Since the Assignment 2 grade is dropped for Student Five, his course grade is 95%: | ||

+ | |||

+ | 10 + 9 + 19 = 38 points earned | ||

+ | 38/40 = 0.95 | ||

+ | |||

+ | ===Categories with Keep Highest=== | ||

+ | [[File:Categories with Keep Highest.png|frame|center]] | ||

+ | |||

+ | Pictured above is a '''Gradebook''' with two categories: '''Assignments''' and '''Quizzes'''. 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. | ||

+ | |||

+ | In our example below, we will use the '''Keep Highest''' option versus '''Drop Lowest''' to show how it affects Student Five's course grade. | ||

+ | |||

+ | ===Before all grades are entered for Student Five - Keep Highest 2 Assignments=== | ||

+ | [[File:Before all grades are entered for Student Five - Keep Highest 2 Assignments.png|frame|center]] | ||

+ | |||

+ | Before the third assignment grade is entered, Student Five 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 Five'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. | ||

+ | |||

+ | ===After all grades are entered for Student Five - Keep Highest 2 Assignments=== | ||

+ | [[File:After all grades are entered for Student Five - Keep Highest 2 Assignments.png|frame|center]] | ||

+ | |||

+ | Now we enter the third assignment grade. The highest two assignment grades are kept, so the lowest assignment grade (Assignment 3) is dropped: | ||

+ | |||

+ | Assignments: | ||

+ | *Assignment 1 (10 points) (1st highest grade - kept) | ||

+ | *Assignment 2 (8 points) (2nd highest grade - kept) | ||

+ | *Assignment 3 (7 points) (lowest grade - dropped) | ||

+ | |||

+ | Quizzes: | ||

+ | *Quiz 1 (9 points) | ||

+ | *Quiz 2 (19 points) | ||

+ | |||

+ | Student Five's grade is still 92%: | ||

+ | |||

+ | 10 + 8 + 9 + 19 = 46 points earned | ||

+ | 46/50 = 0.92 | ||

+ | |||

+ | Keeping the highest grades instead of dropping the lowest grades ensures that Student Five's grade is calculated out of the same number of total points (50 points) both before and after entering the third assignment grade. | ||

+ | |||

+ | If the '''Drop Lowest''' option had been used instead, the calculated course grade for Student Five would have been calculated out of 40 points before entering the third assignment grade. The course grade would have decreased significantly after the third assignment grade was entered, going from an A (95%) down to an A- (92%). | ||

+ | |||

+ | ==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% (or more, if there is an '''Extra Credit''' category). | ||

+ | |||

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

+ | |||

+ | [[File: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..png|frame|center]] | ||

+ | |||

+ | ===The '''Gradebook''' calculates the weighted average in each category by:=== | ||

+ | |||

+ | #Totaling the student's scores for all graded items in the category. In the example pictured above, in Exams, Student One earned: Final Exam (95 points) + Midterm Exam (40 points) = 135 points. | ||

+ | #Totaling the point values for all graded items in the category. Final Exam (95 points) + Midterm Exam (40 points) = 150 total points. | ||

+ | #Dividing the student's score by the total points, then multiplying that number by 100, to determine the category average. Student One's category average in Exams is 90%: 135/150 = 0.90. 0.90 x 100 = 90%. | ||

+ | #Applying the weight to the category average. Because the Exams category is worth 20% of the course grade, Student One'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 One received a category average of 75% for Assignments and 85% for Quizzes, his course grade is 82%, calculated as follows: | ||

+ | |||

+ | *Exams (20%) weighted average (shown above) = 18 | ||

+ | *Assignments (40%) weighted average = 0.4 x 75 = 30 | ||

+ | *Quizzes (40%) weighted average = 0.4 x 85 = 34 | ||

+ | *Course Grade = 18 + 30 + 34 = 82 | ||

## Revision as of 20:30, 24 July 2020

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.

## Contents

## No categories

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

In the example pictured above, Student Five earned a total of 72 points out of 80 total points possible. His course grade is 72/80 = 0.90 (90%).

*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 80 total points. However, Student Three has not received a grade for Homework 2 (10 points possible). Thus, her course grade is 59/70 = 0.8429 (84.29%).*

## 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 **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 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

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 our example, Student Five received the following grades:

Assignments:

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

Quizzes:

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

Since the Assignment 2 grade is dropped for Student Five, his course grade is 95%:

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

### Categories with Keep Highest

Pictured above is a **Gradebook** with two categories: **Assignments** and **Quizzes**. 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.

In our example below, we will use the **Keep Highest** option versus **Drop Lowest** to show how it affects Student Five's course grade.

### Before all grades are entered for Student Five - Keep Highest 2 Assignments

Before the third assignment grade is entered, Student Five 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 Five'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.

### After all grades are entered for Student Five - Keep Highest 2 Assignments

Now we enter the third assignment grade. The highest two assignment grades are kept, so the lowest assignment grade (Assignment 3) is dropped:

Assignments:

- Assignment 1 (10 points) (1st highest grade - kept)
- Assignment 2 (8 points) (2nd highest grade - kept)
- Assignment 3 (7 points) (lowest grade - dropped)

Quizzes:

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

Student Five's grade is still 92%:

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

Keeping the highest grades instead of dropping the lowest grades ensures that Student Five's grade is calculated out of the same number of total points (50 points) both before and after entering the third assignment grade.

If the **Drop Lowest** option had been used instead, the calculated course grade for Student Five would have been calculated out of 40 points before entering the third assignment grade. The course grade would have decreased significantly after the third assignment grade was entered, going from an A (95%) down to an A- (92%).

## 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% (or more, if there is an **Extra Credit** category).

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

### The **Gradebook** calculates the weighted average in each category by:

- Totaling the student's scores for all graded items in the category. In the example pictured above, in Exams, Student One earned: Final Exam (95 points) + Midterm Exam (40 points) = 135 points.
- Totaling the point values for all graded items in the category. Final Exam (95 points) + Midterm Exam (40 points) = 150 total points.
- Dividing the student's score by the total points, then multiplying that number by 100, to determine the category average. Student One's category average in Exams is 90%: 135/150 = 0.90. 0.90 x 100 = 90%.
- Applying the weight to the category average. Because the Exams category is worth 20% of the course grade, Student One'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 One received a category average of 75% for Assignments and 85% for Quizzes, his course grade is 82%, calculated as follows:

- Exams (20%) weighted average (shown above) = 18
- Assignments (40%) weighted average = 0.4 x 75 = 30
- Quizzes (40%) weighted average = 0.4 x 85 = 34
- Course Grade = 18 + 30 + 34 = 82