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

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.

Reviewed by

Chee Wei Jie·Academic Advisor (Physics)

Practical course completion-record note

For practical, lab, and experiment courses, Eclat Institute maintains centre-held attendance records and may also issue an internal attendance or completion document based on participation and internal assessment.

• For SEAB private-candidate declarations, the key evidence is the centre's attendance or completion record, not a government-issued certificate.
• This is an internal centre-issued certificate, not an MOE/SEAB qualification or accreditation.
• Recognition (if any) is determined by the receiving school, institution, or employer.
• For SEAB private candidates taking science practical papers, SEAB states you should either have taken the subject before or attend a practical course and complete it before the practical paper date.

View our sample completion document (Current sample layout (design may be refined over time))