Flexible Rankings

[flungo]

I have a customer who is making quizzes as sort of mocks for written exams. The exam has a clear grading system of Fail, Pass, Merit and Distinction. The current ranking system has 5 fixed levels of ranking and it may be useful to some people to have flexibility with this being able to choose not only how many ranks but the boundaries for the ranks.

I am thinking that the input would be a 2 column table as such:

Score	Rank
80	80%-100% Rank Label
60	60%-80% Rank Label
40	40%-60% Rank Label
20	20%-40% Rank Label
0	0%-20% Rank Label

This would require an additional table in the database where there is a foreign key to the quiz that it relates, the score, and the label. The foreign key and score would be unique as a pair. A NULL FK could be used to store a default ranking (See #18) configurable from the settings.

When displayed, if no ranks have been added a table with the empty labels and the default (0,20,40,60,80) scores shown as rows. Rows should be able to be added or removed. When displayed, they should be sorted by score in descending order. If no row with score 0 is in the database this should always be displayed when editing as a prompt for them to add this as the base ranking. Rows without a label should not be saved.

If I were to implement this feature, would you be interested in merging?