Grade Book Calculations and Formulas with Examples

Here are descriptions and examples for each of the 3 grade book calculation methods:

1. Total Points: In this calculation method, the students’ cumulative grade is based on the total points earned divided by the total points attempted. Select this option if the cumulative grade is based on straight points, and you do not take into account the type of assignment when calculating the grade.

Formula

sum(assignment grade * assignment factor) / sum(maximum points * factor) = Total cumulative grade

 

CALCULATION EXAMPLE 

A class has five total assignments and one extra credit (EC) assignment. Each assignment is worth 4 points, and each has a factor of 1. The students receives the full 4 points on all regular assignments, and 3 points on the extra credit assignment.

To calculate the total cumulative grade for the class, we must first add up the total points the student earned for all assignment types, multiplied by the assignment factor.

Assignment 1: 4 * 1 = 4

Assignment 2: 4 * 1 = 4

Assignment 3: 4 * 1 = 4

Assignment 4: 4 * 1 = 4

Assignment 5 (EC): 3 * 1 = 3

Total = 19

Then sum up all the assignment maximum point values multiplied by the assignment factor, excluding any extra credit assignments.

Assignment 1: 4 * 1 = 4

Assignment 2: 4 * 1 = 4

Assignment 3: 4 * 1 = 4

Assignment 4: 4 * 1 = 4

Total = 16

Next, divide the sum of the points earned by the sum of the maximum points.

This is your cumulative grade.

19 / 16 = 1.1875

118.75%

2. Total Points with Weight: In this calculation method, the students’ cumulative grade is based on the total points a student earned, divided by the total points attempted within each assignment type. The assignment type grades are then averaged together based on their weights. Select this option if the cumulative grade is based on something like 30% homework, 40% quizzes, and 30% exams, but each assignment within those categories is worth varying points.

Formula

For each assignment type: sum(assignment grade * assignment factor) / sum(maximum points * factor) = Assignment type grade

Then: sum(assignment type grade * weight) / sum(weight) * 100 = Total cumulative grade

CALCULATION EXAMPLE

A class has five total assignments and one extra credit (EC) assignment. Each assignment is worth 4 points, and each has a factor of 1. The students receives the full 4 points on all regular assignments, and 3 points on the extra credit assignment.

To calculate the total cumulative grade for the class, we must first calculate the assignment type grade.

For each assignment, divide the assignment grade by the assignment factor.

Add the sums together.

Assignment 1: 4 * 1 = 4

Assignment 2: 4 * 1 = 4

Assignment 3: 4 * 1 = 4

Assignment 4: 4 * 1 = 4

Assignment 5 (EC): 3 * 1 = 3

Total = 19

Then sum up all the assignment maximum point values multiplied by the assignment factor, excluding any extra credit assignments.

Assignment 1: 4 * 1 = 4

Assignment 2: 4 * 1 = 4

Assignment 3: 4 * 1 = 4

Assignment 4: 4 * 1 = 4

Total = 16

Next, divide the sum of the points earned by the sum of the maximum points. This is your assignment type grade.

19 / 16 = 1.1875

Apply weights to each assignment type grade by multiplying each assignment type grade by it’s weight.

Homework: 1.1875

Weight: 50%

1.1875 * 0.50 = 0.5938

Classwork: 0.9102

Weight: 50%

0.9102 * 0.50 = 0.4551

Add all the weighted grades together, and divide by the sum of the weights. Multiply by 100.

This is your cumulative grade.

Assignment type grades: 0.5938 + 0.4551 = 1.0489

Weights: 0.5 + 0.5 = 1

1.0489 / 1 = 1.0489

104.89%

3. Percentages: The assignments are averaged together within each assignment category, the average is used to calculate the cumulative grade based on the weights the teacher has entered. Select this option if the cumulative grade is based on something like 30% homework, 40% quizzes, and 30% exams, but each assignment within those categories count equally.

Formula

For each assignment type: sum(assignment grade / maximum points * assignment factor) / sum(factor) = Assignment type grade

Then: sum(assignment type grade * weight) / sum(weight) * 100 = Total cumulative grade

CALCULATION EXAMPLE

A class has five total assignments and one extra credit (EC) assignment. Each assignment is worth 4 points, and each has a factor of 1. The students receive the full 4 points on all regular assignments, and 3 points on the extra credit assignment.

To calculate the total cumulative grade for the class, we must first calculate the assignment type grade.

For each assignment, divide the assignment grade by the maximum points, and multiply by the assignment factor.

Add the sums together.

Assignment 1: (4 / 4 * 1) = 1

Assignment 2: (4 / 4 *1 ) = 1

Assignment 3: (4 / 4 * 1) = 1

Assignment 4: (4 / 4 * 1) = 1

Assignment 5 (EC): (3 / 4 * 1 ) = .75

Total = 4.75

Then sum up all the assignment factors, excluding any extra credit assignments.

Assignment 1: 1

Assignment 2: 1

Assignment 3: 1

Assignment 4: 1

Total = 4

Next, divide the assignment averages by the sum of the factors. This is your assignment type grade.

4.75 / 4 = 1.1875

Apply weights to each assignment type grade by multiplying each assignment type grade by it’s weight.

Homework: 1.1875

Weight: 50%

1.1875 * 0.50 = 0.5938

Classwork: 0.9102

Weight: 50%

0.9102 * 0.50 = 0.4551

Add all the weighted grades together, and divide by the sum of the weights. Multiply by 100.

This is your cumulative grade.

Assignment type grades: 0.5938 + 0.4551 = 1.0489

Weights: 0.5 + 0.5 = 1

1.0489 / 1 = 1.0489

104.89%

SET DISPLAY OPTIONS

1. Select Display Options.

2. Use the options to control how information will display.

Note: Grade books must be set up per Year in order to display a Year Cumulative.

3. Select Save & Close.