📊 Weekly IEP Strategy Review: Week <% tp.date.now("ww") % (<% tp.date.now("YYYY") %)
📊 Weekly IEP Strategy Review: Week <% tp.date.now("ww") %> (<% tp.date.now("YYYY") %>)
Weekly Operational Focus
- Review Date:
<% tp.date.now("YYYY-MM-DD") %> - Target Source Folder:
Accommodation Journal/03_observations/Daily/ - Primary Objective: Aggregate 5-day observation probes to evaluate student progress, strategy efficacy, and antecedent dysregulation patterns for Friday School-Based Team (SBT) check-ins.
📈 1. Weekly Student Performance Baseline
TABLE
Profile AS "Learning Profile ID",
round(average(rows.Effectiveness), 1) AS "Weekly Avg Success (1-5)",
length(rows.file.link) AS "Probes Logged",
rows.Strategy AS "Strategies Implemented",
rows.Regulation_State AS "Zones Recorded"
FROM "Accommodation Journal/03_observations/Daily"
WHERE file.day.year = date(today).year AND file.day.week = date(today).week
GROUP BY Profile
SORT round(average(rows.Effectiveness), 1) DESC
🛠️ 2. Strategy Efficacy Leaderboard (This Week)
TABLE WITHOUT ID
Strategy AS "Accommodation / Strategy",
round(average(rows.Effectiveness), 1) AS "Weekly Success Rate (1-5)",
length(rows.file.link) AS "Sessions Tested",
rows.Profile AS "Learners Supported"
FROM "Accommodation Journal/03_observations/Daily"
WHERE file.day.year = date(today).year AND file.day.week = date(today).week
GROUP BY Strategy
SORT round(average(rows.Effectiveness), 1) DESC
🚨 3. High-Priority Antecedent & Dysregulation Alerts
Logs from this week where strategy effectiveness was low (≤ 2) or an antecedent trigger was recorded.
TABLE WITHOUT ID
date + " (" + time + ")" AS "Date & Time",
Profile AS "Student",
Subject AS "Context / Subject",
Locale AS "Setting",
Trigger AS "Antecedent Trigger",
Regulation_State AS "Zone",
Strategy AS "Strategy Used",
Effectiveness AS "Score (1-5)"
FROM "Accommodation Journal/03_observations/Daily"
WHERE file.day.year = date(today).year
AND file.day.week = date(today).week
AND (Effectiveness <= 2 OR (Trigger != null AND Trigger != "None"))
SORT date DESC, time DESC
📝 4. Qualitative Team Handoff & SBT Notes
🌟 Key Wins & Successful Accommodations
⚠️ Areas Needing Adjustment / Strategy Re-evaluation
🤝 Action Items for Next Week's EA Shift
- [ ]