Attendance register format: the columns that actually matter
A register has one job — to answer "what is this student's percentage, and on what" without anyone recounting. Most formats fail at the denominator rather than the layout. Here is what to include, and the one rule people get wrong.
What should an attendance register contain?
An attendance register needs the roll number and name, the date with its period or subject, a present/absent/late mark, a reason field for documented absences, a running count of classes held, and a calculated percentage. The percentage must be counted on classes held — not on days the school was open.
Count classes held, not days the school was open
This is the single most common error, and it changes the number. If your period did not run — a holiday, an exam, a cancelled slot — it is not a class the student missed, and it must not sit in the denominator. A register that counts calendar days understates every honest student and, in a board year, understates them below a threshold that matters.
- Denominator = classes actually held for that subject
- Not school working days, and not calendar days
- Cancelled and exam periods excluded, not marked absent
- Attend 40 of 50 classes held and the figure is 80%
Six columns, and nothing decorative
A register grows unusable when it collects fields nobody reads. What is needed is the identity of the student, the date and period, the mark, and a reason only where a reason changes the arithmetic — a documented medical absence is not the same as an unexplained one.
- Roll number and name — the roll number is what the office matches on
- Date and which period or subject, not just the date
- Present / absent / late, with late defined somewhere
- A reason field used only for documented absences
- A running count of classes held, kept per subject
- The percentage, calculated rather than typed
The 75% rule, stated carefully
Most Indian boards require 75% attendance for exam eligibility, counted on classes held. CBSE's own compliance notice sets that figure and allows a relaxation of up to 25% for documented exigencies — medical grounds, sport, and similar. Schools are usually asked to compute and submit the position early in the exam year, but the exact date moves, so check the circular in force for your session rather than trusting any page, this one included.
- 75% of classes held is the usual requirement
- Up to 25% relaxation for documented exigencies
- The shortfall is found in November, not discovered in February
- A student at 60% with 20 classes left reaches 64% — arithmetic worth doing early
Paper, spreadsheet or app — what each costs you
The paper register
Fine for marking, and the marking was never the problem. Adding up 180 days across 40 students at term end is.
An Excel template
Does the arithmetic, if the formula is right and nobody sorts a column by hand. The denominator mistake usually lives here.
A printed grid per month
Readable at a glance, which is its real strength. Keep the classes-held count in the same sheet or the percentage drifts.
An app
Marks in seconds and calculates as it goes. The advantage is not the marking; it is that the percentage exists before anyone asks.
Per-subject registers
Necessary once subjects have different numbers of periods. One combined register cannot produce an honest per-subject figure.
Whatever the office accepts
The register has to produce a file someone else can read. An Excel export is usually what settles that.
About the format and the rules
What columns does an attendance register need?
Roll number, name, the date with its period or subject, the mark (present, absent or late), a reason field used only for documented absences, a running count of classes held, and the calculated percentage. Anything beyond that tends to go unfilled.
Is attendance counted on working days or on classes held?
On classes held for that subject. A period that did not run is not a class the student missed. Counting calendar days understates every student, and in a board year it can understate them below the eligibility threshold.
What is the minimum attendance for a board exam?
Most Indian boards ask for 75% of classes held. CBSE's compliance notice sets that figure and allows up to 25% relaxation for documented exigencies. The submission dates move between sessions, so check the circular in force for yours.
How do I calculate the percentage?
Classes attended divided by classes held, times 100. Attend 40 of 50 and it is 80%; 24 of 34 is 71%. The division is trivial — keeping an accurate count of classes held is the part that goes wrong.
Can I keep a separate register per subject?
Yes, and once subjects have different period counts you have to. A single combined register cannot produce an honest per-subject percentage.
Can I get the register as an Excel file?
Yes. Veda keeps the register as you mark it and exports it to Excel when the office or a parent needs the document.
Do I need an app for this?
No — a paper register marks attendance perfectly well. What an app changes is that the percentage is already calculated, so a shortfall shows up in November rather than at the end of the year.
Also: take attendance online · the attendance app · record grades · student reports · free teacher tools
The format matters less than the denominator.
Free on Google Play. Veda keeps the register on classes held and calculates the percentage as you mark, so November tells you what February would.