This Top 100 Secondary 4 G2 Vocabulary List for Punggol helps students understand the language of Computing: the words behind a spreadsheet formula, a network explanation, a graphic-editing instruction and a visual program. Each term has a plain meaning and an original example so that students can move from recognising a word to using it correctly in a task.
Start with the mistake that is happening now. If a copied formula changes the wrong reference, learn relative and absolute together. If a game starts with yesterday’s score, work on initialisation. Parents can help by asking what the computer should do, what it actually did and which instruction explains the difference. This is a curated eduKate teaching selection, not an official SEAB vocabulary list, frequency ranking or prediction of examination questions.
- Reader: Secondary 4 students taking G2 Computing and parents supporting their learning in Punggol.
- Scope: the 2027 SEC G2 Computing syllabus, K237; confirm the examination year and subject code with school.
- Contents: 100 terms, common confusions, original worked examples, practice and explained answers.
- Learning method: explain the word, perform its action, change one condition and check the result.
- Practical focus: spreadsheets, media work and visual programming, supported by computer, network and responsible-use concepts.
- Parent’s next step: use one recent piece of work to locate a precise learning need before choosing extra practice or support.
Choose your reading route
Start with the task you need today, then return to the full guide when you are ready.
- Understand the scope — Check the subject, syllabus year and starting point.
- Learn the 100 terms — Use the numbered lists, meanings and original examples.
- See the words in use — Follow explanations and original worked examples.
- Practise and check — Try the questions before reading the explained answers.
- Plan the next lesson — Use the revision routine and parent guidance.
Article contents
Chapters 1–7
- Check the subject before choosing the words
- Find the decision hidden inside the word
- Words 1–10: components, data and processing
- Words 11–20: networks and communication
- Words 21–30: files, risks and responsible use
- Words 31–40: spreadsheet foundations
- Words 41–50: conditions and spreadsheet functions
Chapters 8–14
- Words 51–60: organising data and starting graphics
- Words 61–70: visual editing and communication
- Words 71–80: planning and program state
- Words 81–90: repetition, lists and debugging
- Words 91–100: game objects and physical prototypes
- Worked example: a formula should survive a changed input
- Worked example: trace the state before changing the blocks
Chapters 15–21
- Worked example: describe the edit before selecting the tool
- Turn vocabulary into an explanation that answers the question
- Twelve short checks, with explained answers
- A revision routine that produces visible evidence
- What parents in Punggol can ask before arranging support
- Questions students and parents often ask
- Sources and how to use this guide
Checked on 16 November 2026. The SEAB 2027 G2 directory lists Computing as K237, with its first examination in 2027. G2 identifies the subject level. A legacy 2026 paper or a G3 Computing resource should not be assumed to have the same requirements.
The K237 syllabus covers computer fundamentals, networking, impact of computing, spreadsheets, media software and programming. Paper 1 is a 90-minute e-examination worth 50%; Paper 2 is a 135-minute lab examination worth 50%. All questions are compulsory. The practical paper covers spreadsheet, media and programming tasks. Microcontrollers and MakeCode blocks are assessed in Paper 1 only; the block appendix identifies Scratch for Papers 1 and 2. Follow the school’s approved software and assessment instructions.
The list below selects useful words from those learning areas and their everyday teaching explanations. It does not replace the full syllabus, the school’s scheme of work or supervised practical experience. You can read the Punggol G2 Computing syllabus guide alongside this article when you need the wider subject overview.
A student can repeat a definition accurately and still make the wrong choice on screen. For example, saying that a reference is “fixed” does not show whether the student knows what will happen when a formula is copied down three rows. The useful check is to predict the new formula, copy it and compare the result with the prediction.
Separate three kinds of difficulty. A meaning difficulty occurs when the student cannot distinguish a formula from a function. An action difficulty occurs when the distinction is understood but the student cannot construct the required expression. A checking difficulty occurs when the expression is entered but its result is accepted without testing. These need different kinds of practice.
Use a four-part note for a troublesome term: “It means…”, “I use it when…”, “It is easily confused with…”, and “I check it by…”. For filtering, the checking sentence could be: “I remove the filter to confirm that the other records still exist.” That final sentence gives the learner something observable, not another definition to memorise.
The tables are arranged in small groups to make these comparisons easier. The numbering is for navigation, not a claim that term 1 is more important than term 100. A student with a working vocabulary can start at the relevant group. A student who is unsure where to begin can try the diagnostic questions later in the article and return to the words exposed by their answers.
These words describe different jobs inside a computer system. When explaining a choice, connect the component to the task. A storage capacity answers how much can be retained; it does not, by itself, answer how quickly a calculation runs. Use an actual familiar task, such as recording speech or opening a saved presentation, to separate input, processing, storage and output.
| No. | Term | Plain meaning | Use it accurately |
|---|---|---|---|
| 1 | Central processing unit (CPU) | The component that executes general program instructions and coordinates much of the computer’s processing. | A larger storage drive does not automatically make the CPU execute instructions faster; compare the component relevant to the task. |
| 2 | Graphics processing unit (GPU) | A processor designed to handle graphics and other suitable workloads involving many parallel calculations. | A student editing a visual project should distinguish graphics capability from the capacity available for storing the finished file. |
| 3 | Main memory | Working space holding data and instructions needed by programs currently running; RAM is the usual example. | An unsaved change held in working memory is not a dependable substitute for saving the project to storage. |
| 4 | Secondary storage | Storage used to retain programs and files beyond the current working session. | Saving a presentation to an internal drive places its file in secondary storage, rather than merely leaving it open. |
| 5 | Solid-state storage | Storage using electronic memory with no moving mechanical parts, such as a solid-state drive. | Compare speed, capacity, durability and cost for the actual use; the label alone does not settle every purchasing decision. |
| 6 | Bit | A binary digit with one of two possible values, commonly written as zero or one. | Do not read a lowercase b and an uppercase B as interchangeable when a question distinguishes bits from bytes. |
| 7 | Byte | A group of eight bits, commonly used as a unit for describing stored data. | A hypothetical eight-byte item contains sixty-four bits; state the unit rather than writing only the number sixty-four. |
| 8 | Input device | Hardware that provides data or instructions to a computer system. | A microphone supplies recorded sound as input; the speaker that plays the recording performs a different role. |
| 9 | Output device | Hardware that presents or delivers results from a computer system. | A projector displays the completed slides, while the keyboard used to enter the slide text is an input device. |
| 10 | Processing | Operations that transform input data into results according to instructions. | Adding three attendance numbers is processing; entering those numbers is input, and displaying their total is output. |
Read network words as relationships. A client requests something; a server provides it. A LAN describes geographical scope, while an intranet describes a private organisational environment. These categories do different work. A useful home discussion is to ask which parts of a task require an internet connection and which can still operate within the local network.
| No. | Term | Plain meaning | Use it accurately |
|---|---|---|---|
| 11 | Local area network (LAN) | A network connecting devices within a relatively limited area, such as a room, home or school site. | A home’s connected computer and network printer can belong to a LAN even when its internet connection is unavailable. |
| 12 | Wide area network (WAN) | A network connecting devices or networks across a wider geographical area. | When a task contrasts a school network with a connection spanning distant locations, geographical scope is the useful distinction. |
| 13 | Network interface card | The hardware interface that enables a computer to connect to a network, sometimes integrated into the device. | A computer needs a suitable network interface; possessing a saved Wi-Fi password does not itself provide the hardware connection. |
| 14 | Wireless router | A device that routes network traffic and commonly provides wireless access for devices on a local network. | A working wireless connection to the router does not by itself prove that the router has a working internet connection. |
| 15 | Modem | Equipment that adapts signals for communication over a particular connection to a service provider. | A home unit may combine modem and router functions; explain their roles instead of assuming every role requires a separate box. |
| 16 | Client | A program or device that requests a service or resource from another system. | When a browser requests a web page, it acts as a client in that interaction. |
| 17 | Server | A program or device that provides services or resources to clients. | A system supplying shared files acts as a server; its role matters more than whether its case looks unusually large. |
| 18 | Intranet | A private organisational network or service environment intended for authorised members. | A school’s internal information service may be an intranet; being available through a browser does not make it public. |
| 19 | IP address | A network-layer address used to identify interfaces and support delivery of data through IP networks. | An IP address helps network communication; it is not the same thing as a person’s name or a website’s page title. |
| 20 | MAC address | An identifier associated with a network interface and used in local link-layer communication. | Distinguish the interface identifier from the IP address used for network addressing; neither is a student’s account password. |
Knowing a risk name is useful only when it changes a decision. A student should be able to explain where a file is saved, how it can be recovered and why an unexpected request for credentials needs checking. Use invented examples for practice. Do not ask children to share actual passwords, account details or private school documents as evidence of learning.
| No. | Term | Plain meaning | Use it accurately |
|---|---|---|---|
| 21 | Cloud storage | A service that holds files on remote systems accessed through a network, commonly the internet. | A saved cloud file and a local copy may be different versions; check which one contains the latest correction. |
| 22 | Local storage | Storage on the device or a locally connected medium, rather than a remote cloud service. | A file on the laptop may remain available offline, but losing that laptop can also remove access to that copy. |
| 23 | Backup | An additional recoverable copy of data, kept so that the original can be restored after loss or damage. | A second shortcut to the same file is not another copy; test that the backup can actually be opened. |
| 24 | Artificial intelligence (AI) | Computing methods that enable systems to perform tasks such as recognition, prediction or generating content. | An AI-generated explanation can contain errors; the student still needs to check its reasoning and follow school rules on assistance. |
| 25 | Malware | Software designed to cause harm, misuse a system or gain unauthorised access. | A harmless-looking download can contain malware; its attractive icon is not evidence that the software is safe. |
| 26 | Phishing | Deception that impersonates a trusted party to obtain information or induce an unsafe action. | An urgent message asking for a school password should be verified through a known official channel, not its supplied contact link. |
| 27 | Ransomware | Malware that blocks access to data or systems, often by encryption, and demands payment. | Recognising the term explains the risk; students should report suspicious activity rather than experiment with an unfamiliar attachment. |
| 28 | Firewall | A control that allows or blocks network traffic according to configured rules. | A firewall is one protective layer; it does not make every message truthful or replace careful account security. |
| 29 | Copyright | Rights protecting original creative work and controlling certain uses of that work. | Finding a photograph online does not automatically give permission to use it in a publicly shared project; check its permitted use. |
| 30 | Privacy policy | A statement explaining how an organisation handles personal information, including its collection and use. | Before entering unnecessary personal details, read what the service says it will collect and how that information will be used. |
Think of a spreadsheet as connected instructions. Some cells contain inputs, others contain formulas and others supply labels. Changing the display format is different from changing the input. Before copying a formula, identify which references should move with the row and which should stay attached to one shared value.
| No. | Term | Plain meaning | Use it accurately |
|---|---|---|---|
| 31 | Cell | A single position in a spreadsheet grid at the intersection of a row and a column. | In a practice register, one cell can hold one day’s attendance number; keep headings separate from the numerical data. |
| 32 | Cell reference | The address used to identify a spreadsheet cell, normally combining a column letter and row number. | C4 points to column C, row 4; reversing the letter and number changes the meaning or makes the reference invalid. |
| 33 | Range | A selection or reference covering multiple cells in a spreadsheet. | B2:B4 refers to three cells down one column, not all the cells in the workbook. |
| 34 | Formula | An expression that a spreadsheet evaluates to produce a result. | The expression =C2/B2 calculates a ratio; typing the result as a fixed number removes its connection to changing inputs. |
| 35 | Function | A named operation supplied by software, often used inside a spreadsheet formula. | SUM is a function; =SUM(B2:B4) is a formula that uses it to total a particular range. |
| 36 | Relative cell reference | A reference that keeps the same row-and-column offset from the formula cell when copied, so its displayed address usually changes. | Copying =C2/B2 down one row normally produces =C3/B3, so each row uses its own data. |
| 37 | Absolute cell reference | A reference with its row and column fixed for copying, written using dollar signs in common spreadsheet software. | In =D2>=$G$1, the comparison keeps using G1 when the formula is copied down to other rows. |
| 38 | Recalculation | Re-evaluation of formulas when their referenced data changes, according to the spreadsheet’s calculation settings. | Correcting an attendance input should update its connected formula result; a manually typed answer will not automatically follow it. |
| 39 | Number format | The way a numerical value is displayed, such as currency, percentage or a chosen number of decimal places. | Displaying 0.8 as 80% changes its appearance; it does not turn its stored numerical value into eighty. |
| 40 | Conditional formatting | A display rule that changes a cell’s appearance when a condition is met. | Highlight attendance below a chosen threshold, then explain the numerical rule; colour alone is not a calculation. |
Read logical statements aloud before entering them. “At least one” points towards OR; “both requirements” points towards AND. Then test a value exactly at the boundary. Function names should also be read as verbs: count, add, choose or look up. Choosing the wrong verb can produce a tidy-looking answer to the wrong question.
| No. | Term | Plain meaning | Use it accurately |
|---|---|---|---|
| 41 | Condition | A statement that can be evaluated as true or false in a particular situation. | Attendance>=0.8 is true at exactly 0.8; replacing >= with > changes what happens at the boundary. |
| 42 | IF | A spreadsheet function that selects one result when a condition is true and another when it is false. | =IF(B2>=10,”Enough”,”Review”) chooses its output from the value in B2; the words are results, not extra conditions. |
| 43 | AND | A logical operation that is true only when all the conditions it combines are true. | For AND(age>=13,consent=”Yes”), satisfying the age condition alone is insufficient; the consent condition must also be true. |
| 44 | OR | A logical operation that is true when at least one of its conditions is true. | An OR condition can be true when both alternatives are true; it does not necessarily mean exactly one alternative. |
| 45 | NOT | A logical operation that reverses a true-or-false result. | NOT(ready) is false when ready is true; identify the full condition being reversed before reading the result. |
| 46 | COUNT | A spreadsheet function that counts numerical values in the specified arguments or range. | If a range contains 8, the text Absent and an empty cell, COUNT counts the number, not the text label. |
| 47 | COUNTA | A spreadsheet function that counts non-empty cells, including cells containing text. | In the same simple range, COUNTA counts both 8 and Absent; this answers a different question from counting numbers alone. |
| 48 | COUNTIF | A spreadsheet function that counts cells meeting one stated criterion. | =COUNTIF(E2:E4,”Ready”) counts cells with the label Ready; it does not add the attendance figures in another column. |
| 49 | SUMIF | A spreadsheet function that adds values associated with entries meeting a stated criterion. | Use it to total attendance for a named category; distinguish the range being checked from the values being added. |
| 50 | Exact match | A lookup requirement that identifies the requested value precisely, rather than accepting an approximate alternative. | For a student or item code, a nearly matching code can identify the wrong record; use the specified exact-match option. |
A clean display is not proof of correct data. A validation rule can reject some impossible entries while accepting a plausible but incorrect one. A chart can make a pattern visible while leaving its interpretation uncertain. In graphics, identify whether the underlying object is an editable shape or a grid of pixels before deciding how to change it.
| No. | Term | Plain meaning | Use it accurately |
|---|---|---|---|
| 51 | Data validation | Rules that check whether an entered value satisfies permitted conditions. | A rule accepting whole numbers from zero to thirty rejects forty, but it cannot prove that an accepted twenty is truthful. |
| 52 | Sorting | Rearranging records into an order based on one or more fields. | Sort complete attendance rows together; sorting only the names can detach them from their corresponding figures. |
| 53 | Filtering | Displaying records that satisfy selected criteria while other records are hidden from that view. | Filtering for Tuesday narrows what is displayed; it does not normally mean the other days have been deleted. |
| 54 | Legend | A chart key explaining which colour, symbol or pattern represents each data series. | When a chart has registered and attended series, its legend tells the reader which set of marks represents each quantity. |
| 55 | Combination chart | A chart using more than one chart form, such as columns and a line, to present related data. | A column-and-line display still needs clear labels and scales; different units must not be presented as if they are identical. |
| 56 | Vector graphic | An image represented through defined shapes and paths rather than only a fixed grid of coloured pixels. | An editable vector badge can be enlarged while retaining its shape definition; an exported raster copy has different limitations. |
| 57 | Raster graphic | An image represented as a grid of pixels. | A photograph is commonly raster-based; enlarging a small copy cannot reliably recover original detail that was never recorded. |
| 58 | Pixel | An individual picture element in a raster image. | A blocky enlarged edge reveals the image’s pixel structure; adding more display area does not necessarily add meaningful detail. |
| 59 | Node | A control point used to define or adjust a vector path. | Move the node that shapes the curve rather than dragging the whole drawing when only one corner needs correction. |
| 60 | Path | A line or curve defined by points and segments in vector work. | Text following a curved path uses that route for placement; the path is not a computer folder address in this context. |
Media vocabulary helps a student follow a precise instruction. Crop, resize and change the fill are different actions, even when each changes what the audience sees. Ask the learner to describe the intended result before touching a control. A short explanation often exposes whether the wrong tool is about to be used.
| No. | Term | Plain meaning | Use it accurately |
|---|---|---|---|
| 61 | Fill | The colour or pattern inside a drawn shape. | Changing the fill alters the inside of the badge; it need not change the thickness of its border. |
| 62 | Gradient | A gradual transition between colours or shades. | A background fading from pale green to white uses a gradient; a single flat colour is a solid fill. |
| 63 | Transparency | The extent to which underlying material remains visible through an object. | A partially transparent shape can reveal another shape beneath it; check readability instead of assuming visibility guarantees clear contrast. |
| 64 | Outline | The visible stroke around a shape or along a path. | A thicker outline can make a symbol clearer, but it is separate from the shape’s fill colour. |
| 65 | Crop | Remove or hide outer parts of an image to change the visible area. | Cropping a photograph can remove empty background; it does not mean stretching the whole photograph into a different proportion. |
| 66 | Resize | Change an object’s dimensions. | Resize a circular badge proportionally if it must stay circular; unequal horizontal and vertical scaling can turn it into an ellipse. |
| 67 | Slide master | A presentation feature controlling shared layout and styling across related slides. | Change a common heading style through the master instead of manually making inconsistent changes on every slide. |
| 68 | Storyboard | A plan showing the sequence and intended content of a presentation, video or other visual narrative. | Sketch what each scene should communicate before adding transitions; the plan should serve the audience’s understanding. |
| 69 | Frame | One image in a sequence forming a video or animation. | A video contains many frames; a frame is not the same as a whole scene or a saved project file. |
| 70 | Frame rate | The number of frames presented per second, commonly expressed as fps. | Compare otherwise similar clips when judging smoothness; resolution, compression and duration also affect the file size. |
A visual program is still a program: the order of instructions and the values they change matter. Begin with the starting state, then move through one instruction at a time. Students should explain what each variable represents, how it begins and which events are allowed to change it.
| No. | Term | Plain meaning | Use it accurately |
|---|---|---|---|
| 71 | Algorithm | An ordered set of instructions for carrying out a task or solving a problem. | Describe how to count qualifying entries before choosing blocks; an algorithm must specify what happens, not merely state the goal. |
| 72 | Decomposition | Breaking a problem into smaller parts that can be addressed separately. | Divide a simple game into starting state, movement, scoring and ending, then check how those parts interact. |
| 73 | Abstraction | Selecting the details relevant to a purpose while leaving out unnecessary detail. | An attendance model needs the relevant counts; decorative descriptions of the room do not help calculate the attendance rate. |
| 74 | Flowchart | A diagram showing the order of actions and decisions in a process. | Follow each decision branch to its next step; reading only the boxes and ignoring the arrows loses the program’s logic. |
| 75 | Sequence | The order in which instructions are carried out. | Set the starting score before adding points; reversing those instructions can overwrite the score just calculated. |
| 76 | Variable | A named place used by a program to hold a value that can change. | A score variable can change during a game; its name identifies its role while its current value records its state. |
| 77 | Initialisation | Setting a starting value or state before later processing uses it. | Set score to zero when beginning a new game so that a previous run does not silently affect the new result. |
| 78 | Assignment | Setting a variable to a specified value or the result of an expression. | Setting score to 2 replaces its previous value; changing score by 2 adds to what was already there. |
| 79 | Conditional instruction | An instruction that chooses an action according to whether a condition is true. | An if-else structure can show one message when a target is reached and another when it is not. |
| 80 | Loop | A structure that repeats instructions according to a count or condition. | A loop can move a sprite several times; inspect what is inside the loop and what runs only once outside it. |
Loop vocabulary concerns control. Count-controlled repetition answers “How many times?”; condition-controlled repetition answers “While what remains true?” or “Until what becomes true?”. Draw a small table of changing values when the answer is uncertain. This is often more revealing than repeatedly running a program without recording what happened.
| No. | Term | Plain meaning | Use it accurately |
|---|---|---|---|
| 81 | Repeat | A count-controlled loop instruction that repeats its enclosed actions a specified number of times. | Repeating a change of two points four times adds eight points, provided no other instruction resets or changes the score. |
| 82 | Forever | A loop that continues while the relevant script or program is running, until it is stopped. | A forever loop can keep checking key presses; it is not a promise that the entire computer can never stop. |
| 83 | Repeat until | A loop that continues while its stopping condition is false and finishes when that condition becomes true. | Repeat until score>=10 stops because the target has been reached; identify the event that can make the condition true. |
| 84 | While | A loop that continues while its test condition is true. | While lives>0 expresses a continuation condition; distinguish this wording from an until condition that describes when to stop. |
| 85 | Logical operator | An operator such as AND, OR or NOT that combines or changes true-or-false values. | Use AND when both requirements must hold; writing the right words in the wrong logical relationship still gives the wrong decision. |
| 86 | Relational operator | An operator comparing values, such as less than, greater than or equal to. | The test score>10 excludes ten itself; read the comparison symbol before deciding what happens at the threshold. |
| 87 | List | A collection of items kept in an ordered structure that a program can read or change. | A list of three names is not the same as one variable containing a long sentence with those names. |
| 88 | Index | A position used to identify an item within a list or array. | Check the environment’s indexing convention; do not assume that the first item has the same index in every language. |
| 89 | Custom block | A named group of instructions that can be used as one reusable operation. | Create a reset routine when several parts of the project need the same starting setup, then check what it actually changes. |
| 90 | Debugging | Finding, understanding and correcting errors in a program. | If a score is wrong, trace its changes before dragging random blocks around; identify the earliest step that differs from the intended result. |
The same visible result can involve several objects. A backdrop may change while a sprite continues moving because its script still runs. In a physical prototype, a sensor provides an input and the program decides what to do with it. Keep those roles separate when describing behaviour, testing a design or explaining an unexpected result.
| No. | Term | Plain meaning | Use it accurately |
|---|---|---|---|
| 91 | Sprite | A programmable object in a visual game environment, often with an appearance and its own scripts. | The player and the target can be separate sprites; select the correct sprite before editing its movement instructions. |
| 92 | Stage | The area in which a visual program displays its scene and sprites. | A stage can have its own scripts and backdrop; it is not simply another name for the selected sprite. |
| 93 | Coordinate | A value used with another value to specify a position, such as an x-and-y pair. | Changing x moves horizontally in the usual stage system; changing a score variable does not itself change the sprite’s position. |
| 94 | Costume | One of the appearances available to a sprite. | Changing costume can animate a walking character while keeping it as the same sprite with the same role. |
| 95 | Backdrop | An image or appearance used for the stage background. | Switching to a finish-screen backdrop changes the scene; it does not necessarily stop every other script automatically. |
| 96 | Event | An occurrence that triggers or influences program execution, such as a key press or message arrival. | Ask what starts a script before tracing its blocks; an unattached sequence may not run when the student expects it to. |
| 97 | Broadcast | A message sent within a visual project to trigger scripts that receive that message. | A Finish message can tell another sprite to display a result; it does not automatically mean publishing information on the internet. |
| 98 | Microcontroller | A small programmable computing device used to read inputs and control outputs in an embedded system. | A classroom prototype can read a button and control an LED; identify the input, decision and output separately. |
| 99 | Sensor | A component that detects a physical quantity or condition and provides a corresponding signal or reading. | A light sensor supplies a reading for the program to interpret; it does not independently decide every action the prototype should take. |
| 100 | Prototype | An early model built to explore and test how a proposed solution could work. | A demonstration that works once is a starting point; test different inputs before claiming the design meets its intended need. |
The following attendance register is an invented classroom exercise. It is not data about a real Punggol school, programme or student. Columns A, B and C contain the day, registered participants and participants who attended. Row 1 contains the headings; rows 2–4 contain the figures below.
| Row | A: Day | B: Registered | C: Attended | D: Attendance rate |
|---|---|---|---|---|
| 2 | Monday | 12 | 10 | 83.3% |
| 3 | Tuesday | 18 | 12 | 66.7% |
| 4 | Wednesday | 20 | 20 | 100.0% |
Enter =C2/B2 in D2 and copy it down. The relative references should make D3 use C3 and B3, and D4 use C4 and B4. Apply a percentage number format with one decimal place. The display is rounded for reading; the formula still represents the underlying ratio.
Now put the threshold 0.8 in G1. In E2, use =IF(D2>=$G$1,"Ready","Review") and copy it down. The results are Ready, Review and Ready. D2 changes with the row, while the absolute reference $G$1 remains attached to the shared threshold. Microsoft’s guide to relative and absolute references explains this copying distinction.
Check the meaning before celebrating the output. Ready means that the invented attendance rule has been met; it is not a judgement about a child’s character or ability. Change G1 to 0.9 and predict the labels before inspecting them. Only Wednesday now meets the rule. This single change checks whether the formulas remain connected to the intended threshold.
Finally, =COUNTIF(E2:E4,"Ready") returns two under the original threshold. It counts matching labels. It does not add the participant numbers. Total attendance is forty-two out of fifty registrations, giving 84%. Averaging the three daily percentages answers a different question because the groups have different sizes. The word average should therefore prompt the learner to ask exactly what is being averaged.
All registered counts here are positive. A real task allowing a zero denominator needs a rule for that case. Do not conceal it by typing a convenient answer over the formula. Explain the issue and follow the task’s data-validation or conditional-processing requirements.
In the programming explanations, score >= 10 is comparison shorthand. In Scratch, build the same test as not (score < 10), using the supported operator blocks. Read the intended condition first, then express it with the blocks available in the school’s environment.
Imagine a simple visual program in which a character moves across a stage and earns points. The following is teaching pseudocode: a written description of the intended block sequence, not text to paste into a particular software editor.
When the game starts:
set score to 0
set x to -60
repeat 4 times:
change x by 30
change score by 2
There are two variables or state values to watch: horizontal position and score. Initialisation creates the starting state. The loop repeats the two changes. Trace the values after each complete repetition:
| Point in execution | x position | Score |
|---|---|---|
| After initialisation | −60 | 0 |
| After repetition 1 | −30 | 2 |
| After repetition 2 | 0 | 4 |
| After repetition 3 | 30 | 6 |
| After repetition 4 | 60 | 8 |
If the final score is two, inspect whether the loop contains “set score to 2” instead of “change score by 2”. The first instruction assigns the same value repeatedly; the second increases the existing value. If a second run begins with extra points, inspect where the reset occurs. These are different errors even though both produce an incorrect score.
Ask one transfer question: what happens if the loop repeats five times? The position becomes ninety and the score becomes ten, assuming nothing else changes them. A student who can explain this has connected repeat, sequence, assignment and initialisation. The Scratch Foundation’s variables and lists resource offers further practice with these concepts.
Do not assume a screenshot of the final score proves that the entire program is correct. It could have been typed manually or reached accidentally. Ask the student to restart, change the repeat count and explain the new result. The observable behaviour and the explanation should agree.
A fictional school club wants a badge for a slide presentation and a short welcome video. The badge begins as a vector drawing. Its outer circle has a dark outline and a pale fill. The first instruction is to make the circle’s interior lighter while keeping the border unchanged. The relevant word is fill. Changing the entire object’s transparency could also weaken the border, so it does not express the same edit.
The next instruction is to remove empty space around a photograph. The useful action is crop. Stretching the photograph to fill a frame changes its proportions and may distort the people or objects shown. A learner who confuses crop with resize can operate the software fluently while still failing to achieve the intended result.
For the presentation, use a shared layout so that titles appear consistently. For the video, use a storyboard to decide what each scene communicates. A transition is helpful when it supports the sequence; adding many effects does not replace a clear message. Keep the editable project as well as any required exported output, following the teacher’s file instructions.
Now explain the export decision. A PNG version of a vector badge is a raster image. The editable vector source still contains the shape information, but the exported copy has pixels at a chosen size. Enlarging that exported copy is not the same operation as enlarging the original vector design. This distinction makes vector, raster, pixel and resize useful working vocabulary.
Definitions are starting points. An explanation must connect the relevant property to the situation. For example, “Use cloud storage because it is online” identifies a feature but does not explain why that feature matters. A stronger response might say: “Cloud storage can make the project accessible from an authorised second device, but access depends on the service and connection. A separate recoverable copy also protects against losing the only working version.” The judgement is tied to a need and a limitation.
When comparing, use the same dimension on both sides. For local and cloud storage, compare location, access conditions or recovery arrangements. Do not compare the colour of one device with the capacity of another. For a LAN and WAN, start with geographical scope. For a client and server, start with their roles in a service request. An answer becomes clearer when the comparison has a stable basis.
When justifying a formula, identify the operation and the references. “I used this formula because it works” offers little evidence. “I divided attended by registered to obtain the attendance proportion, then kept the threshold reference fixed while copying the decision formula” shows what the calculation represents and how it survives copying.
When debugging, explain the earliest incorrect state. Suppose the intended sequence sets the score to zero before movement, but the reset is placed inside every repetition. The important explanation is that the reset discards the accumulated score. Naming the error as a “loop problem” is too broad to show what should change.
Use precise limits. Validation can reject values outside a permitted range without proving every accepted entry is correct. A backup supports recovery without preventing every attack. A firewall filters traffic without deciding whether a persuasive message is honest. These limits protect students from writing explanations that sound confident but promise more than the concept can deliver.
Try the questions without looking back at the list. Write a sentence or a small trace, not just a term. These are original learning exercises rather than SEAB specimen questions or an official marking scheme. After checking, return to the exact pair of words involved in each mistake.
- A student changes 0.65 to a percentage display and says the stored value is now 65. What is the confusion?
- A formula in D2 is
=B2*$F$1. What should it become when copied one row down? - A simple range contains the number 9, the text Pending and one genuinely empty cell. What do COUNT and COUNTA return?
- A rule accepts attendance values from zero to thirty. Does an accepted value of twenty prove the entry is correct?
- A student sorts only the names column of a table containing names and scores. What might go wrong?
- A character’s score starts at three and increases by two in each of five repetitions. What is the final score?
- In the preceding program, each repetition sets the score to two instead. What is the final score?
- A loop stops when score>=10. Should it stop at exactly ten?
- A sprite changes costume, but its scripts and identity stay the same. Has a new sprite necessarily been created?
- A small raster photograph looks blocky when enlarged. Why does enlarging it not guarantee better detail?
- The laptop connects to the home router, but an internet page does not load. Does the wireless connection prove the wider connection works?
- A message threatens to delete a school account unless a password is entered through its link. What is the safer next step?
Answers and what each answer reveals
- Value versus format. The display can show 65% while the value remains 0.65. Ask the student to use the cell in a calculation to test that distinction.
=B3*$F$1. B2 moves with the row; F1 remains fixed. If both references move, revisit absolute references before adding a more complicated formula.- COUNT returns 1; COUNTA returns 2. The first counts numerical values, and the second counts the two non-empty cells. This example has no formulas returning empty-looking text.
- No. The value meets the rule but may still be factually wrong. Validation and verification of the real-world information answer different questions.
- Names can become mismatched with scores. Treat each complete row as one record so that rearranging it preserves the relationship between its fields.
- Thirteen. Start with three, then add two five times. The calculation is 3 + 5 × 2, provided no other instruction changes the score.
- Two. Repeated assignment replaces the value each time. This is different from repeatedly increasing the current value by two.
- Yes. Greater than or equal includes the boundary value. A strict greater-than test would behave differently at exactly ten.
- No. A costume changes the appearance of an existing sprite. Its object identity and associated scripts can remain the same.
- The original has a limited pixel grid. A larger display can spread or estimate pixels but cannot guarantee restoration of details that were not captured.
- No. The local wireless connection and the onward internet connection are different parts of the route. Troubleshooting should identify which connection is failing.
- Verify independently through the school’s known channel. Do not submit the password through the unexpected message. The sender’s claimed identity and urgency are not proof of authenticity.
For the final question, see the Cyber Security Agency of Singapore’s phishing guidance. Its practical lesson is to check a suspicious request through a trusted route. Students do not need to open a questionable attachment or visit a fake site to demonstrate that they understand the vocabulary.
Choose a small set from an actual learning need. Five words about references and formulas may be more useful today than twenty unrelated terms. Begin by explaining each word without the table, then use it in a tiny task. End by changing one input or instruction and predicting the effect before running it.
Keep a simple error record with four columns: task, mistaken idea, correction and next check. A useful entry is “Copied threshold formula; thought every reference should move; fixed the shared threshold; next time copy two rows and inspect both formulas.” “Careless again” gives the student little information for the next attempt.
Return to the same idea after a gap with different numbers or a different scenario. If Monday’s practice used attendance, the next task can use item quantities. Keep the underlying relationship the same while changing the surface details. This checks whether the student understands the idea or remembers one screen.
Practise file handling as part of the task. Use the required filename and location, save changes and check that the intended file opens. At home, keep recoverable copies of important work. CSA’s data-resilience advisory explains the value of backups and checking recovery. School examination saving instructions take priority during an assessment.
A short oral explanation can close the session: “I changed this because…; I expected this result…; I checked it by…”. If the explanation and output disagree, investigate the mismatch while the task is still small. Progress is visible when the student can perform the action, explain the choice and check a changed case with less prompting.
Bring one recent task and the student’s explanation of it to a discussion with the teacher or tutor. Ask whether the difficulty concerns concepts, software actions, program logic or task reading. A broad description such as “weak in Computing” can hide very different needs. A child who selects an unsuitable chart needs different practice from one who knows the chart but cannot find the relevant control.
Ask how the support matches G2 K237 and the school’s software. A programme dominated by another level’s coding language or advanced topics may not address the immediate task. Extra challenge can be valuable, but it should be clearly identified as extension, with the student’s current assessed work still understood.
Ask to see how explanations are checked. A useful lesson should make the student’s reasoning visible: predict a result, perform the operation, test a variation and correct an identified error. Watching an adult produce a polished project is not the same learning experience as making and explaining the decisions independently.
At home, protect authorship. It is reasonable to ask what a term means, help locate the teacher’s instructions or encourage a restart after frustration. Replacing the student’s work with a parent-created or AI-generated project hides the very gap that teaching needs to find. Follow the school’s rules for assistance and submitted work.
Access and pace also matter. Check what equipment and software the school expects before purchasing anything. Use the available school guidance to distinguish an access problem from a vocabulary problem. This article does not advertise a particular Computing class, software package or available timetable; it gives families questions for judging whether proposed support fits the learner.
Must a student memorise all one hundred definitions?
Use the list as a working reference. A stronger goal is to explain a term in ordinary language, recognise a contrasting term and use the idea in a fresh task. Exact technical wording matters where it carries a precise distinction, but repeating a paragraph without being able to act on it gives limited evidence of understanding.
Can this list replace practical lessons?
No. The words help students understand instructions and explain choices. They still need to practise with the school’s software, inspect their results and respond to feedback. A student can understand the definition of a slide master while needing further practice applying it appropriately.
Does fast software use mean the vocabulary is secure?
Speed can come from familiarity with one routine. Change the data, the target or a condition and ask for a prediction. If the student can adapt the task and explain why the new result follows, there is better evidence that the underlying vocabulary is usable.
What should we do after finishing the list?
Choose a small task that joins two areas, such as a spreadsheet chart placed in a clear presentation. Explain the data choices, the visual choices and the file-handling decisions. Continue with the G2 Computing syllabus guide for Punggol and the teacher’s next learning objective.
Official sources establish the subject scope and relevant safety guidance. Software creators’ documentation supports the particular software concepts. The selection, definitions, examples, pseudocode, practice questions and suggested routines here are original eduKate teaching material. They are not an official examination glossary or marking scheme.
- SEAB: 2027 G2 syllabuses for school candidates — check the subject and examination year.
- SEAB: G2 Computing K237 syllabus for 2027 — authoritative content, assessment and programming-block boundaries.
- Microsoft: relative, absolute and mixed spreadsheet references — reference behaviour when formulas are copied.
- Scratch Foundation: variables and lists — creator-provided learning resources.
- CSA: phishing scams — recognising and checking suspicious requests.
- CSA: data resilience — backups and recovery checks.
More Secondary 4 G2 vocabulary guides
Choose the guide that matches the subject and combination recorded by your school.

