TL;DR From 2026, H2 Physics Paper 4 (syllabus 9478) replaces manual graph plotting with spreadsheet-based data analysis. You must be able to import CSV/XLSX data, create labelled graphs with trendlines, extract gradients using LINEST, and calculate areas under curves using trapezoidal summation - all in Excel or equivalent software. SEAB provides a 4-page Excel Reference Guide that you should know inside out.
For the specific linearisation patterns behind ln graphs, power-law plots, reciprocal graphs, RC time constants, and trapezoidal area columns, use the focused H2 Physics spreadsheet linearisation guide.
Quick spreadsheet map
Paper 4 spreadsheet work is part of data analysis, not admin: Set up clean quantity and unit headers.
Graphs, LINEST, and uncertainty are linked: Decide which columns make the graph linear.
A spreadsheet answer still needs physics interpretation: Explain what the gradient or area means.
Concrete example: For an RC discharge, create columns for time and ln voltage, then use LINEST on those columns to find the gradient and its uncertainty.
What changed in the 2026 syllabus
The H2 Physics syllabus changed from
Want supervised lab practice?
Explore practical lessons, with timings, fees, and locations on the programme page.
The Specimen Paper 4 explicitly asks candidates to determine the gradient and its standard error using LINEST. Practise this until it is second nature.
LOGEST function:
For exponential relationships (y = ae^(bx)), use LOGEST instead of LINEST to extract the rate constant and pre-exponential factor.
5. Area under a curve
When the quantity of interest is the area under a plotted curve (e.g., impulse from a force-time graph, work done from a force-displacement graph), use trapezoidal summation:
For each strip between consecutive data points:
Area of strip = 0.5 × (y₁ + y₂) × (x₂ − x₁)
Sum all strips to get the total area. This can be set up as a formula column in the spreadsheet and summed with SUM().
How to prepare
Step 1: Get the official documents
Download and study these three SEAB documents:
9478 Syllabus document - Section on "Requirements on Use of Spreadsheet for Practical Assessment"
Specimen Paper 4 - see how spreadsheet tasks are phrased in actual exam questions
Do not just learn the functions abstractly. Practise by:
Taking measurements from an actual lab session (e.g., voltage-current for a resistor)
Entering the data into a spreadsheet
Creating a scatter chart with trendline
Using LINEST to extract gradient and standard error
Comparing your spreadsheet result with a manual calculation
Step 3: Time yourself
In the actual exam, you will need to perform spreadsheet tasks under time pressure alongside traditional practical work (apparatus manipulation, measurements, planning). Practise switching between the physical experiment and the computer.
Step 4: Learn the exam phrasing
The specimen paper uses specific phrasing like:
"Use a spreadsheet to plot a graph of [Y] against [X]"
"Determine the gradient of the line and its standard error"
"Use your spreadsheet to calculate the area under the curve"
Get familiar with these instruction patterns so you do not waste time interpreting them during the exam.
Common mistakes to avoid
Wrong angle unit.SIN(), COS(), TAN() in Excel use radians, not degrees. If your data is in degrees, convert first: =SIN(RADIANS(A1)).
Forgetting the 4th argument in LINEST. To get standard errors, you must set the 4th argument to TRUE: =LINEST(y, x, TRUE, TRUE). Without it, you only get gradient and intercept.
Wrong precision in headers. Write Length / cm, not Length (cm) or Length. SEAB expects the / format.
Not displaying enough decimal places. Format cells to show the appropriate number of significant figures. Do not let Excel round your data.
Forgetting to label axes. Spreadsheet charts default to no axis labels. Always add Quantity / Unit labels to both axes.
Using the wrong trendline type. A linear trendline on curved data will give a meaningless gradient. Check whether the relationship is linear, quadratic, or exponential before adding the trendline.
For private candidates
If you are a private candidate sitting H2 Physics Paper 4, you need access to a computer with spreadsheet software during your practical training. Supervised lab sessions should include spreadsheet practice alongside traditional apparatus work.
