Track attendance or grades

I have this class roster and weekly attendance sheet. Send the attendance column for Week 3 to Priya in Student Services and to Noah, the head teacher, asking them to confirm absences by Friday so I can flag truancy. Before sending, make sure every student row has a student ID, a last name, and that no attendance cell is blank or marked with ambiguous notes like 'late?'.

Before I share this attendance sheet with parents, make it clear and hard to misread. Put total absences for the term at the top, highlight any student with three or more unexcused absences, make the date columns narrow and the name column wide, and flag any rows with missing IDs or comments that need resolution so a reviewer can sign off fast.

I sent Week 3 attendance to Student Services and Noah and Priya replied that several rows lack student IDs and some dates show 'present/absent' in the same cell. I need to get a clean list before Friday to meet the truancy-report deadline. Which problems should I fix first, what exact edits do I make so Priya trusts the sheet, and what short message do I send her after fixing it?

Every week I lose hours reconciling names, missing student IDs, and inconsistent attendance entries. I want a practice that stops this recurring back-and-forth so I can file truancy reports without chasing teachers. Which single habit change or sheet feature should I adopt now, how do I roll it out to the team, and what two quick rules do I enforce to keep the sheet clean?