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


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

points

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

question

The question text. Minimal HTML formatting is allowed.

"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

points

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

question

The question text. Minimal HTML formatting is allowed.

Points when this option is selected, e.g. "1" or "-1"

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.

question

The question text. Minimal HTML formatting is allowed.

textA text element

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

Correct answer in a gap. Synonyms can be entered separated with ";". The gap lines have a third column where the 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
titleTopic
questionTitle of the question
pointsThe maximal score. The minimal score is always set to 0.
minMinimum word count
maxMaximum word count



MATCH question

typeMATCH

titleTopic

questionTitle of the question

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

titleTopic

questionTitle of the question

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


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



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
keywords KeywordsKeywords
coverage Coverage Coverage 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"


Neben den aufgeführten Feldern gibt es noch weitere optionale Felder wie "Topic", "Keywords", "License" usw. Weitere Details dazu finden Sie in der im Rahmen des Importprozesses bereitgestellten Datei "Vorlage Excelimport"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.