Tip: Choose Save as PDF in the print dialog to download. Use A4 paper size.
Shade in the A or B circle for each question.
Draw a line connecting each item on the left to its match on the right.
| Left column | Right column | |
|---|---|---|
| 1Criterion: Report totals match the source data (Yes/No) | AA measurable efficiency criterion with a clear time target | |
| 2Criterion: Dashboard refreshes in under 5 seconds | BIt is vague and has no measurable target, so it cannot be answered with evidence. Fix: Rate the layout from 1 to 5, aiming for an average of 4 or more. | |
| 3A criterion is linked to a requirement so each one is judged against what the client needs | CRequirement: Show sales by region | Criterion: Chart shows all 4 regions (Yes/No) | |
| 4A rating scale criterion lets users give a score that can be collected as evidence | DCriterion: Rate how easy the dashboard is to read from 1 to 5 | |
| 5Criterion: The dashboard looks good | EA yes/no criterion that checks effectiveness by comparing the output with the source data | |
| 6Criterion: Make the spreadsheet better | FIt is not linked to any requirement and has no target. Fix: Formulas calculate the total correctly with no errors (Yes/No). |
Complete each line of code by filling in the missing parts.
Shade in the letter of the line that contains an error.
evaluation criterion — A measurable standard used to judge a solution, linked to a requirement and written so it can be answered with evidence, such as a target, a yes/no check or a rating.=IF(B2<=5,"Yes","No")=COUNTIF(C2:C9,"Yes")=AVERAGE(D2:D9)>=4IF accuracy >= 95 THEN
result ← "Met"
ENDIF=IF(AND(B2>=95,C2<=5),"Met","Not met")