Calculating Total and Weighted Total in the Gradebook

About Totals

Current Gradebook calculations for Total and Weighted Total include item that have not been scored. For example, picture a course where the grade is determined by two tests weighted equally. Using the current Gradebook settings, a Student with a score of 90 percent on the first quiz would have a weighted total of 45 percent. This shows that the student has accumulated a score of at least 45 percent in the course.

A new option to ignore ungraded items, or nulls, when calculating the total and weighted total appears in Application Pack 3. In the example above, the student's progress would be reported as 90 percent.

When nulls are ignored, the Total and Weighted Total columns in the Gradebook are renamed to Running Total and Running Weighted Total.

Calculating the Total and the Weighted Total

The table below details how Student progress is calculated in the Gradebook. Running Total and Running Weighted Total are calculated without including ungraded items (nulls).

 

Calculated Item

Weight-by

Display Option / Calculation

Formula

Total & Running Total

 

Points Possible

(Item.PointsPossible)

Total

 

Score

(Item.Attempt.PointsGiven)
 

Running Total

 

Score

Same as Total above
 

Total

 

Percentage

(Item.Attempt.PointsGiven)  / 
(Item.PointsPossible)
 

Running Total

 

Percentage

(Item.Attempt.PointsGiven)  / 
(Item.PointsPossible

    not including items where Attempt.PointsGiven=NULL)
 

Weighted Total & Running Weighted Total

Item

Points Possible

(Item.PointsPossible * Item.Weight)

Weighted Total & Running Weighted Total

Category

Points Possible

(Item.PointsPossible * Category.Weight)

Weighted Total

Item

Score

(Item.Attempt.PointsGiven * Item.Weight)

Weighted Total

Category

Score

(Category1 Attempt.PointsGiven) * Category1.Weight +
(Category2 Attempt.PointsGiven) * Category2.Weight +
(Category3 Attempt.PointsGiven) * Category3.Weight +

Running Weighted Total

Item

Score

Same as Item Weighted Total above

Running Weighted Total

Category

Score

Same as Category Weighted Total above
 

Weighted Total

Item

Percentage

[ (Item.Attempt.PointsGiven / Item.PointsPossible) * Item.Weight]

/
(Item.Weight)
 

Weighted Total

Category

Percentage

[ (Item.Attempt.PointsGiven / Item.PointsPossible) * (Category.Weight / Category.Number-Of-Items) ]
/

(Category.Weight)

Running Weighted Total

Item

Percentage

[ (Item.Attempt.PointsGiven / Item.PointsPossible) * Item.Weight]
/

(Item.Weight not including items where Attempt.PointsGiven=NULL)

Running Weighted Total

Category

Percentage

[ (Item.Attempt.PointsGiven / Item.PointsPossible) * (Category.Weight / Category.Number-Of-NonNULL-Items) ]
/

(Category.Weight not including where ALL items Attempt.PointsGiven=NULL)

The table shows that when calculated based on Points Possible ignoring ungraded items has no effect.

 

 

Tip: The Running Total and Running Weighted Totals should use the Percentage or Letter Grade display option when ignoring ungraded items. This will display student performance only on completed items.

 

Set the Total or Weighted Total to Ignore Ungraded Items

The ability to include or ignore ungraded items is not available in all courses. The Administrator must first turn on the feature. Existing courses will continue to include ungraded items until this feature is enabled in the specific course. After confirming that the option is available, follow the steps below to set the Gradebook to ignore ungraded items.

  1. Open the Gradebook.

  2. Click Total or Weighted Total. After setting one to ignore or include ungraded items, be sure to set the other one.

  3. Click Item Information.

  4. Select Yes or No for Ignore Ungraded Attempts.

Example Calculation using Ignore Ungraded Items

The example below shows how ignoring ungraded items will affect the reported progress for one user throughout a course. Keep in mind:

 

The table below shows the Total and Weighted Total displayed after each assignment is completed. Ungraded items are included in the calculation. The formulas to generate the Total and Weighted Total are:

 

Gradebook Item

Grade

Total

Weighted Total

Quiz 1

85

10%

4%

Quiz 2

90

22%

9%

Test 1

88

33%

18%

Quiz 3

75

42%

21%

Quiz 4

80

52%

25%

Paper

90

63%

52%

Test 2

80

73%

60%

Final Exam

92

85%

88%

Final Grade

 

 

88%

 

The table below shows the Running Total and Running Weighted Total displayed after each assignment is completed. Keep in mind that ungraded items are included in the calculation. The formulas to generate the Total and Weighted Total are:

 

Gradebook Item

Grade

Running Total

Running Weighted Total

Quiz 1

85

85%

85%

Quiz 2

90

88%

88%

Test 1

88

88%

88%

Quiz 3

75

84%

86%

Quiz 4

80

84%

85%

Paper

90

85%

87%

Test 2

80

84%

86%

Final Exam

92

85%

88%

Final Grade

 

 

88%

 

For some added insight into Gradebook calculations look at how the Running Weighted Total is calculated after the Student received a grade on the Paper. Remember that the formula to calculate the Running Weighted Total is:

[ (Item.Attempt.PointsGiven / Item.PointsPossible) * (Category.Weight / Category.Number-Of-NonNULL-Items)] / (Category.Weight not including where ALL items Attempt.PointsGiven=NULL)

 

Q1: [(85/100) * (.2/4)] = .0425

Q2: [(90/100) * (.2/4)] = .045

T1: [(88/100) * (.2/1)] = .176

Q3: [(75/100) * (.2/4)] = .0375

Q2: [(80/100) * (.2/4)] = .04

P : [(90/100) * (.3/1)] = .27

Sum                     = .611

Running Total           = .611/.7 = .873