If you want to be able to export the file to Excel (via CSV file), you need all this data as attributes.
Then you create a document for each student (with their ID and name in separate columns, one of which should be the Documents column).
For the grades, you need to create similar document, but with the assignment name and grade included. Then when dealing with the same student, you can just copy and paste the previous assignment document and edit the assignment part of it.
So, the tree will look like this:
Code: Select all
Student ID | Student Name | Assignment name | Assignment grade
[-] ID 1 | Name 1 | (empty) | (empty)
- ID 1 | Name 1 | Assignment 1 | Grade 1
- ID 1 | Name 1 | Assignment 2 | Grade 2
- ID 1 | Name 1 | Assignment 3 | Grade 3
[+] ID 2 | Name 2 | (empty) | (empty)
You can export this file using File > Export > CSV file (use the ; separator, so the Excel can open it easier).