Compressed Zip File
Be sure that you have an application to open this file type before downloading and/or purchasing. How to unzip files.
2.1 MB | 12 pages
This is an attendance spreadsheet that covers a typical school year (Monday to Friday, September 2016 - June 2017). 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 lookup" sheet which will automatically graph any given student's data against the class average.
It is possible to input two values into one cell. For example, of a student is late AND has forgotten their homework, you can input LH and both totals columns will go up by one.
I originally made this file using Apple's Numbers software, but I have included an Excel version, too, that should would pretty much the same way.