...
- The Course Management Final Grading system must accept .csv files exported from Sakai with the following columns:
- Site Title: Unparsed label field.
- Site ID: Parsed unique course identifier of the form (term_yearterm_idcrn).
- Provider ID: Parsed unique course identifier of the form (term_yearterm_idcrn) or (term_yearterm_idcrn).
- Student Name: Unparsed label field.
- Student ID: Parsed unique student identifier (kerberos_name).
- Course Grade: Parsed two-letter grading code (valid Banner gradecode).
- Accepted files must be parsed to resolve valid grading tuples (Course,Student,Grade) according to systemic grading rules.
- Grading tuples passing validation must be saved to the internal database.
- Instructors must be notified of invalid grading tuples and the cause.
- An interface to allow direct upload of a grading sheet via url parameters must be developed
...
Name | Data Type | Data Element | Processing |
|---|---|---|---|
Site Title | char(19-21) | Title of Course Site | N/A |
Course Site ID | char(99) | Sakai Site ID N/A | [term year][term_id][crn] |
Course Provider ID | char(14) | Unique Course ID | [term year][term_id][crn] OR [term year][term_id][crn] |
Student Name | char(???) | Student Name | N/A |
StudentID | char(32) | Kerberos Name | [kerberos_name] |
Grade | char(2) | Grade Code | [grade_code] |
...
In order to set up the cookie correctly, Sakai will need to forward some information along the url passed to the final grading tool. Specifically, Sakai will need to indicate the course that will be used. The page itself should be able to resolve the correct instructor information from the content of the auth_user cookie. Therefore, the required url parameter is:
course: 20060553443 (TERM_CODECRN)
The passed in url parameters will include both site id and provider id. The page will then inspect the url parameters in an attempt to resolve a usable course identifier. Once found, it will be used to create the necessary currentcourse cookie.
Interface Mockups
There are two ways we can approach the Final Grading interface for SmartSite Course Grading sheet uploads. We can either integrate the interface with the existing interface for download and upload of excel files, or we can build a separate interface. Providing one interface, while perhaps allowing some confusion, should present the most powerful set of features.
...