attendance sheet template excel for students

Tip: Choose “center alignment” to line up the attendance records for aesthetics. This can be done manually or by using a simple formula (see “Calculate Attendance Totals”). Attendance can be recorded in many different ways - a quick and simple method is to mark students who are present with a “P” or an “X” in the appropriate cell.įinally, tally up total attendance for each student in the “Total” column. Next, enter the student names in the column labeled “Name” and take attendance. Once the dates are entered, they will appear vertically at a 76 degree angle, as shown below. Because the dates are not automatically set to appear every week (as they are in our “Dates” worksheets), the “Simple” attendance worksheets work great if you don’t have consecutive school sessions.

Next, enter the date of each school session across the top row. To start using the Sunday school attendance sheet, populate the standard fields as shown below.

No matter which orientation you select, the fields at the top are the same - “Title,” “School Name,” and “Starting Date.” Our “Simple” attendance sheet in landscape orientation, on the other hand, can display as many as 19 Sunday school sessions, but is best for class sizes of 25 or fewer students. However, the tradeoff is less space populate with dates. Portrait orientation provides more room for student names, to accomodate class sizes of 25 or more students. Our “Simple” attendance sheet is available in both portrait orientation and landscape orientation. Using the Template General Use Simple (Portrait and Landscape) This worksheet includes automated date setting. This worksheet includes automated date setting.Īn attendance sheet in landscape orientation with space for up to 25 students. Template Contentsīelow is a list of worksheets included in this template.Ī simple attendance sheet in portrait orientation, with space for up to 35 students.Ī simple attendance sheet in landscape orientation, with space for up to 25 students.Īn attendance sheet with the following letter codes in landscape orientation:Īn attendance sheet in portrait orientation with space for up to 35 students. To help Sunday school organizers run their programs, we offer a Sunday school attendance sheet template with 5 different attendance worksheets. Sunday school attendance records also provide trends of student engagement in religious studies over time. For example, attendance records can help Sunday school leaders make decisions about whether to add or subtract classes. Tracking Sunday school attendance can help a religious organization evaluate and adjust its services to meet the needs of its community.

Attendance sheet template excel for students