Assignment submissions can be exported from Angel to a CSV file, which contains all the students' answers and a mapping of values 1 and 0 to indicate whether or not they're correct. To process the data in a standard way, we'll create an Excel file with a reformatted version of this data.
- Go to Home and select a course from the Courses box
- Click in Lessons
- Navigate to the assignment location
- Hover the mouse pointer over the assignment for option links to appear underneath
- Click on "Utilities" (*)
- Click on "Export Posted Submissions"
- (*) Obs.: This is for Angel 7.3. A separate "Submissions" option exists in Angel 7.4, which will be used instead of "Utilities" in this case. The new version is planned to be installed by August 3, 2011.
In the Export screen (fig. 8)
- File Format: CSV
- You can leave all the options checked by default
- Click OK button
Save the file to a desired location
Obs.: In the CSV file each row (after 4th) belongs to a student submission. After the "GRADED BY" column, there are columns with the answers (each titled with the question text in row 3) and after them, "mapping" columns with values 1 or 0, representing whether or not the student answer was correct, respectively. They are related by the identifiers in row 4, e.g. FIELD_4daeaa8e-ad08-4117-85ab-e020fecc2a60 matches VAL_FIELD_4daeaa8e-ad08-4117-85ab-e020fecc2a60. See figure 9 for illustration
The "standard" Excel file needs to be generated from the CSV, with a worksheet within it for every question. Each question worksheet will pair the answers and the mapping (1 or 0 values) for that question only. This will simplify further analysis of the data.
- Open the CSV file
- Create a new Excel file
For each question in the CSV file
- Create a worksheet in the new file
- Copy the columns RESPONSE ID, GRADE, NAME, Login Name and DATE SUBMITTED to the new worksheet
- Copy the question column to the new worksheet
- Copy the corresponding mapping column to the new worksheet. Remember to verify the identifiers in row 4 for every match (like FIELD_4daeaa8e-ad08-4117-85ab-e020fecc2a60 matchingVAL_FIELD_4daeaa8e-ad08-4117-85ab-e020fecc2a60)
- Figure 10 shows a sample Excel file, with one worksheet per question, for the previously displayed CSV file.