Grade with Excel (Classic marking)

  • Updated

The is available for Graders.

The grading in Excel functionality makes it possible to grade submissions offline, without using Inspera Assessments built-in grading tool. To grade in Excel, you must first export the grades to a supported file format, complete the grading offline, and then import the file back into Inspera Assessment. This article will walk you through all the necessary steps.

This feature requires activation. Please contact the Service Desk to activate it for your Inspera Assessment tenancy.

Step 1: Export grades to xls format

  1. Go to the Grade module and select the test you want to grade.
  2. Click on Grade you candidates.
  3. Click on the Download dropdown menu on the top right corner.

  4. Select Grades to Excel.

    excel1.png

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. 

Step 2: View xls file and grade

  1. An xls-file will immediately be downloaded to your computer.

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

    excel2.png

  3. Input the grades you want. The grades in the Excel file, must coincide with the grading scale used for the test.

Step 3: Import grades from xls

After you complete grading in Excel, you must import the file back into Inspera Assessment.

  1. Click the Import dropdown menu.

  2. Select Grades from Excel.

    excel3.png

  3. A warning message will appear. Review the information before continuing.
  4. Click Browse, and locate and select the xls file on your computer. 
  5. Press Done when finished.

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 the XLS file will not overwrite existing grades in Inspera Assessment.
  • You can re-upload your XLS file at any time.
  • Candidates who have not started the test will get status Submitted if a grade is imported.

Was this article helpful?

6 out of 17 found this helpful