Spreadsheets for Decision Making

Select a course.

arrow_back

infoWhy this? Spreadsheet models turn collected data into useful evidence for answering questions and making decisions. Formulae, validation, visualisation, and critical evaluation allow us to analyse accurately while recognising how poor data, weak assumptions, or misleading presentation can undermine conclusions.

scheduleWhy now? Following algorithmic thinking, spreadsheets provide an immediate context for applying logical precision, testing calculations, and diagnosing errors. They also establish practical data-handling and visualisation skills that can be used across subjects and developed in later computing units.

A cell reference identifies a specific location such as B4.
Spreadsheet formulas start with an equals sign.
Rows, columns, labels, and values make spreadsheet models easier to read and reduce input errors.
Data can be collected from known users through structured forms or surveys to answer specific questions.
Functions such as SUM, MIN, MAX, and AVERAGE automate common calculations.
Order of operations affects spreadsheet calculation results.
Relative references change when copied to another cell.
Absolute references remain fixed when copied using dollar signs.
Validation rules restrict invalid data entry.
Conditional formatting highlights values that meet criteria.
Errors such as #DIV/0! indicate invalid calculations or inputs.
Chart choice depends on the question being answered by the data.
Axis scales can distort interpretation if chosen poorly.
Analysis should answer a defined question for a known audience.
Model outputs are only as reliable as assumptions and input data.

rocket_launchYou must be able to

Build a structured spreadsheet model with clear labels and units.
Use formulas, functions, and references accurately.
Select and justify charts that communicate findings honestly.
Collect and analyse data from known users to answer a defined question.

Curriculum Portal