Course Management Final Grade Import

Requirements

1. The Course Management Final Grading system must accept .csv files exported from Sakai with the following columns:
   1. Site Title: Unparsed label field.
   2. Provider ID: Parsed unique course identifier of the form (term_year-term_id-crn).
   3. Student Name: Unparsed label field.
   4. Student ID: Parsed unique student identifier (kerberos_name).
   5. Course Grade: Parsed two-letter grading code (valid Banner gradecode).
2. Accepted files must be parsed to resolve valid grading tuples (Course,Student,Grade) according to systemic grading rules.
3. Grading tuples passing validation must be saved to the internal database.
4. Instructors must be notified of invalid grading tuples and the cause.