Assignments questionnaires: Difference between revisions
Jump to navigation
Jump to search
| Line 18: | Line 18: | ||
|- | |- | ||
!notification_limit | !notification_limit | ||
|int | |||
|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. | |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 | !questionnaire_weight | ||
|int | |||
|Gives the percentage of the contributor's overall score that is based on this questionnaire. | |Gives the percentage of the contributor's overall score that is based on this questionnaire. | ||
|- | |- | ||
!used_in_round | !used_in_round | ||
|int | |||
|Tells which round (1, 2, ...) of review this questionnaire is used in. If null, I suspect that the questionnaire is used in all rounds. | |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 | !dropdown | ||
|tinyint(1) | |||
|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. | |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 | !topic_id | ||
|int | |||
|If this field is non-null, then this rubric is used only to review this particular topic. | |If this field is non-null, then this rubric is used only to review this particular topic. | ||
|- | |- | ||
!duty_id | !duty_id | ||
|int | |||
|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). | |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). | ||
|- | |- | ||
Latest revision as of 01:01, 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 | int | 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 | int | Gives the percentage of the contributor's overall score that is based on this questionnaire. |
| used_in_round | int | 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 | tinyint(1) | 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 | int | If this field is non-null, then this rubric is used only to review this particular topic. |
| duty_id | int | 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.