K2 MTSS Blueprint Guide
K-2 MTSS Framework
K-2 MTSS Tracker Blueprint
Digital Spreadsheet Setup Schema & Data Validation Guide
Document Class Staff Reference
Purpose: This guide provides school staff with the exact schema, validation dropdowns, and developmental milestones needed to construct or configure digital tracking systems (Google Sheets/Excel) for Tiered support. Use the structured fields below to standardize weekly and monthly data entries.
1. Visual Spreadsheet Columns Map
A - D
E - H
I - L
M - N
O - P
Core Info
ELA Foundational Progress
Math Key Progress
Social-Emotional
Contact & Notes
ID / Name
PA | Phonics | SightW | ORF
Count | NumSense | Computation | Prob
Regul | Engage
Last Contact | Action Notes
01. Jane D.
OnOnDevInt
OnOnOnDev
CD
08/24 Parent Call re: Small group
2. Column Field Specifications
| Target Field | Format / Validation | Primary K-2 Indicator / Focus |
|---|
| ELA Foundational | Dropdown Menu | PA: Phonemic Segment/Blend |
| ELA Tier Rating | Tier 1 | 2 |
| Math Progress | Dropdown Menu | Count: Forward/Backward sequences |
| Math Tier Rating | Tier 1 | 2 |
| SEL / Behavior | C | D |
| Parent Contacts | Date | Type |
3. Data Validation Dropdown Configurations
Academic Fields
Status Dropdown
- On: At/Above Bench
- Dev: Developing
- Int: Intervention Needed
SEL / Behavioral
Growth Dropdown
- C: Consistent (T1)
- D: Developing (T2)
- E: Emergent (T3)
Intervention Tier
Global Tier Status
- 1 Tier 1 (Core Class)
- 2 Tier 2 (Targeted Group)
- 3 Tier 3 (Individualized)
K-2 MTSS Setup & Schema Blueprint Page 1 of 2
K-2 MTSS Framework
Primary Entry Rubric Matrix
Standardized Benchmarks to Guide Input Validation
Standard K-2 Developmental
ELA Foundational Standards
Kindergarten
- On: Know 20+ letter sounds; blend basic CVC.
- Dev: Struggles blending; identifies 10-15 sounds.
- Int: Letter-sound knowledge under 5; can't rhyming.
Grade 1
- On: Decodes consonant blends/digraphs; 30+ ORF.
- Dev: Halting decode; struggles with sight words; < 20 ORF.
- Int: No word-level blending; struggles with basic sight words.
Grade 2
- On: Decodes multisyllabic words; ORF 60+ WCPM.
- Dev: Reads word-by-word; low comprehension; ORF 40-59.
- Int: Decodes below Grade 1 level; ORF < 35 WCPM.
Mathematics Milestones
Kindergarten
- On: Count to 100; cardinality & subitize to 5.
- Dev: Counts with errors < 30; erratic 1-to-1 matching.
- Int: Cannot subitize small sets; counts under 10.
Grade 1
- On: Fact fluency +/- within 10; place value understanding.
- Dev: Relies entirely on finger-counting for + / -.
- Int: Disorganized addition; place value confusion.
Grade 2
- On: Fluently add/sub within 20; solve 2-step stories.
- Dev: Hard time with multi-digit regrouping.
- Int: Struggles with basic 1-digit addition; cannot count collections.
Behavioral / SEL Rating Key
C (Consistent)
Regulates strong emotions; actively follows group norms; respects classroom boundaries and safety.
D (Developing)
Needs co-regulation checks during changes/transitions; easily distracted in center-work.
E (Emergent)
Requires continuous behavioral redirection; shows extreme peer friction or classroom flight risk.
Parent Communication & Data Discipline
Logging Standards
Every Tier 2 and Tier 3 contact must be recorded inside the digital tracker. Standardize notes to protect student privacy while maintaining instructional utility:
- Keep notes brief: focus on strategy agreement.
- State agreed-upon home reinforcement ideas.
Spreadsheet Maintenance Checklist
Ensure reliable collaboration across your K-2 interventionist team:
- Update benchmark scores by Tuesday at 4:00 PM.
- Code parent phone calls within 24 hours.
- Highlight missing tests in bright yellow cells.
K-2 MTSS Setup & Schema Blueprint Page 2 of 2