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
- Access your Inspera test for marking
- Add graders to an Inspera test
- Add late-enrolled students to Inspera assessment CSV
- Add media content to questions in Inspera
- Add one-time users to an Inspera test
- Add the Assumption and Queries question in an Inspera exam
- Adding Resources (pdf files, links) to a Question Set
- 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
- Answer key corrections - MCQ
- Apply Alternative Exam Arrangements (AEAs) and Time Zone Adjustments in Inspera
- Assign questions to graders in Inspera
- Complete an Inspera test as a student
- Confirm grades in Inspera
- Copying a question set from Staff Training to Production
- Create an Inspera 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
- Edit question weight in Inspera
- Enable After-test settings in Inspera
- Enrolling students in an Inspera assessment using CSV file
- Explanations on student responses
- Export/Import questions from Blackboard to Inspera
- Exporting a Question Set to PDF
- False Start
- Filter functionality in Inspera marking
- Flag students in Inspera test
- Getting started with Inspera
- Grading workflow for Planners and Graders
- 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 Grade Workspaces
- Inspera Observed User Testing
- Inspera Question Set Version Control
- Inspera Recommended Assessment - Standard (non-exam) assessment - webpage
- Inspera Rubrics
- Inspera School-based Exams
- Inspera Test settings
- Inspera analytics
- Inspera central on-campus and off-campus exams
- Inspera marking navigation
- Inviting students to an assessment via Test Code
- Late submissions and extensions in Inspera Assessment
- Manually marked questions: Mark and feedback
- Monitor Assessment
- Name and label questions in Inspera Assessment
- Navigate Inspera
- Override scoring of questions in Inspera
- Question sets in Inspera Assessment
- 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
- View student responses in Inspera