School Attendance Register and Report (Excel template)

Posted on

Update: There is a new enhanced version of this template with 1) complete flexibility in choosing weekends and 2) accommodation of entry of late attendance by students. Please visit School Attendance Register and Report v2 (Excel Template)

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 
Attendance Register Template - Class Attendance Report
Attendance Register Template – Class Attendance Report

 

VIDEO DEMO


FEATURES

  • Can track attendance for up to 50 students 
  • Customizable academic window (up to 366 working days)
  • Choice for Weekends: 1) Sundays 2) Saturdays and Sundays
  • 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
  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
School Attendance Register Template - Enter Settings
School Attendance Register Template – Enter 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
 
ATTENDANCE REGISTER
School Attendance Register Excel Template - Attendance Register Format
School Attendance Register Excel Template – Attendance Register Format

 

Instructions
  • Enter Student Roll No.
  • Enter Student Name
  • Enter P for Present 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
School Attendance Register Excel Template - Class Attendance Report
School Attendance Register 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
School Attendance Register Excel Template - Student Attendance Report
School Attendance Register 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, Absent, Holidays, Weekends and Not Entered


Please use the template and provide me feedback on how this can be improved.

36 thoughts on “School Attendance Register and Report (Excel template)

  1. we have two classes on Wednesday and the two classes should be counted. how can i do for that. your template is excellent. thank you

    1. Hello,
      This template is designed for one class, and there can be one attendance per day for each student in the free template, and two attendances (AM/PM) for each student in the premium template.
      Please visit https://indzara.com/product/student-attendance-register-excel-template/ for Student Attendance Register – Excel Template
      Thanks

  2. hi
    i want to purchase school attendance register with slight changes. if it is possible, i want to add summer vacations of three months in it, and also Leave count, in place of Late coming, leave count should not be entered or calculated as present days. and also i want to add monogram of my school in this format.
    if these changes are possible than i am ready to purchase.

    Waseem Sarwar
    waseem.sarwar84@gmail.com

    1. Hello

      Thanks for your interest in our template.
      Please see the Student Attendance Register template https://indzara.com/product/student-attendance-register-excel-template/ which allows more number of holidays and customizable entry codes.

      Thanks & Best wishes

  3. Thanks for job well done. I have more than 60 students but your template am using can’t go beyond 50. It’s showing it has been protected thereby demanding for code. Pls help I really need it. Thanks.

    1. Hello Joy,
      Thanks for the positive feedback.

      You may review our following template: Student Attendance Register – Excel Template at https://indzara.com/product/student-attendance-register-excel-template/

      Best wishes

  4. Hi and Good day: Your attendance template looks pretty good. I was just curious, how would I use that when I have to take attendance both in the am. and p.m (morning attendance and afternoon attendance)? Is there a way of adjusting the template to meet my needs?

    Thank you.

    1. Thank you.
      For tracking 2 attendances per day, please use the Student Attendance Register template. https://indzara.com/product/student-attendance-register-excel-template/
      Please let me know if there are any questions.
      Best wishes.

  5. Hi, we have a few breaks that are a week each. We total more then 20 holidays. Can I add more or have a way to exclude our winter holiday 2 week break? For the year we have a total of 26 days off.

    1. Please see Student Attendance Register template https://indzara.com/product/student-attendance-register-excel-template/ that allows unlimited number of holidays.
      Please let me know if there are any questions.
      Best wishes.

Leave a Reply

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