# 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.

42Uploads

6k+Views

6k+Downloads

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

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

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

***********************
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)

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).

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.

*** 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.

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

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

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

***********************
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.

***********************
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/

***********************
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

***********************
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/

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.
THIS IS A WORK IN PROGRESS. I will be updating it here as I add more.
Buying the resource now means you can download the final version from here cheaper than the final price will be.
The only section I have not yet done is the atomic physics section. Everything else is complete (319 pages so far, formatted such that they can be viewed full screen)

***********************
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.

***********************
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

Save yourself some time: simply copy a key word list or some answers into the spreadsheet and it will automatically generate a coloured grid with the words randomly placed.
The rules I play are that I split the class into two teams. Using a deck of cards, I show each student a card and get them to memorise it. I put the two teams of cards in two piles at the back of the room, where I sit. I draw a card from each team's pile and show the teams. The chosen students then have to stand on each side of the board. I ask a question, and the first person to place their hand over the correct answer scores 1 point for their team, but each incorrect answer scores -2. Each pair of students gets three questions.
This encourages engagement whilst learning key vocabulary, which can be quite a dry task otherwise.
Forcing the formulas to recalculate (pressing F9 on MS Windows Excel) shuffles the key words. Only square grids are automatically made, i.e. 2x2, 3x3, 4x4 etc. Zoom into the appropriate level for the number of key words displayed.
Useful for any subject, and much quicker than drawing the grid yourself. If you already have key word lists, they can simply be copied in.
Why not try my other resources? Search for the Physics Drill Bundles!

***********************
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

***********************
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.)

***********************
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

***********************
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

***********************
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/

***********************
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 interpret a system with multiple bodies interacting.
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 randomly chooses the masses of the bodies and the external forces acting on them. The internal forces between them and their acceleration is calculated by the spreadsheet. On the Question sheet, two pieces of data are missing so that the student can calculate their values, which can be checked by viewing the Answer sheet. Pressing F9 in MS Excel allocates random numbers to the masses and forces, so a near-infinite number of questions can be generated.
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/