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

29k+Views

38k+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).
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 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 Check out my other resources: the Physics Drill spreadsheets will change your life.
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.
A Level Physics Definitions Drill (worksheet generator)
PhysicsWithKeithPhysicsWithKeith

A Level Physics Definitions Drill (worksheet generator)

(0)
I have collected together technical vocabulary and definitions and designed a spreadsheet that generates random worksheets for students to do. The ability to use technical language is a key skill students need. This tool will help them learn that language. 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.
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.
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?
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 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.
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. 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.
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.
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.
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. All of my drills are fully Excel compatible spreadsheets.
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.
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.
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.