Monthly Attendance Sheet
- Version
- 14'312 Downloads
- 18 KB File Size
- January 3, 2022 Updated
- 0 Number of comments
- Rating
There are school attendance sheets, meeting attendance sheets, employee attendance sheets, and many other types of attendance sheet templates, all tailored toward a specific theme. But a basic, theme-less attendance sheet can offer more flexibility. We offer a generalized monthly attendance sheet template, which can be used to record attendance for any type of program or activity. This template also comes with an automated monthly calendar.
Template Contents
Below is a list of worksheets included in this template.
Monthly
A monthly attendance sheet, which includes daily attendance tracking for up to 25 attendees. This attendance sheet includes the following data fields -
- Number
- Name
- Title
- Department
Setup
A worksheet that controls how months and weekends are displayed on the “Monthly” attendance sheet.
Using the Template
General Use
Monthly Attendance Sheet
Since this is a generalized template, enter a new title that describes the monthly activity for which attendance will be recorded. In the example below, this attendance sheet will be used to record monthly “Rowing Club” practice participation.
Tip: You can change the gray and white attendance sheet color scheme by changing background color and text color. A tutorial on modifying color schemes can be found here.
Enter the year in the “Year” field at the top of the worksheet. At the beginning of each month, select the current month from the dropdown menu in the “Month” field.
Once the month is selected, all days of the current month will be displayed horizontally across the top of the sheet.
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.
You can change the column headings to fit the activity for which you are tracking attendance. For example, “Title” and “Department” column headings are included as standard fields in this template, but these fields may have little to do with your program or activity. Therefore, in this example, you can replace the standard column headings with fields such as “Rank” and “Weight” to record information about your rowing team.
Setup
The Setup worksheet contains a list of months and a list of weekend markers. The list of months makes up the “Month” dropdown list on the “Monthly” worksheet. The list of weekend markers indicates which days will be displayed as weekend days on the monthly attendance sheet. For example, if there is rowing practice on Saturdays or Sundays, weekends can be displayed as regular practice days on the monthly attendance sheet.
To make a weekend marker selection, use the dropdown to select “Yes” (weekend) or “No” (non-weekend).
A “Yes” selection is formatted in gray on the monthly attendance sheet to represent a weekend day, as shown below.
Track Attendance
There are various ways to track attendance. For example, enter a letter such as an “X” or a “P” into the box when the person is present.
Attendance can also be tracked using color codes. In the example below, green is used to indicate that the person is present, while red is used to indicate absence.
Number the days to indicate positive attendance and make counting total attendance a snap.
If you are a fan of checking the box, you can use check marks to take attendance, too! To enter a checkmark, use the “Wingdings 2” font and enter “P” into the cells.
If there are more than 25 attendees, expand the worksheet to include as many attendees as necessary. To add more people, simply copy (Ctrl + C) the last row of the worksheet and “Insert Copied Cells” under the last row. Finally, update the attendee number and all other information.
Tip: Column headings will disappear if you scroll down toward the middle of the page. Use the “Freeze Panes” option to retain column headings. A tutorial on how to freeze panes can be found here.
New Sheets and Historical Records
If you are tracking multiple monthly meetings, create multiple attendance sheets and organize them in one file. You may also want to save and organize previous monthly attendance sheets. Create a new worksheet for each month (or new meeting theme) by duplicating the previous worksheet. This method will allow you to create historical records of previous attendance sheets. Finally, delete any old attendance records from the previous worksheet.
Tip: Create copies of attendance sheets before using them to avoid deleting old information.
A tutorial on duplicating worksheets can be found here.
