Forum Discussion
Rockiesfan
Jan 25, 2024Copper Contributor
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). ...
HansVogelaar
Jan 25, 2024MVP
What do the attendance codes mean?
Which one(s) should we include to measure attendance?
What is the home room? The grade level?
Rockiesfan
Jan 25, 2024Copper Contributor
- HansVogelaarJan 25, 2024MVP
Thanks! Does this do what you want?
- RockiesfanJan 25, 2024Copper ContributorUnfortunately, 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.- HansVogelaarJan 25, 2024MVP
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.