A prof should be able to download an excel spreadsheet with
a) A tab listing each student in rows with columns and their data (including links to the relevant group, project, etc)
b) A tab for each group, with rows for group info, and with a cell in each row that gathers together the members (Prof. Lethidge can show the needed formula)
c) A tab for each project, with info about status etc.
It should be possible to use this as a backup too, i.e. to re-load the database from this database. There should be the option when re-loading to just reload any differences, or to erase all data for the cohort and reload, or to just erase any matching students, projects and groups and reload.
Any prof should be able to load just the data relevant to their sections (cohorts). The admin should be able to upload all.
Note this spreadsheet would be different from the one loaded with new students that comes from Brightspace.
A prof should be able to download an excel spreadsheet with
a) A tab listing each student in rows with columns and their data (including links to the relevant group, project, etc) b) A tab for each group, with rows for group info, and with a cell in each row that gathers together the members (Prof. Lethidge can show the needed formula) c) A tab for each project, with info about status etc.
It should be possible to use this as a backup too, i.e. to re-load the database from this database. There should be the option when re-loading to just reload any differences, or to erase all data for the cohort and reload, or to just erase any matching students, projects and groups and reload.
Any prof should be able to load just the data relevant to their sections (cohorts). The admin should be able to upload all.
Note this spreadsheet would be different from the one loaded with new students that comes from Brightspace.