Synap Academy


How to set up your question spreadsheet and use the importer to create and update questions in bulk.
Put your questions into a spreadsheet and follow the template available on Quiz > Import or use the link below.

📇 Import fields

Synap ID: This is where the unique id that Synap uses to locate your questions exists. You need to leave this blank if you’re uploading new questions.
External ID: Use this id to call your question something so you or your team can identify it easily if you ever need to export it. In this example I’ve called mine charlottes_portal_exampleQuestion_q1. You can use a sheet CONCATENATE function and “_” instead of spaces to create this id, check out Google's guide on concatenation.
Question: Add in your questions stem. Field accepts HTML. If you’re not comfortable using HTML you can create your questions in plain text on a sheet and add the formatting in after through the built in question editor.
Options: Add between 1 and 26 options like Option A to Option Z. If you want to use image answer options instead, you need to use the field Option A URL.
Options URL: To create image answer options, use the Option URL fields. Image answer options created in these fields instead of the standard option fields display better on platform and allow users to open up a pop up to zoom in. See below.
Answer options as Images
Correct Options: Use the letter from the option field that has the correct option in it to make the correct option on the spreadsheet. This may be a single letter or separated by a ‘,’ if there is more than one correct answer
One correct option vs either multiple correct or ranked
Feedback: This field also accepts HTML. Use feedback to give your users reasoning into the answers of the question. This is handy if you are creating questions for revision purposes. In general if you’re writing an exam you do not need to use this field.
EMQ Synap ID: This is a unique Synap ID that is created when a new EMQ is created. For a more detailed guide into EMQ creation on Synap, If you're not using EMQs please leave this blank. See here for our guide on importing and EMQs
Tags: Use tags to group questions together. Multiple tags should be separated by a comma You'll need to tag your questions correctly and give them facets to leverage Synap's analytics (Fractal) .
Tags on a CSV
See below to find out more about Fractal results and Tags
Calculator: Accepted inputs are TRUE or FALSE only. True if you want a calculator to show on screen during the quiz.
Time in ms: Leave this blank if you want to do an overall time for the quiz, this live slightly separately to the import. But if you'd like a time per question this field accepts ms, 1 second = 1000ms
Ranked: Expects TRUE or FALSE. True if the question options are ranked and the user must reorder the questions to get the mark. Note if Ranked = TRUE your Correct Options will need to be separated by a comma, ordered first to last in terms of order. If Option A need to be at the top, option C at the bottom and Option B in the middle, Correct Options needs to be A,B,C
Multiple Correct: Expects TRUE or FALSE. True will enforce answers are shown as multiple correct, the system tries to infer multiple correct when there is more than one answer in Correct Options. Use this if you want a multiple correct question type that only has one correct answer option.
Free Text: Expects TRUE or FALSE. True means users must type a response. Use Option A field to input instructions above the text box.
Upload: Expects TRUE or FALSE. True means users must upload a document as their response. Use Option A field to input instructions above the text box.
use the Option A field to define instructions above text box or upload area
Side-by-Side Layout?: Expects TRUE or FALSE. True will enforce questions are displayed on the left and answers are on the right, rather than questions on the top and answers below.
Randomised Options: Expects TRUE or FALSE. True if you want the options to be randomised.
Credits: Expects a numerical value. Leave blank for the default value set on the quiz

🚀 Using the importer

Once you've got your sheet ready, download it as a CSV and head over to import on the quiz you want to import into, select your file.
Check all of your fields have been mapped correctly. From the confirmation page you'll be shown any errors with your CSV. Confirm the field mapping and resolve any errors before starting the import. You can check tags are in place
When everything is in place, start the import, and review your questions.