For Texas users, once Graduation Endorsements have been created, students can be added to them. As the student plans, enrolls in, or receives credit for a course or courses in the endorsement, the student's status within the endorsement will be calculated and then displayed on the student's Profile and Graduation Status pages. It will also be displayed on the Academic Plan in the Endorsement View area.
For California users, once Add-On Graduation Endorsements have been created, students can be added to them. As the student plans, enrolls in, or receives credit for a course or courses in the Add-On Graduation requirement, the student's status within the endorsement will be calculated and then displayed on the student's Profile and Graduation Status pages. It will also be displayed on the Academic Plan in the Add-On Graduation View area.
The progress towards achieving each Endorsement/Add-On Graduation Requirement is displayed as a fraction on the summary page. Clicking on the fraction will open a window and display the courses completed, currently enrolled, and planned.
Managing Endorsements/Add-On Graduation Requirements on a Student's Record
On each student's Profile, Graduation Status and Academic Plan page, the Add-On Graduation Requirement/Endorsement widget will display the student's status within any Graduation Requirement. To view a student's Add-On Graduation Requirement widget, a user will need Read permissions to GES. To add or delete a Graduation Requirement from a student's record, a user will need Update permissions to GES.
Click the Manage button to add a Graduation Requirement/Endorsement:
The Graduation Requirements/Endorsements management window will open. Existing Graduation Requirements/Endorsements will be displayed along with the current status for the student's Add On Graduation Requirements/Endorsements. Additionally, a students can opt out of Endorsements or a student's current progress towards completing a Graduation Requirement/Endorsement can be overridden.
To add a Graduation Requirement/Endorsement place a check mark in the checkbox to the left of any Graduation Requirement/Endorsement that should be added to the student's record. When all desired Graduation Requirements have been added click the the Save button to close the Graduation Status/Endorsement management window.
The Graduation Requirement(s) will be added to the student and will display under the Pursuing Endorsements header. The remaining Add-On Graduation Requirements/Endorsements will display under the Other Possible Endorsements header. Their status will be calculated and displayed on the Add-On Graduation Requirement/Endorsement widget on the student's Profile and Graduation Status pages.
Opting a Student Out of Add-On Graduation Requirements/Endorsements
11th and 12th grade students can opt-out of Add-On Graduation Requirements/Endorsements. To opt a student out click the Manage button on the student's Add-On Graduation Requirement/Endorsement widget. The Graduation Requirements/Endorsements management window will open. A checkbox is provided to opt a student out of all Graduation Requirements. In order to opt out a student, a user will need Update permissions to STU.
If a student has opted out of Graduation Requirements, the Add / Delete button will no longer display on the widget.
A confirmation window will appear asking if you are sure you want to opt the student out of Endorsements. To continue opting the student out click the OK button.
A confirmation message will appear with the Opt-Out box checked to confirm that the student will be opt-out. Click the Save button if you want to continue.
If the Opt-Out option was saved, a notice will appear on the student's Add-On Graduation/Endorsement widget that the student has opted-out of Endorsements.
To remove a student's Op-Out status, click on the Manage button that opens the Graduation Requirements/Endorsements management window. The Endorsement Opt-Out window will open instead. Remove the check mark from the Opt-Out option.
Once the check mark is removed the Endorsement options will be listed and can be added to the student's record. When done selecting Endorsement options click the Save button to close the window.
Overriding a student's Add-On Graduation Requirement/Endorsement Status
A student's Add-On Graduation Requirements/Endorsement status can be overridden and manually set. To change a student's status click on the Manage button to open the Graduation Requirements/Endorsements Management window. Use the Status Override boxes to select a new status for a student's.
The options available are: Not Set, No Information, Planned, In Progress, On Track, Complete, Not on Track and Incomplete. Once a new status has been selected click the Save button to close the window.
The student's Add-On Graduation Requirement/Endorsement status will be updated to the manually set status. A note will display stating that the status was manually overridden.
Note: Seniors will automatically have Incomplete set for any Endorsement if they have not completed the requirements and have a Graduation code set in the STU.HSG field.
Mass Update Endorsement Status
To mass update Endorsement status, use the following steps in Aeries Query:
The example below changes the status of the Public Service endorsement (PS) to In-Progress (IP) for all 11th grade students.
- Execute a KEEP to get the group of students who have a particular endorsement code, status, and grade level.
KEEP STU IF GES.EC = "XX" AND GES.ST # "YY" AND STU.GR = NN
where:
XX = the endorsement code
YY = the endorsement status
NN = grade level of students
Example:
KEEP STU IF GES.EC = "PS" AND GES.ST # "IP" AND STU.GR = 11
where:
PS = Public Service endorsement
IP = In Progress status
NOTE: You can also use the Student Multi-Search feature to obtain this list. - Set the Manual Override flag for the students.
CHANGE GES MO TO 1 IF GES.EC = "XX" AND GES.ST # "YY" AND STU.GR = NN
Example:
CHANGE GES MO TO 1 IF GES.EC = "PS" AND GES.ST # "IP" AND STU.GR = 11 - Set the Opt-in flag for the students.
CHANGE GES OI TO 1 IF GES.EC = "XX" AND GES.ST # "YY" AND STU.GR = NN
Example:
CHANGE GES OI TO 1 IF GES.EC = "PS" AND GES.ST # "IP" AND STU.GR = 11 - Change the current status of the selected endorsement to the new status.
CHANGE GES ST TO "XX" IF GES.EC = "YY" AND STU.GR = NN
Example:
CHANGE GES ST TO "IP" IF GES.EC = "PS" AND STU.GR = 11
NOTE: Once there is a manual override set, you must run the following query to remove the manual override and clear out the status in order for the the automatic endorsement setup to work:
CHANGE GES MO TO 0 ST TO " " IF ID = XXXXX
This sets the Endorsement Status (GES.ST) to blank and the Manual Override (GES.MO) = 0
Additional logic may be added to clear for a group of students.
For example, to clear manual override & the endorsement status for students in grades 9-12:
CHANGE STU GES GES.ST TO " " GES.MO TO 0 IF GES.MO = 1 AND ( STU.GR = 9 OR STU.GR = 10 OR STU.GR = 11 )
Graduation Requirements Status Calculation
The status of a student within a Graduation Requirement is based on the course records in the student's Academic Plan (APC), Transcript (HIS), and current Class Schedule (SEC). The student's status is displayed on their Profile and Graduation Status pages:
Graduation Requirement/Endorsement calculation statuses:
Status: | Including Records in Table(s): | Note: |
Complete | Course History (HIS) | Courses and credits on Transcript fulfill the Graduation Requirement |
On Track | Course History (HIS) Academic Plan (APC) Class Schedule (SEC) | Courses on Transcript or in Academic Plan or in current Class Schedule fulfill the requirements |
Course History (HIS) Class Schedule (SEC) | Student is a 12th grader: courses on Transcript or in current Class Schedule fulfill the requirements | |
Not on Track | Course History (HIS) Academic Plan (APC) Class Schedule (SEC) | Courses on Transcript or in Academic Plan or in current Class Schedule do not meet the requirements |
Course History (HIS) Class Schedule (SEC) | Student is a 12th grader: courses on Transcript or in current Class Schedule do not meet the requirements | |
In Progress | Course History (HIS) Class Schedule (SEC) | Student is in 11th grade or below; some courses in requirements are on the Transcript |
Planned | Course History (HIS) Class Schedule (SEC) | Student is in 11th grade or below; no courses meeting the requirements are on the student's Transcript but courses in the requirements are in the current Class Schedule |
Not Available | Course History (HIS) Class Schedule (SEC) | Student is in 11th grade or below; no courses on Transcript or in current Class Schedule count in a requirement |
Incomplete | Student is in the 12th grade. Endorsement requirements are not complete and student has a graduation code in the STU.HSG field. |
Endorsement calculation of credits:
- A course will only be counted once within a Pathway but may count towards multiple Endorsements or Pathways.
- In Texas, courses with the same Service ID and course sequence will also only be counted up to the max credits allowed within a Pathway.
NOTE: Student's with an Academic Plan will only have a status of 'On Track' or 'Not on Track':
On Track if all courses from HIS + current classes (SEC) + planned classes (APC) meet the requirements of one of the pathways for that endorsement. Otherwise, Not On Track.Querying an Endorsement/Add-on Graduation Requirement Status
A student's status within an Endorsement/Graduation Requirement can be queried. In the following example, the query returns student demographic information along with their overall Opt-out status (STU.EOO), the Graduation Endorsement Code (GES.EC) for any Graduation Endorsement the student has been added to, and the student's status within the Graduation Endorsement (GES.ST).
LIST STU GES STU.ID STU.LN STU.FN STU.GR STU.EOO GES.EC GES.ST? IF GES.EC = HLT
The query displays a "Complete" status for student ID 99400004 and the HLT Graduation Endorsement: