Import questions into Polling @ McGill with Vevox
With Vevox, you can bulk import multiple polls or surveys into a session using an Excel template. This is ideal for large question banks, or if you would like to make content uploads quicker.
To prepare your polls for importing, you will need to download a copy of the template:
Log into the Vevox dashboard and select an existing session, or create a new one.
Click the arrow next to the + Create New button and select Import polls or Import surveys.
Click download sample template.
Once you have the Excel template, you can populate the sample sheet with your questions.
Formatting questions in the Excel template
To import question into Vevox using the template, you will need to format the questions correctly. The following table lists the mandatory and optional column (or field) headers and explains their use. The Excel template also includes sample questions to help you fill in your template.
Column header | |
|---|---|
Type | This is where you enter the type of question you want to import. This is always a required field, if you do not enter a type then you will receive an error when attempting to import the Excel file. The valid values for the 'type' are:
|
Title | This is always a required field. Every question type requires a title; if you do not enter a title of the question, you will receive an error when attempting to import the Excel file. |
SurveyName | This is an optional field and only relevant if you import questions into the Surveys section of Vevox. If you import questions into the Polls section, this field is ignored. If the field is left blank, all questions will be grouped into one unnamed survey when imported. You can give each question the same survey name or use different survey names for questions, and they will all be grouped into surveys of their respective name. |
Choice | This field is used for question types where you can specify a number of choices. Each choice you want to specify must have its own column. For example, if there are 4 possible choices then there must be 4 choice columns. This is a required field for the following question types: MCQ, Ranking, and RatingScale. If you populate this field for other question types, then it will be ignored when importing. |
CorrectAnswer | This is an optional field for questions that support a correct answer. It can be used for the following question types: MCQ, Text, Ranking, and Numeric. The value entered in this column must always be a numerical value. For example, if you have an MCQ question with 4 choices and the correct answer is the value you entered in the third choice column, the correct answer must be 3. |
AllowedSelections | This field is used for question types where you can specify the number of selections a participant is allowed to make. It is valid for the following question types: MCQ and Ranking. If you populate this field for other question types, then it will be ignored when importing. |
Minimum | This is an optional field used for the Numeric question type only. It is used to specify the minimum value that you want to be accepted as the input. It must be used in conjunction with a maximum value. |
Maximum | This is an optional field used for the Numeric or RatingScale question types. For Numeric questions, it is used to specify the maximum value that you want to be accepted as the input. It must be used in conjunction with a minimum value. |
NumberOfDecimals | This is an optional field used for the Numeric question type only. It is used to specify the maximum number of decimal places you would like to accept. If left blank, no decimal places will be accepted as the input. |
LowerLabel | This field is for the RatingScale question type only. It specifies the label for the lowest value on the scale. |
UpperLabel | This field is for the RatingScale question type only. It specifies the label for the highest value on the scale. |
The Excel template does not support the importing of XY plot or Pin on image questions types.
If certain columns are not needed, you can delete them from the Excel template, or leave them blank.
Once you you have populated the Excel template, save it and return to the Import polls window. Click Upload file or drag and drop the template onto the upload box to see a preview of the polls to be imported. You can deselect any polls you want to exclude before clicking Import.
Once imported, the polls will appear in your dashboard, where you can edit, move, duplicate, add images, or delete them as needed.
Read more:
Vevox Documentation:
While this resource is accessible worldwide, McGill University is on land which has served and continues to serve as a site of meeting and exchange amongst Indigenous peoples, including the Haudenosaunee and Anishinabeg nations. Teaching and Learning Services acknowledges and thanks the diverse Indigenous peoples whose footsteps mark this territory on which peoples of the world now gather. This land acknowledgment is shared as a starting point to provide context for further learning and action.
McLennan Library Building 3415 McTavish Street Suite MS-12(ground level), Montreal, Quebec H3A 0C8 | Tel.: 514-398-6648 | Fax: 514-398-8465 | Email: tls@mcgill.ca