School Attendance Register and Report v2 (Free Excel Template)

Posted on
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.

For more advanced features, please see Student Attendance Register 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 

 


FREE  DOWNLOAD

(For Excel 2010 or above)

 


 

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

 

FEATURES

  • 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


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

Attendance Register Template - Settings Information
Attendance Register Template – Settings Information


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

Attendance Register Format in Excel - Enter Holidays
Attendance Register Format in 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

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

172 thoughts on “School Attendance Register and Report v2 (Free Excel Template)

  1. Copy and paste not working

    1. Thanks for using our template.

      The data needs to be entered in a table format. Please refer to “Introduction to Excel Tables” at https://indzara.com/support/

      Best wishes

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

    1. Thanks for using our template.

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

      Best wishes

  3. copy/paste is not working. sheet is protected, how to unprotect?

    1. Hello

      Please use “indzara” as a password.

      Thanks

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

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

  5. 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)),””)

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

Leave a Reply

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