OpenTest ExcelTemplate | test construction template


Within the QCK we have developed an open Excel template that teachers and teams of authors can use to develop tests and exams, outside of the testing program in use. The use of this template is free. You need the QuestionConverter program (paid) to export from the template to various open test standards and a range of specific test programs. Besides that we can export to IMS QTI 2.1 format, the template can also be exported to several other open standards and a range of well-known testing platforms. Prefer to use an editor? We have that too: QuestionEditor.


Information with the template

  • There are nine question types to choose from, via a pull-down list. The questions can be entered and further points, demerits, sources and metadata. It depends on the target program what can be read from it.
  • Question types: multiple choice, multiple response, short answer, numeric, open, match, order, fill in the blanks, select.
  • On the [Tab] 'Template' you can enter the questions.
  • On the [Tab] 'Example' you will find two detailed examples for each question type to be used.
  • On the [Tab] 'Help' you will find an explanation of all options for each question type.
  • More about: [ multiple choice ]. [ multiple response ],[ short answer ],  [ numeric ], [ open ], [ match ], [ order ], [ fill in ], [ select ].

Downloading the template is possible from March 2023.

(c) opdendrieberg | disclaimer: opdendrieberg makes this template freely available, but is not responsible for its use.


Example of questions in the OpenTest ExcelTemplate