How to Import Multiple Questions from Excel Spreadsheet in Storyline2?


Create an Excel sheet with the following columns:

  • Quiz Question Type
  • Score Points
  • Questions
  • Answer Choices (Answer Option1,Answer Option2,…)


In Quiz Question Type we can use abbreviations like: 
 
Abbreviation
Question Type
TF
True/False
MC
Multiple Choice
MR
Multiple Response
FIB
Fill in the Blank
WB
Word Bank
MD
Matching Drag and Drop
MDN
Matching Drop-down
SD
Sequence Drag and Drop
SDN
Sequence Drop-down
NUM
Numeric
LIK
Likert
PO
Pick One
PM
Pick Many
WW
Which Word
SA
Short Answer
ESS
Essay
RD
Ranking Drag and Drop
RDN
Ranking Drop-down
HM
How Many

 
Score Pointscolumn is used for graded questions, we can allot marks to correct answers in each quiz. The Points can range from -1000 to 1000. Points for incorrect answers are not supported.

Questions Text is required for all questions. In This column you can add your questions as shown below.

Answer Choices are required for all graded question types.
You can make upto 10 columns for answer choices and the correct answers are denoted by an Asterisk (*). In the example given below * True and all the underlined options are the correct answers.
 
For choice-level feedback, separate each answer choice and its feedback with a pipe (|) as shown in the image below.

For matching questions, separate each answer choice and its match with a pipe (|).

 
Click HERE to download the free excel spreadsheet used in this demonstration.

Comments are closed.

× How can we help you? Available on SundayMondayTuesdayWednesdayThursdayFridaySaturday

He was a German psychologist who is known for discovering the forgetting curve. According to this curve, the biggest decline in memory happens within 20 minutes, and then 1 hour.