Element Quiz Generator

I mentioned inwards a previous post, that I'm giving my chemical scientific discipline students weekly chemical factor quizzes until they convey the symbols too names of the commencement 36 elements memorized.

When I told my husband of my innovation to write my chemical factor quizzes, he offered to tending practise an Excel Spreadsheet that would automatically generate random chemical factor quizzes. Of course, I took him upward on his offer!

Here's the finished product:

Change the version letter, too the spreadsheet volition automatically generate a novel quiz. Not happy amongst the novel quiz version? Hit F9 to generate a dissimilar version.

This purpose of the spreadsheet controls the magic.

Type inwards the atomic numbers that you lot desire to quiz students through. Choose a quiz discover too version letter. The spreadsheet does the rest.

For my class, nosotros are doing 4 quizzes.

Quiz 1 - Elements 1-12

Quiz ii - Elements 13-24

Quiz iii - Elements 25-36

Quiz 4 - Elements 1-36

The spreadsheet made it super slow to generate all of these quizzes (including FOUR versions of each) inwards a thing of minutes. I exactly hitting F9 until I got a quiz version I wanted, too then I selected "Microsoft Print to PDF" every bit my printer.

Each PDF contains a quiz too the corresponding response key!

Here's what the finished production looks like:

Quiz

Answer Key

You tin download the chemical factor quiz generator (created past times my husband) every bit good every bit each of the quizzes I created using the generator here. I'm also including the file for the report direct I gave my students to cook for each of the chemical factor quizzes.