IEP Caseload Tracker | Excel & Google Sheets for Special Education Teachers | Goal Progress Service Minutes IEP Dashboard | Digital Download

Are you a special education teacher
or case manager drowning in IEP
deadlines, service minutes, goal
data, and parent communication?

This tracker puts your entire
caseload in one organized system
— and it runs itself.

━━━━━━━━━━━━━━━━━━━━━━
📦 WHAT YOU GET — BOTH VERSIONS!
━━━━━━━━━━━━━━━━━━━━━━

✔ Excel Version (.xlsx)
Download and use immediately
in Microsoft Excel or
upload to Google Drive.
Works on PC and Mac.

✔ Google Sheets Version (PDF)
Contains your instant access
link + step-by-step instructions
to make your own editable copy
in Google Sheets. Free Google
account required.

Use whichever version works
best for YOUR district!

━━━━━━━━━━━━━━━━━━━━━━
📊 11 POWERFUL TABS INSIDE
━━━━━━━━━━━━━━━━━━━━━━

✔ 📖 Tab 1: How To Use
Full setup guide, privacy
reminders, and instructions.
Start here before anything else.

✔ 📊 Tab 2: Visual Dashboard
16 color-coded KPI boxes that
auto-update the moment you
enter data. See your entire
caseload status at a glance —
IEPs overdue, meetings this
month, goals at risk, services
behind, and more.

✔ 📋 Tab 3: Caseload Manager
All students in one place.
IEP dates auto-calculate days
remaining. Status color-codes
automatically: green, yellow,
orange, or red. Next action
fills in automatically.

✔ 👤 Tab 4: Student Snapshot
Complete at-a-glance profile
for every student. Strengths,
needs, services, accommodations,
goals, team members, and parent
notes — all in one place.
Perfect for IEP meetings.

✔ 📅 Tab 5: IEP Deadline Tracker
Track every meeting type with
an 11-column prep checklist.
Parent notice, teacher input,
provider input, goals drafted —
all tracked in one row.

✔ 🎯 Tab 6: Goal Progress Monitor
Quarterly progress for every
IEP goal with auto status.
Goal Met, Making Progress,
or Needs Attention —
auto-calculated every quarter.

✔ 📈 Tab 7: Weekly Goal Data
Ongoing data collection for
regular progress monitoring.
Data type dropdowns, prompt
level tracking, setting log,
evidence column, staff initials.

✔ 📞 Tab 8: Parent Contact Log
Every interaction documented.
Contact method dropdowns,
follow-up tracking, and
auto summary stats at bottom.

✔ ⏱️ Tab 9: Service Minutes Log
Daily and weekly service
tracking. Missed minutes
auto-calculate. Reason missed
dropdowns. Make-up minutes log.
Compliance status auto-fills.

✔ 🛠️ Tab 10: Accommodations
All accommodations logged by
type, setting, staff responsible,
start date, review date, and
implementation status.

✔ 🎓 Tab 11: Transition Planning
IDEA-aligned transition planning
for students 16+. Post-secondary,
employment, and independent
living goals tracked.

━━━━━━━━━━━━━━━━━━━━━━
🎯 WHO THIS IS FOR
━━━━━━━━━━━━━━━━━━━━━━

✔ Special education teachers
at any grade level
✔ IEP case managers
✔ Resource room and SDC teachers
✔ Inclusion and co-teachers
✔ High school SPED teachers
managing transition planning
✔ New SPED teachers who need
an organized system from Day 1

━━━━━━━━━━━━━━━━━━━━━━
⚡ HOW TO ACCESS
━━━━━━━━━━━━━━━━━━━━━━

EXCEL VERSION:
1. Download the .xlsx file
2. Open in Microsoft Excel
or upload to Google Drive
3. Start on the How To Use tab
4. Replace sample data with
your own students
5. Use INITIALS only —
never full names!

GOOGLE SHEETS VERSION:
1. Download the PDF file
2. Click the Google Sheets
link inside the PDF
3. File → Make a Copy →
Save to your Google Drive
4. Your personal editable
copy is ready instantly!
5. Access the Google Sheet on your phone using the QR code

━━━━━━━━━━━━━━━━━━━━━━
💻 COMPATIBILITY
━━━━━━━━━━━━━━━━━━━━━━

✔ Microsoft Excel (all versions)
✔ Google Sheets (free)
✔ Excel Online
✔ Works on PC, Mac, tablet
and mobile
✔ Access from anywhere!

━━━━━━━━━━━━━━━━━━━━━━
🏆 WHY PLAYBOOKDEPOT
━━━━━━━━━━━━━━━━━━━━━━

Built by Mauricio — a community
college counselor, dual enrollment
professor, and educator with 14+
years of experience supporting
students across Southern California.

M.S. in Educational Counseling.
Real schools. Real caseloads.
Real experience.

━━━━━━━━━━━━━━━━━━━━━━
⚖️ PROFESSIONAL USE NOTE
━━━━━━━━━━━━━━━━━━━━━━

This tracker is a communication
support tool for educator planning
purposes only. It does not replace
licensed professional judgment,
official IEP documents, district
systems, legal guidance, or required
professional training. Always follow
your school, district, state, and
federal laws and regulations.
PlaybookDepot assumes no
responsibility for outcomes from
use of this material.

━━━━━━━━━━━━━━━━━━━━━━
📥 WHAT YOU GET
━━━━━━━━━━━━━━━━━━━━━━

✔ Excel file (.xlsx) —
download and use immediately
✔ Google Sheets access PDF —
instant link + instructions
✔ 11 fully organized tabs
✔ Auto-calculating formulas
✔ Color-coded status system
✔ Works in Microsoft AND Google
✔ Instant digital download
✔ Lifetime access

━━━━━━━━━━━━━━━━━━━━━━
📌 PLEASE NOTE
━━━━━━━━━━━━━━━━━━━━━━

Digital download only. No physical
product will be shipped. Google
Sheets version requires a free
Google account. All sales final.
Questions before purchasing?
Message us — happy to help!

────────────────────────────
⚠️ GETTING STARTED WITH YOUR TRACKER
────────────────────────────
This workbook includes sample data to show you how the
dashboard, formulas, and automated calculations work.

1. Go to File → Save a Copy before entering your own
data so you always have a clean master backup of
this tracker.

2. Delete the sample entries in the white and yellow
input cells only — such as student initials, dates,
and settings.

3. Do not delete or type over columns marked with
"(Auto)" such as Sessions Held, Attendance Rate,
Grade %, or Growth. These cells contain the formulas
that make the tracker update automatically.


Welcome to PlaybookDepot.
Every Play You Need,
All In One Place. 🏪