...
| Field | Type | Purpose |
|---|---|---|
| property_id | mediumint(8) unsigned | Primary Key – auto increment. |
| paper_title | varchar(255) | Name of the assessment or survey. |
| start_date | datetime | Datetime when students can start to access the paper. There is a 2 minute grace on this to account for client-server clocks being different. |
| end_date | datetime | Datetime when students will loose access to the paper. Data recorded after the end date will go into log_late. |
| timezone | varchar(255) | What timezone should be used. |
| paper_type | enum('0','1','2','3','4','5','6') | 0=Formative, 1=Progress Test, 2=Summative, 3=Survey, 4=OSCE Station, 5=Offline paper, 6=peer review |
| paper_prologue | text | Text to display at the top of screen 1. |
| paper_postscript | text | Text to display after the student clicks 'Finish' |
| bgcolor | varchar(20) | Background colour of the paper. |
| fgcolor | varchar(20) | Foreground colour of the paper. |
| themecolor | varchar(20) | Colour of themes (headings). |
| labelcolor | varchar(20) | Colour of labels. |
| fullscreen | enum('0','1') | 0=Windowed, 1=Fullscreen. Fullscreen works only in Internet Explorer. |
| marking | char(60) | Marking scheme used for the paper. |
| bidirectional | enum('0','1') | 0=Linear navigation, 1=Bidirectional - students may return to previous screens. |
| pass_mark | tinyint(4) | Percentage pass mark for the paper. |
| distinction_mark | tinyint(4) | Percentage distinction mark for the paper. |
| paper_ownerID | int(10) unsigned | User ID of the paper owner. |
| folder | varchar(255) | Personal folder the paper is stored in (optional). |
| labs | text | Comma separated list of lab IDs that a summative paper is restricted to. |
| rubric | text | The exam rubric displayed to students before they start the exam. |
| calculator | tinyint(4) | 0=No calculator, 1=Display JavaScript calculator |
| exam_duration | smallint(6) | Exam duration specified in minutes. |
| deleted | datetime | Datetime the paper was deleted. NULL means the paper is still active. |
| created | datetime | Datetime the paper was created. |
| random_mark | float | The calculated random mark that someone would get based on probability. |
| total_mark | mediumint(9) | Total available marks. |
| display_correct_answer | enum('0','1') | 0=Hide correct answers, 1=Display correct answers. |
| display_question_mark | enum('0','1') | 0=Hide question marks, 1=Show question marks. |
| display_students_response | enum('0','1') | 0=Hide student responses, 1=Show student responses. |
| display_feedback | enum('0','1') | 0=Hide feedback, 1=Show feedback. |
| hide_if_unanswered | enum('0','1') | 1=If student leaves a question unanswered then receive no feedback. |
| calendar_year | enum('2002/03','2003/04','2004/05','2005/06', '2006/07','2007/08','2008/09','2009/10','2010/11','2011/12', '2012/13','2013/14','2014/15','2015/16','2016/17', '2017/18','2018/19','2019/20') | Academic year the paper applies to. Important for mapping to learning objectives. |
| external_review_deadline | date | Deadline when external reviews should be completed by. |
| internal_review_deadline | date | Deadline when internal reviews should be completed by. |
| sound_demo | enum('0','1') | 0=No sound demo, 1=Include sound demo. |
| latex_needed | tinyint(4) | 1=Include Latex rendering libraries because a question with Latex has been detected. |
| password | char(20) | Password protect a summative exam. |
| retired | datetime | Datetime when a paper is retired. |
| crypt_name | varchar(32) | An encrypted ID for the paper. |
| recache_marks | tinyint(3) | If set to 1 then /paper/details.php will call Class Totals and recache values. Necessary if the marking method changes, for example. |
| Warning |
|---|
The Information below is for an in development branch of Rogo |
Purpose: Stores general setup information for a paper.
Version: 6.1
Joins: academic_year, papers, modules, labs and users table.
Field | Type | Purpose | Key |
|---|---|---|---|
| property_id | mediumint(8) unsigned | auto increment. | PRIMARY KEY |
| paper_title | varchar(255) | Name of the assessment or survey. | |
| start_date | datetime | Datetime when students can start to access the paper. There is a 2 minute grace on this to account for client-server clocks being different. | |
| end_date | datetime | Datetime when students will loose access to the paper. Data recorded after the end date will go into log_late. | |
| timezone | varchar(255) | What timezone should be used. | |
| paper_type | enum('0','1','2','3','4','5','6') | 0=Formative, 1=Progress Test, 2=Summative, 3=Survey, 4=OSCE Station, 5=Offline paper, 6=peer review | |
| paper_prologue | text | Text to display at the top of screen 1. | |
| paper_postscript | text | Text to display after the student clicks 'Finish' | |
| bgcolor | varchar(20) | Background colour of the paper. | |
| fgcolor | varchar(20) | Foreground colour of the paper. | |
| themecolor | varchar(20) | Colour of themes (headings). | |
| labelcolor | varchar(20) | Colour of labels. | |
| fullscreen | enum('0','1') | 0=Windowed, 1=Fullscreen. Fullscreen works only in Internet Explorer. | |
| marking | char(60) | Marking scheme used for the paper. | |
| bidirectional | enum('0','1') | 0=Linear navigation, 1=Bidirectional - students may return to previous screens. | |
| pass_mark | tinyint(4) | Percentage pass mark for the paper. | |
| distinction_mark | tinyint(4) | Percentage distinction mark for the paper. | |
| paper_ownerID | int(10) unsigned | User ID of the paper owner. | |
| folder | varchar(255) | Personal folder the paper is stored in (optional). | |
| labs | text | Comma separated list of lab IDs that a summative paper is restricted to. | |
| rubric | text | The exam rubric displayed to students before they start the exam. | |
| calculator | tinyint(4) | 0=No calculator, 1=Display JavaScript calculator | |
| exam_duration | smallint(6) | Exam duration specified in minutes. | |
| deleted | datetime | Datetime the paper was deleted. NULL means the paper is still active. | |
| created | datetime | Datetime the paper was created. | |
| random_mark | float | The calculated random mark that someone would get based on probability. | |
| total_mark | mediumint(9) | Total available marks. | |
| display_correct_answer | enum('0','1') | 0=Hide correct answers, 1=Display correct answers. | |
| display_question_mark | enum('0','1') | 0=Hide question marks, 1=Show question marks. | |
| display_students_response | enum('0','1') | 0=Hide student responses, 1=Show student responses. | |
| display_feedback | enum('0','1') | 0=Hide feedback, 1=Show feedback. | |
| hide_if_unanswered | enum('0','1') | 1=If student leaves a question unanswered then receive no feedback. | |
| calendar_year | int(4) | Academic year the metadata applies to. | FOREIGN KEY academic_year.calendar_year |
| external_review_deadline | date | Deadline when external reviews should be completed by. | |
| internal_review_deadline | date | Deadline when internal reviews should be completed by. | |
| sound_demo | enum('0','1') | 0=No sound demo, 1=Include sound demo. | |
| latex_needed | tinyint(4) | 1=Include Latex rendering libraries because a question with Latex has been detected. | |
| password | char(20) | Password protect a summative exam. | |
| retired | datetime | Datetime when a paper is retired. | |
| crypt_name | varchar(32) | An encrypted ID for the paper. | |
| recache_marks | tinyint(3) | If set to 1 then /paper/details.php will call Class Totals and recache values. Necessary if the marking method changes, for example. |