Students have the option to add External assessors on the "fly" when submitting assessment to external assessors (Refer to the ePortfolio Submission to an external assessor, UQ student guide). Schools may wish to identify External assessors that have been added by students between particular dates.

To do this you will need to:

  • Copy the list of External assessors in your school (Department in Chalk and Wire) at the start date. i.e. the start of semester.
  • Optionally, keep a master list of all External assessors added by UQ Adminstration staff / Course coordinators i.e. this list would contain First name, Last name and Email address 
  • Copy the list of External assessors in your school (Department in Chalk and Wire) at the end date. i.e. the end of semester.
  • Use the spreadsheet template compare-external-assessor-lists.xlsx to produce a list of External assessors added between particular dates.

Copy External assessors list

  1. Access to ePortfolio (i.e. click on any ePortfolio link in your Learn.UQ course)
  2. Select Menu > Contact List Manager
  3. Click on Department Contact Lists.

Contact List Manager

  1. Select your school (Department in Chalk and Wire).
  2. Click on the Show All button.

Show All

  1. Highlight the names and paste into the template spreadsheet (see instructions below).

Highlight names

 

Identify External assessors added by students

  1. Save and open the spreadsheet template compare-external-assessor-lists.xlsx.
  2. At the start date (i.e. the start of semester) copy the list External assessors from the ePortfolio system and paste the list into cell A2 (highlighted blue).
  3. Save the spreadsheet.
  4. At the end date (i.e. the start of semester) copy the list External assessors from the ePortfolio system and paste the list into cell C2 (highlighted green).
  5. Optionally copy the master list of External assessors added by UQ Administration staff / Course coordinators into cells G2, H2, I2 (highlighted orange).
  6. Column E will display all the new External assessors that have been added since the start date.
  7. Column F will display all the new External assessors that are also not on the master list.

Note:  The spreadsheet formulas only cater for lists of up to 2000 names.

spreadsheet

Duplicate names

Note: The spreadsheet formulas will not identify if new External assessor names that are duplicates of names on the start date list.

  1. Duplicate names in column A (Start of Semester list) are highlighted green.
  2. Duplicate names in column D (End of Semester list) are highlighted red.

Display only new External assessor names

  1. Click on the down arrow on column E (New External Assessor?).
  2. Uncheck OK and (Blanks).
  3. Click the OK button.

OR

  1. Click on the down arrow on column F (New names not on Master list?).
  2. Uncheck OK and (Blanks).
  3. Click the OK button.

sort

View and edit External assessors

If you need to view or edit the new External assessors identified, refer to the Edit or Delete a Contact or Guest guide by Chalk&Wire.

Note: External assessor accounts cannot be deleted but you can request that they are no longer displayed. Log a job by emailing help@elearning.uq.edu.au with a list of External assessor names and email addresses.