LUCERIA
Sign in
Evidence bank · free · no email required

Interview evidence bank workbook

One row per story with label, theme (dropdown), question, situation, task, action, result and last-practised date; formulas count the words and estimate spoken seconds. A summary sheet counts stories, themes covered out of twenty, answers that run too long or too short, and stories with no result. A CSV version holds the editable story fields without calculated columns.

Evidence bank workbook (.xlsx)Columns only, with one fictional example (.csv)

Direct downloads: no account, email address or payment. Formats: Excel, CSV.

What is inside

  • Evidence bank sheet: 59 rows with a theme dropdown, STAR text columns, Words (formula), Spoken seconds (words ÷ 2.5) and Last practised (date).
  • Themes sheet: the 20 competency themes that feed the dropdown.
  • Summary sheet: stories saved, themes covered, stories over 150 seconds, under 40 seconds, and without a result.

How to use it

  1. Write five or six strong stories first, then fill gaps the summary shows.
  2. Keep the action column the longest and in the first person.
  3. Use the spoken-seconds column to trim: most answers land best between 60 and 120 seconds.
  4. Record the last-practised date and re-read the action and result before each interview.

Why it is built this way

  • Spoken time is estimated at 150 words a minute, the same rule the STAR planner tool uses, so the two agree.
  • The theme list is a dropdown from a sheet rather than a typed label so the coverage count works.

Accessibility

The workbook uses a frozen header row, plain text labels and list dropdowns, with formulas only where a sheet calculates something; nothing depends on colour alone (shading only marks input cells). It is a standard .xlsx file whose structure was checked programmatically; it has not been tested in every spreadsheet application. This page lists every sheet and column.

Browser tools that work with it

Keep going

Published 6 November 2026 · Files are generated from version-controlled source so every copy is identical. Drafted with AI assistance and checked against Luceria’s editorial standards.