Sorting and Filtering Table Data

In this lesson, you'll learn how to sort and filter table data to make it easier to understand and analyze. We'll be creating a fun project where you'll sort and filter a table of your favorite superheroes!

Warning: Your screen size is quite small for viewing this. Rotate your device into landscape mode if you can.

1 Setting up the Table
2 Adding Superheroes
3 Sorting by Debut Year
4 Sorting by Team
5 Filtering by Team
6 Clearing the Filter
7 Combining Sorting and Filtering
8 Reflecting on Your Work
Quiz

1 - Setting up the Table

Let's start by creating a table with the following columns: Superhero, Real Name, Team, and Debut Year. We will use this table to store information about your favorite superheroes.

👇 Mark your steps as done as you complete them.

+10 XP

2 - Adding Superheroes

Now, add data to your table by listing at least 5 of your favorite superheroes along with their real names, the team they belong to, and the year they debuted. Feel free to search online for this information if you're not sure.

👇 Mark your steps as done as you complete them.

+15 XP

3 - Sorting by Debut Year

Let's sort our table by the Debut Year column in ascending order to see which superhero was introduced first. To do this, click on the Debut Year column header and select 'Sort Ascending'.

+10 XP

4 - Sorting by Team

Now, let's sort our table by the Team column in alphabetical order to group superheroes by the team they belong to. Click on the Team column header and select 'Sort Ascending'.

+10 XP

123learn · Online learning platform

Unlock the full learning experience

You're previewing this lesson. Get full access to this lesson and hundreds more — each one ready to teach, with interactive activities, printable resources and pupil progress tracking built in.

Hundreds of curriculum-aligned lessons

Interactive activities in every lesson

Printable resources & progress tracking

Get started

Copyright Notice
This lesson is copyright of Coding Ireland 2017 - 2026. Unauthorised use, copying or distribution is not allowed.

Sorting and Filtering Table Data

Teacher Class Feed

1 - Setting up the Table

2 - Adding Superheroes

3 - Sorting by Debut Year

4 - Sorting by Team

Unlock the full learning experience

XP