To Query Student Attendance Percentages by Primary Teacher at a Flex Daily Attendance School


1. Navigate to the Query Page


2. Run the following Query to Include the Independent Study Complete Codes

LIST STU AHS STU.SC STU.ID STU.NM STU.GR  PRIMARYTEACHERNAME  AHS.YR AHS.EN  AHS.PR AHS.AB AHS.SP (( LEFT ( (( 100 * (( AHS.PR + AHS.ISC )) / AHS.EN )) , 5 ) + "%" )) AHS.ISC AHS.ISI BY  PRIMARYTEACHERNAME  (( 100 * AHS.PR / AHS.EN )) ^ IF AHS.YR =  "20xx-20xx" AND AHS.EN > 0 AND STU.SC = AHS.SCL AND ( AHS.ISC > 0 OR AHS.ISI > 0 )

  • Replace the xx values with the current year (example:  2025-2026)


3.  Run the following Query to not include the Independent Study Complete Codes


LIST STU AHS STU.SC STU.ID STU.NM PRIMARYTEACHERNAME   AHS.SP AHS.EN AHS.AB AHS.PR (( LEFT ( (( 100 * AHS.PR / AHS.EN )) , 5 ) + "%" )) BY PRIMARYTEACHERNAME  (( 100 * AHS.PR / AHS.EN )) ^ IF AHS.YR =  "20xx-20xx" AND AHS.EN > 0 AND STU.SC = AHS.SCL

  • Replace the xx values with the current year (example:  2025-2026)