📊
Learning objective
Filtering Data
Spreadsheet Filters
1
2
3
4
5
6
Welcome to Spreadsheet Filters! In this strand, you will learn how to turn raw spreadsheet data into clear answers by sorting, filtering by single and multiple criteria, and using advanced search conditions.
Simple Sorting
Sorting table rows A-Z and numerical order.
Let's Go!
Learn
Sorting rearranges rows into alphabetical or numerical order. When you sort a column from A to Z or smallest to largest, the computer keeps all the details in that row together so your information stays accurate!
| A | B | C | |
|---|---|---|---|
| 1 | Item | Amount | |
| 2 | Apples | 5 | |
| 3 | Bananas | 3 | |
| 4 | Carrots | 2 | |
| 5 | Total | =SUM(B2:B4) |
Try it yourself
Sort your first data table!
🚀 Open a practice space
Or try locally: 💻 LibreOffice Calc (free)
🌟 Student Project GuideSuccess Criteria & WAGOLL (What A Good One Looks Like)
🎯 Task Success Criteria (Rubric)
Foundation
Identify a table header row in a spreadsheet.
Developing
Sort a single column from A to Z using toolbar buttons.
Secure (Goal)
Sort data rows without scrambling adjacent columns.
Mastery
Explain why header rows must be frozen when sorting. Typing: 5 WPM.
👀 What A Good One Looks Like (WAGOLL)
Exemplar Standard
A top-tier student project for Simple Sorting includes:
- Core Deliverable: Sort your first data table!
- Target Quality: Sort data rows without scrambling adjacent columns.
- Excellence & Polish: Explain why header rows must be frozen when sorting. Typing: 5 WPM.
📁
Save to Your Website Portfolio:
When you finish creating your project in your software, copy the share link or take a screenshot and publish it onto your student portfolio website!
⭐Self-Assessment: How confident do you feel with this skill?
Reflect
Learning check
Teacher setup, curriculum links and progress descriptors
Spark support
Routine: See, Think, Wonder
Achievement pathway
- Foundation: Identify a table header row in a spreadsheet.
- Developing: Sort a single column from A to Z using toolbar buttons.
- Secure: Sort data rows without scrambling adjacent columns.
- Mastering: Explain why header rows must be frozen when sorting. Typing: 5 WPM.
Curriculum links
Curriculum strand: MAT.01.C.1.4
Outcome: SPF-O-01 — Sorting table rows A-Z and numerical order.
PYP: Form · Organising data helps us see patterns and find information quickly.
Learner profile: Inquirer
Competency tags
Gate support
Accessibility alternative:
Teacher override: allow
Locked level
Level 2: AutoFilter On/Off
Complete the previous learning check to unlock this next level.
AutoFilter On/Off
Enabling AutoFilter buttons on table headers.
Learning objective
Learning About: AutoFilter. Learning To: Toggle filters. Learning To Be: Communicator.
Let's Go!
Learn
AutoFilter adds small drop-down arrows to every column header. Clicking the Filter icon acts like a toggle switch—turning it on lets you isolate data, and turning it off shows everything again!
| A | B | C | |
|---|---|---|---|
| 1 | Item | Amount | |
| 2 | Apples | 5 | |
| 3 | Bananas | 3 | |
| 4 | Carrots | 2 | |
| 5 | Total | =SUM(B2:B4) |
📊
Data Visualization Chart
Try it yourself
Turn AutoFilter on and off!
🚀 Open a practice space
Or try locally: 💻 LibreOffice Calc (free)
🌟 Student Project GuideSuccess Criteria & WAGOLL (What A Good One Looks Like)
🎯 Task Success Criteria (Rubric)
Foundation
Locate the Filter button on the spreadsheet toolbar.
Developing
Turn AutoFilter on to reveal drop-down arrows on headers.
Secure (Goal)
Turn AutoFilter off to restore the full unfiltered dataset.
Mastery
Explain that filtering hides rows without deleting them. Typing: 10 WPM.
👀 What A Good One Looks Like (WAGOLL)
Exemplar Standard
A top-tier student project for AutoFilter On/Off includes:
- Core Deliverable: Turn AutoFilter on and off!
- Target Quality: Turn AutoFilter off to restore the full unfiltered dataset.
- Excellence & Polish: Explain that filtering hides rows without deleting them. Typing: 10 WPM.
📁
Save to Your Website Portfolio:
When you finish creating your project in your software, copy the share link or take a screenshot and publish it onto your student portfolio website!
⭐Self-Assessment: How confident do you feel with this skill?
Reflect
Learning check
Teacher setup, curriculum links and progress descriptors
Spark support
Routine: Zoom In
Achievement pathway
- Foundation: Locate the Filter button on the spreadsheet toolbar.
- Developing: Turn AutoFilter on to reveal drop-down arrows on headers.
- Secure: Turn AutoFilter off to restore the full unfiltered dataset.
- Mastering: Explain that filtering hides rows without deleting them. Typing: 10 WPM.
Curriculum links
Curriculum strand: MAT.02.C.1.4
Outcome: SPF-O-02 — Enabling AutoFilter buttons on table headers.
PYP: Function · Filters help us focus on specific information without deleting other data.
Learner profile: Communicator
Competency tags
Gate support
Accessibility alternative:
Teacher override: allow
Locked level
Level 3: Single Category
Complete the previous learning check to unlock this next level.
Single Category
Filtering a column by selecting a single category.
Learning objective
Learning About: Category Filters. Learning To: Filter by value. Learning To Be: Thinker.
Let's Go!
Learn
Filtering by category lets you select exactly what you want to see. By clicking the drop-down arrow, unchecking 'Select All', and checking just one box (like 'Mammal'), all other rows disappear from view!
| A | B | C | |
|---|---|---|---|
| 1 | Item | Amount | |
| 2 | Apples | 5 | |
| 3 | Bananas | 3 | |
| 4 | Carrots | 2 | |
| 5 | Total | =SUM(B2:B4) |
📊
Data Visualization Chart
Try it yourself
Filter by a single category!
🚀 Open a practice space
Or try locally: 💻 LibreOffice Calc (free)
🌟 Student Project GuideSuccess Criteria & WAGOLL (What A Good One Looks Like)
🎯 Task Success Criteria (Rubric)
Foundation
Open a column filter drop-down menu.
Developing
Uncheck 'Select All' and select a single item checkbox.
Secure (Goal)
Filter a dataset to show only rows matching one category (e.g., 'Grade 3').
Mastery
Count filtered items using the status bar count. Typing: 15 WPM.
👀 What A Good One Looks Like (WAGOLL)
Exemplar Standard
A top-tier student project for Single Category includes:
- Core Deliverable: Filter by a single category!
- Target Quality: Filter a dataset to show only rows matching one category (e.g., 'Grade 3').
- Excellence & Polish: Count filtered items using the status bar count. Typing: 15 WPM.
📁
Save to Your Website Portfolio:
When you finish creating your project in your software, copy the share link or take a screenshot and publish it onto your student portfolio website!
⭐Self-Assessment: How confident do you feel with this skill?
Reflect
Learning check
Teacher setup, curriculum links and progress descriptors
Spark support
Routine: Think, Puzzle, Explore
Achievement pathway
- Foundation: Open a column filter drop-down menu.
- Developing: Uncheck 'Select All' and select a single item checkbox.
- Secure: Filter a dataset to show only rows matching one category (e.g., 'Grade 3').
- Mastering: Count filtered items using the status bar count. Typing: 15 WPM.
Curriculum links
Curriculum strand: CM.02.B.1.1
Outcome: SPF-O-03 — Filtering a column by selecting a single category.
PYP: Connection · Isolating variables reveals specific patterns within large datasets.
Learner profile: Thinker
Competency tags
Gate support
Accessibility alternative:
Teacher override: allow
Locked level
Level 4: Multi-Column Filters
Complete the previous learning check to unlock this next level.
Multi-Column Filters
Applying simultaneous filters across multiple columns.
Learning objective
Learning About: Multi-Column Filtering. Learning To: Apply AND logic. Learning To Be: Principled.
Let's Go!
Learn
Combining filters narrows your data using AND logic! When you filter Category='Fruit' AND Status='In Stock', the computer shows ONLY rows that satisfy both conditions at the exact same time.
| A | B | C | |
|---|---|---|---|
| 1 | Item | Amount | |
| 2 | Apples | 5 | |
| 3 | Bananas | 3 | |
| 4 | Carrots | 2 | |
| 5 | Total | =SUM(B2:B4) |
📊
Data Visualization Chart
Try it yourself
Filter across two columns!
🚀 Open a practice space
Or try locally: 💻 LibreOffice Calc (free)
🌟 Student Project GuideSuccess Criteria & WAGOLL (What A Good One Looks Like)
🎯 Task Success Criteria (Rubric)
Foundation
Understand that filtering column A affects what is visible in column B.
Developing
Apply a filter on Column A, then apply a second filter on Column B.
Secure (Goal)
Answer targeted queries requiring two criteria (e.g., 'Fruit' AND 'In Stock').
Mastery
Identify which columns have active filters by inspecting header funnel icons. Typing: 20 WPM.
👀 What A Good One Looks Like (WAGOLL)
Exemplar Standard
A top-tier student project for Multi-Column Filters includes:
- Core Deliverable: Filter across two columns!
- Target Quality: Answer targeted queries requiring two criteria (e.g., 'Fruit' AND 'In Stock').
- Excellence & Polish: Identify which columns have active filters by inspecting header funnel icons. Typing: 20 WPM.
📁
Save to Your Website Portfolio:
When you finish creating your project in your software, copy the share link or take a screenshot and publish it onto your student portfolio website!
⭐Self-Assessment: How confident do you feel with this skill?
Reflect
Learning check
Teacher setup, curriculum links and progress descriptors
Spark support
Routine: See, Think, Wonder
Achievement pathway
- Foundation: Understand that filtering column A affects what is visible in column B.
- Developing: Apply a filter on Column A, then apply a second filter on Column B.
- Secure: Answer targeted queries requiring two criteria (e.g., 'Fruit' AND 'In Stock').
- Mastering: Identify which columns have active filters by inspecting header funnel icons. Typing: 20 WPM.
Curriculum links
Curriculum strand: CM.02.B.1.1
Outcome: SPF-O-04 — Applying simultaneous filters across multiple columns.
PYP: Responsibility · Combining multiple criteria allows precise and targeted data analysis.
Learner profile: Principled
Competency tags
Gate support
Accessibility alternative:
Teacher override: allow
Locked level
Level 5: Number & Text Rules
Complete the previous learning check to unlock this next level.
Number & Text Rules
Filtering using numerical rules and text conditions.
Learning objective
Learning About: Condition Filters. Learning To: Filter by rule. Learning To Be: Knowledgeable.
Let's Go!
Learn
Number and Text Filters let you set rules instead of clicking checkboxes! You can ask the spreadsheet to show rows where 'Score > 80' or 'Name Contains 'Smith'', saving huge amounts of time.
| A | B | C | |
|---|---|---|---|
| 1 | Item | Amount | |
| 2 | Apples | 5 | |
| 3 | Bananas | 3 | |
| 4 | Carrots | 2 | |
| 5 | Total | =SUM(B2:B4) |
📊
Data Visualization Chart
Try it yourself
Apply a number rule filter!
🚀 Open a practice space
Or try locally: 💻 LibreOffice Calc (free)
🌟 Student Project GuideSuccess Criteria & WAGOLL (What A Good One Looks Like)
🎯 Task Success Criteria (Rubric)
Foundation
Access 'Number Filters' and 'Text Filters' sub-menus.
Developing
Apply number conditions such as 'Greater Than', 'Less Than', or 'Between'.
Secure (Goal)
Use text conditions like 'Contains' or 'Begins With' to filter unstructured text.
Mastery
Combine numerical thresholds with text rules to solve complex scenarios. Typing: 25 WPM.
👀 What A Good One Looks Like (WAGOLL)
Exemplar Standard
A top-tier student project for Number & Text Rules includes:
- Core Deliverable: Apply a number rule filter!
- Target Quality: Use text conditions like 'Contains' or 'Begins With' to filter unstructured text.
- Excellence & Polish: Combine numerical thresholds with text rules to solve complex scenarios. Typing: 25 WPM.
📁
Save to Your Website Portfolio:
When you finish creating your project in your software, copy the share link or take a screenshot and publish it onto your student portfolio website!
⭐Self-Assessment: How confident do you feel with this skill?
Reflect
Learning check
Teacher setup, curriculum links and progress descriptors
Spark support
Routine: I used to think...
Achievement pathway
- Foundation: Access 'Number Filters' and 'Text Filters' sub-menus.
- Developing: Apply number conditions such as 'Greater Than', 'Less Than', or 'Between'.
- Secure: Use text conditions like 'Contains' or 'Begins With' to filter unstructured text.
- Mastering: Combine numerical thresholds with text rules to solve complex scenarios. Typing: 25 WPM.
Curriculum links
Curriculum strand: CM.03.B.1.3
Outcome: SPF-O-05 — Filtering using numerical rules and text conditions.
PYP: Perspective · Numerical thresholds and text conditions help us extract strategic evidence.
Learner profile: Knowledgeable
Competency tags
Gate support
Accessibility alternative:
Teacher override: allow
Locked level
Level 6: Slicers & Clearing
Complete the previous learning check to unlock this next level.
Slicers & Clearing
Using visual Slicers and managing clear filter safety.
Learning objective
Learning About: Slicers & Resets. Learning To: Build interactive dashboards. Learning To Be: Reflective.
Let's Go!
Learn
Slicers are user-friendly visual buttons that filter tables with a single tap! Always remember to click 'Clear Filter' when you finish your analysis so hidden rows don't distort your calculations.
| A | B | C | |
|---|---|---|---|
| 1 | Item | Amount | |
| 2 | Apples | 5 | |
| 3 | Bananas | 3 | |
| 4 | Carrots | 2 | |
| 5 | Total | =SUM(B2:B4) |
📊
Data Visualization Chart
Try it yourself
Add a Slicer and clear filters!
🚀 Open a practice space
Or try locally: 💻 LibreOffice Calc (free)
🌟 Student Project GuideSuccess Criteria & WAGOLL (What A Good One Looks Like)
🎯 Task Success Criteria (Rubric)
Foundation
Locate the 'Clear Filter' command to reset a column.
Developing
Insert interactive visual Slicers for one-touch category filtering.
Secure (Goal)
Design an interactive mini-dashboard with multiple linked Slicers.
Mastery
Audit filtered spreadsheets to prevent hidden-data errors in formulas. Typing: 30+ WPM.
👀 What A Good One Looks Like (WAGOLL)
Exemplar Standard
A top-tier student project for Slicers & Clearing includes:
- Core Deliverable: Add a Slicer and clear filters!
- Target Quality: Design an interactive mini-dashboard with multiple linked Slicers.
- Excellence & Polish: Audit filtered spreadsheets to prevent hidden-data errors in formulas. Typing: 30+ WPM.
📁
Save to Your Website Portfolio:
When you finish creating your project in your software, copy the share link or take a screenshot and publish it onto your student portfolio website!
⭐Self-Assessment: How confident do you feel with this skill?
Reflect
Learning check
Teacher setup, curriculum links and progress descriptors
Spark support
Routine: Step Inside
Achievement pathway
- Foundation: Locate the 'Clear Filter' command to reset a column.
- Developing: Insert interactive visual Slicers for one-touch category filtering.
- Secure: Design an interactive mini-dashboard with multiple linked Slicers.
- Mastering: Audit filtered spreadsheets to prevent hidden-data errors in formulas. Typing: 30+ WPM.
Curriculum links
Curriculum strand: MAT.03.E.1.6
Outcome: SPF-O-06 — Using visual Slicers and managing clear filter safety.
PYP: Reflection · Transparent data filtering and clear resets ensure accurate conclusions.
Learner profile: Reflective
Competency tags
Gate support
Accessibility alternative:
Teacher override: allow