Collecting data is only half the job. A screen full of raw numbers means nothing until you organise it, run the calculations, and turn it into a graph that reveals the trend. Technology does all of this in seconds — spreadsheets crunch the numbers, graphs expose the patterns, and computer models let you simulate what you can’t measure. Here’s how each one earns its place.
📘 What you need to know
Technology helps process, analyse and interpret data efficiently as investigations get more complex
Spreadsheets (e.g. Excel, Google Sheets) organise, manipulate and visualise data
They automate calculations — averages, gradients, uncertainties, error propagation — using built-in formulas
Statistical functions help identify trends and reduce random uncertainty
Graphs make complex data readable: line graphs and scatter plots show trends and correlations; bar charts and pie charts aid comparison
Computer modelling simulates real-world phenomena, letting you test conditions that are unsafe, too large, or too small for a lab
Modelling saves time and resources and lets you test and refine theoretical predictions
Using Spreadsheets to Manipulate Data
Spreadsheets are the everyday workhorse for processing physics data. Their power comes in three layers: getting the data in order, doing calculations on it, and turning it into visuals.
organise (rows & columns)
→ then →
manipulate (formulas)
→ then →
visualise (graphs)
Layer
What it does
Why it helps
Data organisation
Input raw data into columns and rows, categorised by parameter
Keeps trials consistent and easy to navigate
Data manipulation
Calculate averages, gradients, uncertainties and error propagation; apply statistical functions; automate with formulas
Fast, repeatable, and reduces random uncertainty by spotting trends
Data visualisation
Generate graphs and charts directly from raw or processed data
Reveals trends, patterns and correlations at a glance
The single biggest win of a spreadsheet is that you write a formula once and drag it down a whole column. Repeat a calculation for fifty readings by hand and you’ll make a slip somewhere; a spreadsheet applies the exact same rule to every row, so it’s faster and more reliable. That’s the “reduces human error” mark in a nutshell.
Representing Data Graphically
A graph turns a wall of numbers into a shape your eye can read instantly. The exam wants you to know why graphs help and which type suits which job.
🧭 Why represent data graphically?
Simplifies complex data — a trend that’s invisible in a table jumps out in a graph
Reveals trends and correlations — line graphs and scatter plots show how one variable depends on another
Makes comparison easy — bar charts and pie charts let you compare categories or proportions at a glance
Choosing the right chart is a small decision that carries real information about your data. Here’s the quick guide:
Match the chart to the question: line/scatter for how two variables relate, bar for comparing categories, pie for proportions.
Quick recap: spreadsheets organise → manipulate → visualise, automating calculations and cutting human error; graphs make data readable — line/scatter for trends, bar for comparison, pie for proportions.
Using Computer Modelling
When an experiment is too dangerous, too big, too small, or simply impossible to run for real, physicists turn to computer modelling. A computational model simulates a real-world system so you can explore it safely and cheaply.
Application
Example
Large-scale systems
Climate change, earthquake response of buildings, orbital mechanics
Lab-scale setups
Oscillations of a spring–mass system with variable damping or resistance
Virtual experiments
Testing a wide range of conditions quickly and safely
🧭 Advantages of computer modelling
Saves time and resources compared with purely experimental approaches
Explores the impossible — scenarios too dangerous, large, or small to do in a lab
Tests and refines theory — lets you check models and improve theoretical predictions
Remember the limit from the last page: a model is only as trustworthy as the assumptions behind it. Modelling is powerful for exploring and predicting, but a simulation that’s built on a flawed model gives confident-looking nonsense. If a question asks you to evaluate one, that’s the point to raise.
WE 1
A student records 40 readings of current and voltage for a component. State two ways a spreadsheet helps them process this data, and explain each.
Way 1 — automated calculations
enter a formula once and apply it to all 40 rows
the same rule is used every time, so it’s fast and consistent
→ reduces human error and saves timeWay 2 — graphing
generate a graph of voltage against current directly from the data
the trend (and gradient, e.g. resistance) becomes visible immediately
→ reveals the relationship at a glance
WE 2
A physicist wants to study how a building would respond to a large earthquake. (a) Explain why a computer model is used instead of a physical experiment. (b) State one limitation of relying on the model.
Part (a) — why model it
a real earthquake test would be dangerous, enormously expensive, and impractical
a model lets you simulate the scenario safely and cheaply
and vary conditions to test many cases quickly→ explores what can’t be done in a labPart (b) — a limitation
the model’s accuracy depends on its assumptions
→ a flawed model gives unreliable predictions
💡 Top tips
Spreadsheet = organise, manipulate, visualise. Naming the three roles shows you understand the full workflow
The “write once, apply to all rows” point is the cleanest way to justify reduced human error
Match the chart to the data: line/scatter for relationships, bar for comparisons, pie for proportions
When evaluating a model, mention its assumptions — that’s usually where the limitation mark lives
⚠ Common mistakes
Describing a spreadsheet as just a table — its value is the automated formulas and graphs
Choosing the wrong chart type, e.g. a pie chart for a trend that needs a line graph
Presenting a simulation as certain — always flag that it depends on the model’s assumptions
Listing one benefit when the question asks for two distinct ones
That completes Tool 2: Technology — and with it, the experimental toolkit. You can now collect data with sensors, loggers and video, then process it with spreadsheets, graphs and models. These are exactly the skills your Internal Assessment rewards, so bring them into your own investigation wherever they fit.
Want this to actually click before the exam?
Book a free meeting and let’s work through the tricky bits together.
