Staff Selection System

Tip 8.6: Offline Batch Input of Test and Final Assessment Results (Excel)

To download:

  1. In the job opening, click on Batch Action at the bottom of the page.
  2. Click on Download List for Test Result or Download List for Final Evaluation, depending on the stage of the staff selection process.


    Click image to open expanded view
  3. On the next page, check the types of applicants, normally Shortlist, for recording the results.
  4. Click on Search.
  5. On the next page, click on Select All at the bottom centre of the page. The evaluation may be conducted in smaller batches.
  6. Click on Download Applicants.


    Click image to open expanded view
  7. When prompted by the system, save the file in a preferred location. Make sure that the document is saved with an .xml extension, which is the default.
  8. At the top of the page, click on Download Offline Test Result Template or
    Download Offline Final Evaluation Template, as applicable.
  9. Save the Excel file in a preferred location and open the file. The Excel file has two worksheets: Introduction and Applicants.
  10. In the Introduction worksheet of the Excel file, click on Import Applicant Data, the first grey rectangle.


    Click image to open expanded view
  11. When prompted, find and open the .xml file which was previously downloaded. The applicant information will be automatically uploaded into the Applicants worksheet of the Excel file.
  12. Proceed to fill the fields in the Applicants worksheet (e.g. Ratings, Comments, Test scores, Assessment date).

To upload:

  1. Once the template is filled out, in the Introduction worksheet of the Excel file, click Export Applicant Data, the green rectangle.
  2. In the job opening, click on Batch Action at the bottom of the page.


    Click image to open expanded view
  3. Click on Upload List of Test Result or Upload List of Final Evaluation, as appropriate.
  4. On the next page, click Upload File.
  5. This time mark the Upload Offline Evaluation checkbox.


    Click image to open expanded view
  6. Click on Upload Applicants.
  7. A pop-up will appear for choosing the export file, which was previously created.
  8. Find and open the export file.
  9. Click on the Upload button.
  10. Click on Select All on the lower left side of the page.
  11. On the next page, review and spot check that the fields have been filled correctly and click Select All on the lower left side of the page.


    Click image to open expanded view
  12. Click on Save. The next page will provide a status of the upload and errors, if any. Click OK.
  13. Click on Return to Previous Page.

)footnote1




Last modified: 1 August 2023