presnick/runestone — pull request #51 by nickdotreid (2014-03-09 17:00:44+00:00)
Title: Detached Grade & Code Table

This fork separates grades for a piece of code and the db.code row.

There is a new table (db.scores) which hold the acid, user id, score (grade), and comment.

Both the db.grades and db.scores now have a boolean field "released" which will all a student to see their grade.

The assignments table has also been changed, so that there is no longer a query field. There is now a table (db.problems) that joins an acid to an assignment row. Which means multiple types of values can be tied to an assignment. This is an important change because now multiple types of queryable values can be tied to an assignment and graded such as mchoice, or active codes in chapters.

My future plan for this is to be able to tag assignments as "reading responses", "chapters", or "problem sets" and have these tags weight a student's total grade accordingly.

Thoughts and comments would be nice!