Nedlastinger Poeng og karakterer som CSV

Available for Planners and Graders.

You can download the marks and grades for each candidate on each question in a test once the test is closed. 


How to download Marks and grades as CSV

  1. Navigate to the Grade module.
  2. Click Options Marks and grades as CSV.
  3. A CSV file will automatically generate.



How to read the Marks and grades CSV

If you download Marks and grades as CSV before the graders confirm their marking, the final grade column will remain empty. 

The file can be opened in Excel or a Google sheet by importing data from the file menu. Be sure to select comma as the field delimiter.

Columns in the .csv file 

CandidateExternalId Candidate ID for the candidate
UserID Internal Inspera database user ID of the candidate
QuestionNo The questions will be numbered as they are in the test, for example, alphanumeric. Question types Document and Form are excluded.
QuestionTitle Title of the question

Any update that requires the question to be saved will update the revision ID

  • Updating the question text, including formatting changes and adding/removing media

  • Updating Answer keys

  • Updating scoring

QuestionId Internal Inspera database ID of the question

If the question is manually marked, the user id and username of the evaluator will be shown in these columns, otherwise, it will be empty/null.

  • Tests with individual marks workflow: If more than one grader has marked the question, each grader will be shown in a separate column.
  • Tests with shared marks workflow: The user ID will be replaced with a workgroup ID, and the ID of individual graders is not included.

Manually graded scores are listed here, and the value will be empty/null for automatically marked questions.

If a grader has overridden an automatically marked question, this column will contain the value of the overridden mark.  


For automatically marked questions, this column will show the calculated score.


This column displays the final grade. The column will remain empty if grading is not confirmed.



Below is an example with two candidates and eight questions, two manually marked and six automatically marked. The final grade for both candidates is an A.



Artikler i denne seksjonen

Var denne artikkelen nyttig?
0 av 0 syntes dette var nyttig