Include points for individual questions in 'Export to CSV'

[malyzajko]

Right now the export to CSV file under the Grading tab only exports (among others) the overall grades or points for all questions together. It would be nice if the points for individual questions could also be included in the export.

The motivation for this is that it will make it easier to adapt to different grading schemes (e.g. by exporting, applying grading, importing grades to Canvas or some other system).

[martin-henz]

This shouldn't be very hard, so I'm marking it as a "good first issue". @RichDom2185 correct me if I'm wrong.

[martin-henz]

Here is some documentation from Canvas regarding the format.

How do I import grades in the Gradebook_ - Instructure Community.pdf

[martin-henz]

Here is an example exported canvas file at NUS. [student name and SIS changed, obviously]

2023-06-28T1714_Grades-CS4215_anonymized.csv

Import format should be similar.

[clementlemon02]

I would propose to change the CSV format to this

This new format contains extra columns for individual questions points, I have also removed question count and questions graded column. In the new format, points in the individual questions column will be displayed as NA if question is ungraded, 0 for zero points. The assessment Name column will be removed, and each sheet/table will be categorised as the assessment name instead.

If the format of all assessments grouped into one sheet/table is preferred, we can merge the assessments into one table and include the assessments name as the headers on top.

The rationale for this new proposed format is because it

1. Includes the points for individual questions.
2. Is compatible with the import format for canvas

@malyzajko what do you think about the proposed format, feel free to provide comments!

[malyzajko]

This looks good to me!