Using the Excel Import Template

Feb 04, 2016

We started asking all SMEs to provide questions through the Excel Template.

Which is great.

 

But.. when I have a multiple choice question with detailed feedbacks - I get an error that it can't be imported with each choice having a separate feedback.

How do I define it to work that way?

Or even how do I define that I can have the feedbacks imported with the questions? (so far used it for quizzes that had no feedbacks, now I have ~20 compliance quizzes all with detailed feedbacks...)

12 Replies
Leslie McKerchie

Hi Efrat!

As you can see in this tutorial, choice level feedback is only available for some question types, such as Multiple Choice, Word Bank, Pick One, Which Word, Freeform Pick One, and Freeform Hotspot.

So, your multiple choice question should allow this when you import.

Do you have a sample question that you could share so that we could take a look? You are welcome to share your spreadsheet.

Efrat Maor

I was trying to use it for Multiple choice - but got an error saying it can't be done of an option level (just question level probably).
So first, I don't get it why an option level can't be done on the Excel if it can be done in QM.
Second, how do I define even a question level? Just the 1st wrong and the right one?
Where should it go so I won't get an error?

 

Leslie McKerchie

It should work, even the example provided in our documentation here uses a MC question type. I am attaching for you.

The question level cannot be defined on import and will default to the basic feedback in the quiz.

If you use the same model in this example, it should work.

Please note that replying via e-mail attaches your signature. You are welcome to pop in and edit and again, if we need to take a look, feel free to share.

Ashley Terwilliger-Pollard

Hi Ludovic,

It's not added to our excel import yet, and as you can see, this discussion is a bit older, but not a popular request it seems.   Here's a bit more about how we work to prioritize feature requests. And, you're always welcome and encouraged to submit a feature request to our team using that form.

Benjamin Walsh

Hey guys, are there any updates on this? I import a lot of questions using a spreadsheet, and, while "choice level" works, it would be nice to have the question level option.

I agree with Ludovic, I think it could be as simple as having a column Question_Level with a TRUE/FALSE parameter, followed by a Question_Level_Feedback column which accepts text input, but maybe it's a lot more complicated than that?

I'll attach an example of how Litmos SAP does it. They are an LMS so, of course, it's a little bit different, but they only allow question level feedback (as opposed to choice level feedback), and have you surround the text with HTML tags. 

This discussion is closed. You can start a new discussion or contact Articulate Support.