Tips for creating and counting quizzes
I'm not sure where to actually post this (I'm sure someone will punish me, tell me where, after I voted for me of course - expected).
I am developing a bunch of files for security training at my facility. The user interface is built in Excel with Excel VBA to get the names and training program to run. The Excel file opens the PowerPoint presentation after getting your name and the program you want and logs that data. When you finish your presentation, it opens as a Word survey document for that presentation.
My problem is this: Currently, all of our tests are generated in Word (I hardly know Word VBA) and would like to continue by just adding some text boxes and checkboxes for the answers. I would like to add code to make it easier to automatically count these tests by putting a button at the end that "locks" the test (so they can't change the answers), then validate and return the test result.
I can't see where Word Files can be locked like in Excel "Protect Sheet". The scoring I am using seems to be wrong, but this is a problem that I can solve later if I stay with Word. I am wondering if it would not be better, or maybe easier, to do this in Excel as it is configured more for evaluating data entry.
Look for any tips on what others might do if they had the choice to use Word or Excel to create tests. I currently have no preference (other than the above, which I am not locked into) which format to use, perhaps even using a separate PowerPoint presentation as the test itself.
source to share
To answer the question: what you are doing seems very funny in terms of VBA and in terms of user interface, but it seems to me that your intuition is telling you to move the test to succeed, and I think this is the right thing to do. You have a lot more options for blocking a test, you can easily run multiple tests and create a multi-problem curve, etc.
source to share