When using multiple lines in the questions (as supported by the RCE), the question text in the csv export (Student Analysis and Item Analysis) also becomes multilined, causing the double quote indicating the text part to be on another line than the first line. When importing the csv in data applications, texts on new lines are not associated with the correct column and the rest of the data after the questions is interpreted as text and not as data, breaking the csv format.
Important: Student Analysis and Item Analysis reports are not available in New Quizzes
Steps to reproduce:
Import attached quiz in a Canvas course
Complete quiz using a student account
Generate Student Analysis report csv and Item Analysis report csv
Import csv's in a data application, e.g. Excel
Recognize data structure is not recognized correctly in the data tool
Analyse the csv files to see that the new lines in the questions become new lines in the csv, breaking the csv format.
Expected behavior:
Data tools interpret one line per row. Multiline question texts could either have \n newline indicators (\t for tabs) and have the complete question in one line, or the question is shortened in the csv file, making sure that questions texts stay unique.
Actual behavior:
Multiline questions cause corrupted data when importing into data tools.
Summary:
When using multiple lines in the questions (as supported by the RCE), the question text in the csv export (Student Analysis and Item Analysis) also becomes multilined, causing the double quote indicating the text part to be on another line than the first line. When importing the csv in data applications, texts on new lines are not associated with the correct column and the rest of the data after the questions is interpreted as text and not as data, breaking the csv format.
Important: Student Analysis and Item Analysis reports are not available in New Quizzes
Steps to reproduce:
Expected behavior:
Data tools interpret one line per row. Multiline question texts could either have \n newline indicators (\t for tabs) and have the complete question in one line, or the question is shortened in the csv file, making sure that questions texts stay unique.
Actual behavior:
Multiline questions cause corrupted data when importing into data tools.
Additional notes:
Samples attached: QTI sample quiz, Student Analysis report csv and Item Analysis report csv: Quiz reports csv bug QTI.zip Quiz reports csv bug Quiz Item Analysis Report.csv Quiz reports csv bug Quiz Student Analysis Report.csv