Importing Students & Student Data - New Portal Beta

May 18, 2017 Rex McWilliams

Importing allows Administrators to add multiple students to courses at once. This is important as assessments are assigned to courses, which can then be assigned to individual students within that course. Note, courses must be created within the portal before attempting to import students to either.

To Import Student Data

1. Open the Admin drop-down menu, and choose Users.

2. Select the Students sub-tab.

3. Click Import.

4. Review the XLS Template to create a data file.

5. All cells in the spreadsheet need to be formatted as Text. Select cells and right click to choose Format Cells in number column, select Text and click Ok.

6. Create data files and save as .XLS or .XLSX.

7. Select Choose Files, locate file, and select Open. The file will automatically begin importing.


Importing Student Information

Users can import all pertinent information about each student. Students may be assigned to accommodation groups for special assessment requirements (i.e. extended time, non-secure mode for all exams). Within this import file, Users can match students to their courses. Note, the courses must already have been created within the portal.  All information can be edited later as needed.

1. To create a data file, review column headings in the sample file.

2. Enter student information into the appropriate column fields.

  • ExamTakerID - The Alphanumeric Identifier for the student.
  • LName - Student's last name.
  • FName - Student's first name.
  • Email - The email address for the student where all email notifications will be sent.
  • LabEquip - n = Personal computer, y = lab user (If student is using both a lab device and a personal computer, input n).
  • NonSecure - n = Secure, y = Non-Secure, for all assessments.
  • ExtraTime - 0 = no extra time, 150 = 150% extra time, 200 = 200% extra time, for all assessments.
  • CourseID - Unique identifier for the Course(s). When importing a student to multiple existing courses, separate each CourseID with a comma and a single space.
  • External ID - This value must match the ID for the student within your SAML database. If this does not apply, you may leave this field blank.

3. Save the file as either an .XLS or .XLSX file.

Previous Article
Assessment Review and Scoring - New Portal Beta
Assessment Review and Scoring - New Portal Beta

Next QRG
WIRIS Equation and Formulae Editor - New Portal Beta
WIRIS Equation and Formulae Editor - New Portal Beta