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.
1 row per student with
total absences in year,
total attended present days,
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.
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"
The query worked great once I removed the ATT
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:
...though any mention of Chronic Absenteeism is strangely absent on this page: