As a training professional for almost 30 years, I’ve observed that many employees prefer to take a self-assessment rather than answer questions in front of a large group. Creating a simple self-checking game involves opening a spreadsheet, entering questions in the first column, leaving the second column blank for answers and setting up formulas with the right answers in the third column. You can create a self-assessment to ensure reading comprehension of complex documents, test knowledge new terminology and vocabulary or quiz participants on new policies and procedures.
For example, enter a question into cell A1. Leave B1 blank. In cell C1, enter an IF function. For example, generate a question like: “What color is the sky on a clear day?” then into cell C2, enter: =IF(B1=”Blue”,”Right!”,”Enter the correct answer.”) Blue is the correct answer. So, if the person enters “Blue,” she gets “Right!” displayed in C1. Otherwise, she gets “Enter the correct answer.” displayed.
Once you have created your self-check, you can add some color with conditional formatting of Column C. Select C1. From the Home menu, select the Conditional Formatting button, and choose the Highlight Cell Rules option and then Equal To… item. Enter “Right!” and click the OK button. You can also adjust the color to green fill with a white font. Repeat the process to make the color of the box red if the answer is wrong.
Hide the self-check column so that people can’t see the answers. Select C1 and right-mouse click and select the Format Cells… item. Then, click the Locked and Hidden buttons and press the OK button. Next go to cell B1 to allow user input. Right-mouse click and select the Format Cells.. item and un-click the Locked and Hidden buttons and press the OK button. From the Review menu, select the Protect Sheet button and click Select Unlocked Cells and click the OK button. You can add a password for added protection. To un-protect the document, from the Review menu, select the Un-protect Sheet button. Save your file.
You can distribute the self-checking game through email or publish the file on your website. Or, you can conduct a meeting and answer the questions as a group, award points to people who answer the questions correctly.