wiki:mark_deduction

Mark Deduction For Late Evaluation Submission

Refer to ticket #364

Requirements

An admin/instructor:

  • Should be able to set mark penalty scale for late evaluation submissions.

The students:

  • Should be notified about the mark penalties for late evaluation submissions.

DB Changes

  • Two new tables have been added : Penalty, and User_grade_penalty.
  • Run the attached SQL queries to update your current database.
    CREATE TABLE `penalties` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `event_id` int(11) DEFAULT NULL,
      `days_late` int(11) NOT NULL,
      `percent_penalty` int(11) NOT NULL,
      PRIMARY KEY (`id`),
      KEY `fk_events` (`event_id`)
    ) ENGINE=InnoDB  DEFAULT CHARSET=latin1;
    
    ALTER TABLE `penalties`
      ADD CONSTRAINT `fk_events` FOREIGN KEY (`event_id`) REFERENCES `events` (`id`) ON DELETE CASCADE;
    
    CREATE TABLE `user_grade_penalties` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `penalty_id` int(11) DEFAULT NULL,
      `grp_event_id` int(11) NOT NULL,
      `user_id` int(11) DEFAULT NULL,
      PRIMARY KEY (`id`),
      KEY `fk_penalties` (`penalty_id`),
      KEY `fk_users` (`user_id`)
    ) ENGINE=InnoDB  DEFAULT CHARSET=latin1;
    
    ALTER TABLE `user_grade_penalties`
      ADD CONSTRAINT `fk_penalties` FOREIGN KEY (`penalty_id`) REFERENCES `penalties` (`id`) ON DELETE CASCADE,
      ADD CONSTRAINT `fk_users` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
    

Implementation

  • An instructor or admin can choose to apply ONE late penalty scale to an event.
  • For now, the late penalty applies to all of the groups that are assigned to an evaluation event.
  • By default, the penalty scale will have increments of one day.
  • The penalty scale can still be modified after the initial setting.
Last modified 5 years ago Last modified on 2012-02-24T23:33:33-08:00