Computer Skills

Beginner

60 mins

Teacher/Student led

+80 XP

What you need:
Chromebook/Laptop/PC or iPad/Tablet

What's a Spreadsheet for? Suitable Uses

Explore when spreadsheets are the right tool and when a word processor or database works better. You'll analyse three tool scenarios, model three spreadsheet options for one sample project, then choose the spreadsheet you'll build for your own Something Real project.

Warning: Your screen size is quite small for viewing this. Rotate your device into landscape mode if you can.

1 Introduction
2 Key Concepts
3 Step-by-step Task
4 Common Issues
5 Independent Practice
6 Reflection
7 Lesson Summary
Quiz

1 - Introduction

Welcome

Spreadsheets are powerful, but they are not the answer to every question. Before you spend the next few weeks building one for your Something Real project, you need to know what you're building and why it belongs in a spreadsheet rather than a document or a database. Picking the wrong tool is how people waste hours.

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

Identify situations where a spreadsheet is the right tool
Recognise when a word processor or database would be better
Choose the spreadsheet you will build across ICT2

Warm-up

Picture three real tasks your Work Experience supervisor might hand you on day one: tallying last month's daily takings, writing a short thank-you note to a supplier, and looking up a customer's delivery address. Without clicking anything, decide in your head: which of those three is clearly a job for a spreadsheet, which is clearly not, and which is in between? Hold that thought.

Teacher Notes

Students may assume a spreadsheet is always the 'more professional' choice. The warm-up surfaces that instinct so it can be corrected during Key Concepts.

👇 Mark your steps as done as you complete them.

+5 XP

2 - Key Concepts

Three tools, one job each. The last row is the headline: if you learn one thing today, learn that.

Concept	Why it matters	Example
Spreadsheet — a grid where the same maths runs down every row	Does repeated maths for you, so you don't redo it by hand every time a number changes.	Daily bakery sales for a week — one row per day, totals at the bottom
Word processor — software for prose and formatted documents	Best when readers go top to bottom, not when you're calculating.	A one-page cover letter for an apprenticeship
Database — software that stores thousands of records you can search and link	When data gets huge and many people search it daily, spreadsheets slow down and break.	Revenue's PAYE system tracks every worker in Ireland
The "same-calculation" test — if the same maths runs on every row, it's a spreadsheet job	Fastest way to decide between the three tools.	—

Teacher Notes

Emphasise the last row out loud. If students can apply the same-calculation test, the rest follows naturally.

👇 Mark your steps as done as you complete them.

+10 XP

3 - Step-by-step Task

Build the document that holds your use-case analysis. You'll work through two small tables: one comparing the three tools side by side, and one showing three spreadsheet options for a sample project. The second table is the exact shape you'll copy in the next step for your own project.

Teacher Notes

Students may argue with the worked examples (e.g. 'but a spreadsheet CAN hold a cover letter'). Accept the challenge, then redirect: 'Can it — or should it?' The test is fit, not possibility. For the fundraiser model table, make sure students see that all three rows are spreadsheet jobs; the decision is not about tool choice but about which question the spreadsheet should answer first.

+15 XP

4 - Common Issues

Common Issues

Issue	Solution
I'm stuck between "spreadsheet" and "word processor" for a scenario	Apply the same-calculation test. If the same maths (add, average, count, compare) runs across every row, it's a spreadsheet. If the content is read top to bottom with no calculations, it's a word processor. When in doubt, sketch what one row would look like — if there is no "one row", it's prose.
My Something Real project doesn't really have numbers, so nothing feels like a spreadsheet job	Every project has something countable: costs, hours, people, items, supplies, responses, dates. You don't need a big number, you need a repeated one. Even a 7-row weekly schedule or a 10-item shopping list is a legitimate spreadsheet.
I can't think of three different options for my project	Use the fundraiser model from the second table. Your three options can be three different views of the same project: a budget sheet (costs), a timeline sheet (what happens when), and an inventory or tracking sheet (what you need or what you've done). Same project, three different questions a spreadsheet could answer.

+10 XP

5 - Independent Practice

Independent Practice

Your goal: Decide what kind of spreadsheet you will actually build for your Something Real project over the next few weeks — so when you start entering data, you already know what question it is supposed to answer.

Time:~20 minutes

Task: Open {{code:31_spreadsheet_use_case}} and add a third section below the two tables you just built, with the heading My Project Use Cases. Insert a new 3×4 table with the same Scenario / Best tool / Why headings and fill it with three different spreadsheet ideas you could build for your own Something Real project — use the fundraiser table (budget / timeline / tracking) as your model. Then pick the strongest option by typing {{code:PICKED — }} at the start of that row's Scenario cell in capitals, exactly as you did for the fundraiser table, and extend that row's Why to explain what makes it stronger than the other two.

Success criteria:

Your document has three tables in total: the three-tool comparison, the fundraiser model, and a new one for your own project
Each of your three project options passes the same-calculation test (you can describe what one row would look like)
One row in your project table starts with {{code:PICKED — }} in capitals
The Why for your pick explains what makes it stronger than the other two, not just that it "fits"

Teacher Notes

Students who picked a highly prose-based Something Real (a creative writing piece, a speech) may struggle to find three spreadsheet uses. Redirect them to counting dimensions of their project: time spent, costs, word counts per section, feedback responses. Remind them the fundraiser model shows three different questions for one project — they need to do the same.

+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.

Your Answer or Description of Your Work

Project URL This can be a link to your project (e.g. a Scratch, Microbit, Arcade or CodePen URL link).

Upload File

You must be logged into Scratch to share your project, otherwise the link will not work.

To get the URL link of your Scratch project:

Make sure you're logged into Scratch.
Click on the Share button in the project editor.
Click on the Copy Link button.
Click on the Copy Link link. This will save the URL of your project page into your clipboard.

To get the URL link of your Microbit project:

Click on the button in the project editor.
Click on the Publish Project button.
Click on the Copy button. This will save the URL of your project page into your clipboard.

To get the URL link of your Arcade project:

Click on the button in the project editor.
Click on the Publish Project button.
Click on the Copy button. This will save the URL of your project page into your clipboard.

To get the URL link of your CodePen project:

Make sure you're logged into CodePen.
Open your project in the editor.
Click on the Save button at the top of the editor.
Copy the link from the address bar in your web browser (e.g. https://codepen.io/Jane-Smith/pen/gOVXxBQ)

What's a Spreadsheet for? Suitable Uses

Teacher Class Feed

1 - Introduction

Welcome

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

Warm-up

2 - Key Concepts

3 - Step-by-step Task

4 - Common Issues

Common Issues

5 - Independent Practice

Independent Practice

Unlock the Full Learning Experience

XP