Assignments: Difference between revisions

From Expertiza_Wiki
Jump to navigation Jump to search
(Created page with "The Assignments table contains one record for each assignment created by an instructor or administrator. ==Assignment Variable Documentation== {| class="wik...")
 
 
(16 intermediate revisions by 2 users not shown)
Line 32: Line 32:
!course_id   
!course_id   
|int(11)   
|int(11)   
|ID in the [http://wikis.lib.ncsu.edu/index.php/Courses_table Courses] table of the course with which this assignment is associated
|ID in the [http://wiki.expertiza.ncsu.edu/index.php/Courses_table Courses] table of the course with which this assignment is associated
|-  
|-  
!instructor_id   
!instructor_id   
Line 54: Line 54:
|number of reviewers who have reviewed the assignment.
|number of reviewers who have reviewed the assignment.
|-  
|-  
!review_strategy_id    
!reviews_visible_to_all    
|tinyint(1) 
|if false, other reviewers can't see this reviewer's review.
|-
!num_reviewers 
|int(10) 
|Number of reviewers.
|-
!spec_location 
|text 
|url of the assignment.
|-
!max_team_size
|int(11) 
|Maximum number of participants allowed on the team.
|-
!staggerred_deadline
|tinyint(1) 
|Indicating whether deadlines are staggered or not *************
|-
!allow_suggestions
|tinyint(1) 
|Indicating whether participants in an assignment with topics may suggest additional topics for the instructor to approve.
|-
!days_between_submissions
|int(11)   
|int(11)   
|the review strategy, e.g., "rubric", "ranking"
|Number of Days available between submissions *************
|-
!review_assignment_strategy
|varchar(12) 
|
|-  
|-  
!mapping_strategy_id 
!review_topic_threshold
|int(11)   
|int(11)   
|the review-mapping strategy, e.g., "static", "dynamic"
|***********************************
|-
!copy_flag
|tinyint(1) 
|Whether the assignment has a copy or not. *************
|-  
|-  
!review_questionnaire_id 
!rounds_of_reviews
|int(11)   
|int(11)   
|This references the questionnaire table which and the id of the questionnaire in that table. It is a foreign key.
|Total number of rounds of reviews done for the assignment *************
|-
!microtask
|tinyint(1) 
|Indicating whether this is a microtask assignment, i.e., if it has topics that are worth varying amounts of credit, and may be selected by students.
|-
!require_quiz
|tinyint(1) 
|Indicating whether the assignment requires a quiz or not. *************
|-  
|-  
!review_of_review_questionnaire_id 
!num_quiz_questions
|int(11)   
|int(11)   
|This references the questionnaire table and the questionnaire id.
|Total number of questions present for the quiz. *************
|-  
|-  
!teammate_review_questionnaire_id 
!is_coding_assignment
|int(10)   
|tinyint(1)   
|This references the questionnaire table and the questionnaire id.
|Indicating whether whether the given assignment is a coding assignment or not *************
|-  
|-  
!review_weight 
!is_intelligent
|float  
|tinyint(1)  
|the percentage that reviews count for; the balance of grade depends on reviews of reviews
|Indicates whether topics are to be bid on, and then the "intelligent assignment" algorithm will assign teams to topics *************
|-  
|-  
!reviews_visible_to_all 
!calculate_penalty
|tinyint(1)   
|tinyint(1)   
|if false, other reviewers can't see this reviewer's review
|Indicating whether penalty needs to be calculated for the given assignment. *************
|-
!late_policy_id
|int(11) 
|ID in the ******late policy table***** *************. Indicating which late policy is applied here.
|-  
|-  
!team_assignment 
!is_penalty_calculated
|tinyint(1)   
|tinyint(1)   
|It's a flag to indicate whether it is a team assignment or individual assignment
|Indicating whether the penalty for the assignment is calculated or not. *************
|-  
|-  
!wiki_type_id 
!max_bids
|int(11)   
|int(11)   
|id of wiki assignment type
|Total amount of bids given for this assignment. *************
|-
!show_teammate_reviews
|tinyint(1) 
|Indicating whether teammate reviews are shown or not. *************
|-
!availability_flag
|tinyint(1) 
|Indicating whether the given assignment is available or not. *************
|-
!use_bookmark
|tinyint(1) 
|Indicating whether bookmarks are used or not. *************
|-
!can_review_same_topic
|tinyint(1) 
|Indicating whether a reviewer can review the same topic again. *************
|-
!can_choose_topic_to_review
|tinyint(1) 
|Indicating whether a reviewer can choose a topic to review *************
|-
!is_calibrated
|tinyint(1) 
|Indicating whether the assignment is calibrated or not. *************
|-
!is_selfreview_enabled
|tinyint(1) 
|Indicating whether an author can review his/her work. *************
|-
!reputation_algorithm
|varchar(12) 
|This field gives us the information of the reputation algorithm used for this assignment. *************
|-  
|-  
!require_signup 
!is_anonymous
|tinyint(1)   
|tinyint(1)   
|if true, users need to sign up through Shimmer before submitting; if false, everyone in course may submit; if assignment not in course, default is that no one may submit.
|Indicating whether whether the reviewer information is anonymous or not. *************
|-
!num_reviews_required 
|int(11) 
|Total number of reviews required for this assignment. *************
|-
!num_metareviews_required 
|int(11) 
|Total number of metareviews required for this assignment. *************
|-  
|-  
!num_reviewers 
!num_metareviews_allowed 
|int(10)   
|int(11)   
|Number of reviewers.
|Total number of metareviews allowed for this assignment. *************
|-  
|-  
!spec_location 
!num_reviews_allowed 
|text  
|int(11)  
|url of the assignment
|Total number of reviews allowed for this assignment. *************
|-  
|-  
!author_feedback_questionnaire_id 
!simicheck 
|int(11)   
|int(11)   
|This references the questionnaire table and the questionnaire id.
|Similarity Check between assignments. *************
|-  
|-  
!max_team_size
!simicheck_threshold
|int(11)   
|int(11)   
|Number of people in the team.
|Similarity check threshold value for the given assignment. *************
|}  
|}
 
== E/R diagram for Parents Tables ==
Tables referred by the Assignment Table as Foreign Key Relationship.
 
[[File:assignment_imported.png]]
 
== E/R diagram for Child Tables ==
Tables which refer the Assignment Table as Foreign Key Relationship.
 
[[File:assignment_exported.png]]


<!--
{| class="wikitable"
|-
! Field Name
! Type
! Description
|-
! id
| int(11)
| This object's unique ID value. One per object.
|-
! created_at
| datetime
| The date/time stamp when this record was created
|-
! updated_at
| datetime
| The date/time stamp when this record was last modified
|-
! name
| varchar(255)
| The name given to this assignment by the instructor/administrator who created it
|-
! directory_path
| varchar(255)
| If this is an assignment to which files are being submitted, this is the first part of the directory path for the submissions.  If this is a wiki assignment, it is the base URL for wiki pages submitted by the creators
|-
! submitter_count
| int(10)
| Number of creators who have submitted so far to this assignment
|-
! course_id
| int(11)
| ID in the [http://wikis.lib.ncsu.edu/index.php/Courses_table Courses] table of the course with which this assignment is associated
|}
-->


Back to the [[Documentation_on_Database_Tables|database documentation]]
Back to the [[Documentation_on_Database_Tables|database documentation]]

Latest revision as of 14:17, 1 April 2021

The Assignments table contains one record for each assignment created by an instructor or administrator.

Assignment Variable Documentation

Field Name Type Description
id int(11) This object's unique ID value. One per object.
created_at datetime The date/time stamp when this record was created
updated_at datetime The date/time stamp when this record was last modified
name varchar(255) The name given to this assignment by the instructor/administrator who created it
directory_path varchar(255) If this is an assignment to which files are being submitted, this is the first part of the directory path for the submissions. If this is a wiki assignment, it is the base URL for wiki pages submitted by the creators
submitter_count int(10) Number of creators who have submitted so far to this assignment
course_id int(11) ID in the Courses table of the course with which this assignment is associated
instructor_id int(11) ID of a instructor who created the assignment
private tinyint(1) whether assignment is visible to other instructors
num_reviews int(11) number of reviews done by a student for this assignment
num_review_of_reviews int(10) number of reviews of reviews done by a student for this assignment
num_review_of_reviewers int(11) number of reviewers who have reviewed the assignment.
reviews_visible_to_all tinyint(1) if false, other reviewers can't see this reviewer's review.
num_reviewers int(10) Number of reviewers.
spec_location text url of the assignment.
max_team_size int(11) Maximum number of participants allowed on the team.
staggerred_deadline tinyint(1) Indicating whether deadlines are staggered or not *************
allow_suggestions tinyint(1) Indicating whether participants in an assignment with topics may suggest additional topics for the instructor to approve.
days_between_submissions int(11) Number of Days available between submissions *************
review_assignment_strategy varchar(12)
review_topic_threshold int(11) ***********************************
copy_flag tinyint(1) Whether the assignment has a copy or not. *************
rounds_of_reviews int(11) Total number of rounds of reviews done for the assignment *************
microtask tinyint(1) Indicating whether this is a microtask assignment, i.e., if it has topics that are worth varying amounts of credit, and may be selected by students.
require_quiz tinyint(1) Indicating whether the assignment requires a quiz or not. *************
num_quiz_questions int(11) Total number of questions present for the quiz. *************
is_coding_assignment tinyint(1) Indicating whether whether the given assignment is a coding assignment or not *************
is_intelligent tinyint(1) Indicates whether topics are to be bid on, and then the "intelligent assignment" algorithm will assign teams to topics *************
calculate_penalty tinyint(1) Indicating whether penalty needs to be calculated for the given assignment. *************
late_policy_id int(11) ID in the ******late policy table***** *************. Indicating which late policy is applied here.
is_penalty_calculated tinyint(1) Indicating whether the penalty for the assignment is calculated or not. *************
max_bids int(11) Total amount of bids given for this assignment. *************
show_teammate_reviews tinyint(1) Indicating whether teammate reviews are shown or not. *************
availability_flag tinyint(1) Indicating whether the given assignment is available or not. *************
use_bookmark tinyint(1) Indicating whether bookmarks are used or not. *************
can_review_same_topic tinyint(1) Indicating whether a reviewer can review the same topic again. *************
can_choose_topic_to_review tinyint(1) Indicating whether a reviewer can choose a topic to review *************
is_calibrated tinyint(1) Indicating whether the assignment is calibrated or not. *************
is_selfreview_enabled tinyint(1) Indicating whether an author can review his/her work. *************
reputation_algorithm varchar(12) This field gives us the information of the reputation algorithm used for this assignment. *************
is_anonymous tinyint(1) Indicating whether whether the reviewer information is anonymous or not. *************
num_reviews_required int(11) Total number of reviews required for this assignment. *************
num_metareviews_required int(11) Total number of metareviews required for this assignment. *************
num_metareviews_allowed int(11) Total number of metareviews allowed for this assignment. *************
num_reviews_allowed int(11) Total number of reviews allowed for this assignment. *************
simicheck int(11) Similarity Check between assignments. *************
simicheck_threshold int(11) Similarity check threshold value for the given assignment. *************

E/R diagram for Parents Tables

Tables referred by the Assignment Table as Foreign Key Relationship.

E/R diagram for Child Tables

Tables which refer the Assignment Table as Foreign Key Relationship.


Back to the database documentation

Retrieved from "https://wiki.expertiza.ncsu.edu/index.php?title=Assignments&oldid=138589"