Element Quiz Generator

I mentioned inwards a previous post, that I'm giving my chemical scientific discipline students weekly chemical factor quizzes until they accept the symbols in addition to names of the starting fourth dimension 36 elements memorized.

When I told my husband of my innovation to write my chemical factor quizzes, he offered to help utilization 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, in addition to the spreadsheet volition automatically generate a novel quiz. Not happy alongside the novel quiz version? Hit F9 to generate a dissimilar version.

This business office of the spreadsheet controls the magic. 

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

For my class, nosotros are doing iv quizzes. 

Quiz 1 - Elements 1-12

Quiz two - Elements 13-24

Quiz three - Elements 25-36

Quiz 4 - Elements 1-36

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

Each PDF contains a quiz in addition to the corresponding answer 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 written report postulate I gave my students to railroad train for each of the chemical factor quizzes. 

Tweet

Subscribe to receive free email updates: