Student attendance register in Excel (free monthly template)

A class attendance register that does the counting for you. Mark each day with P, A or L, and the workbook gives daily totals, each student’s monthly and yearly percentage, and highlights anyone falling below the attendance you require.

What each month looks like

RollStudent123…31PresentWorking days%
1Student namePPA…P212391%
2Student namePLP…P222396%
3Student nameAAP…A162370% ⚠

What’s in the file

Setup

School, class, section, session start month, the minimum attendance you require (75% by default) and the student list, typed once.

Twelve monthly sheets

Names and dates fill in from Setup. Mark H in the header row for holidays and Sundays; they turn grey, and the percentage counts only the days you mark.

Codes

P for present, A for absent, L for leave, H for half day (counted as 0.5). Anything else is rejected, so typos don’t slip through. Absences show in red.

Year summary

Month-by-month percentage for each student, the year total and a flag for anyone below your minimum, ready for the TC and the report card.

How to use it

  1. Type the class details and student list on the Setup sheet.
  2. On each month’s sheet, put H in the header row for holidays so they are not counted as working days.
  3. Mark P, A, L or H every day. Totals and percentages update as you type.
  4. Use the Summary sheet at the end of a term for report cards and parent meetings.

Questions

What attendance percentage do CBSE students need?

CBSE’s examination bye-laws set 75% attendance as the requirement for appearing in Class 10 and 12 board exams, with condonation possible in limited cases. The template uses 75% as its default threshold, and you can change it on the Setup sheet.

Does leave count as present?

By default L does not count as present, but it is shown separately so you can treat approved leave the way your school’s policy says.

How many students does it hold?

Up to 60 per class sheet. Make a copy of the file for each section.

Can parents see this?

Not from a spreadsheet. If you want parents alerted the same day their child is marked absent, that needs an attendance app connected to the parent’s phone.

When the spreadsheet stops being enough

With School Vion teachers mark attendance on their phone in under a minute, and parents get an alert the same morning when their child is absent.

See School Vion →