UPDATE: This question import template also works with Storyline 2. The process is virtually identical. See this tutorial for details on importing your Excel spreadsheet into Storyline 2.
One of my favorite new updates that came in Articulate Quizmaker ’13 is the ability to import questions from text and Excel files. This feature has the potential to save you and your subject matter experts (SMEs) a ton of time managing the questions in your e-learning courses.
To prepare my import file, the first thing I did was create a simple fill-in-the-blank form in Excel. It’s a great way to organize your question set and collect questions from geographically dispersed SMEs or clients.
The beauty of the Excel template is that anyone can easily write, share, and review the questions, which you can then import directly into Quizmaker. It’s a great way to guide SMEs providing questions for your course—just send them the template and ask them to fill in the blanks. Or, better yet, post it in a shared location online and watch the questions roll in.
So, in a nutshell, you and your SMEs can use this fill-in-the-bank template to:
- Create questions easily by filling in a simple form
- Choose from many different question types
- Share questions easily with other authors or SMEs to review or edit
- Enter feedback for each question choice
- Import the questions directly into Quizmaker
Opening the template
When you open the template, Excel’s built-in protections might open this file in Protected View. If you see the yellow Protected View message bar, click the Enable Editing button so you can work in the spreadsheet.
Since this template has some built-in macros, you may also see a yellow Security Warning message bar. Click the Enable Content button to allow the macros to do their thing.
Working with the template
Hopefully, it’s pretty straightforward to use the template. Take a look at this video walk through below to see how it works.
You can also grab a printable job aid that covers the basics of working with the input form.
Importing questions to Quizmaker
When you’re ready to import your questions to Quizmaker, here are the steps to take:
1. Create a new quiz, or open an existing one.
2. Click the round Articulate button in the upper left corner, and select Import Questions.
3. Browse to the Excel spreadsheet that contains the questions you want to import, and click Open.
4. Quizmaker displays a list of questions from the spreadsheet you selected. Mark the questions you want to import.
5. Click the OK button to complete the import process.
You can check out this tutorial for more details about importing questions. I hope this helps you and your SMEs save some time getting questions into your courses.
If you want to try this yourself but don’t have Studio ’13, no problem. Just sign up for a fully functional, free trial. And don’t forget to post your questions and comments in the forums. We’re here to help! For more e-learning tips, examples, and downloads, follow us on Twitter.