There are several types of Built-in GPA’s, credits, and class rankings that are calculated and stored in the Aeries database.  All fields are stored in the Student (STU)  table.  The credits and class rankings are described in the sections below, along with the Query field codes.  The various GPA’s are defined as:

  • The Total GPA includes all courses that a student has taken.
  • The Academic GPA excludes all non-academic courses.  A non-academic course is any course that has an “N” in the NA field of the Courses (CRS) table.
  • The Grades 10-12 Academic GPA (AKA the College GPA) excludes all non-academic courses and all courses taken when the student was in grade 9.
  • A weighted GPA will include the extra grade points (defined by the district/school) for honors courses that a student has taken.  An honors course is any course that has an “H” in the NA field of the Courses (CRS) table.
  • A non-weighted GPA will not include extra grade points for honors courses that a student has taken.


NOTE:  Courses designated as College Credit Only (CRS.CL=23) will be excluded from all GPA calculations.  


The following GPA’s, credits, and class ranks are stored in the student record, and may be queried using the STU table and the Query field codes that are provided below along with the description of the GPA.


Cumulative GPA’s, calculated from Course History (HIS), weighted:


Field Code
Field Name
Description
TP
TGPA
Total GPA
GP
AGPA
Academic GPA
CP
CGPA
Grades 10 - 12 Academic GPA
CA
Credit Att
Credit Attempted
CC
Credit Cmp
Credit Completed
CR
Class Rank
Class rank based on the school’s selection of the weighted Total GPA (TP), the weighted Academic GPA (GP), the non- weighted Total GPA (TPN), or the non- weighted Academic GPA (GPN). This includes active students and Inactive Graduates (STU.TG > " " OR STU.DG populated)
UR
UC Rank
Class rank based on the Grades 10-12 Academic GPA (CP)
CS
Class Size
Class size including active students and Inactive Graduates (STU.TG > " " OR STU.DG populated)



Cumulative GPA’s, calculated from Course History (HIS), non-weighted:


Field Code
Field Name
Description
TPN
TGPAN
Total GPA Non-weighted
GPN
 AGPAN
Academic GPA Non-weighted
CPN
 CGPAN
Grades 10 - 12 Academic GPA Non-weighted



Current GPA’s, calculated from the current marking period in the Grade Reporting (GRD) table, weighted:


Field Code
Field Name
Description
GT
GTGPA
Grades Total GPA
GG
GAGPA
Grades Academic GPA
GA
Credit Att  
Credit Attempted
GD
Credit Cmp
Credit Completed
GK
GRank
Class rank based on the school’s selection of the Grades Total GPA (GG) or the Grades Academic GPA (GG)
GS
GSize
Class size including active students



Current GPA’s, calculated from the current marking period in the Grade Reporting (GRD) table, non-weighted:


Field Code
Field Name
Description
GTN
GTGPAN
Grades Total GPA Non weighted
GGN
GAGPAN
Grades Academic GPA Non weighted



Citizenship GPA’s:


Field Code
Field Name
Description
CCG  
CCGPA
Cumulative Citizenship GPA calculated from Course History
GCG  
GCGPA
Grades Citizenship GPA calculated from the current citizenship mark in the Grade Reporting (GRD) table



University of California and California State University entrance qualifications:


Field Code
Field Name
Description
PTS
PTS
Number of grade points, used to calculate University of California and California State University GPA’s
PUC
PUC
Preliminary Academic GPA for University of California entrance
PCS
PCS
Preliminary Academic GPA for California State University entrance
QUC
QUC
Qualifies for University of California (UC) entrance (Y/N)
QCS
QCS
Qualifies for California State University (CSU) entrance (Y/N). This looks at courses and other factors like GPA and Test Scores when appropriate.
CUC
CUCCourse Completion for University of California (UC) entrance (Y/N). This looks at course completion requirements only. This field is used for state reporting.
CCSCCSCourse Completion for California State University (CSU) entrance (Y/N). This looks at course completion requirements only. This field is used for state reporting.
CCOCCOCourse Completer Override (Y/N). This field is used to override the automatic calculation for purposes of state reporting.