Assignments questionnaires: Difference between revisions

From Expertiza_Wiki
Jump to navigation Jump to search
Line 11: Line 11:
!questionnaire_id   
!questionnaire_id   
|int(11)   
|int(11)   
|This references the questionnaire id in the questionnaire
|This references a questionnaire that is used in t he assignment
|-  
|-  
!assignment_id   
!assignment_id   
|int(11)   
|int(11)   
|This references the assignment_id in the assignment
|This references the assignment in which the questionnaire is used
|}  
|-
!notification_limit
|If a new review has a score that is more than this # of percentage points away from the current average review score for this artifact, then the instructor will be emailed.
|-
!questionnaire_weight
|Gives the percentage of the contributor's overall score that is based on this questionnaire.
|-
!used_in_round
|Tells which round (1, 2, ...) of review this questionnaire is used in.  If null, I suspect that the questionnaire is used in all rounds.
|-
!dropdown
|I believe that if this is true, instead of using a rubric to evaluate this kind of work (e.g., review of work, teammate review), a simple dropdown with integers from 1 to MAX_SCORE is used instead.
|-
!topic_id
|If this field is non-null, then this rubric is used only to review this particular topic.
|-
!duty_id
|If this is non-null, then this rubric is used only to review a team member who takes on a particular role (such as scrum master, tester, or documentor).
|-
|}


== E/R diagram for Parents Tables ==
== E/R diagram for Parents Tables ==

Revision as of 00:59, 24 November 2024

Deprecated

Assignments Questionnaire Variable Documentation

Field Name Type Description
id int(11) The unique record id
questionnaire_id int(11) This references a questionnaire that is used in t he assignment
assignment_id int(11) This references the assignment in which the questionnaire is used
notification_limit If a new review has a score that is more than this # of percentage points away from the current average review score for this artifact, then the instructor will be emailed.
questionnaire_weight Gives the percentage of the contributor's overall score that is based on this questionnaire.
used_in_round Tells which round (1, 2, ...) of review this questionnaire is used in. If null, I suspect that the questionnaire is used in all rounds.
dropdown I believe that if this is true, instead of using a rubric to evaluate this kind of work (e.g., review of work, teammate review), a simple dropdown with integers from 1 to MAX_SCORE is used instead.
topic_id If this field is non-null, then this rubric is used only to review this particular topic.
duty_id If this is non-null, then this rubric is used only to review a team member who takes on a particular role (such as scrum master, tester, or documentor).

E/R diagram for Parents Tables

Tables referred by the Assignment Badges Table as Foreign Key Relationship.

E/R diagram for Child Tables

No Tables refer the Assignment Badges Table as Foreign Key Relationship.



Back to Database Tables Main page.