Start a new topic

Chronic absenteeism and per-student attendance totals?

Can anyone point to simple queries or reports to generate per-student absenteeism rates?  I know this is possible but the existing reports and table structures make it difficult to find and calculate.  


Desired output:  

1 row per student with 

total absences in year, 

total attended present days, 

total tardies, 

total enrolled days, 

(ideal; easy to calculate) percentage of total present days divided by total enrolled days.  


I feel like I've found this before but with extensive searching and reading I can't find what I need at the moment.


Thanks!


I run this query to get the attendance present/ enrolled.  I haven't tried combining with tardies.


LIST STU AHS ATT STU.SC STU.ID STU.LN STU.FN AHS.SCL AHS.EN AHS.AB AHS.PR (( AHS.PR/CAST(AHS.EN AS DEC(10,3) )*100 )) BY STU.SC IF AHS.EN # 0 AND AHS.YR = "2018-2019"


1 person likes this

The query worked great once  I removed the ATT


thanks

Thanks, everyone!  I wound up liking this version:  

LIST STU AHS STU.ID STU.NM AHS.EN AHS.AB AHS.PR (( 100 * AHS.PR/AHS.EN )) AHS.TD (( 100 * ( AHS.PR - AHS.TD ) / AHS.EN )) IF AHS.EN # 0 AND AHS.YR = "2018-2019" 


But in truth I couldn't find a way to make the math worthwhile, since Aeries Query wouldn't let me sort by my computed field, so I have to dump it into a spreadsheet anyhow.  Thus, the simpler version that lets you do your own math:  

LIST STU AHS STU.ID STU.NM AHS.EN AHS.AB AHS.PR AHS.TD IF AHS.EN # 0 AND AHS.YR = "2018-2019" 


Interestingly, most of this query is buried on this page:  

https://support.aeries.com/support/solutions/articles/14000079376-session-270-advanced-query-secondary-schools 

...though any mention of Chronic Absenteeism is strangely absent on this page:  

https://support.aeries.com/support/solutions/articles/14000094509-attendance-queries 


1 person likes this
Login to post a comment