Grade Points in Double Digit Value
Table of Contents
Overview
Grade Points can be defined in the Grade Settings record.
Certain educational institutions award their students with Grade Points that are in double-digit values. As an example, "HD - High Distinction" below:
Grade Range | Grade Points | Grade Result | Grade Value |
85 - 100 | 10 | Pass | HD - High Distinction |
75 - 84.9 | 9 | Pass | D - Distinction |
65 - 74.9 | 8 | Pass | CR - Credit |
50 - 64.9 | 5 | Pass | PS - Pass |
0 - 49.9 | 0 | Fail | FL - Fail |
Since EDA does not support double-digit GPA values, RIO Education behaves in the same manner.
If the above details are setup as the Grade Setting records in RIO Education, you may encounter an error during the grade release process. See more information on the error here.
Workaround
Taking the same example above, convert the Grade Point values by dividing the Grade Point values into 2.
For instance, instead of entering a Grade Point of "10" for the Grade Range of 85-100, you enter "5".
Grade Range | Grade Point | Grade Result | Grade Value |
85 - 100 | 10/2 = 5 | Pass | HD - High Distinction |
75 - 84.9 | 9/2 = 4.5 | Pass | D - Distinction |
65 - 74.9 | 8/2 = 4 | Pass | CR - Credit |
50 - 64.9 | 5/2 = 2.5 | Pass | PS - Pass |
0 - 49.9 | 0 | Fail | FL - Fail |
When releasing the grade of a Course Connection, the converted Grade Point will be taken. So, if the student manage to obtain a Grade of 95, the Grade Point awarded will be 5 instead of 10.
Of course the calculation to the GPA values at the Program Enrollment and PE Pathway records will be affected - showing incorrect value. What you need to do is to create the following:
- A formula field in the Program Enrollment (PE) object that takes the calculated GPA value and multiplies it by 2.
- A formula field in the PE Pathway (PEP) object that takes the calculated GPA value and multiplies it by 2.
- Replace both the standard GPA fields in PE and PEP layouts with the newly created formula fields so that the users will see the correct values.
You may also need to create the following:
- A formula field in the Course Connection object that takes the Grade Point value and multiplies it by 2.
- Replace the standard Grade Point field in CC layout with the newly created formula field. Also ensure that you expose this formula field (hide the standard Grade Point column) to the student through the Student Community/portal.
The calculated outcome should look like this:
Course | Grade | Credits Attempted | Grade Point (Workaround) | Grade Point (Workaround) x Credits Attempted | Grade Point (Original) | Grade Point (Original) x Credits Attempted |
Manage Meeting | 95 | 3 | 5 | 15 | 10 | 30 |
Economics I | 75 | 3 | 4.5 | 13.5 | 9 | 27 |
Accounting I | 75 | 3 | 4.5 | 13.5 | 9 | 27 |
Statistics I | 90 | 3 | 5 | 15 | 10 | 30 |
Total | 12 | 57 | 114 |
Calculation (Workaround):
= Total of (Grade Point (Workaround) x Credits Attempted) / Total of Credits Attempted
= 57/12
= 4.75
To get the actual GPA, 4.75 x 2
= 9.5 (which matches the original value without conversion.)
Calculation (Original without conversion):
= Total of Grade Point / Total of Credits Attempted
= 114/12
= 9.5