Hero image

Physics With Keith

Average Rating4.92
(based on 72 reviews)

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.
Exemplar lab reports for all 12 AQA A Level Physics required practicals
PhysicsWithKeithPhysicsWithKeith

Exemplar lab reports for all 12 AQA A Level Physics required practicals

(11)
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).
GCSE and A Level Physics Drills (question generators)
PhysicsWithKeithPhysicsWithKeith

GCSE and A Level Physics Drills (question generators)

(7)
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
Full Course Presentations for Physics GCSE (9-1) AQA  (All topics; perfect for lessons or revision)
PhysicsWithKeithPhysicsWithKeith

Full Course Presentations for Physics GCSE (9-1) AQA (All topics; perfect for lessons or revision)

(3)
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.
Edexcel GCSE (9-1) Physics Core Practical Workbook
PhysicsWithKeithPhysicsWithKeith

Edexcel GCSE (9-1) Physics Core Practical Workbook

(1)
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?
A Level Physics Drills (question generators)
PhysicsWithKeithPhysicsWithKeith

A Level Physics Drills (question generators)

(2)
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
A Level Physics Questions and Answers All Topics
PhysicsWithKeithPhysicsWithKeith

A Level Physics Questions and Answers All Topics

(9)
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.
Particle Physics resources including presentations and worksheets
PhysicsWithKeithPhysicsWithKeith

Particle Physics resources including presentations and worksheets

(0)
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.
GCSE Physics Formula Drill Worksheet Question Generator
PhysicsWithKeithPhysicsWithKeith

GCSE Physics Formula Drill Worksheet Question Generator

(1)
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
Planning spreadsheet
PhysicsWithKeithPhysicsWithKeith

Planning spreadsheet

(6)
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!
A Level Physics Formula Drill Worksheet Question Generator
PhysicsWithKeithPhysicsWithKeith

A Level Physics Formula Drill Worksheet Question Generator

(0)
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.
Gas Laws Worksheet Generator
PhysicsWithKeithPhysicsWithKeith

Gas Laws Worksheet Generator

(0)
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
Resolving vectors question generator
PhysicsWithKeithPhysicsWithKeith

Resolving vectors question generator

(0)
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
GCSE Physics Drills (question generators)
PhysicsWithKeithPhysicsWithKeith

GCSE Physics Drills (question generators)

(4)
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
Physics GCSE and A Level Kirchhoff's Laws Drill Question Generator for Circuit Rules
PhysicsWithKeithPhysicsWithKeith

Physics GCSE and A Level Kirchhoff's Laws Drill Question Generator for Circuit Rules

(0)
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.
A Level Physics Minkowski Diagrams Drill
PhysicsWithKeithPhysicsWithKeith

A Level Physics Minkowski Diagrams Drill

(0)
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
Question Generator for Feynman Diagram
PhysicsWithKeithPhysicsWithKeith

Question Generator for Feynman Diagram

(0)
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
A Level Physics Wave Diffraction and Interference Drills
PhysicsWithKeithPhysicsWithKeith

A Level Physics Wave Diffraction and Interference Drills

(1)
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.
Fine Beam Tube and Teltron Tube D Simulator
PhysicsWithKeithPhysicsWithKeith

Fine Beam Tube and Teltron Tube D Simulator

(0)
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
The Gradiator: spreadsheet to choose grade boundaries based on grade distributions
PhysicsWithKeithPhysicsWithKeith

The Gradiator: spreadsheet to choose grade boundaries based on grade distributions

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