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 file 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, Moodle, and Akindi Format

If the exam files are ZipGrade/Quick Key/Moodle/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', 'id number', 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). Additional information in the column name is ignored.

  4. In each question column cell, a positive number indicates the student answered 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.

Note that ZipGrade's standard output format complies with characteristics above. ZipGrade's full output format does not and is incompatible with the program.

Google Forms Quizzes

Google Forms quizzes are slightly different than the other formats highlighted here as Forms do not have question numbers and student ids aren't automatically collected. This results in two important points to keep in mind:

  1. The instructor must place a student id question on the quiz. This column can be named 'id', 'student id', 'external id', or 'id number'. The question doesn't need to be worth a positive number of points.

  2. The question number is implied by the order of the questions on the Form.

The responses can be downloaded from the responses tab, more section (three dots), or download responses (.csv). The software will assume any question worth a positive number of points is a quiz question. Other questions will be ignored.

Blackboard Format

In some Blackboard installs, the instructor can download comma separated by question and user. This support is considered experimental as the format seems to vary by institution. The program assumes the following:

  1. There are columns named 'Question ID', 'Possible Points', 'Auto Score', and 'Manual Score'.

  2. Either a column for id ('id', 'student id', 'external id', or 'id number') or username ('username') appears in the file.

  3. The values in the 'Question ID' column end with a numerical value representing the question number (e.g. 'Question ID 14').

Custom Format

If your exam software is not currently supported, you can create a custom exam spreadsheet with a column for student id followed by columns for each question. An example spreadsheet might look like the following:

















Where "1" indicates the student answered the question correct and "0" indicates the student did not answer the question correct.

Last updated