AIP Tools · K–12 AI Governance
AI Adoption Metrics Worksheet
A measurement framework for districts. Use this as a planning worksheet: pick the modules that matter, define your KPIs, and decide which charts to build in your existing reporting tools (Sheets, Excel, Power BI, Looker).
The problem: Without data, districts make AI decisions by instinct. This worksheet defines the modules, KPIs, and visualizations a district should track. Pair it with your existing reporting stack (Google Sheets, Excel, Power BI, Looker) — the framework is tool-agnostic.
10 Modules to Track
🍎
Teacher AI Literacy Tracker
- Aggregate by school, grade, subject
- Pre/post quiz scores
- PD credential level distribution
- Trend over time (monthly)
🎓
Student AI Literacy Tracker
- Pre/post by grade level (7–12)
- Proficiency band distribution
- SPED / ELL / SES equity analysis
- Year-over-year cohort tracking
📱
Tool Usage Analytics
- Logins per tool per week
- Active users vs. licensed seats
- Feature adoption rates
- Underutilized tool alerts
🚨
Incident Tracking System
- Frequency by Level (1/2/3)
- Resolution time tracking
- Tool-incident correlation
- Board reporting auto-export
🏅
PD Completion Tracker
- Credential levels by staff member
- School-level completion %
- Annual renewal compliance
- Roster gaps alert
👨👩👧
Parent Sentiment Dashboard
- Survey scores (1–5 avg)
- Opt-out rates by grade/school
- Sentiment trend over time
- Concern category breakdown
💰
Budget Tracking Module
- Spend vs. plan by category
- Cost per active student (actual)
- ROI calculation (live)
- Grant offset tracking
🏢
Vendor Performance Scorecard
- Uptime % per tool (vs. SLA)
- Support ticket volume
- Privacy compliance status
- Contract renewal alerts
🗺️
Visualization Library
- Heat maps (school vs. metric)
- Trend lines (6-month, 12-month)
- Benchmark comparison charts
- Board-ready exports (PDF)
🌐
Benchmarking Network
- Anonymized peer-district data
- Filter by size, state, Title I
- Percentile ranking per metric
- Opt-in data sharing
Key Performance Indicators
| Metric | Data Source | Target | Frequency |
|---|
| Teacher AI literacy gain | Quiz pre/post | +30% | Per training cycle |
| Student AI literacy gain | Quiz pre/post (Grades 7–12) | +25% | Annually |
| PD completion rate | Credential system | 100% Level 1 | Monthly |
| Tool usage rate | Vendor analytics API | 80%+ licensed users active | Weekly |
| Incident rate | Incident log | <1 per 100 students | Real-time |
| Incident resolution time | Incident log | <24 hours avg | Per incident |
| Parent sentiment score | Survey | 3.5/5 average | Quarterly |
| Parent opt-out rate | Opt-out forms | <20% | Per semester |
| Cost per active student | Budget + usage | Within 10% of plan | Monthly |
| Vendor SLA compliance | Uptime logs | 99%+ per tool | Monthly |
Suggested Output Formats
📄 Board Report (print to PDF)
📊 Excel / Google Sheets
📧 Email Digest (manual)
🌐 Internal Wiki Embed
📋 Grant Application Data
Suggested Visualizations
- Teacher Literacy Heat Map — Color-coded grid showing AI literacy scores by school and subject area. Identifies low-performing pockets for targeted PD.
- Student Progress Trend Line — Pre/post literacy scores over multiple years by grade cohort. Correlates with training investment.
- Incident Timeline — Chronological log of all incidents with Level (1/2/3), tool, resolution time, and outcome. Board-ready.
- Opt-Out Rate by Grade — Bar chart showing parent opt-out rates disaggregated by grade level and school. Flags equity concerns.
- Budget vs. Actuals — Waterfall chart showing planned vs. actual spend by category with grant offset visualization.
- Benchmarking Radar Chart — Compare your district across 8 dimensions vs. anonymized peers of similar size and demographics.
- PD Completion Funnel — Shows progression from Level 1 to Level 3 across staff — identifies credential gap at each stage.