Technologies · Year 9

Active learning ideas

Organising Data in Tables

Active learning transforms abstract data concepts into tangible experiences. When students physically arrange information in tables or simulate algorithmic decision-making, they move beyond passive listening to construct their own understanding of how data organisation drives automated systems.

• ACARA Content Descriptions
• AC9DT10P01

• 40–50 min
• Pairs → Whole Class
• 3 activities

Activity 01

• Simulation Game
• 45 min · Whole Class

Simulation Game: Training a Human Algorithm

One student acts as the 'algorithm' and must sort objects (e.g., different types of leaves) based on a 'training set' provided by the class. If the training set is biased (e.g., only small leaves), the algorithm will fail to correctly identify large leaves, demonstrating how data bias works.

Explain why organising data into tables makes it easier to find information.

Facilitation Tip

During the Simulation activity, have students physically stand in rows and columns to model how a table’s structure separates data points while maintaining relationships between them.

What to look for

Provide students with a list of items (e.g., different types of fruits) and ask them to draw a table to organise information about them, including at least three columns like 'Name', 'Colour', and 'Taste'. Ask them to label one row and one column.

• Apply
• Analyze
• Evaluate
• Create
• Social Awareness
• Decision-Making

Activity 02

• Formal Debate
• 40 min · Small Groups

Formal Debate: Surveillance vs. Safety

Students debate the use of facial recognition and big data in public spaces. They must represent different stakeholders, such as a privacy advocate, a police officer, and a retail store owner, using evidence to support their ethical positions.

Differentiate between a row and a column in a data table.

Facilitation Tip

In the Structured Debate, assign roles in advance and provide a one-page brief with key arguments and data examples to keep discussions focused and evidence-based.

What to look for

Present students with two simple, related lists of information, such as a list of students and a list of their favourite subjects. Ask: 'How could we organise this information into tables so we can easily see which student likes which subject? What would be the primary key in each table, and how would they connect?'

• Analyze
• Evaluate
• Create
• Self-Management
• Decision-Making

Activity 03

• Inquiry Circle
• 50 min · Small Groups

Inquiry Circle: AI Ethics Audit

Groups are given a scenario where an AI is used to screen job applications. They must identify potential sources of bias in the data (e.g., historical gender roles) and propose ways to make the algorithm fairer and more transparent.

Design a simple table structure to store information about a collection of items.

Facilitation Tip

For the Collaborative Investigation, assign each group a different dataset (e.g., loan approvals, hiring decisions) so they can compare how table organisation reveals or obscures bias.

What to look for

Ask students to write down one reason why organising data into a table is better than a simple list. Then, have them define 'row' and 'column' in their own words.

• Analyze
• Evaluate
• Create
• Self-Management
• Self-Awareness

A few notes on teaching this unit

Teach data organisation by starting with concrete examples students can touch or move, such as sticky notes or cards. Research shows that students grasp relational databases more easily when they first experience flat-file tables and only later abstract to primary keys and joins. Avoid rushing to technical terms; let students name columns and rows in their own words before formalising the vocabulary.

Students will confidently organise data into tables, identify primary keys, and explain how table structure enables efficient data processing. They will also critique algorithmic bias by connecting data choices to real-world outcomes, demonstrating both technical skill and ethical awareness.

---

Watch Out for These Misconceptions

• During Simulation: Training a Human Algorithm, watch for students attributing human-like understanding to the algorithm.

  Pause the simulation after the first round and ask students to explain the decision-making process in exact steps, using the table they created to show how the algorithm only followed the data’s patterns, not any deeper logic.

• During Structured Debate: Surveillance vs. Safety, watch for students assuming algorithms are neutral tools.

  Provide each debater with a sample dataset (e.g., a table of facial recognition error rates by demographic) and require them to cite specific rows or columns when making claims about algorithmic fairness or bias.

---

Methods used in this brief

• Simulation Game
• Formal Debate
• Inquiry Circle