Excel Templates for School – Attendance Tracking, Report Cards & More

Student Attendance Register

Student Attendance Register Excel Template
Student Attendance Register Excel Template
Track student attendance and create attendance reports instantly using this 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 institutions
FEATURES
  • Can track attendance for up to 200 students
  • 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).
  • Any number of Holidays can be entered
  • Customizable tracking (You can choose what you want to track – Present, Absent, Late, Excused, etc.)
  • Can handle attendance taken once or twice per day
  • Set default attendance value thus minimizing data entry
  • Customizable ‘pass requirement’ for attendance rate
  • Ready to print Class and Student Attendance Reports
  • Allows 2 student fields of your own to appear in report
  • Identify students with least attendance rate easily
  • Easy to change logo with your own

Download Student Attendance Register Excel Template

 


School Attendance Register and Report (Free 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

 Read and Download


Report Card – Basic (Free Excel Template)

Automate creation of student report cards and provide meaningful academic performance information to teachers and instructors, with minimal effort.
  • Handles up to 50 students
  • Up to 12 different tests can be entered
  • Up to 12 different subjects can be entered
  • Customizable % required to pass
  • Customizable maximum marks for each test for each subject
  • Marks presented as %
  • Option to calculate final marks based on custom weights assigned to each test
  • Class View
    • Highlights Subject with the least average in each test
    • Presents the number of students failed in each subject in each test
    • Calculates the average final % for each subject
  • Subject View (Choose one subject)
    • Presents the data for all the students in each test
    • Highlights the highest marks in each test
    • Highlights students failing to meet the % required to pass
    • Calculates the average final % for each student
  • Student View (Choose one student)
    • Presents all the data for one student
    • Calculates the final overall %, final class rank and final result.
    • Calculates the final % for each subject
    • Calculates the result and class rank for each test
  • Ready for printing

Read and Download


All-Purpose Calendar Maker (Free Excel Template)

You can use the All-Purpose Calendar Maker to create custom academic calendars at schools and other educational institutions.

  • Choice of two designs: 12 month calendar on 1 page, Monthly calendar in 12 pages
  • Works with any year after 1900
  • Start with any month
  • 12 Month calendar (12 months beginning with the month you choose)
  • Start the week with any day
  • Displays up to 100 of your personal events (nicely sorted)
  • Event dates are highlighted on the calendar
  • Choice of up to 5 different types of events. Each event type is highlighted with a different colour
  • Customizable Weekends – You chose which days of the week are usually non-working days or weekends.

Download All-Purpose Calendar Maker


Quiz Master (Free Excel Template)

Use Microsoft Excel to conduct quiz events at school. This template is suitable for groups of people forming teams, or individuals (1 to 4) and works well with multiple choice questions.
  • Customizable number of questions (1 to 50)
  • Customizable number of participants  (1 to 4)
  • Customizable participant names
  • Value of each answer can be customized
  • Displays whose turn it is to answer next question
  • Scoreboard gets updated automatically
  • Revealing answers with a button
  • Moving to the next question with a button
  • Correct answers are highlighted
  • Quiz progress bar shows the progress
  • Easy to enter new questions for a new quiz
  • Message board captures errors

Download Quiz Master template

44 thoughts on “Excel Templates for School – Attendance Tracking, Report Cards & More

  1. I am from Kuwait. Looking for software for School Management System. Right from admission, Billing, Collection, outstanding, Grade wise, Sibling Discount) Staff Children Discount.
    Here all the students are registered with parent account. In Books we need to create parent account(mandatory) and should be linked with student account.

    By default system should create invoice week before due date. Like academic year starts from 1st Sep and ends on 31st Aug. So 1st Invoice for registration fee along with 1st installment due amount is on 1st Sep, 2nd invoice to generate on 1st Dec & 3rd and final invoice to generate on 1st Mar. All due fees must settle on or before 31st Mar.

    Sibling discount is applicable only if parent settle their dues on or before 31st March. Sibling discount is 10 % from the 2nd enrolled child.

    All this should be available in table so as per need of the school it can change.

    HR & Payroll management: Complete HR & Payroll system with attendance, Leave tracking, lateness, Absent, MTD & YTD availed & Balance, Employee Advance.
    Teaching staff & Non Teaching staff entitlement days of Leave and work days in particular academic year.

    1. Thanks for sharing your requirements.

      We are not accepting customized projects due to the existing workload.

      Best wishes

  2. Hello there.
    Great stuff you people. Very simple, and precise.
    However, do you guys have a template to manage school fees collection for a school. If so please kindly share it.
    You should also make templates for tracking school supplies, library management, salary payments.
    Otherwise you guy’s are doing some great work.
    Much appreciated!
    arnoldceaser180@gmail.com

    1. Thanks for your interest in our templates.
      We have taken your feedback and will try to develop these templates soon.
      Best wishes

  3. So please tell me that how extant table and what is the formula for that

    1. Hello

      You may extend the table, however, the reports would get affected.

      Best wishes

  4. Hello first of all thank you for making report card tamplet. Sir I need to extend students large number how could I, please help me

Leave a Reply

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