School Attendance Register and Report v2 (Free Excel Template)

Posted on
Student Attendance Register & Report
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
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. 

You may also be interested in...

Report Card Excel Template
Quiz Master Excel Template

Some of our related products...

  • Student Attendance Register – Excel Template

    US$15
    Add to cart
  • Student Attendance Register – Google Sheet Template

    US$15
    Add to cart

Report Card – Basic (Free Excel Template)

Posted on
Report Card Excel Template
PURPOSE
The purpose of this template is to automate creation of student report cards and provide meaningful academic performance information to teachers and instructors, with minimal effort. I believe this would be useful for schools and other educational institutions, conducting tests or assessments for their students.


FREE DOWNLOAD




FEATURES

  • 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
  • Easy data entry of marks
  • 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


HOW TO USE THE TEMPLATE

  • Step 1: Enter information in cells underlined in the Settings worksheet.
  • Step 2: Enter information in Entry worksheet.
    • Enter Maximum Marks for each test
    • Enter Student info and marks.
  • Step 3: Go to Class View to view and print Class Report Card
  • Step 4: Go to Subject View to view and print Subject Report Card (Choose a Subject)
  • Step 5: Go to Student View to view and print Student Report Card (Choose a Student)
 
SETTINGS

indzara_ReportCard_Settings

This is where you would enter your school and class information. Also, you would enter the ‘% Required to Pass’. In the screenshot above with the sample data, I have used 40% as % required to pass. This allows the template to automatically highlight any marks which are less than 40% with a red font so that it’s easy for the teacher to identify failures.

In many scenarios, students’ final marks are calculated based on assessments or tests throughout the academic year. In such scenarios, weights are assigned to each test and final marks are calculated based on those weights. This template accommodates that set-up. You can choose up to 12 tests and you can assign a weight to each test and the total of the weights should be 100%. The template is very flexible. For example, if your final marks are based only on the last test you conduct, you would assign 100% weight to the last test and 0% weight to all other tests. 

If you do not have the need to calculate final marks, please choose No in the drop down menu as shown in the image below. This would make sure that the final marks will not be displayed anywhere in the template. 
indzara_ReportCard_Settings_FinalMarks

You can choose up to 12 subjects. Please make sure that the subject names are unique. 

ENTRY
indzara_ReportCard_Entry

CLASS VIEW
This is where you enter the student names, their roll numbers and the marks they scored in each subject in each test. This sheet automatically adjusts based on the number of tests and subjects you have entered in the Settings worksheet. 

Enter Maximum Marks for each test. This is crucial for calculation. If you don’t enter this, you would see errors like the one shown in this image.
indzara_ReportCard_SubjectView_error

indzara_ReportCard_ClassView

This view presents the overall performance of the class and highlights areas of opportunities. Everything is automatically calculated and is ready to print. 
  • Subject with the least average in each test is highlighted with dark orange font. This allows easy identification of the (relatively) weakest subject for the class. 
  • Number of students failed in each subject in each test is also calculated and highlighted. 
  • If you have chosen to calculate final marks in the Settings worksheet, the average final % of the class for each subject is also calculated.
SUBJECT VIEW 
indzara_ReportCard_SubjectView

Choose a subject from the drop down menu and this view presents each student’s performance in that subject during the course of the academic year. This allows the teacher to understand how the class is performing in that subject.

  • Highest marks in each test is highlighted in dark green font.
  • Marks that have failed to meet the % required to pass are highlighted with dark red font.
  • If you have chosen to calculate final marks in the Settings worksheet, the final % of each student in that subject is also calculated.
STUDENT VIEW
indzara_ReportCard_StudentView
Choose a student from the drop down menu and this view presents the performance of that student in all subjects across all the tests. 
  • In addition to the %, this sheet calculates 
    • Result (Pass or Fail) whether the student has passed in each subject in a test. 
    • Class Rank of the student in each test
  • If you have chosen to calculate final marks in the Settings worksheet, the final % of the student in each subject is calculated. The Final Result, Final Class Rank and Final Overall % are also calculated. 
  • Placeholders are provided for signatures from school principal and class teacher. This sheet can be printed and handed to the students.
Calculation Logic
  • Total Marks is the sum of actual marks scored in all the subjects in a test.
  • Maximum Marks is the sum of maximum possible marks in all the subjects in a test.
  • Overall % is calculated as Total Marks/Maximum Marks in each test.
  • Result is ‘PASS’ if the student has scored at least the “% Required to Pass” in each of the subjects in the test. Otherwise the Result is ‘FAIL’.
  • Class Rank is calculated based on students whose result is ‘PASS’ in the test. For students with a ‘FAIL’ result, the class rank is NR (No Rank).
    • If there are five students and 2 of them score the highest total marks in a test, then both of them will get a class rank of 1 and there will not be class rank of 2. The next highest student will get a class rank of 3.  
  • Final % for each subject is calculated based on weights given to each test in the settings worksheet. 
  • Final Overall % is calculated as average of the Final % in all subjects. 
  • Final Result is PASS if the student’s Final % for each subject is at least the ‘% required to pass’. 
  • Final Class Rank is calculated based on students whose final Result is PASS. For students whose final Result is FAIL, the final class rank is NR.
This excel result sheet download is simple and effective in managing the student report of a class of 50 students. I hope you find the result card format in excel template useful. Please share your feedback on whether the marksheet format in excel template captures the requirements of your scenario. I can make the necessary changes so that the template can be used by as many people as possible. 

You may also be interested in...

Student Attendance Register & Report
Quiz Master Excel Template

Quiz Master (Excel template) to conduct quizzes

Posted on
Quiz Master Excel Template
An Excel template for questions and answers that can be used to conduct quizzes. Customize Questions and Answers easily. 
Excel Quiz Template Free - Screenshot
Excel Quiz Template Free – Screenshot

FREE DOWNLOAD

Download Quiz Master Excel template for free

 

PURPOSE

  • Suited for conducting quiz events at work, school or home
  • Suitable for groups of people forming teams, or individuals (1 to 4)
  • Font sizes have been chosen to suit presentations using projectors
  • Works well with multiple choice questions

 

VIDEO DEMO

 

QUIZ GAMEPLAY

  • A quiz conductor asks the first question to the first participant and the other participants get to answer in a sequence
  • Each question will be answered by every one of the participants regardless of whether a participant’s answer is correct or not
  • Quiz conductor enters the participants’ answers in the template
  • Only the quiz conductor will use the Excel template to conduct the quiz; Participants will not be using the document
  • Answer is revealed for each question after all participants have answered
  • Points are awarded for every correct answer
  • Second question begins with second participant and others answer in the sequence
  • Participant with the highest points at the end of all questions is the winner
 

FEATURES

  • 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

WHAT IS IN THE QUIZ IN EXCEL TEMPLATE?

Three worksheets
  • Introduction: Information about the template and how to use it
  • Questions: Where the quiz master will enter questions, answer choices, points and correct answer for each question in the quiz
  • Quiz:
    • Input about  number of questions, number of participants  and participant names
    • Quiz conducting interface where participants’ answers will be entered
    • Scoreboard with scores updated for each participant

 

PREPARATION FOR THE QUIZ

  1. Create questions and answers  or collect from outside sources such as books or the internet 
  2. Enter Information in the Questions worksheet  
  3. Enter number of participants, number of questions and participant names 

 

CONDUCTING THE QUIZ

  1. Click Up button in Current Question
    • This makes the next question appear along with answer choices and points
    • You may have to scroll down to view the next question 
  2. Enter Participants’ answers
    • Every participant will answer the questions in  a sequence
    • Use the drop downs to answer the questions
  3. Click Up button in Reveal Answer
    • Reveals the correct answer for the question
    • Highlights the correct answers from participants 
    • Updates the scores in the scoreboard

RESTARTING THE QUIZ

  1. Delete any responses from participants
    • They are in rows 18 to 67 in columns J,K,L and M, in Quiz worksheet 
  2. Set the Current question to 0 (zero)
    • You can enter directly in cell F5 or use the down button
  3. Set Reveal Answer to 0 (zero)
    • You can enter directly in cell H5 or use the down button
  4. (Optional) If you would like to change the questions, then update the Questions worksheet with new information
  5. Start conducting the quiz

 

I have also prepared a downloadable PDF document that summarizes the above information. The screenshots are attached below as well.

 

Slide2

Slide3

Slide4

Slide5

Slide6

Slide7

Slide8

Slide9

Slide10

Slide11

You may also be interested in...

Report Card Excel Template
Student Attendance Register & Report