UPDATED for the 2017-2018 School Year.
This is an attendance spreadsheet that covers a typical school year (Monday to Friday, September 2017 - June 2018). 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.
Enjoy, and let me know if you need any help.