G2 Computing spreadsheets are not merely digital tables for entering numbers. They are tools for modelling information, applying calculations, checking conditions, presenting patterns and updating results when input changes. In the 2027 Singapore-Cambridge Secondary Education Certificate (SEC), syllabus K237, spreadsheets form Module 4, assessed in both the electronic theory paper and the practical lab examination. The practical paper allocates approximately 25 marks to spreadsheet tasks as part of its 80 marks and 50% weighting.
This guide explains how G2 spreadsheet formulas and functions work, which function families appear in SEAB’s 2027 syllabus, how to use relative and absolute references, and how to avoid errors in lookups, dates, sorting and charts. It includes original fictional datasets and runnable formula examples for hands-on practice. Students should follow the precise task instructions and software supplied by their school and examination centre.
- Subject: G2 Computing, 2027 SEC K237; a new syllabus beginning with the 2027 examination.
- Paper 1: 1 hour 30 minutes, 70 marks, 50% of the subject, assessing all six modules.
- Paper 2: 2 hours 15 minutes, 80 marks, 50%, testing Media Software, Spreadsheets and Programming.
- Spreadsheet practical allocation: Approximately 25 marks out of 80; exact task marks depend on the paper.
- Important: All Paper 2 tasks are compulsory and the time includes saving the files required for marking.
- Module 4 skills: Formatting, charts, formulas, functions, sorting, filtering and data validation.
- Central habit: Build a correct model, check it with an independent calculation, change an input and verify the updated result.
What Makes a Spreadsheet Useful?
A spreadsheet can store structured records: a list of items, quantities, unit prices, dates or survey responses. The power comes from describing relationships between cells.
For example, revenue for an item can be calculated from quantity × unit price. If the price changes, the revenue should update automatically. A well-designed spreadsheet behaves like a small information system rather than a page of manually typed answers.
The student must understand what each column represents, which cells are inputs, which are formulas, and how results are checked. A beautiful layout with incorrect formulas is unreliable.
This is why the syllabus includes both presentation and computational logic.
How the Official 2027 K237 Papers Work
SEAB’s K237 syllabus contains six modules. Paper 1 assesses all six through twenty multiple-choice questions worth 20 marks and short structured questions worth 50 marks.
Paper 2 assesses only Modules 4–6: Spreadsheets, Media Software and Programming. It lasts 2 hours 15 minutes, carries 80 marks and requires students to submit appropriate soft copies of their work.
The syllabus gives approximate allocations of 25 marks for spreadsheets, 30 for media and 25 for programming. Those figures are approximate; students should follow the actual task’s marks and instructions.
The practical assessment covers AO3, application of skills, which accounts for 50% of the overall Computing subject. Recognising a function name is not enough. Students must be able to create the correct result using software.
The Software Environment Matters
The examination centre provides each candidate with a laptop and approved software for the lab-based paper. Students should practise with the software authorised by their school.
This guide uses Excel-style formula notation for clarity. Some concepts transfer to other spreadsheet applications, but function availability, interface names and behaviour may differ by version.
Do not assume a preferred cloud spreadsheet, browser plugin, personal laptop or macro tool will be available in the examination. Use school-approved preparation resources and current SEAB arrangements.
The goal is to understand the underlying computation and perform it correctly in the permitted environment.
The Practice Dataset: A Fictional School Supplies Shop
To make the skills concrete, imagine a fictional shop tracking four products. Enter the following information in columns A–D, with headings in row 1.
| Row | Item in A | Category in B | Units in C | Unit price in D |
|---|---|---|---|---|
| 2 | Notebook | Stationery | 12 | 4.50 |
| 3 | Pen | Stationery | 30 | 1.20 |
| 4 | Bottle | Accessories | 8 | 9.00 |
| 5 | Folder | Stationery | 15 | 3.00 |
These are invented educational figures, not retail prices or actual inventory records.
In cell E1, type Revenue. In E2 enter the formula **=C2*D2** and copy it through E5.
The expected results are $54, $36, $72 and $45. The total is $207.
This simple model becomes the foundation for more advanced spreadsheet functions.
Formula Versus Value: The First Distinction
A value entered directly into a cell is fixed until someone changes it. A formula calculates a result from a relationship.
If E2 contains 54 typed manually, it will not automatically change when the quantity in C2 changes. If E2 contains **=C2*D2**, the result recalculates when C2 or D2 is modified.
SEAB’s syllabus explicitly requires students to recognise automatic recalculation of formulas when referenced cells change.
A useful check is to change C2 from 12 to 10. E2 should become 45 if the unit price remains 4.50. Restore the original input afterward.
This test is a form of debugging, not merely an arithmetic demonstration.
Relative References: When a Formula Should Move
In a formula such as **=C2*D2, C2 and D2 are relative references** by default.
When the formula is copied from E2 to E3, the references shift to **=C3*D3**. The intended row changes automatically.
That is useful when calculating the same relationship for each product.
A common mistake is to type E2’s formula into every row without updating the references or to copy a single calculated value. In either case, the model may appear filled but produce incorrect totals.
Students should inspect formulas using the spreadsheet’s formula display when the result seems suspicious.
Absolute References: When a Cell Must Stay Fixed
Suppose an invented demonstration adjustment rate of 10% is stored in G1. You want to calculate a price adjusted by that same rate for every row.
The example formula in F2 could be **=E2*(1+$G$1)**.
When copied downward, E2 changes to E3, E4 and E5, but $G$1 stays fixed.
This is an example of an absolute reference, and the 10% is simply a fictional classroom factor—not a claim about the current Singapore tax rate or an official accounting requirement.
The reason to use absolute referencing is conceptual: one input should remain constant while another changes by row.
Mixed References: Understand Rows and Columns
In conventional spreadsheet reference notation, $A2 fixes the column A while allowing the row number to change, and A$2 fixes row 2 while allowing the column to move.
This can be useful in two-dimensional tables where a formula must copy both across rows and down columns.
The published K237 syllabus specifically names absolute and relative cell referencing. Mixed references are a natural extension of understanding which parts are fixed.
Students should practise by predicting how a formula will change before copying it, then checking the actual result.
The key question is always: Which quantity is meant to move, and which is not?
The Main Arithmetic Operators
The 2027 syllabus lists operators for addition, subtraction, multiplication, division and exponentiation: +, -, *, / and ^.
For example, **=C2*D2 multiplies units by price. =C2+D2** would add quantities with different meanings and would not represent revenue.
A formula can be syntactically valid but conceptually wrong. That is one of the most important lessons in spreadsheet use.
Parentheses can clarify the intended order. For instance, =(B2+C2)/2 differs from =B2+C2/2.
Students should compare a formula’s result with a hand estimate whenever possible.
The Relational Operators
The syllabus also lists greater than, greater than or equal to, less than, less than or equal to, equal to and not equal to: >, >=, <, <=, = and <>.
These produce logical conditions that can be used in formulas such as IF.
For example, =C2<10 checks whether the units in C2 are fewer than ten. At the original value of 12, the result is FALSE.
Changing C2 to 8 would make the condition TRUE.
The important skill is distinguishing a comparison from a calculation. A condition does not by itself tell the workbook what action should follow.
The IF Function: Turn a Condition Into an Outcome
In F1, type Stock note. In F2, enter:
=IF(C2<10,"Restock","Enough")
With the original data, the result for the Notebook row is Enough because 12 is not less than 10. For the Bottle row, where units are eight, the result is Restock.
The formula expresses if condition is true, return one result; otherwise return another.
A student who reverses the two text outputs may create a valid formula that gives the opposite business meaning. Check the statement of the intended rule before typing.
The K237 syllabus permits up to one level of nested IFs in the specified function content. There is no need to assume arbitrarily deep nesting is an examination requirement.
AND, OR and NOT: Different Types of Logic
AND tests whether all specified conditions are satisfied. OR tests whether at least one condition is satisfied. NOT reverses a logical value.
A fictional rule might require reviewing items with fewer than ten units AND price greater than $5:
=IF(AND(C2<10,D2>5),"Check","Routine")
On the Bottle row, C4 = 8 and D4 = 9, so both conditions hold and the result is Check.
A different rule using OR would label an item if either condition held, potentially producing more matches.
Students should translate the business rule into ordinary language first. A logical formula can be technically correct but answer the wrong question.
SUM: The Basic Total That Must Include the Right Range
For the fictional shop, total revenue in E2:E5 is:
=SUM(E2:E5), which returns 207.
A surprisingly common error is using =SUM(E2:E4), accidentally omitting the last item. The function works, but the range is wrong.
Before trusting a total, check where the data begin and end. If the table may expand, follow the task’s instructions for the intended range.
A total that looks plausible is not proof that every row was included.
SUMIF: Add Only the Matching Rows
Suppose the task asks for revenue from Stationery items only.
The formula is:
=SUMIF(B2:B5,"Stationery",E2:E5)
It adds E2, E3 and E5, producing $54 + $36 + $45 = $135.
The criteria range is B2:B5, containing categories. The sum range is E2:E5, containing revenue.
Mixing the two ranges can cause incorrect results. The student must understand which cells decide whether a row qualifies and which provide the value to add.
This is more than memorising commas in a function.
COUNT, COUNTA, COUNTBLANK and COUNTIF
These functions count different kinds of entries.
COUNT counts numeric values in a range. COUNTA counts non-empty cells. COUNTBLANK counts empty cells. COUNTIF counts cells meeting a condition.
For the four product quantities in C2:C5:
=COUNT(C2:C5)returns 4, because all four are numeric.=COUNTA(A2:A5)returns 4, because all four item names are present.=COUNTIF(C2:C5,">=10")returns 3, for quantities 12, 30 and 15.=COUNTIF(B2:B5,"Stationery")returns 3, for the three matching categories.
The correct function depends on what is being counted, not merely the presence of the word “count” in the question.
AVERAGE and AVERAGEIF
AVERAGE finds the arithmetic mean of a selected numeric range. AVERAGEIF computes the average for values meeting a condition.
The four unit prices are 4.50, 1.20, 9.00 and 3.00. Their mean is (4.50 + 1.20 + 9.00 + 3.00)/4 = 4.425.
A formula such as =ROUND(AVERAGE(D2:D5),2) displays 4.43.
The average price for Stationery items, ignoring the Bottle, can be calculated using =AVERAGEIF(B2:B5,"Stationery",D2:D5). It gives 2.90.
Students should distinguish average unit price across products from a quantity-weighted average selling price. They are different quantities when units sold differ.
MEDIAN, MODE.SNGL, MIN and MAX
These functions summarise numerical data in different ways.
MEDIAN finds the middle value after ordering the data, or the average of the two middle values for an even count.
MODE.SNGL returns a most frequently occurring numerical value where one exists. If values tie, the function’s treatment of ties follows its defined behaviour.
MIN and MAX find the smallest and largest numerical values.
A student should choose the function that answers the question. The largest observed result is not the “average”, and the median is not automatically the value appearing most often.
Learning the distinction makes spreadsheet work meaningful rather than mechanical.
RANK.EQ: Order Values Correctly
Suppose the shop wants to rank products by revenue from highest to lowest.
For the revenue in E2, use =RANK.EQ(E2,$E$2:$E$5,0).
The original revenues are 54, 36, 72 and 45. The Notebook’s revenue of 54 is the second highest, so the formula returns 2.
The third argument 0 specifies descending ranking. A different setting can rank ascending.
The absolute range ensures the comparison set remains fixed if the formula is copied to other rows.
Do not confuse a rank with the revenue amount itself.
LARGE and SMALL: The n-th Item
LARGE and SMALL select the n-th largest or smallest value from a range.
For revenues 54, 36, 72 and 45, =LARGE(E2:E5,2) returns 54, the second-largest amount.
=SMALL(E2:E5,2) returns 45, the second-smallest amount.
These functions differ from MAX and MIN, which return the extreme values.
Students should carefully read whether a question asks for rank, second-highest value or the name of the item having that value. Different functions or combinations may be required.
QUOTIENT, MOD and POWER
These functions illustrate different numerical operations.
=QUOTIENT(17,5) returns 3, the integer portion of the division.
=MOD(17,5) returns 2, the remainder.
=POWER(2,3) returns 8, since two cubed equals eight.
A plausible practical use is grouping supplies into complete packs while tracking leftover units. But QUOTIENT and MOD answer different parts of that problem.
The underlying arithmetic meaning should be understood before choosing a function.
ROUND, CEILING.MATH and FLOOR.MATH
These functions apply different rounding operations.
ROUND rounds to a specified number of decimal places. CEILING.MATH rounds upward to a specified multiple under its rules. FLOOR.MATH rounds downward.
A student should not treat rounding upward as identical to ordinary rounding. If a task concerns the number of complete packs needed, rounding up may be appropriate, but the model must match the situation.
Care is especially important for negative numbers or non-default significance settings. Use the exact task and software rules, not guesses from a function name alone.
The syllabus specifies these functions, so students should practise their actual behaviour in the approved spreadsheet environment.
SQRT and Exponentiation
=SQRT(81) returns 9, the principal square root of 81.
=POWER(3,2) returns 9, as does =3^2 in standard spreadsheet formula notation.
A student should not assume square root and squaring are interchangeable operations. One finds a principal root; the other multiplies a number by itself.
When a function produces an error, check whether its input is within the function’s accepted domain and correctly formatted.
These skills help students reason about formulas rather than type a function name at random.
RAND and RANDBETWEEN: Random Values Can Change
RAND generates a random number within its specified range. RANDBETWEEN generates a random integer between the given bounds.
For practice, =RANDBETWEEN(1,6) can simulate a fair die’s possible numbered outcomes, assuming the software uses its defined random generation.
Values may change when a spreadsheet recalculates. A student should not treat one randomly generated number as fixed evidence unless the task requires and permits a particular way of preserving it.
Random output is useful for simulations, but a random function does not automatically make a survey sample representative. Proper sampling design still matters.
LEFT, MID and RIGHT: Extracting Text
Text functions can retrieve selected characters from a code or label.
Suppose A2 contains SG-204.
=LEFT(A2,2) returns SG.
=RIGHT(A2,3) returns 204.
=MID(A2,4,3) also returns 204, beginning at the fourth character and taking three characters.
These operations depend on character positions, not word meanings. If the code structure changes, a fixed-position formula may retrieve the wrong fragment.
This is why students should test functions against more than one input when building a reusable model.
LEN and CONCAT: Length and Combining Text
LEN returns the number of characters in a text value, according to the spreadsheet’s rules.
For SG-204, =LEN(A2) returns 6.
CONCAT can combine text pieces. For example, =CONCAT("Item-",A2) produces Item-SG-204.
The syllabus also includes the & operator for text concatenation; ="Item-"&A2 can achieve the same visible result.
A strong learner understands whether the task is extracting, counting or combining text, not merely using whichever function appeared most recently in class.
FIND and SEARCH: Similar but Not Identical
Both locate a text fragment within another text value, but their case-sensitivity behaviour differs.
In common Excel-style spreadsheet behaviour, FIND is case-sensitive, while SEARCH is case-insensitive.
If A2 contains School, =SEARCH("s",A2) can find the leading S without requiring identical case. A corresponding FIND with lowercase s may not find a match.
The task might depend on this distinction. Students should test actual behaviour using the approved software, especially with mixed-case strings.
Do not assume every text search is case-sensitive or that the same function is appropriate in every scenario.
VLOOKUP: Exact Matching in a Vertical Table
Consider an original lookup table with product codes in H2:H5, names in I2:I5 and unit prices in J2:J5.
| Row | H: Code | I: Item | J: Price |
|---|---|---|---|
| 2 | P01 | Notebook | 4.50 |
| 3 | P02 | Pen | 1.20 |
| 4 | P03 | Bottle | 9.00 |
| 5 | P04 | Folder | 3.00 |
To find the price for P02 with exact matching, use:
=VLOOKUP("P02",$H$2:$J$5,3,FALSE)
This returns 1.20.
The lookup value is P02, the table starts with the code column, the result is in the third column of that table, and FALSE requests exact matching.
A common mistake is leaving out the exact-match setting when the task requires exact identification.
HLOOKUP: When the Matching Table Is Horizontal
HLOOKUP follows a related idea but searches across the first row of a horizontal range and retrieves a value from a specified row.
It is not automatically better or worse than VLOOKUP. The appropriate one depends on how the reference data are laid out.
A student should identify the direction of the lookup, where the key values appear and which row or column contains the needed result.
Practise with an intentionally small table before moving to more complicated data. This reduces errors caused by confusing coordinates rather than misunderstanding the actual lookup purpose.
The K237 syllabus specifies exact matching for the VLOOKUP and HLOOKUP content.
INDEX and MATCH: Locate a Value More Flexibly
The functions INDEX and MATCH can be combined to retrieve data.
Using the fictional product-code table:
=INDEX(J2:J5,MATCH("P02",H2:H5,0))
MATCH finds P02’s relative position in H2:H5, which is 2. INDEX then returns the second value from J2:J5, which is 1.20.
The important idea is that MATCH finds a position, while INDEX returns a value at a specified position.
If the lookup range and return range do not align, the result may be incorrect even when the formula is accepted.
Students should test one known code before trusting a formula copied through many rows.
TODAY, NOW and DAYS
The syllabus includes date functions for the current date, current date and time, and the difference between two dates.
=TODAY() produces the current date according to the spreadsheet environment.
=NOW() produces the current date and time.
=DAYS(B2,A2) calculates the number of days between an end date in B2 and a start date in A2 under the function’s conventions.
These functions do not produce permanent static values unless the workbook or task handles them in a way that preserves the result. A TODAY formula can change when reopened on another date.
A student must also check that date cells are recognised as dates, not strings that merely look like dates.
Sorting: Preserve the Whole Record
Sorting rearranges rows based on a column’s values, such as quantity, price or item name.
A serious mistake is to sort only one column while leaving related columns unchanged. This can separate product names from their quantities and prices, making the sheet misleading.
Students should select or use the complete relevant dataset, including associated fields, according to the approved software’s sorting behaviour.
After sorting, verify that each item is still paired with the correct attributes.
Correct sorting preserves the integrity of the record, not just the order of one list of numbers.
Filtering: Hide Rows Without Losing the Data
Filtering displays only rows that meet specified criteria.
For instance, the fictional shop might filter Category to show only Stationery items. The Bottle row would be hidden from the view, but its record still belongs to the dataset.
Students should understand that filtering is not deleting. It is a way of selecting which data are visible for inspection.
A total based on the entire range may still include hidden rows depending on the formula. The student must understand what the task asks and verify the calculated result.
After filtering, confirm that the displayed selection actually matches the criteria.
Data Validation: Prevent Predictable Input Errors
Data validation applies rules to allowable input. A quantity cell might be required to contain a whole number within a specified range.
The K237 syllabus includes setting validation criteria and displaying custom error messages when invalid input is entered.
The purpose is to reduce avoidable input mistakes. For example, entering the word “twelve” into a column expected to contain numeric quantities may interfere with calculations.
Validation is not proof that all entered data are true. A number can satisfy the validation rule and still be factually incorrect.
Good design combines appropriate restrictions with verification of meaning.
Conditional Formatting: Highlight Relevant Values
The syllabus includes conditional formatting for greater than, less than and equal to conditions, changing fill or font colour.
In the fictional shop, a condition could highlight quantities less than 10, which would flag the Bottle row with eight units.
The formatting should help users notice something meaningful rather than decorate the sheet.
Students should not assume that every complex custom formatting rule is examinable. The official K237 content limits this area to the specified comparisons.
Check the rule itself and its result after changing an input.
Charts: Match the Visual to the Information
The syllabus includes bar, column, pie and line charts, as well as a combination of line and column charts. Students learn to add titles, labels, axes, legends and other relevant elements.
A column chart is useful for comparing revenue by product. A line chart can show changes over an ordered series such as dates. A pie chart can represent parts of a whole when the underlying quantities form an appropriate total.
Choosing a chart because it looks attractive can distort a message. Ask which comparison the reader needs to make.
The graph must be accurate before it can be persuasive.
A Worked Chart Example: Product Revenue
With revenues of $54, $36, $72 and $45, a column chart can compare the four products.
The categories should identify Notebook, Pen, Bottle and Folder. The axis should clearly describe the money amount or its suitable unit. A meaningful title could be Revenue by Product — Fictional Practice Data.
A pie chart could represent the proportions of the same $207 total, provided the data are appropriate and the chart does not introduce overlapping categories.
The proportions are approximately 26.1%, 17.4%, 34.8% and 21.7%, respectively. Minor differences in rounded totals reflect display rounding.
A student should not put unit prices into the same revenue chart without clear distinction; they are different quantities.
Combination Charts: When Two Series Have Different Roles
The syllabus permits a line-and-column combination chart.
For a fictional month-by-month study, columns might display total registrations while a line shows another related measure, such as average satisfaction, using suitable axes and labels.
The student should not imply that two quantities share a unit merely because they appear together. If different axes are needed, they must be labelled correctly and interpreted cautiously.
Combination charts can help compare patterns, but they can also mislead when scales exaggerate relationships.
A sensible practice task asks what each series measures and whether the chart provides a fair representation.
Formula Auditing: Make the Hidden Logic Visible
A cell may display 207, but that tells us little about how it was calculated. The value could be typed manually, derived from the correct range or produced by a flawed formula that coincidentally returns the expected total.
SEAB includes the ability to display formulas. Students should learn to inspect the expression rather than trust the visible result.
One audit method checks whether the correct ranges and conditions appear, then changes a controlled input to see whether the result updates correctly.
A spreadsheet is reliable when its logic is reliable, not merely when its first output looks plausible.
Common Error 1: The Formula Does Not Include Every Row
=SUM(E2:E4) excludes E5 even though the question asks for all four products.
Repair by identifying the full dataset and checking the range endpoints.
Common Error 2: An Absolute Reference Was Not Fixed
A shared percentage in G1 becomes G2 or G3 when the formula is copied down.
Repair using $G$1 where the same input must remain fixed, and verify the copied formula.
Common Error 3: The Wrong Logical Operator Is Used
AND is substituted for OR, changing which rows qualify.
Repair by translating the condition into ordinary language before writing the formula.
Common Error 4: A Lookup Uses the Wrong Column
VLOOKUP returns a product name instead of the price because the column index is incorrect.
Repair by counting columns within the selected table range, not across the entire worksheet.
Common Error 5: Lookup Matching Is Not Exact
A code lookup produces an unexpected result because the function’s match setting does not enforce exact matching.
Repair by using the specified exact-match option and testing a known identifier.
Common Error 6: COUNT Is Used for Text Names
COUNT returns zero or too few because the intended cells contain text rather than numbers.
Repair by choosing COUNTA for non-empty entries or COUNTIF for an explicit condition.
Common Error 7: Sorting Breaks the Records
The price column is sorted independently, separating prices from their product names.
Repair by sorting the entire relevant dataset so rows remain intact.
Common Error 8: A Graph Has Unclear Units
A chart is visually attractive but cannot be interpreted because it lacks meaningful axis information or data labels.
Repair with appropriate chart type and titles.
Common Error 9: Date-Like Text Is Not a True Date
DAYS or another function behaves unexpectedly because a cell is stored as text or uses the wrong date order.
Repair by inspecting the date value and applying the requested date format.
Common Error 10: The Workbook Is Not Saved Correctly
The practical task may be technically completed, but the required file is absent or saved in the wrong location.
Repair by practising the school’s permitted file submission procedure. Paper 2’s allotted time includes saving required soft copies.
The Difference Between a Working File and a Submitted File
The examination assesses actual digital work. A candidate should understand which file contains the finished answer and how that file must be saved under the examination rules.
A working file may contain incomplete stages, while the final submitted soft copy must satisfy the task’s requirements. The exact naming and saving rules come from the paper and examination centre.
Do not invent an external upload service or assume cloud saving is allowed. Follow the authorised workflow and verify the file after saving if permitted.
File-management discipline is a practical computing skill, not just an administrative afterthought.
The Fencing Method for Spreadsheet Mastery
The eduKateSG Fencing Method introduces complexity gradually.
Begin with one formula and two referenced cells. Next, copy it down a table. Add a fixed reference, then a logical condition, a conditional sum and a lookup.
After those foundations are secure, add charts, validation, sorting and an unfamiliar task that requires combining skills.
The learner should not depend on a tutor to name which function to use. Mastery becomes visible when the student can translate a new information problem into the appropriate spreadsheet operation.
A Four-Week K237 Spreadsheet Revision Plan
Week 1: Build the Calculation Foundation
Enter a clean fictional dataset, use arithmetic formulas, copy relative references and practise absolute references. Check automatic recalculation.
Week 2: Learn Function Families
Work with SUMIF, COUNTIF, AVERAGEIF, IF, logical functions, ranking and text extraction. Group functions by their purpose rather than alphabetically.
Week 3: Lookups, Dates and Data Presentation
Use a small exact-match lookup table. Practise sorting without breaking records, filtering, validation and appropriate charts. Check common errors.
Week 4: Simulate a Practical Task
Complete an original timed spreadsheet exercise involving formulas, functions, formatting and a chart. Save the final file through a school-approved method and review the error log.
This is a starting cycle, not a guarantee of any grade or an attempt to predict the official lab task.
Parents and Tutors: What to Ask
Ask the student, “What should this cell calculate?”, “Why is that reference fixed?”, “Which range contains the right records?” and “What changes when I edit an input?”
These questions reveal understanding more clearly than asking the learner to list every formula name.
Encourage the child to practise with fictional or non-sensitive data. Do not upload personal records or confidential school information to an unfamiliar online service for convenience.
The broader eduKateSG 3-pax teaching approach emphasises visible reasoning and independent correction. Specialist Computing instruction should use the approved software and authentic K237 requirements; extra tuition is optional when school practice is sufficient.
Frequently Asked Questions
Is spreadsheet work examined in G2 Computing K237?
Yes. It is Module 4, assessed in Paper 1 and the Paper 2 lab examination.
How much of Paper 2 is allocated to spreadsheets?
Approximately 25 marks out of the 80-mark practical paper, according to the 2027 syllabus.
How much is Paper 2 worth overall?
50% of the subject grade, with 2 hours 15 minutes for three compulsory lab tasks.
Is Excel the only possible spreadsheet software?
The centre provides approved software. Follow the current SEAB and school instructions. This article uses Excel-style notation for teaching.
Does the syllabus include VLOOKUP and HLOOKUP?
Yes, including exact matching, along with INDEX and MATCH.
Are IF and nested IFs examinable?
Yes. The syllabus specifies IF with up to one level of nested IFs, alongside AND, OR and NOT.
Are SUMIF, AVERAGEIF and COUNTIF included?
Yes. They are among the listed conditional functions.
Are text functions included?
Yes. LEFT, MID, RIGHT, LEN, CONCAT, FIND and SEARCH are specified.
Do dates appear in spreadsheet tasks?
The syllabus includes TODAY, NOW and DAYS, plus specified date formatting.
Does conditional formatting include every advanced rule?
The listed 2027 content limits it to comparisons of greater than, less than and equal to.
Is a chart enough if its data are wrong?
No. Correct relationships, range selection and meaningful presentation all matter.
Can candidates submit files after the allotted time?
The 2027 syllabus states the Paper 2 time includes saving required work. Follow the examination centre’s instructions; do not assume extra submission time.
Will Scratch be in the same lab paper?
Paper 2 also includes Programming, alongside Media Software and Spreadsheets. The exact programming task follows the 2027 K237 syllabus.
Official Sources and Connected Guides
- SEAB 2027 G2 Computing K237 syllabus — printed pages 4 and 6–8 detail Paper 2 and Module 4 functions.
- SEAB G2 subject syllabuses for 2027.
- How G2 Computing Works | SEC Guide — the six-module overview.
- How G2 Computing Paper 2 Lab Practical Works | SEC Examination Preparation — all three practical tasks.
- How G2 Mathematics Real-World Problem Solving Works | SEC Guide — modelling, rates and interpretation.
- The eduKateSG Clementi first-principles tutorial reference — controlled practice, diagnosis and independent application.
Final Takeaway: Learn the Model, Not Just the Menu
K237 G2 Computing spreadsheet questions assess the ability to build functioning digital calculations, select appropriate functions and present reliable results. The 2027 SEC requires this knowledge in theory and practical work, with approximately 25 spreadsheet marks in Paper 2.
A student who can explain why a formula uses a particular range, fixed cell or lookup method is better prepared than one who simply memorises menu clicks. Practice should end with a working, checked and correctly saved file under the official examination rules.
*2027 syllabus and function list checked against SEAB on 13 November 2026. Every price, product and dataset in this guide is original fictional teaching material, not actual commercial data.*