A Level Physics Quiz Generator Spreadsheet by Topic (Excel & Numbers)

I use this generator extensively for continual revision throughout the school year. Each lesson we have a 5-10 minute quiz on past topics to keep them fresh in students’ minds. This is one of Rosenshine’s key principles.

Generate a recap / review quiz on a subject in physics with ease. Comes with a database of questions categorised into topic areas (physics subjects), you just select the topic area you want a quiz for and you’ll immediately get a mini quiz of five questions. When the class has finished attempting the questions click once to reveal the solutions.

Want to cycle the questions for a new quiz? Check a checkbox and boom you’ve got a new quiz on the same topic area (use the Refresh drop down menu on Excel).

This is an entirely offline solution meaning you can use this even when your school’s internet connection drops out. The supplied questions are categorised as literacy or numeracy (where applicable). And those linked skills are displayed to the class to reinforce that the mini quiz includes those skills.

The master sheet has a single database of questions to make question maintenance a breeze - one place to input / edit questions. All lookup formulae are dynamic so that you don’t have to worry about which order the questions are in - so feel free to change the order of questions or add/remove questions as you see fit.

In the Numbers (Apple) version the master database also harnesses Numbers’ built in categorisation on the subject so you can expand and collapse collections of questions easily - once again maintaining the database is made super easy.

The quiz generator is designed to randomly select five questions from the database. But note that for subjects with a small number of questions in the database duplicate questions may occasionally be shown. If you can try to keep numbers of questions above 15 to reduce the likelihood of this.

Comes with over 600 questions ready to get you going with a bang! Here’s the subject break down of the questions:

• UNITS 12
• EQUILIBRIUM 21
• MOTION 26
• FORCE AND MOTION 21
• WORK AND ENERGY 14
• MATERIALS 25
• ELECTRICITY 49
• WAVES 18
• REFRACTION & TIR 21
• WAVE INTERFERENCE 34
• QUANTUM 50
• GASES AND KINETIC THEORY 35
• THERMAL PHYSICS 13
• CIRCULAR MOTION 27
• SHM 28
• GRAVITATIONAL FIELDS 33
• ASTROPHYSICS 47
• ELECTRIC FIELDS 15
• CAPACITANCE 26
• MAGNETIC FIELDS 50
• PARTICLES 18
• RADIOACTIVE DECAY 39
• NUCLEAR ENERGY 24
• MEDICAL PHYSICS 19

**Now includes an Excel spreadsheet **. For Windows users. Windows users suffer enough with poor OS & software options so I created an Excel version to take the edge off it ; )
Includes a Numbers spreadsheet. Numbers is spreadsheet software made by Apple, it opens with the Numbers app available for free with most recent iPhone / iPad / Mac devices also available with a free Apple ID for use in most web browsers.