Indzara
Shop
Support
Login

School Attendance Register and Report – Free Excel Template

Manage student attendance at schools and educational institutions using this simple free Excel template.

Class Register Excel Template - Class Attendance Report
Class Register Excel Template – Class Attendance Report

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

School Attendance Register and Report Excel Template
School Attendance Register and Report Excel Template with Sample Data

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?

  1. Enter information in the Settings worksheet
  2. Enter information in the Attendance Register daily
  3. View and print Class Attendance Report when needed
  4. 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

Class Register Excel Template - Settings Information
Class Register Excel Template – Settings Information
  • 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 Format in Excel - Enter Holidays
School Attendance Register Format Excel – Enter Holidays
School Attendance Register Template - Set Weekends for school
School Attendance Register Template – Set Weekends for school

Attendance Register

Attendance Register Format in Excel
Attendance Register Format in Excel


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

Class Attendance Report Format
Class Attendance Report Format
  • 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

Printable Student Attendance Report in Excel
Printable Student Attendance Report in Excel
  • 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. 

213 Comments

  • If we change the Begin Date and End Date to this new academic year to cover the dates from in 2024 to 2025 then it creates an error on the Class and Student Attendance Report. If we change it back to dates in 2023 to 2024 then it work again. It is as though it doesn’t like an end date in 2025

    Reply

    • Thank you for showing interest in our template.

      As per our email communication, we are glad that your concern has been resolved after entering the start date on or before the current date.

      Best wishes.

      Reply

  • Sir ,
    How can we enter Summer Holiday (20 May to 30 June) in this sheet,

    we can enter only 20 holidays in this sheet.

    Please Support

    Reply

    • Thank you for showing interest in our template.

      You can unprotect the sheet using the password indzara and add more rows in-between the holiday list (For example, between row 40 and 41) to increase the holiday limit.

      But usually the school starts after summer holidays and ends before summer holidays. Hence you can enter the begin and end date accordingly to avoid entering all dates in summer holidays.

      Best wishes.

      Reply

  • i have issue with end of term even when i go to setting and put a date it is not changing

    Reply

  • Hi
    I am looking for something like a register to record who attends a church coffee morning weekly (term time only).

    I have downloaded your sheet and I have done the set up with days (wednesdays), dates and holidays which is great. However you only allow 60 names. I want to kept a note of all attendees over the year so probably need 120. I cannot easily see how to extent the attendance table of names – can you help ?
    Also any ideas on how I cold record how many children attend with their parents or maybe I need each child too – if that’s the case I may need 200 🙁

    Reply

  • The password found here does not unprotect the spreadsheet and I would need to change the attendance codes to fit the school…..can you help at all please?

    Reply

  • Hi this is a great template and thanks for sharing it. Do I need to delete the cells if I don’t have 50 students? And if I add more students in the future can I just add the rows back? Or should I just leave the 50 spaces you have already desigated?

    Thank you

    Reply

    • Hello,

      Thank you for sharing your valuable feedback and you are welcome.
      Regarding empty rows, I would suggest you to hide the empty rows and unhide it when adding more number of students.
      For further clarifications, requesting to contact support@indzara.com.

      Best wishes.

      Reply

  • dear sir, what is the password of School Attendance Register and Report Excel Template, i want to change or adjustment in the report as per my requirement.

    thanks and regards,
    Sulaman Ali

    Reply

      • The password is YSE6852SHUUR the same will be available in the top right of the settings tab for future reference.

        Best wishes.

        Reply

  • Thank you, you’ve done a great work. Please need a little adjustment, I need it to be able to take attendance per subject.

    Reply

    • Thanks for using our template.

      You may use a template for each subject. As of now, this is designed for a class where students study all subjects and attendance is taken once.

      Best wishes

      Reply

  • How can I add new features to the attendance register like change the layout and add background photo

    Reply

    • Hello

      Can you please elaborate more about the features that you will like to add. Please write to us at contact@indzara.com.
      We might be able to guide you to add some feasible changes.

      Thanks

      Reply

  • I downloaded the attendance register from your website. but could not increase the number of students in that document. To input that password. Please tell, whats the story of them big puppy’s …..

    Reply

    • Thanks for using our template.

      Please use “indzara” as a password.

      Best wishes

      Reply

  • Even though I entered the Begin Date and End Date, the report are not working well.
    I entered begin date as Jan/1/2020 and end date as Mar/25/2021. Class attendance report and Student attendance report end date are default at May 26 2020, no working days are shown and no monthly information are shown.

    Reply

    • Thanks for using our template.

      Please note the academic window should not exceed 366 days.

      Best wishes

      Reply

  • Hello Sir,
    How do I input the dates before I mark the register? And if it is a weekend school can I set all other days to be weekend other than actual weekends?

    Thanks

    Reply

    • Hello Sir,
      How do I input the dates before I mark the register because cells for the dates are protected? And if it is a weekend school can I set all other days to be weekend other than actual weekends?

      Thanks

      Reply

      • Hello

        Please use ” indzara” a pasword.

        For weekend school, you can mark the weekdays as off or non-working days.

        Thanks

        Reply

    • Hello

      Please use ” indzara” a pasword.

      For weekend school, you can mark the weekdays as off or non-working days.

      Thanks

      Reply

  • Can i expect a reply soon from my question I recently asked?
    A question was sent on the 24th.

    Reply

  • Hi
    My comment is going to be a long one.
    Regarding the school attendance, it is honestly one of the best; nicely and professionally presented. The “set your weekends” table was a good thinking. It can not only be used for selecting week-ends, but also those days where you are not working with a particular grade/group of students. For instance, I work with grade 10 on only three different week days, so I select those two also where I’m not working, including Saturdays and Sundays. So it’s great to have it. I don’t know though why you have only 5 week numbers!!!

    However, there are certain things not working for me and I do have a few questions. Grateful if you could reply back to my email given below.

    1. The “Class” in the setting page is set for only one grade, meaning that if I work with 6 different grades I will have to keep 6 different sets of excel documents and each time I will require to fill the other parts or paste information. Is there a solution for this? Can we have the possibility to change the grades on one setting and have specific information for each grade on the same sets of files?

    2. Regarding the “Enter your Holidays” section, you have used an example of 3 national holidays and a remaining space of 17. Is this limited to 20 holidays only? Can’t we add more?
    By the way, if I use all the national holidays in my country and the school holiday dates, then the list is quite long. I have tried to include all the holidays and changed the formula with the required column number, however, some holidays are taken care of and other are not. To be frank, this part is giving me issues!!! Plz check the change formala

    =IF(SUM(IF(ISNUMBER(O26:O74),0,1))-Q25>0,”Error: Please enter only dates for holidays “,””)

    I would love to ammend all these to make it work in a school setting.

    But, i would not forget to say that you did a great job and I’m thankful to you.

    Wish to hear from you.

    Regards

    Vikash
    (from Mauritius)

    Reply

    • Thanks for your feedback.
      1. 5 week numbers: Since there cannot be 6 Mondays or 6 Tuesdays in a month, 5 was allowed as the maximum.
      2. The template is designed for only 1 class. File has to be copied for second class. Making this for the whole school or multiple classes will be considered in a future version.
      3. Holidays: The premium template https://indzara.com/product/student-attendance-register-excel-template/ allows any number of holidays to be entered in the table. If there are any further questions, please email file and specify.

      Best wishes.

      Reply

  • Can this be customised to use as a department / individual teacher to track attendance at individual lesson? ie is it possible to put in a timetable for a class (eg Monday Period 1, Tuesday Period 4, Thursday Period 5, Friday Period 3). This would be really useful

    Reply

    • Currently it is designed for only one class. The premium version also supports only two attendances per day (AM/PM).
      Thanks for your feedback.
      Best wishes.

      Reply

  • how to add more number of student when no of students are more than 100, it is not allowing to add more number of students

    Reply

  • this is very good template for tracking attendanc of student.
    in this template how we make extra lecture entry on same day.

    Reply

    • Thanks for using our template.

      You can make an entry as am or pm for a morning, evening class respectively.

      Best wishes

      Reply

  • thank you so much.
    what if I have between 4 and 10 different classes
    and I teach them 2 hours every week.

    Reply

    • You are welcome.
      The template is for tracking attendance for one class. Please make a copy of the file for each class you have. In each file you can track students who attend that specific class.
      Best wishes.

      Reply

  • Hi I am TusharK this formula is not working in google sheets ( Sheet1) . Why ? Please suggest me
    =IFERROR(SMALL(WorkingDay,ROW(A5)-ROW($A$2)),””)

    Reply

    • Thanks for using our template.

      Our templates are designed to work on MS Excel.

      Some of the formulas will not work in Google Sheets.

      Best wishes

      Reply

  • I do really love your work but I wonder if it is possible for you to add the separate class period / section tab into the same worksheet. Most of the middle and high school teachers have several separate periods because each period have different roster.

    Reply

    • Thanks for your suggestion.
      The present template does not have this feature. We will try to incorporate the same in our next release.

      Best wishes

      Reply

  • Hi
    am a student at university we have been given assignment to make a project now i have chosen to create a school attendance register, do have other procedures i can follow for me to create this project? I have downloaded this template.

    Reply

  • Hi:

    Thanks for this great template!. I’m a teacher in a Catholic School in Puerto Rico. Here we have another recess periods in the school year, like: Holy Week (1 week recess) and Christmas ( two to three weeks recess). How do we enter these periods if the template only have up to 20 holidays to register?

    Reply

    • Thanks for your positive feedback.

      We have noted your suggestion, we might incorporate in the subsequent releases.

      Best wishes

      Reply

  • Sir it is a superb template for class attendance but their is a aslight confussion related to summer holidays how to enter summer holidays in the template It is showing only 20 holidays . Please make it clear I will be very thankful to you.

    Reply

    • Hello,
      Thank you for using the template.
      You need to enter each day separately in the Holidays table. If we enter two dates and drag them down, Excel will fill automatically. This should help with data entry.
      Best wishes

      Reply

    • Hello

      In a report, a name seems more relevant as it gives the observer a quick recall about the student. Hence the name is used.

      Thanks

      Reply

  • Started using the template to customize it is promoting to enter the password
    what is the password

    Reply

    • Hello

      The reports are designed to handle a maximum of 50 students.
      Hence extending the rows would affect the reports.

      Thanks

      Reply

  • Could you please send me template used in an international school situated in Gulf countries, at the earliest.

    Thanks and regards

    Reply

    • Hello

      We do not have a template for a specific geography. You may customize it according to your needs.

      Best wishes

      Reply

  • Hi,
    I have downloaded this template as we are a very small school. How do I customise the holiday dates to support holidays that are more than one day, e.g. half term (october, february and June) and 2 weeks at christmas/easter?

    Reply

    • Hello,
      Thank you for using the template.
      You need to enter each day separately in the Holidays table. If we enter two dates and drag them down, Excel will fill automatically. This should help with data entry.
      Best wishes

      Reply

  • its a superb template well done. can i get a template for patients daily attendance in the hospital?

    Reply

    • Thank you for the positive feedback.
      We are not accepting any customized project now. We will definitely design a similar template in future.
      Best wishes & regards

      Reply

  • Hi great work, But here is possible to calculate prefix or suffix leave.

    Reply

    • Hello
      Please elaborate about what you mean by “Prefix”or “Suffix” leave.
      Best wishes

      Reply

  • Dear Sir/Madam

    Thanks for your Fantastic Template. but in my class 65 Students, Its possible to increase 65 students in that excel template, and the attendance will calculate FN & AN Wise., (Twice a day), any solution for this, Waiting for your kind reply.

    Thanks

    Reply

  • Thanks for your excellent Template. But I am dealing with over thirty Classes and wished I could get a single Template/file which can Handle all the classes. Or otherwise I have to create single template for each class. That is over 30 Templates/Files. Thanks for the great work.

    Reply

    • Hello
      This template is designed to track attendance for one class. You can have maximum 50 students.
      Best wishes

      Reply

  • Respected Sir,

    Suppose someone leaves school at the middle of the term, then How to manage attendance?

    Reply

  • hI IT wont let me add more students I have 25 students I need to add a few more but it wont let me

    Reply

  • Hi Indzara,
    Great work and thanks for providing password, this made me to learn excel formulas.
    Would it be possible to create one template for fee tracking for different classes and provide us to learn.

    Appreciate your efforts

    Thank you

    Reply

    • You are welcome. Glad to hear.
      Can you please specify what features are needed in fee tracking? I don’t have a template yet, but will try in the future.
      Best wishes.

      Reply

    • Won’t let me add a student or any data. But keep telling me ……………. is on a protected sheet. To make changes…………….. a password is required. what’s the password?

      Reply

  • Hi Indzara, Great template. Is it possible to add another 2 function to the attendance Register section “not required” and “leave”. These would be omitted from the final calculation of attendance.

    Many thanks Kylie

    Reply

  • Hello
    Thanks for the great and dynamic job. I am using this sheet for attendance in the University where there is semester system. I need to have the following information along with others to be printed:
    1. Semester (Spring or Fall)
    2. Subject Name
    3. Session.
    Also, information about :
    1. Long (more than a month) winter vacation

    2. Long (more than a month) summer vacation.
    Please update this with these, although it’s alrady rocking in design, accuracy and flexibility.
    Thanks
    Sincerely
    Abdur Rahman

    Reply

  • I want same sheet for 100 students. In Place of School write collage.
    Please Upload or provide the password

    Reply

  • fantastic and very nice tracker. Can we record more than fifty students at this tracker sheet?

    Reply

  • Dear sir,
    Namaste !
    very nice your planning. i Am Kunal, i am running coaching centre in morning section and evening section. how i will take attendance for two section a day.
    please send to kunalgupt@gmail.com
    Thank u sir

    Reply

  • Hi, how do I increase the number of the learners as I have 120 learners?

    Reply

  • hi,can i import data from a database into the excel template ,i want to use an electronic system whereby the students register by swipping in an RFID tag

    Reply

    • You can take data from any database and paste in the template as long as the columns are aligned. The template does not have connection to any other system such as RFID. Sorry.

      Reply

  • good to see your responds , kindly let me know the monthly wise report possible with no of present and absent ,,.. ect details

    Reply

    • In the template above, we can see present and absent for each month for each student in Student report, and for entire class in Class report. Thanks. Best wishes.

      Reply

  • dear Sir,

    i am try to use this attendance excel format for my office , kindly help us to get 1/2 (half day ) present how an i use.

    Reply

  • Hello sir
    You are doing good work .
    I have a question .
    We have 9 class in school
    How can we add more class in sheet ?
    Thank you

    Reply

    • Thanks for the feedback.
      The template is to track attendance for one class. To track for multiple classes, you can create a copy of the file for each class.
      Best wishes.

      Reply

  • Hi, 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?

    Thanks and very nice work

    Reply

  • Hello indzara,

    Your template is very functional. I use it to register attendance to my UHD classes. But, in some classes i have double lectures which the template does not have option for. How can I modify the template to be able to register double lectures?
    Thank you in advance

    Reply

  • its Awesome but i have 150 student and this file consisted of only 50 student so plz help me….

    Reply

  • Hi, 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?

    Thanks and very nice work

    Reply

  • Hi there,

    This is a brilliant attendance spreadsheet! We run a small Saturday and Sunday school and this works very well for us as the spreadsheets allows to filter out weekdays.

    I just wanted to ask if there is a way of adding another field to record student ‘authorised absence’ (AA). This would be for hospital appointments or exceptional circumstances where it would not effect students overall attendance as this is beyond their control.

    Thank you for sharing…

    Many thanks.

    Reply

  • Hi it is very very good well done for the job.
    I like to use this template and wanted to add up something like term attendance report but no way to make a change it is protected.
    Here there is only yearly report and how should I build a first, second and third report before using your one as the last main report

    Please help me

    Reply

  • HI the template is just too good. we have attendance on hourly basis can that be modified on the template. and more number of students be added

    Reply

  • sir please add register number, birth date, cast, 40 holidays list and need 90 students register also add cast category example : OBC, NT, DT, SC, OPEN

    Reply

    • Thanks. Please email me at indzara@gmail.com if you need customized template. I can let you know the cost once I understand the specific requirements. Best wishes.

      Reply

  • आपका कार्य अच्छा है. विद्यालय के हिसाब से इसमें कई कमियों भी हैं . जैसे 1 दो पारी उपस्थिति 2 कार्य दिवस की संख्या 3 अवकाश 4 अधिक छात्र संख्यां 5 आधे दिन की उपस्थिति 6 सत्र के बीच मै प्रवेश / त्याग 7 स्त्तम्भ मे घोषित अवकाश का विवरण . ये कमियां दूर करैं तो काफी अच्छा रहेगा .

    Reply

  • this is 2016 and from the part of the world i come from this is like the future lol thank you boss

    Reply

  • Can you please tell me how to fix the “Error: Please enter only dates for holidays” message? I have entered only dates, but the entries do not resolve the issue.

    Reply

    • Please ensure that it is in DATE format (from the cell format menu at the top). Sometimes it may appear as date in the cell, but Excel will accept only certain date formats. And they also may vary with different country versions of Excel. If the issue continues, please email me the file (indzara at gmail dot com) and I will look into it. Thanks.

      Reply

  • Comment…sir mujhe attendance sheet par absent aur present ka fomulas chahiye p sur a ko count kis trha karte hai

    Reply

    • Thanks. You can see all the formulas in the sheet. Please unlock sheets using the password indzara and you can see the formulas. Hope this helps. Best wishes.

      Reply

  • Hi, please can you send me a template which allows you to work with each day split into AM and PM? I am aware that others have asked the same question and I just cannot work out how to change this myself.
    Wonderful work, thank you so much!

    Reply

  • Hi, i find your templete very helpful for my school.And Thank you very much for providing it free download.
    But i have a little problem with the “End date”. I could not customise it in setting. Even though i change the date in the setting, it doesn’t change in ” class attendence report and student attendence report”.
    Note: my school’s academic session is winterly basis..i,e january -december.
    Sir please help me in sorting out this issue. Thank you

    Reply

    • I am glad that it is helpful for your school. You are welcome.

      The Template shows only data until today in the Class Attendance Report and Student Attendance Report. For example, since it is Jan 24th today, it will only show until January and will not show February. That’s because Feb has not happened yet. In a couple of weeks, you will see February automatically appear. Everything seems to be working as designed. If this does not address your concern, please e-mail your file and I can look into it.

      Thanks & Best wishes,

      Reply

  • Hi.sorry i sent the same this message into inventory forum
    Thanks for your effort
    but i just confused little bit about Attendance Register
    i tried to add the drop down list “Holiday or H”
    to be like this
    P
    A
    H
    L
    so i need instruction to do this
    i hop you help me anyone
    thnks

    Reply

    • You are welcome.

      You can enter the holidays in the Holidays table in the Settings. Days entered in the Holidays table will not be displayed for attendance register. In the attendance register, you can choose P, A or L.

      Thank you,

      Reply

    • Thank you.

      This is the formula used for conditional formatting today’s date. =D$8=TODAY()

      Hope that helps.

      Reply

  • Thanks 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.

    Reply

    • A new version of the template will be available this month (Feb 2015). It can handle more than 100 students and will be flexible on how attendance is recorded.

      Thanks,

      Reply

  • hello, i am constantly getting ‘error’ concerning the begin and end date???
    please help me as i need this register ASAP! thank you.

    Reply

    • 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.

      Reply

  • 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.
    So 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

    Reply

    • Thank you.
      Currently, 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.

      Reply

  • 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.
    So 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

    Reply

  • 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.
    Thank you

    Reply

    • 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.

      Reply

  • 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.

    Reply

    • 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,

      Reply

  • 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.

    Reply

  • 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?

    Reply

  • 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 ?

    Reply

  • 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.

    Reply

  • 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?

    Reply

  • 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?

    Reply

  • 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

    Reply

  • Hi ind zara

    first 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) ?

    Reply

    • Thank you.
      Currently, 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.

      Reply

  • Hi, 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?

    Thanks and very nice work

    Reply

  • 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…

    Reply

    • Thanks. 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.

      Reply

    • I 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.

      Reply

  • briliant work
    but
    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

    Reply

  • in studend attendence report it is showing only student 50 how to select please i am using office 2007 & 2003

    Reply

    • The 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.

      Reply

  • 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???

    Reply

    • Thanks for using the template.

      The 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.

      Reply

  • Fantastic template!

    I 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.

    Reply

    • Thanks, Alex James.
      I 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.

      Reply

    • 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.

      Reply

    • Fixed 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?

      If you can e-mail the screenshots, that would be even more helpful for me to troubleshoot. Thanks.

      Reply

  • 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

    Reply

    • I am glad you like the template, fifi. Thanks.

      Do 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.

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *