You can assign weights for calculating GPAs either on course records in Records or by defining the weights on translation tables in Registrar Setup in Configuration. 

Note: Do not weight GPAs using both methods, which would create double-weighted grades causing inaccurate GPA, honor, and rank calculation results.  

Weighting on Translation Tables:

To weight on a translation table, add a value to the grade point for each passing grade awarded in the course. For example, to reward students who pass honors courses with one higher grade point than students who pass standard courses, define both a Standard Translation Table and an Honors Translation Table.

Standard Translation TableHonors Translation Table
Letter GradeGrade Point ValueLetter GradeGrade Point Value
A4A5
B3B4
C2C3


When you associate translation tables with marking columns in Grading information on course records, associate the Standard Translation Table with standard courses and the Honors Translation Table with honors courses.

You can select the formulas not including "Weight" in the Sum of field on the GPA calculation:  

  • Mark
  • Mark * Earned Credit
  • Mark * Attempted Credit 

Note: To edit the GPAs on a translation table select View, GPA view from the menu bar of the translation table. 


Weighting on Translation Tables: Calculating both Unweighted and Weighted GPAs


If you add weights on translation tables, you can still calculate both unweighted and weighted GPAs. To do so, you must define two GPA types in the GPA table, one for Weighted and one for Unweighted. 

  • On the Standard Translation Table, complete the GPA Equivalent column for the Unweighted Grade Point Value only. On the Honors Translation Table, complete the GPA Equivalent column for both the Unweighted GPA type and the Weighted GPA type.
  • Define two identical GPA calculations, except associate one with the Unweighted GPA Type and one with the Weighted GPA type.

Weighting on Course Records:

You can select a weight on the course record if you add or multiply by a value to award higher grade points. Do not weight on the course record if you do not want to award extra points to students who enroll in, but fail, advanced classes.

 You can use weights on course records for another purpose if needed. For example, to include total attempted credits in a GPA calculation, considering defining the weight of a course as the total attempted credits and including Weight in the GPA calculation formula.

 You can select the formulas including "Weight" in the Sum of field on the GPA calculation: 

  • Mark + Weight
  • Mark * Weight
  • (Mark + Weight) * Earned Credit
  • (Mark + Weight) * Attempted Credit
  • (Mark * Earned Credit) + Weight
  • (Mark * Attempted Credit) + Weight
  • Mark * Earned Credit * Weight
  • Mark * Attempted Credit * Weight

Weighting on Course Records: Calculating both Unweighted and Weighted GPAs

If you add weights on course records, you can still calculate both unweighted and weighted GPAs. To do so, you must define two GPA types in the GPA table and add weights to course records for only one of the GPA types. 

  • For example, define GPA types for School GPA and College GPA. You define two GPA types because you weight certain courses for in-house GPAs, but must provide unweighted GPAs for college transcripts. 
  • On the translation table, complete the GPA Equivalent column for both GPA types with the same unweighted values.
  • Define two identical GPA calculations, one associated with the School GPA type and one associated with the College GPA type.  
  • Open each advanced placement course record, select the GPA types and enter a weight of 1.00 for the School GPA type. You can include both GPA types so the program includes grades awarded in the classes of the courses when calculating GPAs regardless of the GPA type for which you run the calculation.

    Note: Another way to achieve the same outcome is to define the calculation for the School GPA type as Mark + Weight, but define the calculation for the College GPA type as Mark. In this way, you make sure that no weights are added to GPAs calculated for colleges, even if a weight is mistakenly entered on a course record for the College GPA type.