Computing · Secondary 3

Active learning ideas

Identifying and Correcting Data Errors

This topic benefits from active learning because students retain data cleaning skills best when they directly confront real errors in realistic datasets. By manipulating imperfect data in pairs and groups, they build muscle memory for noticing inconsistencies that static examples cannot teach.

• MOE Syllabus Outcomes
• MOE: Data Analysis - S3

• 20–45 min
• Pairs → Whole Class
• 4 activities

Activity 01

• Outdoor Investigation Session
• 30 min · Pairs

Pair Hunt: Error Detection Relay

Pairs receive a shared spreadsheet with planted errors in a student survey dataset. One partner identifies typos and inconsistencies using filters, while the other notes them; they switch after 10 minutes and apply corrections with REPLACE. Pairs compare final cleaned versions.

Explain why accurate data is important for reliable analysis.

Facilitation Tip

During Pair Hunt, circulate and listen for students explaining their error detection process aloud to reinforce verbal reasoning about data quality.

What to look for

Provide students with a small, pre-prepared spreadsheet containing 5-7 common data errors. Ask them to identify and list the errors they find, specifying the type of error for each. For example: 'Row 3, Column B: Typo - 'Appple' instead of 'Apple'.' This checks their identification skills.

• Remember
• Understand
• Analyze
• Social Awareness
• Self-Awareness
• Decision-Making

Activity 02

• Outdoor Investigation Session
• 45 min · Small Groups

Small Group Challenge: Sales Data Cleanup

Small groups get a sales dataset with duplicates, missing prices, and format issues. They sort and filter to find errors, use TRIM and functions to correct, then calculate totals before and after. Groups share one key insight with the class.

Identify common types of errors found in real-world datasets.

Facilitation Tip

In the Small Group Challenge, assign roles so each student practices a different function, ensuring no one gets stuck on one task.

What to look for

Give students a scenario: 'Imagine you are a data entry clerk for a library. You accidentally entered a book title as 'The Great Gatsy'. What spreadsheet function could you use to fix this, and what would be the corrected entry?' This assesses their ability to apply a specific correction method.

• Remember
• Understand
• Analyze
• Social Awareness
• Self-Awareness
• Decision-Making

Activity 03

• Outdoor Investigation Session
• 25 min · Individual

Individual Drill: Personal Dataset Fix

Each student downloads a flawed inventory dataset. They independently spot and correct errors using conditional formatting and functions, then export a cleaned summary. Follow with peer swap for verification.

Apply simple spreadsheet functions to correct identified data errors.

Facilitation Tip

For the Individual Drill, provide a partially cleaned dataset to reduce overwhelm and focus on targeted fixes.

What to look for

Pose this question: 'Why is it more efficient to correct data errors early in the process, rather than after you have already performed several analyses on the data?' Facilitate a brief class discussion to gauge their understanding of the impact of data quality on subsequent steps.

• Remember
• Understand
• Analyze
• Social Awareness
• Self-Awareness
• Decision-Making

Activity 04

• Outdoor Investigation Session
• 20 min · Whole Class

Whole Class: Real-World Error Debate

Display a public dataset projection with errors. Class votes on error types, suggests fixes via spreadsheet demo, and discusses analysis impacts. Students contribute via shared doc.

Explain why accurate data is important for reliable analysis.

Facilitation Tip

In the Real-World Error Debate, give each group one dataset to analyze so their arguments are grounded in concrete evidence.

What to look for

Provide students with a small, pre-prepared spreadsheet containing 5-7 common data errors. Ask them to identify and list the errors they find, specifying the type of error for each. For example: 'Row 3, Column B: Typo - 'Appple' instead of 'Apple'.' This checks their identification skills.

• Remember
• Understand
• Analyze
• Social Awareness
• Self-Awareness
• Decision-Making

A few notes on teaching this unit

Experienced teachers approach this topic by balancing direct instruction with guided practice. They model error detection by thinking aloud while cleaning a sample dataset, then gradually release responsibility to students. Teachers avoid overwhelming learners by scaffolding from obvious typos to subtle inconsistencies, and they emphasize documentation to build metacognitive awareness of data cleaning steps.

Students will demonstrate the ability to identify multiple error types in a dataset and apply corrective functions efficiently. Success looks like cleaned data with documented fixes and clear explanations of the tools used.

---

Watch Out for These Misconceptions

• During Pair Hunt, watch for students assuming all errors are obvious typos and skipping over format inconsistencies like mixed date formats.

  Pause the relay to have pairs categorize errors on a whiteboard before searching, forcing them to notice subtle inconsistencies in the provided dataset.

• During the Small Group Challenge, observe students ignoring missing values because they seem less critical than typos or duplicates.

  Highlight empty cells by using conditional formatting to change their background color, making the gaps impossible to overlook during cleanup.

• During the Individual Drill, notice students preferring manual edits over functions like TRIM or FIND, assuming these take too long.

  Time their fixes and compare results; demonstrate how a single FIND and REPLACE corrects hundreds of entries in seconds versus minutes of manual work.

---

Methods used in this brief

• Outdoor Investigation Session