# Physics With Keith

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

Home feed

My list

Courses
My Jobs
Job alerts
My CV
Career preferences
Resources
Author dashboard
Settings

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

43Uploads

28k+Views

37k+Downloads

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

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

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 Lenses Drill
GCSE Physics Wave Superposition Drill
GCSE and A Level Physics Resolving Vectors Drill
GCSE Science Command Words Drill
GCSE Mathematics Trigonometry 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 (too many to list!)
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).
When using MS Excel in Windows, press F9 to recalculate formulas and generate new questions. When using MS Excel on a Mac, press Cmd + =. On other packages, how to recalculate formulas may vary.
If you have any questions, send me a message via http://m.me/PhysicsWithKeith

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.

Contains all of the Edexcel GCSE (9-1) Physics Core Practicals. I’ve included the MS Word document so you can change the order, if necessary. All of the practicals include instructions, diagrams, space for tables, graphs and questions that direct the pupil to develop their practical skills throughout the course.
Scaffolding is provided for the students. This one booklet is all the students would need for their required practicals.
For assessment and feedback, level descriptors for the grades are included and there is a form after each practical for the teacher to give comments about areas for development.
Really handy for cutting down your workload, particularly if preparing for next year. Why not get a site licence and use this across your whole department?

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.
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.
When using MS Excel in Windows, press F9 to recalculate formulas and generate new questions. When using MS Excel on a Mac, press Cmd + =. On other platforms, the way to recalculate formulas may vary.
If you have any questions, send me a message via http://m.me/PhysicsWithKeith

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.

Contains all of the AQA GCSE (9-1) Physics Required Practicals (sometimes called core practicals), listed in the order of the new AQA GCSE Physics Third Edition textbook (Breithaupt, 2016). I’ve included the MS Word document so you can change the order, if necessary, and a version where the practicals are in specification order. All of the practicals include instructions, diagrams, space for tables, graphs and questions that direct the pupil to develop their practical skills throughout the course.
Scaffolding is provided for the students. This one booklet is all the students would need for their required practicals.
For assessment and feedback, level descriptors for the grades are included and there is a form after each practical for the teacher to give comments about areas for development.
Really handy for cutting down your workload, particularly if preparing for next year. Why not get a site licence and use this across your whole department?

A spreadsheet that generates Minkowski diagrams to help with teaching special relativity.
All of my drills are fully Excel compatible spreadsheets.
SAVE MONEY, BUY A BUNDLE
(this drill and many more are included)
GCSE and A Level Drills: https://www.tes.com/teaching-resource/gcse-and-a-level-physics-drills-all-topics-perfect-for-use-in-lessons-or-revision-11399137
A Level Drills: https://www.tes.com/teaching-resource/a-level-physics-drills-all-topics-perfect-for-use-in-lessons-or-revision-11399125

This spreadsheet generates data that students can use to calculate absolute errors and percentage errors from lists, and propagate those errors through an equation to arrive at a final result with error.
All of my drills are fully Excel compatible spreadsheets. This one is a worksheet generator, which can be used to generate an unlimited number of unique questions.
Just press F9 (PC) or Cmd+= (Mac) to refresh the spreadsheet and generate a new question.
SAVE MONEY, BUY A BUNDLE
(this drill and many more are included)
GCSE and A Level Drills: https://www.tes.com/teaching-resource/gcse-and-a-level-physics-drills-all-topics-perfect-for-use-in-lessons-or-revision-11399137
A Level Drills: https://www.tes.com/teaching-resource/a-level-physics-drills-all-topics-perfect-for-use-in-lessons-or-revision-11399125

This spreadsheet generates worksheets to help students practise key skills with log graphs, such as reading from logarithmic scales and finding decay constants for exponential decays. These skills are now being examined at A Level.
All of my drills are fully Excel compatible spreadsheets. This one is a worksheet generator, which can be used to generate an unlimited number of unique questions.
Just press F9 (PC) or Cmd+= (Mac) to refresh the spreadsheet and generate a new question.
SAVE MONEY, BUY A BUNDLE
(this drill and many more are included)
GCSE and A Level Drills: https://www.tes.com/teaching-resource/gcse-and-a-level-physics-drills-all-topics-perfect-for-use-in-lessons-or-revision-11399137
A Level Drills: https://www.tes.com/teaching-resource/a-level-physics-drills-all-topics-perfect-for-use-in-lessons-or-revision-11399125

Approximately ten lessons of work based on the AQA A Level textbook. The order roughly follows the chronological order of particle physics discoveries, with essential tangents included.
These go a little bit beyond the AQA A Level course, including a little bit about gluons and quantum chromodynamics, but only to support students’ understanding of why there are three quarks in a baryon and a quark and an anti-quark in a meson.

An interactive diffraction simulation. Students can make measurements from the screen to confirm the equations for diffraction from a grating or two slits (or more). The spreadsheets can produce displacement plots or intensity plots.
You can customise where the slits are, and what the wavelength is. Units are arbitrary.
All of my drills are fully Excel compatible spreadsheets.
SAVE MONEY, BUY A BUNDLE
(this drill and many more are included)
GCSE and A Level Drills: https://www.tes.com/teaching-resource/gcse-and-a-level-physics-drills-all-topics-perfect-for-use-in-lessons-or-revision-11399137
A Level Drills: https://www.tes.com/teaching-resource/a-level-physics-drills-all-topics-perfect-for-use-in-lessons-or-revision-11399125
Technical points:
The huge one takes a few seconds to load. If the graphics are glitchy, press F9 (PC) or Cmd+= (Mac) to refresh them.

This one is a question generator that displays an image of a micrometer scale and asks the student to say what measurement is given. It can produce any random measurement to be determined by the student.
To generate new questions, press F9 (PC) or Cmd+= (Mac).
The answer appears on the ‘Answer’ sheet. In the ‘Settings’ sheet you can choose whether to force the generator to quantize measurements to match the resolution of the intrument, or not.
All of my drills are fully Excel compatible spreadsheets.
SAVE MONEY, BUY A BUNDLE
(this drill and many more are included)
GCSE and A Level Drills: https://www.tes.com/teaching-resource/gcse-and-a-level-physics-drills-all-topics-perfect-for-use-in-lessons-or-revision-11399137
A Level Drills: https://www.tes.com/teaching-resource/a-level-physics-drills-all-topics-perfect-for-use-in-lessons-or-revision-11399125

A question generator that displays an image of a Vernier scale and asks the student to say what measurement is given.
To generate new questions, press F9 (PC) or Cmd+= (Mac).
The answer appears on the ‘Answer’ sheet. In the ‘Settings’ sheet you can choose whether to force the generator to quantize measurements to match the resolution of the intrument, or not.
All of my drills are fully Excel compatible spreadsheets.
SAVE MONEY, BUY A BUNDLE
(this drill and many more are included)
GCSE and A Level Drills: https://www.tes.com/teaching-resource/gcse-and-a-level-physics-drills-all-topics-perfect-for-use-in-lessons-or-revision-11399137
A Level Drills: https://www.tes.com/teaching-resource/a-level-physics-drills-all-topics-perfect-for-use-in-lessons-or-revision-11399125

A question generator that creates worksheets where students have to calculate resultant field strengths and potentials for situations with more than one charge. Very customisable.
All of my drills are fully Excel compatible spreadsheets. This one is a worksheet generator, which can be used to generate an unlimited number of unique questions.
Just press F9 (PC) or Cmd+= (Mac) to refresh the spreadsheet and generate a new question.
SAVE MONEY, BUY A BUNDLE
(this drill and many more are included)
GCSE and A Level Drills: https://www.tes.com/teaching-resource/gcse-and-a-level-physics-drills-all-topics-perfect-for-use-in-lessons-or-revision-11399137
A Level Drills: https://www.tes.com/teaching-resource/a-level-physics-drills-all-topics-perfect-for-use-in-lessons-or-revision-11399125

This spreadsheet generates questions where three forces are in equilibrium and students have to use the principles of vectors to determine a missing quantity, such as the angle of one of the vectors or the magnitude of one of the forces.
All of my drills are fully Excel compatible spreadsheets. This one is a question generator, which can be used to generate an unlimited number of unique questions.
Just press F9 (PC) or Cmd+= (Mac) to refresh the spreadsheet and generate a new question.
SAVE MONEY, BUY A BUNDLE
(this drill and many more are included)
GCSE and A Level Drills: https://www.tes.com/teaching-resource/gcse-and-a-level-physics-drills-all-topics-perfect-for-use-in-lessons-or-revision-11399137
A Level Drills: https://www.tes.com/teaching-resource/a-level-physics-drills-all-topics-perfect-for-use-in-lessons-or-revision-11399125

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.
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.
When using MS Excel in Windows, press F9 to recalculate formulas and generate new questions. When using MS Excel on a Mac, press Cmd + =. On other packages, the way to recalculate formulas may vary.
If you have any questions, send me a message via http://m.me/PhysicsWithKeith

In this 12-part video series, I describe the history of the standard model, and explain some of the key features. This is suitable for students studying A Level Physics and would be really useful for revision. At just 1 hour and 47 minutes, the series isn’t long enough to cover absolutely everything, but it does cover the essentials.

Here is a video I made and a worksheet I put together to help students understand the concepts of time dilation and length contraction in special relativity. I hope this helps.

If you are like me, you do not enjoy the task of trying to decide grade boundaries for assessments. If you are a Head of Department, you may be responsible for deciding grades that go on reports, which are sent home to parents. It is vital these are representative of the attainment of the students.
I have made this spreadsheet to make the process less painful.
Simply enter a suitable distribution of grades into the ‘Curve to fit’ section (I use the distribution of results from the previous cohort’s public examinations), then copy the percentage scores for the students into the ‘Scores (%)’ section. The Grade boundaries appear under ‘Boundaries’. Some schools use subgrades (dividing each grade into three), so subgrade boundaries are also produced (listed in ascending and descending order, to suit your preference of index-match or vlookup formulas)
Of course, it can be a pain writing your own formulas to generate the grades, so the formulas are also produced, which can be copied and pasted (as text!) into your own spreadsheet. Don’t forget to change the cell to which the formula refers under ‘Cell’.
If you need to see how it works, I’ve uploaded a YouTube video to demonstrate.
HOW IT WORKS: the spreadsheet assumes a normal distribution for all data. The normal distribution standard deviation and mean are determined from the data you enter under ‘Curve to fit’, which is then used to generate matching grade boundaries for the ‘Scores (%)’ data, which should produce a similar spread of results. Doing all that statistical crunching manually can take far too long, so I wrote this spreadsheet to speed the process up.