Filtering Data

Spreadsheet Filters

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.

🎨Official Curriculum Sketchnote • Synthesis Poster🏆 100% Mastered

SPF VISUAL SUMMARY

Spreadsheet Filters

Congratulations on mastering Levels 1 to 6! Here is your one-page visual synthesis of every key concept learned:

▶View All 6 Level Key Concepts & Standards6 Levels Summarised

📌

Level 1🚀

Simple Sorting

Sorting table rows A-Z and numerical order.

Key Takeaway:Sorting rearranges rows into alphabetical or numerical order.

#spreadsheets#sorting#tables

✓ Mastered

📌

Level 2🛡️

AutoFilter On/Off

Enabling AutoFilter buttons on table headers.

Key Takeaway:AutoFilter adds small drop-down arrows to every column header.

#autofilter#dropdown-menus#spreadsheet-basics

✓ Mastered

📌

Level 3🔑

Single Category

Filtering a column by selecting a single category.

Key Takeaway:Filtering by category lets you select exactly what you want to see.

#category-filters#checkboxes#data-query

✓ Mastered

📌

Level 4💻

Multi-Column Filters

Applying simultaneous filters across multiple columns.

Key Takeaway: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.

#multi-filter#combined-criteria#boolean-and

✓ Mastered

📌

Level 5🔐

Number & Text Rules

Filtering using numerical rules and text conditions.

Key Takeaway: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.

#number-filters#text-conditions#thresholds

✓ Mastered

📌

Level 6🏆

Slicers & Clearing

Using visual Slicers and managing clear filter safety.

Key Takeaway: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.

#slicers#clear-filters#interactive-dashboards

✓ Mastered

🧩 TOP SECRET • VAULT KEY SHARD REVEALED✓ 100% STRAND MASTERY REWARD

🗝️

STRAND KEY SHARD #3 OF 8

Area Boss Cipher Fragment Discovered!

Congratulations on completing all 6 levels of Spreadsheet Filters! To unlock the Data Detective Agency, you must collect all 8 Key Shards across the Data, Spreadsheets & Science strands. Here is your cipher fragment for Slot #3:

KEY SHARD #3

Slot 3 of 8

🧩 Data, Spreadsheets & Science Key Ring Tracker:Slot #3 Active

#1?

#2?

#34

#4?

#5?

#6?

#7?

#8?

Go to Data, Spreadsheets & Science Boss Vault➔

Level 1

Simple Sorting

Sorting table rows A-Z and numerical order.

Learning objective

Learning About: Sorting. Learning To: Sort A-Z & 1-10. Learning To Be: Inquirer.

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! In computing, organising data helps us see patterns and find information quickly. As you explore the interactive Spreadsheet Simulator below, focus on how to sort data rows without scrambling adjacent columns.

Interactive Simulator Sandbox

📊

Spreadsheet StudioStep 1 • Bronze Tier

A1fx

	A	B
1	Item	Amount
2	Apples	5
3	Bananas	3
4	Carrots	2
5	Total

Challenge: Click cell B5 to inspect how the AutoSum formula adds up column B!

Apply Simulator Skills • Try it yourself

Sort your first data table!

🥉 Bronze Transfer • Task 1Open the practice spreadsheet in your workspace to establish the foundational setup for simple sorting.

🥈 Silver Transfer • Task 2Click inside the 'Name' column header carefully, checking your settings and controls as you build your project.

🥇 Gold Transfer • Task 3Click the 'Sort A-Z' button and verify that your output meets the target goal for simple sorting.

✨ Extension Task • Task 3+Verify all names are now in alphabetical order and review your finished work so it is ready to share in your digital portfolio.

🚀 Open a practice space

📊Open Google Sheets

Or try locally: 💻 LibreOffice Calc (free)

🌟 Student Project GuideSuccess Criteria & WAGOLL (What A Good One Looks Like)▾

🎯 Task Success Criteria (Rubric)

Identify a table header row in a spreadsheet.

Sort a single column from A to Z using toolbar buttons.

Sort data rows without scrambling adjacent columns.

Explain why header rows must be frozen when sorting. Typing: 5 WPM.

👀 What A Good One Looks Like (WAGOLL)

Exemplar 1 of 2

⭐ Mastering Standard

Filtering Data Exemplar: Demonstration of mastering quality standards for Simple Sorting.

⭐ Mastering Standard

Filtering Data Exemplar: Demonstration of mastering quality standards for Simple Sorting.

📁

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!

Reflect

Learning check

Which button symbol is used to sort a table column from A to Z?

Select the matching icon or option below:

🔤Sort A-Z🌪️Filter∑SUM Formula📊Bar Chart

Answer correctly to unlock the next level.

Teacher setup, curriculum links and progress descriptors

Spark support

Routine: See, Think, Wonder

Teacher notes: Facilitate the See, Think, Wonder routine for 2–3 minutes. Encourage students to connect the prompt to Form (Organising data helps us see patterns and find information quickly.).

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

spreadsheets
sorting
tables
data-organisation

Gate support

Accessibility alternative: Students may verbally explain or point to the correct answer for "Which button symbol is used to sort a table column from A to Z?" with a teacher or teaching assistant.

Teacher override: allow

Locked level

Level 2: AutoFilter On/Off

Complete the previous learning check to unlock this next level.

Level 2

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! In computing, filters help us focus on specific information without deleting other data. As you explore the interactive Diagram Builder Simulator below, focus on how to turn AutoFilter off to restore the full unfiltered dataset.

Interactive Simulator Sandbox

⚙️ Flow Inspector

Total Nodes: 0

Connections: 0

Cyclomatic Complexity: 1 (Linear)

Place shapes from palette to begin constructing your diagram.

💻 Synced Pseudocode:

// Flowchart execution logic
BEGIN Process
  // Add nodes to generate code
END

Quick Blueprints:

Apply Simulator Skills • Try it yourself

Turn AutoFilter on and off!

🥉 Bronze Transfer • Task 4Highlight your table header row in your workspace to establish the foundational setup for autofilter on/off.

🥈 Silver Transfer • Task 5Click the 'Filter' funnel button on the toolbar carefully, checking your settings and controls as you build your project.

🥇 Gold Transfer • Task 6Confirm small drop-down arrows appear on each header.

✨ Extension Task • Task 6+Click 'Filter' again to turn it off and review your finished work so it is ready to share in your digital portfolio.

🚀 Open a practice space

📊Open Google Sheets

Or try locally: 💻 LibreOffice Calc (free)

🌟 Student Project GuideSuccess Criteria & WAGOLL (What A Good One Looks Like)▾

🎯 Task Success Criteria (Rubric)

Locate the Filter button on the spreadsheet toolbar.

Turn AutoFilter on to reveal drop-down arrows on headers.

Turn AutoFilter off to restore the full unfiltered dataset.

Explain that filtering hides rows without deleting them. Typing: 10 WPM.

👀 What A Good One Looks Like (WAGOLL)

Exemplar 1 of 2

⭐ Mastering Standard

Filtering Data Exemplar: Demonstration of mastering quality standards for AutoFilter On/Off.

⭐ Mastering Standard

Filtering Data Exemplar: Demonstration of mastering quality standards for AutoFilter On/Off.

📁

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!

Reflect

Learning check

What happens to your hidden rows when you turn off the AutoFilter tool?

Select the correct answer from the options below.

They are permanently deletedThey are moved to another documentThey reappear instantly on your screenThey turn red

Answer correctly to unlock the next level.

Teacher setup, curriculum links and progress descriptors

Spark support

Routine: Zoom In

Teacher notes: Facilitate the Zoom In routine for 2–3 minutes. Encourage students to connect the prompt to Function (Filters help us focus on specific information without deleting other data.).

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

autofilter
dropdown-menus
spreadsheet-basics
focus

Gate support

Accessibility alternative: Students may verbally explain or point to the correct answer for "What happens to your hidden rows when you turn off the AutoFilter tool?" with a teacher or teaching assistant.

Teacher override: allow

Locked level

Level 3: Single Category

Complete the previous learning check to unlock this next level.

Level 3

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! In computing, isolating variables reveals specific patterns within large datasets. As you explore the interactive Shortcut Simulator below, focus on how to filter a dataset to show only rows matching one category (e.g., 'Grade 3').

Interactive Simulator Sandbox

Target Shortcut:Ctrl + A

✨ Mission Ready

💡 Click or press keys on your physical keyboard:

📁 Source Document (Research Notes)

➔

📋 Destination Notebook (Clean Summary)

Apply Simulator Skills • Try it yourself

Filter by a single category!

🥉 Bronze Transfer • Task 7Click the drop-down arrow on the 'Category' header in your workspace to establish the foundational setup for single category.

🥈 Silver Transfer • Task 8Uncheck '(Select All)' carefully, checking your settings and controls as you build your project.

🥇 Gold Transfer • Task 9Check the box for 'Mammal' and verify that your output meets the target goal for single category.

✨ Extension Task • Task 9+Click OK and count how many rows remain and review your finished work so it is ready to share in your digital portfolio.

🚀 Open a practice space

📊Open Google Sheets

Or try locally: 💻 LibreOffice Calc (free)

🌟 Student Project GuideSuccess Criteria & WAGOLL (What A Good One Looks Like)▾

🎯 Task Success Criteria (Rubric)

Open a column filter drop-down menu.

Uncheck 'Select All' and select a single item checkbox.

Filter a dataset to show only rows matching one category (e.g., 'Grade 3').

Count filtered items using the status bar count. Typing: 15 WPM.

👀 What A Good One Looks Like (WAGOLL)

Exemplar 1 of 2

⭐ Mastering Standard

Filtering Data Exemplar: Demonstration of mastering quality standards for Single Category.

⭐ Mastering Standard

Filtering Data Exemplar: Demonstration of mastering quality standards for Single Category.

📁

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!

Reflect

Learning check

What is the first step when you want to filter a column for only 'Green' items?

Choose the correct sequence.

Delete all the red itemsClick the column header drop-down arrow and uncheck 'Select All'Type 'Green' in every rowClose the spreadsheet

Answer correctly to unlock the next level.

Teacher setup, curriculum links and progress descriptors

Spark support

Routine: Think, Puzzle, Explore

Teacher notes: Facilitate the Think, Puzzle, Explore routine for 2–3 minutes. Encourage students to connect the prompt to Connection (Isolating variables reveals specific patterns within large datasets.).

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

category-filters
checkboxes
data-query
analysis

Gate support

Accessibility alternative: Students may verbally explain or point to the correct answer for "What is the first step when you want to filter a column for only 'Green' items?" with a teacher or teaching assistant.

Teacher override: allow

Locked level

Level 4: Multi-Column Filters

Complete the previous learning check to unlock this next level.

Level 4

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. In computing, combining multiple criteria allows precise and targeted data analysis. As you explore the interactive Spreadsheet Simulator below, focus on how to answer targeted queries requiring two criteria (e.g., 'Fruit' AND 'In Stock').

Interactive Simulator Sandbox

📊

Spreadsheet StudioStep 4 • Bronze Tier

A1fx

	A	B
1	Item	Amount
2	Apples	5
3	Bananas	3
4	Carrots	2
5	Total

Challenge: Click cell B5 to inspect how the AutoSum formula adds up column B!

Apply Simulator Skills • Try it yourself

Filter across two columns!

🥉 Bronze Transfer • Task 10Filter the 'Type' column for 'Fruit' in your workspace to establish the foundational setup for multi-column filters.

🥈 Silver Transfer • Task 11Next, filter the 'Status' column for 'In Stock' carefully, checking your settings and controls as you build your project.

🥇 Gold Transfer • Task 12Verify that all displayed rows match BOTH conditions.

🚀 Open a practice space

📊Open Google Sheets

Or try locally: 💻 LibreOffice Calc (free)

🌟 Student Project GuideSuccess Criteria & WAGOLL (What A Good One Looks Like)▾

🎯 Task Success Criteria (Rubric)

Understand that filtering column A affects what is visible in column B.

Apply a filter on Column A, then apply a second filter on Column B.

Answer targeted queries requiring two criteria (e.g., 'Fruit' AND 'In Stock').

Identify which columns have active filters by inspecting header funnel icons. Typing: 20 WPM.

👀 What A Good One Looks Like (WAGOLL)

Exemplar 1 of 2

⭐ Mastering Standard

Filtering Data Exemplar: Demonstration of mastering quality standards for Multi-Column Filters.

⭐ Mastering Standard

Filtering Data Exemplar: Demonstration of mastering quality standards for Multi-Column Filters.

📁

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!

Reflect

Learning check

How can you tell if a specific column currently has an active filter applied to it?

Select the best answer.

The column turns bright redThe drop-down arrow changes into a small funnel iconThe text changes to italicsThe column disappears completely

Answer correctly to unlock the next level.

Teacher setup, curriculum links and progress descriptors

Spark support

Routine: See, Think, Wonder

Teacher notes: Facilitate the See, Think, Wonder routine for 2–3 minutes. Encourage students to connect the prompt to Responsibility (Combining multiple criteria allows precise and targeted data analysis.).

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

multi-filter
combined-criteria
boolean-and
precision

Gate support

Accessibility alternative: Students may verbally explain or point to the correct answer for "How can you tell if a specific column currently has an active filter applied to it?" with a teacher or teaching assistant.

Teacher override: allow

Locked level

Level 5: Number & Text Rules

Complete the previous learning check to unlock this next level.

Level 5

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. In computing, numerical thresholds and text conditions help us extract strategic evidence. As you explore the interactive Formatting Toolbar Simulator below, focus on how to use text conditions like 'Contains' or 'Begins With' to filter unstructured text.

Interactive Simulator Sandbox

Words: 0Characters: 0Estimated Speed: 0 WPM

💾 All changes saved to Drive

Apply Simulator Skills • Try it yourself

Apply a number rule filter!

🥉 Bronze Transfer • Task 13Click the 'Score' column filter in your workspace to establish the foundational setup for number & text rules.

🥈 Silver Transfer • Task 14Hover over 'Number Filters' and select 'Greater Than...'.

🥇 Gold Transfer • Task 15Type '50' into the value box and click OK and verify that your output meets the target goal for number & text rules.

✨ Extension Task • Task 15+Verify all visible scores are over 50 and review your finished work so it is ready to share in your digital portfolio.

🚀 Open a practice space

📊Open Google Sheets

Or try locally: 💻 LibreOffice Calc (free)

🌟 Student Project GuideSuccess Criteria & WAGOLL (What A Good One Looks Like)▾

🎯 Task Success Criteria (Rubric)

Access 'Number Filters' and 'Text Filters' sub-menus.

Apply number conditions such as 'Greater Than', 'Less Than', or 'Between'.

Use text conditions like 'Contains' or 'Begins With' to filter unstructured text.

Combine numerical thresholds with text rules to solve complex scenarios. Typing: 25 WPM.

👀 What A Good One Looks Like (WAGOLL)

Exemplar 1 of 2

⭐ Mastering Standard

Filtering Data Exemplar: Demonstration of mastering quality standards for Number & Text Rules.

⭐ Mastering Standard

Filtering Data Exemplar: Demonstration of mastering quality standards for Number & Text Rules.

📁

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!

Reflect

Learning check

Which Number Filter condition would you use to find all items priced over $100?

Select the correct rule option.

Equals...Less Than...Greater Than...Begins With...

Answer correctly to unlock the next level.

Teacher setup, curriculum links and progress descriptors

Spark support

Routine: I used to think...

Teacher notes: Facilitate the I used to think... routine for 2–3 minutes. Encourage students to connect the prompt to Perspective (Numerical thresholds and text conditions help us extract strategic evidence.).

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

number-filters
text-conditions
thresholds
search-rules

Gate support

Accessibility alternative: Students may verbally explain or point to the correct answer for "Which Number Filter condition would you use to find all items priced over $100?" with a teacher or teaching assistant.

Teacher override: allow

Locked level

Level 6: Slicers & Clearing

Complete the previous learning check to unlock this next level.

Level 6

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. In computing, transparent data filtering and clear resets ensure accurate conclusions. As you explore the interactive Python Console Simulator below, focus on how to design an interactive mini-dashboard with multiple linked Slicers.

Interactive Simulator Sandbox

🐍main.pyClean

Snippets:

Target: Type print("Hello World!") and run your script.

Interactive Python REPL (v3.12.2)

Python 3.12.2 (tags/v3.12.2:5acc80f, Feb 6 2024, 01:22:40) [MSC v.1938 64 bit (AMD64)]

Type "help", "copyright", "credits" or "license" for more information.

>>> Ready to execute scripts.

🌲

AST Root NodeModuleAbstract Syntax Tree representation.

🏷️

Symbol Scope0 IdentifiersGlobal variable memory allocations.

🛡️

Linter & PEP 8CleanZero syntax or indentation warnings.

⚡

Complexity & LoopsO(1)Bounded iteration & recursion safety.

Python Abstract Syntax Tree (AST)Valid AST

Type Python code in the IDE to view real-time AST node tree parsing.

Runtime Variable Symbol TableStack Memory

Identifier	Type	Value	Scope
No active variables in memory. Assign variables (e.g. score = 100) to inspect.

Apply Simulator Skills • Try it yourself

Add a Slicer and clear filters!

🥉 Bronze Transfer • Task 16Convert your range to a Table in your workspace to establish the foundational setup for slicers & clearing.

🥈 Silver Transfer • Task 17Click 'Insert Slicer' and select 'Category' carefully, checking your settings and controls as you build your project.

🥇 Gold Transfer • Task 18Click Slicer buttons to filter instantly and verify that your output meets the target goal for slicers & clearing.

✨ Extension Task • Task 18+Click the 'Clear Filter' button to reset the table and review your finished work so it is ready to share in your digital portfolio.

🚀 Open a practice space

📊Open Google Sheets

Or try locally: 💻 LibreOffice Calc (free)

🌟 Student Project GuideSuccess Criteria & WAGOLL (What A Good One Looks Like)▾

🎯 Task Success Criteria (Rubric)

Locate the 'Clear Filter' command to reset a column.

Insert interactive visual Slicers for one-touch category filtering.

Design an interactive mini-dashboard with multiple linked Slicers.

Audit filtered spreadsheets to prevent hidden-data errors in formulas. Typing: 30+ WPM.

👀 What A Good One Looks Like (WAGOLL)

Exemplar 1 of 2

⭐ Mastering Standard

Filtering Data Exemplar: Demonstration of mastering quality standards for Slicers & Clearing.

⭐ Mastering Standard

Filtering Data Exemplar: Demonstration of mastering quality standards for Slicers & Clearing.

📁

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!

Reflect

Learning check

Why is it important to click 'Clear Filter' before calculating grand totals across a raw dataset?

Choose the best professional practice.

It deletes the spreadsheetFiltered hidden rows might be missed if you only look at visible textIt changes all numbers to zeroIt locks the screen

Answer correctly to complete this strand.

Teacher setup, curriculum links and progress descriptors

Spark support

Routine: Step Inside

Teacher notes: Facilitate the Step Inside routine for 2–3 minutes. Encourage students to connect the prompt to Reflection (Transparent data filtering and clear resets ensure accurate conclusions.).

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

slicers
clear-filters
interactive-dashboards
data-integrity

Gate support

Accessibility alternative: Students may verbally explain or point to the correct answer for "Why is it important to click 'Clear Filter' before calculating grand totals across a raw dataset?" with a teacher or teaching assistant.

Teacher override: allow

🎒 Students Home →

Spreadsheet Filters

Spreadsheet Filters

Simple Sorting

AutoFilter On/Off

Single Category

Multi-Column Filters

Number & Text Rules

Slicers & Clearing

Stage Mastery Quest Challenge

Spreadsheet Filters

What is your next action?

Question Prompt goes here?

STRAND MASTERY ACHIEVED!

Area Boss Cipher Fragment Discovered!

🎉 Mastered! Keep Practicing!

Learning About: Sorting. Learning To: Sort A-Z & 1-10. Learning To Be: Inquirer.

Data Visualization Chart

Sort your first data table!

🎯 Task Success Criteria (Rubric)

👀 What A Good One Looks Like (WAGOLL)

Self-Assessment & Reflection

Which button symbol is used to sort a table column from A to Z?

Spark support

Achievement pathway

Curriculum links

Competency tags

Gate support

Level 2: AutoFilter On/Off

Learning About: AutoFilter. Learning To: Toggle filters. Learning To Be: Communicator.

🧠 Hierarchical Mind Map & Concept Mapping Studio

⭕ 2-Circle Venn Diagram & Hierarchical Classification Tree

📐 Flowchart Logic, Venn Sets & CAD Schematic Audit

1. Standard ISO Flowchart Symbols

2. Visual Hierarchy & Linking Phrases

3. Mathematical Set Intersections

4. Top-Down Modular Decomposition

📋 Diagram Engineering Quality Checklist

Turn AutoFilter on and off!

🎯 Task Success Criteria (Rubric)

👀 What A Good One Looks Like (WAGOLL)

Self-Assessment & Reflection

What happens to your hidden rows when you turn off the AutoFilter tool?

Spark support

Achievement pathway

Curriculum links

Competency tags

Gate support

Level 3: Single Category

Learning About: Category Filters. Learning To: Filter by value. Learning To Be: Thinker.

Filter by a single category!

🎯 Task Success Criteria (Rubric)

👀 What A Good One Looks Like (WAGOLL)

Self-Assessment & Reflection

What is the first step when you want to filter a column for only 'Green' items?

Spark support

Achievement pathway

Curriculum links

Competency tags

Gate support

Level 4: Multi-Column Filters

Learning About: Multi-Column Filtering. Learning To: Apply AND logic. Learning To Be: Principled.

Data Visualization Chart

Filter across two columns!

🎯 Task Success Criteria (Rubric)

👀 What A Good One Looks Like (WAGOLL)

Self-Assessment & Reflection

How can you tell if a specific column currently has an active filter applied to it?

Spark support

Achievement pathway

Curriculum links

Competency tags

Gate support

Level 5: Number & Text Rules

Learning About: Condition Filters. Learning To: Filter by rule. Learning To Be: Knowledgeable.

📊 Document Analytics & Typing Proficiency

📋 Curriculum Digital Writing Checklist

Apply a number rule filter!

🎯 Task Success Criteria (Rubric)

👀 What A Good One Looks Like (WAGOLL)

Self-Assessment & Reflection