DIT5 · Calculations 1 / Calculations 2 / Conditions 1 / Conditions 2 Processing data with spreadsheets mind map
Use your browser’s Print command for A4 landscape, or choose A3 in its paper settings. The SVG remains sharp when enlarged. A text version follows the map.
Read the mind map as text
Calculations 1
Original practice dataset: Three invented records; retain raw input
Import and split: Preview import; verify rows and types
Arithmetic formulae: Formulae calculate; formatting does not
Calculations 2
Summary functions: SUM, AVERAGE, MIN and MAX with ranges
Cell references: Relative moves; dollars fix rows or columns
Sorting and filtering: Sort complete records; filter selected records
