How to Write a Report on Attendance

Simplify attendance tracking by using a template.

School districts track student attendance in accordance with state truancy laws, which vary. In Maine, for example, children ages 7 to 16 must attend school. A child of at least 7 who has not yet finished sixth grade is considered habitually truant if he misses seven instructional days in a school year or five instructional days in a row. Excused absences do not count against students. Thus, most attendance reports contain student information, days present and absent, and notations regarding whether absences are excused or unexcused.

1 Track Attendance

2 Download a free attendance-tracking form

Download a free attendance-tracking form, such as the "Monthly Class Attendance Form" or "Weekly Student Attendance Record" available on, or the "Home School Attendance Report" from Lake County ISD. (resources 1 and 2)

3 Open the attendance report in Excel

Open the attendance report in Excel, Word or other program for which the form is designed. Fill in the information daily or weekly, keeping track of student names, dates present, dates absent, whether absences are excused, and any notes you need to make regarding students' absences. Consult with the attendance clerk in your district to determine any additional tracking requirements, such as tardies.

4 Open the template

Open the template and print it if you prefer to keep records by hand.

5 Prepare Attendance Report

6 Upload or submit your data

Upload or submit your data as directed if your district maintains an electronic attendance system. Archive or save all data to a disk in case your submission fails or a file becomes corrupted.

7 Prepare a report manually

Prepare a report manually, if required, by following the template supplied by your district. Compile the data from your daily or weekly attendance-tracking form. Save a copy for yourself, and submit the original as directed.

8 Create your own attendance report

Create your own attendance report by summarizing the data for a specific marking period, such as a semester, quarter or six-week period. Include, at a minimum, the following background information: your name and the course you teach, the beginning and ending dates of the report period, each student's name, identification number, and grade level, as well as each student's ethnicity, if required by the district.

9 Add the compiled data

Add the compiled data for each student: list the total number of days in the reporting period, the number of days she was present, the number of days she was absent, and a comment regarding her total excused/unexcused absences. If the district requires it, include the number of times each student was tardy to class.

10 Copy the report

Copy the report, save one for yourself and submit the original to the attendance office.

Deanne Lachner has been writing and editing fiction and nonfiction for more than 15 years. She has published articles in "Working Women," "Performance Magazine" and the "Direct Selling News." Lachner holds a master's degree in English from Texas Woman's University and is pursuing a second master's degree in instructional design and technology.