Enrol students in Inspera test using CSV file (Original)

1. Click on the course list file (spreadsheet) downloaded in previous step.
2. Select yes to open the file.

3. Delete all columns except for the Username column (Column C).

4. 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).

5. 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.

6. Place your cursor in the bottom-right corner of the cell.

7. 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.

8. Select the entire column (column B) containing the email addresses.

9. Right-click the selected column and choose Copy from the context menu.

10. 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.

11. Go to File > Save As.
12. Choose a location to save your file.
13. Give your file a name; e.g Inspera upload.
14. From the file type list, choose CSV (Comma delimited) (*.csv).

15. Click on the Save button.

The complete file should have the following format without any formula.