Hero image

Physics With Keith

Average Rating4.91
(based on 80 reviews)

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

(10)
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
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.
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
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.
AQA GCSE (9-1) Physics Required Practical Workbook
PhysicsWithKeithPhysicsWithKeith

AQA GCSE (9-1) Physics Required Practical Workbook

(0)
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 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
Error Analysis Question Generator for A Level Physics
PhysicsWithKeithPhysicsWithKeith

Error Analysis Question Generator for A Level Physics

(0)
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
Log graph worksheet generator
PhysicsWithKeithPhysicsWithKeith

Log graph worksheet generator

(0)
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
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.
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.
Micrometer Drill Question Generator for Physics or Technology
PhysicsWithKeithPhysicsWithKeith

Micrometer Drill Question Generator for Physics or Technology

(0)
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
Vernier Drill Question Generator for Physics or Technology
PhysicsWithKeithPhysicsWithKeith

Vernier Drill Question Generator for Physics or Technology

(1)
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
Electric Fields Drill for A Level Physics
PhysicsWithKeithPhysicsWithKeith

Electric Fields Drill for A Level Physics

(0)
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
Force in Equilibrium question generator
PhysicsWithKeithPhysicsWithKeith

Force in Equilibrium question generator

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

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

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