I have a quiz that I need to do some special grading on (if they answered a for 1 and c for 2 then they get X pts, but b for ...). When I export the "Student Analysis" report (CSV) the student responses come in as the text of the answer. This is a pain because (1) the answers often have special characters in them that are difficult to decipher/distinguish when I open in Excel and (2) Excel mangles the results because it tries to interpret them as dates/formulae etc.
Is there any way to just get the student responses as the response letter/number they chose rather than the text of the answer? This would make it so much easier to analyze the file.
PS Yes, I know that I could import the CSV into excel rather than just opening it and tell excel to read everything as text so that it doesn't reformat it. And yes I could figure out what the answers are for each question (once they've been converted to weird characters in the CSV file) and then write a lookup conversion in excel to make this a,b,c... or 1,2,3... output. Having started down this path and realizing what a pain it was I was hoping that there was an easier way. Thanks!