Multi-worksheet grade report

Registered by Jeffrey Elkner on 2007-11-16

I want to create a view or report that stores final grades for a course section. It should compute a grade based on the following formula:

1. Take the final grades from 2 or more (3, 4, and 5 are all possibilities) sheets as input. The final grades are currently percentages, so apply the mapping:
        >= 90 --> 4
       89 - 80 --> 3
       79 - 70 --> 2
       69 - 60 --> 1
       <= 59 --> 0
2. Average these values, divide by the number of sheets and round up to the nearest integer (example: 5 sheets with 3, 4, 4, 4, and 2 would
     give (3 + 4 + 4 + 4 + 2)/5.0 which is 3.3999.. and would round to 3.
3. Display 'A' for 4, 'B' for 3, 'C' for 2, 'D' for 1 and 'E' for 0.
4. Allow user (teacher to override a computed grade on the report (example, change a 'B' to an 'A').

Blueprint information

Status:
Complete
Approver:
Tom Hoffman
Priority:
Undefined
Drafter:
Jeffrey Elkner
Direction:
Needs approval
Assignee:
Alan Elkner
Definition:
Approved
Series goal:
None
Implementation:
Implemented
Milestone target:
None
Started by
Tom Hoffman on 2010-03-16
Completed by
Tom Hoffman on 2010-03-16

Related branches

Sprints

Whiteboard

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.