Option 2: To mark a student as excused, where the student is effectively considered " Absent" in the attendance calculation, use the letters "EX".This simple spreadsheet is a great way to record attendance at meetings, clubs, scouts, church, and Sunday School classes. Option 1: To mark a student as excused, where the student is effectively considered " Present" in the attendance calculation, use the letter "E". You can choose two different ways of marking a student as "Excused". You can use either capital letters or lowercase letters.
("E" counts as "Present", and "EX" counts as "Absent") To mark a student as being excused, type the letter "E", or the letters "EX".To mark a student absent, either type the letter "A", or the number "0".To mark a student present, either type the letter "P", or the number "1".You can also mark a student as "Excused", which will display differently visually… but will count as "Present" in the versions that calculate. There are a couple of different ways to mark a student present or absent in the attendance templates. Marking students "Present", "Absent", and Excused" *Note: In each of the templates, the cells that should NOT be edited, will display a warning if you try to edit them.
This template is the same as the one above (has calculated attendance rate), but shades Saturdays and Sundays (or whichever days that you choose) in grey color. This template allows you to track daily attendance, and it also calculates attendance rates for you! It will display how many days the student attended, how many days they were absent, and the percent attendance rate.Ĭalculated attendance template (Shaded Weekends) This template is the same as the previous one, but has conditional formatting that shades the weekends grey so you can easily see the calendar weeks. Simple attendance template (Shaded Weekends) This simple template will allow you to track daily attendance, and does not contain calculations. On the sheets that have "Shaded Weekends", give the sheet a moment to adjust the conditional formatting after entering the timeline start date. Quick explanation of attendance template versionsĮach of the templates below will allow you to track attendance for up to 1 year, and for up to 100 students.
0 kommentar(er)
