Why Would I Want to Export My Students' Answers?
The Export Student Answers feature provides valuable insights into your students' progress. This tool allows you to:
- Determine which students have started the lesson and monitor how far they have progressed.
- Review all student responses in one place, even outside the grading process.
- Collate responses from surveys or other lesson questions into a .csv file for advanced analytics and reporting.
For example, if your lesson includes a survey, exporting the answers into a .csv file enables you to conduct custom analytics and gather meaningful insights from your students' responses.
How to Export Student Answers
To export a .csv file containing your students' responses to questions within a lesson:
- Navigate to Course Progress.
- Locate the desired lesson from the list.
- Click the overflow menu (three vertical dots) next to the lesson.
- Select Export Student Answers from the dropdown menu.
Fig. 1: Accessing the Export Student Answers Option
What Does the .csv File Look Like?
The exported .csv file is organized so that:
- Each student has their own row.
- Responses to each question are arranged in separate columns.
- Students who have not started the lesson are excluded from the file.
The file includes:
- Location and panel type for every question.
- Model answers and grading instructions (if applicable).
Cells corresponding to unanswered questions will display “Not Answered.” Note that the exported file does not indicate whether answers are correct or incorrect and does not apply numeric grades.
Fig. 2: Example of an Exported .csv File
By default:
- All column widths are equal.
- Cell text does not wrap.
These settings can be adjusted in the software used to view the .csv file, such as Microsoft Excel or Google Sheets.