Problem Statement
In Expertiza, peer reviews are used as a metric to evaluate someone’s project. Once someone has peer reviewed a project, the authors of the project can also provide a feedback for this review in terms of ‘Author feedback’. While grading peer reviews, it would be nice for the instructors to take into account the author feedbacks given on a particular peer review, this will be helpful in evaluating how helpful the peer review actually was to the author of the project. The aim of this project is to build this into the system. We need an additional column in the summary page for reviews which shows the calculation of the author feedback. This will help instructor's to know how the reviews proved useful to the authors/team. The aim of this project is to integrate the author feedback column in the summary page
Design
The following are the table structures we will need for mapping. First, the questions table has all the questions based on the questionnaire.
Questions Table Structure
| Field Name |
Type |
Description
|
| id
|
int(11)
|
unique identifier for the record
|
| txt
|
text
|
the question string
|
| weight
|
int(11)
|
specifies the weighting of the question
|
| questionnaire_id
|
int(11)
|
the id of the questionnaire that this question belongs to
|
| seq
|
DECIMAL
|
|
| type
|
VARCHAR(255)
|
Type of question
|
| size
|
VARCHAR(255)
|
Size of the question
|
| alternatives
|
VARCHAR(255)
|
Other question which means the same
|
| break_before
|
BIT
|
|
| max_label
|
VARCHAR(255)
|
|
| min_label
|
VARCHAR(255)
|
|
Answer Table Structure
| Field Name |
Type |
Description
|
| id
|
int(11)
|
Unique ID for each Answers record.
|
| question_id
|
int(11)
|
ID of Question.
|
| answer
|
int(11)
|
Value of each of the answer.
|
| comments
|
text
|
Comment given to the answer.
|
| reponse_id
|
int(11)
|
ID of the response associated with this Answer.
|
Response Table Structure
| Field Name |
Type |
Description
|
| id
|
int(11)
|
The unique record id
|
| map_id
|
int(11)
|
The ID of the response map defining the relationship that this response applies to
|
| additional_comment
|
text
|
An additional comment provided by the reviewer to support his/her response
|
| updated_at
|
datetime
|
The timestamp indicating when this response was last modified
|
| created_at
|
datetime
|
The timestamp indicating when this response was created
|
| version_num
|
int(11)
|
The version of the review.
|
| round
|
int(11)
|
The round the review is connected to.
|
| is_submitted
|
tinyint(1)
|
Boolean Field to indicate whether the review is submitted.
|
Response Map Table
| Field Name |
Type |
Description
|
| id
|
int(11)
|
The unique record id
|
| reviewed_object_id
|
int(11)
|
The object being reviewed in the response. Possible objects include other ResponseMaps or assignments
|
| reviewer_id
|
int(11)
|
The participant (actually AssignmentParticipant) providing the response
|
| reviewee_id
|
int(11)
|
The team (AssignmentTeam) receiving the response
|
| type
|
varchar(255)
|
Used for subclassing the response map. Available subclasses are ReviewResponseMap, MetareviewResponseMap, FeedbackResponseMap, TeammateReviewResponseMap
|
| created_at
|
DATETIME
|
Date and Time for when the record was created
|
| updated_at
|
DATETIME
|
Date and Time when the last update was made
|
| calibrate_to
|
BIT
|
Test Plan
References
1) http://wiki.expertiza.ncsu.edu/index.php/Documentation_on_Database_Tables