A comprehensive set of basic statistical tests in one spreadsheet. Includes: distribution checker (check whether data is normally distributed), standard error and confidence limits, student’s t-test, chi squared test, Spearman and Pearson correlations. The first sheet has a decision tree to help decide which type of analysis is most appropriate for the data. Simply follow the decision tree and click the link to jump to the relevant sheet for that test. The spreadsheet is built in Apple’s Numbers application (iOS, iPadOS and macOS).

Poster about NASA’s Hubble Ultra Deep Field image produced in 2003-2004. Gives a great context for discussing the scale of the Universe. Suitable for a range of science and physics specifications across age ranges.

Worksheet for practicing drawing and analysing log graphs. There are two log graphs to plot and analyse. The first data set is from the oscillations of a mass-spring system and requires a log base 10 graph. The second data set is from a capacitor discharge experiment and requires a natural log graph. The first two pages include the activity for students to complete, the third and fourth pages are the solutions. Suitable for AQA and OCR Physics A AS-Level and A-Level specifications. (7407, 7408, H156, H556) This is part of a series of worksheets for practicing different graph skills. If you prefer, you can purchase this in a bundle of Graph Skills worksheets 1-6 here (at a discount): https://gum.co/KBWAH This worksheet is great for home learning since it has solutions to all questions included in the document and it is part of a series that gradually builds up a range of graphing techniques.

Copy of the spreadsheet that can be used to analyse gas pressure and volume data to investigate Boyle’s Law. This is a Numbers spreadsheet. It is possible to convert Numbers spreadsheets to Excel files but I cannot guarantee an easy to use output since the tables may be converted to separate worksheets in the Excel file. Suitable for most A-level physics specifications.

Copy of the spreadsheet that can be used to analyse the heat capacity experiment in this video. This is a Numbers spreadsheet. It is possible to convert Numbers spreadsheets to Excel files but I cannot guarantee an easy to use output since the tables may be converted to separate worksheets in the Excel file. Suitable for most A-level physics specifications.

A poster illustrating the principal bodies of our Solar System. The Sun is shown with the planets in their respective orbits around it. Data is given on the Sun and each planet including: mass, diameter and mean orbit radius around the Sun. Two additional graphics show the orbits to relative scale and the Sun and planet diameters to relative scale. Suitable for A-Level physics specifications: AQA and OCR Physics A AS-Level and A-Level specifications. (7407, 7408, H156, H556)

Revise the key concepts of the photoelectric effect with these two sorting activities. Activity 1 reinforces the relationship between colour, wavelength and photon energy for visible photons. Activity 2 extends activity 1 by introducing differences in intensity. Included in this bundle are: Sorting cards for both activities (PDF files). On page two are optional header columns to help students structure their solutions. Presentation files for teachers to project the correct solutions to the class (a Keynote file for Mac/iOS users and PowerPoint file for Windows users). Suitable for A-Level physics specifications: AQA and OCR Physics A AS-Level and A-Level specifications. (7407, 7408, H156, H556)

This spreadsheet looks up steam properties for a specified temperature or pressure. It is based on data from the NIST steam tables. The spreadsheet automatically handles interpolation on the temperature and pressure sorted tables. It also handles double interpolation on the superheated steam tables. In order to use the lookup tables the database first needs to be populated with freely available NIST data - I do not sell that data or claim any copyright on it. The data is included for free in a spreadsheet with the correct layout ¹. Download the data and populate the database tables in this spreadsheet before use. ¹ Filename: Steam table lookup - file 2 - database (free) This is a Numbers (Apple spreadsheet) spreadsheet. It is possible to convert Numbers spreadsheets to Excel files but I cannot guarantee an easy to use output since the tables may be converted to separate worksheets in the Excel file. You can use Numbers spreadsheets on iPhones, iPads, Mac computers and in a web browser.

A poster illustrating the main features of the Hertzsprung-Russell diagram (luminosity and temperature scales) including main sequence, red giants, white dwarfs, young and old clusters and evolution progression for a star like the Sun. Suitable for A-Level physics specifications: AQA and OCR Physics A AS-Level and A-Level specifications. (7407, 7408, H156, H556)

Differentiated activity for practicing drawing curved graphs. There are four curves to plot and draw, which includes choosing the scale on the y-axis. The four graphs are gas pressure and volume, gravitational field strength, radioactive activity and capacitor charging. The first two pages include the activity for students to complete, the third and fourth pages are the same activity but designed for more able students to complete, the final two pages are the solutions. Suitable for AQA and OCR Physics A AS-Level and A-Level specifications. (7407, 7408, H156, H556) This is part of a series of worksheets for practicing different graph skills. If you prefer, you can purchase this in a bundle of Graph Skills worksheets 1-6 here (at a discount): https://gum.co/KBWAH This worksheet is ideal for home learning since it has solutions to all questions included in the document, it is part of a series that gradually builds up a range of graphing techniques and it includes an extension version of the tasks to challenge more able students.

Copy of the spreadsheet I used to analyse the Young’s Modulus experiment in my video on the experiment. Now included: a version 2 of the spreadsheet with improved formatting. But note that in order to achieve the neater formatting it is necessary to use more advanced formulae which will make it harder for spreadsheet novices to understand the calculations (especially around indices). Both versions are included to give the user the option of which one to use. This is a Numbers spreadsheet. It is possible to convert Numbers spreadsheets to Excel files but I cannot guarantee an easy to use output since the tables may be converted to separate worksheets in the Excel file. Suitable for most A-Level Physics specifications.

Copy of the spreadsheet I used to analyse the pressure law experiment in this video. This is a Numbers spreadsheet. It is possible to convert Numbers spreadsheets to Excel files but I cannot guarantee an easy to use output since the tables may be converted to separate worksheets in the Excel file.

Copy of the spreadsheet I used to analyse the current balance experiment in this video. This is a Numbers spreadsheet. It is possible to convert Numbers spreadsheets to Excel files but I cannot guarantee an easy to use output since the tables may be converted to separate worksheets in the Excel file.

Copy of the spreadsheet I used to analyse the resistivity experiment in this video. This is a Numbers spreadsheet. It is possible to convert Numbers spreadsheets to Excel files but I cannot guarantee an easy to use output since the tables may be converted to separate worksheets in the Excel file.

Activity for practicing drawing tangents on curved velocity-time graphs and calculating gradient values for those tangents in order to calculate acceleration values. The first page includes the activity for students to complete and the second and third pages includes solutions to the questions. Suitable for AQA and OCR Physics A AS-Level and A-Level specifications. (7407, 7408, H156, H556) This is part of a series of worksheets for practicing different graph skills. If you prefer, you can purchase this in a bundle of Graph Skills worksheets 1-6 here (at a discount): https://gum.co/KBWAH This worksheet is great for home learning since it has solutions to all questions included in the document and it is part of a series that gradually builds up a range of graphing techniques.

Activity for practicing plotting graph data points on log graphs, drawing a line of best fit, calculating a gradient and analysing the line in order to calculate quantities. There are two log graphs to plot and analyse. The first data set is from the oscillations of a mass-spring system and requires a log base 10 graph. The second data set is from capacitors in series and requires a natural log graph. Suitable for AQA and OCR Physics A AS-Level and A-Level specifications. (7407, 7408, H156, H556) This is part of a series of worksheets for practicing different graph skills. If you prefer, you can purchase this in a bundle of Graph Skills worksheets 1-6 here (at a discount): https://gum.co/KBWAH This worksheet is great for home learning since it has solutions to all questions included in the document and it is part of a series that gradually builds up a range of graphing techniques.

A poster showing the base units of the SI units system and derived units. The relationship between base and derived units is shown in a mind map layout. Paper size: A3 Suitable for AQA and OCR Physics A AS-Level and A-Level specifications. (7407, 7408, H156, H556)

A poster showing the base units of the SI units system and derived units. The relationship between base and derived units is shown in a mind map layout. Paper size: A3 Suitable for AQA and OCR Physics A AS-Level and A-Level specifications. (7407, 7408, H156, H556)

Activity for practicing plotting graph data points, drawing a line of best fit, calculating a gradient and analysing the line in order to calculate quantities. The first page includes the activity for students to complete and the second page includes solutions to the questions. Suitable for AQA and OCR Physics A AS-Level and A-Level specifications. (7407, 7408, H156, H556) This is part of a series of worksheets for practicing different graph skills. Graphs Skills worksheets 1 & 2 are available for free, subsequent worksheets are premium resources. This worksheet is great for home learning since it has solutions to all questions included in the document and it is part of a series that gradually builds up a range of graphing techniques. 14 September 2024: It was brought to my attention that the data provided an invalid intercept value for analysis if imported into a spreadsheet to compute. I realised that two values for s suffered from typos (u=12 had s=35 and u=14 had s=42). These data give a negative intercept preventing correct analysis. The values have been corrected (u=12 had s=34 and u=14 had s=43). This affected the values in the tables, however, the values plotted on the grid were correct.

Activity for practicing plotting graph data points, drawing a line of best fit and calculating a gradient. The first page includes the activity for students to complete and the second page includes solutions to the questions. Suitable for AQA and OCR Physics A AS-Level and A-Level specifications. (7407, 7408, H156, H556) This is part of a series of worksheets for practicing different graph skills. Graphs Skills worksheets 1 & 2 are available for free, subsequent worksheets are premium resources. This worksheet is great for home learning since it has solutions to all questions included in the document and it is part of a series that gradually builds up a range of graphing techniques.