Attendance Register Format for Coaching Classes (Free Excel Template)

Coaching class attendance register template in Excel
On this page
  1. What to include in an attendance register
  2. Sample attendance register layout
  3. How to calculate attendance percentage
  4. Daily routine that keeps the register accurate
  5. Attendance register format for different set-ups
  6. What parents should see
  7. Use attendance as an early warning
  8. Paper register, spreadsheet or software?
  9. Keeping attendance records safe
  10. Frequently asked questions

The right attendance register format for a coaching class has one row per student and one column per class day, with a fixed set of symbols (P, A, L for late, H for holiday), and total and percentage columns at the end of the month. Add the batch name, subject, month and teacher at the top, and keep a column for the parent’s phone number so absences can be followed up the same day.

This guide covers the columns to include, how to mark and total attendance, a sample layout you can copy, and how to turn attendance into an early warning for students who are about to drop out.

Key takeaways

  • Keep one register per batch per month. Mixing batches makes totals unreliable.
  • Agree on symbols and use only those: P, A, L, H, and optionally E for excused.
  • Calculate attendance percentage on classes held, not on calendar days.
  • Two absences in a row is a signal to call the parent, not just a mark in a column.
  • Use a printable sheet for offline batches and automatic attendance for live online classes.

What to include in an attendance register

Header

  • Institute name
  • Batch or class name and timing
  • Subject and teacher
  • Month and year

Columns

  • Serial number and roll number
  • Student name
  • Parent’s phone number (useful for same-day follow-up)
  • One column per class date
  • Total present
  • Classes held
  • Attendance percentage
  • Remarks

Sample attendance register layout

Roll Student Parent phone 3 Nov 5 Nov 7 Nov 10 Nov Present Held %
1 Aarav S. 98xxxxxx12 P P L P 4 4 100
2 Diya K. 97xxxxxx45 P A A P 2 4 50
3 Kabir M. 99xxxxxx78 P P P E 3 3 100

In this layout, late (L) counts as present, and excused (E) is removed from classes held for that student. Decide your own rules once and write them at the bottom of the sheet so every teacher marks the same way.

How to calculate attendance percentage

Attendance % = (classes attended ÷ classes held) × 100.

In Excel or Google Sheets, if dates run from D5 to AH5, you can count presents with =COUNTIF(D5:AH5,"P")+COUNTIF(D5:AH5,"L") and classes held with =COUNTA(D5:AH5)-COUNTIF(D5:AH5,"H")-COUNTIF(D5:AH5,"E"). Divide and format as a percentage. Add conditional formatting to colour anyone below your threshold, for example 75%.

Daily routine that keeps the register accurate

  1. Mark within the first five minutes. Late arrivals get L, not P, so you can see patterns.
  2. Follow up the same day. A short message to the parent of an absent student is more effective than a note at the end of the month.
  3. Total weekly, not just monthly. It takes two minutes and catches problems three weeks earlier.
  4. Lock the month. Once totals are shared with parents, don’t change past marks without a note in remarks.

Attendance register format for different set-ups

The basic layout works everywhere, but small changes make it fit how your classes actually run.

Single-teacher tuition at home

One register for all students is fine if you teach fewer than 15 students across two or three time slots. Add a “Slot” column so you can filter by timing, and keep fee status in a separate sheet so the register stays readable.

Coaching institute with several batches

Use one sheet per batch per month, with the same column order in every sheet. A summary tab can pull each batch’s average attendance so the owner can see at a glance which batch or timing has a problem. Give each teacher edit access only to their own batches.

Subject-wise attendance

When the same batch attends different subjects with different teachers, mark attendance per subject, not once per day. A student who never misses maths but skips chemistry is easy to miss in a daily register.

Hybrid and online classes

Add a column for mode (O for online, C for classroom) or use separate symbols such as PO (present online). For online classes, joining is not the same as attending: decide a rule such as “present if in the class for at least 75% of its length” and apply it consistently.

Test days and extra classes

Mark tests and doubt sessions in the same register with a note in the date header, such as “12 Nov (Test)”. Missing a test is a stronger warning sign than missing a regular class, and it helps when parents ask why a score is missing.

What parents should see

Parents rarely need the full register. A short monthly summary works better:

  • Classes held and attended this month, with the percentage
  • Dates missed
  • Tests missed, if any
  • One line from the teacher on punctuality or participation

Send it on the same day each month, together with test results if you have them. Consistent, factual updates make conversations about attendance much easier when they are needed.

Use attendance as an early warning

Attendance usually falls before a student leaves a coaching class. A simple rule set helps:

  • Two consecutive absences: call or message the parent.
  • Attendance below 75% for the month: a short meeting with the student, and a catch-up plan for missed topics.
  • Regular late marks: check whether the batch timing still works for that student.

Pair attendance with test results. A student whose attendance and scores both drop needs attention first. Our guide to batch management for coaching institutes shows how to keep attendance, tests and classes for one batch in one place.

Paper register, spreadsheet or software?

  • Paper register: simple and reliable in the classroom, but totals take time and are easy to get wrong.
  • Spreadsheet: automatic totals and percentages, easy to share; someone still has to type marks in.
  • LMS with live classes: attendance for online classes can be recorded automatically when students join, so teachers only mark offline sessions.

Download a free, ready-to-print attendance sheet, or make a custom one for your batch with the attendance sheet generator. AcadifyLab records attendance automatically for live classes on every plan; see AcadifyLab for coaching institutes.

Keeping attendance records safe

Attendance registers contain children’s names and parents’ phone numbers, so treat them as private records. Keep paper registers in a locked drawer, share spreadsheets only with the teachers who need them, and don’t post attendance lists in public WhatsApp groups. Keep past registers for at least the current academic session, as parents sometimes ask for records when a student changes schools or applies for a certificate.

Frequently asked questions

What is the format of an attendance register?

An attendance register lists students in rows and class dates in columns, with symbols such as P for present and A for absent in each cell. It ends with totals for classes attended and held, and an attendance percentage. The header records the batch, subject, teacher and month.

How do I calculate attendance percentage for students?

Divide the number of classes the student attended by the number of classes held, then multiply by 100. Count only days when a class actually ran, and decide in advance whether late arrivals and excused absences count.

What symbols are used in an attendance register?

The common symbols are P for present, A for absent, L for late, H for holiday and E or ML for excused or medical leave. Whatever you choose, write the key on the sheet so every teacher uses the same symbols.

Should coaching classes share attendance with parents?

Yes. Parents usually pay the fees and want to know that their child is attending. A same-day message on absence and a monthly summary builds trust and helps you catch problems early.

Should I mark attendance per subject or per day?

If one teacher teaches the whole batch, daily attendance is enough. If different teachers take different subjects, mark attendance per subject so you can see when a student is skipping one subject in particular.

Can I make an attendance sheet in Excel?

Yes. Put student names in rows and dates in columns, use COUNTIF to total P and L marks, and divide by classes held for the percentage. Conditional formatting can highlight students below your attendance target.

Related articles

Scroll to Top
AAcadifyLab
The white-label LMS to launch, sell, and scale your branded learning business.
Get the app
Download on the App StoreGet it on Google Play
Product
FeaturesPricingMobile appsIntegrations
Solutions
Coaching institutesTrainersEnterprisesCase studies
Company
BlogContactPrivacy policyTerms
© 2026 AcadifyLab. All rights reserved.Privacy policy · Terms of service