See spreadsheets for 2017-2018 school year by following this link instead:
(previous spreadsheet also included in zip file)
This is an Excel attendance spreadsheet that covers a typical school year (2015-2016).
Each month is a separate sheet that will automatically tally lates, absences, and incomplete homework.
To use with your class:
Input your grade and students’ names on the AUGUST sheet.
After doing so, all following sheets will automatically match those changes.
Delete unnecessary rows from each month.
Add rows if necessary.
There is a separate sheet for each month and a totals sheet at the end. Also, there is a "student report" sheet which will automatically graph any given student's data against the class average.
Values may be entered using the drop-down menu or by typing directly into the cell. Typing into a cell allows for multiple values. For example, typing LH will tally both 'late' and 'homework' columns.