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