How to Create a Cryptogram Trivia Quiz

Answer: Create a code

The way I came up with a code is using a spreadsheet, I use 3 columns. In column 1, I put the alphabet in sequence. In Column 2, I copy over column 1. In column 3, I use the spreadsheet's random number generator (In Excel, the format would be =Rand()*100.

Then, I sort columns 2 or 3 to get my code. I check to make sure that a coded letter is not the same as the real letter. If they are I switch it with another one without going through the sorting again.

Answer: Think up the answers

Remember that if your cryptogram quiz has a common theme that the answers should relate to that theme. Also, if your quiz doesn't have a theme, remember that only those really proficient at cryptograms will enjoy them.

Answer: Translate the answers using your code

Be careful! It's really easy to screw this part up. I've learned this from experience. I've typed in the actual letter in place of the coded letter. This is the hardest part of creating the quiz.

Answer: The code remains the same throughout the quiz

Even though it is possible to make a cryptogram with a different set of code for each questions, it would not be advisable to do your first one using different codes. Different codes for each line could be used for quizzes that have 5 or more words that translate to popular phrases, but I don't suggest you try this until you've mastered one code quiz since you will come up with many suprises.

Answer: Take the quiz using your code to make sure it translates properly

I suggest that you take the quiz using only the code. Try not to look at what you are typing (hard to do) and see if you get the right answers. Remember, since you created this quiz you already know the answers, so you have to try real hard and look at the code and type the corresponding letter in its place.

The best thing to do would be, if possible, is to have a friend or relative take the quiz and see if they translate it correctly.