About the Monthly Attendance Templates
Microsoft Office Excel 2003 or later
Yes - remove protection from worksheet to amend
This generic MS Excel attendance template allows up to 30 student names to be entered.
Simply enter the Month and Year required at the top of the attendance sheet, together with your class details.
Enter the day of the week under the corresponding day of the month. We recommend that you identify weekends by cell shading allowing you to more easily identify the day of the week.
Please note that class-templates.com no longer publishes an attendance sheet template on a monthly basis. If you would like a spreadsheet configured for each calendar month for 2013 please see our Attendance Sheets for 2013 .
To the right of each monthly student record (the row for a student) under the STUDENT TOTALS
header, the total number of classes the student is Present, Late,
Absent or Excused is automatically counted and the students attendance
percentage for the month calculated.
At the bottom of each daily record (the column for a day) the total number of students Present, Late, Absent or Excused that day is automatcially counted and a class attendance percentage calculated.
Total attendance percentage figures are calculated for all classes delivered for the month to date.
Instructions for use:
Entering Month, Year, Subject / Course, Group, Time and Location
Enter details of the Month, Year, Subject / Course, Group, Time and Location directly into the cells identified.
Entering Student Names
Enter the names of the students that are registered to attend the class under the Student Name header in column B.
I recommend that you enter the surname first followed by the first name of the student. Use the following name format to ensure consistency;
[SURNAME], [First name]
e.g. SMITH, John
By entering names in this format, names can be ordered alphabetically (ascending or descending) by surname.
When all registered student names have been entered in this format into column B, if you have not entered them alphabetically you can sort them by doing the following.
1. Highlight the Student Names in column B that you want to order. Ensure that the first cell selected is the Student Name: header in cell B8
2. From the Data menu select Sort...
If prompted, confirm that you wish to continue to sort the current selection.
NOTE: If you have selected cells in other columns a message will be displayed informing you that changes cannot be made until Protection is removed.
The Sort dialogue screen is displayed.
If the Student Name header in cell C8 was selected, STUDENT NAME should appear in the Sort by: selection box.
Select how you want your student names displayed, Ascending or Descending alphabetically.
Select OK and your students will be sorted.
Names will be sorted alphabetically by the first letter of the student name entered. Take care not to enter a space before the student name as this will affect how the names are sorted.
Think about how you want the names sorted when calling the class register.
Enter names in a format that best suit your requirements.
By using the recommended name format above you will ensure that student names are sorted by surname.
All monthly attendance templates have been setup using the following default characters to identify a students attendance.
/ - Present
L - Late
X - Absent
E - Excused
If you want to use different characters or symbols enter them into cells AH8 (PRESENT), AH9 (LATE), AH10 (ABSENT) and AH11 (EXCUSED).
All other cells on the monthly attendance template will update automatically with the characters entered into these cells.
To mark attendance, click into a cell for a particular student and day and select a character from the drop-down list that corresponds to the students attendance.
MORE MONTHLY ATTENDANCE TEMPLATES AND ATTENDANCE FORMS..
MORE FREE ATTENDANCE RECORD FORMS AND TEMPLATES..