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. When using Excel the following format can be used:
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".
- 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 repertoire.
- 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 wil 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.
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)