Unit 1 Spreadsheet Applications
Cells and ranges, formulae and functions, relative and absolute references, IF, VLOOKUP, modelling, charts, validation, printing and macros.
How to study for CCEA GCSE Digital Technology
Connect precise digital concepts to scenario evidence, design decisions, testing and evaluation, then rehearse the controlled-practice lifecycle under your centre's current CCEA instructions.
Core concepts
Concept 1
Spreadsheet formulae calculate from cell references, while relative and absolute references control what changes when a formula is replicated.
Exam cue: Trace the formula with the stated row and column before predicting a copied result.
Concept 2
Functions, IF statements and VLOOKUPs transform data into decisions or retrieved results and must be tested at boundaries.
Exam cue: Lock only the row or column that must remain fixed.
Concept 3
A useful model separates inputs, processing and outputs, uses suitable validation, and presents results in an audience-appropriate chart or print area.
Exam cue: Choose a chart from the comparison, trend or proportion the user needs to see.
Risk pitfalls and guardrails
Putting a calculated value into a cell instead of the formula that produces it.
Guardrail: Keep to Northern Ireland CCEA scope, never add the weights of both routes, and distinguish a digital concept from unsupported product or technology claims.
Using an absolute reference everywhere rather than only where replication requires it.
Guardrail: Keep to Northern Ireland CCEA scope, never add the weights of both routes, and distinguish a digital concept from unsupported product or technology claims.
Selecting a visually elaborate chart that obscures the intended comparison.
Guardrail: Keep to Northern Ireland CCEA scope, never add the weights of both routes, and distinguish a digital concept from unsupported product or technology claims.
Memory anchors
Formula
A spreadsheet expression that calculates a value from data or references.
Relative reference
A reference that adjusts when the formula is copied.
Absolute reference
A reference fixed with dollar signs when a formula is copied.
IF function
A function returning different results according to a logical test.
VLOOKUP
A function retrieving a related value from a vertical lookup table.
Data model
A structured set of inputs, formulae and outputs used to explore outcomes.
Checkpoint rule
Do the check-up only after you can summarize each concept in one sentence and identify one dangerous pitfall from memory.
Knowledge Check (after reading)
Short check-up to confirm understanding of this module.
Check-up Questions
Which entry is a spreadsheet formula?
Cell D2 contains =B2+C2. Copied to D3, what does it become?
Answer all questions to submit.
Next step personalized recommendations
Continue learning
Move forward only after this module is stable.
What is Pass Harbor?
Completely free exam prep for 247 UK exams.
- Practice questions
- Flashcards
- Study guides
- Mock exams
- No registration
- No paywall
- Start instantly
“No more expensive exam prep. Quality study tools should be accessible to everyone.”