Gap Listing | Tradeoffs | Gradebook & Roster | Melete/Content Module

New or Enhanced Features of the 2.5 Gradebook

• Better integration with assignments
  • Must create gradebook column first, then link assignment to that column
  • No corresponding improvement with quiz integration
• Weighted categories
• Three grading styles to choose from
• Improved import/export
  • import now overwrites same-named columns rather than rejecting them
  • this can NOT be used to assign a grade for an unsubmitted test or assignment
  • this can NOT be used to upload grades in unsupported formats
  • this can NOT be used to upload re-calculated course grades
• Individual student grade reports for intructors

Still missing...

• Calculated columns other than final grade
• Calculated columns that allow user formulas. None of the following is possible
  • drop lowest of several columns
  • take highest of several columns
  • pass/fail for a graded event
• Mixed column types
• other column types: alphanumeric, text, selection

Untested bug fixes

• Spring Davidson was losing grades - not sure if this is fixed

Phil Conrad's Minimum Requirements (fixed, not fixed)

What I need: Minimum requirements for a Course Mgt System Spreadsheet

1. Instructors and TAs have full edit access to all columns (except userid).
2. Columns can be numeric, alphanumeric, calculated, or letter grade.
3. Instructor/TA can toggle student read access to each columns on/off
4. Instructor/TA can rearrange columns in the spreadsheet, add new columns, and rename columns, and sort entire spreadsheet ascending or descending by any column.
   1. rearrange
   2. rename auto-created
   3. rename gradebook-created
   4. sort
5. Instructor/TA can edit values in an entire column by clicking on an "edit" button at the top of the column. Numeric columns have an optional "total points" value that can be entered for the column.
   1. not sure what Phil means by this, but max points for a numeric column are mandatory and must be at least .01
6. Instructor/TA can edit values for an entire row by clicking an edit button for that row.
7. Calculated columns are based on formulas that can include +, -, *, /, parentheses, and functions min(col1, col2, ... ), max(col1, col2, ...), sum(col1, col2, ... )
8. Instructor/TA can download entire contents of spreadsheet into a CSV (comma separated value file) suitable for importing into, for example, Excel *Final grade will not download until you have released it.
9. Instructor/TA can import entire contents of a CSV file, provided that
   1. the CSV file has Student Id in column 1
   2. the first row is the titles of the fields
   3. existing columns are replaced with new values---old - only some replacements are accepted
   4. re-arrangement of columns is not preserved