Computer Skills
Beginner
60 mins
Teacher/Student led
Learning Goals
Learning Outcomes
+80 XP
What you need:
Chromebook/Laptop/PC or iPad/Tablet

Sorting & Filtering Data

Learn to sort data by one or more columns and apply filters to reveal specific information. Discover how to avoid accidentally scrambling your spreadsheet when reordering rows.

Teacher Class Feed

Load previous activity

    1 - Introduction

    Welcome

    On Work Experience or at an apprenticeship site, someone eventually hands you a 200-row stocktake, a payroll register, or a job log and asks a simple question: "Which items cost the most?" or "How much have we spent on Transport this week?" Sorting and filtering are how you get those answers in seconds, but they can also silently scramble a sheet if you use them carelessly. Today you'll learn to do both safely, including the one mistake that breaks everyone's first spreadsheet.

    By the end of this lesson, you will be able to:

    • Sort data ascending or descending by one or more columns
    • Apply a filter to hide rows that don't match your criteria
    • Avoid breaking formulas and data relationships when sorting a formatted sheet

    Warm-up

    Imagine your Centra supervisor hands you a 120-line stocktake and asks for "the five most expensive items." What's the fastest way to find them? Now, what do you think would go wrong if you sorted only the Cost column by itself, without the Item names moving along with it?

    👇 Mark your steps as done as you complete them.

    +5 XP

    2 - Key Concepts

    Five terms you need before you sort or filter anything real.

    ConceptWhy it mattersExample
    Sort — reorders entire rows by the values in one column, ascending (A→Z, small→big) or descending (Z→A, big→small)Puts the answer ("biggest", "newest", "first alphabetically") at the top where you can actually see itSort your project budget by Cost descending; the €180 materials line jumps to row 2 and the €2 stationery line sinks to the bottom
    Filter — temporarily hides rows that don't match a rule, without deleting themLets you answer "show me only X" without wrecking the full sheet; clear the filter and everything comes backOn a Centra stocktake, filter Category = "Drinks" to see just Coke, Water, and juice rows while the rest are tucked out of sight
    Data range — the full block of related rows and columns you select before sorting or filteringIf you select only one column, sorting scrambles the data because the other columns don't move with itFor a 4-column budget with 15 rows of data, the correct range is A1:D16 — headers and all data, nothing else
    Header row — the first row of labels ("Item", "Category", "Cost"...)Sort dialogs need to be told you have one, or they'll mix "Item" into the middle of your item names—
    Summary/total row — a row of SUM, AVERAGE, or other formulas at the bottom of your dataIf you include it in a sort or filter range, it gets shuffled into the data or hidden by the filter, and your totals stop making sense—

    👇 Mark your steps as done as you complete them.

    +10 XP

    3 - Step-by-step Task

    You'll build a small Centra stocktake sheet, watch a careless sort scramble the data, undo it, then sort and filter the right way. By the end you'll know exactly where sorting goes wrong and how to stop it.

    +15 XP

    4 - Common Issues

    Common Issues

    IssueSolution
    My data got scrambled after sorting — rows no longer matchPress {{kbd:Ctrl+Z}} (Windows/Chromebook) or {{kbd:Cmd+Z}} (Mac) to undo immediately. You almost certainly selected only one column. Reselect the full block (all columns, all data rows, header included, totals excluded) and sort again.
    My Total row ended up in the middle of the dataYou included the Total row in the sort range. Undo, then reselect the range so it stops one row above the Total, and sort again.
    My Total row disappeared when I applied a filterThe filter auto-extended to include row 7. Turn off the filter, select {{range:A1:E6}} explicitly (headers plus data, Total row excluded), then turn the filter on again. The Total row stays visible because it sits outside the filtered range.
    My header row ("Item", "Category"...) got sorted into the dataThe sort dialog didn't know you had headers. Undo, open the sort dialog again, and tick "My data has headers" (Excel) or "Data has header row" (Sheets) before clicking Sort.
    The filter dropdown shows "Drinks" and "drinks" as two separate optionsSpreadsheets treat typo variations as different values. Fix the typos in your data first — use Find & Replace if there are many — then the filter will show one clean option.
    I can't find the Sort or Filter option in my menusIn Excel Online, look under {{menu:Home -> Sort & Filter}}. In Google Sheets, look under the {{menu:Data}} menu. If those look different on your screen, check you're signed into the school account and not a personal one with a different interface.
    +10 XP

    5 - Independent Practice

    Independent Practice

    Your goal: Turn your project budget from a long list into a tool that answers real questions, so when someone asks "what's the biggest spend?" or "how much is Transport costing us?" you can show them in ten seconds.
    Time:~20 minutes
    Task: Open {{code:05_project_budget}} from your {{code:Digital_Portfolio}} folder. Using the careful approach from the worked example, select the full data range with the Total row excluded, then sort your budget by Cost descending so the biggest line is on top. Next, select just the headers-plus-data range (Total row still excluded) and apply a filter on the Category column to show only ONE category of your choosing, whichever reveals something you want to look at more closely. Leave the filter applied when you finish so the sorted-and-filtered view stays as part of your project evidence. Your budget file auto-saves in your cloud storage, so no separate save step is needed.
    Success criteria:
    • Your budget is sorted so the largest cost is at the top and the smallest is at the bottom
    • A filter is active on one Category — only the matching rows are visible, the others are hidden (not deleted)
    • The Total row at the bottom stays visible when the filter is applied, because it sits outside the filter range
    • Any SUM or AVERAGE formulas already in your budget still show the correct totals — sorting didn't break them
    +15 XP

    Unlock the Full Learning Experience

    Get ready to embark on an incredible learning journey! Get access to this lesson and hundreds more on our learning platform.

    Get started
    Copyright Notice
    This lesson is copyright of Coding Ireland 2017 - 2025. Unauthorised use, copying or distribution is not allowed.
    🍪 Our website uses cookies to make your browsing experience better. By using our website you agree to our use of cookies. Learn more