Changes

Jump to navigation Jump to search
4,065 bytes removed ,  17:50, 10 April 2009
Replacing page with '{{TOCright}} ==/Question Support API== ==Flash Card Game - Assimilate=='
Line 1: Line 1:  
{{TOCright}}
 
{{TOCright}}
==Question Support API==
+
==[[/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.)
  −
[[Image:QuestionERDiagram.PNG|right]]
  −
Authorship and history attributes for Questions could be provided through a new Person ID field in Questionnaire and recursive links.
  −
: The Moodle [http://docs.moodle.org/en/Development:Question_database_structure Question database structure].
  −
====Table Dictionary====
  −
{{Definition_table
  −
|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====
  −
{{Definition_table
  −
|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====
  −
{{Definition_table
  −
|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====
  −
{{Definition_table
  −
|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====
  −
{{Definition_table
  −
|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====
  −
{{Definition_table
  −
|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====
  −
{{Definition_table
  −
|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====
  −
{{Definition_table
  −
|ID | primary key
  −
|School | School or organizational name
  −
}}
  −
====Person====
  −
{{Definition_table
  −
|ID | primary key
  −
|Last Name | Family name for Person
  −
|First Name | Primary name for Person
  −
}}
  −
 
   
==[[Flash Card Game - Assimilate]]==
 
==[[Flash Card Game - Assimilate]]==

Navigation menu