Spreadsheets

1. Learning goals

• Explain the important concepts in your own words.
• Recognise the tools, controls and vocabulary used in real computer work.
• Perform the skill carefully rather than memorising a single sequence of clicks.
• Choose safe, efficient actions and know when to ask for help.

2. The big idea

Work confidently with spreadsheet structure, data entry, formulas, functions, references, formatting, sorting, filtering, charts and practical budgets. A strong computer user does not simply remember buttons. They understand what the computer is doing, what result an action should produce, and how to recover when the result is unexpected.

Throughout this topic, separate what you see from what the computer is storing or doing. A window, icon, file name or message is an interface representation. The underlying data, process, device or connection is the thing being represented.

3. Core knowledge

Terminology

Learn the words used by operating systems and software. Knowing the vocabulary makes instructions, help pages and error messages much easier to understand. When a term is unfamiliar, look for its meaning before changing an important setting.

Cause and effect

Most computer actions have a predictable relationship between input and result. Selecting an item before using a command matters. Choosing the correct destination matters. Permissions, available storage, network connection and application state can all affect the outcome.

Accuracy before speed

Speed is useful only after the process is reliable. Build the habit of checking the selected item, destination, account and final result before confirming a consequential action.

4. Step-by-step working method

1. Identify the goal. State exactly what you want to accomplish.
2. Inspect the starting state. Check the device, application, selected item, connection and available space when relevant.
3. Choose the appropriate command. Prefer built-in controls and trusted software.
4. Perform one meaningful action at a time. This makes mistakes easier to detect.
5. Verify the result. Open, inspect, test or otherwise confirm that the intended result occurred.
6. Record important details. For recurring work, note names, locations, dates, settings or error messages.

5. Practical examples

Example A — Everyday work: You receive a task and need to produce a file. First identify the required format and destination. Create or open the correct application, work on the content, save using a meaningful name, then reopen or inspect the saved file to verify it.

Example B — Something goes wrong: Do not immediately make many changes. Capture the exact message, note what you were doing, check whether the problem is repeatable, and test the simplest safe explanation first.

Example C — Shared computer: Avoid leaving private documents, passwords or accounts open. Sign out where appropriate and do not install software merely because a pop-up asks you to.

6. Important details to remember

• Many commands have keyboard and mouse alternatives. Learn both where practical.
• Menus and labels can vary by software version, but the underlying concepts are usually similar.
• Saving is different from merely seeing a change on screen.
• Deleting is different from securely destroying information; deleted items may remain recoverable.
• A warning message is information. Read it before clicking a button.
• When working with important data, keep a backup before making risky changes.

7. Common mistakes and how to avoid them

• Doing an action without checking what is selected.
• Using vague file names such as newfile or document1 for important work.
• Ignoring updates, warnings or storage limits until a failure occurs.
• Assuming that a device is broken when the real issue is a cable, setting, permission or network connection.
• Changing several settings at once, making the original cause difficult to identify.

8. Skill drill

Practise this lesson in short cycles: attempt → check → correct → repeat. Do the task once slowly, once normally, and once without looking at instructions. If the app provides an interactive practice activity for this topic, complete it before the test.

9. Self-check

Before taking the test, answer these questions aloud or in your notes:

1. What is the purpose of this skill?
2. What can go wrong?
3. How can I verify success?
4. What should I avoid when handling important information?
5. How would I explain this skill to a complete beginner?

10. Summary

Mastery means understanding the purpose of the tools, using them deliberately, verifying results and recovering safely from mistakes. These habits are more valuable than memorising a particular screen layout because software changes over time.

Mastery test

You need 80% or higher. If you do not pass, review this lesson, practise again and retake the test.

Spreadsheet deep dive

A spreadsheet is organised into rows and columns. A cell is identified by a reference such as B4. A formula normally begins with =. Examples include =B2+C2, =SUM(B2:B10), =AVERAGE(C2:C10) and =IF(D2>=50,"Pass","Review").

Relative references change when formulas are copied; absolute references such as $B$2 remain fixed. Mixed references can lock only a row or column. Learn this before building larger models.

Formatting should communicate meaning, not hide errors. Use appropriate number formats for currency, dates and percentages. Sort and filter only after understanding whether the operation affects the whole dataset. Charts should answer a clear question and have readable labels.

Practical examples include a household budget, attendance register, inventory list, sales tracker and simple grade sheet. Keep raw data separate from calculations where possible.