Exam Files

The software reads most common exam formats without modification. Just make sure your students fill in their student id.

With rare exception, providing the software the exam output file will 'just work.' In all cases, you need to provide the exam results in CSV format - which is the default in most cases. The following describes how the software determines the exam format.

Scantron Format

The software assumes Scantron formatted exam files have the following characteristics:

  1. The first row is the answer key

  2. The second column is the student id

  3. The third column of the first row specifies the number of questions

  4. The fourth column and higher are the student answers

The software will compare the answer key (first row) to each student's answer thereby determining if the student correctly answered the question.

Canvas Format

If the files is in Canvas Student Analysis format (under Quiz Statistics), the program assumes it has the following characteristics.

  1. The first row of the file specifies the column names

  2. There is a column named 'attempt'

  3. The column 'id' or 'sis_id' contain the student ids. If both exist, sis_id will be used.

  4. Students receive some positive number of points when they answer correct. If they receive fewer than these points, the software will assume they answered incorrect.

ZipGrade, Quick Key, and Akindi Format

If the exam files are ZipGrade/Quick Key/Akindi formatted, the software assumes the files have the following characteristics:

  1. The first row of the file specifies the column names

  2. There is a column named 'id', 'student id', 'external id', or 'zipgrade id' specifying a unique id number for each student

  3. Each exam question column is named 'Q' followed by the question number (e.g. 'Q67' for question 67)

  4. In each question column cell, '1' indicates they got it correct and {'0', ' ', 'a', 'b', 'c', 'd', 'e'} indicates the student got the question wrong. Both ZipGrade and Quick Key place a '1' in any cell where the student correctly answered the question. ZipGrade places a '0' in any cell where the student got it wrong while Quick Key puts the (incorrect) student response ({' ', 'a', 'b', 'c', 'd', 'e'}). Akindi's columns are the same but the values differ.

  5. If the column 'Grade' exists in the input file, the program will assume the 'Q' columns are in Akindi's format. Each cell containing {'a', 'b', 'c', 'd', 'e'} will be marked correct while all other values will be counted as incorrect. Akindi places the response in each cell of the column; if the response is incorrect, the response is wrapped in parentheses.