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 exclude a day from the student's overall attendance requirement. There are a couple of different ways to mark a student present or absent in the attendance templates. Marking students "Present", "Absent", and Excused" The default for this option is "Saturday" and "Sunday". On the tab labeled "Settings", simply select up to six days of the week by checking the checkboxes in column B, and these selected days will act as the "Weekend". You can select up to 6 days for this option. The tracker now also allows you to select which days of the week represent the "Weekend" at your school. In other words only list holidays that fall on weekdays. Only enter holidays that do not fall on weekends / that do not fall on the custom chosen weekend days, since those days are already being excluded from the calculations. Holidays that you have specified will highlight in yellow color on the attendance tracker timeline.įor each holiday date, the total days possible / days expected for all students will reduce by 1. On the "Settings" tab, in column G, list the dates of the holidays that you want to exclude from the attendance calculation, as shown in the image below. On the attendance templates that calculate attendance rate, you now have the option to exclude holidays from the calculations. Or click here to take the dashboards course Click here if you want the Excel version of the attendance templates.Ĭlick here to get your Google Sheets cheat sheet This page contains the attendance templates for Google Sheets.
You can set any start date that you want for the timeline to match your school's schedule… but the templates on this page have now been updated for the new 2023-2024 school year for your convenience! The calculated templates on this page have now been updated with the ability to exclude holidays, and all templates have been updated to display additional useful columns of data. Whether you want a simple place to track attendance, or if you want to automatically calculate attendance rates… below you will find the templates that you need. There are multiple attendance template versions that you can choose from, depending on how simple or in-depth you want your attendance tracker to be. If you are looking for an attendance template that you can simply make a copy of and start using right away, then you will find exactly what you need on this page! Google Sheets is the perfect place to track attendance.