...
This function on dev was modified to be UCDavis-specific, exporting fields including: Site Title, Course Site, Course Provider ID, Student Name, Student ID (Kerberos ID), and Course Grade.
He then imported the file to the Final Grade Submission (fgs) dev site to demonstrate the ease of use. The file uploaded successfully, showing grades for the students graded in Sakai and the fgs error message messages for ungraded students.
He explained that there are two types of error messages possible on a successful import: 1)
- standard notice for
...
- students where no grade is submitted, and
...
- issues with gradining based on student level, e.g., where pass/non-pass is indicated differently for a grad student vs an undergrad. FGS grading error message points out where an incorrect grade type is entered and shows the selections possible for that student.
The current upload process checks and matches for the correct number of fields, and will work whether the spreadsheet is coming from sakai or myucdavis. There is some brittleness to the unpload in that faculty must not change/rearrange columns and errors may arise from additional tabs or spreadsheet entries beyond the last row.
...