📊
Learning objective
Data Manipulation & Operations
Spreadsheet Operations
1
2
3
4
5
6
Welcome to Spreadsheet Operations! In this strand, you will master inserting, deleting, formatting, linking, and restructuring data inside spreadsheet tables efficiently.
Rows & Columns
Grid navigation, row/column selection, and cell entry.
Let's Go!
Learn
A spreadsheet grid is made of vertical Columns (labeled with letters A, B, C) and horizontal Rows (labeled with numbers 1, 2, 3). Clicking a column letter selects the whole column!
| A | B | C | |
|---|---|---|---|
| 1 | Item | Amount | |
| 2 | Apples | 5 | |
| 3 | Bananas | 3 | |
| 4 | Carrots | 2 | |
| 5 | Total | =SUM(B2:B4) |
Try it yourself
Grid Explorer
🚀 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 grid letters and numbers.
Developing
Select specific cells by reference (e.g. B3).
Secure (Goal)
Select entire rows and columns and enter text.
Mastery
Resize column widths to fit long text. Typing: 5 WPM.
👀 What A Good One Looks Like (WAGOLL)
Exemplar Standard
A top-tier student project for Rows & Columns includes:
- Core Deliverable: Grid Explorer
- Target Quality: Select entire rows and columns and enter text.
- Excellence & Polish: Resize column widths to fit long text. 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 grid letters and numbers.
- Developing: Select specific cells by reference (e.g. B3).
- Secure: Select entire rows and columns and enter text.
- Mastering: Resize column widths to fit long text. Typing: 5 WPM.
Curriculum links
Curriculum strand: MAT.01.C.1.4
Outcome: SPO-O-01 — Grid navigation, row/column selection, and cell entry.
PYP: Form · Grids and tables help us structure and locate information.
Learner profile: Inquirer
Competency tags
Gate support
Accessibility alternative:
Teacher override: allow
Locked level
Level 2: Insert & Delete
Complete the previous learning check to unlock this next level.
Insert & Delete
Inserting/deleting rows, columns, and clearing contents.
Learning objective
Learning About: Table Restructuring. Learning To: Insert & delete rows/columns. Learning To Be: Communicator.
Let's Go!
Learn
When you forget to include an item in your table, you don't need to restart! Right-click any row number or column header and select 'Insert' to add a blank row or column right where you need it.
| 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
Row & Column Editor
🚀 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
Use Delete/Backspace to clear text in a cell.
Developing
Right-click a row number to open the context menu.
Secure (Goal)
Insert new blank rows and columns into an existing table.
Mastery
Explain the difference between clearing content and deleting a row.
👀 What A Good One Looks Like (WAGOLL)
Exemplar Standard
A top-tier student project for Insert & Delete includes:
- Core Deliverable: Row & Column Editor
- Target Quality: Insert new blank rows and columns into an existing table.
- Excellence & Polish: Explain the difference between clearing content and deleting a row.
📁
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: Use Delete/Backspace to clear text in a cell.
- Developing: Right-click a row number to open the context menu.
- Secure: Insert new blank rows and columns into an existing table.
- Mastering: Explain the difference between clearing content and deleting a row.
Curriculum links
Curriculum strand: MAT.02.C.1.4
Outcome: SPO-O-02 — Inserting/deleting rows, columns, and clearing contents.
PYP: Function · Updating tables keeps our datasets complete and accurate.
Learner profile: Communicator
Competency tags
Gate support
Accessibility alternative:
Teacher override: allow
Locked level
Level 3: Cell Formatting
Complete the previous learning check to unlock this next level.
Cell Formatting
Formatting data types (Currency, Percentage, Date, Text).
Learning objective
Learning About: Number Formatting. Learning To: Apply Currency & Percentage formats. Learning To Be: Thinker.
Let's Go!
Learn
Raw numbers like '12.5' can be confusing. Is it $12.50? 12.5%? Or 12.5 kg? Number formatting tells the computer how to present the value clearly without changing the underlying mathematical data!
| 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 the Store Prices
🚀 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
Recognise that numbers can represent money, dates, or percentages.
Developing
Format numbers as Currency (£/$/€) using toolbar buttons.
Secure (Goal)
Format cells correctly as Percentage (%), Currency, or Short Date.
Mastery
Adjust decimal places (increase/decrease decimals) appropriately.
👀 What A Good One Looks Like (WAGOLL)
Exemplar Standard
A top-tier student project for Cell Formatting includes:
- Core Deliverable: Format the Store Prices
- Target Quality: Format cells correctly as Percentage (%), Currency, or Short Date.
- Excellence & Polish: Adjust decimal places (increase/decrease decimals) appropriately.
📁
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: Recognise that numbers can represent money, dates, or percentages.
- Developing: Format numbers as Currency (£/$/€) using toolbar buttons.
- Secure: Format cells correctly as Percentage (%), Currency, or Short Date.
- Mastering: Adjust decimal places (increase/decrease decimals) appropriately.
Curriculum links
Curriculum strand: CM.02.B.1.1
Outcome: SPO-O-03 — Formatting data types (Currency, Percentage, Date, Text).
PYP: Connection · Formatting numbers properly conveys exact meaning and context.
Learner profile: Thinker
Competency tags
Gate support
Accessibility alternative:
Teacher override: allow
Locked level
Level 4: Fill & Drag
Complete the previous learning check to unlock this next level.
Fill & Drag
Using the Fill Handle for series generation and copying formulas.
Learning objective
Learning About: Auto-Fill. Learning To: Use Fill Handle for series & formulas. Learning To Be: Principled.
Let's Go!
Learn
The Fill Handle (the little black square at the bottom right corner of a cell selection) is your biggest productivity helper! Dragging it copies formulas down a column while automatically updating row references.
| 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
Fill the Column!
🚀 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 small square Fill Handle in the bottom-right of a selected cell.
Developing
Drag Fill Handle to auto-complete days of the week or month series.
Secure (Goal)
Drag Fill Handle down a column to copy a calculation formula across rows.
Mastery
Explain how relative cell references automatically shift when filled down.
👀 What A Good One Looks Like (WAGOLL)
Exemplar Standard
A top-tier student project for Fill & Drag includes:
- Core Deliverable: Fill the Column!
- Target Quality: Drag Fill Handle down a column to copy a calculation formula across rows.
- Excellence & Polish: Explain how relative cell references automatically shift when filled down.
📁
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: Locate the small square Fill Handle in the bottom-right of a selected cell.
- Developing: Drag Fill Handle to auto-complete days of the week or month series.
- Secure: Drag Fill Handle down a column to copy a calculation formula across rows.
- Mastering: Explain how relative cell references automatically shift when filled down.
Curriculum links
Curriculum strand: CM.02.B.1.1
Outcome: SPO-O-04 — Using the Fill Handle for series generation and copying formulas.
PYP: Responsibility · Pattern replication tools speed up workflow and reduce errors.
Learner profile: Principled
Competency tags
Gate support
Accessibility alternative:
Teacher override: allow
Locked level
Level 5: Conditional Format
Complete the previous learning check to unlock this next level.
Conditional Format
Highlight rules, data bars, and color scales for automatic visualization.
Learning objective
Learning About: Visual Rules. Learning To: Apply Conditional Formatting rules. Learning To Be: Knowledgeable.
Let's Go!
Learn
Conditional Formatting changes a cell's appearance (fill color, text color, borders) automatically whenever its value meets a specific rule you defined—like highlighting low inventory in red!
| 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
Rule Creator
🚀 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 cell colors can change automatically based on cell value.
Developing
Apply 'Highlight Cell Rules > Greater Than' to flag numbers.
Secure (Goal)
Set up multi-rule formatting (e.g. Red for <50, Green for >=80).
Mastery
Apply Data Bars or Color Scales to visually compare dataset ranges.
👀 What A Good One Looks Like (WAGOLL)
Exemplar Standard
A top-tier student project for Conditional Format includes:
- Core Deliverable: Rule Creator
- Target Quality: Set up multi-rule formatting (e.g. Red for <50, Green for >=80).
- Excellence & Polish: Apply Data Bars or Color Scales to visually compare dataset ranges.
📁
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 cell colors can change automatically based on cell value.
- Developing: Apply 'Highlight Cell Rules > Greater Than' to flag numbers.
- Secure: Set up multi-rule formatting (e.g. Red for <50, Green for >=80).
- Mastering: Apply Data Bars or Color Scales to visually compare dataset ranges.
Curriculum links
Curriculum strand: CM.03.B.1.3
Outcome: SPO-O-05 — Highlight rules, data bars, and color scales for automatic visualization.
PYP: Perspective · Automated rules bring key data insights to light instantly.
Learner profile: Knowledgeable
Competency tags
Gate support
Accessibility alternative:
Teacher override: allow
Locked level
Level 6: Tabs & Links
Complete the previous learning check to unlock this next level.
Tabs & Links
Multi-tab workbooks, 3D cross-sheet references, and Freeze Panes.
Learning objective
Learning About: Multi-Tab Architecture. Learning To: Link worksheets & freeze headers. Learning To Be: Reflective.
Let's Go!
Learn
A workbook can contain multiple worksheets (tabs)! You can link values between tabs by typing '=' and clicking a cell on another tab. Freezing top rows ensures headers stay visible during scrolling.
| 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
Build a Multi-Tab Dashboard
🚀 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
Add, rename, and color-code new worksheet tabs at the bottom of a workbook.
Developing
Freeze top row headers so column titles stay visible when scrolling.
Secure (Goal)
Link formulas across tabs using 3D references (e.g. '=Summary!B5').
Mastery
Design an executive summary dashboard sheet that pulls totals from 4 quarterly tabs.
👀 What A Good One Looks Like (WAGOLL)
Exemplar Standard
A top-tier student project for Tabs & Links includes:
- Core Deliverable: Build a Multi-Tab Dashboard
- Target Quality: Link formulas across tabs using 3D references (e.g. '=Summary!B5').
- Excellence & Polish: Design an executive summary dashboard sheet that pulls totals from 4 quarterly tabs.
📁
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: Add, rename, and color-code new worksheet tabs at the bottom of a workbook.
- Developing: Freeze top row headers so column titles stay visible when scrolling.
- Secure: Link formulas across tabs using 3D references (e.g. '=Summary!B5').
- Mastering: Design an executive summary dashboard sheet that pulls totals from 4 quarterly tabs.
Curriculum links
Curriculum strand: MAT.03.E.1.6
Outcome: SPO-O-06 — Multi-tab workbooks, 3D cross-sheet references, and Freeze Panes.
PYP: Reflection · Structured multi-sheet systems organise complex interconnected projects.
Learner profile: Reflective
Competency tags
Gate support
Accessibility alternative:
Teacher override: allow