Math4Team/RIT/Projects
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Question Support API
http://git.sugarlabs.org/projects/question-support-api
Data Model
A potential data model: (It was built for a corporate medical department's medical records. I've already renamed Clinic and Provider to School and Teacher.)
Authorship and history attributes for Questions could be provided through a new Person ID field in Questionnaire and recursive links.
- The Moodle Question database structure.
Table Dictionary
Questionnaire | A collection of questions that might be used in a Survey, Quiz, Exam, etc. | |
Question | A problem seeking an answer | |
Answer | A potential solution to the problem | |
AnswerType | The class of answer suitable for the problem or question | |
Survey | An event instance of collecting Answers to Questions or problems | |
Response | An event instance of the Student providing an answer to a question on a Survey or Quiz, etc | |
School | An organization | |
Person | An individual, such as a Teacher, Student, etc. |
Questionnaire
ID | primary key | |
Title | Short name for questionnaire | |
Category | Classifier ID, the ID of a Questionnaire class or category of Questionnaire | |
Notes | Description, Image link, rich format data | |
StartDate | Effective date for this instance of the Questionnaire | |
EndDate | Expiry date of this instance |
Question
ID | primary key | |
Questionnaire | ID of parent questionnaire | |
Sequence | number to order question among questions on questionnaire | |
Question | text problem statement | |
AnswerType | ID of the suitable answer type | |
Jump | conditional number to redirect survey question sequence | |
Notes | Description, images, rich format data | |
StartDate | Effective date of this question instance | |
EndDate | Expiry date of this instance |
Answer
ID | primary key | |
Question_ID | ID of parent question | |
Sequence | number to order answer among answer choices for question | |
Answer | text of solution or answer | |
Notes | Description, images, rich format data | |
StartDate | Effective date of this answer instance | |
EndDate | Expiry date of this instance |
AnswerType
ID | primary key | |
AnswerType | text for the class of answer. Example, text, numeric, multiple choice, tabular, yes/no, etc. | |
Category | ID for class of answer type |
Survey
ID | primary key | |
BaseID | ID of parent Survey. Used to identify families of Surveys, such as version | |
School | ID of the School or organization sponsoring this Survey instance | |
Teacher | ID of Person extending this instance of the survey or quiz | |
Student | ID of the Person taking this instance of the survey or quiz | |
Notes | Description, images, rich format data for this instance of the survey or quiz | |
DateTime | DateTime that this Survey instance was taken | |
ReviewDate | Date that this Survey instance was reviewed by the Teacher | |
ChangeDate | Date that this instance of the Survey was changed (reasons are provided in the Response record). |
Response
ID | primary key | |
Answer_ID | ID of selected answer (when one of a choice) | |
Question_ID | ID of the Question instance for this Response instance | |
Survey_ID | ID of the parent Survey or Quiz instance for this Response | |
Response | text of Response | |
ResponseValue | numerical Response | |
Notes | Description, images, rich format data for this Response | |
ChangeDate | DateTime that this instance of the Survey was changed, i.e., initial response, update by Student, override by Teacher, etc. | |
ChangePerson | ID of Person who changed this Response instance, i.e., Student, Teacher | |
ChangeReason | text reason this Response instance was changed, i.e., initial response, update by Student, override reason |
School
ID | primary key | |
School | School or organizational name |
Person
ID | primary key | |
Last Name | Family name for Person | |
First Name | Primary name for Person |