Loading...
operations

Substitute Teacher Coverage and Assignment Log

Track daily substitute teacher assignments, fill rates, and open coverage gaps in one log. Use it to document who was covered, what remained unfilled, and when an issue was escalated.

Trusted by frontline teams 15 years of frontline software

Built for: K 12 Education · School Administration · District Operations

Overview

The Substitute Teacher Coverage and Assignment Log template is a daily workplace form for recording substitute assignments, coverage status, and any gaps that need escalation. It brings the day’s staffing decisions into one structured record so school offices can see what was covered, what remained open, and who made the final call.

Use this template when your team needs a repeatable way to track substitute placement across classes, periods, or rooms. The Log Details section captures the coverage date, school name, preparer, and submission notes. The Assignment Summary section gives a quick read on total classes needing coverage, total classes filled, coverage status, and fill rate. The Assignment Details section is where each class-level assignment is documented, while Coverage Gaps and Escalation records the reason a class was not filled, the gap details, and whether an administrator was notified. The Audit Trail preserves decision maker, last updated, and follow-up status.

This template is a good fit for daily operations, staffing accountability, and end-of-day review. It is not the right form for hiring substitutes, collecting employment documents, or managing long-term staffing plans. If you only need a quick text message thread or a one-off absence note, a structured log may be more than you need. But if you need consistent reporting, clear handoffs, and a record that can be reviewed later, this template keeps the process organized without forcing extra fields.

What's inside this template

Log Details

This section identifies the day and school so the coverage record can be searched, compared, and audited later.

  • Coverage Date (required)

    Date the substitute coverage log applies to.

  • School Name (required)

    Name of the school or campus.

  • Prepared By (required)

    Name or role of the person completing this log.

  • Notes

    Use this log to record daily substitute coverage, fill rates, and any gaps. Do not include student PII.

Assignment Summary

This section gives a quick snapshot of staffing coverage and helps reviewers see the day’s fill rate at a glance.

  • Total Classes Needing Coverage (required)

    Number of classes or periods that required substitute coverage.

  • Total Classes Filled (required)

    Number of classes or periods successfully covered.

  • Overall Coverage Status (required)

    Select the day’s overall staffing outcome.

  • Fill Rate (%)

    Calculated fill rate based on classes filled divided by classes needing coverage.

Assignment Details

This section records each class-level assignment so the school can verify exactly who covered what.

  • Substitute Assignment Log (required)

    Record each class or period, assigned substitute, and coverage outcome.

  • Coverage Outcome Key

    Use the table to mark each assignment as Filled, Split Coverage, or Unfilled.

Coverage Gaps and Escalation

This section documents any open classes and the reason they stayed unfilled, along with the escalation path.

  • Number of Unfilled Classes (required)

    Count of classes or periods that remained uncovered.

  • Primary Reason for Coverage Gap (required)

    Select the main reason the assignment was not filled.

  • Coverage Gap Details

    Briefly describe the gap, including the affected period or class and any immediate mitigation steps.

  • Escalated to Administrator? (required)

Audit Trail

This section preserves who made the decision, when the log changed, and whether follow-up is still needed.

  • Decision Maker

    Name or role of the person who approved the final coverage plan.

  • Last Updated

    Timestamp of the most recent update to this log.

  • Follow-Up Required?

    Select if additional staffing review or corrective action is needed.

How to use this template

  1. 1. Enter the coverage date, school name, preparer, and any submission notes in Log Details before assignments are finalized.
  2. 2. Record the total classes needing coverage and total classes filled, then calculate or validate the fill rate in Assignment Summary.
  3. 3. Fill out the assignment table with each class, the assigned substitute, and the coverage outcome using consistent status labels.
  4. 4. If any classes remain open, complete Coverage Gaps and Escalation with the reason, gap details, and whether an administrator was notified.
  5. 5. Save the decision maker, last updated time, and follow-up requirement in the Audit Trail so the record shows who closed the loop.

Best practices

  • Use a fixed set of coverage outcome values so staff do not invent new labels for the same situation.
  • Make coverage date and school name required fields so each log can be filtered and audited later.
  • Use conditional logic to show gap details only when a class is unfilled or partially covered.
  • Keep the assignment table aligned to the school’s actual schedule, such as periods, rooms, or subject blocks.
  • Record the escalation path the same day the gap is identified, not after the fact.
  • Avoid collecting unnecessary PII about substitutes or students; only capture what the school needs to manage coverage.
  • Review fill rate and unfilled class counts at the end of each day to spot recurring staffing patterns.

What this template typically catches

Issues teams running this template most often surface in practice:

Coverage status is marked too broadly, making it impossible to tell whether a class was fully covered or only partially covered.
The assignment table lists a substitute but does not show which class or period they covered.
Unfilled classes are noted without a reason, which weakens follow-up and trend review.
The log is submitted without a last updated time, so later edits cannot be traced.
Escalation to an administrator is skipped even when coverage gaps remain open.
Fill rate is left to manual interpretation instead of being captured as a clear field or validated calculation.
Submission notes are used for important decisions that should have their own structured fields.

Common use cases

Elementary School Front Office Coverage Log
A front office team uses the form each morning to assign substitutes to homeroom and specialist classes. The log helps them confirm which rooms are covered before the first bell and which gaps need immediate escalation.
Middle School Period-by-Period Assignment Record
An attendance clerk tracks substitute coverage by period, room, and subject area. This makes it easier to see partial coverage, reassignments, and classes that need a backup plan later in the day.
District Operations Daily Fill-Rate Report
A district office compiles logs from multiple schools to compare coverage status and unfilled class counts. The structured fields support consistent reporting without relying on scattered emails or chat messages.
Emergency Absence Escalation Log
When a teacher calls out after the day has started, the school uses the form to document the gap, the interim coverage decision, and the administrator who was notified. The audit trail shows how the issue was handled from first notice to follow-up.

Frequently asked questions

What is this template used for?

This template records daily substitute teacher coverage for a school or district. It captures the date, school name, assignment summary, individual class coverage, and any gaps that need escalation. Use it when you need a clear record of what was filled, what was not, and who handled the follow-up.

Who should complete the log?

A school office manager, attendance clerk, substitute coordinator, or administrator usually prepares it. The person filling it out should have access to the day’s staffing decisions and the final coverage outcome. If multiple people contribute, use the audit trail fields to show who made the final decision and when.

How often should this log be completed?

This is typically a daily form, completed before the school day starts and updated if coverage changes during the day. Some schools also keep a running record for late-call absences, partial-day coverage, or emergency reassignments. If your process is weekly, the same structure still works as a summary log.

What should be included in the assignment table?

The assignment table should list each class or period needing coverage, the assigned substitute, and the coverage outcome. Use conditional logic or separate fields to show whether the class was fully covered, partially covered, reassigned, or left unfilled. Keep the entries specific enough that a reviewer can understand the day without reading email threads.

How does this template help with accountability?

It creates a simple audit trail showing the coverage status, the decision maker, the last update, and whether follow-up is required. That makes it easier to review staffing patterns, confirm escalation, and spot recurring gaps. It also reduces confusion when multiple staff members are coordinating the same day’s coverage.

Can this template be customized for different schools or grade levels?

Yes. You can add fields for grade band, subject area, room number, or special program coverage if those details matter to your workflow. Keep the form lean and use progressive disclosure so extra fields only appear when they apply. That helps avoid collecting unnecessary PII or cluttering the log with fields no one uses.

What are common mistakes when using this log?

Common mistakes include leaving the fill rate blank, using vague coverage statuses, and failing to record why a class stayed unfilled. Another issue is skipping the escalation field, which makes it hard to prove that the gap was addressed. The log works best when every day ends with a clear outcome and next step.

How does this compare with tracking coverage in email or chat?

Email and chat are useful for coordination, but they are hard to audit later and easy to lose. This template turns those decisions into a structured record with consistent fields, validation, and a clear submission trail. It is better when you need repeatable reporting, not just ad-hoc communication.

Go deeper on the topic

Related concepts
  • 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 —...
Related guides

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.

Get Started