This is a quiz or exam template that you can use to randomize your questions from a question bank. The sections are already made and could be modified as well (fill in the blank, true/false, circle the correct answer, multiple choice). The teacher would create a set of bank questions in the various section tabs in the Excel document and by just hitting the F9 button, it would randomize all of the questions from the bank so that you can print different exams/quizzes for each class or for each semester, etc. This helps a lot with printing a version A and B quiz/exam for a class and it also helps to prevent any cheating because no two exams will be exactly alike. You can decide on how many "bank" questions you want in your question bank. The exam will take a sample of 4 to 5 questions from each section in the bank.
The document is two pages long (front and back) with various sections. If you only wanted one page you can just print one page and/or delete the various sections that you don't want.
Instructions to complete the bank: The teacher would add any questions (and answers if you want an answer key) in the various tabs in the document (section 1, section 2, etc). The tabs are pre-set to about 8 to 16 different questions in the bank, but you can add more or less depending on what you want.
It might be a little confusing to explain how to add more questions, but I will do my best. For example, in the section 1 tab. You have 13 pre-set questions that you can add in the bank. You simply just have to type the question(s) in the section 1 tab (and the answer if you want). The parts in the yellow are sections/formulas that you don't want to change. If you add more questions, then you would drag the yellow part on the left to coincide with the amount of questions that you have. If you were to delete questions (to have a bank of 10 questions for example), you would delete some of the yellow parts left of the questions. The parts on the right (that say "questions that will appear on the exam") are the randomized questions that will appear on your quiz/exam. Basically speaking, the yellow parts are a random number that is assigned to the question that you create, and it selects some of those random numbers to appear on the exam. You can create as many or as little questions as you want, you just want to make sure that their is a random number to the left of the question so that it is part of the list of randomized questions that could appear on your quiz/exam.
Excel is not the most user-friendly program, but you can also adjust the width and column size and delete sections so that it accommodates your class.
Once you have a good question bank in all of the tabs that you want, all you have to do is hit the F9 button and it will randomize those questions from the bank. This will definitely help prevent any cheating on the exams because the exams will be different (depending on how many versions you wish to print for your class).
*There is a slight possibility that a question would repeat itself on the quiz/exam, but the odds of that happening would be about 1/100,000,000.
I have attached a couple of preview photos that show some examples of questions that I used for one of my English classes (as a second language). Hope they help you to understand how it works.
Please email me if you have any questions at all. I love helping other teachers and I would gladly help you if you have any problems or would like to know how to better adapt this document to your class. Thank you.