questions
Purpose: Holds most of the data used by an individual question. See options table for the rest of the data.
Joins: papers and options tables.
Field | Type | Purpose |
|---|---|---|
q_id | int(4) | Primary Key – auto increment. |
q_type | enum('blank', 'calculation', 'dichotomous', 'flash', 'hotspot', 'labelling', 'likert', 'matrix', 'mcq', 'mrq', 'rank', 'textbox', 'info', 'extmatch', 'random', 'sct', 'keyword_based', 'true_false', 'area') | What type the question is (flash is now deprecated) |
theme | text | Optional heading for the question |
scenario | text | Scenario or background information for the question |
leadin | text | The question itself |
correct_fback | text | General textual feedback to display if student gets question correct |
incorrect_fback | text | General textual feedback to display if student gets question wrong |
display_method | text |
|
notes | text | Notes displayed against question (these are visible to students) |
ownerID | int(11) | ID of the user who ownes (originally created) the question |
q_media | text | Filename of optional media to be attached to the current question (removed in 7.2) |
q_media_width | varchar(100) | Width of attached media (removed in 7.2) |
q_media_height | varchar(100) | Height of attached media (removed in 7.2) |
creation_date | datetime | Datetime when the current question was created |
last_edited | datetime | Datetime of the last time the question was edited |
bloom | enum('Knowledge', 'Comprehension', 'Application', 'Analysis', | Holds what level of cognitive engagement as per Bloom's Taxonomy the question pertains to |
scenario_plain | text | Same as scenario but with HTML tags removed (used for searching) |
leadin_plain | text | Same as leading but with HTML tags removed (used for searching) |
checkout_time | datetime | Datetime question was checked out for editing |
checkout_authorID | int(10) unsigned | User ID who has question checked out for editing |
deleted | datetime | Datetime when question was deleted. If NULL then the question is still active |
locked | datetime | Datetime when the question was locked bacause of a summative exam |
std | varchar(100) | Standard setting value saved with question for future use. |
status | tinyint(3) | Status of the question |
q_option_order | enum('display order', 'alphabetic', 'random') | What order to display the options |
score_method | enum('Mark per Question','Mark per Option','Allow partial Marks','Bonus Mark') | Depending on question type holds data about how to mark the question |
settings | text | 5.1: Used to hold JSON encode list of settings for a question. Currently used with the Calculation question. |
guid | char(40) | 5.1.2: Global unique identifier for a question. Used to help support question identification between Rogo and an external item bank. |