Series: How to Run a Workshop People Remember (6/10)
Part 1 of this series made you write an evidence sentence: "I'll know it worked because ___." This is the part where we actually collect that evidence — because the industry-standard substitute for it is embarrassing.
The smile sheet — "How satisfied were you with this workshop, 1–5?" — collects politeness, not learning. It can only go up. Nobody rates a workshop badly on the way out the door when the facilitator is standing right there, and even an honest 4.8 tells you nothing about whether participants can do the thing you promised. If a client asks "did the training work?" and your answer is a satisfaction percentage, you don't have an answer.
The measure that actually moves
The design is old and boring and correct: the same short scored instrument, run before and after the session. Before: it measures where people actually are (and calibrates their confidence). After: it measures the same knowledge and self-ratings again. The difference between the two is your evidence.
If you want the framework language, this is where the Kirkpatrick levels get cited in every L&D conversation — the WorkshopSkill guide on measuring training effectiveness covers the levels without the consultant-speak, and there's a dedicated guide on pre/post measures for the instrument design. The mechanics in the room are simpler than the literature suggests:
- Keep it under ten minutes. A pre-measure that takes twenty minutes will be sabotaged by late arrivals and coffee logistics before it collects a single honest answer.
- Score it, don't just ask it. "Rate your confidence 1–5" is an opinion; ten right-or-wrong items plus two confidence self-ratings is a measure. Scored instruments are the difference between vibes and deltas.
- Same items, same order, both times. If the post-test differs from the pre-test, your "improvement" is noise.
From paper instrument to automatic before/after deltas
Here's where I stopped doing this the hard way. For years my pre/post measure lived in a Google Form (forms.google.com) — free, fine, and completely manual afterwards: export two spreadsheets, VLOOKUP participants by hand (the ones who spelled their email differently in round two), compute deltas, build a chart per person for the client. That's the "spreadsheet pain" in this post's title, and it's the reason most facilitators quietly skip the pre/post entirely.
The tool I built to make this automatic is FormLM — you describe a diagnostic once, and it generates the questions, the scoring logic, and a print-ready PDF report for every respondent:
The template I start from for workshops is the pre/post-training quiz: the same scored quiz runs before and after training, every attempt gets graded automatically, and FormLM computes the before/after deltas into a per-participant report — the knowledge lift in plain numbers:
What that buys you at the end of a session:
- Per-participant before/after deltas, computed — not hand-joined from two exports.
- A PDF report per respondent (scored, branded), which is the artifact you forward to a sponsoring manager who asks "so what did my team actually get?"
- An honest aggregate: "average knowledge lift from 41 to 63 points, biggest gains on the two items about X."
The surrounding templates I keep in rotation for the full workshop measurement loop: the workshop feedback form (the useful kind of post-session survey — structured, not smile sheet), the training evaluation form for program-level evaluation, and the post-training survey for the two-weeks-later check on what stuck. There's a whole training template category if you run recurring programs.
One connection worth knowing if you use both tools from this series: the WorkshopSkill folders each ship with a pre/post measure in the folder, and FormLM is the engine that turns that measure into a live scored form with the deltas computed — the folder is the paper instrument, FormLM is the scoring desk.
Free tools when you just need the math
Two situations where you don't need a platform at all:
- You already have scores in a spreadsheet and just need the charts for a debrief slide: FormLM's free in-browser tools — the radar chart maker, the Likert scale and weighted-score calculators — run without an account and upload nothing.
- The measure is one question ("how confident are you running this activity, 1–10?" on the way in and on the way out): a whiteboard and a show of hands is the honest, zero-tool version. Do this one even when you have the platform — it makes the lift visible to the room in real time, which is worth more than any PDF.
What measurement won't do for you
Honest limits, because overselling measurement is its own industry disease:
- A pre/post lift proves learning happened in the room, not that behavior changed back at the desk. For behavior, you need a follow-up at two to four weeks (the post-training survey above) and a client who actually wants to know.
- Don't measure more than you'll report. Ten items you'll show the sponsor beat forty items you'll never open again.
- If the workshop is genuinely just "exposure" — a one-hour talk with no practice — measuring learning is theater. Part 1's outcome sentence decides whether a pre/post is even appropriate.
Next in the series: the part I get the most pushback on — handing the prep work to an AI agent, on purpose.
Tools in this post:
- FormLM — AI form and assessment platform with scored pre/post measures, automatic before/after deltas and a PDF report per respondent: pre/post-training quiz template, workshop feedback form, training evaluation form, training templates, free in-browser tools
- WorkshopSkill — guides on measuring training effectiveness and pre/post measures; every folder ships a pre/post measure
- Google Forms — free, fine, and fully manual afterwards
*Disclosure: I'm one of the makers of WorkshopSkill, QRCard AI, FormLM and ReportSkills — the tools from my own shop named across this series. *
Top comments (0)