🎛️ Master Control Panel: Accommodation Journal
🎛️ Master Control Panel: Accommodation Journal
🔒 FOIPPA Privacy & De-Identification Protocol
- De-Identified Profile Codes Only: Use randomized student IDs (e.g.,
M41P,X92J). Never record legal names or direct PII in vault notes. - Air-Gapped Key: Keep student identity mapping sheets stored strictly offline (locked physical file drawer) or on encrypted district servers.
- Device Encryption: Ensure local disk encryption (BitLocker / FileVault) is active.
🚀 Quick-Action Command Bar
Daily Operations & Logging
BUTTON[logObs, addProfile, addStrat, weekly]
label: "Log Observation"
id: logObs
hidden: true
icon: "clipboard-list"
style: default
action:
type: command
command: quickadd:choice:1395e1fb-ace1-4123-9d72-0002b196acef
label: "👤 Add Student Profile"
id: addProfile
hidden: true
icon: "user-plus"
style: default
action:
type: command
command: quickadd:choice:9aaad206-a8f7-4a4e-9e06-cfb9e971f1d8
label: "💡 Add Strategy"
id: addStrat
hidden: true
icon: "lightbulb"
style: default
action:
type: command
command: quickadd:choice:e07e96cd-35d7-4f4b-ba2b-ca4e55d23ef3
label: "📊 Weekly Review"
id: weekly
hidden: true
icon: "line-chart"
style: default
action:
type: command
command: "quickadd:run-macro: Run Weekly Review"
👥 1. Active Student Roster Overview
TABLE WITHOUT ID
file.link AS "Profile ID",
bc_designation AS "BC Category",
primary_needs AS "Support Focus Areas",
status AS "Status"
FROM "Accommodation Journal/01_students"
WHERE status != "past" AND status != "archived"
SORT file.name ASC
🚨 2. High-Priority Antecedent & Dysregulation Alerts (FBA Focus)
Incidents with Low Effectiveness (≤2) or Active Triggers
Monitors recent sensory overload, transition stress, or severe dysregulation events across all settings.
TABLE WITHOUT ID
date + " (" + time + ")" AS "Date & Time",
Profile AS "Learner",
Subject AS "Setting / Context",
Locale AS "Location",
Trigger AS "Antecedent Trigger",
Regulation_State AS "Zone",
Strategy AS "Strategy Used",
Effectiveness AS "Outcome Score (1-5)"
FROM "Accommodation Journal/03_observations/Daily"
WHERE (Effectiveness <= 2 OR (Trigger != null AND Trigger != "None"))
SORT date DESC, time DESC
LIMIT 10
🎯 3. Active IEP Goal Progress & Metric Probes
TABLE WITHOUT ID
date AS "Date",
Profile AS "Learner",
Subject AS "Subject",
choice(IEP_Goal != null, IEP_Goal, Academic_Goal) AS "IEP Goal Target",
choice(Metric_Name != null, Metric_Name + ": " + Academic_Metric, Academic_Metric) AS "Probe Result",
Goal_Progress AS "Progress Status"
FROM "Accommodation Journal/03_observations/Daily"
WHERE (IEP_Goal != null AND IEP_Goal != "None") OR (Academic_Goal != null AND Academic_Goal != "None")
SORT date DESC
LIMIT 10
🛠️ 4. Strategy & Accommodation Success Ranking
Efficacy Leaderboard (Calculated Across All Daily Probes)
TABLE WITHOUT ID
Strategy AS "Accommodation Strategy",
round(average(rows.Effectiveness), 1) AS "Avg Success Rate (1-5)",
unique(rows.Profile) AS "Students Utilizing",
length(rows.file.link) AS "Total Probes Logged"
FROM "Accommodation Journal/03_observations/Daily"
WHERE Strategy != "None" AND Strategy != null AND Effectiveness != null
GROUP BY Strategy
SORT round(average(rows.Effectiveness), 1) DESC
📜 5. Live Classroom Observation Stream (Recent Activity)
TABLE WITHOUT ID
date + " (" + time + ")" AS "Time",
Profile AS "Learner",
Observation_Type AS "Type",
Subject AS "Subject",
Strategy AS "Strategy Used",
Prompt_Level AS "Prompt Level",
Effectiveness AS "Score (1-5)"
FROM "Accommodation Journal/03_observations/Daily"
SORT date DESC, time DESC
LIMIT 10