Forum Discussion
Analyze Student Attendance Data
I have a very large spreadsheet with over 15K rows. The spreadsheet is an export from our student information system of student attendance data for the second reporting term (10/11/23 - 12/21/23). ...
What do the attendance codes mean?
Which one(s) should we include to measure attendance?
What is the home room? The grade level?
Thanks! Does this do what you want?
- Unfortunately, it does not. Looking at student 11071, they were in attendance for 34 out of 42 days. Their attendance would be 81%.
Each homeroom attendance should calculate a unique value based on the student attendance. Column L in your example is the value I'm looking for.Rockiesfan My apologies, stupid mistake on my side.
The formula in I2 should be
=COUNTIFS($A$2:$A$15078,H2,$C$2:$C$15078,"IA*")/COUNTIFS($A$2:$A$15078,H2)
Fill down from there.