How Grade Exemptions Affect Calculations

Grade exemptions affect any calculation that depends on the values of the constituent grade items.

Category scores that include exemptions

For category scores, grade exemptions affect the scores as follows:

  • Exempted grade items are excluded from the calculation of category scores. The grade item is treated as though it does not exist within the category.
  • In a category with drop rules, exempted items are removed before the specified number of grade items are dropped. Then, the category is calculated with the remaining items.
  • If all the items in a category are exempted, there are no grade item scores to use in calculating a category score. In this case, the category does not have a score.
  • In a weighted grade book, the exemption of a category item results in the remaining item weights not reaching 100%. Brightspace Learning Environment automatically scales the weights of the remaining items proportionally to each other.

Calculated grade items that include exemptions

For calculated grade item scores, grade exemptions affect the scores as follows:

  • Exempted items are excluded from the calculated score.
  • If all items in a calculated grade item are exempted, the item does not have a calculated score.

Final Grades that include exemptions

For final grade items, grade exemptions affect the scores as follows:

  • Exempted items are excluded from the calculation. These grade items are treated as empty grades, not as 0.
  • If all items are exempted, there are no grades to use to calculate a final grade. The final grade will not have a score.

Formula grade items that include exemptions

For formula grade items, grade exemptions affect the scores as follows:

  • Formulas treat exemptions as empty (null) grades; however, the Treat Ungraded Items as 0 setting is ignored. If a learner is exempted from a grade, then the exemption and its cascading results are treated as null.
  • If a formula grade item used in another formula and the former is empty (null), then it is treated as though it were exempted during the formula calculation.

The following table describes the updated evaluation rules for formulas:

Evaluation Rule

Result

For Single grades
If a grade item is exempt Null
If a grade item has no value, and Drop Ungraded Items is turned on Null
If grade item has no value, and Treat Ungraded Items as 0 is turned on 0
If a grade item has a value [value]
Addition/Subtraction (+/-)
If both sides are exempt Null
If one side is exempt and the other side has no value, and Drop Ungraded Items is turned on Null
If one side is exempt and the other side has no value, and Treat Ungraded Items as Zero is turned on 0
If both sides are empty, and Drop Ungraded Items is turned on Null
If both sides are empty, and Treat Ungraded Items as Zero is turned on 0
If one side has a value (+/-) [Value]
Multiplication/Division (*//)
If either side is exempt Null
If either side is empty, and Drop Ungraded Items is turned on Null
If either side is empty, and Treat Ungraded Items as Zero is turned on 0
If both sides have a value [Result]
Equality (=)
If both sides are exempt True
If both sides are empty and Drop Ungraded items is turned on True
If both sides are empty and Treat Ungraded Items as Zero is turned on True
If both sides have different values False
If one side is exempt and the other side is empty and Treat Ungraded Items as Zero is turned on False
If one side is exempt and the other side has a value False
Inequality (<>)
If both sides are exempt False
If both sides are empty and Drop Ungraded items is turned on False
If both sides are empty and Treat Ungraded Items as Zero is turned on False
If both sides have different values True
If one side is exempt and the other side is empty and Treat Ungraded Items as Zero is turned on True
If one side is exempt and the other side has a value True
Greater/Less than (>/<)
Both sides have values Appropriate True/False
If one side is exempt False
If one side is empty and Drop Ungraded Items is turned on False
If one side has a value and the other side is empty and Treat Ungraded Items as Zero is turned on Appropriate True/False
Greater/Less Than or Equal (>=/<=)
Both sides have values Appropriate True/False
If both sides are exempt True
If both sides are empty and Drop Ungraded Items is turned on True
If one side has a value and the other side is exempt False
If one side has a value and the other is empty and Drop Ungraded Items is turned on False
If one side has a value and the other side is empty and Treat Ungraded Items as Zero is turned on. Appropriate True/False