001. sorting hats: grouping data by attributes (ks3)
Discover how to organise information efficiently by grouping data by attributes.
Imagine having a massive box of mixed-up Lego bricks. To build something great, you first need to sort them by colour or size. In the digital world, computers do the exact same thing! In this lesson, we will explore how to group data by its specific attributes, learning the foundational skills needed to become a brilliant data analyst.
The Sorting Hat's Secret: How Computers Group Data
In the digital world, everything is made of data. Data is just a collection of raw, unorganised facts, figures, and symbols. A list of names, a column of numbers, or a folder full of photos - on its own, it's just a messy digital pile. Before we can do anything useful with it, we need to bring order to the chaos. This is the first and most important job of a Data Analyst.
Finding the Attributes
The secret to sorting is to look for attributes. An attribute is a specific characteristic or property of a piece of data. If you have a collection of animals, their attributes could be:
Species (e.g., Lion, Eagle, Crocodile)
Class (e.g., Mammal, Bird, Reptile)
Diet (e.g., Carnivore, Herbivore, Omnivore)
Habitat (e.g., Savanna, Forest, River)
Just like the Sorting Hat looks for bravery or cunning, a computer program looks at these attributes to group similar items together. Sorting data by a specific attribute makes it incredibly easy to find things. If you sort your animal data by 'Diet', you can find all the carnivores in a split second.
From Raw Data to Useful Information
This process of sorting and grouping is how we turn useless raw data into powerful information. A long, unsorted list of every student in a school is raw data. But a list that has been sorted into tutor groups, and then sorted alphabetically by surname, is information. You can use it to take a register quickly and efficiently.
This is a fundamental skill in computer science. Every time you filter products on a shopping website (e.g., 'show me trainers, size 9, in black') or search for a specific email in your inbox, you are using the power of data attributes. A computer has rapidly sorted a massive dataset based on the characteristics you provided. By learning to identify and categorise data, you are learning to think like an analyst and unlock the stories hidden in the numbers.
Plugged Task: The Digital Zoologist
You are a Trainee Data Analyst working for a new digital zoo. You have been given a messy, unsorted list of the first 10 animals acquired by the zoo. Your task is to use a spreadsheet to organise this raw data into a structured and useful set of information that your boss can use to answer questions.
The Persona
As The Analyst, your job is to be logical, methodical, and precise. You bring order to chaos and transform messy data into clean information that reveals hidden patterns.
1
Prepare your tools
First, open your spreadsheet software (Microsoft Excel, Google Sheets, or similar). Create a new, blank workbook.
2
Structure your dataset
The first step for any analyst is to define the attributes you need to collect. In row 1 of your spreadsheet, create the following column headers (fields) in cells A1 to E1:
Animal_NameClassDietNative_ContinentIs_Endangered3
Collect your data
Now, populate your spreadsheet. Here is the messy, raw data list of the zoo's first 10 animals. You will need to do some quick research to fill in all the attributes correctly for each one.
Tiger
Emperor Penguin
Komodo Dragon
Red-Eyed Tree Frog
African Elephant
Clownfish
Bald Eagle
Giant Panda
Green Sea Turtle
Giraffe
You are an expert data analyst. Explain what a data attribute is. Explain it to a 13-year-old in less than 50 words. Give an example using an animal. NO intro, NO outro, NO deviation from the topic, NO follow-up questions
Use a reliable source like National Geographic Kids to find the information.
4
Turn your data into information
You have a table of data, but it's not yet easy to analyse. We need to add sorting and filtering tools.
1
Highlight all of your data, including the headers in row 1.
2
In the menu, find the Data tab.
3
Click the Filter button. Little dropdown arrows should appear next to each of your headers.
5
Interrogate the data
Now you are a true analyst. Use the filter arrows on your headers to answer these questions. Write your answers on a piece of paper or in a separate text document.
1
How many of the animals are Mammals?
2
List all the animals whose diet is 'Carnivore'.
3
Which animal is from the continent of 'Australia'? (Hint: Clownfish live in the ocean around Australia!).
4
How many of the zoo's animals are endangered?
Outcome
You have created a new spreadsheet with five clear, well-named headers.
You have researched and accurately populated the table with data for 10 different animals.
You have successfully applied the 'Filter' tool to your dataset.
You have used the filters to correctly answer the four questions about your digital zoo.
Unplugged Task: The Collection Curator
On a piece of A4 paper, you are going to become the curator of your own personal collection. This could be your video games, your books, your trading cards, or even your collection of shoes. Your task is to design a paper 'database' to organise it.
1
Turn your paper landscape and draw a large table.
2
Your first task is to think like a Data Analyst. What are the most important attributes of the items in your collection? Choose at least five attributes to be the column headers for your table. For example, for a video game collection, you might choose 'Title', 'Genre', 'Console', 'Age_Rating', and 'My_Score_Out_Of_10'.
3
Now, fill in your table with at least ten items (records) from your real-life collection.
4
Once your table is complete, look at your organised information. At the bottom of the page, write down two interesting questions that you could now easily answer using your table. For example: "Which of my games has the highest score?" or "How many of my books were written by the same author?"
Last modified: June 24th, 2026
