← Computer Science syllabus

SingaporeComputer Science

Spreadsheets and Data Processing

5 dot points across 5 inquiry questions. Click any dot point for a focused answer with worked past exam questions where available.

How do we turn rows of data into a clear chart, and find the rows we want?

Choose an appropriate chart type for data, and use sorting and filtering to organise and find records
A focused answer to the O-Level Computing point on presenting data. Choosing a suitable chart (bar, line, pie), sorting records into order, and filtering to show only the rows that meet a condition.
6 min answer →

How do built-in functions like SUM and AVERAGE save work over long formulae?

Use common spreadsheet functions (SUM, AVERAGE, MAX, MIN, COUNT) with cell ranges to summarise data
A focused answer to the O-Level Computing point on spreadsheet functions. Using SUM, AVERAGE, MAX, MIN and COUNT with cell ranges to summarise data, and the colon range notation.
6 min answer →

How can a spreadsheet make decisions and look up values from a table?

Use the IF function for conditional results and lookup functions such as VLOOKUP to find values in a table
A focused answer to the O-Level Computing point on logical and lookup functions. Using IF for conditional results, nesting IF for grades, and VLOOKUP to find a matching value in a table.
7 min answer →

Why do some cell references change when copied and others stay fixed?

Distinguish relative and absolute cell references, use the dollar sign to fix a reference, and predict how references change when a formula is copied
A focused answer to the O-Level Computing point on cell references. How relative references change when copied, how absolute references with a dollar sign stay fixed, and how to predict the result of copying a formula.
6 min answer →

How is a spreadsheet organised, and how do formulae let it recalculate automatically?

Describe how a spreadsheet is organised into cells, rows and columns, and write formulae using cell references and operators
A focused answer to the O-Level Computing point on spreadsheet basics. Cells, rows and columns, cell references, writing formulae with operators, and why formulae recalculate automatically when data changes.
6 min answer →