Understanding and Verifying Your GPA in Aeries: A Comprehensive Guide
The Grade Point Average (GPA) is a crucial metric that reflects a student's academic performance. For educational institutions utilizing the Aeries Student Information System, understanding how GPAs are calculated and how to verify them is paramount. This guide delves into the intricacies of GPA management within Aeries, empowering students, parents, and administrators with the knowledge to navigate this essential academic component.
The Foundation: Aeries GPA Configurations
At the heart of GPA management in Aeries lies the GPA Configurations page. This powerful feature, accessible to System Administrators, allows districts to meticulously define and customize how GPAs are calculated. It provides the framework for both Aeries's built-in GPA options and the creation of unique, district-defined GPAs. Without this foundational configuration, the subsequent GPA calculations would lack the necessary structure and parameters.
A key aspect of the GPA Configurations page is its ability to enable or disable various GPA calculation methods. This ensures that the system aligns with the specific academic policies and reporting requirements of each district. The availability of the GPA Configurations page is contingent upon a System Administrator enabling it, often through special instructions involving a hidden Feature Flags page. This underscores the administrative control and deliberate implementation required for GPA customization within the Aeries environment.
Navigating District-Defined GPAs
The District GPAs section within the GPA Configurations page serves as a central repository for all GPA calculations relevant to a district. This includes Aeries's standard, built-in GPAs, which are often active by default. However, districts possess the flexibility to inactivate these built-in options if they wish to exclusively utilize their own custom-defined GPAs. This allows for a tailored approach to GPA calculation, ensuring that the system precisely mirrors the district's academic philosophy.
To inactivate an Aeries Built-in GPA, a user with appropriate permissions would navigate to the GPA list, select the desired GPA, and access its details. Within the "Edit District GPA Details" window, the status can be changed from "Active" to "Inactive." It is important to note that inactivating certain built-in GPAs can have downstream effects on transcript definitions. For instance, if the "Weighted Academic GPA" and "Weighted Total GPA" are inactivated, the "Weighted GPA" option may no longer be available on the Transcript Definition - GPA Options tab for enhanced, single-column transcripts. Similarly, specific inactivations will remove the corresponding GPA options (Weighted GPA, Unweighted GPA, Academic GPA, Total GPA, Academic 10-12 GPA) from transcript displays.
Read also: Check GPA Online
Beyond managing built-in options, districts can also introduce their own District-defined GPAs. The process begins by clicking the "Add District GPA" button, which opens the "Add District GPA Details" window. This window is divided into several crucial sections:
General Info: This section requires essential details for the custom GPA. A Short Name (limited to 6 characters) and a Long Name (limited to 20 characters) provide concise and descriptive identifiers. The Status field determines whether the GPA is active or inactive. A Description field allows for further clarification of the GPA's purpose. Crucially, this section also includes options to Calculate Weighted GPA and Calculate Non-Weighted GPA. Both can be selected simultaneously, but this necessitates the addition of a Weight Factor for the weighted calculation, in addition to the automatically generated "Regular Weight Factor." The Calculate Using option dictates the basis of the GPA calculation: either "Credits Attempted" (the default) or "Courses Taken," which results in a simple average of grade points divided by the number of transcript records. Finally, the Show on Printed Transcript option, which defaults to checked, controls whether the District-defined GPA appears on the one-column enhanced transcript.
Course Selection: This section offers granular control over which courses are included in the GPA calculation. Two primary options exist:
- Courses: This method allows GPA calculation to be based on specific fields within the Courses page. For example, a district might choose to include all courses where the
CRS.NAfield (indicating Academic, Non-Academic, or Honors status) does not equal 'N'. This would encompass Academic and Honors courses while excluding Non-Academic ones. Various conditions and comparisons (Equals, Not Equal, IN, Greater than, Less than, etc.) can be employed to refine this selection. TheINcomparison is particularly useful for including a list of specified values, separated by commas. Special handling is required for comparisons involving no data or blank fields, using single or double quotes. - Course Characteristics: This approach leverages the characteristics defined for a course on the "Characteristics" tab of the Courses page. Transcript records with matching characteristics in the Course History Characteristics (
CHC) table will be included. - Off Grade Course Inclusion: This option allows for the inclusion of "Off Grade Courses" in the GPA calculation, based on configurations in the Off Grade Courses page.
- Important Note: If no Course Selection data is entered, all courses will be included in the GPA calculation. Conversely, if no courses meet the specified criteria or the criteria are missing, the GPA will default to 0.00.
- Courses: This method allows GPA calculation to be based on specific fields within the Courses page. For example, a district might choose to include all courses where the
Rank: This section governs class ranking. The Rank Type must align with the selected Weighted or Non-Weighted GPA option. Rank Groups allow for the grouping of students into a specified number of deciles or other divisions (0 to 100), rather than assigning individual ranks. A Rank Group of 0 (the default) creates individual ranks based on class size. Calculate Top % enables ranking for a specific percentage of students, while Display Top % to Parents and Students controls whether this limited rank is visible on transcripts and in the Parent/Student Portal. If no ranking is desired, all rank-related fields should be set to 0.
Languages for GPA Labels: This feature supports translations for GPA labels, ensuring they display correctly on student transcripts in multiple languages.
Read also: Check Your Loan Balance
Student Statuses to Include: This critical section allows districts to specify which student status tags should be considered when calculating GPA, Class Rank, and Class Size. For instance, including early graduates ensures their academic achievements are factored in. Conversely, unselected inactive tags will result in GPA recalculations being excluded and Class Rank/Size being zeroed out during the recomputation process. It's also noted that if a student belongs to multiple GPA cohorts, the GPA record in the non-natural cohort will be updated, but Class Rank and Size will not be affected.
After configuring these details, clicking "Save" stores the changes, and "Continue" progresses to the next section.
Subject Area Thresholds: Refining GPA Calculations
The Subject Area Thresholds section provides a sophisticated mechanism for limiting the number of semester grades or credits per subject area that contribute to the GPA calculation. This feature works in tandem with the Course Selection criteria defined in the District GPA Details. Aeries first identifies transcript records that meet the Course Selection criteria and then further refines this selection by limiting those records to courses within the specified Subject Areas. The system then prioritizes the highest marks within each subject area, up to the defined maximum number of grades or credits.
A key option within this section is "Use course weight when determining which transcript records will provide the highest marks." When selected, this option utilizes the District GPA Weight Factors to ascertain the highest grade point value within each subject area. If this option is not selected, the unweighted grade point value is used for this determination.
The Subject Area dropdown is populated with subject areas defined in the Graduation Requirement (REQ) table for School 0 (District Level). Each subject area can only be selected once per District GPA. A warning message will appear if a duplicate selection is attempted. The Maximum Semester Grades/Credits to Include field requires a numeric value specifying the limit for each subject area. Decimal values are permissible, but zero is not an acceptable entry.
Read also: Verifying Education: The Role of Background Checks
To add a new Subject Area Threshold, click the "+Add Subject Area Threshold" button. After selecting a subject area and entering the maximum, click "Save changes." While the maximum values can be edited, the selected Subject Areas themselves cannot be altered after saving. To remove a threshold, click the "Delete" button and then "Save changes."
Once Subject Area Thresholds are established, clicking "Continue" leads to the Schools and Cohorts section.
Schools and Cohorts: Assigning GPAs to Specific Groups
The Schools and Cohorts section is where District-defined GPAs are assigned to specific schools and student cohorts. Only schools designated as Secondary or Flexible with grade levels 9 and above appear in this listing.
Key columns in this section include:
- Selected: A checkbox to include the school/cohort in the District-defined GPA.
- School: The name of the school. A school may appear multiple times if it has various cohorts.
- Cohort: The available cohorts at the listed school.
- Other District GPAs Applied: Displays any existing District-defined GPAs assigned to this school and cohort.
- Natural Grade: The expected current grade level of the cohort.
- Lock Class Ranks: When enabled, class rank calculations are locked to the selected cohort and grade.
- Primary GPA: This designates the District-defined GPA that will serve as the Term GPA on transcripts for that specific school and cohort. Only one Primary GPA can be assigned per school and cohort.
- Include Other Cohorts for this Grade: If checked, this option ensures that students in other cohorts within the same grade level are included in the GPA calculation. This is beneficial for students who have advanced or are behind their natural grade progression.
GPA Weight Factors: Assigning Value to Marks
GPA Weight Factors are the mechanism by which districts assign specific point values to different marks earned by students, thereby influencing the final GPA calculation. When a District GPA is created, a "Regular Weight Factor" is automatically generated. By default, all weight factors are initialized with 0 Grade Points for all marks. Therefore, it is essential to assign appropriate grade points to each mark before calculating GPAs.
The "Do Not Include in GPA" column provides a crucial function: it allows districts to exclude specific marks entirely from the GPA calculation. If a checkmark is placed in this column for a particular mark, that mark will be disregarded when computing the GPA.
To understand how these weight factors are applied, it's essential to examine the Valid Marks page, accessible through the Grade Reporting node. This page defines all marks used on report cards and transcripts. For each mark, several critical settings exist:
- Count in GPA Computation: Determines if the mark contributes to the GPA calculation.
- Count as Attempted: Indicates if the mark counts towards attempted credits.
- Count as Completed: Indicates if the mark counts towards completed credits.
- Default Gradebook % Range Low and High: These fields allow for the definition of default percentage ranges for each mark, which can be utilized in the Gradebook.
- Point value in GPA computation: This area includes fields for Non-honors, Honors, and Non-academic courses. These fields must contain a value for each mark defined. If a mark is not used in GPA calculation, it should be assigned a zero in these fields.
The "Weight Advanced Placement Courses/IB Courses" option allows for differentiated point values for Advanced Placement (AP) and International Baccalaureate (IB) courses. The values defined here are instrumental in computing the GPA, where Grade Points are multiplied by the Credit Value and then divided by the Total Credits attempted.
Important Note: Courses designated as "College Credit Only" (CRS.CL=23) are excluded from all GPA calculations.
Add-On Weighted GPAs: An Alternative Calculation Method
Beyond traditional GPA calculations, some institutions employ alternative methods for weighted GPAs, often referred to as "Add-On Weighted GPAs." Aeries facilitates this through the "W" setting in the School Settings form. This feature allows for the storage of Add-On Weighted GPAs either within the standard weighted GPA fields or in separate fields, enabling the retrieval and display of both traditional and add-on weighted GPAs.
The Aeries system stores various GPA types, credits, and class rankings within the Student (STU) table. These include:
Cumulative GPAs (calculated from Course History - HIS):
- Weighted: Total GPA (TP), Academic GPA (GP), Grades 10-12 Academic GPA (CP).
- Non-weighted: Total GPA Non-weighted (TPN), Academic GPA Non-weighted (GPN), Grades 10-12 Academic GPA Non-weighted (CPN).
- Associated fields for Credit Attempted (CA), Credit Completed (CC), Class Rank (CR), and Class Size (CS) are also stored.
Current GPAs (calculated from current marking period in Grade Reporting - GRD):
- Weighted: Grades Total GPA (GT), Grades Academic GPA (GA).
- Non-weighted: Grades Total GPA Non-weighted (GTN), Grades Academic GPA Non-weighted (GAN).
- Associated fields for Credit Attempted (GDC), Credit Completed (GDC), Rank (GK), and Size (GS) are stored.
Citizenship GPAs: Cumulative Citizenship GPA (CCG) and Grades Citizenship GPA (GCG).
University of California and California State University entrance qualifications: Fields such as Number of Grade Points (PTS), Preliminary Academic GPA (PUC, PCS), and qualification indicators (QUC, QCS, CUC, CCS, CCO) are maintained.
When the "Do Not Weight Honors" option is selected, weighted and unweighted GPA fields will be identical unless specific point values are defined on the Valid Marks page. Options 8 or 9 on the Aeries Variables for Current School form trigger a configuration form for calculating Add-On Weighted GPAs, which can be based on a fixed value per honors course or a more complex calculation involving the sum of honors courses passed, optionally with a per-term maximum.
Understanding GPA Field Codes and Definitions
The Aeries database stores GPA information using specific field codes within the Student (STU) table. These codes are essential for querying and reporting on GPA data.
Cumulative GPAâs, calculated from Course History (HIS), weighted:
- TP (TGPA): Total GPA - Includes all courses taken.
- GP (AGPA): Academic GPA - Excludes non-academic courses (marked with 'N' in
CRS.NA). - CP (CGPA): Grades 10-12 Academic GPA (also known as College GPA) - Excludes non-academic courses and courses taken in grade 9.
Cumulative GPAâs, calculated from Course History (HIS), non-weighted:
- 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:
- GT (GTGPA): Grades Total GPA.
- GG (GAGPA): Grades Academic GPA.
Current GPAâs, calculated from the current marking period in the Grade Reporting (GRD) table, non-weighted:
- GTN (GTGPAN): Grades Total GPA Non-weighted.
- GGN (GAGPAN): Grades Academic GPA Non-weighted.
Note: Courses designated as College Credit Only (CRS.CL=23) are excluded from all GPA calculations. Weighted GPAs incorporate extra grade points for honors courses (marked with 'H' in CRS.NA), while non-weighted GPAs do not.
Verifying GPA Calculations: View GPA Calculation Page and Report
Aeries provides two primary tools for verifying how a student's GPA was calculated: the View GPA Calculation page and the GPA Calculations Report. These tools are accessible at the school level and display detailed information used in the GPA computation, provided a record exists in either the Built-in GPA (BGV) table or a custom District GPA (DGV) table. Running the "Recompute GPA" function updates these tables, replacing existing records with the latest calculation details.
All courses completed in grades 9-12, along with any grade 7-8 courses designated as Off Grade Courses, are included in the GPA calculation. If a course is excluded, the reason for its exclusion is clearly displayed.
Security Permissions: Access to the View GPA Calculation page and the GPA Calculations Report requires specific Read permissions to the "Transcript View GPA Calculation Button" within the Transcripts table. These reports are not available to Parent or Student Portal Groups. Other portal groups with the necessary permissions will see the "View Calculation" button on the Transcripts page.
Accessing View GPA Calculation:
- Navigate to Grades > Transcripts.
- For Aeries Built-in GPAs, select the "View GPA Calculation" button next to the desired GPA.
- For Custom District GPAs, select the "View Calculation" button next to the custom GPA.
- An option to "Sort by Subject Area" may be available to summarize the GPA by subject.
Accessing GPA Calculations Report:
- Navigate to Reports > GPA Calculation Report while logged into a school.
- The report can be run for specific students, grade levels, or counselors, and it sorts by grade level and student name by default.
Report Header and Details:
The report header provides essential context, including the School Name, Date of Report, Student Name and ID, Student's Current Grade Level, the GPA name and value for the student, and the Date the GPA was last updated. Last updated information is specifically available for custom District GPAs.
The detailed report includes:
- Course ID, Course Title, Service ID/State Course Code: Identifies the course.
- Term, Grade, Repeat Tag, Mark: Details of the course completion.
- Weighted Category: The name of the GPA Weight Factor scale used.
- Grade Points: Total points for each mark based on the Weight Factor scale.
- Courses Taken or Credits Attempted: Based on GPA Configurations.
- Total Earned: Calculated as Grade Points x Courses Taken or Grade Points x Credits Attempted.
- Summary Totals: A breakdown of Courses Taken/Credits Attempted and Total Earned by Academic Year or Subject Area.
- GPA Calculation: The final GPA is calculated as the sum of Total Earned divided by the sum of Courses Taken or Credits Attempted.
tags: #how #to #check #gpa #on #aeries

