School & Childcare Data Tracker Templates | Editable Excel | Assessment, Behavior, Attendance, MTSS
Track the data that matters in one color-coded workbook, and let the dashboard do the math. These editable Excel templates (they also open in Google Sheets) help classroom teachers, grade-level teams, school leaders, and childcare or early learning programs see assessments, focus standards, behavior, and attendance at a glance. Type student names once on the roster and every tab, chart, and summary fills in automatically.
What's inside
- School-Wide Data Tracker (K-5), 13 tabs: Start Here guide, Dashboard with 12 KPI tiles, 3 native charts, and a Grade-Level / School Rollup table for team data meetings, Class Roster (30 students) with editable score cutoffs, ELA, Math, Science, and Social Studies assessment trackers (10 assessments each, with a focus standard code and description on every column, student and class averages, and 4-color Exceeding / Meeting / Approaching / Beginning bands), Focus Standards mastery grid (1-4 dropdown), Behavior Log and Behavior Summary with a color-coded 10-week trend, monthly Attendance grid (P/A/T/E) with attendance % and chronic absence flags under 90%, MTSS / Intervention Log with tiers and progress checks, and Parent Contact Log with follow-up tracking
- Childcare and Early Learning Program Tracker (ages 0-5, PreK, before- and after-school), 9 tabs: Start Here, Program Dashboard with 3 charts, Child Roster (40 children, auto-calculated age, blank guardian and emergency contact columns), Daily Sign-In / Sign-Out with hours, monthly Attendance with flags under 90%, Developmental Milestones checklist (24 indicators across social-emotional, language, literacy, math, physical, and cognitive domains with Not Yet / Emerging / Developing / Mastered dropdowns), Behavior and SEL Notes, Incident and Health Log, and Ratio and Staffing Log that flags Over Ratio checks
- SAMPLE and BLANK versions of both workbooks: explore the sample with practice data, then start fresh in the blank copy
- Quick Start Guide (4-page PDF) with screenshots of every tab and step-by-step customizing tips
Built for real use: dropdowns on every coded column, a color legend on every color-coded tab, frozen header rows, gray formula cells you never have to touch, and print setup on every tab (landscape, one page wide). Change the score cutoffs once and every color and count updates.
LOW PREP: about 2 minutes a day for attendance and behavior tallies. Works in Microsoft Excel and Google Sheets.
License: Single-classroom or single-program license. For school, team, or multi-site licenses, send a message through the store's Contact page.
Note: sample standards are grade 4 examples, and childcare ratios are placeholders. Enter your own state standards and licensing requirements.
Designed by a classroom teacher and instructional coach. Illustrations are created with AI tools; all content is written and reviewed for standards alignment and classroom use.