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.
PURPOSE
- 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
DOWNLOADS (for Excel 2010 and 2013)
- Download the free School Attendance Register and Report (v2) Excel template
- Download the School Attendance Register and Report (v2) Excel template with Sample data
 |
| indzara School Attendance Register and Report (v2) Excel Template - Student Attendance Report |
- 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
WHAT'S IN THE TEMPLATE?
The template has 4 worksheets
- Settings
- Attendance Register
- Class Attendance Report
- Student Attendance Report
HOW TO USE THE TEMPLATE
- 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
 |
| indzara School Attendance Register and Report (v2) Excel Template - Settings |
Instructions
- 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
 |
| indzara School Attendance Register and Report (v2) Excel Template - Weekends |
 |
| indzara School Attendance Register and Report (v2) Excel Template - Holidays |
 |
| indzara School Attendance Register and Report (v2) Excel Template - 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
 |
| indzara School Attendance Register and Report (v2) Excel Template - 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
 |
| indzara School Attendance Register and Report (v2) Excel Template - 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 template.
Please provide us excel sheet password
ReplyDeleteHello Matilda Hilarious,
DeleteYou can unlock using 'indzara'.
Ind Zara, I love you project planner. My only issue is I need a longer period that 60 working days. Also I need to be able to add more than 25 project, add additional holidays and Paid Time off.Can you please help in expanding the template
ReplyDeleteI am glad you like the template, fifi. Thanks.
DeleteDo you have specific limits on the period (days) and number of projects/number of tasks? I will take a look. I am worried about performance if I increase the number of tasks and the period by a lot. Also, I will have to think about factoring in the paid time off for each employee/resource.
Please send me an e-mail with the details. I will do my best to customize the template for your needs.
Fantastic template!
ReplyDeleteI have one question. My students only study 2days per week,which can be any two days. How can I do this with your template?
Many thanks.
Thanks, Alex James.
DeleteI am assuming your 2 days a week vary from one week to another. If so, I don't think this template design will work.
If you only enter Absent, Present Late and Present On Time for your 2 days and leave the other days blank, the report should still calculate the number of days present, absent, late, etc. However, the number of working days, Attendance rate % and PASS/FAIL rating will be wrong.
If you need any help, please e-mail (indzara at gmail) me with the requirements. I am currently working on other projects and may not be able to get to this immediately. However, I will add this to my queue and work on it when time permits.
the days are fixed. I entered 'yes' as a weekend for all days except the study days. This works, but the end report doesn't work properly.
DeleteFixed days should work. You are doing the correct thing by selecting 'Yes' for weekends. Can you please explain what you mean by the end report not working properly?
DeleteIf you can e-mail the screenshots, that would be even more helpful for me to troubleshoot. Thanks.
student report and class report not working. error message #DIV/0! and ##### and also not adding up attendance records for days or months on both class and student report. HELP? i thhink it may have something to do with no matter what end or start date you input into settings the template always reads 12 august 2013 as the end date on both class and student report???
ReplyDeleteThanks for using the template.
DeleteThe template does not count dates from the future. This enables the calculation of Attendance rate to be always current and accurate. As the days go by, the number of working days will automatically increase. For example, now the template will not count dates from August 13th, since those days have not happened yet. But once August 13th comes, the template will count that as a working day automatically.
Regarding the error messages, please e-mail me your document and I can help fix the issue.
in studend attendence report it is showing only student 50 how to select please i am using office 2007 & 2003
ReplyDeleteThe template by default handles only up to 50 students. Are you trying to use this for a class with more than 50 students? Please explain your question.
Deletebriliant work
ReplyDeletebut
in most school there are like one month summer and winter holidays etc then how to add these holidays in to settings
plz update any idea
and thanks for this brilliant project
Hello Ainan Leo,
DeleteThank you.
It can be done. Please e-mail me at indzara at gmail.
Dear sir,
ReplyDeleteNamaste !
very nice your planning. i Am Ananda, i am running coaching centre in morning section and evening section. how i will take attendance for two section a day.
please send to plusacademy4@gmail.com
Thank u sir
This is a great template, the best I've found online...I was curious like Ainana Leo how to input looong summer and winter breaks in the holiday field...
ReplyDeleteThanks. I need to make some tweaks to the template to accommodate that. I will try to do that in the next few days and inform you. Please e-mail me at indzara at gmail.
DeleteI have prepared the new version which allows 150 holidays. If you would like a free copy of this new version, please e-mail at indzara at gmail. Thanks.
DeleteHi, Yes its very interesting, but I have two major problem. First, I have more than 50 student, can I add more than 50?. Second I need a report shows the Absent for each students by month? can you make this changes?
ReplyDeleteThanks and very nice work
Thank you. Please e-mail me at indzara at gmail with your requirements.
DeleteHi ind zara
ReplyDeletefirst of all, I would like to thank you for this very nice work that you're sharing,
I have one or two questions if you don't mind:
for the holidays dates: how does it work? from what I understood you just enter the day of your holiday but it seems that it doesn't take into account for how long you'll be on holiday? could you please explain to me if for example your on holiday from 05/11/2013 to 17/11/2013 how do you figure out this?
also what would be the solution if the attendance is recorded twice a day (morning+afternoon) ?
Thank you.
DeleteCurrently, you enter holidays one day at a time.
If you would like to customize the template to accept more holidays and twice a day recording of attendance, please e-mail me at indzara at gmail.
Hello INDZARA,
ReplyDeleteExcellent 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
How to add more than 50 students ?
ReplyDeletePlease e-mail me at indzara at gmail.
DeleteI 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?
ReplyDeleteHi 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?
ReplyDeleteand 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.
ReplyDeleteplease help me.
Please e-mail me at indzara at gmail with your specific requirements.
ReplyDeleteI 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 ?
ReplyDeleteI don't think I understand your question correctly. Can you please explain?
DeleteHi a wonderful software you have made and it is very helpful. Thank You.
ReplyDeleteBut 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.
DeleteHi 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.
ReplyDeleteHi 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.
ReplyDeleteThank you.
DeleteThanks 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,
first of all, Thank you very much. The Program is very useful and easy to learn, but just a question? In our school, we have long holidays Maybe 15 days or 5 days not just one day, how can I edit these holidays in programs.
ReplyDeleteThank you
Please e-mail me at indzara at gmail and I will send a version that allows 150 holidays. Hopefully soon, I will upload that here, as I have received multiple requests for that feature. Thanks.
DeleteHi, firstly thanks for the project. Any possibility that more studant could be added perhaps double thanks .
ReplyDeleteYou are welcome. I have responded to your e-mail with the template. Hope that helps.
DeleteBest wishes.
Hi! Great Template! I would like to add 250 students. Is there a way to do this? I only seem to be able to add 50
ReplyDeleteThank you. Please e-mail at indzara at gmail.
DeleteCan I also have the same template? Great work =)
DeleteI have e-mailed the file. Hope it helps.
DeleteHey there ur template is tooo gud and with great ideas. I am working in a Ltd. Coaching institute. There are three section like lowest junior ( 7,8 ) junior ( 9,10, ) senior ( 11,12 ). The lowest jr. Class has phy, chem, maths, mat subjects 2 days in a week with two subjects. The jr. Section has phy, chem, maths, bio and sst subjects 3 days in a week with two subjects. Sr. Section has phy, chem, maths subjects 3 days in a week with two subjects.
ReplyDeleteSo kindly replace ur one day absent, present in subjectwise. And I am also want to email parent student attendance report daily basis through outlook in ur student report format.
Kindly pls pls help me.
My email address is
Perpendicular.khan@gmail.com
Hey there ur template is tooo gud and with great ideas. I am working in a Ltd. Coaching institute. There are three section like lowest junior ( 7,8 ) junior ( 9,10, ) senior ( 11,12 ). The lowest jr. Class has phy, chem, maths, mat subjects 2 days in a week with two subjects. The jr. Section has phy, chem, maths, bio and sst subjects 3 days in a week with two subjects. Sr. Section has phy, chem, maths subjects 3 days in a week with two subjects.
ReplyDeleteSo kindly replace ur one day absent, present in subjectwise. And I am also want to email parent student attendance report daily basis through outlook in ur student report format.
Kindly pls pls help me.
My email address is
Perpendicular.khan@gmail.com
Thank you.
DeleteCurrently, the template is for a class as a whole and not for separate subjects. You could make a copy of the template and use it separately for each subject.
You can save as a PDF and e-mail via outlook.
But its tooo difficult use that type .
ReplyDeleteKindly help me pls..
I am sorry. I am not sure what you need. If attendance needs to be taken for each subject separately, a separate file can be used for each subject.
Deletehello, i am constantly getting 'error' concerning the begin and end date???
ReplyDeleteplease help me as i need this register ASAP! thank you.
Please e-mail file (indzara at gmail) so that I can look into it. Thank you.
DeleteThanks for sharing the template. Is there any way to add 100+ students? Also, Is there any way absences can be excused (E) or unexcused (U)? I would appreciate any help. Thank you.
ReplyDeleteHi sir Its Very Use-full
ReplyDeletePlease tell me that conditional formatting in extra bordering under the Today date
thank you