To calculate total yearly attendance percentage for all schools and students:
1. Navigate to the Attendance History Configuration Page
- Run the Update All Schools Now process
- This will update the AHS for all schools and students through the current day (last day of the calendar if this is done after the last day of school)
- Once this process is complete, move to Step 2
2. Query the student's Days of Enrollment and Days Present from Attendance History (AHS)
LIST STU AHS STU.SC STU.ID STU.NM AHS.EN AHS.PR BY AHS.SCL IF AHS.EN > 0 AND AHS.YR = "20xx-20xx" AND AHS.SCL = STU.SC
Change the xx's to the current year (ex: 2024-2025)
Include Inactive Students to get all students enrolled within the year
Click on the Excel button on the Query Page
3. Save the Excel document
4. Go to the bottom of the document
Using a formula total the Enrollment and Present columns
Using a formula divide the Present column by the Enrollment column in the cell to the right
Example: =(E7368/D7368)
Format the column as a Percentage
