Technologies · Year 10

Active learning ideas

Introduction to Data Concepts

Active learning works for this topic because students need to experience the consequences of poor data design firsthand. When they manipulate real data or act as parts of a database, they quickly see why relationships and structure matter.

• ACARA Content Descriptions
• AC9DT10K01

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

Activity 01

• Think-Pair-Share
• 30 min · Whole Class

Physical Simulation: The Human Database

Students hold cards representing 'records' in different tables (e.g., Students and Classes). They must physically 'link' themselves using pieces of string to represent Foreign Keys, demonstrating one-to-many relationships.

Differentiate between data, information, and knowledge with examples.

Facilitation Tip

For the SQL Query Challenge, display sample queries on posters so students can compare their solutions and discuss efficiency in small groups.

What to look for

Provide students with three scenarios: 1) A list of customer names and purchase amounts. 2) A collection of customer reviews written in plain text. 3) A JSON file containing product details with nested categories. Ask students to identify the type of data (structured, unstructured, semi-structured) for each and briefly explain why.

• Understand
• Apply
• Analyze
• Self-Awareness
• Relationship Skills

Activity 02

• Inquiry Circle
• 50 min · Small Groups

Inquiry Circle: Schema Design

In small groups, students design a database schema for a new streaming service. They must decide which tables are needed (Users, Movies, Ratings) and how to normalize the data to avoid repeating the same movie title 100 times.

Analyze the challenges of working with unstructured data.

What to look for

Present students with a scenario: 'A company wants to understand customer satisfaction by analyzing online reviews and social media comments.' Ask them to list two specific challenges they would face when working with this type of data and one reason why ensuring the accuracy of this data is important for the company's decisions.

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

Activity 03

• Gallery Walk
• 40 min · Pairs

Gallery Walk: SQL Query Challenge

Post 'data requests' around the room (e.g., 'Find all students who like Pizza and live in Sydney'). Students move in pairs to write the SQL code on posters to solve each request, then check each other's syntax.

Explain why data quality is crucial for accurate analysis.

What to look for

Facilitate a class discussion using the prompt: 'Imagine you are a data analyst for a city council. You have access to structured data about crime statistics and unstructured data from citizen complaint emails. How would you explain the difference between data, information, and knowledge in the context of using these two data sources to improve public safety?'

• Understand
• Apply
• Analyze
• Create
• Relationship Skills
• Social Awareness

A few notes on teaching this unit

Teachers should avoid starting with abstract theory; instead, begin with a concrete problem that highlights data integrity issues. Research shows students grasp normalization better when they first experience anomalies through hands-on sorting or physical movement. Use analogies carefully—avoid comparing databases to spreadsheets, as this reinforces misconceptions.

Successful learning looks like students accurately linking tables with primary and foreign keys and explaining how normalization reduces redundancy. They should confidently write simple SQL queries to extract information and articulate why spreadsheets fail at scale.

---

Watch Out for These Misconceptions

• During The Human Database, watch for students who treat the simulation like a spreadsheet by linking everything to a single 'super record.'

  Pause the activity and ask teams to explain how changing one student's address in multiple tables would work. Use a whiteboard to tally steps needed and highlight why relationships reduce workload.

• During Schema Design, watch for groups who combine all data into one large table to 'keep it simple.'

  Give each group a card with a real-world scenario involving duplicate data (e.g., customer orders). Ask them to count how many times the same customer details repeat, then demonstrate how normalization isolates unique entries.

---

Methods used in this brief

• Think-Pair-Share
• Inquiry Circle
• Gallery Walk