"I think it went well"
A student ends the project with: "I think it went well." The owner asks: how well? Which parts? How do you know?
The answer is a table. Each success criterion, what was measured, and what came out.
Key words
| Word | What it means |
|---|---|
| Success criteria | the list of things the finished work must do |
| Measure | a number or a fact that shows how well a criterion was met |
| Evidence | something that shows a result is true |
| User need | something a person who uses the solution must be able to do |
| Feedback | what a user says about the solution after using it |
| Query | a question you ask of data, written in SQL |
| SQL | a language for asking questions of data kept in tables |
The cells students fill in are left blank in this preview.
By the end of this lesson
Note
I can measure a solution against its success criteria and show with evidence that it meets what users need.
Starter
Have a go
Starter
3 questionsYour answers are marked here and are not kept. A college account keeps every student’s marks.
This is practice
Important
The real task comes from the exam board. This lesson uses an invented organisation and its own made-up data. Your teacher tells you how the real tasks are set and what you may bring.
A criterion you can measure
A criterion is easy to judge if it has a number or a yes and no. "The report is fast" is vague. "The report loads in under 5 seconds" can be measured.
For each criterion write how you measured it, what you found, and where the evidence is.
Worked example: criteria, measures and results
| Criterion | How measured | Result | Evidence | Met? |
|---|---|---|---|---|
| No repeated rows | The repeat test on the final table | 0 groups | Test log, T2 rerun | Met |
| Amounts from 1 to 1000 | The range test | 0 rows outside | Test log, T5 rerun | Met |
| Report loads in under 5 seconds | Timed three runs | 3, 4 and 6 seconds | Timing notes | Partly |
| Private details hidden from delivery list | Checked the delivery view | Surname still shown | Screenshot note | Not met |
The cells students fill in are left blank in this preview.
Run it: count the criteria met
SELECT result, COUNT(*) AS how_many
FROM criterion
GROUP BY result
ORDER BY result;Worked example: a percentage met
| Step | Working | Answer |
|---|---|---|
| Criteria met | From the counts above | 4 |
| All criteria | 4 met, 1 partly, 1 not met | 6 |
| Percentage met | 4 out of 6, so 4 times 100 divided by 6, kept as a whole number | 66 out of every 100 |
The cells students fill in are left blank in this preview.