Technologies · Year 9 · Data Analytics and Visualization · Term 2

Organising Data in Tables

Students will learn to organise data into tables with rows and columns, understanding primary keys and simple relationships between tables.

• ACARA Content Descriptions
• AC9DT10P01

About This Topic

Big Data and Machine Learning (ML) are transforming how society functions, from personalized shopping to medical diagnoses. In this topic, Year 9 students explore the fundamentals of how algorithms learn from large datasets to make predictions. This aligns with AC9DT10K01 and AC9DT10P01, focusing on the social and ethical implications of automated decision-making. Students investigate how bias in training data can lead to unfair outcomes, a critical consideration in our multicultural Australian society.

This topic moves beyond the 'magic' of AI to look at the mechanics: data collection, pattern recognition, and iterative improvement. By understanding these processes, students become informed citizens who can navigate a world increasingly governed by algorithms. The ethical dimension is particularly suited to active learning, as students must weigh competing values and perspectives. This topic comes alive when students can physically model the patterns of algorithmic decision-making.

Key Questions

1. Explain why organising data into tables makes it easier to find information.
2. Differentiate between a row and a column in a data table.
3. Design a simple table structure to store information about a collection of items.

Learning Objectives

• Design a simple data table structure to store information about a collection of items, including appropriate column headers.
• Differentiate between rows and columns in a data table and explain their function in organising information.
• Explain why organising data into tables makes it easier to find, sort, and analyse information.
• Identify the primary key in a simple two-table relationship and explain its role in linking data.

Before You Start

Introduction to Digital Systems

Why: Students need a basic understanding of how digital information is stored and processed to grasp the concept of organising data.

Data Representation

Why: Familiarity with different ways to represent information, such as lists or simple categories, provides a foundation for understanding structured tables.

Key Vocabulary

Data Table	A grid-like structure used to organise information into rows and columns, making it easier to read and manage.
Row	A horizontal set of cells in a data table, representing a single record or item.
Column	A vertical set of cells in a data table, representing a specific attribute or category of data for all items.
Primary Key	A unique identifier for each record in a data table, ensuring that each row can be distinctly identified and linked to other tables.
Relationship (in databases)	A connection between two data tables that allows information from both to be combined, often based on a shared primary key.

Watch Out for These Misconceptions

Common Misconception

AI is 'smarter' than humans.

What to Teach Instead

AI is only as good as the data it is given. Through hands-on simulations, students see that AI doesn't 'understand' things; it simply finds patterns in data, which can often be wrong or biased.

Common Misconception

Algorithms are neutral and objective.

What to Teach Instead

Algorithms reflect the biases of their creators and the data used to train them. Discussing real-world examples of algorithmic bias helps students realize that 'math' can still be unfair if the inputs are flawed.

Active Learning Ideas

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.

45 min·Whole Class

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.

40 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.

50 min·Small Groups

Real-World Connections

• Librarians use tables to catalogue books, with columns for title, author, ISBN, and genre, and rows for each individual book. This organisation allows them to quickly search for specific books or authors.
• Online retailers like Kmart or Myer organise product information in databases structured as tables. Each product has a unique ID (primary key), with columns for name, price, description, and stock levels, enabling efficient searching and inventory management for customers and staff.

Assessment Ideas

Quick Check

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.

Discussion Prompt

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?'

Exit Ticket

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.

Frequently Asked Questions

Do Year 9 students need to know how to code AI?

No, the focus is on understanding the concepts and impacts. While some students might use 'no-code' ML tools, the curriculum goal is for them to understand how data drives these systems and the ethical considerations involved.

What is 'Big Data' in a way students can understand?

Big Data refers to datasets so large and complex that traditional software can't handle them. Think of every single 'like' on social media or every sensor on a fleet of trucks, it's the sheer volume and variety that makes it 'big'.

How does machine learning differ from traditional programming?

In traditional programming, a human writes specific rules for the computer to follow. In machine learning, the human provides data and a goal, and the computer identifies the patterns and rules itself.

How can active learning help students understand machine learning?

Active learning helps demystify AI. By physically participating in 'sorting' or 'predicting' activities, students see that machine learning is just a series of logical steps based on probability, which removes the 'black box' mystery of the technology.