Skip to content

Calculating Final Grades with Incomplete Category

December 12, 2018

In Quickschools, the school administrators can decide how the Gradebook will treat a case when a student does not have grades for a specific column or category. This can be configured on the Grading Setup screen, under the section Gradebook Formula Behavior.

 

In this example, we have the Final Grade column with the weight formula 50% Test, 10% Recitation, 20% Quiz, 20% Assignment, for a total of 100%.

 

Set the Gradebook Formula Behavior to Show Incomplete if you want the formula to populate an “I” instead of a number. In the illustration below, the student is missing a grade in the category Quiz, which is 20% of the required weight factor to compute the Final Grade.

 

Otherwise, set it to Re-normalize if you want the system to calculate the formula as though you never asked to include the “unfulfilled” category to begin with, instead of showing Incomplete. The system will then divide the grade to the total available weights, in this case 80, then computes the percentage to get 100 (See below).

Computation: ((90 x 0.20) + (87 x 0.10) + (95 x 0.50)) / 80 x 100 = 92.75

 

If you’re ever concerned that a formula isn’t calculating accurately, please let us know. It’s always a good idea to verify the calculations on your end, either by hand or on an Excel sheet, to see if the result of the formula still seems incorrect. And if you do see a discrepancy, definitely contact QuickSchools so we can look into the issue.

No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s