← VCE Data Analytics U4O1

Applying evaluation criteria to a data solution

Test the solution against a criterion, record the result (met, partly met or not met) and justify the rating with evidence. Recommend improvements if it is not fully met.

Part of: VCE Data Analytics - U4O1 - Development and Evaluation — Module 93, QCE Digital Solutions Unit 2 — Prototype Data Solutions — Module 127

Understanding Applying evaluation criteria to a data solution in VCE Data Analytics U4O1

What it does: The rating is backed by specific evidence, comparing the solution's result with the source data. The recommendation is a specific, actionable fix that would address the gap found when applying the criterion. 3 seconds is under the 5 second limit, so the criterion is fully met. Most charts pass but two fail, so the criterion is only partly met. With no validation rules, there is no evidence of any progress towards the criterion, so it is not met. A strong justification cites specific evidence such as counts, names or test results. When a criterion is not fully met, a good evaluation recommends an improvement to fix it.

Common mistakes: The evidence shows an average of 3.2 s, which is under 5 s, so the criterion is met. The result should be 'Result: Met'. 4 IDs are blank, so the criterion 'No blank IDs' is not fully achieved. Most IDs are filled, so the rating should be 'Result: Partly met'.

Class: _____________________  ·  Name: _____________________  ·  Date: _________

Free printable worksheet with full answer key — or add this module to a class and your students practise it interactively.

🖨 Print worksheet + answer key Add Applying evaluation criteria to a data solution to a class →

This module's key terms are also in a printable crossword (Modules 85–105) and word search (Modules 63–105).

Take this worksheet further — free with Cloodit

Each concept is reinforced from every angle — learned, then applied, then tested.

Learning
Duo
A criterion says 'All totals must be correct'. What is the best way to apply it?
Test the totals against hand-calculated answers and record the resultSay the totals look fine without checking them
Matches
Criterion: Totals are accurate | Result: Met (looks fine)
↓
The rating is not justified with evidence. A vague comment like 'looks fine' does not show the solution was tested.
Applying
Meanings
Term
apply a criterion
Meaning
Test the solution against a criterion, record the result (met, partly met or not met) and justify the rating with evidence. Recommend improvements if it is not fully met.
Practice
Criterion: Dashboard loads in under 5 seconds
Testing
Gaps
=(B2>=95,"Met","Not met")
Check Answer
Spots
2Test: Timed 3 runs
3Result: Not met

Cloodit turns curriculum-aligned coding content into journeys students work through one biome at a time.

The 'Pufferfish' badge — Error Handler, one of Cloodit's 106 collectible badges
Students earn collectable badges

Over 100 of them, across seven natural biomes.

Study Buddy
Students build a real study resource

Turns their work into revision material ready for Flash Cards and Exam study.

Diamond Dash — one of Cloodit's live, competitive Sprint games
Students lock in with Sprints

Live, competitive practice for the start of the lesson or a teacher-led lesson finisher.

A Cloodit certificate of achievement, ready to personalise and print
Custom printable certificates

Honour your top performers, or encourage a student who's trying hard — ready to print in seconds.

Add to class →

Quick Questions

1. A criterion says 'All totals must be correct'. What is the best way to apply it?
A. Say the totals look fine without checking them
B. Test the totals against hand-calculated answers and record the result ✓
Applying a criterion means actually testing the solution against it, then recording what you found.
2. Which rating fits best? The dashboard loads in 3 seconds. The criterion says it must load in under 5 seconds.
A. Met ✓
B. Not met
3 seconds is under the 5 second limit, so the criterion is fully met.
3. Which rating fits best? 8 of 10 charts have axis labels. The criterion says every chart must have axis labels.
A. Met
B. Partly met ✓
Most charts pass but two fail, so the criterion is only partly met.
4. Which rating fits best? The criterion says data must be validated on entry. The spreadsheet has no validation rules at all.
A. Not met ✓
B. Partly met
With no validation rules, there is no evidence of any progress towards the criterion, so it is not met.
5. Which justification is stronger?
A. Partly met: 8 of 10 charts have axis labels, but the Sales and Costs charts do not ✓
B. Partly met: the charts are mostly okay
A strong justification cites specific evidence such as counts, names or test results.

Match the Pairs

Criterion: Chart shows all 8 students | Result: Met → A rating of met, because the test showed the criterion was fully achieved.
Result: Partly met | Evidence: 7 of 8 rows charted → A rating of partly met, justified with evidence from the test.
Justify a rating by citing evidence from testing the solution. → Not met: the total in F10 shows 412, but the source data adds to 436.
If a criterion is not fully met, recommend an improvement. → Recommendation: Change =SUM(B2:B8) to =SUM(B2:B9) to include every row.
Criterion: Totals are accurate | Result: Met (looks fine) → The rating is not justified with evidence. A vague comment like 'looks fine' does not show the solution was tested.
Criterion: Chart is clear | Result: Not met | Evidence: none | Recommendation: none → A Not met rating has no evidence and no recommended improvement.

Key Term

apply a criterion
Test the solution against a criterion, record the result (met, partly met or not met) and justify the rating with evidence. Recommend improvements if it is not fully met.

Fill in the Blanks

1. =IF(B2>=95,"Met","Not met")
Hint: Type the function that records one result if a test is true and another if it is false.
2. =IF(B2>=95,"Met","Not met")
Hint: Type the comparison operator meaning the score is at least the target.
3. =COUNTIF(C2:C9,"Met")
Hint: Type the function that counts how many criteria have a given result.
4. IF errors = 0 THEN result ← "Met" ELSE result ← "Not met"
Hint: Type the keyword that gives the rating when the test fails.
5. IF result = "Not met" THEN OUTPUT "Add a range check"
Hint: Type the keyword that displays a recommended improvement.

Spot the Error

Question 1
A Criterion: Loads in under 5 s
B Test: Timed 3 runs
C Result: Not met
D Evidence: Average was 3.2 s
Line C — The evidence shows an average of 3.2 s, which is under 5 s, so the criterion is met. The result should be 'Result: Met'.
Question 2
A Criterion: No blank IDs
B Test: Filtered ID for blanks
C Result: Met
D Evidence: 4 of 200 IDs blank
Line C — 4 IDs are blank, so the criterion 'No blank IDs' is not fully achieved. Most IDs are filled, so the rating should be 'Result: Partly met'.
Question 3
A Criterion: Shows all 12 months
B Result: Not met
C Evidence: Looks fine to me
D Improve: Extend axis to Dec
Line C — Evidence must be specific and checkable, not an opinion. It should state what was found, such as 'Evidence: Chart stops at Oct'.
Question 4
A Criterion: Totals are correct
B Test: Did not check anything
C Result: Met
D Evidence: All 5 matched
Line B — Applying a criterion means actually testing the solution against it. The test should be something like a hand calculation of 5 rows, otherwise the rating has no basis.
Question 5
A Criterion: Staff find it easy
B Test: Asked the developer
C Result: Partly met
D Evidence: 3 of 5 found it easy
Line B — The criterion is about staff finding it easy, so the test must involve the actual users. The developer is not a fair judge, so it should be 'Test: Survey of 5 staff'.

Student with a class code? Join your class →