Description
What? Inspera allows you to import multiple-choice quiz questions, but they need to be in a specific format. Copilot can convert your existing questions into the format that Inspera can automatically import.
Why? If you have existing quizzes, manually putting them into the required format for Inspera can be almost as time consuming as creating the quizzes from scratch. Getting Copilot to do this can be a big time saver.
What do I need to know? While Inspera does allow you to import different types of questions, from my testing this worked best with multiple-choice questions, so that’s what this recipe focuses on.
📺 Example Video
Video – Import multiple-choice quiz questions into Inspera (media.ac.uk)
Instructions
Step 1: Go to Copilot (office.com/chat) and sign in with your Coventry account. If you’re already using Copilot, just select the ‘New chat’ button at the top right.
Step 2: Start the conversation by copying and pasting the following prompt into Copilot. Now click the paper clip emoji 📎 and upload the document containing your quiz (Microsoft Word format works best). Select the ‘Submit’ button (the arrow at the bottom-right) to proceed.
🤖 Prompt (click to expand, then copy and paste into Copilot)
I’m going to upload a doc with a quiz. First, I want you to ask me what module the quiz is for. Wait for my response. Then go through the doc and identify all the single-answer multiple-choice questions. Ignore questions that have multiple correct answers, or any questions that only have one correct answer with no answer options to choose from. <br><br>Then I want you to put them into a table in this format:<br><br>QuestionType QuestionName QuestionText Randomize OptionText IsCorrect OptionText IsCorrect OptionText IsCorrect OptionText IsCorrect OptionText IsCorrect OptionText IsCorrect multiple_choice 4000SOP Presidential Election Who won the <b>2020 US Presidential election</b>? 1 Donald <b>Bold formatted</b> Trump Joe <b>Bold Biden</b> 1 Barack <i>Italic Obama</i><br><br>For the ‘Question Name’, use this format: [Module Code] [Question Name]. After you make the table, instruct me to copy the cells I need and use ‘Paste Special > Text’ or ‘Paste Special > Values only’ to paste into the ‘Excel’Blank Inspera QTI Template’ in plain text.
Step 3: Copilot should ask you what module your quiz is for. Type the module code and press Enter on your keyboard, or select ‘Submit’.
Step 4: Copilot should now go through your document, pull out all the multiple-choice questions and put them into a table in the required format.
Step 5: Download this blank Inspera template and open it in Excel:
This template was adapted from the one provided by Inspera.
Step 6: Select all the content in the table Copilot has created excluding the header row. Then, in the blank Inspera template you downloaded in Step 5, right-click in cell A3 and select ‘Paste Special > Values only’. If you can’t see that option, select ‘Paste Special > Paste Special > Text only’. This will paste in the questions without any formatting. Save the excel template with a meaningful name, e.g. the name of the module and test.
Step 7: Go to the Inspera test instance and log in. Select the ‘Author’ tab, then select the small downwards arrow ⌄ next to the red ‘Create new’ button at the top right. Select ‘Import from QTI’. This will open a file explorer window.
Step 8: At the bottom of the file explorer window, where it says ‘Format: Zip Archive’ change it to ‘All Files’. You can now find the excel template you created in Step 6 and select it, then select ‘Open’.
Step 9: Inspera will ask you what you want to do with duplicate questions – select ‘Create New’.
Step 10: You should see a success message with the number of questions that were imported. Close this pop-up, then click the ‘Created by me’ filter and you should see ‘Test from Excel’ at the top of the list. If you can’t see it, refresh your browser tab.
Step 11: Click on the ‘Test from Excel’ and change the name – see Inspera Naming Conventions – The Teaching Knowledge Base (coventry.domains).
Step 12: Delete the first question as it was just the sample from the template. Then check through the other questions to make sure everything imported correctly.
Important: Always check Copilot’s output. Generative AI tools can hallucinate (create plausible but incorrect information).