Importing questions with an Excel file

Last modified: 2017-03-01 10:31:03 +0100

To quickly add questions to the environment, you can use a CSV file and send it the support team of aNewSpring to import these questions.


How?

First download the CSV file you will find at the bottom of the article. The CSV file has a number of columns of which you should not edit the names. Carefully read the explanations about the columns below to prevent mistakes.

Note! The file has to be filled in very accurately to be sure the questions are imported correctly and without error. Please read the instructions below carefully.

Ident (obligatory, maximal 21 characters)
This column requires a unique code (for example ABC-001), to tell the system that each row contains a different question. If you want to import a second file into the same content folder and you use the same Ident for a question, this question will be overwritten.

Folder (optional)
Enter the name of the folder in which you want to place the questions. You can put questions in a sub folder by adding a '/' between the folder names: First_folder/Second_folder. You can create as many layers as you want. If you do not enter a folder name, the questions will be placed in the main folder. If you add here a folder name that doesn't exist in the content library, this new folder will be created.

ExamTerm (optional)
Enter the exam term. For more information about exam terms, read this article: 'What are exam terms?'

InternalLink (optional)
You can add information (a referal to a content part) to the feedback of a question. Enter the exact title of the content part here. Do not enter the title if the content part has an ID. Then enter 'ID|' and add the content part ID. Example: ID|123

UseInternalLinkDefaultTitle (obligatory if InternalLink has been used)
Enter No if the title for 'More information' should be the same as the title of the content part. Enter Yes if the title should be 'More information'.

CaseText (optional)
You can add information (a referal to a content part) to the question. Enter the exact title of the content part here. Do not enter the title if the content part has an ID. Then enter 'ID|' and add the content part ID. Example: ID|123

UseCaseTextDefaultTitle (obligatory if CaseText has been filled in)
Enter No if the title for 'More information' should be the same as the title of the content part. Enter Yes if the title should be 'More information'.

Type (obligatory)
Enter the abbreviations of the type of questions that you want to use. Also see this article: 'What question type should I choose?'

  • MC = Multiple choice (only one correct answer),
  • MR = Multiple response (a combination of answers is correct),
  • E = Open question/essay item,
  • FiB = Fill-in-the-blank,
  • HS = Hotspot question. We advise you not to use an Excel file for this type of question, because it is easy to make mistakes with the coordinates in the column 'Answer1'.

Encode (obligatory)
Enter No if you use HTML codes/tags. Special characters can also be handled as HTML, so take that into account. You can use HTML tags to make text bold or italic for example. If you do not want to use this option, enter Yes. Special characters and line breaks will automatically be converted to HTML this way.

ID (optional)
You can have a clearer overview by entering an ID, it 'identifies' the question and it is only visible to you. If you do use this, make sure that each question has a unique ID. (This is only necessary if the questions are in the same folder).

Title (obligatory)
Enter the title of the question. It needs to be unique, unless you have entered an ID.

Question (obligatory)
Enter the question.

Image (optional)
Enter the file name of an image that you want to add to the question. Please send the images you set to use along with the import file (read about this at the end of the article).

Sound (optional)
Enter the file name of a sound file that you want to add to the question. Please send the sound files you set to use along with the import file (read about this at the end of the article).

Before (optional)
This is for FiB questions. Here you can enter the text that comes before the input field.

Answer1 - Answer12 (at least one answer is obligatory)
For MC and MR questions you can enter multiple answers into different columns. For FiB questions you need to fill in Answer1. You can fill in multiple answers, but if you do this, you cannot edit your FiB question anymore after it has been imported into aNewSpring. For an E question you can only enter the model answer into Answer1. For a hotspot question you should enter the coordinates to the correct area of the image.

AbcVisible (optional)
No = if the ABC formating for the answers has to be hidden.

After (optional)
This is for FiB questions. Here you can enter the text that comes after the input field.

Shuffle (obligatory)
Enter Yes if you want to shuffle the answers. Enter No if you want them in a fixed order.

FiBType (obligatory when using FiB)
You need to use this for FiB questions. Enter String if learners can enter all kinds of characters. Enter Decimal if they can only enter numbers.

CaseSensitive (obligatory when using FiB)
Yes = case sensitive, No = Not case sensitive.

HSType (obligatory when using HS)
Enter 'Bounded'. This column is for HS questions. We advise you not to use an Excel file for this type of question, because it is easy to make mistakes with the coordinates in the column 'Answer1'.

HSImage (obligatory when using HS)

MaxScore (obligatory)
You can put this by default on 1.0. If you want to make a question count extra you can enter 2.0 for example.

Correct (obligatory when using MC and MR questions)
Only for MC and MR questions. For MC questions you should enter one number (e.g. 3) which corresponds with the correct answer. For MR questions you can enter multiple numbers, divided by a comma and without spaces.

up to and including AU - Feedback1 - Feedback12 (optional)
For FiB questions and MR questions you can only fill in Feedback1 and Feedback2. In Feedback1 you should enter the correct feedback. In Feedback2 the incorrect feedback. For MC questions you can fill all cells in these columns. If the learner chooses Answer1, they will see the text of Feedback1, etc.
If you leave these columns empty, standard feedback will be generated.

Locale (optional)

You can specify a specific language for the standard feedback.
These are the options:

  • da (Danish)
  • en (English)
  • nl (Dutch)
  • de (German)
  • fr (French)
  • it (Italian)
  • es (Spanish)
  • zh (Mandarin Chinese)
  • sv (Swedish)

Finished with filling in the CSV file?

Save it as CSV, separated by a semicolon (;), not comma (,) and send it to support@anewspring.com.

If you want to import images and sound files along with the CSV file you can also send these to us. Place the images in a folder called 'images' and sound files in a folder called 'sounds'. Put these folders in a ZIP file and send it to us.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.
Can you please tell us how we can improve this article?