student attendance spreadsheet template excel

But if you are managing the class attendance sheet in Excel, totals can be calculated instantly by using a simple “COUNTIF” formula. Manually summing up attendance totals for each student can be time consuming.

For example, good students get a P (present), students who are late are marked with a T (tardy), and those that didn’t make it to class get an excused (E) or unexcused (U) absence.Īttendance records for each student can be summed up manually on the right, at the end of each month, as shown below. To track attendance for each student, for each day of school, enter a letter code to represent a type of attendance. Note: This worksheet is built to include up to 31 days if a month has fewer than 31 days, any extra columns will be blanked out, as shown below. Once the month is selected, all days of that month will be displayed horizontally across the top of the sheet. A tutorial on modifying color schemes can be found here.Īt the beginning of each school month, select the current month from the dropdown menu in the “Month” field. Tip: You can change the gray and white attendance sheet color scheme, for example to use your school’s colors or to have colors that represent a specific course. For example, a “Public School Code” might be included in the title, as shown below. You can also modify the standard title “CLASS ATTENDANCE SHEET” by entering a new title in that cell. Using the Template General Use Class Attendance Sheetīefore the bell rings and students flood the classroom, take a moment to enter general information in the fields below - Teacher, Room, Course, and Year. Template Contentsīelow is a list of worksheets included in this template.Ī monthly class attendance sheet, which includes daily attendance tracking for up to 25 students.Ī worksheet that controls how months and weekends are displayed on the Class Attendance Sheet. To help teachers, students, and parents track class attendance, we offer an easy-to-use Class Attendance Sheet with an automated calendar.

According to the National Center for Education Statistics, students who attend class regularly achieve higher grades than chronically truant students.

Class attendance is very important for student development and scholastic achievement.

Student attendance spreadsheet template excel