Shop / Systems / Assessment scoring

Well Measured Systems · Assessment scoring

VB-MAPP Scoring Template

Score Milestones, Barriers and Transitions in Google Sheets. Every box fills with the color of the assessment period you're scoring, the Dashboard adds it all up, and one menu click builds a 4-page PDF report.

Google SheetsPDF reportStart Here guide inside
Try it: pick a period, then click a box
12345

A simplified preview of Level 1 milestones. In the template you type in a box and it fills with the active period's color.

What it does

Scoring that colors itself

Pick the active period at the top of the tab, type anything in a score box, and it fills with that period's color. Re-assessments show up next to earlier scores, so growth is visible at a glance.

A Dashboard that adds it up

The Milestones totals for every period, plus Barriers and Transitions for the most recent period you scored, all on one tab.

A note on every box

Hover over any score box for a shorthand reminder of what earns the score, with an abbreviation key beside Level 1 and a short key on Barriers and Transitions.

A report in one click

The VB-MAPP menu builds a 4-page PDF right in your browser, ready to attach to a treatment plan or share with a team.

What's inside

Start HereSeven steps with screenshots, from making your copy to downloading the report.
DashboardLearner info, your agency or practice name, assessment periods and every total.
MilestonesAll three levels, scored by period color.
BarriersFour period columns, matching the paper protocol.
TransitionsFour period columns, matching the paper protocol.

The PDF report

Page 1Present Level
Page 2Milestones grid
Page 3Barriers
Page 4Transitions

How it works

  1. 1Make your copyTPT adds the template to your Google Drive.
  2. 2Set up the DashboardEnter the learner and your assessment periods.
  3. 3ScoreChoose the active period and type in the boxes.
  4. 4Download the reportVB-MAPP menu, then Download report. Google asks for permission the first time.

Use it on a computer. Menus don't run in the Google Sheets phone app. Tabs have warning-only protection, so formulas are hard to break by accident.

More assessment scoring