Enrol students in an Inspera assessment using CSV file
This guide provides instructions on enrolling students in an Inspera assessment using CSV file. This method is used in:
- central exam
- create committees using CSV
Four steps are involved:
- Create a CSV file for Inspera
- Add student details to the CSV file for Inspera
- Upload your CSV file to your Inspera assessment
- Transfer marks to your Learn.UQ course site
Add student details to the CSV file for Inspera
Note: You will need to download your class list from your Learn.UQ (Blackboard) course site prior to completing the below steps. For further information on downloading your class list from your Learn.UQ course site, refer to the Download a Spreadsheet from the Grade Centre guide.
- Open the downloaded spreadsheet from Grade Centre.
- Delete all columns except for the Username column (Column C).
- Delete the Header row (Row 1).
Tip: For further information on how to delete a column, refer to the Insert or delete rows and columns guide (by Microsoft).
- In the first row of the second column (cell B1), enter the formula =A1&"@uq.edu.au" and press Enter.
Note: This will take the Username from the first column and add the @uq.edu.au to the end, resulting in the student’s email address being filled into the second column.
- Place your cursor in the bottom-right corner of the cell.
- Double-click to fill the whole column with the formula you just added in the first row. This will result in the other students' email addresses being filled into their respective cells.
- Select the entire column (column B) containing the email addresses.
- Right-click the selected column and choose Copy from the context menu.
- Right-click the selected column again and choose Paste Values from the context menu.
Note: This will remove the formula and replace it with the actual email addresses.
- Go to File > Save As.
- Choose a location to save your file.
- Give your file a name.
- From the file type list, choose CSV (Comma delimited) (*.csv).
- Click on the Save button.
Upload your CSV file to your Inspera assessment
- Log into Inspera Assessment (https://uqi.inspera.com/admin).
- Set up your assessment via Deliver > Tests.
- Scroll down to the Candidates heading.
- Click on the Manage button.
- The Candidates window appears. Click on the Add button.
- From the drop-down menu, select CSV Import (SSO).
- Click on the Click here to select file button from the CSV Import (SSO) dialogue box.
- Choose the CSV file you saved earlier.
- Click on the Open button.
- The file will upload and a message will display if the students have been successfully added.
- Click on the Close button.
- The student's Usernames (e.g., s1234567) will appear in the Candidates list. Click on the Close button to return to the main assessment setup page.
Tip: Alternative Examination Arrangements can be applied prior to closing the Candidate's list.
- Continue applying other settings specific to your assessment. For further information, refer to the following guides:
Transfer marks to your Learn.UQ course site
Once your assessment has been marked, you will need to manually transfer these marks across to your Learn.UQ course site. For further information, refer to the Transferring marks from Inspera to Learn.UQ course guide.
- Academic Integrity & Assessment Security in Inspera
- Access Inspera
- Add graders to the test/exam
- Add late-enrolled students to Inspera assessment CSV
- Add media content to questions in Inspera
- Add the Assumption and Queries question in an Inspera exam
- Adding Resources (pdf files, links) to a Question Set
- Adding one-time users to Inspera for testing
- Adding staff (contributors) to an Inspera assessment
- Adding the Academic Integrity Statement to your assessment
- Additional pages required for Inspera exams
- Alternative method for downloading Final Marks from Inspera
- Apply Alternative Exam Arrangements (AEAs) and Time Zone Adjustments in Inspera
- Assign questions to graders in Inspera
- Confirm grades
- Copying a question set from Staff Training to Production
- Create an Inspera assessment submission link in Learn.UQ
- Create an Inspera test in Deliver
- Create bands and criteria
- Create marking committees in Inspera
- Create marking committees using CSV
- Creating Questions
- Downloading responses to Assumptions and Queries
- Enable After test settings
- Enrolling students in an Inspera assessment using CSV file
- Explanations in Inspera
- Export/Import questions from Blackboard to Inspera
- Exporting a Question Set to PDF
- False Start
- Getting started with Inspera
- Images in Inspera Assessment
- Incident Adjustments for students who experience technical delays
- Inspera Assessment Design Settings
- Inspera Assessment Environments and their Purposes
- Inspera Assessment User Roles
- Inspera Assessment access methods for students
- Inspera Exam Requests
- Inspera Observed User Testing
- Inspera Question Set Version Control
- Inspera Recommended Assessment - Standard (non-exam) assessment - webpage
- Inspera Rubrics
- Inspera School-based Exams
- Inspera analytics
- Inspera central on-campus and off-campus exams
- Inspera test setup explained
- Inviting students to an assessment via Test Code
- Late submissions and extensions in Inspera Assessment
- Mark and feedback in Inspera
- Monitor Assessment
- Name and label questions in Inspera Assessment
- Navigate Inspera
- Navigate Inspera workspaces
- Question sets in Inspera Assessment
- Release results
- Sections in Question Sets
- Sharing a question set in Inspera Assessment
- Student Arrives Late
- Supporting students to use Inspera Assessment
- Things to look for in review
- Transfer results from Inspera to your Learn.UQ course
- Turnitin similarity report in Inspera
- Video and audio in Inspera Assessment