MORE MONTHLY ATTENDANCE TEMPLATES AND ATTENDANCE FORMS. Select a character from the drop-down list that corresponds to the Mark attendance, click into a cell for a particular student and day and All other cells on the monthly attendance template will update automatically with the characters entered into these cells. You want to use different characters or symbols enter them into cellsĪH8 (PRESENT), AH9 (LATE), AH10 (ABSENT) and AH11 (EXCUSED). Present L - Late X - Absent E - Excused If Marking AttendanceĪll monthly attendance templates have been setup using the following default characters to identify a students attendance. Names sorted when calling the class register.Ībove you will ensure that student names are sorted by surname. This will affect how the names are sorted. Take care not to enter a space before the student name as Names will be sorted alphabetically by the first letter of the student Select OK and your students will be sorted.

Select how you want your student names displayed, Ascending or Descending alphabetically. If the Student Name header in cell C8 was selected, STUDENT NAME should appear in the Sort by: selection box. Informing you that changes cannot be made until Protection is removed. If you have selected cells in other columns a message will be displayed If prompted, confirm that you wish to continue to sort the current selection. Ensure that the first cell selected is the Student Name: header in cell B8 2.

Highlight the Student Names in column B that you want to order. WhenĪll registered student names have been entered in this format intoĬolumn B, if you have not entered them alphabetically you can sort themīy doing the following. SMITH, John By entering names in this format, names can be ordered alphabetically (ascending or descending) by surname.

Use the following name format to ensure consistency, e.g. Recommend that you enter the surname first followed by the first name Entering Student Names Enter the names of the students that are registered to attend the class under the Student Name header in column B. Total attendance percentage figures are calculated for all classes delivered for the month to date.Įntering 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. Late, Absent or Excused that day is automatcially counted and a classĪttendance percentage calculated. Record (the column for a day) the total number of students Present, Header, the total number of classes the student is Present, Late,Ībsent or Excused is automatically counted and the students attendance To the right of each monthly student record (the row for a student) under the STUDENT TOTALS

Monthly staff roster template