# Physics Drill Spreadsheets

Physics Drill Spreadsheets promote mastery of the necessary skills to succeed at GCSE and A Level, whilst reducing the teacher's workload.

Physics Drill Spreadsheets promote mastery of the necessary skills to succeed at GCSE and A Level, whilst reducing the teacher's workload.

43Uploads

7k+Views

7k+Downloads

Physics Drill Spreadsheets promote mastery of the necessary skills to succeed at GCSE and A Level, whilst reducing the teacher's workload.

SALE

Dear Physics Teachers,
These resource will help your students master GCSE and A Level Physics subject knowledge and skills. This is a complete set of simulations and worksheet generators. Using this resource, you will save yourself time making as many worksheets as your heart desires.
How often have you had to tell your students that they need more practice at a particular skill or to acquire some particular knowledge in physics? One day, a student asked me a reasonable question: "where can I get additional questions to practise?" From that simple question spawned my idea to create a series of 'drill spreadsheets'. These worksheet generators can be used be teachers or students to generate thousands upon thousands of unique worksheets. Most of the sheets can be customised for differentiation quickly by toggling a few options.
I wish someone had invented and provided this resource when I started teaching. You do not need to wish, here it is. As I create new drill sheets I'll add them here, so you will always be able to come back and get the latest sheets.
Sheets included in this bundle:
GCSE Physics Formula Drill
GCSE Physics Definitions Drill
GCSE Physics Motion Graphs Drill
GCSE Physics Length, Area and Volume Unit Conversions Drill
GCSE Physics Wave Superposition Drill
GCSE and A Level Physics Resolving Vectors Drill
GCSE Science Command Words Drill
GCSE Mathematics Trigonometry Drill
AS Level Physics Definitions Drill
A Level Physics Definitions Drill
A Level Physics Three Forces in Equilibrium Drill
A Level Physics Projectiles Drill
A Level Physics Momentum Conservation Drill
A Level Physics Stationary Waves Drill
A Level Physics Photoelectric Effect Drill
A Level Physics Kirchhoff's Laws Drill
A Level Physics Electron Beam Drills
A Level Physics Newton's Second Law Drill
A Level Physics Feynman-like Diagrams Drill
A Level Physics Errors Drill
A Level Physics Vernier Caliper Drill
A Level Physics Micrometer Drill
A Level Physics Electric Fields Drill
A Level Physics Gravitational Fields Drill
A Level Physics Diffraction Drill
And more are added frequently (this list might not be up to date!)
These are all available individually, see here for the full selection: http://physicsdrill.wikispaces.com/
The resources all work with MS Excel and other spreadsheet applications. None of them use VBA or other scripting tools, so they should also work on Macs, Android phones and iPhones, amongst other platforms. I have tested most of the sheets on my Android phone and they work fine (using the free WPS app).
If you have any questions, email me at dalbyk@whsb.essex.sch.uk

SALE

This is perfect for students in Year 13 to use to revise the AQA required practicals. All of the required practicals have been done and photographs taken of the experimental setups. The results have been tabulated and graphed with appropriate processing. The errors have been analysed, and additional research has been referenced. There is even an appendix where the AQA method of estimating errors is justified by comparing it to more thorough statistical error analysis approaches. Document contains ~19000 words and 95 pages (including title, introduction and contents page).

TES PICKS

Useful for revision or to support your teaching in lessons, this large .pdf file contains information, formulas, questions (with answers), explanations, diagrams and definitions of quantities.
331 pages long. I recommend you display in full-screen. You can zoom in to parts of interest. Parts of the presentation link to other parts.
This contains the full course. I may add more slides in the future, and update this file, but this includes everything the student needs to know.

SALE

This is perfect for students in Year 13 to use to revise the AQA required practicals. All of the required practicals have been done and photographs taken of the experimental setups. The results have been tabulated and graphed with appropriate processing. The errors have been analysed, and additional research has been referenced. There is even an appendix where the AQA method of estimating errors is justified by comparing it to more thorough statistical error analysis approaches. Document contains ~19000 words and 95 pages (including title, introduction and contents page).

SALE

This is a workbook containing 99 questions about topics found at A Level Physics, covering most of the course. The answer to each question immediately follows the questions. Students can work through pages of these at their own pace. This can be shared with students on your school's VLE.
This promotes independent working and mastery of the necessary skills.
Contains:
99 problems about quantum physics
99 problems about electricity
99 problems about work, energy and power
99 problems about springs
99 problems about kinematics
99 problems about dynamics
99 problems about waves
99 problems about optics
99 problems about circular motion
99 problems about simple harmonic motion
99 problems about gravitational fields
99 problems about electric fields
99 problems about capacitors
99 problems about magnetic fields
99 problems about magnetic induction
99 problems about gases
99 problems about thermal physics
99 problems about nuclear physics
The book is now also available in paperback from Amazon and I think it looks pretty good: https://www.amazon.co.uk/dp/152090553X/ref=cm_sw_r_cp_apa_6pl1ybK6E9FQ8
Check out my other resources: the Physics Drill spreadsheets will change your life. Go to www.physicsdrill.wikispaces.com for details.

SALE

*** NOTE: THIS RESOURCE HAS BEEN REDUCED IN PRICE BECAUSE IT IS NOW OUT OF DATE ***
A full booklet of questions, with an answer booklet, for students to use for their revision for the new GCSE (9-1) in Physics. Gives an entire year of homework tasks (up to Easter, after that they might want to be set past papers to do).
It is designed to follow the scheme of work at my school, so the order of the tasks might not be suitable for all schools. The tasks are tailored for the AQA GCSE (9-1) Physics [HT]; however, they are likely to be applicable to other exam boards.
There is a significant amount of repetition within the booklet. The philosophy is that mastery of the knowledge and skills requires repetition. Using this philosophy, our school attained 83% A*/A grades in Physics in the 2017 examination year.
Tasks are generated using the question generators I made, which are also available here on TES. Search for Physics Drill Spreadsheets.

SALE

Dear Physics Teachers,
These resource will help your students master GCSE Physics subject knowledge and skills. This is a complete set of simulations and worksheet generators. Using this resource, you will save yourself time making as many worksheets as your heart desires.
How often have you had to tell your students that they need more practice at a particular skill or to acquire some particular knowledge in physics? One day, a student asked me a reasonable question: "where can I get additional questions to practise?" From that simple question spawned my idea to create a series of 'drill spreadsheets'. These worksheet generators can be used be teachers or students to generate thousands upon thousands of unique worksheets. Most of the sheets can be customised for differentiation quickly by toggling a few options.
I wish someone had invented and provided this resource when I started teaching. You do not need to wish, here it is. As I create new drill sheets I'll add them here, so you will always be able to come back and get the latest sheets.
These are all available individually, see here for the full selection: http://physicsdrill.wikispaces.com/
The resources all work with MS Excel and other spreadsheet applications. None of them use VBA or other scripting tools, so they may also work on Macs, Android phones and iPhones, amongst other platforms.
If you have any questions, email me at dalbyk@whsb.essex.sch.uk

SALE

Dear Physics Teachers,
These resource will help your students master GCSE and A Level Physics subject knowledge and skills. This is a complete set of simulations and worksheet generators. Using this resource, you will save yourself time making as many worksheets as your heart desires.
How often have you had to tell your students that they need more practice at a particular skill or to acquire some particular knowledge in physics? One day, a student asked me a reasonable question: "where can I get additional questions to practise?" From that simple question spawned my idea to create a series of 'drill spreadsheets'. These worksheet generators can be used be teachers or students to generate thousands upon thousands of unique worksheets. Most of the sheets can be customised for differentiation quickly by toggling a few options.
I wish someone had invented and provided this resource when I started teaching. You do not need to wish, here it is. As I create new drill sheets I'll add them here, so you will always be able to come back and get the latest sheets.
Sheets included in this bundle:
GCSE Physics Formula Drill
GCSE Physics Definitions Drill
GCSE Physics Motion Graphs Drill
GCSE Physics Length, Area and Volume Unit Conversions Drill
GCSE Physics Wave Superposition Drill
GCSE and A Level Physics Resolving Vectors Drill
GCSE Science Command Words Drill
GCSE Mathematics Trigonometry Drill
AS Level Physics Definitions Drill
A Level Physics Definitions Drill
A Level Physics Three Forces in Equilibrium Drill
A Level Physics Projectiles Drill
A Level Physics Momentum Conservation Drill
A Level Physics Stationary Waves Drill
A Level Physics Photoelectric Effect Drill
A Level Physics Kirchhoff's Laws Drill
A Level Physics Electron Beam Drills
A Level Physics Newton's Second Law Drill
A Level Physics Feynman-like Diagrams Drill
A Level Physics Errors Drill
A Level Physics Vernier Caliper Drill
A Level Physics Micrometer Drill
A Level Physics Electric Fields Drill
A Level Physics Gravitational Fields Drill
A Level Physics Diffraction Drill
And more are added frequently (this list might not be up to date!)
These are all available individually, see here for the full selection: http://physicsdrill.wikispaces.com/
The resources all work with MS Excel and other spreadsheet applications. None of them use VBA or other scripting tools, so they should also work on Macs, Android phones and iPhones, amongst other platforms. I have tested most of the sheets on my Android phone and they work fine (using the free WPS app).
If you have any questions, email me at dalbyk@whsb.essex.sch.uk

SALE

***********************
Save money by buying the bundles, which contain ALL of the Drill spreadsheets.
£3 for the GCSE Bundle: https://www.tes.com/teaching-resource/-11399132
£4 for the A Level Bundle: https://www.tes.com/teaching-resource/-11399125
£6 for the GCSE and A Level Bundle: https://www.tes.com/teaching-resource/-11399137
***********************
Dear Physics Teachers,
1. This resource will save you time with planning, preparation and marking.
2. This resource produces good looking worksheets that can be printed or projected on a screen, with answers.
3. This resource is relevant to the new AQA GCSE (9-1) Physics specification and can be customised for others.
4. This resource is useful throughout the GCSE course. Pupils are required to memorise 23 equations and be able to rearrange and use 35 equations. Repeated and continual use of this resource can make this process painless.
Info:
This spreadsheet generates an almost unlimited number of questions that can be printed as a worksheet. The questions are all mathematical, and test the pupils' ability to solve simple mathematical problems. The numbers are populated randomly (press F9 in MS Excel to shuffle the numbers and formulas), as is the order of the formulas chosen. The settings sheet can be used to narrow the selection of equations included, and one can choose if hints should be given.
The spreadsheet is fairly self explanatory, but if you would like help, please do email me at dalbyk@whsb.essex.sch.uk and I should be able to help you.
To see a sample of what the outputted worksheets look like, see here: https://www.tes.com/teaching-resource/year-10-aqa-gcse-9-1-physics-basic-mechanics-worksheets-11388602
(The equations are taken from the new AQA GCSE (9-1) Physics specification.)
(This should work on MS Excel for Windows and Apple Mac. Has been tested on the WPS office suite for Android and it works fine.)
See here for other Physics Drill resources: http://physicsdrill.wikispaces.com/

SALE

This spreadsheet estimates errors for the gradient and intercept of a graph using two methods: an analytical approach and a Monte Carlo method of random sampling. The Monte Carlo method randomly samples pairs of data points 20000 times in order to estimate the standard error in the gradients and intercepts. A graph is produced that shows the spread of results around the data for the two different methods of estimating errors.
This is a useful teaching tool for showing A Level Physics students how to estimate the errors in their lab work; particularly helpful for the A Level Physics Required Practicals. Exam boards expect students to estimate errors in gradients and intercepts by eye by drawing a 'worse-but-acceptable line of best fit'. Students find this challenging, so a tool such as this can help alleviate any concerns they have about the validity of that method of approximation.
Your students could even use this spreadsheet when analysing their own practical work, as long as they understand how it works and as long as they are able to estimate errors as the exam board prescribes before their examinations!

TES PICKS

Useful for revision or to support your teaching in lessons, this large .pdf file contains information, formulas, questions (with answers), explanations, diagrams and definitions of quantities.
331 pages long. I recommend you display in full-screen. You can zoom in to parts of interest. Parts of the presentation link to other parts.
This contains the full course. I may add more slides in the future, and update this file, but this includes everything the student needs to know.

SALE

***********************
Save money by buying the bundles, which contain ALL of the Drill spreadsheets.
£3 for the GCSE Bundle: https://www.tes.com/teaching-resource/-11399132
£4 for the A Level Bundle: https://www.tes.com/teaching-resource/-11399125
£6 for the GCSE and A Level Bundle: https://www.tes.com/teaching-resource/-11399137
***********************
Dear Physics Teachers,
1. This resource will help your students understand the subtle difference between the meanings of the exam command words.
2. This resource is to be projected on a screen, used by students on a computer or used to print an unlimited number of different worksheets.
3. This resource is relevant to all new AQA GCSE (9-1) Science specifications and can be edited for other exam boards.
Info:
This spreadsheet uses random numbers to shuffle the descriptions of exam words, to help your pupils with their revision.
The spreadsheet is fairly self explanatory, but if you would like help, please do email me at dalbyk@whsb.essex.sch.uk and I should be able to help you.

SALE

***********************
Save money by buying the bundles, which contain ALL of the Drill spreadsheets.
£3 for the GCSE Bundle: https://www.tes.com/teaching-resource/-11399132
£4 for the A Level Bundle: https://www.tes.com/teaching-resource/-11399125
£6 for the GCSE and A Level Bundle: https://www.tes.com/teaching-resource/-11399137
***********************
Dear Physics Teachers,
1. This resource will help your students understand thermal physics, including state changes and heating/cooling.
2. This resource is to be projected on a screen, used by students on a computer or used to print worksheets, with worked solutions.
3. This resource is relevant to all new A Level Physics specifications.
Info:
The spreadsheet generates thermal physics questions that involve either zero or one state change (questions with more state changes can be generated, but the question and answer boxes go red and no worked solution is created). Two materials at two different temperatures are given, and students are asked to calculate what the equilibrium temperature would be.
The spreadsheet gives answers, but also full worked solutions for problems with one or fewer state changes.
The spreadsheet is fairly self explanatory, but if you would like help, please do email me at dalbyk@whsb.essex.sch.uk and I should be able to help you.
(This should work on MS Excel for Windows and Apple Mac. Also works on other platforms, such as Libre Office or even WPS on Android)

SALE

A booklet containing 10 thermal physics equilibrium questions and answers with step-by-step working included. Ready to print. Questions include the same or different substances, and situations where there is and is not a change in state.

SALE

***********************
Save money by buying the bundles, which contain ALL of the Drill spreadsheets.
£3 for the GCSE Bundle: https://www.tes.com/teaching-resource/-11399132
£4 for the A Level Bundle: https://www.tes.com/teaching-resource/-11399125
£6 for the GCSE and A Level Bundle: https://www.tes.com/teaching-resource/-11399137
***********************
Dear Physics Teachers,
1. This resource will save you time with planning, preparation and marking.
2. This resource produces good looking worksheets that can be printed or projected on a screen, with answers.
3. This resource is relevant to the new AQA AS Level Physics specification and can be customised for others.
4. This resource is useful throughout the AQA AS and A Level course. Students are required to learn almost 200 key words and know their definitions. Repeated and continual use of this resource can make this process painless.
The spreadsheet is fairly self explanatory, but if you would like help, please do email me at dalbyk@whsb.essex.sch.uk and I should be able to help you.
To see a sample of what the outputted worksheets look like, see here: https://www.tes.com/teaching-resource/year-12-aqa-as-level-physics-definitions-worksheet-11389608
(The key words and definitions are taken from the new AQA AS Level Physics CGP Textbook.)
(This should work on MS Excel for Windows and Apple Mac. Has been tested on the WPS office suite for Android and it works fine.)
See here for other Physics Drill resources: http://physicsdrill.wikispaces.com/

SALE

***********************
Save money by buying the bundles, which contain ALL of the Drill spreadsheets.
£3 for the GCSE Bundle: https://www.tes.com/teaching-resource/-11399132
£4 for the A Level Bundle: https://www.tes.com/teaching-resource/-11399125
£6 for the GCSE and A Level Bundle: https://www.tes.com/teaching-resource/-11399137
***********************
Dear Physics Teachers,
1. This resource will help you students practise their kinematics skills.
2. This resource is to be projected on a screen or used by students on a computer.
3. This resource is relevant to the new AQA A Level Physics specification.
Info:
This spreadsheet generates an almost unlimited number of projectile problems that can be printed as a worksheet or projected on a screen. The numbers are populated randomly (press F9 in MS Excel to shuffle the numbers and variables given).
The spreadsheet is fairly self explanatory, but if you would like help, please do email me at dalbyk@whsb.essex.sch.uk and I should be able to help you.
(This should work on MS Excel for Windows and Apple Mac.)
See here for other Physics Drill resources: http://physicsdrill.wikispaces.com

SALE

***********************
Save money by buying the bundles, which contain ALL of the Drill spreadsheets.
£3 for the GCSE Bundle: https://www.tes.com/teaching-resource/-11399132
£4 for the A Level Bundle: https://www.tes.com/teaching-resource/-11399125
£6 for the GCSE and A Level Bundle: https://www.tes.com/teaching-resource/-11399137
***********************
Dear Physics Teachers,
1. This resource will help your students understand diffraction from two or more slits.
2. This resource is to be projected on a screen or used by students on a computer.
3. This resource is relevant to all new A Level Physics specifications.
Info:
This spreadsheet simulates an array of point sources. Students can investigate the effect of varying the wavelength or spacing between the sources on the diffraction pattern produced.
The spreadsheet is fairly self explanatory, but if you would like help, please do email me at dalbyk@whsb.essex.sch.uk and I should be able to help you.
(This should work on MS Excel for Windows and Apple Mac.)
See here for other Physics Drill resources: http://physicsdrill.wikispaces.com

SALE

***********************
Save money by buying the bundles, which contain ALL of the Drill spreadsheets.
£3 for the GCSE Bundle: https://www.tes.com/teaching-resource/-11399132
£4 for the A Level Bundle: https://www.tes.com/teaching-resource/-11399125
£6 for the GCSE and A Level Bundle: https://www.tes.com/teaching-resource/-11399137
***********************
Dear Physics Teachers,
1. This resource will help you students practise their vernier caliper reading skills.
2. This resource is to be projected on a screen or used by students on a computer.
3. This resource is relevant to all new A Level Physics specifications.
Info:
This spreadsheet simulates a vernier caliper scale. The user can select whether to use values rounded to 0.1mm or not, to differentiate the difficulty level. The values are randomly selected, and can be shuffled by pressing F9 on MS Excel.
The spreadsheet is fairly self explanatory, but if you would like help, please do email me at dalbyk@whsb.essex.sch.uk and I should be able to help you.
(This should work on MS Excel for Windows and Apple Mac.)
See here for other Physics Drill resources: http://physicsdrill.wikispaces.com

SALE

***********************
Save money by buying the bundles, which contain ALL of the Drill spreadsheets.
£3 for the GCSE Bundle: https://www.tes.com/teaching-resource/-11399132
£4 for the A Level Bundle: https://www.tes.com/teaching-resource/-11399125
£6 for the GCSE and A Level Bundle: https://www.tes.com/teaching-resource/-11399137
***********************
Dear Physics Teachers,
1. This resource will help you students practise their micrometer scale reading skills.
2. This resource is to be projected on a screen or used by students on a computer.
3. This resource is relevant to all new A Level Physics specifications.
Info:
This spreadsheet simulates a micrometer scale. The values are randomly selected, and can be shuffled by pressing F9 on MS Excel.
The spreadsheet is fairly self explanatory, but if you would like help, please do email me at dalbyk@whsb.essex.sch.uk and I should be able to help you.
(This should work on MS Excel for Windows and Apple Mac.)

SALE

***********************
Save money by buying the bundles, which contain ALL of the Drill spreadsheets.
£3 for the GCSE Bundle: https://www.tes.com/teaching-resource/-11399132
£4 for the A Level Bundle: https://www.tes.com/teaching-resource/-11399125
£6 for the GCSE and A Level Bundle: https://www.tes.com/teaching-resource/-11399137
***********************
Dear Physics Teachers,
1. This resource will help your students practise measuring acceleration using ticker tape.
2. This resource is to be projected on a screen, used by students on a computer or used to print an unlimited number of different worksheets.
3. This resource is relevant to all new GCSE Physics specifications, where the use of ticker tape timers is a standard practical way of measuring acceleration.
Info:
Simulating the tape from a ticker-tape timer connected to a 50 Hz AC supply (0.02s time interval between dots), this worksheet generator produces five questions each time. Pressing F9 in Excel for Windows (or Cmd + = in Excel for Mac) recalculates the formulas, randomly choosing five new questions with five new accelerations to measure. The sheet tab "answers" has the answers filled in. This should print correctly to scale on A4 paper, but if not, the rulers are drawn with mm intervals to allow them to be used instead of direct measurement.
This worksheet generator can be projected on the screen so that the teacher can explain to the students how to measure acceleration with the ticker-tape, then an unlimited number of unique worksheets can be generated so they can practise the skill.

SALE

***********************
Save money by buying the bundles, which contain ALL of the Drill spreadsheets.
£3 for the GCSE Bundle: https://www.tes.com/teaching-resource/-11399132
£4 for the A Level Bundle: https://www.tes.com/teaching-resource/-11399125
£6 for the GCSE and A Level Bundle: https://www.tes.com/teaching-resource/-11399137
***********************
Dear Physics Teachers,
1. This resource will help you students practise their gas laws calculation skills.
2. This resource can be used to print worksheets (with separate answers sheets) or can be projected onto a screen.
3. This resource is relevant to all A Level Physics specifications and some GCSE Physics specifications too.
Info:
This spreadsheet generates an almost unlimited number of gas laws problems that can be printed as a worksheet or projected on a screen. The numbers are populated randomly (press F9 in MS Excel to shuffle the numbers and variables given).
The spreadsheet is fairly self explanatory, but if you would like help, please do email me at dalbyk@whsb.essex.sch.uk and I should be able to help you.
(This should work on MS Excel for Windows and Apple Mac.)
See here for other Physics Drill resources: http://physicsdrill.wikispaces.com

SALE

***********************
Save money by buying the bundles, which contain ALL of the Drill spreadsheets.
£3 for the GCSE Bundle: https://www.tes.com/teaching-resource/-11399132
£4 for the A Level Bundle: https://www.tes.com/teaching-resource/-11399125
£6 for the GCSE and A Level Bundle: https://www.tes.com/teaching-resource/-11399137
***********************
Dear Physics Teachers,
1. This resource will help you students practise their skills finding electric potentials, field strengths and forces in 2D systems with up to six large point charges randomly distributed.
2. This resource is to be projected on a screen or used by students on a computer.
3. This resource is relevant to all new A Level Physics specifications (AQA, OCR, Edexcel, etc).
Info:
This spreadsheet generates an almost unlimited number of electric fields problems that can be printed as a worksheet or projected on a screen. The numbers are populated randomly (press F9 in MS Excel to shuffle the numbers and variables given). The number of point charges included can be changed on the 'question' sheet, between 1 and 6.
The spreadsheet is fairly self explanatory, but if you would like help, please do email me at dalbyk@whsb.essex.sch.uk and I should be able to help you.
(This should work on MS Excel for Windows and Apple Mac.)
See here for other Physics Drill resources: http://physicsdrill.wikispaces.com

SALE

Dear Physics Teachers,
These resource will help your students master A Level Physics subject knowledge and skills. This is a complete set of simulations and worksheet generators. Using this resource, you will save yourself time making as many worksheets as your heart desires.
How often have you had to tell your students that they need more practice at a particular skill or to acquire some particular knowledge in physics? One day, a student asked me a reasonable question: "where can I get additional questions to practise?" From that simple question spawned my idea to create a series of 'drill spreadsheets'. These worksheet generators can be used be teachers or students to generate thousands upon thousands of unique worksheets. Most of the sheets can be customised for differentiation quickly by toggling a few options.
I wish someone had invented and provided this resource when I started teaching. You do not need to wish, here it is. As I create new drill sheets I'll add them here, so you will always be able to come back and get the latest sheets.
These are all available individually, see here for the full selection: http://physicsdrill.wikispaces.com/
The resources all work with MS Excel and other spreadsheet applications. None of them use VBA or other scripting tools, so they may also work on Macs, Android phones and iPhones, amongst other platforms.
If you have any questions, email me at dalbyk@whsb.essex.sch.uk

SALE

***********************
Save money by buying the bundles, which contain ALL of the Drill spreadsheets.
£3 for the GCSE Bundle: https://www.tes.com/teaching-resource/-11399132
£4 for the A Level Bundle: https://www.tes.com/teaching-resource/-11399125
£6 for the GCSE and A Level Bundle: https://www.tes.com/teaching-resource/-11399137
***********************
Dear Physics Teachers,
1. This resource will help your students learn how to analyse and combine errors.
2. This resource is to be projected on a screen or used by students on a computer.
3. This resource is relevant to the new AQA A Level Physics specification, amongst others (OCR, Edexcel, etc).
Info:
This spreadsheet generates a random equation consisting of five variables, and gives seven repeat measurements for four of them. The student is then asked to calculate the mean value of each, the absolute error, the percentage error, and finally the combined error. The answers are given on the Answers sheet. Pressing F9 in MS Excel shuffles the equation and values.
The spreadsheet is fairly self explanatory, but if you would like help, please do email me at dalbyk@whsb.essex.sch.uk and I should be able to help you.
(This should work on MS Excel for Windows and Apple Mac.)
See here for other Physics Drill resources: http://physicsdrill.wikispaces.com/