This functionality makes it possible to grade candidates without using Inspera Assessment's built-in grading tool. You can set the final grade on all the candidates on the test.

This article explains all the steps to grade with Excel, and shares important notes.

Step 1: Download grades as Excel file

This is available for Graders and Planners.

Start by downloading the excel file.

1. Within the Grade module, click on the Option dropdown menu. 
2. Under Download select Grades as Excel file.
3. An XLS file will be saved to the hard drive. 

Step 2: View XLS file and grade

The file will contain the following columns:

• Candidate ID
• Grade

If the candidates have not been given any grades yet, the Grade column will be empty.

Start grading:

1. Open the file (in Excel or similar software) and input the grades.
2. The grades in the file must coincide with the grading scale used for the assessment. 

Step 3: Import Grades from Excel

This is available only to Graders.

1. When grading is complete, go back to the Grade module. 

2. In the Options dropdown menu, under Import select Grades from Excel.

   

3. Click on the Confirm button.
4. Select the XLS file on your harddrive.
5. Click on Open.

Important to note

• Only grades with a corresponding Candidate ID will be imported. The candidate ID cannot be changed in the Excel file.
• If you use the grading scale Pass/Fail or Passed/Not passed, you need to register the grades as Pass/NotPass in the Excel document for the import to work.
• Grades in the XLS file will overwrite any existing grades in Inspera Assessment.
• Empty grades (cells) in XLS will not overwrite existing grades in Inspera Assessment.
• You can re-upload your XLS at any time.
• Candidates who have not started the test will get status Submitted if a grade is imported.