Interactive Spreadsheet Quiz

Do you have to have your students take a vocabulary quiz? You can make one rather easily using Microsoft Excel. Here is a screenshot of a quiz I made on basic color theory vocabulary. The students can type the correct vocab word into the cell and press enter. The quiz will tell them if their answer is correct or incorrect by using a formula to say "Good" if the answer is correct and "uh-oh" if the answer is incorrect. The quiz will also track the student's points earned for each correct answer. This format allows the students to take the quiz as many times as they desire until they get the score that the desire. This format also allows for easy grading on the teacher's part.