CBSE School Attendance Sheet is an excel sheet which enables you to maintain an annual record of attendance of all students in your class.
It is mandatory by the Education ministry to maintain records of the student’s attendance for every academic year.
Thus, this record helps a tutor to even monitor the regularity of students as well as preserve it for future requirements.
Previously, as we all know that the attendance registers were maintained manually by the class teachers. Time advanced and now things have changed.
With technological advancement, all these records are now maintained on computers or different types of gadgets. Most of these automated systems that use fingerprints, thumb impressions, or bar codes are expensive.
Those who belong to the educational field know it well that it requires a handsome amount of time to maintain such registers manually as well as prepare different reports.
CBSE School Attendance Sheet Excel Template
We have created a simple and ready-to-use CBSE School Attendance Sheet in excel predefined formulas along with multiple reports. This sheet is made for the academic year 2019-20 for the CBSE Board.
The motto behind making this sheet is to simplify this tedious task of the manual recording of attendance and save your valuable time.
Just mark the attendance of the student against the name and roll numbers. This will hardly take 5-10 minutes of your time on a daily basis. That’s it and it is done.
For those teachers, who are teaching in Gujarat Board Schools can use our Yearly School Attendance Sheet.
The above template can be helpful to every teacher teaching in CBSE schools or any private institutions. In addition to this, you get ready-to-view attendance reports and their respective averages.
Let us now discuss all the contents of this template in detail.
Contents of CBSE School Attendance Sheet Excel Template
This template consists of a total of 15 sheets. 12 sheets for monthly attendance, (APR – MAR). 3 Sheets for reports; Month-Wise Report, Gender-Wise Annual Report, and Student-wise Annual Report.
Let us discuss first the CBSE Monthly Attendance Sheet.
CBSE Monthly Attendance Sheet (Apr-Mar)
Usually, the academic year in CBSE Board school starts in April and ends in March. You can change this according to your need.
All 12 sheets are for making the entry and have these 4 sections:
- Heading Section
- Student Details Section
- Attendance Record Section
- Summary Section
1. Heading Section
Firstly, the heading section consists of the school’s/institution’s name, heading of the sheet, academic year and the month.
Insert details the above details only for April and it will be automatically displayed in remaining 11 months. The cells are linked to each other.
Insert Class, Division and Total Strength of Students in the April Month only.
If a new student joins in the month of August, then make his entry in the month of August. Don’t change data in previous months (Apr to Jul).
Please make sure you update the new strength manually in the sheet of August. The current month and upcoming months will now reflect the new strength.
The sheet calculates the total number of boy students and girl students automatically with the help of COUNTIF Function.
Furthermore, this section consists of the date, day as well as a working status section of that particular day of the month.
This template is created for the academic year 2019-2020 with reflects all holiday’s as per CBSE academic calendar. You can make necessary changes as per your region.
The status of Sunday will be marked as Holiday instead of working. Each Sunday and Holiday will automatically change to Peach color.
If there is a holiday coming except Sunday, then you need to delete the attendance column data. It will automatically convert it to Holiday and also change the color.
Note: It is mandatory to delete the attendance data in the column otherwise it will not calculate monthly attendance accurately.
2. Student Details Section
Insert student’s details like name of the student and their respective gender. Entry is to be made only once i.e. in the Month of April. Make sure you delete extra rows of roll numbers at the beginning of every month.
For example, you have only 40 students in the current month. Once you enter the data of those 40 students, delete rows from roll number 41 to 60. Failing to do so will affect the accuracy of reports.
3. Attendance Record Section
Each date has 2 columns. The first for the attendance of that particular date.
By default, all the cells in the sheet bear “P” that is present. If a student is absent on that particular day, just change it to “A”. It will change its color to Light Red.
The second column is auto-updated. As you have made the entry of gender earlier, it will show boy or girl present or absent.
It will display “BP” for boys present and “GP” for girls present. Similarly, it will display “BA” for boys absent and “GA” for girls absent. This helps you to maintain gender wise attendance record.
This sheet will display all the relevant calculations beside and beneath the attendance record of each month.
To check the accuracy, an Accuracy Check Feature is given in each monthly sheet. Make sure that all three cells; BU78, BU79, and BU80 in every sheet have the same value.
If these 3 cells differ, there are chances of either wrong entry or deleting of the formula. Give a second check to obtain an accurate monthly report.
Similarly, make entries in all months. and your yearly data will compile.
In CBSE Board schools, the academic year starts after a small 8-10 days vacation after the exams are conducted. The school runs for a month and then the school gives summer vacation.
In this case, the whole month of May and half month of June or whatever be the duration of the is marked as a holiday.
4. Summary Section
Each month’s sheet carries monthly Summary Section. It shows the summary in three different aspects:
- Individual student’s monthly details
- Date wise attendance details
- Overall class attendance monthly report.
Individual Student’s Monthly Attendance
Present (Column: BM) will display the number of days present of the student in that month.
Previous (Column: BN) will show the number of days student was present in the previous month.
This cell will be “0” in 2 cases:
- If it’s the first month of the academic year.
- A student gets enrolled after a few months of the session started.
Total Present (Column: BO) will display cumulative total present days of each student from the date of his/her enrolment or the academic year whichever is later.
Monthly % (Column: BP) will display you the percentage of present days. Total Absent (Column: BQ) automatically calculates the number of absent days of a student.
Date wise Attendance Details
Below each date column, it shows the total number of students present and absent along with the grand total of present and absent.
In addition to that, it also displays the total number of boys and girls that are present or absent.
The grand total is the total strength of a class.
Row A82 and Row A82 display the total number of boys and girls in the class. It remains the same unless there is any change in class strength.
Completing the data entry of attendance for each student every month, the reports are prepared automatically. There are 3 reports:
- Month-Wise Report
- Gender-Wise Annual Report
- Student-wise Annual Report
Month-wise Annual Attendance Report
This report is created automatically as all the cells contain predefined formulas. The monthly report is displayed in tabular form.
It shows the number of working days of each month as well as total cumulated days till that month. It also displays different averages of attendance for that month.
These include month-wise daily average, the monthly average of presence and a cumulative average of presence.
Student-wise Annual Attendance Report
It projects a cumulative report of each student for the whole academic year. The attendance is also shown in percentage.
Gender-wise Annual Attendance Report
A cumulative report that shows gender-wise attendance for each month for a complete academic year and its percentage.
With the help of this sheet, a tutor can save a great amount of time that can be easily used in other productive tasks.
We thank our readers for liking, sharing and following us on different social media platforms.
If you have any queries please share in the comment section below. We will be more than happy to assist you.