📋 Master IEP Strategy Dashboard

---

📊 1. Student Progress & Performance Overview

Calculates the overall average success score, total logs, and recorded states for each active learning profile.

TABLE WITHOUT ID Profile AS "Student Profile", round(average(rows.Effectiveness), 1) AS "Avg Success (1-5)", length(rows.file.link) AS "Total Logs", unique(rows.Prompt_Level) AS "Prompt Levels Used", unique(rows.Regulation_State) AS "Regulation States Observed" FROM "Accommodation Journal/03_observations/Daily" WHERE Effectiveness != null GROUP BY Profile SORT round(average(rows.Effectiveness), 1) DESC

---

🛠️ 2. Strategy Effectiveness Ranking (Vault-Wide)

Ranks educational accommodations by average success across all student profiles.

TABLE WITHOUT ID Strategy AS "Strategy / Accommodation", round(average(rows.Effectiveness), 1) AS "Overall Avg Success (1-5)", unique(rows.Profile) AS "Profiles Observed", length(rows.file.link) AS "Total Times Logged" FROM "Accommodation Journal/03_observations/Daily" WHERE Effectiveness != null GROUP BY Strategy SORT round(average(rows.Effectiveness), 1) DESC

---

🕒 3. Recent Observation Feed (Latest 10 Logs)

A real-time stream of the most recent individual classroom observations.

TABLE WITHOUT ID 
	date AS "Date", 
	time AS "Time", 
	Profile AS "Profile", 
	Subject AS "Subject", 
	Strategy AS "Strategy Used", 
	Effectiveness AS "Score (1-5)", 
	Prompt_Level AS "Prompt Level", 
	Regulation_State AS "Regulation State" 
	FROM "Accommodation Journal/03_observations/Daily" 
	WHERE Effectiveness != null SORT date DESC, time DESC LIMIT 10