Experiment data files from across the A-level physics course — spreadsheets, write-ups, and reports ready to open in Excel or Google Sheets. Use them as templates, for analysis practice, or to check your own results against.

xlsx

Usain Bolt 100 m Sprint — World Record Analysis

Distance–time and velocity–time data for the 2009 Berlin world record. Good for non-uniform acceleration, instantaneous vs average velocity, and graphical analysis of motion.

↓ Download
xlsx

Jumping Popper

Video analysis of a rubber popper toy — captures the launch phase at high frame rate. Useful for energy conservation, impulse, and projectile calculations.

↓ Download
xls

Popper on Smartphone — Acceleration

Accelerometer data from a phone placed under a jumping popper. Links consumer sensors to Newton's second law and illustrates how to capture rapid acceleration events.

↓ Download
xls

Acceleration Without g

Datalogger results from an Atwood machine. Separates gravitational from measured cart acceleration — explores F = ma without needing to know g in advance.

↓ Download
docx

Load on a Plastic Wire — Extension Graph

Student write-up investigating how load affects extension in a plastic wire, including a graph showing the elastic and plastic regions. Covers Hooke's law and the limit of proportionality.

↓ Download
xlsx

Speed of Sound Using Standing Waves

Resonance tube data at multiple frequencies. Students determine the speed of sound from tube length and wavelength at the fundamental and harmonic frequencies.

↓ Download
xls

Refraction Through a Glass Block

Angle of incidence and refraction measurements for a rectangular glass block. Includes a Snell's law analysis and refractive index calculation with uncertainty treatment.

↓ Download
xlsx

Inverse Square Law — Photocell (I vs d)

Light intensity measured with a photocell at increasing distances from a point source. Demonstrates the inverse square law and includes a log–log plot to confirm the relationship.

↓ Download
xlsx

Internal Resistance of a 9 V Cell

Terminal voltage vs current data for a carbon-zinc 9 V battery. The gradient of the V–I graph gives internal resistance; the y-intercept gives the EMF.

↓ Download
xlsx

Finding Planck's Constant from LEDs

Threshold voltage data for LEDs of known wavelength. Plotting eV against frequency gives a straight line whose gradient is h — a real bench determination of Planck's constant.

↓ Download
pdf

Specific Heat Capacity — Experiment Report

Full lab report for a calorimetry experiment measuring the specific heat of water and lead. Includes method, error analysis, and a candid discussion of systematic errors.

↓ Download
xlsx

Boyle's Law

Pressure and volume data for a fixed mass of gas at constant temperature. A p vs 1/V plot confirms the linear relationship and allows extraction of the constant k.

↓ Download
xlsx

Radiation from Different Surfaces

Cooling curves for containers with matt black, shiny silver, and white surfaces. Good for comparing emissivity and discussing Stefan's law qualitatively.

↓ Download
xlsx

Light Absorption as a Model for X-ray / Gamma Absorption

Intensity data for visible light through increasing thicknesses of absorbing material — an analogy for exponential attenuation in medical imaging and nuclear physics.

↓ Download
xlsx

Radioactive Decay of Protactinium

Count-rate data from a protactinium generator over time. Students plot ln(count rate) vs time to find the decay constant and half-life of Pa-234.

↓ Download
xlsx

Half-Life Dice Analogue

Simulated decay using dice — each roll removes a fraction of the "nuclei." Mirrors real exponential decay and gives intuition for randomness, half-life, and the decay constant.

↓ Download
xlsx

Radioactive Nuclides — Binding Energy

Binding energy per nucleon data for a range of nuclides. Used to plot the binding energy curve, identify the most stable nuclides, and explain fission and fusion energy release.

↓ Download
xlsx

Mass on a Spring — Datalogger

Position vs time trace from a datalogger for a mass oscillating on a spring. Covers period, amplitude, SHM analysis, and energy exchange between kinetic and potential forms.

↓ Download
docx

Experiment Results Template

A general student results write-up template with data tables, graph space, and an analysis section — a useful starting point for any practical report.

↓ Download