How to Track Missing Assignments Without Chasing Students All Day

Missing work piles up fast. A simple logging routine, a three-strike rule and clear parent contact records turn chasing into a two-minute habit.

Published 2026-11-08 ยท 3 min read

Missing assignments have a way of multiplying. One forgotten worksheet becomes three, three becomes a failing grade, and by the time anyone notices, the conversation with the family is much harder than it needed to be.

The answer is not chasing harder. It is a small logging routine you can do in the last two minutes of a lesson.

1. Log it the moment it is missing

When you collect work, note who did not hand it in: date, student, assignment and status. Keep the statuses simple:

  • Missing: not handed in
  • Late: handed in after the due date
  • Turned in: resolved
  • Excused: absence or accommodation

One row per missing piece. That is it.

2. Use a three-strike rule

Decide in advance what happens at each level, so you are not making it up on a busy Thursday:

Missing piecesAction
1Quick reminder to the student
2Lunch or study-hall catch-up time
3+Contact home and agree a plan

Students with three or more missing pieces should be impossible to overlook, so make them stand out in red.

3. Contact home early and record it

A short, friendly message after the third missing piece is far easier than a difficult conference at the end of the term. Record every contact: date, method and outcome. Those notes protect you and help the next conversation start from facts.

4. Close the loop

When work comes in, change the status to *turned in*. Over time, your resolved percentage becomes a useful measure of whether your system is working.

5. Look for patterns

Once you have a few weeks of data, patterns appear: a student who struggles only with writing tasks, an assignment that half the class missed (which may be an instruction problem, not a student problem), or missing work that follows late arrivals. If lateness is part of the picture, a tardy tracker makes the link easy to see.

A ready-made tracker

The Missing Assignment Tracker spreadsheet does all of this in Excel or Google Sheets. It includes an assignment list, a missing work log with dropdowns, parent contact tracking, and a dashboard that counts missing and late work per student, flags anyone with three or more in red and charts the status of all work.

For conference season, keep your observations alongside it in the anecdotal notes and observation log, so every conversation with a family is backed by more than a grade.

More on this