Upload a Drill
Instead of manually creating a Drill, you can also upload a Drill.
This can be done via:
- A comma-separated file (an Excel file that will be saved as a .csv file).
- WRTS 1.0 or 2.0 file
- A hot Potatoes Quiz file
See the upload page for more information about uploading files.
Upload an excel/.csv file
You can import a csv. file in Drillster to easily add your existing content to Drillster, provided that the file has been edited in a certain format.
We recommend using Google Sheets to create the .csv file. This because Excel can have different settings per language.
The entries given in columns A and B may contain multiple correct answers. If several correct answers belong to the same cell, they may be separated by a slash. For example: "big/tall". If a drill consists of multiple columns, or if feedback or context data is to be included, use columns C and D.
Incorrect alternatives (distractors) that belong to the same column, will be entered in the same line as the correct answer. The incorrect alternatives will be preceded by a “@” sign and will be separated from the other alternatives by a “/” (slash) sign. An example is “apple/@pear/@banana/@grape”.
It is possible to add columns. A new column can be added behind the shown columns and Drillster will add those columns to the drill. If feedback or context information needs to be added, this can also be done by using the above structure. Once the drill has been uploaded, the context or feedback function can be activated in the drop-down menu next to the column name in the “editor”.
Pay attention: always save the Excel spreadsheet in .csv (comma separated or comma delimited).
- To upload the .csv file in Drillster:
- Click "create new drill" in my content.
- Then click the tab "Upload"
- Click the function "Choose file" to select the .csv file you'd like to upload.
- Click "Import" and Drillster will add the drill to your content.
- There are two options you can select in the import screen:
- Validate only:
Drillster will only verify whether the file has the correct layout and can be uploaded. When this option is selected, Drillster will not yet convert the file to a drill.
- Import another file when finished:
Drillster will not go to the Drill details screen of the Drill that has just been imported, but it will return to the import screen so you can import another .csv file
After “import” has been clicked, the Drill will be created and the “edit” screen will be shown after clicking “edit”. The drill can be checked and changes can be made if necessary. Also, the question styles can be edited, alternatives added, etc.
The IMS Question and Test Interoperability specification (QTI) defines a standard format for the representation of assessment (https://en.wikipedia.org/wiki/Educational_assessment) content and results, supporting the exchange of this material between authoring and delivery systems, repositories (https://en.wiktionary.org/wiki/repository) and other learning management systems (https://en.wikipedia.org/wiki/Learning_management_systems) . It allows assessment materials to be authored and delivered on multiple systems interchangeably. It is, therefore, designed to facilitate interoperability (https://en.wikipedia.org/wiki/Interoperability) between systems.
If questionnaires are exported in QTI format, they can be uploaded in Drillster, using the upload mechanism.
Pay attention: To save the changes made in a drill, a drill has to be released first. This can be done by clicking “Release this version” on top of the page. Once a drill version is released, the changes that are made can be seen by practicing the drill. Furthermore, you can publish it in the drill store, forward it to other users, define tests for it *, add it to groups* and more. *(if your account allows you to)