← VCE Data Analysis

Judging the quality of a dataset

Judging a dataset by testing accuracy, bias, integrity, relevance and reliability one at a time, and using evidence to show how any problem could affect conclusions.

Part of: VCE Applied Computing - U1O1 - Data analysis — Module 33, VCE Data Analytics - U3O1 - Data Analytics — Module 44, VCE Data Analytics - U3O2 - Analysis and Design — Module 79, ACARA Digital Technologies Years 9–10 — Acquiring and Validating Data — Module 90

Understanding Judging the quality of a dataset in VCE Data Analysis

What it does: Blank cells and duplicate IDs are counted evidence that the data is incomplete or inconsistent, which affects integrity. The sleep data does not help answer a question about canteen sales, so it is not relevant and could mislead the conclusion. A quality check works through each characteristic separately, so every problem is found and can be backed with evidence. A value that is clearly impossible shows the data does not match reality, so it is an accuracy problem. Bias is about whether the data fairly represents everyone. Correctly recorded answers from an unrepresentative sample can still be biased. A strong explanation points to specific evidence (an example from the data) and says how it could affect conclusions.

Common mistakes: Accuracy is about whether values are correct, so the check is that values match the source. Checking that no rows are missing tests integrity (completeness), not accuracy. The line should be: accuracy ← values match source. Checking whether values were typed correctly tests accuracy. A bias check asks who or what was left out or over-represented. The line should be: ask: who was left out?

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 Judging the quality of a dataset to a class →

This module's key terms are also in a printable crossword (Modules 25–37) and word search (Modules 25–54).

Take this worksheet further — free with Cloodit

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

Learning
Duo
A student wants to judge the quality of a dataset. Which approach matches a proper data quality check?
Test accuracy, bias, integrity, relevance and reliability one at a timeGlance at the dataset and decide if it looks good overall
Matches
Quality check: The data looks neat, so it is high quality.
↓
Judging quality by appearance only. Each characteristic must be tested separately using evidence, such as counting errors.
Applying
Meanings
Term
data quality check
Meaning
Judging a dataset by testing accuracy, bias, integrity, relevance and reliability one at a time, and using evidence to show how any problem could affect conclusions.
Practice
Accuracy: compare values to the source
Testing
Gaps
=(B2:B100,">120")
Check Answer
Spots
1dataset ← survey_results
2accuracy ← no rows missing

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

The 'Woolly Mammoth' badge — Tundra Master, 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 student wants to judge the quality of a dataset. Which approach matches a proper data quality check?
A. Test accuracy, bias, integrity, relevance and reliability one at a time ✓
B. Glance at the dataset and decide if it looks good overall
A quality check works through each characteristic separately, so every problem is found and can be backed with evidence.
2. A dataset of student heights lists one Year 10 student as 17 m tall. Which quality characteristic is this evidence against?
A. Accuracy ✓
B. Relevance
A value that is clearly impossible shows the data does not match reality, so it is an accuracy problem.
3. A survey about school canteen food was only given to students who were already in the canteen queue. What is the best quality judgement?
A. No problem, because every response was recorded correctly
B. Possible bias, because the sample leaves out students who do not buy canteen food ✓
Bias is about whether the data fairly represents everyone. Correctly recorded answers from an unrepresentative sample can still be biased.
4. Which statement is the stronger way to explain a quality problem?
A. This dataset is bad and should not be trusted
B. Row 14 has no postcode, so the data is incomplete and suburb totals could be too low ✓
A strong explanation points to specific evidence (an example from the data) and says how it could affect conclusions.
5. A dataset about bus delays in Melbourne is used to answer a question about train delays in Perth. Which characteristic is the main problem?
A. Relevance ✓
B. Integrity
The data does not suit the question being asked, so it fails the relevance check, even if the values themselves are fine.

Match the Pairs

Accuracy check: 3 of 40 ages are 250 → Accuracy problem: some values are impossible or wrong, so averages and totals drawn from them could be misleading
Bias check: 90% of replies are from Year 12 → Bias problem: the sample over-represents one group, so conclusions about the whole school may be unfair
Integrity is checked by looking for missing, duplicated or mismatched records, and giving evidence by counting them → Integrity check: 12 blank cells, 5 duplicate IDs
Relevance is checked by asking whether each field helps answer the question, and noting data that does not → Relevance check: sleep data used to study canteen sales
Quality check: The data looks neat, so it is high quality. → Judging quality by appearance only. Each characteristic must be tested separately using evidence, such as counting errors.
Reliability check: One survey gave this result, so it is reliable. → Reliability needs evidence of consistent results, such as repeated surveys or a trusted source. One result proves nothing.

Key Term

data quality check
Judging a dataset by testing accuracy, bias, integrity, relevance and reliability one at a time, and using evidence to show how any problem could affect conclusions.

Fill in the Blanks

1. =COUNTIF(B2:B100,">120")
Hint: Type the function that counts cells meeting a condition, used here to find impossible ages (an accuracy check).
2. =COUNTBLANK(C2:C100)
Hint: Type the function that counts empty cells, used to spot missing values (an integrity check).
3. =COUNTIF(D2:D100,"Year 12")/COUNTA(D2:D100)
Hint: Type the function that counts all non-empty responses, so you can check if one group dominates the sample (a bias check).
4. =IF(B2=C2,"Match","Check")
Hint: Type the function that tests whether two sources agree and returns a different result if they do not (a reliability check).
5. =MEDIAN(B2:B100)
Hint: Type the function that finds the middle value, which is less distorted by one wrong extreme value than the mean when judging how errors affect conclusions.

Spot the Error

Question 1
A dataset ← survey_results
B accuracy ← no rows missing
C evidence ← compared 20 rows
Line B — Accuracy is about whether values are correct, so the check is that values match the source. Checking that no rows are missing tests integrity (completeness), not accuracy. The line should be: accuracy ← values match source.
Question 2
A check ← bias
B ask: were values typed right?
C evidence ← only Year 12 asked
Line B — Checking whether values were typed correctly tests accuracy. A bias check asks who or what was left out or over-represented. The line should be: ask: who was left out?
Question 3
A check ← relevance
B purpose ← plan canteen menu
C IF data is large: keep
D ELSE: discard it
Line C — Relevance means the data suits the purpose of the task, not how large it is. A large dataset can still be irrelevant. The line should be: IF data fits purpose: keep.
Question 4
A check ← reliability
B repeat ← collect data again
C IF results are similar
D reliable ← FALSE
E ELSE reliable ← FALSE
Line D — If repeating the collection gives similar results, the data is reliable. Setting reliable to FALSE contradicts the IF condition. The line should be: reliable ← TRUE.
Question 5
A check ← integrity
B missing ← count blank cells
C IF missing = 0: flag problem
D ELSE: no integrity problem
Line C — A problem should be flagged when blank cells exist (missing is more than 0), not when there are none. The line should be: IF missing > 0: flag problem.

Student with a class code? Join your class →