Technologies · Year 8

Active learning ideas

Data Collection and Cleaning

Active learning works here because data collection and cleaning are hands-on skills. Students need to touch messy data to see why cleaning matters, and moving through stations or pair work keeps the abstract concrete. This builds the judgment they’ll need when designing their own research.

• ACARA Content Descriptions
• AC9TDI8P01

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

Activity 01

• Stations Rotation
• 45 min · Small Groups

Stations Rotation: Source Hunt

Prepare stations with survey forms, online articles, sensor apps, and databases. Groups visit each for 7 minutes, collect sample data, note pros and cons, then share plans for a class question like 'What affects lunch choices?'. Rotate twice for depth.

Justify the importance of data cleaning before analysis.

Facilitation Tip

During Source Hunt, set a 3-minute timer at each station so groups must move quickly, forcing them to evaluate sources under time pressure.

What to look for

Provide students with a short list of data sources (e.g., a student survey, a published census report, sensor readings from a weather station). Ask them to write one sentence for each, classifying it as primary or secondary data and briefly explaining why.

• Remember
• Understand
• Apply
• Analyze
• Self-Management
• Relationship Skills

Activity 02

• Project-Based Learning
• 30 min · Pairs

Pairs: Spreadsheet Scrub

Provide messy datasets with errors in Google Sheets. Pairs identify issues using filters and formulas, remove duplicates, fill gaps logically, then graph before-and-after. Discuss changes' effects on trends.

Differentiate between primary and secondary data sources.

Facilitation Tip

Pairs working on Spreadsheet Scrub should swap cleaned sheets to compare corrections before finalizing, ensuring they defend each edit.

What to look for

Present students with a small table of sample data containing obvious errors (e.g., a typo in a name, a nonsensical age, a duplicate entry). Ask them to identify at least two specific errors and suggest how they would correct or handle each one.

• Apply
• Analyze
• Evaluate
• Create
• Self-Management
• Relationship Skills
• Decision-Making

Activity 03

• Project-Based Learning
• 50 min · Whole Class

Whole Class: Data Plan Pitch

Pose a question like 'School waste patterns'. Students brainstorm sources and cleaning steps on shared boards, vote on best plans, then test one by collecting initial data.

Construct a plan for collecting and cleaning data for a specific research question.

Facilitation Tip

In Data Plan Pitch, require students to hold up their planned data source when they explain why it’s suitable, making their reasoning visible.

What to look for

Pose the question: 'Imagine you are collecting data about the most popular sports at your school. What are two potential problems you might encounter when collecting this data, and how would you clean your data to fix these problems?' Facilitate a brief class discussion on their responses.

• Apply
• Analyze
• Evaluate
• Create
• Self-Management
• Relationship Skills
• Decision-Making

Activity 04

• Project-Based Learning
• 20 min · Individual

Individual: Error Detective

Give printed datasets with planted errors. Students circle problems, propose fixes, and justify choices in a log, preparing for group cleaning.

Justify the importance of data cleaning before analysis.

Facilitation Tip

For Error Detective, give students red pens to mark errors directly on the printout so corrections are visible and discussable.

What to look for

Provide students with a short list of data sources (e.g., a student survey, a published census report, sensor readings from a weather station). Ask them to write one sentence for each, classifying it as primary or secondary data and briefly explaining why.

• Apply
• Analyze
• Evaluate
• Create
• Self-Management
• Relationship Skills
• Decision-Making

A few notes on teaching this unit

Teach this topic by letting students experience the frustration of dirty data first. Start with quick, low-stakes messes they can spot immediately, then layer in subtler issues like duplicates or outdated figures. Model your own thinking aloud when cleaning a sample dataset so students see the internal dialogue behind each decision. Avoid over-teaching the rules upfront; let students discover the need for cleaning through their own trials.

Successful students will justify their cleaning choices with evidence, spot errors without prompting, and plan steps that prevent bias. They’ll discuss trade-offs between data sources and explain how clean data leads to reliable results in their own projects.

---

Watch Out for These Misconceptions

• During Source Hunt, watch for students who assume any government website or published chart is flawless.

  Have students record one potential error for each source they examine, then share findings in a whole-class debrief to highlight how even trusted sources need scrutiny.

• During Data Plan Pitch, listen for students who default to primary data without weighing its limitations.

  Require them to present one advantage and one drawback of their chosen source, then challenge the class to suggest alternatives or improvements.

• During Spreadsheet Scrub, observe students who alter values to match their expectations rather than restore accuracy.

  Display before-and-after graphs side by side during the activity’s wrap-up to show how honest cleaning reveals true trends without distortion.

---

Methods used in this brief

• Stations Rotation
• Project-Based Learning