Daily Attendance Log • Automatic Attendance % • Chronic Absence Flags • Parent Contact Log • Editable Excel + Google Sheets

Log attendance once. Know who may need attention before patterns become persistent.

The Attendance Tracker turns daily marks into automatic percentages, status bands, and a class-wide overview — helping you spot attendance patterns quickly instead of waiting until the end of term.

Built for time-poor teachers, it uses light-yellow input cells, dropdown menus for status and absence reasons, and a dashboard that updates as you enter data.

Type a mark. Read the pattern.

What's Inside — 5 Ready-Made Tabs Tab What it does Attendance Log 200 rows for daily marks with Status dropdown (Present / Tardy / Excused Absence / Unexcused Absence) and an absence-reason dropdown Student Summary Up to 32 students with automatic days Present, Tardy, Excused & Unexcused, Total Days Logged, Attendance % and a Status band Parent Contact Log100 rows to record outreach to families: date, student, reason, contact method and outcome Dashboard Class attendance rate, students flagged for chronic absence, entries by status, absences by reason, and contacts by reason — with charts that update automatically How to Use Quick-start guide, mark-code legend, status-band thresholds, and usage tips

Attendance Status Bands

• Good Standing — Attendance % of 95% or higher

• Needs Watching — 90%–94.9%

• Chronic Absence — below 90%

These bands are configurable and are intended as practical tracking thresholds. Schools and districts should follow their own attendance policies and applicable definitions.

Why Teachers & MTSS Teams Will Find It Useful

• Automatic Attendance % — no manual math; each student's percentage and status band recalculates as you log attendance

• Excused absences handled separately — excused absences remain visible in the record while the attendance calculation can be configured to exclude them

• Instant status bands — conditional formatting shows Good Standing / Needs Watching / Chronic Absence as you enter data

• Dropdown menus — consistent statuses and absence reasons help keep entries organized

• Parent contact trail — record calls, messages, meetings, and outcomes in one place

• MTSS / RTI ready — attendance patterns can support tiered intervention and attendance-review discussions

• Protection built in — formulas and layout are locked; only designated input cells are editable

• Excel + Google Sheets — choose the format that works best for your workflow

• Sample data included — see how the tracker works before replacing the examples with your own student information

Perfect For

• Primary / elementary teachers tracking daily attendance for their class

• Attendance leads building early-warning lists for attendance concerns

• MTSS / RTI teams needing documented attendance and parent-contact records

• Pupil-progress and attendance-review meetings

• Home-school liaison teams recording family outreach in one place

• Teachers who prefer working in either Excel or Google Sheets

Files Included Excel Version

Attendance_Tracker.xlsx

Includes:

• 5 ready-made tabs

• Conditional formatting

• Dropdown/data validation

• 200-row daily attendance log

• Up to 32 students tracked in the summary

• 100-row parent contact log

• Password-protected formulas and layout

• Sample demonstration data

Google Sheets Version

An editable Google Sheets version is also included.

Use the provided Google Sheets link to create your own editable copy in Google Drive.

Important: When prompted, select Make a copy. Your personal copy is the version you should edit and use with your students.

The original template should not be edited or shared with others.

Important Information

• This is a digital resource. No physical product will be shipped.

• The tracker records both excused and unexcused absences for context.

• The attendance calculation is designed so that excused absences can be excluded from the percentage used for the status-band calculation.

• The included status bands are practical tracking thresholds and should be adapted to your school's, district's, or local authority's attendance policies where necessary.

• This resource supports attendance tracking, documentation, and intervention discussions. It does not replace your school's attendance, safeguarding, or intervention procedures.

• License: Single-classroom use only. Please purchase an additional license where required for use by another educator or class.

• Not for resale, redistribution, public posting, or uploading to file-sharing websites.

by Koco Kyo — friendly, practical resources that make great teaching easier.