School Attendance Register and Report – Free Excel Template
Manage student attendance at schools and educational institutions using this simple free Excel template.
Benefits of the Class Register Excel Template
- To use as an attendance register tool
- To create class attendance reports
- To create student attendance reports
- Can be used in schools and educational institutes
- Can also be used at work places to track employee attendance
For more advanced features, please see Student Attendance Register Excel Template
This template is an upgraded version of the School Attendance Register and Report (Excel template). The enhancements are 1) complete flexibility in choosing weekends and 2) accommodation of entry of late attendance by students.
Free Downloads – Class Register Excel Template
Features of the Class Register Excel Template
- Can track attendance for up to 50 students
- Late attendance by students can be tracked (in addition to Present on Time and Absent)
- Customizable academic window (up to 366 working days)
- Choice for Weekends: You can choose which days of the week and which week days of a month are considered weekends (holidays).
- Up to 20 school Holidays can be entered
- Customizable ‘pass requirement’ for attendance rate
- Ready to print Class and Student Attendance Reports
- Friendly features for easy data entry
- Data validation and tips to help identify errors in data
- No Macros
Video Demo – Class Register Excel Template
What is in the Class Register Excel Template?
The template has 4 worksheets.
- Settings
- Attendance Register
- Class Attendance Report
- Student Attendance Report
How to create student attendance registers in Excel?
- Enter information in the Settings worksheet
- Enter information in the Attendance Register daily
- View and print Class Attendance Report when needed
- View and print Student Attendance Report when needed
- Choose a student name to print
To restart, create a new document or delete all the attendance register entries and start with Step 1.
Settings
- Enter information in the fields shaded in light blue colour
- Make sure that there are no errors in your inputs
- Error messages will disappear after you correct them
- Reports will not be accurate until all the errors are corrected
- Choose your weekends and enter your holidays so that they will not be considered as working days
Attendance Register
Instructions on how to fill student attendance register
- Enter Student Roll No.
- Enter Student Name
- Enter P for Present on Time, L for Present Late or A for Absent for each student for each day
- Do not change the cells shaded in Gray colour as they have formulas
- Student names should be unique
Class Attendance Report
- Fully automated
- Ready to print
- School Information
- Class information
- Monthly and overall summary of Class Attendance
- Month and overall summary of Students’ attendance
- Students not meeting attendance requirements highlighted
Student Attendance Report
- Fully automated
- Ready to print
- Customized for each student
- School Information
- Class information
- Overall and monthly summary of Student’s attendance
- Students not meeting attendance requirements highlighted
- Student’s daily attendance
- Present On Time, Present Late, Absent, Holidays, Weekends and Not Entered
Please let me know if you find this useful or if your requirements are not captured in this school register format template.
Related Templates
Recommended Templates
-
Excel Calendar Template – Excel Calendar 2024/2023 or any yearOriginal price was: $25.$20Current price is: $20. -
Student Attendance Register – Excel Template$15
-
Student Attendance Register – Google Sheet Template$15
211 Comments
Hi your templates are very useful. I would love to use them, but I need AM/PM and I need to specify whether authorised or unauthorised absence. Would you be able to help me with this.
Thank you.
Thanks for sending the e-mail. I have responded with a template that I had built earlier. Unfortunately, I cannot do more customizations at this point due to other projects.
Hope that helps,
Hi Ind Zara, thank you for the great work. We have between 4 and 9 subjects per learner depending on which phase they are in at our school. A learner will typically have classes for around 4 of the subjects per day in periods of between 45 minutes and 90 minutes each. How can I track attendance per subject per day.
Hi a wonderful software you have made and it is very helpful. Thank You.
But i am facing a problem i.e. what if i have 2 lectures in a day in a class??? How to add two credits in one day?
Thank you. Please e-mail me at indzara at gmail.
I was wondering if you could add number of hours for attendance column. In our schools system, some classes are scheduled shorter than hours and there for P may equal two hours or P may equal 45 minutes. How can we track the number of hours in this template ?
I don’t think I understand your question correctly. Can you please explain?
Please e-mail me at indzara at gmail with your specific requirements.
and one more thing i need to add here is ,i need “leave” option in dropdown and it will be considered as a present in attendance sheet.
please help me.
Hi sir,Its really working fine but I am working on a project where i need to manage more than 50 students ,is there any way to increase the number of students?
I am trying to use this for my Cadet Unit for that I need to change Students into cadets and Schools into Cadet Unit how to I do it please?
How to add more than 50 students ?
Please e-mail me at indzara at gmail.
Hello INDZARA,
Excellent Work! I would like to change the formulas for the P, A, and L. I want it to be 1 for each hr of class missed and .33 for late. So 1=absent and .33=late and 0=Present. We enter by the hour because some students do not come the first hour of class, but come the second hour.
Regards,
Gary