I am a teacher and use Canvas-LMS for my course. The course is broken into smaller groups led by individual teaching assistants, who grade student assignments in their own section. Canvas only provides an option to download all student submissions to a given assignment. Downloaded submissions are automatically renamed in a single folder with the format lastName_firstNameRandomNumber_SubmissionTime.pdf.
I have another Excel spreadsheet of student’s names and their group numbers.
I would like to make some kind of script that can:
- compare the portion of the file name and the student name in the Excel sheet;
- find the group number in the Excel sheet and prepend it to the file name
group1_lastName_*.pdf; - sort the renamed submission files into folders such as
group1andgroup2.
