Grading with Excel

Introduction

This functionality makes it possible to grade candidates without using Inspera Assessments built-in grading tool. The feature is available for graders only.

Instruction

Export grades to xls-format:

Note: While the export is available for Planners, it will only contain the candidate list and not the grades. Any existing grades will only be included when a grader downloads the file. 

1. Select Grading in the main menu, and find the relevant test.
2. From the Download-menu, select Grades to Excel:

3. A xls-file will immediately be downloaded to your computer:

The file will contain to columns only, Candidate ID and Grade.
If the candidates have not been given any grades yet, the Grade column will be empty.

Import grades from .xls

If you wish to enter grades in Excel instead of doing it inside Inspera Assessment, follow these steps:

1. Download a .xsl-file as described above.
2. Open the file in Excel or similar and input grades.
   The grades in the Excel-file, must coincide with the grading scale used for the test.
3. Click the Grades from XLS-option:
   
4. Locate and select the .xls-file on your computer. Press Done when finished.