Status
- Work Begun: 06/19/2006
- Percent Complete: 85%
Requirements
- The Course Management Final Grading system must accept .csv files exported from Sakai with the following columns:
- 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.
File Format
The transitional .csv file will be required to have the following columns, in order:
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 |
Course Provider ID |
char(14) |
Unique Course ID |
[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] |
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.
- A mockup of the gradesheet download / upload page can be seen here: http://ips.ucdavis.edu/grading/mockup/fgs_gradesheet.cfm?All=A01-A05
- A mockup of the default import summary page can be seen here: http://ips.ucdavis.edu/grading/mockup/fgs_gradesheet_parse.cfm?All=A01-A05
Code Changes
The following pages will be changed:
- fgs_gradsheet_parse.cfm : Implement detection of Sakai format file and invocation of appropriate tag.
- tag_fgs_gradesheet_parse_sakai.cfm : New implementation of csv parsing for Sakai file format.