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 | CUC | Course Completion for University of California (UC) entrance (Y/N). This looks at course completion requirements only. This field is used for state reporting. |
CCS | CCS | Course Completion for California State University (CSU) entrance (Y/N). This looks at course completion requirements only. This field is used for state reporting. |
CCO | CCO | Course Completer Override (Y/N). This field is used to override the automatic calculation for purposes of state reporting. |