Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Work Begun: 06/19/2006
  • Percent Complete: 100%85%

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.

...

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]

...