VIEW THIS AS

Auto mode follows the Route Engine until you choose a viewpoint.

YOU ARE HERE

ROUTE CHECK

CONNECTED TO

WHAT NEXT

Use the canonical route for this room, or HELP if you are unsure.

SEAB MOE Syllabus Distinctions | Master Secondary 4 Computing SEC Exam Preparatory Curriculum

Three students in school uniforms work through open books at a classroom table, with textbooks and stationery nearby and study notes on the whiteboard behind them.

Secondary 4 Computing preparation begins with the correct subject level. The 2027 SEC has G3 Computing K349, G2 Computing K237 and G1 Computing K127. Their programming tools, practical tasks and examination weightings differ. Check the school’s actual entry before choosing books, software or outside support.

A useful preparatory curriculum helps a student explain a problem, build a working solution, test it and save the required files independently. Start with recent school work: is the difficulty understanding instructions, writing logic, using applications, explaining theory or finishing practical tasks? The answer should determine the next practice session.

  • Confirm the examination year, Computing level and syllabus code with the school.
  • Match preparation to Python and JupyterLab for G3, or the specified visual programming work for G2 and G1.
  • Prepare spreadsheets carefully; also check the media and document tasks relevant to the student’s route.
  • Diagnose one small task before assigning more practice: understanding, building, checking and saving are separate skills.
  • Use original examples, normal and boundary cases, and independent repeats to see whether understanding transfers.
  • Review progress with the teacher and confirm any proposed support’s actual subject coverage and software environment.

2027 SEC preparation · Parent guide. Source review: 21 November 2026. Begin with the student’s confirmed subject entry and the school’s current teaching plan.

Choose the reading route closest to your child’s needs. The examples and study plans are original preparation suggestions; the linked official syllabuses remain the assessment references. The related Mathematics video below introduces support for mathematical reasoning.

Related mathematical reasoning · eduKate Mathematics tuition introduction · Open video

Choose your next learning step

Full chapter index · Start with a diagnosis · Earlier Computing curriculum guide

Full chapter index

01 · Understand the route · Chapters 1–4
  1. Understand the SEC name and your child’s actual Computing route
  2. Compare the three assessment structures before planning revision
  3. Choose the correct tools and a useful preparation sequence
  4. Diagnose the difficulty with a small task and a short conversation
02 · Build the programming logic · Chapters 5–9
  1. Turn a wordy problem into inputs, rules and outputs
  2. Trace an algorithm before asking the computer to run it
  3. Make conditions precise and test both sides of a boundary
  4. Build repetition around a clear starting state and update
  5. Use G3 strings, dictionaries and functions with explicit assumptions
03 · Prepare visual and application work · Chapters 10–13
  1. For G1 and G2, make visual programs reliable across events
  2. For G2, distinguish list work, reusable blocks and microcontroller ideas
  3. For G1, treat document processing as a practical construction skill
  4. For media tasks, make the specification visible in the finished file
04 · Check data and systems · Chapters 14–18
  1. Build spreadsheet formulas that still work when inputs change
  2. Choose functions by the question and protect the meaning of data
  3. Read a data table before choosing a chart or writing a conclusion
  4. For G3, connect data representation and logic to exact meanings
  5. Explain networks, security and computing impacts through bounded scenarios
05 · Study and choose support · Chapters 19–23
  1. Prepare the practical workflow from opening the task to reopening the result
  2. Turn vague answers and random edits into specific corrections
  3. Build the year around independence, then use a manageable four-week cycle
  4. Answer the questions parents ask before choosing extra support
  5. Use the official sources and choose one calm next action

CHAPTER 1 OF 23 · Understand the route

1. Understand the SEC name and your child’s actual Computing route

Back to contents

The SEAB explanation of the Secondary Education Certificate places the SEC change in 2027. Parents comparing resources may therefore encounter older O-Level labels alongside new SEC codes. The useful question is whether a resource matches the student’s examination year, content and assessment. A familiar cover title is insufficient evidence.

SEAB’s current listings identify G3 Computing as K349 and mark G2 K237 and G1 K127 as new. This is a concrete reason for families to encounter unfamiliar Computing names. It does not establish how popular a subject is, or mean that every school offers every level.

Separate three different questions

First, what has the school registered or proposed for this student? Second, what work does that particular syllabus require? Third, what support would make the student more independent in that work? Answer them in that order. Starting with a fashionable programming course can leave the actual examination needs unresolved.

A Posting Group describes the admission arrangement and initial subject levels at the start of Secondary 1. It is different from a subject’s G1, G2 or G3 level. This distinction is explained in Bukit View Secondary School’s current Full Subject-Based Banding guidance. For a Secondary 4 decision, use the school’s current subject information.

Create a small subject record

Keep the code, examination year, teacher’s topic list, approved applications and latest marked work together. Add any file-naming instructions used in school practical sessions. This record can be a single page. Its purpose is to prevent assumptions from spreading between parent, student and a potential tutor.

If the school is discussing a change of level, ask which knowledge and practical habits would need bridging, when the decision must be made and what evidence informs it. A level name alone cannot show whether a particular learner will manage the new combination of tasks.

Contents · Next chapter

CHAPTER 2 OF 23 · Understand the route

2. Compare the three assessment structures before planning revision

Back to contents

The following details come from the 2027 SEAB PDFs: K349, pages 3–4, K237, pages 3–4 and K127, pages 3–4. Both papers and all questions are compulsory at each level.

RoutePaper 1Paper 2
G3 K349Written; 2 hours; 80 marks; 60%Lab-based; 2 hours 30 minutes; 70 marks; 40%
G2 K237e-Examination; 1 hour 30 minutes; 70 marks; 50%Lab-based; 2 hours 15 minutes; 80 marks; 50%
G1 K127e-Examination; 1 hour 15 minutes; 60 marks; 40%Lab-based; 2 hours; 90 marks; 60%
Compare the three assessment structures before planning revision

G3 Paper 2 contains one spreadsheet question and four to five programming questions. G2 has three practical tasks covering media, spreadsheets and programming. G1 has three covering media, document processing with spreadsheets, and programming. Saving the required work is included in the allotted practical time.

Original weighting example

Suppose a G3 learner scores 48/80 on a suitable written practice and 49/70 on a practical practice. The weighted result is (48 ÷ 80 × 60) + (49 ÷ 70 × 40) = 36 + 28 = 64 percentage points. Adding the raw marks and dividing by 150 would give a different figure because the components carry different weights.

This is a planning calculation, not a predicted SEC grade. It suggests examining the written responses closely while maintaining practical competence. A second learner with the same combined figure might have the opposite pattern and need a different plan.

Record paper-specific weaknesses as well as marks. “Cannot explain why a formula changes when copied” is more actionable than “weak theory”. “Completed the task but submitted the wrong file” identifies an operational gap. Neither is repaired automatically by doing longer programming exercises.

For timed preparation, use the school’s advice and current paper instructions. Since questions are compulsory, practise moving past a temporary blockage and returning with remaining time. Do not build a revision plan around permanently avoiding a topic.

Contents · Previous chapter · Next chapter

CHAPTER 3 OF 23 · Understand the route

3. Choose the correct tools and a useful preparation sequence

Back to contents

RouteImportant tool and scope distinctionsPreparation implication
G3Python and JupyterLab; spreadsheetsPractise reading, constructing and testing text-based programs alongside spreadsheet work.
G2Scratch; media and spreadsheets; MakeCode and microcontrollers are assessed in Paper 1 onlySeparate practical application work from understanding the microcontroller material.
G1Scratch; document processing, media and spreadsheetsInclude document construction and file handling in the preparation routine.
Choose the correct tools and a useful preparation sequence

These distinctions are specified in the G3 PDF, G2 PDF and G1 PDF. Ask the school which approved application versions it uses. The presence of spreadsheets in a syllabus does not establish that every commercial package or online substitute will behave identically in practice.

An original learning sequence

Begin with understanding inputs, outputs and instructions. Move to one working operation, then a condition, a repeatable process and a check of the result. Apply the same discipline to a formula, a visual program or a Python program. Finally, combine operations in a task with a clear deliverable.

This sequence is a preparatory suggestion. The school may teach topics in a different order. Align the current week with classroom needs, then revisit earlier ideas where the new work exposes a gap.

For a student who enjoys games, that interest can provide a context for explaining score changes and events. It does not prove that the student can build those mechanisms. For a student who enjoys designing slides, assess the ability to follow a specification and edit the underlying objects, not merely produce an attractive screenshot.

Before buying equipment or software, ask what access the school already provides and what can be practised in that environment. The immediate educational need may be a reliable way to rehearse saving files and checking formulas, rather than a more powerful device.

Contents · Previous chapter · Next chapter

CHAPTER 4 OF 23 · Understand the route

4. Diagnose the difficulty with a small task and a short conversation

Back to contents

A blank response can arise before any programming begins. The student may not understand the requested output, may recognise the idea but forget an application command, or may be afraid to produce an imperfect first attempt. Observe the point where progress stops before deciding what to teach.

An original four-part diagnostic

Use a fictional activity register containing three names and the number of sessions attended: Mei, 3; Arun, 5; and Lin, 0. Ask the student to explain the information in each row, calculate the total attendance, identify who attended at least three sessions and describe how the answer should update if Lin’s value changes to 4.

The initial total is 8 and two people meet the condition. After the change, the total is 12 and three meet it. The context requires little background knowledge, so the conversation can reveal whether the difficulty lies in the requirement, the calculation or the update.

What you observeLikely question to investigateNext small task
Cannot say what “at least” meansIs the language of the condition unclear?Classify 2, 3 and 4 manually.
Explains the rule but cannot build itIs a programming or application operation missing?Construct one condition with known values.
Gets the first answer but fails after the changeWas the result typed in rather than calculated?Change one input and inspect the dependency.
Works correctly but cannot retrieve the fileIs saving or locating the deliverable unreliable?Save, close and reopen one completed file.
Diagnose the difficulty with a small task and a short conversation

These are diagnostic possibilities, not labels for the learner. A single attempt may be affected by an unfamiliar interface or unclear instructions. Repeat a comparable task after clarifying the requirement and compare what the student can now do without prompting.

Finish by asking, “Which part did you understand, and where did you need help?” Keep the student’s explanation alongside the work. It gives the teacher more useful information than a general claim that the child is bad at Computing.

Contents · Previous chapter · Next chapter

CHAPTER 5 OF 23 · Build the programming logic

5. Turn a wordy problem into inputs, rules and outputs

Back to contents

A computer task becomes manageable when the student can describe the decision it must make. Writing code immediately can hide an incomplete understanding of the problem. Start with a few manual examples and make the rules visible.

Original equipment-loan example

A fictional club records how many equipment sets a member borrows. The permitted quantity is a whole number from 0 to 4. An input of 0 should display “None”; quantities from 1 to 4 should display “Recorded”; quantities outside the range should display “Invalid”. These are invented practice rules, not school policy.

The input is the quantity. The output is a label. The rule has two boundaries, 0 and 4. A student who talks about membership fees, opening hours or the colour of the equipment has introduced information the current task does not require.

Break the work into decisions

  1. Establish what form the input has: in this first exercise, it is already an integer.
  2. Decide whether the integer falls within the permitted range.
  3. For a valid value, distinguish zero from a positive quantity.
  4. Produce the exact output label requested.
  5. Test values around each boundary.

Now change one requirement: the club wants the number of unborrowed sets from a stock of four. A new numerical output, 4 minus the valid quantity, is needed. The student should identify the changed requirement before changing the implementation. Copying a previous answer without reconsidering the output is a common source of plausible but incomplete work.

A parent can help by asking for one accepted example and one rejected example. There is no need to supply the code. The learner’s explanation should be precise enough that another person can apply the same rule and obtain the same answer.

When a task is large, write a checklist of small outputs rather than a vague instruction to “finish the program”. A working first component can then be checked before the next component introduces more possibilities for error.

Contents · Previous chapter · Next chapter

CHAPTER 6 OF 23 · Build the programming logic

6. Trace an algorithm before asking the computer to run it

Back to contents

Tracing means following the instructions in their stated order and recording what changes. It is useful when a learner can repeat a definition but cannot explain why a program produced a particular result. A trace makes the reasoning inspectable.

Original total-and-count example

Take the fictional values 4, 0, 7, 2 and 7. We want the total of values that are at least 4, and how many values qualify. Start the total and the count at zero. Examine each value once. If it qualifies, add its value to the total and add one to the count.

Value examinedAt least 4?Total afterwardsCount afterwards
4Yes41
0No41
7Yes112
2No112
7Yes183
Trace an algorithm before asking the computer to run it

The final total is 18 and the count is 3. They answer different questions. Increasing the count by the current value would accidentally make it behave like a second total. Resetting the total to zero inside every repetition would discard earlier work.

Use a trace to locate the first difference

If a program returns 7 instead of 18, compare its variable values with the table. Do not change several lines at once. Find the first step where the observed state differs from the expected state, then inspect the instruction responsible for that change.

The same approach works with visual blocks. Record a score before an event, identify the block that changes it and record the score afterwards. Drawing attractive sprites does not remove the need to understand the sequence.

For independent checking, replace the values with 1, 4 and 5. The expected total is 9 and the count is 2. Ask the learner to predict both before running anything. A correct prediction supported by a trace is stronger evidence of understanding than a correct screen output obtained by repeated guessing.

Contents · Previous chapter · Next chapter

CHAPTER 7 OF 23 · Build the programming logic

7. Make conditions precise and test both sides of a boundary

Back to contents

A condition describes when something should happen. Small wording differences matter: “greater than four” excludes four, while “at least four” includes it. Translate the words into examples before choosing the comparison.

Original G3 Python example

This short program implements the equipment-loan rule. Its stated starting assumption is an integer input; accepting arbitrary typed text would require a separate input-handling step.

def loan_label(quantity):
    if quantity < 0 or quantity > 4:
        return "Invalid"
    elif quantity == 0:
        return "None"
    else:
        return "Recorded"

print(loan_label(4))

The displayed result is Recorded. The official Python control-flow tutorial explains the selection structure used here. The example itself is original and can be changed to explore the effect of each branch.

Test −1, 0, 1, 4 and 5. Their expected labels are Invalid, None, Recorded, Recorded and Invalid. This set examines values just outside and at the boundaries, alongside a normal accepted value. Testing only 2 would not expose an accidental rejection of 4.

Understand AND and OR through the requirement

An integer is valid when it is at least 0 and at most 4. It is invalid when it is below 0 or above 4. Using OR between the two valid-range tests would accept values outside the intended interval: 9 is at least 0, even though it exceeds 4.

For a visual programming learner, discuss the same accepted and rejected values using the blocks permitted in the school course. This is a comparison of reasoning, not a requirement for G1 or G2 students to learn Python.

Ask the student to explain why 0 follows a different valid branch from 1. If the answer is simply “because the code says so”, return to the original rule. The implementation should express a decision the learner understands, rather than become a pattern remembered without meaning.

Contents · Previous chapter · Next chapter

CHAPTER 8 OF 23 · Build the programming logic

8. Build repetition around a clear starting state and update

Back to contents

A loop should have a clear job. Before writing it, identify what is repeated, what information must be remembered and what should be true when the repetition ends. This prevents a learner from choosing a loop because its shape looks familiar.

Original G3 Python implementation

The program below implements the earlier total-and-count trace. Running it prints 18 3.

values = [4, 0, 7, 2, 7]
total = 0
count = 0

for value in values:
    if value >= 4:
        total = total + value
        count = count + 1

print(total, count)

The starting values appear before the loop so that each qualifying item contributes to the accumulated result. The condition sits inside the loop because every item needs its own decision. The final display sits after it because the task asks for the completed result.

Change one feature and predict the effect

If the print instruction moves inside the loop, intermediate results appear. If the condition changes from at least 4 to greater than 4, the value 4 no longer qualifies, leaving total 14 and count 2. If the list is empty, the loop processes no items and the starting values remain zero.

Those variations are useful because they reveal whether the student understands position, condition and starting state separately. They also give a teacher a way to adjust challenge without increasing the length of the exercise.

For a G3 learner using a numerical range, check the endpoint carefully. Python’s range documentation within the tutorial shows that the stopping value is excluded. A loop intended to process positions 0 through 4 must be checked against that convention.

For a visual game, the equivalent planning question may be whether an action repeats a fixed number of times or continues until a condition changes. Ask what stops the repetition and what changes inside it. A stop condition that can never become true is a logic problem, even when every block connects neatly.

Contents · Previous chapter · Next chapter

CHAPTER 9 OF 23 · Build the programming logic

9. Use G3 strings, dictionaries and functions with explicit assumptions

Back to contents

A longer program becomes easier to reason about when a small function has a clear input and one clear responsibility. The function should be understandable without relying on unexplained values left elsewhere in the program.

Original code-frequency example

Suppose a fictional log contains comma-separated equipment codes. The practice specification says codes contain no spaces, letter case matters, and empty fields should be ignored. Count how many times each non-empty code occurs.

def count_codes(line):
    counts = {}
    for item in line.split(","):
        if item != "":
            if item in counts:
                counts[item] = counts[item] + 1
            else:
                counts[item] = 1
    return counts

print(count_codes("A2,B1,A2,,B1,C3"))

The result is a dictionary containing A2: 2, B1: 2 and C3: 1. The first encounter with a code creates its count; later encounters increase it. The Python documentation for built-in types is a reference for strings and dictionaries. The important reasoning here is why the two cases are different.

Test an empty line, a single code and repeated codes. The corresponding results for an empty string, A2, and A2,A2 are an empty dictionary, A2: 1, and A2: 2. Also ask what would happen to a2. Under the stated rule, it is a different code from A2.

Do not hide a changed requirement

If the real task says blank fields indicate missing information, silently ignoring them would be wrong. If case should not matter, the program needs a consistent conversion rule. A useful solution follows the specified meaning of the data; it does not treat every inconvenient value in the same way.

For file-based work, distinguish the file’s contents from the filename and from the program’s variables. A correct function cannot compensate for reading the wrong file. The official Python input and output guide provides the relevant file-handling reference; practise with small invented files that can be checked manually.

Ask the learner to explain what is returned and what is printed. A function that computes the right value but does not pass it to the rest of the program may still fail the larger task. This is a productive point for targeted feedback.

Contents · Previous chapter · Next chapter

CHAPTER 10 OF 23 · Prepare visual and application work

10. For G1 and G2, make visual programs reliable across events

Back to contents

A visual program needs the same attention to state and sequence as a text-based program. The absence of typed punctuation does not remove the need to decide when something starts, which object receives an event and how values change.

Original collecting-game specification

Design a small practice game with a player and a token. At the start, the score is zero and both objects have known positions. When the player touches the token, the score increases once. The next increase should occur only after the player has stopped touching the token and then touches it again.

A common first attempt places “if touching, change score by one” inside continuous repetition. The score can then increase repeatedly during one sustained contact. The problem is not necessarily that the computer is too fast. The instructions allow more than one increase for the same contact.

Reason through the event

A possible correction is to wait for contact, increase the score once, then wait until contact ends before allowing another increase. Describe this sequence in words first. Recreate it with the blocks and conventions taught in school, then test it through deliberate actions.

  • Start a new run: the score should return to zero.
  • Touch once and remain in contact: the score should increase once.
  • Move away and touch again: the score should increase once more.
  • Restart after several points: the old score should not survive unintentionally.

These checks are original practice suggestions. They are not an official examination task. They make a behaviour visible enough for a parent to discuss without taking over the block construction.

When several sprites respond to events, ask which sprite owns each script and which event begins it. Duplicating a score-changing script in two places can create an unexpected double update. Keep the first version small before adding sound, costumes or extra objects.

The Scratch Foundation learning library offers general activities and coding resources. Select material that supports the student’s present school task; completing a large unrelated game is not automatically more useful than understanding a small unreliable one.

Contents · Previous chapter · Next chapter

CHAPTER 11 OF 23 · Prepare visual and application work

11. For G2, distinguish list work, reusable blocks and microcontroller ideas

Back to contents

The K237 specification includes list or array operations, custom blocks and microcontroller learning. Its examinable-block tables identify Scratch for Papers 1 and 2, and MakeCode for Paper 1 only. Keep that assessment boundary clear when allocating revision time.

Original list reasoning

Imagine a fictional waiting list containing three names: Jo, Sal and Min. A new name joins the end; the first name is then removed because that person has been served. The learner should predict both the contents and the order of the updated list.

If Kai joins first, the list becomes Jo, Sal, Min, Kai. Removing the first entry leaves Sal, Min, Kai. Removing the last entry instead would undo the arrival of Kai. This tiny example reveals whether the learner distinguishes the position of an item from its value.

Use the indexing convention of the environment being taught. A parent comparing a Scratch list with a Python example should not assume that the displayed position numbers are interchangeable. Ask the student to demonstrate how the first and last items are addressed in the actual tool.

Original sensor decision

Consider an invented brightness reading. The rule says a display should show a warning when the reading is below 30. Test readings 29, 30 and 31 manually: only 29 should trigger the warning. Then ask what input is being measured, what decision is made and what output responds.

This is a reasoning exercise, not an instruction to wire unfamiliar hardware at home. Use school-approved equipment and teacher guidance for physical work. A written explanation can still be practised with a supplied table of fictional readings.

Reusable blocks are helpful when one clearly named operation appears in several places. Ask what that operation promises to do and what information it needs. A name such as “reset round” should correspond to a deliberate reset of the relevant state, rather than conceal unrelated changes that become difficult to trace.

Contents · Previous chapter · Next chapter

CHAPTER 12 OF 23 · Prepare visual and application work

12. For G1, treat document processing as a practical construction skill

Back to contents

A document task can look easy because a student has typed many school assignments. The real test is whether the student can create the required structure and make controlled changes without disturbing the rest of the document.

Original two-page notice

Prepare an invented club notice with a title, two short paragraphs, an event table and an image. The second page contains a wide timetable. The practice requirements specify consistent headings, a page number and a landscape second page while the first page remains portrait.

Before clicking through menus, identify which requirements affect text, which affect an object and which affect a page or section. Treating all changes as character formatting can lead to repeated spaces, blank lines and manual positioning that collapse when the content changes.

Check the structure by editing it

Add one sentence to the opening paragraph. Does the next heading move naturally? Replace the image with a different-sized image. Does the text remain readable? Change the page count. Are the page numbers still generated correctly? A document that survives these small edits provides better evidence than a single attractive print preview.

For the landscape page, ask the learner to explain why a section-level layout change is needed. For aligned information, ask what creates the alignment. Several typed spaces may appear adequate on one line but behave unpredictably after a font or text change.

Keep a short checklist tied to the specification: content present, layout correct, image suitable, numbering correct, file saved in the requested format. Check those points before spending time on decorative choices.

If the student is slow, identify the specific operation causing delay. They may need three repetitions of inserting and managing a section break, rather than another full document assignment. A parent can read the requirements aloud and ask the student to point to the corresponding feature, while leaving the actual editing to the learner.

Contents · Previous chapter · Next chapter

CHAPTER 13 OF 23 · Prepare visual and application work

13. For media tasks, make the specification visible in the finished file

Back to contents

Media work combines technical operations with communication. A student may know how to move an image but still produce a file that misses the requested dimensions, hides important text or loses editable elements. Start from the deliverable and check it systematically.

Original image-sizing example

An invented source image is 600 pixels wide and 400 pixels high. Its width-to-height ratio is 3:2. Resizing it proportionally to a width of 900 pixels gives a height of 600 pixels. Changing it to 900 by 400 stretches the proportions instead.

Ask the student to distinguish resizing from cropping. Resizing changes the dimensions of the whole image; cropping removes part of its visible area. If a portrait must fit a narrow space, stretching the face is not a satisfactory substitute for choosing an appropriate crop.

Original vector-editing check

Create a simple emblem from a circle, two overlapping shapes and a short label. Ask the learner to select a shape behind another, change its fill, group related objects and then edit one component. The point is control over the structure, not artistic complexity.

Keep the editable source file as well as any requested export. A flattened image can look correct while no longer allowing the same object-level edits. Confirm the format required by the task rather than assuming that a screenshot is an acceptable replacement.

Original short-video plan

For a practice announcement, plan three scenes: the activity, the time and the instruction to the viewer. Give each scene a purpose before adding transitions. Check that text remains readable for its displayed duration and that sound supports the message.

Review the exported video from beginning to end. A working project preview does not demonstrate that the exported file contains the intended sequence. Check the start, final frame, sound and any missing images.

Parents can ask the student to show where each requirement is satisfied. “Which part proves you followed this instruction?” is a more helpful question than “Can you make it look more professional?” It keeps practice focused on decisions the learner can explain and repeat.

Contents · Previous chapter · Next chapter

CHAPTER 14 OF 23 · Check data and systems

14. Build spreadsheet formulas that still work when inputs change

Back to contents

A spreadsheet is useful when its results depend correctly on its inputs. A learner who types the right total into a cell may produce a convincing first display while missing the central task: constructing a calculation that updates.

Original equipment-cost model

In a fictional worksheet, cell B2 contains quantity 6, B3 contains quantity 10, and F1 contains a unit cost of 1.50. Put =B2*$F$1 in C2 and copy it to C3. The results should be 9.00 and 15.00.

The quantity reference changes from B2 to B3 as the formula moves down. The reference to F1 remains fixed. Microsoft’s guide to relative and absolute references explains these reference types; the dollar signs control copying, not whether a number is currency.

Change F1 to 2.00. The results should become 12.00 and 20.00 without retyping either formula. If only the first result changes, inspect the copied reference. If neither changes, check whether the results were entered as values.

Extend the model carefully

For a G3 mixed-reference exercise, place quantities down column A and different unit costs across row 1. A formula such as =$A2*B$1 keeps the quantity column and cost row fixed while allowing the other coordinate to change. Copied from B2 to C3, it becomes =$A3*C$1.

Before filling an entire table, predict one copied formula and inspect it. A single mistaken reference can produce a whole grid of plausible values. Testing the first row alone may not expose the error.

Distinguish the stored number from its display. A percentage format and a currency format communicate different meanings. Formatting cannot repair a wrong formula, and an attractive table cannot establish that the result is correct.

A parent can ask for a controlled change: double one quantity, alter the shared rate or set a quantity to zero. The student should predict which results change and which stay the same. This checks understanding without requiring the parent to memorise spreadsheet commands.

Contents · Previous chapter · Next chapter

CHAPTER 15 OF 23 · Check data and systems

15. Choose functions by the question and protect the meaning of data

Back to contents

A function name is useful only when the student understands the question it answers. Counting records, adding quantities and retrieving a value from a table are different operations. Begin with the answer expected from a tiny dataset.

Original exact-lookup example

Imagine A2:B4 contains three fictional item-code and cost pairs: 101 and 2.50; 205 and 1.80; 309 and 0.60. Cell D2 contains the requested code 205. The formula =VLOOKUP(D2,$A$2:$B$4,2,FALSE) returns 1.80.

The requested code is searched in the first column of the specified range, and the answer comes from its second column. FALSE requests an exact match. The official Microsoft VLOOKUP reference explains the distinction between exact and approximate matching.

Test code 999, which is absent. An exact lookup should not silently substitute another item’s cost. An error or an explicitly designed “not found” response tells the user something important about the data. Hiding the problem with an arbitrary zero can make a later total look valid when it is incomplete.

Original count and total comparison

Suppose B2:B5 contains 3, 0, 4 and 2. The sum is 9. The number of numeric entries is 4. The number of entries greater than zero is 3. Ask which answer is required before selecting SUM, COUNT or COUNTIF. An empty cell and a cell containing zero also need to be interpreted according to the task.

For a permitted whole-number quantity from 0 to 4, input validation should reject 5 and −1. But validation cannot prove that an accepted value is true: a user can enter 3 when the real quantity is 2. This distinction helps the student explain the benefit and limit of a check.

Match the chosen function to the actual level’s permitted work. Do not replace a method specified by the school with a newer function simply because an online tutorial recommends it. The objective is an explainable solution within the required task and application environment.

Contents · Previous chapter · Next chapter

CHAPTER 16 OF 23 · Check data and systems

16. Read a data table before choosing a chart or writing a conclusion

Back to contents

Data presentation should make the relevant comparison easier to understand. Begin by identifying what one row represents, what each column measures and whether the values are counts, categories, dates or another quantity.

Original attendance dataset

A fictional activity has attendance counts of 12, 18, 15 and 25 on four successive days. The total is 70 and the mean is 17.5. The largest value is on the fourth day, but the sequence does not increase at every step: it falls from 18 to 15 before rising to 25.

That last observation matters. A broad sentence such as “attendance increased steadily” would misdescribe the data. A more accurate statement is that the final day had higher attendance than the first, with a decrease between the second and third days.

Make the graph answer a question

If the purpose is to compare daily counts, label the days and the number of attendees clearly. If a task requires a particular chart type, follow the instruction and check that the selected cell range contains the intended data. A chart generated from the wrong range can still look polished.

Now change the fourth count from 25 to 20. The total becomes 65 and the mean becomes 16.25. Check both the calculated cells and the chart. If the graph does not respond, inspect its data source instead of manually adjusting the picture.

Before interpreting an extreme value, inspect the entry. A mistyped 250 in place of 25 changes the apparent scale and the summary. The student should query the source rather than quietly change an unusual value merely because it looks inconvenient.

Separate observation from explanation

The data show attendance; they do not establish why people came. A statement that a publicity campaign caused the final increase needs evidence about the campaign and other influences. In a computing answer, a careful description can be more defensible than a confident invented story.

For parent review, ask the learner to point to the cells supporting each sentence. This simple habit links written explanation to evidence and exposes conclusions that have drifted beyond the dataset.

Contents · Previous chapter · Next chapter

CHAPTER 17 OF 23 · Check data and systems

17. For G3, connect data representation and logic to exact meanings

Back to contents

Representation questions are easier to check when the student names the convention first. The same sequence of bits can mean different things under different rules. An answer should identify whether it is treating the value as unsigned, signed or another representation.

Original number conversion

The denary number 45 is 32 + 8 + 4 + 1, so its unsigned binary form is 101101. Written in eight bits it is 00101101. Grouping those eight bits into 0010 and 1101 gives hexadecimal 2D. Each conversion describes the same value.

For an eight-bit two’s complement example, start with positive 13 as 00001101. Invert the bits to obtain 11110010, then add one to obtain 11110011, representing −13. Check it using the signed place values: −128 + 64 + 32 + 16 + 2 + 1 = −13.

The bit width matters. Do not remove leading bits from a signed representation casually. Ask which width the question specifies before applying a remembered conversion procedure.

Original logical rule

For a fictional equipment cabinet, let A mean “permission is present” and B mean “maintenance lock is active”. The cabinet may open when A is true and B is false. The expression is A AND NOT B.

ABA AND NOT B
FalseFalseFalse
FalseTrueFalse
TrueFalseTrue
TrueTrueFalse
For G3, connect data representation and logic to exact meanings

Explain each row in the cabinet context. If the student changes AND to OR, ask whether the cabinet could then open without permission. The concrete consequence helps reveal the logical error.

For storage calculations, preserve unit names. Two kibibytes equal 2,048 bytes, while two kilobytes equal 2,000 bytes. At eight bits per byte, 2,048 bytes contain 16,384 bits. A correct numerical method using the wrong unit convention can still answer the wrong question.

These are original G3 practice examples. Parents supporting another route should follow its actual topic list rather than assume that every extension here is required.

Contents · Previous chapter · Next chapter

CHAPTER 18 OF 23 · Check data and systems

18. Explain networks, security and computing impacts through bounded scenarios

Back to contents

Technical vocabulary is more useful when a student can apply it to a particular situation. “The internet is not working” may describe a problem with a device, a local connection, an external service or the route between them. A good explanation keeps those possibilities separate.

Original connection scenario

Suppose two school computers can still exchange a file over their local network, but neither can reach an external website. This evidence shows that at least some local communication is functioning. It does not by itself prove which device or service has failed outside that connection.

Ask the learner what additional observation would help distinguish possibilities. Checking whether another permitted external service is reachable gives different information from repeatedly opening the same page. The exercise is about interpreting evidence, not changing school network settings.

Original privacy and recovery scenario

A fictional club saves a membership file in a shared folder. One concern is that an unauthorised person can read it. Another is that the only copy might be accidentally deleted. Restricting access addresses the first concern; a suitable recoverable backup addresses the second. One measure does not automatically solve both problems.

In a written answer, name the risk, the proposed measure and why it helps. Avoid a list of security terms with no connection to the situation. If a message unexpectedly asks for a password, a sensible practice response is to verify through the organisation’s known channel rather than trust the message’s own link.

Original technology-impact comparison

A fictional booking system can reduce repeated manual entry, yet an incorrect stored capacity can cause the same mistake to affect many bookings. Ask who benefits, who may be inconvenienced and what a human should check. The strongest discussion explains both the useful function and the consequence of an error.

Use invented data for practice. There is no need to place real classmates’ details into a demonstration application. A learner can reason about consent, access and purpose with a fictional dataset, without exposing information belonging to someone else.

Keep all security practice defensive and authorised. The educational goal is to recognise risks and explain proportionate controls, not to test another person’s accounts or devices.

Contents · Previous chapter · Next chapter

CHAPTER 19 OF 23 · Study and choose support

19. Prepare the practical workflow from opening the task to reopening the result

Back to contents

Practical competence includes finding the right source file, interpreting the task, completing changes, checking the result and saving the required deliverable. Practise this complete sequence, because a correct unsaved result cannot demonstrate the same independence as a correct retrievable file.

Use a realistic practice folder

Create a folder containing only the invented source materials needed for one task. Give the student the intended output names and formats. Let them work without a parent arranging the windows, selecting the files or completing the final save.

At the end, close the application and reopen the saved output. Inspect the actual file, not a screenshot taken before saving. Check that formulas remain formulas, that editable objects remain available when required and that a program runs from its intended starting state.

G3 notebook habits

JupyterLab supports notebooks containing runnable code and outputs, as described in its official notebook guide. For practice, keep code in a sensible order and understand which earlier cells establish values used later.

A student can accidentally depend on a value created during an earlier attempt but absent from the saved solution. A supervised practice check from a fresh kernel, followed by execution in the intended order, can expose that dependence. Preserve work and follow the teacher’s procedure; do not experiment with unfamiliar reset commands during an examination.

Reserve attention for delivery

In a practice session, note how long checking and saving actually take. Build that observed need into the next attempt. There is no universal minute allocation that suits every task, device and learner.

If something goes wrong, practise stating the problem clearly: which file, which action, what happened and what was expected. During a formal examination, follow the invigilator’s instructions and the stated procedure for technical problems. Do not improvise unauthorised assistance or transfer methods.

Use the school’s current arrangements as the reference for the environment. The three syllabuses have different paper formats; a home exercise should prepare the relevant habits without pretending to reproduce every examination control.

Contents · Previous chapter · Next chapter

CHAPTER 20 OF 23 · Study and choose support

20. Turn vague answers and random edits into specific corrections

Back to contents

A useful explanation connects a feature to its effect in the given situation. A useful debugging action tests a reason for failure. Both improve when the student names the evidence rather than relying on general phrases.

Weak response or habitMore useful correction
“The spreadsheet is wrong.”“The copied formula refers to F2, but the shared rate is in F1.”
“The program does not work.”“Input 4 is rejected although the rule allows 0 through 4.”
“Use a backup for privacy.”“A backup supports recovery; access controls address who can read the file.”
“The chart proves the event was successful.”“The chart shows the recorded attendance; success needs a stated criterion.”
Change several instructions togetherLocate the first unexpected state and test one reason for it.
Turn vague answers and random edits into specific corrections

Separate three programming questions

Does the code have a form the language accepts? Can it execute with the supplied data? Does its behaviour meet the requirement? These are different checks. A program may run without an error message and still calculate the wrong answer.

For example, replacing a running total with the current item can leave the final item as the output. Nothing about that instruction necessarily prevents execution. The problem is that its meaning differs from the intended accumulation.

Make an error record worth rereading

For each recurring error, keep the smallest example that exposes it, the corrected principle and one new test. Avoid collecting pages of copied answers. A two-line note explaining why the threshold includes its endpoint can be more useful than a long solution the student cannot reconstruct.

When answering theory, underline the command and the relevant context. A request to compare needs a common basis; a request to explain needs a reason. If the question describes a particular user’s need, connect the answer to that need rather than list every remembered advantage.

Parents should look for increasing precision: the student can now name the problem, propose a targeted correction and show evidence that it worked. Speed can then be developed through repetition of understood tasks.

Contents · Previous chapter · Next chapter

CHAPTER 21 OF 23 · Study and choose support

21. Build the year around independence, then use a manageable four-week cycle

Back to contents

Plan around the school’s sequence and assessment dates. In an early phase, repair essential concepts and application operations. As the course develops, combine them in complete tasks. Closer to assessment, use suitable timed work to practise decisions and delivery under pressure. These are suggested preparation phases, not a claim about every school’s calendar.

Maintain two strands each week: explaining ideas and producing working files. The balance should respond to the learner’s evidence and the weighting of the actual route. It should not be determined solely by the activity the student already enjoys most.

An original four-week repair cycle

WeekFocusVisible evidence
1Confirm the route; use one short diagnostic; identify a precise gap.A correct explanation of one task and a record of where help was needed.
2Repair that gap using small variations.Three independently completed variations, including a boundary or changed input.
3Combine the repaired skill with an already secure skill.A working saved file and a small test record.
4Attempt a comparable task with less prompting and suitable time limits.A reopened deliverable, an explanation and a comparison with Week 1.
Build the year around independence, then use a manageable four-week cycle

One possible starting routine is two short focused sessions and one longer integrated session each week. Adjust this to homework, school access and other subjects. The measure of usefulness is what the student can now do, not how many hours appear on a timetable.

Use delayed and changed tasks

Immediate repetition can be completed from memory of the demonstration. Return several days later with different values or a changed context. Ask the student to explain the rule before beginning. This provides better evidence of independent understanding.

For G1, the integrated task might combine a document with an embedded chart. For G2, it might join a small media deliverable with a data task, while checking programming separately. For G3, it might connect a clearly specified program with a spreadsheet check of its expected totals. Keep each task within the school’s current learning scope.

At the end of the cycle, choose the next gap from evidence. If the original difficulty remains, change the explanation or reduce the task size. Repeating the same unsuccessful session with more urgency is unlikely to reveal what the learner has not yet understood.

Contents · Previous chapter · Next chapter

CHAPTER 22 OF 23 · Study and choose support

22. Answer the questions parents ask before choosing extra support

Back to contents

Does being good with devices mean Computing will be easy?

Comfort with devices is useful, but it does not show whether a student can interpret a specification, construct a formula, explain a condition or test a program. Ask for one small independent task. The result gives a more reliable starting point than time spent on a phone or game.

Should every Computing student study Python?

Match the language to the route. The earlier comparison identifies the relevant 2027 tools. A separate interest in Python can be worthwhile, but it should not displace the visual programming, application or document work actually required by the student’s course.

Are past papers enough?

Use papers that match the current specification, with teacher guidance. Earlier materials can contain useful practice, but their title does not prove complete alignment. For a newly introduced route, consult the current SEAB listing and the school’s selected specimen materials rather than assuming a long history of identical papers exists.

What should I ask a tuition provider?

Ask which code and year it supports, which applications it teaches, how it diagnoses gaps and whether the learner completes practical work independently. Request a concrete explanation of feedback and file-based practice. Confirm actual availability directly; this guide does not establish that eduKate provides a class for every Computing route.

Can an AI tool help with revision?

Follow the school’s rules for each task. In permitted practice, ask the student to inspect any suggested solution, explain its steps and test it with changed data. A generated answer that the learner cannot reconstruct is poor evidence of readiness. Do not use external assistance in controlled work unless expressly permitted.

How can I help without knowing the software?

Ask what the task requires, what result is expected and how the student checked it. Let the student operate the computer. Read the requirements back at the end and ask where each is satisfied. If help is needed, record the sticking point for the teacher.

Does this subject guarantee a particular post-secondary course?

No single subject choice establishes eligibility for every course. Check the actual combination and current course requirements with the school counsellor. MOE’s 2026 announcements introduce the Post-Secondary Admissions Exercise for 2028. Consult the current official details for the relevant application year.

What would meaningful improvement look like?

The student needs fewer prompts, predicts results more accurately, finds a fault with a reason and produces a file that works when reopened. Keep those observations alongside marks. They show which habits are becoming dependable and which still need focused teaching.

Contents · Previous chapter · Next chapter

CHAPTER 23 OF 23 · Study and choose support

23. Use the official sources and choose one calm next action

Back to contents

Source review: 21 November 2026. Use the following primary references for current subject details, and recheck the school’s instructions before buying materials or changing a preparation plan.

The worked examples and suggested study sequence in this article are original teaching material. They are not official examination questions, a school’s mandatory order or a prediction of grades.

For related preparation, the Secondary 4 English Language guide can support reading and explanation, while the Secondary 4 Mathematics guide develops numerical reasoning. Use those links where they address an observed need.

Begin with one recent Computing task. Confirm its route, ask the student to explain the requirement and watch one independent attempt. Take the smallest unresolved step to the teacher. A clear next question is a useful start to a more dependable preparation plan.

Contents · Previous chapter · Continue with related reading