data download format in CSV file
Mark here on Jay's account as I don't seem to have a bugzilla ID....
Downloaded CSV files from the datacart are not rectangular, they are normalized. We discussed this several times. Faculty need a rectangular dataset even though it offends database sensibilities.
i very much thought we had agreed that the data would be returned as one table so that users would not have to join different tables on their own.
That was my understanding as well. I'm perplexed about what problem this bug actually expresses.
added a new "pivot" option when downloading data.
the dataset can now be returned with questions and metadata for each question as a separate column rather than a row.
csv sample for a single student taking an exam with three questions.
This is an actual file downloaded from my local system.
It is a single-question exam taken by 11 students. No response data was captured, only scores.
Notice that the vocab/value is in a single column - this is different from what we had decided on at the last meeting, but I believe it is the last outstanding item to address for this data return format.
I've split the vocab/value into two columns (nbii | Biopolymers) as agreed on last week.
without the "transponse" box checked
with the "transpose" box checked
addressed the comments from today's meeting:
-html is stripped out for both return formats
-studentIds are changed to sequential numbers
-studentId column labels are relabeled "recordNum"
-duplicate true/false values for the metadata matrix are omitted
Original Bugzilla ID was 3876
Also available in: Atom