Substitute Teacher Coverage and Assignment Log
Track daily substitute teacher coverage, open classes, and escalation follow-up in one log. Use it to see fill rates at a glance and document who covered each assignment.
Trusted by frontline teams 15 years of frontline software
Built for: K 12 Education · School District Operations · Charter Schools
Overview
This Substitute Teacher Coverage and Assignment Log template is built to record which classes needed coverage, which substitutes were assigned, which classes stayed open, and what follow-up happened after a gap. It gives campus and district staff a single place to capture the daily staffing picture without relying on scattered emails, sticky notes, or verbal handoffs.
Use it when you need a repeatable daily record of substitute coverage across one campus or multiple schools. The log works well for morning staffing checks, midday updates, and end-of-day review because it separates the summary counts from the assignment-level details. The audit trail fields also make it easier to confirm who reviewed the log and when.
Do not use this template as a general absence request form or a teacher evaluation record. It is meant for coverage accountability, not for collecting sensitive employee information or narrative performance notes. Keep the fields focused on operational data: date, campus, totals, assignment details, unfilled reasons, escalation actions, and review status. If a class is unfilled, use the gap section to document the reason and next step instead of adding extra free-text fields that make the log harder to scan.
Standards & compliance context
- Keep the form aligned with GDPR data minimization by collecting only the staffing details needed for coverage and follow-up.
- If the log is used in an HR-adjacent workflow, avoid unnecessary PII and keep comments focused on operational facts rather than personal information.
- Use an audit trail with reviewer and timestamp fields to support internal accountability and recordkeeping.
General regulatory context for orientation only — verify current requirements with counsel or the relevant agency before relying on this template for compliance.
What's inside this template
Log Details
This section anchors the record to one campus and one submission window so the coverage data can be traced later.
-
Log Date
Select the date the coverage log applies to.
-
Campus / School Name
Enter the school or campus name.
-
Submitted By
Enter the name or role of the staff member submitting this log.
-
Submission Time
Optional timestamp for audit trail purposes.
Coverage Summary
This section gives a quick read on how many classes needed coverage, how many were filled, and whether the day is fully covered.
-
Total Classes Needing Coverage
Enter the number of classes or periods that required substitute coverage.
-
Total Filled
Enter the number of classes that were successfully covered.
-
Total Unfilled
Enter the number of classes that remain without coverage.
-
Coverage Status
Select the overall coverage outcome for the day.
-
Fill Rate (%)
Optional percentage of classes filled. Use this if your team tracks fill rate manually.
Assignment Details
This section captures the class-level substitute assignments so staff can verify who covered each period or room.
-
Daily Assignment Log
Record each class or period assignment, the assigned substitute, and whether coverage was confirmed.
Coverage Gaps and Escalation
This section documents open classes, why they stayed unfilled, and what escalation steps were taken next.
- Are there any unfilled assignments?
-
Unfilled Assignment Details
Describe the classes or periods that were not covered and why.
-
Primary Reason for Coverage Gap
Select the main reason or reasons a class was left unfilled.
-
Escalation / Follow-Up Actions
Document any calls, reassignments, admin coverage, or follow-up steps taken.
Audit Trail and Submission
This section records who reviewed the log and when, creating accountability and a clear follow-up trail.
-
Reviewed By
Optional reviewer name or role for the audit trail.
-
Review Timestamp
Optional date and time the log was reviewed.
-
Additional Comments
Add any other notes relevant to staffing accountability or follow-up.
How to use this template
- Enter the log date, campus name, submitter, and submission time so the record is tied to one specific coverage window.
- Fill in the coverage summary with the total classes needing coverage, the number filled, the number unfilled, and the resulting coverage status and fill rate.
- Add each substitute assignment in the assignment table with the class, time block, assigned substitute, and any brief handoff notes needed for the day.
- If any classes remain open, mark has_unfilled_assignments and complete the unfilled assignment details, reason, and escalation actions fields.
- Have the reviewer verify the log, add the review timestamp, and record any additional comments or follow-up needed for the campus or district team.
Best practices
- Use structured fields for class, period, and substitute name instead of burying key details in a single notes box.
- Keep the assignment table aligned to your bell schedule so staff can scan coverage by time block without extra interpretation.
- Use conditional logic to show unfilled assignment details only when there are open classes, which keeps the form shorter and easier to complete.
- Record the reason for each gap using a controlled set of options when possible, such as no substitute available, late cancellation, or late absence notice.
- Add a clear submission confirmation line so staff know whether the log was received and reviewed.
- Limit comments to operational follow-up and avoid collecting unnecessary PII or personal notes about teachers or substitutes.
- Review repeated gap patterns by campus and time of day so staffing fixes can be targeted instead of handled case by case.
What this template typically catches
Issues teams running this template most often surface in practice:
Common use cases
Frequently asked questions
What does this substitute teacher coverage log track?
This template tracks the daily status of substitute coverage by campus, including classes needing coverage, filled and unfilled assignments, and the overall coverage status. It also captures assignment-level details, reasons for gaps, and escalation actions so follow-up is documented. The review fields and audit trail help show who checked the log and when.
Who should complete this form?
It is usually completed by a school operations coordinator, attendance clerk, front office manager, or staffing lead who is responsible for daily coverage. A campus administrator may review it at the end of the day or after a shortage is resolved. If your district uses a central staffing office, the local campus can submit the log and the central team can review it.
How often should this log be used?
This template is designed for daily use, typically once in the morning and again after any mid-day changes. Some schools keep one log per campus per day, while others update it throughout the day as assignments change. If coverage is handled in shifts, you can add a submission time field for each update.
What should be included in the assignment table?
The assignment table should list the class, period or time block, assigned substitute, and any notes needed for handoff. Keep the fields focused on coverage and avoid collecting unrelated PII. If you need more detail, use conditional logic so only relevant follow-up fields appear when an assignment is unfilled or changed.
How does this help with escalation and accountability?
The unfilled assignment section records which classes were not covered, why the gap happened, and what actions were taken next. That creates a clear audit trail for principal follow-up, district staffing review, or parent communication if needed. It also makes repeated shortage patterns easier to spot across campuses.
Can this template be customized for elementary, middle, or high school use?
Yes. You can rename fields to match bell schedules, add grade-level or subject fields, and adjust the assignment table for self-contained classrooms or departmentalized schedules. For elementary schools, you may want homeroom and specials coverage fields; for secondary schools, period, subject, and room number are often more useful.
What are common mistakes when using a coverage log like this?
Common mistakes include marking every field required, using free-text notes where structured fields would work better, and failing to record why a class stayed unfilled. Another issue is skipping the review step, which weakens accountability. The best logs keep the form short, use conditional logic for exceptions, and include a clear submission confirmation.
Can this connect to other staffing or HR workflows?
Yes. It can be paired with absence reporting, substitute request workflows, payroll review, or campus operations dashboards. Many teams also use the log as a source for weekly staffing summaries or escalation reports. If you integrate it with a ticketing or workflow tool, keep the assignment status fields consistent so the data stays usable.
Related templates
Go deeper on the topic
-
A standard operating procedure (SOP) is a documented, step-by-step procedure for a repeatable task — the written version of "how we do this here." Good SOPs...
-
Workforce management (WFM) is the operational discipline of getting the right employees, with the right skills, in the right place, at the right time — and...
-
A daily huddle is a brief (10–15 minute) standing meeting held at the start of a shift or workday to align the team on priorities, surface issues, and...
-
A deskless worker is any employee whose job happens without a desk, a company laptop, or a fixed workstation. They're roughly 80% of the global workforce —...
-
Gallup 2026 workplace report reveals falling engagement, manager burnout, and $10T losses—actionable HR insights for leaders.
-
See how the Kansas City Chiefs unified communication for 600+ event staff with a branded app, achieving 90% adoption and reaching every employee on game day.
-
A vendor-agnostic checklist covering architecture, frontline access, AI, compliance, and payroll to evaluate any scheduling platform.
-
AI employee self-service assistants cut HR and IT support time with instant answers, automated routing, and better employee experience.
Ready to use this template?
Get started with MangoApps and use Substitute Teacher Coverage and Assignment Log with your team — pricing built for small business.
