Attendance Register Format for Tuition and Coaching Classes (Free Excel and PDF)

The student attendance sheet format, column by column

Both downloads follow the same layout, so a teacher can move between the paper register and the Excel sheet without relearning anything.

The four codes

The Excel file also has a second sheet called How to use, which repeats these codes and the steps below, so you can hand the file to another teacher without a long explanation.

How to write an attendance register by hand

1. Fill the top first: institute, batch, teacher's name, month and year. Use one page per batch per month.
2. Write the students in roll-number order and keep that order all year, so each student sits on the same line every month.
3. Mark attendance at the same point in every class, ideally in the first few minutes, from the register itself rather than from memory later.
4. Use only the four codes, written as capital letters in pen, one letter per box.
5. On holidays and weekly offs, write H down the whole column, so a blank box always means not marked yet.
6. Never overwrite. If you mark wrongly, strike through once, write the right code beside it and initial it.
7. At the end of the month, count P, L and A for each student, write them in the total columns and work out the percentage using the method below.
8. Sign and date the bottom of the page. If an owner or coordinator checks registers, they sign too.

Ticks and crosses look quicker, but they cannot tell late from present, and a cross can easily be turned into a tick. Letters are harder to alter and easier to count.

How to make an attendance register in Excel

You can simply download our Excel sheet, or build the same thing yourself in a few minutes. Either way, it helps to know how the formulas work so you can trust the totals.

1. In rows 1 to 4, type Institute, Batch, Teacher and Month and year, with the values beside them.
2. In row 5, type Roll no. in A5 and Student name in B5, the numbers 1 to 31 in C5 to AG5, then Present, Late, Absent and Attendance % in AH5 to AK5.
3. Enter roll numbers and names from row 6 down to row 45.
4. In AH6, AI6, AJ6 and AK6, type the four formulas shown below, and format AK6 as a percentage.
5. Select AH6 to AK6 and drag the fill handle down to row 45, so every student gets the same formulas.
6. Optional: select C6 to AG45, open Data, then Data Validation, choose List and type P,L,A,H in the Source box. Each day cell then offers a drop-down with only the four codes, which stops typing mistakes.
7. Optional: freeze panes at cell C6, so the names and day numbers stay in view while you scroll.

The formulas for row 6 (Excel adjusts them for each row when you drag them down)

Present, in AH6: =COUNTIF(C6:AG6,"P")

Late, in AI6: =COUNTIF(C6:AG6,"L")

Absent, in AJ6: =COUNTIF(C6:AG6,"A")

Attendance %, in AK6: =IF(AH6+AI6+AJ6=0,"",(AH6+AI6)/(AH6+AI6+AJ6))

COUNTIF counts the cells in a range that match a value, and it ignores capital and small letters, so p and P both count. The percentage is (AH6+AI6)/(AH6+AI6+AJ6), wrapped in IF so the cell stays blank until at least one class has been marked instead of showing an error. H and blank cells are not counted anywhere, which is what you want for holidays and for the days before a student joined.

For the next month, make a copy of the sheet inside the same file, rename the tab to the new month, and clear the day cells C6 to AG45. The formulas stay in place. If you also want a daily headcount, add a row under the last student and put =COUNTIF(C6:C45,"P")+COUNTIF(C6:C45,"L") under day 1, then copy it across to day 31.

Working out the monthly attendance percentage

The register treats a late arrival as attended and leaves holidays out entirely. So the formula is: attendance % = (days present + days late) divided by (days present + days late + days absent), multiplied by 100.

If late arrivals are a real problem in a batch, you may decide on your own rule, for example that three lates count as one absence. If you do, write the rule on your fee plan or notice board before you apply it, apply it to every student, and change the formula yourself, since the template counts every late as attended.

Holidays, weekly offs and late joiners

• Holidays and weekly offs: mark H for the whole batch. These days drop out of the percentage, so a festival week does not pull anyone's attendance down.
• A class you cancel: mark H as well. Attendance should measure the student, not your timetable.
• A student on leave with a note: still mark A, and write the reason in a remarks line at the bottom of the page. The count stays honest and you can explain it to the parent.
• Late joiners: leave the days before they joined blank and start marking from their first class. Write the joining date next to the name, for example Joined 14 Oct. Blank days are ignored, so the percentage is fair from day one.
• Students who leave: stop marking, write Left on [date] next to the name and keep the row. Do not delete it, because who attended when matters if a fee or refund question comes up later.
• Batch changes: end the row in the old batch with Moved to [batch] on [date] and start a new row in the new batch's register.
• Extra or make-up classes on a holiday: mark that day normally for that batch instead of H.

Larger coaching centres may also have timing rules to follow. The Ministry of Education's model guidelines for coaching centres, which apply the term to centres coaching more than 50 students, ask for a weekly off for students and tutors, leave planned around major local festivals, and coaching of no more than 5 hours a day. These guidelines were sent to states to adopt through their own rules, so check what your state has put in place.

Telling parents about attendance each month

A short monthly message works better than calling only when something has gone wrong. Send each parent their own child's numbers, never the whole batch list.

Monthly attendance message in English

Hello [Parent name], [Student name]'s attendance in [batch] for [month]: present [P] days, late [L] days and absent [A] days out of [total] classes, which is [percentage]%. [One line: Good going. / Please help them attend regularly. / We missed them on [dates].] Do call me on this number for anything. [Teacher name], [Institute name]

मासिक उपस्थिति संदेश हिंदी में

नमस्ते [अभिभावक का नाम] जी, [महीना] में [बैच] में [छात्र का नाम] की उपस्थिति: कुल [कुल] कक्षाओं में से [P] दिन उपस्थित, [L] दिन देर से और [A] दिन अनुपस्थित, यानी [प्रतिशत]%। [एक पंक्ति: बहुत अच्छा चल रहा है। / कृपया नियमित भेजें। / [तारीखों] को कक्षा में नहीं आए।] किसी भी बात के लिए इसी नंबर पर बात करें। [शिक्षक का नाम], [संस्थान का नाम]

When to call instead of sending a message

• Attendance drops below a line you set in advance, for example 80%.
• Three absences in a row with no reason given.
• A pattern, such as missing every test day or every Monday.

More ready-to-send texts, including fee reminders and holiday notices, are in our guide to WhatsApp messages for tuition classes.

Keeping registers safe and private

• Keep paper registers in one place at the centre, not in a teacher's bag.
• In Excel, keep one file per batch per year with one sheet per month, and back it up at the end of each month.
• Share attendance with each family privately. A batch-wide list in a WhatsApp group shows every child's record to every parent.
• Keep old registers rather than throwing them out at the end of the session. The Ministry of Education's model guidelines leave the detail of record keeping to what each state government prescribes, so check your state's coaching rules.

Doing this on Sikhami

Sikhami gives institutes a free set of tools that includes attendance. You create a batch with its weekly timetable, add your students, and mark each one present, late or absent for every class of that batch, so the record builds up class by class instead of being added up at the end of the month. A batch can also store the Meet or Zoom link you use for live classes; the class itself runs on that service, not on Sikhami. Fee plans in instalments and the fee book, with numbered fee receipts, sit in the same institute account. It works on the web and on Android. If paper or Excel suits you better, the downloads above do the job; Sikhami simply keeps batches, attendance, fees and courses in one place. See Sikhami for institutes.

Common attendance register mistakes

• Filling the register later from memory instead of during the class.
• Mixing ticks, crosses and letters on the same page.
• Leaving holidays blank, so nobody can tell a holiday from a day that was never marked.
• Deleting the rows of students who left.
• Counting lates as absences without ever telling parents that rule.
• Posting the whole batch's attendance in a parents' group.