RELATIONSHIPS BETWEEN QUIZZES, CATEGORIES, SECTIONS AND THE QUESTION CATALOG
(Note: Graphic data valid on 1/13/06)
A top down review of the existing tables and data shows the following hierarchical structure for quizzes in the MyUCDavis cms. The hierarchy of Quiz Builder revolves around quizzes, quiz sections, questions, answers, and finally student response data associated with quiz attempts. In addition, the original design suggests a grouping mechanism for quizzes in a categories table, but these tables are so little used as to be negligible.
DATA ANALYSIS OF TABLE USAGE - QZ_QUIZ & QZ_SECTIONS
The key table here is qz_quiz which contains the primary key identifying the quiz (quizID), the quiz name, the kerberos_name of the owner, and quiz type information.
The two category tables on the left side of the graphic allow the user to create a category and then to associate quizzes with that category. This feature is virtually unused (the majority of the records were created by IET personnel as test data.) These records do not need to be ported to sakai.
The quiz sections relationship is the key to associating questions with a quiz. The process flow is that the user first creates a quiz (record) and in the next step makes additional decisions which populate a section record. There is a minimum of a one-to-one relationship when a quiz is created, i.e., for every quiz created (quizzes w/o this association are not complete thus irrelevent) there is at least one section automatically associated with it. (As of 1/30/06, there are 72 'orphan' quizzes.)
Some quizzes have more than the one auto-generated section. The default name for auto-generated sections is 'Section 1' with the number increasing with each section. The same section relationship exists in Samigo with 'Default' as the auto-generated name, which will not be displayed unless it is changed.
# of Sections |
# of Quizzes |
|
# of Sections |
# of Quizzes |
|---|---|---|---|---|
1 |
916 |
|
6 |
14 |
2 |
186 |
|
7 |
12 |
3 |
59 |
|
8 |
5 |
4 |
27 |
|
10 |
2 |
5 |
21 |
|
11 |
1 |
No quizzes with 9 sections
DATA ANALYSIS OF TABLE USAGE - QZ_SECTION_QUESTIONS & QZ_QUES_CATALOG
The qz_ques_catalog table is contains all questions. Each unique questionid has a question type and owner. All relationships to answers and feedback are associated with the primary key, quesionid.
The association of quizzes with questions occurs in qz_section_questions. The unique secid (from qz_section) is matched with a question key (qcid) - the two foreign keys are the primary key with additional information for the order/sequence of appearance.