It may seem unnecessary to track homeschool attendance. After all, you know when you educating your children at home. However, depending on where you live and homeschool, information such as the attendance is required by regulatory authorities on a regular basis. To help with the attendance tracking for your at-home students, we offer a Homeschool Attendance Sheet template with automated start month.
Free Homeschool Attendance Sheet
Below are the list of worksheets included in this template.
Attendance
A 12-month, daily attendance worksheet, with an automated start month feature.
Setup
A worksheet that controls the start of month to be displayed on the “Attendance” worksheet.
Free Homeschool Attendance Sheet
Attendance Worksheet
Make yourself feel at home with your homeschool attendance sheet just by adding a personal title. Next, populate important fields, such as School Name, School Term, Student’s Name, Chief Administrator, and others.
You can also change the gray and white attendance sheet color scheme so by modifying the background and/or text colors.
Finally, there is a also sign off section down at the bottom to finalize this document before filing and submitting the attendance sheet.
Setup Worksheet
Go to Setup worksheet to set the start month.
Once the “start month” is selected in the Setup worksheet, it will automatically change the first month in the Attendance worksheet, to reflect your selection.
Track Attendance
Attendance can be taken in many different ways. The easiest way is to enter a letter, such as an “X” or a “P,” into the box when the student is present. Thus, Building from this, you can create letter codes to represent types of attendance.
Thus, Attendance can also be tracked using color codes.
Number of the days to represent positive attendance and make counting the total attendance a snap.
If you are a fan of checking the box, you can also use check marks to take attendance. To enter a checkmark, use the “Wingdings 2” font and enter “P” into the cells.
Calculate Attendance Totals
Attendance totals can be calculated manually, but this method could be time consuming. To save time, attendance can be calculated automatically using the simple formula. For example, if you are using an “X” to count attendance, enter the following formula into the “Total” column at the end of the first month:
This formula will also capture any attendance marked with an “X” (for row 9) with a range of C9 to AG9. Drag this formula down to automatically calculate the attendance for all months.
New Sheets and Historical Records
If you are homeschooling more than one student, you may want to create multiple attendance sheets to keep organized in one file. To create multiple attendance sheets, duplicate the original attendance sheet until there is an attendance sheet for each student. You can also create a new attendance sheet for the same student each year by using the same method.
