Surpass lets you import items into subjects. This is useful if you have pre-existing content on your database or are creating a large volume of items. Use the Import items from other sources functionality to import items into Surpass from either a QTI file or a spreadsheet. This lets you create a large quantity of items quickly.
This article explains how to import items into a subject from spreadsheets and QTI files.
In this article
1. Choose your import type
In your subject, select Create New Item to open the Import menu. Choose Import items from other sources.
Select your import type (Spreadsheet, QTI 2.1, or QTI 1.2.1) in the Import items from other sources dialog menu.
Import type compatibilities
Each import type has different capabilities and compatibilities. Expand the following section to view a table comparing the import types.
|Content||Spreadsheet||QTI 2.1||QTI 1.2.1|
|Fill in the blank|
|Select from a list|
|Drag and Drop|
|Basic and survey pages|
|Audio and video|
|Maximum Candidate Selections (Multiple Choice)|
|Standard marking (Multiple Choice)|
|Standard marking (Multiple Response)|
|Randomise answer options order (Multiple Choice and Multiple Response)|
|Single-column answer options (Multiple Choice and Multiple Response)|
|Number of lines for candidate response (Essay)|
|Images in answer options|
|Multiple question blocks|
Creating a spreadsheet
Spreadsheets must adhere to a strict format if they are to be imported into Surpass successfully. Select Download Sample XLS to get a pre-formatted empty spreadsheet. Refer to the Help and Guidelines sheet for details on each column’s content requirements. Enter content in the Item List sheet.
Expand the following section for information on how to input data in an import spreadsheet.
The name of the item.
|The first ten characters of Question Text.|
Question text or instructions to candidates.
NOTE: This field is mandatory if Type is set to InformationPage, Essay, or left blank.
|Option A – Option H||
The answer options for the question.To create an Either/Or question, only enter values in Option A and Option B.
To create a Multiple Choice or Multiple Response question, add three or more options.
Set to 1 to create a Multiple Choice question.Enter a value higher than 1 to create a Multiple Response question.
|Award Partial Marks||
Gives candidates a percentage of the Total Mark for each correct answer given in a Multiple Response question.
The question’s correct answer(s). Enter the letter of the relevant Option and separate multiple entries with a comma (for example, a for Option A and a,c for Option A and Option C).
The total number of marks available for the question.
Give an image page including the file extension to include an image in the item (for example, images\image1.jpg).
IMPORTANT: If you are importing images, you must upload a ZIP file containing the import spreadsheet and an image folder called images.
Enter the Unit the item is associated with.
Enter the Learning Outcomes the item is associated with. Separate values with a pipe | (for example, Learning Outcome 1 | Learning Outcome 2).
Enter the Keywords the item is associated with. Separate values with a pipe | (for example, Keyword 1 | Keyword 2).
The folder the item is to be contained in.
The purpose of the item. Acceptable values are Summative, Formative, and Unspecified. If left blank, items are set to Unspecified.
Determines whether the answer options are randomised in delivery.
The owner of the item.
TIP: Item owners are used to allocate items to assignees in Authoring tasks. For more information, read Creating an Authoring task.
The type of item that is created. Available values are ItemSet, InformationPage, and Essay.
Leave blank to create either a Multiple Choice, Multiple Response, or Either/Or question based on the Option and Max Selections fields.
The name of the item set containing the item.
Determines whether rationale is displayed for Multiple Choice and Multiple Response questions.
To add a custom tag group, edit the column header using the following format: customtag_name. You can enter a maximum of 20 custom tag groups, each with a limit of 50 tag groups separated by pipes |.
2. Choose your import file
Select Import to open your device’s file explorer.
Choose the file you want to import and select Open to start the upload.
3. Import items
After you select Open, Surpass begins copying the items from the upload file to the destination subject. The Importing Items dialog gives you a real-time feed of how many items have been successfully imported and if there are any errors.
After the items have been imported, select View Report on the dialog to download a CSV detailing any issues with their respective error codes. For example, you might have errors if upload file tag values are not defined in the destination subject.
4. View imported items
In your subject, the imported items are contained in a folder using the following naming convention: [upload file name] Import.