H2 Physics Paper 4 Spreadsheet Skills (9478 Syllabus 2026): Excel Guide for Practical

Study guideUpdated 17 Jul 2026
Chee Wei Jie
Reviewed by
Chee Wei Jie·Academic Advisor (Physics)
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 9749 to 9478 for examinations from 2026. The most significant practical change: Paper 4 now requires spreadsheet software for data processing, graph plotting, and analysis.

FeatureOld syllabus (9749)New syllabus (9478)
Graph plottingManual on graph paperSpreadsheet (Excel or equivalent)
Data processingCalculator + manual tablesSpreadsheet formulas
Gradient extractionRuler + best-fit lineLINEST / trendline equation
Uncertainty estimationManual calculationLINEST standard error
Paper 4 duration2 h 30 min2 h 30 min (unchanged)
Paper 4 marks5550
Paper 4 weighting20%20% (unchanged)

Students no longer need to plot graphs on graph paper. All graph work is done in the spreadsheet.


Paper 4 structure under 9478

Paper 4 assesses four skill strands:

StrandWhat it coversWeighting
Planning (P)Designing an experiment, identifying variables, hazard assessment4% of subject
MMOManipulation, Measurement, ObservationPart of 16%
PDOPresentation of Data and Observations (tables, graphs, spreadsheet output)Part of 16%
ACEAnalysis, Conclusions, Evaluation (gradient, intercept, percentage difference, sources of error)Part of 16%

The spreadsheet skills are primarily tested in PDO and ACE, but you will also use the spreadsheet for data manipulation in MMO tasks.


Required spreadsheet skills

SEAB's Excel Reference Guide is provided during the exam. You should be fluent in every function it covers.

1. Data entry and formatting

  • Open and import external data files in .xlsx or .csv format
  • Input raw data from experiments with correct precision (e.g., length to 0.1 cm, voltage to 0.01 V)
  • Create headers with quantity and unit in the format Quantity / Unit (e.g., Current / A, Time / s)
  • Format cells to display the correct number of significant figures or decimal places

2. Formulas and calculations

You must be able to use spreadsheet formulas for:

  • Basic arithmetic: addition, subtraction, multiplication, division
  • Powers and roots: ^ operator, SQRT()
  • Trigonometric functions: SIN(), COS(), TAN() and inverses ASIN(), ACOS(), ATAN() - note these use radians by default
  • Logarithms: LN() (natural log), LOG10() (base-10 log)
  • Exponentials: EXP()
  • Scientific notation: entering and displaying values in standard form
  • Absolute and relative cell references: AA1 vs A1

3. Graph plotting

  • Create an XY scatter chart from two columns of data
  • Add axis labels with quantity and unit (e.g., Voltage / V)
  • Add a best-fit trendline (linear, polynomial, or other as appropriate)
  • Display the trendline equation on the chart (e.g., y = 2.34x + 0.12)
  • Adjust axis scales for appropriate display
  • Plot error bars if required

You are not expected to manually draw best-fit lines. The spreadsheet does this for you.

4. Gradient and intercept extraction

This is the most important new skill. Instead of drawing a best-fit line and measuring the gradient with a ruler, you use:

LINEST function:

=LINEST(known_y_values, known_x_values, TRUE, TRUE)

This returns an array containing:

  • Gradient (slope)
  • Y-intercept
  • Standard error of gradient
  • Standard error of intercept
  • R-squared value

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:

  1. 9478 Syllabus document - Section on "Requirements on Use of Spreadsheet for Practical Assessment"
  2. Specimen Paper 4 - see how spreadsheet tasks are phrased in actual exam questions
  3. SEAB Excel Reference Guide - the 4-page reference provided during the exam

Step 2: Practise with real data

Do not just learn the functions abstractly. Practise by:

  1. Taking measurements from an actual lab session (e.g., voltage-current for a resistor)
  2. Entering the data into a spreadsheet
  3. Creating a scatter chart with trendline
  4. Using LINEST to extract gradient and standard error
  5. 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

  1. Wrong angle unit. SIN(), COS(), TAN() in Excel use radians, not degrees. If your data is in degrees, convert first: =SIN(RADIANS(A1)).
  2. 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.
  3. Wrong precision in headers. Write Length / cm, not Length (cm) or Length. SEAB expects the / format.
  4. Not displaying enough decimal places. Format cells to show the appropriate number of significant figures. Do not let Excel round your data.
  5. Forgetting to label axes. Spreadsheet charts default to no axis labels. Always add Quantity / Unit labels to both axes.
  6. 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.

See our H2 Physics practical guide for the full registration timeline and practical requirements.

For a comprehensive overview of H2 Physics Paper 4 preparation, see our H2 Physics Practical 2026 Lab Mastery Guide.

For a narrower drill on transformed graphs and time constants, continue to H2 Physics Spreadsheet Linearisation: ln Graphs, Trendlines and Time Constants.


References

Want supervised lab practice?

Explore practical lessons, with timings, fees, and locations on the programme page.

View H2 Physics Practicals (Labs & Experiments)