NAME

dump-past-answers.pl: This script dumps past answers from courses into a CSV file.

SYNOPSIS

dump-past-answers.pl [options]

Options:
    -c|--course          Course from which to dump past answers
    -f|--output-file     CSV file name to dump past answers to
    -h|--help            Show this help

The course option can be repeated multiple times to dump past answers from multiple courses into the same file. If no courses are given via this option, then past answers from all courses will be dumped.

If the output-file option is not given then past-answers-$current_unix_time.csv will be used for the output file name.

DESCRIPTION

The CSV file that is generated has the following columns:

ID info

0 - Answer ID
1 - Course ID
2 - Student ID
3 - Set ID
4 - Problem ID

User Info

5 - Permission Level
6 - User Course Status

Set Info

7 - Set type
8 - Open Date (unix time)
9 - Reduced Scoring Date (unix time)
    10 - Due Date (unix time)
11 - Answer Date (unix time)
12 - Final Set Grade (percentage)

Problem Info

13 - Problem Path
14 - Problem Value
15 - Problem Max Attempts
16 - Problem Seed
17 - Attempted
18 - Final Incorrect Attempts
19 - Final Correct Attempts
20 - Final Status

OPL Info

21 - Subject
22 - Chapter
23 - Section
24 - Keywords

Answer Info

25 - Answer timestamp (unix time)
26 - Attempt Number
27 - Raw status of attempt (percentage of correct blanks)
28 - Number of Answer Blanks
29/30 etc... - The following columns will come in pairs.  The first will be
               the text of the answer contained in the answer blank
               and the second will be the binary 0/1 status of the answer
               blank.  There will be as many pairs as answer blanks.