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

42Uploads

18k+Views

18k+Downloads

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

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

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

Sale

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

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?

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

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.

Sale

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.

Sale

A worksheet generator, which can be used to generate an unlimited number of unique questions. The questions are mathematical, students have to decide what equation to use, rearrange it and substitute the numbers to come to an answer. Hints are given on the sheet, but do not need to be given to students.
To generate new questions, press F9 (PC) or Cmd+= (Mac).
If you wish to test only a selection of formulas, you can choose the range of formulas to include from the list on the Settings sheet.
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 is a spreadsheet I created, which enables you to effectively plan across the entire year with ease. The spreadsheet is designed to be robust enough to be useful with most subjects and, if used regularly, can significantly reduce planning time. Better yet, the spreadsheet makes it virtually impossible to forget to set or collect homework.
See the manual (the pdf file) for information about what the spreadsheet can do and how to use it.
Planner.xlsx: I have filled in some details about my own timetable so that you can see how it is used.
Planner-blank.xlsx: This is a blank version so you do not need to clear my data, which also has a sheet called SIMS Import, and the necessary formulas in the Settings sheet to import your timetable directly from the SIMS export.
Transfer-data.xlsm: This macro-enabled spreadsheet uses a VBA to copy the data you choose from one Planner.xlsx spreadsheet to another. Useful if you are updating your Planner.xlsx file with a newer version and don’t want to have to manually copy the data across. You do not need to use full path names if the Transfer-data.xlsx file is in the same directory as the two Planner.xlsx files you want to copy data between.
Planning-macros.xlsm: This macro-enabled spreadsheet uses VBA to toggle square brackets around a selected cell and shift cells down, skipping those with square brackets. Those familiar with using macros may find this useful: most users can ignore this file.
If you have any questions, send me a message via http://m.me/PhysicsWithKeith
Please review!

Sale

A worksheet generator, which can be used to generate an unlimited number of unique questions. The questions are mathematical, students have to decide what equation to use, rearrange it and substitute the numbers to come to an answer. Hints are given on the sheet, but do not need to be given to students.
To generate new questions, press F9 (PC) or Cmd+= (Mac).
If you wish to test only a selection of formulas, you can choose the range of formulas to include from the list on the Settings sheet.
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
All of my drills are fully Excel compatible spreadsheets.

Sale

This question generator produces worksheets including numerical questions about Boyle’s law, Charles’ law, Gay-Lussac’s law (pressure law) and the Ideal Gas law. It is customisable so that you can select the units to be included in the questions and increase the difficulty of the worksheet by including a larger selection of the laws.
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

Sale

This spreadsheet can be used to generate questions where students are given two or more vectors and asked to find what the resultant vector is. They can do this graphically and algebraically.
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

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

Sale

I analysed years of past papers, reviewing circuit topologies to create a worksheet generator which will produce questions that test all of the circuit skills students need to succeed. Diodes in forward and reverse bias are included, as are resistors in series and parallel, and cells in series and parallel.
Just press F9 (PC) or Cmd+= (Mac) to refresh the spreadsheet and generate a new question.
Students must find the current through and voltage across each component. The answers are provided in the ‘Answers’ sheet (tab at the bottom). If you wish to force the spreadsheet to use components that you choose, you can do that also.
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
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.

Sale

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

Sale

All of the Feynman Diagrams that students must memorise are here. Students can be shown a diagram without the particles labelled and have to determine what the particles are.
All of my drills are fully Excel compatible spreadsheets.
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

Sale

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.

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.

Sale

These are interactive simulations of the circular fine beam tube and the Teltron deflection tube D, to show electric and magnetic deflection of electron beams. This can be shared with students so that they can use them in lessons.
All of my drills are fully Excel compatible spreadsheets. This one is an interactive simulator, which can be used to make measurements to determine the specific charge of the electron.
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

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.