Training feedback scores and themes
The feedback form has 200 comments. Half say 'good'. The other half need an action plan.
Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files
Export anonymous feedback
Keep response code, rating, comment and topic tag if available. Remove identifying details and use the sample first.
Confirm the rating scale
Check what each score means. Missing scores stay blank, not zero.
Privacy Remove names, contact details, employee codes and identifying comments. Use random response codes only.
I'm attaching anonymous feedback for [Training session]. Rating scale: [Rating scale]. Low rating threshold: [Low rating threshold] or below. A. Count responses, valid ratings, missing or out-of-range ratings and low ratings. Average valid ratings only to two decimal places; show sum and denominator. B. Count topic tags from the sheet, one per response. If no tag, group comments and mark the grouping as your interpretation. Show short anonymous examples, no invented quotes. C. Separate findings from suggested improvements, one per repeated topic. Do not infer individual ability or trainer performance beyond the comments. Use only supplied data. HR reviews before sharing.
Which model? Use your tool's strongest model with thinking turned on.
In your AI tool: attach the files with the + button, paste, send.
Keep the real feedback in Excel if uploads aren't allowed.
Excel A:D = response code, rating, comment, topic. Rating scale [Rating scale], low threshold [Low rating threshold]. Write formulas to count all response codes, valid ratings in the scale, missing/invalid ratings, average valid ratings and low valid ratings. Explain a pivot count by topic. Never count a blank rating as zero.
Use formulas and pivot in your own file; read the comments yourself for context.
- 2Practice mentions. More examples and another practice round.
- 2Pace mentions. Two responses say the session moved too fast.
- F06Rating missing. Excluded from average, comment still counted.
Then send this: Recount all responses, ratings and topics. Show the exact rating sum and denominator, and check that the missing rating is not zero.
It counts blank as zero
Reply: "Exclude missing ratings from the average."
It invents a quote
Reply: "Use only supplied comment text."
It rates the trainer
Reply: "Report feedback themes, not a person-level verdict."
Sir ne bola urgent. Ab bolo: ho gaya.
Did it work?
Doing this every week? Save it once.
Save the prompt in your AI tool, so next time you only drop the files in. Pick your tool at the top to see how.
What is that?
A Project is a folder in ChatGPT that keeps your instructions and files for every chat inside it. It's on the free plan too. Checked 14 Nov 2026.
What is that?
A Project in Claude is a workspace with its own instructions and files that every chat inside it uses. Checked 14 Nov 2026.
What is that?
A Gem is a custom Gemini that loads your instructions before every chat. Free on every plan; you create it on a computer. Checked 14 Nov 2026.
What is that?
Signed in with a work account, Microsoft's Copilot Chat applies enterprise data protection: your prompts aren't used to train its models. Checked 14 Nov 2026.
If your whole team does this, we'll set it up for all of them in one session.