CSC/E1869 GRADING AUDIT TRAIL

Introduction

Problem Statement

After an instructor gave a grade to an assignment, there is no way to track who gave the grade. A grading audit trail must be created and the following information needs to be stored:

1. When a grade is assigned by an instructor, there needs to be an indication of who did it and when it was done.

2. Comments previously provided by other instructors must also be preserved.

This information needs to be stored every time an instructor edits a grade / comment and clicks the save button.

Currently, there are two places need to add grading audit trail:

1. Review grade: Log in as instructor -> Manage -> Assignments -> View Review Report

2. Submission grade: Log in as instructor -> Manage -> Assignments -> View submissions

Proposed Solution

Design

We will use MVC design to create a model, a controller, and a view for both of Review Grade and Submission Grade.

Model: has a database contains instructor id, assignment id, grade type, student id, grade, comment, and timestamp.

Controller: saves a new entry into database every time a review grade or submission grade is saved

View: displays current submission or review's grading history. An existing example of this is submission record in the system.

Testing Plan

Functional testing: For “Review grade”: 1.Log in as instructor 2.Navigate to Manage -> Assignments 3.Click on Review Report A report with following details will show up: Timestamp, Instructor Id, Assignment id, Grade type, Student id, Grade, Comment 4.Every time an instructor edits or comments on the grade the report is updated with the new entry and timestamp.

For “Submission grade”: 1.Log in as instructor 2. Navigate to Manage -> Assignments 3.Click on View Submission -> History A report with following details whill show up: Timestamp, Instructor Id, Assignment id, Grade type, Student id, Grade, Comment 4Every time an instructor edits or comments on the grade the report is updated with the new entry and timestamp.