Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The question import via Excel files allows you to import multiple questions at once in simple way. The import of excel questions can for example be used to import questions from other systems when the questions do also support the QTI 2.1 standards. Please use the template which can be found when opening the import.

At this time the following question types are supported:

  • Single-Choice
  • Multiple-Choice
  • Kprim
  • Fill-in-blank
  • Essay
  • Match
  • Drag and Drop
  • TrueFalse


When you are finished creating your questions in the Excel file, select the the questions in Excel and copy&paste them to the input field.

Info
When copying the questions, Excel will convert the cells to a comma separated formatting. The same does also work with other tools like Apple Numbers or OpenOffice.


Keywords

The table consists of two, three or four columns: the keywords / points, the values and extra information. The questions are separated with an empty line.



Multiple-choice question

type

MC for multiple-choice

title

Title of the question / topic

question

The question text. Minimal HTML formatting is allowed.

max. answersMax. number of possible answers.
min. answersMin. number of possible answers.
points

The maximal score. The minimal score is always set to 0.

"1" for a correct option, "0" for a wrong option

Options text. You can have as many options as you like, each on a separated line with a point configuration





Single-choice question

type

SC for single-choice

title

Title of the question / topic

question

The question text. Minimal HTML formatting is allowed.

points

The maximal score. The minimal score is always set to 0.

Points when this option is selected, e.g. "1" (correct) or "-1" (incorrect)

Options text. You can have as many options as you like, each on a separated line with a "0" or "1" point configuration



Fill-in-blank (gap) question

type

FIB for fill-in-blank


title

Title of the question / topic


points

The maximal score. The minimal score is always set to 0.


textA text element

Points when the gap is correctly answered, e.g. "1" 

Correct answer in a gap. Synonyms can be entered separated with ";".

Size of the gap and the maximum characters that can be entered is configured, e.g. "10,8".



KPRIM question

typeKPRIM
titleTitle of the question / topic
questionThe question text. Minimal HTML formatting is allowed.
points1
+ or -Options text
+ or -Options text
+ or -Options text
+ or -Options text



Essay question

typeESSAY
titleTitle of the question / topic
questionThe question text. Minimal HTML formatting is allowed.
pointsThe maximal score. The minimal score is always set to 0.
minMinimum word count
maxMaximum word count



MATCH question

typeMATCH

titleTitle of the question / topic

questionThe question text. Minimal HTML formatting is allowed.

pointsThe maximal score. The minimal score is always set to 0.


ABC
Antwort 11 (correct answer)0 (false answer)0 (false answer)
Antwort 2001
Antwort 3010



Drag and Drop question

typeKPRIM

titleTitle of the question / topic

questionThe question text. Minimal HTML formatting is allowed.

pointsThe maximal score. The minimal score is always set to 0.


AlgerienKeniaNamibia
Nairobi0 (false answer)1 (correct answer)0 (false answer)
Windhoek001
Algier100



TrueFalse question

typeTruefalse

titleTitle of the question / topic

questionThe question text. Minimal HTML formatting is allowed.

pointsMaximum achievable score. The minimum score is 0.


UnansweredRightWrong
Paris is in France01 (
korrekte Antwort
correct answer)0 (
falsche Antwort
false answer)
Bern is in Switzerland010
Stockholm is in Danmark001



Optional meta data for question pool

description

Question description to set the question into context.

subject

The taxonomy path. The hierarchies are separated with slashes. Not existing path elements are automatically created.
Example: /Languages/German/Verbs

topicTopic of the question
keywordsKeywords
coverageCoverage of the question
level

Level of use, e.g. "College"

language

Language, e.g. "de" or "en"

typical learning time

Typical learning time, e.g. "5min"

difficulty index Item difficulty
standard deviation

Standard deviation of item

discrimination index

Item discrimination index

distractors

Number of distractors

editor

Used editor, e.g. "OpenOLAT Excel Import"

hinthint for the test participant
correct solutionCorrect solution, only shown if the solution is wrong
feedback correct answerFeedback, if all answers are correct
feedback wrong answerFeedback, if at least one answer is wrong
editor version

The editor version

license

License, e.g. "CC by-nc-nd"


In addition to the mentioned meta data there are some more data fields to add. Find more details in the Excel template which is provided during the import process.