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


1 person likes this

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 


3 people like this

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??

image


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.


1 person likes this

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

Image

Login to post a comment