AIP › Tools › Metrics Worksheet
AIP Tools · K–12 AI Governance

AI Adoption Metrics Worksheet

A measurement framework for schools. 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).

10
Modules to Track
10
KPIs Defined
7
Suggested Charts
Print
Ready
The problem: Without data, AI decisions are made by instinct. This worksheet defines the modules, KPIs, and visualizations a school 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
  • Equity analysis by student group — no group under 5 reported
  • 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 class (P1/P2/P3, policy §10)
  • 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)
  • Baseline vs. re-baseline charts
  • Board-ready exports (PDF)
🔁

Six-Month Re-baseline

  • The same instruments, re-run
  • Readiness and Governance, never averaged
  • Change against your own baseline
  • No comparison with other schools
Key Performance Indicators
MetricData SourceExample target — set your ownFrequency
Teacher AI literacy gainQuiz pre/post+30%Per training cycle
Student AI literacy gainQuiz pre/post (Grades 7–12)+25%Annually
PD completion rateCredential system100% Level 1Monthly
Tool usage rateVendor analytics API80%+ licensed users activeWeekly
Incident rateIncident logRecorded, not targeted — a target on incidents discourages reporting themReal-time
Incident deadlines metIncident logPolicy §10: P1 contained in 24h · P2 panel in 48h · P3 closed in 5 daysPer incident
Parent sentiment scoreSurvey3.5/5 averageQuarterly
Parent opt-out rateOpt-out forms<20%Per semester
Cost per active studentBudget + usageWithin 10% of planMonthly
Vendor SLA complianceUptime logs99%+ per toolMonthly
Suggested Output Formats
📄 Board Report (print to PDF)
📊 Excel / Google Sheets
📧 Email Digest (manual)
🌐 Internal Wiki Embed
📋 Grant Application Data
Suggested Visualizations