Home/Spreadsheets/Special Ed & Teachers/Anecdotal Notes Tracker
Anecdotal Notes Tracker
An anecdotal notes tracker for teachers: every observation in one place, one row per note with what happened before and after, and a dashboard for each student. It opens in Microsoft Excel and in Google Sheets, has no macros and nothing to install, and is yours to reuse as often as you like.
What you get
- Notes Log: pick the student and focus area, then record before, what you saw, count, minutes, people involved, after, your interpretation and any follow-up
- A Check column turns green once the key fields are in, so thin notes stand out before a meeting
- Dashboard for one student or All Students: total notes, last 30 days, times observed, average minutes, open follow-ups and last date observed
- Amber flag when a student has not been observed in the number of days you choose, plus a focus-area mix and the 10 newest notes
- Student roster of up to 100 with notes logged and last observed filled in automatically
- Opens in Excel and in Google Sheets
$7.99one-time, no subscription
Buy on Etsy
Instant digital download · one-time purchase · no subscription
What it does
- Notes Log: pick the student and focus area, then record before, what you saw, count, minutes, people involved, after, your interpretation and any follow-up
- A Check column turns green once the key fields are in, so thin notes stand out before a meeting
- Dashboard for one student or All Students: total notes, last 30 days, times observed, average minutes, open follow-ups and last date observed
- Amber flag when a student has not been observed in the number of days you choose, plus a focus-area mix and the 10 newest notes
- Student roster of up to 100 with notes logged and last observed filled in automatically
- Getting Started has five rules for objective notes with do and don't examples, and six focus areas you can rename
What it looks like
Every tab in the workbook
These are the actual sheet names in the file, not a feature list.
- Dashboard
- Notes Log
- Students
Works in
- Microsoft Excel 2016 or later and Microsoft 365, on Windows or Mac
- Google Sheets, free, in any browser, including on a Chromebook (ready-made Sheets copy links are included)
- No macros, no add-ons
Honest scope
This is an organizational template. It reports the data you enter. It does not determine mastery, eligibility or compliance, and it does not replace your district documentation system — those stay your professional judgement.
Others in Special Ed & Teachers
- MTSS and RTI Small Group SchedulerAn MTSS and RTI small group scheduler: place students into tiered intervention blocks…$9.99View →
- School Nurse Health ManagerA school nurse health manager that keeps immunisations, screenings, health plans and…$13.99View →
- IEP Due Date Compliance CalendarEvery statutory clock on your caseload in one place — consent, evaluation, annual…$16.00View →
- IEP Goal TrackerAn IEP goal tracker for special education data collection and progress monitoring: one…$19.99View →
