Forum Discussion
Import Excel Question in Storyline
Hi !
I have the excel sheet for import but I would like to know the format for the below in Excel :
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
If there is One excel sheet for each of the above format kindly share.
Thank you
5 Replies
Hi Mukesh,
Happy to help here!
The format for those questions would follow this:
- Question Type
- Points
- Question Text
- Answer Choices
We also have an excel template with an example question that should help with the formatting. You can locate the template as well as more details about this here:
Please let us know if you have any questions!
Hi !,
I already have the template. My question is I want the format for
example for MD
(Matching Drag and Drop)In my excel row should it be
MD 1 A B C *a *b *c d e f
where A matches a
B matches b
C matches c
d , e , f are extra choicesTF 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
Hi Mukesh,
Happy to help clarify! The link Vincent sent above helps specify how to input for that question:
- For matching questions, separate each answer choice and its match with a pipe (|).
Example: Texas | Austin
So in your case,
- Answer 1 will be: A | a
- Answer 2 will be B | b
Let us know if you have further questions!
Hi Ren,
I've been using this template recently for quizzes and it has been very helpful to automate the process and a lot quicker to build.
I was wondering if it is possible, in the excel template, to add a column that creates custom feedback for either Correct, Incorrect, Try again and/or Post-quiz review as part of this process?
It feels like there should be a way, but I'm not sure if there is or how.
Many thanks
- For matching questions, separate each answer choice and its match with a pipe (|).
Hi Ben, and welcome to E-Learning Heroes. 😊
Thanks for reaching out and sharing what you would like to create in your project.
Based on your description, it sounds like you are looking to customize your feedback masters for your question slides. Take a look at the following tutorial:
