Skip to Content

Element Quiz Generator

I’m giving my chemistry students weekly element quizzes until they have the symbols and names of the first 36 elements memorized. I broke the first 36 elements down into three sets. Each week, my chemistry students have 12 elements and their symbols to memorize from the periodic table.

First 36 Elements of the Periodic Table Study Guide

When I told my husband of my plan to write my element quizzes, he offered to help create an Excel Spreadsheet that would automatically generate random element quizzes. Of course, I took him up on his offer to create an element quiz generator!

Here’s the finished product:

Element Quiz Generator

Change the version letter, and the spreadsheet will automatically generate a new quiz. Not happy with the new quiz version? Hit F9 to generate a different version.

Element Quiz Generator

This part of the spreadsheet controls the magic.

Element Quiz Generator

Type in the atomic numbers that you want to quiz students through. Choose a quiz number and version letter. The spreadsheet does the rest.

For my class, we are doing four quizzes.

  • Quiz 1 – Elements 1-12
  • Quiz 2 – Elements 13-24
  • Quiz 3 – Elements 25-36
  • Quiz 4 – Elements 1-36

The spreadsheet made it super easy to generate all of these quizzes (including FOUR versions of each) in a matter of minutes. I simply hit F9 until I got a quiz version I wanted, then I selected “Microsoft Print to PDF” as my printer.

Element Quiz Generator

Each PDF contains a quiz and the corresponding answer key!

Element Quiz Generator

 Here’s what the finished element quiz looks like:

Element Quiz Generator

And, here’s the corresponding answer key.

Element Quiz Generator

Please check out my other chemistry resources for more free downloads.

Lin W

Friday 13th of October 2017

Wow this is great and available even before I need it. Thank you for sharing yours and your husband's resources!!! So very appreciated!!! I see the excel template has other information so will you use it for other things in future like electron configurations, atomic mass etc?