📊
Learning objective
Organizing Tabular Data
Tables & Sorting
1
2
3
4
5
6
Welcome to Tables & Sorting! In this strand, you will master creating structured data tables, formatting headers, sorting text and numbers logically, and building clean multi-column layouts.
Grid & Headers
Basic table structure, identifying rows, columns, and headers.
Let's Go!
Learn
A table organizes information into vertical columns and horizontal rows. Putting titles in the top header row tells everyone exactly what information lives in each column!
| A | B | C | |
|---|---|---|---|
| 1 | Item | Amount | |
| 2 | Apples | 5 | |
| 3 | Bananas | 3 | |
| 4 | Carrots | 2 | |
| 5 | Total | =SUM(B2:B4) |
Try it yourself
Build a simple table!
🚀 Open a practice space
🌟 Student Project GuideSuccess Criteria & WAGOLL (What A Good One Looks Like)
🎯 Task Success Criteria (Rubric)
Foundation
Identify rows and columns in a grid.
Developing
Enter words and numbers into individual grid cells.
Secure (Goal)
Create a simple 2-column, 3-row table with clear headers.
Mastery
Explain the difference between a row and a column. Typing: 5 WPM.
👀 What A Good One Looks Like (WAGOLL)
Exemplar Standard
A top-tier student project for Grid & Headers includes:
- Core Deliverable: Build a simple table!
- Target Quality: Create a simple 2-column, 3-row table with clear headers.
- Excellence & Polish: Explain the difference between a row and a column. 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 rows and columns in a grid.
- Developing: Enter words and numbers into individual grid cells.
- Secure: Create a simple 2-column, 3-row table with clear headers.
- Mastering: Explain the difference between a row and a column. Typing: 5 WPM.
Curriculum links
Curriculum strand: MAT.01.C.1.4
Outcome: TS-O-01 — Basic table structure, identifying rows, columns, and headers.
PYP: Form · Organizing information into grids helps us understand and share data clearly.
Learner profile: Inquirer
Competency tags
Gate support
Accessibility alternative:
Teacher override: allow
Locked level
Level 2: Header Formatting
Complete the previous learning check to unlock this next level.
Header Formatting
Formatting table headers with bold text, fill color, and borders.
Learning objective
Learning About: Visual Hierarchy. Learning To: Format headers. Learning To Be: Communicator.
Let's Go!
Learn
Plain text tables can look messy! Bolding header text, adding a shaded fill background, and applying clean grid borders makes your table titles stand out immediately.
| 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
Format your table header!
🚀 Open a practice space
🌟 Student Project GuideSuccess Criteria & WAGOLL (What A Good One Looks Like)
🎯 Task Success Criteria (Rubric)
Foundation
Change text formatting inside table cells.
Developing
Apply bold text and background fill color to a header row.
Secure (Goal)
Add clean outer and inner grid borders to separate data cells.
Mastery
Explain why bold headers improve table readability. Typing: 10 WPM.
👀 What A Good One Looks Like (WAGOLL)
Exemplar Standard
A top-tier student project for Header Formatting includes:
- Core Deliverable: Format your table header!
- Target Quality: Add clean outer and inner grid borders to separate data cells.
- Excellence & Polish: Explain why bold headers improve table readability. 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: Change text formatting inside table cells.
- Developing: Apply bold text and background fill color to a header row.
- Secure: Add clean outer and inner grid borders to separate data cells.
- Mastering: Explain why bold headers improve table readability. Typing: 10 WPM.
Curriculum links
Curriculum strand: MAT.02.C.1.4
Outcome: TS-O-02 — Formatting table headers with bold text, fill color, and borders.
PYP: Function · Visual emphasis and clear headers make complex data tables scannable.
Learner profile: Communicator
Competency tags
Gate support
Accessibility alternative:
Teacher override: allow
Locked level
Level 3: Single Column Sort
Complete the previous learning check to unlock this next level.
Single Column Sort
Sorting tables alphabetically A-Z and numerically ascending/descending.
Learning objective
Learning About: Single Column Sort. Learning To: Sort A-Z & 1-9. Learning To Be: Thinker.
Let's Go!
Learn
Instead of retyping a list to put it in order, use the Sort feature! You can sort words alphabetically (A to Z) or numbers from smallest to largest (Ascending) in one click.
| 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
Sort A to Z and 1 to 10!
🚀 Open a practice space
🌟 Student Project GuideSuccess Criteria & WAGOLL (What A Good One Looks Like)
🎯 Task Success Criteria (Rubric)
Foundation
Locate the Sort tool in a spreadsheet or word processor.
Developing
Sort a list of student names alphabetically from A to Z.
Secure (Goal)
Sort numerical columns in ascending (1-9) or descending (9-1) order.
Mastery
Verify that entire rows move together when sorting a column. Typing: 15 WPM.
👀 What A Good One Looks Like (WAGOLL)
Exemplar Standard
A top-tier student project for Single Column Sort includes:
- Core Deliverable: Sort A to Z and 1 to 10!
- Target Quality: Sort numerical columns in ascending (1-9) or descending (9-1) order.
- Excellence & Polish: Verify that entire rows move together when sorting a column. 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: Locate the Sort tool in a spreadsheet or word processor.
- Developing: Sort a list of student names alphabetically from A to Z.
- Secure: Sort numerical columns in ascending (1-9) or descending (9-1) order.
- Mastering: Verify that entire rows move together when sorting a column. Typing: 15 WPM.
Curriculum links
Curriculum strand: CM.02.B.1.1
Outcome: TS-O-03 — Sorting tables alphabetically A-Z and numerically ascending/descending.
PYP: Change · Sorting tabular data enables quick searching and pattern detection.
Learner profile: Thinker
Competency tags
Gate support
Accessibility alternative:
Teacher override: allow
Locked level
Level 4: Multi-Column Sort
Complete the previous learning check to unlock this next level.
Multi-Column Sort
Multi-level sorting using primary and secondary sort keys.
Learning objective
Learning About: Multi-Level Sorting. Learning To: Apply primary & secondary sorts. Learning To Be: Principled.
Let's Go!
Learn
When multiple rows have the exact same value (like 30 students in 'Year 4'), a secondary sort breaks the tie! Sort by Year Group FIRST, then by Last Name SECOND.
| 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
Master multi-column sorting!
🚀 Open a practice space
🌟 Student Project GuideSuccess Criteria & WAGOLL (What A Good One Looks Like)
🎯 Task Success Criteria (Rubric)
Foundation
Understand why sorting by one column may leave tied values unsorted.
Developing
Apply a primary sort on one column and a secondary sort on another.
Secure (Goal)
Sort school data first by 'Year Group' (Primary) then by 'Last Name' (Secondary).
Mastery
Explain how multi-level sorting prevents scrambling related data. Typing: 20 WPM.
👀 What A Good One Looks Like (WAGOLL)
Exemplar Standard
A top-tier student project for Multi-Column Sort includes:
- Core Deliverable: Master multi-column sorting!
- Target Quality: Sort school data first by 'Year Group' (Primary) then by 'Last Name' (Secondary).
- Excellence & Polish: Explain how multi-level sorting prevents scrambling related data. 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 why sorting by one column may leave tied values unsorted.
- Developing: Apply a primary sort on one column and a secondary sort on another.
- Secure: Sort school data first by 'Year Group' (Primary) then by 'Last Name' (Secondary).
- Mastering: Explain how multi-level sorting prevents scrambling related data. Typing: 20 WPM.
Curriculum links
Curriculum strand: CM.02.B.1.1
Outcome: TS-O-04 — Multi-level sorting using primary and secondary sort keys.
PYP: Connection · Multi-tiered sorting reveals nested patterns across complex datasets.
Learner profile: Principled
Competency tags
Gate support
Accessibility alternative:
Teacher override: allow
Locked level
Level 5: Custom Lists & Banding
Complete the previous learning check to unlock this next level.
Custom Lists & Banding
Custom list sorting (days/months/priorities) and alternating row styles.
Learning objective
Learning About: Custom Order & Style. Learning To: Custom sort & band rows. Learning To Be: Knowledgeable.
Let's Go!
Learn
Alphabetical sorting puts 'Friday' before 'Monday' because F comes before M! Using Custom Sort Lists forces the computer to follow chronological or logical orders like 'High > Medium > Low'.
| 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
Custom sort and band your rows!
🚀 Open a practice space
🌟 Student Project GuideSuccess Criteria & WAGOLL (What A Good One Looks Like)
🎯 Task Success Criteria (Rubric)
Foundation
Recognize when alphabetical sorting fails (e.g. Monday coming after Friday).
Developing
Create and apply a Custom Sort List for days of the week or Priority (High/Med/Low).
Secure (Goal)
Apply alternating row colors (banded rows / zebra striping) to improve tracking.
Mastery
Evaluate readability of wide data tables before and after zebra striping. Typing: 25 WPM.
👀 What A Good One Looks Like (WAGOLL)
Exemplar Standard
A top-tier student project for Custom Lists & Banding includes:
- Core Deliverable: Custom sort and band your rows!
- Target Quality: Apply alternating row colors (banded rows / zebra striping) to improve tracking.
- Excellence & Polish: Evaluate readability of wide data tables before and after zebra striping. 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: Recognize when alphabetical sorting fails (e.g. Monday coming after Friday).
- Developing: Create and apply a Custom Sort List for days of the week or Priority (High/Med/Low).
- Secure: Apply alternating row colors (banded rows / zebra striping) to improve tracking.
- Mastering: Evaluate readability of wide data tables before and after zebra striping. Typing: 25 WPM.
Curriculum links
Curriculum strand: CM.03.B.1.3
Outcome: TS-O-05 — Custom list sorting (days/months/priorities) and alternating row styles.
PYP: Perspective · Custom sorting and zebra striping enhance readability for large datasets.
Learner profile: Knowledgeable
Competency tags
Gate support
Accessibility alternative:
Teacher override: allow
Locked level
Level 6: Clean & Freeze Data
Complete the previous learning check to unlock this next level.
Clean & Freeze Data
Data normalization, removing duplicate rows, and freezing header rows.
Learning objective
Learning About: Data Hygiene. Learning To: Clean duplicates & freeze headers. Learning To Be: Reflective.
Let's Go!
Learn
Professional data managers clean their tables before analyzing! Removing duplicate entries prevents double-counting, and Freezing the top header row keeps titles visible no matter how far down you scroll.
| 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
Clean duplicates and freeze headers!
🚀 Open a practice space
🌟 Student Project GuideSuccess Criteria & WAGOLL (What A Good One Looks Like)
🎯 Task Success Criteria (Rubric)
Foundation
Identify duplicate rows and inconsistencies in a dataset.
Developing
Use the 'Remove Duplicates' tool to clean raw tabular data.
Secure (Goal)
Freeze the top header row so column titles remain visible when scrolling down.
Mastery
Audit a large dataset for missing cells and inconsistent data types. Typing: 30+ WPM.
👀 What A Good One Looks Like (WAGOLL)
Exemplar Standard
A top-tier student project for Clean & Freeze Data includes:
- Core Deliverable: Clean duplicates and freeze headers!
- Target Quality: Freeze the top header row so column titles remain visible when scrolling down.
- Excellence & Polish: Audit a large dataset for missing cells and inconsistent data types. 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: Identify duplicate rows and inconsistencies in a dataset.
- Developing: Use the 'Remove Duplicates' tool to clean raw tabular data.
- Secure: Freeze the top header row so column titles remain visible when scrolling down.
- Mastering: Audit a large dataset for missing cells and inconsistent data types. Typing: 30+ WPM.
Curriculum links
Curriculum strand: MAT.03.E.1.6
Outcome: TS-O-06 — Data normalization, removing duplicate rows, and freezing header rows.
PYP: Reflection · Data integrity and frozen headers allow seamless navigation of large tables.
Learner profile: Reflective
Competency tags
Gate support
Accessibility alternative:
Teacher override: allow