Your privacy choices

KiwiBee uses optional Google Analytics, Google Ads, and Meta Pixel cookies to understand adult visitors, measure completed sign-ups, and improve campaigns. Essential cookies always stay on. OpenAI’s ChatGPT Ads Pixel also measures page views and completed enquiries after advertising consent, and may use hashed contact details for matching. Privacy policy

Skip to main content
Excel template

Student Attendance Tracker

StudentsXLSXEnglish

What's inside

A preview of the first rows. The file adds drop-down lists, formulas that fill in by themselves and room for more rows.

Monthly attendance register

P = present, A = absent, L = late, E = excused absence. Leave days with no school empty.

Class
Month
Teacher
No.Student name123456…PresentAbsentLateExcusedAttendance %
Example: Mai TranPPLPAP

Sheet: Attendance · 35 rows

How to use it

  1. Write your class, month and name in the boxes at the top.
  2. Type your students' names in the Student name column.
  3. Each day, pick P, A, L or E from the drop-down in that day's column.
  4. Read the totals and attendance rate on the right; copy the sheet for the next month.

About this document

A one-month class register for teachers and form tutors. Choose a code for each student on each school day, and the sheet counts days present, absent and late and works out the attendance rate for you.

Comments

    Student Attendance Tracker – Free Excel Template | KiwiBee