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:
Alejandra, I ran this query
List of Attendance Percentages for Students by Counselor/Teacher and School for a Specific School Year
Provides Attendance History information with calculated percentages for student enrollment for a specific school year sorted by School and Counselor/Teacher Name
LIST STU TCH AHS STU.ID STU.SC STU.NM TCH.TE AHS.SP AHS.EN AHS.AB AHS.PR (( 1.0 * AHS.PR/AHS.EN * 100 )) BY AHS.SCL IF AHS.EN # 0 AND AHS.YR = "20##-20##" AND AHS.SCL = STU.SC AND LOC.U = 0
(Extract to Excel)
Once in Excel I came up with this but can easily change it to show student names
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"
Alejandra, I've looked into that sort of computation before and I couldn't find any way to do it inside of Aeries - sad, because I agree that it's super-useful.
The query worked great once I removed the ATT
We are a hosted district.
Our cabinet would like a month by month comparison between this year and last year on chronic absenteeism for the district as a whole.
Ex: Aug 2021: 30% Aug 2022: 23%
Can someone help?
It seems that you are get in combining Aeris tables. I need to run a report with percentage per semester for our student. but also need to run it every two weeks to see if they show improvement. Something that will give me like the image below, without me going one by one. Can you help??
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.
1 person has this question