Modelling
Learn the core concepts and decision-making in Cambridge 9626 Topic 9, then practise recall, application and transfer with fictional scenarios.
Exam scope and assessment notes
This is original StudyForA teaching and fictional practice based on Cambridge syllabus outcomes, not copied syllabus text, an official question, a required software brand or a Cambridge mark scheme. Practical software tasks here are planning and reasoning exercises; StudyForA does not inspect files created in spreadsheet, database, graphics, audio/video or animation software, simulate the practical exam environment, award official marks or predict a grade. Follow the software and file-format requirements issued by your centre for your exam year.
Before you begin
- Check whether your route is AS Level (Topics 1–11) or full A Level (Topics 1–21).
Work on paper. Try each question before revealing help, and explain why your method works.
Quick readiness check
Before Topic 9: modelling
What you will learn
- Explain what-if analysis, scenario changes and goal seek
- Use models for financial forecasts, population, climate, weather, queues, traffic and construction
- Explain the need, features and limits of computer models and spreadsheet models
- Evaluate simulations for disaster planning, pilot training, driving and scientific research
A model represents a real system for a purpose
A model simplifies reality by selecting variables, relationships and assumptions. What-if analysis changes inputs to predict outcomes; scenarios compare sets of assumptions; goal seek finds an input that produces a target output. Models can explore unsafe, expensive or long-term situations, but forecasts are only as good as their data and assumptions.
Test sensitivity and communicate uncertainty
A spreadsheet can make assumptions visible and allow quick recalculation, but large or dynamic systems may exceed its structure. Check formulas, units, boundaries and sensitivity: a small input change can have a large effect. Compare predictions with observed outcomes when possible and state where the model is unsuitable. A simulation helps investigate possibilities; it does not prove what will happen.
Sources for this lesson
Pause and explain
Which approach best demonstrates secure, reliable IT practice in modelling?
Worked example
A school models queue length at lunch using arrivals per minute and service rate. What inputs should be varied and what should be checked before using its prediction?
Show the worked solution
- Vary arrival patterns, service rate, opening times and number of counters.
- Check the model against observed queue lengths over representative days.
- State limits such as special events, breakdowns or unequal service times.
Answer The model should vary arrival rates by time, service rates, number of counters and opening arrangements. Compare predictions with measured queues on different ordinary days and busy days. Check assumptions such as independent arrivals and equal service times. Use the result as a planning aid, not a promise, and state conditions the model does not represent.
Try a topic test
Choose Easy, Normal or Difficult. Save your answers and open worked review after finishing.
Test this topic →From guided practice to a new situation
Write your answer and reasoning first. Use a hint only if you are stuck. The model solution is for self-checking; your written work is not automatically marked.
A savings model shows the target is reached in 10 years. Which inputs could goal seek solve for, and what assumptions must be disclosed?
Give me a hint
The target is known; one variable can be adjusted to find the required value.
Compare my reasoning
- Set the target cell to the savings goal.
- Choose an input such as monthly contribution or annual return.
- Disclose inflation, fees, contribution timing and return assumptions.
Goal seek can set the projected balance cell to the target and vary the monthly contribution, return rate or time, one at a time. The result depends on contribution timing, fees, taxes, inflation and whether returns are constant. State these assumptions and test alternative rates; the model cannot guarantee investment returns.
Look for these in your work
- Identifies goal seek structure
- Chooses an adjustable input
- States material assumptions
A flood model estimates water depth but has no recent rainfall or elevation data. What is the main limitation and response?
Give me a hint
Consider input quality before discussing the sophistication of the software.
Compare my reasoning
- Identify how missing/stale data affect the prediction.
- Obtain or estimate inputs with documented uncertainty.
- Run scenarios and avoid overconfident claims.
The model may be precise-looking but unreliable because key inputs are stale or absent. Obtain suitable rainfall and elevation data, document resolution and uncertainty, test against known events, and run a range of scenarios. Decision-makers should not treat a single output as a guaranteed flood depth.
Look for these in your work
- Connects data quality to model quality
- Proposes validation and scenarios
- Communicates uncertainty
A driving simulator is used to practise emergency braking. Explain one benefit and one limit compared with a real car.
Give me a hint
Balance safe repeatable practice with the fidelity of the simulation.
Compare my reasoning
- Explain a risk or cost avoided by simulation.
- Identify physical or sensory details it may not reproduce.
- Use real-world instruction for transfer and safety.
A simulator lets learners repeat dangerous situations without risking collisions and can vary conditions consistently. It may not reproduce real vehicle forces, road surfaces, stress or every hazard, so skill transfer can be incomplete. It should complement supervised real driving rather than replace safety instruction.
Look for these in your work
- Gives a scenario-specific benefit
- States a fidelity limit
- Explains the role of real-world practice
Common mistakes
- Treating an output as a fact rather than a conditional prediction
- Changing several inputs without recording which caused an effect
- Ignoring validation against real observations
What can you explain now?
A savings model shows the target is reached in 10 years. Which inputs could goal seek solve for, and what assumptions must be disclosed?
Compare with the explanation
Goal seek can set the projected balance cell to the target and vary the monthly contribution, return rate or time, one at a time. The result depends on contribution timing, fees, taxes, inflation and whether returns are constant. State these assumptions and test alternative rates; the model cannot guarantee investment returns.
The target is known; one variable can be adjusted to find the required value.
After trying it yourself, choose your next review. This is your self-assessment.
Your review choice appears on Today. Sign in to sync it across devices.
Make it stick
What does a model output mean when its assumptions are changed?
If you needed the solution, close it and solve the problem again from a blank page. A correct answer is stronger when you can explain the reason for each step.