Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • page_name which is generated by wrapping the following text around the quiz name: "Take the " + qz_quiz.quizname + " Quiz"
  • file_name which is a varchar field that stores the numeric quiz id
  • user_account which stores the course instructor's kerberos name - NOT the name of the quiz owner or person who added the quiz (which could be the instructor or someone with proxy access to the course"
  • activity_date which is either the add and last edit date
  • is_quiz which is a single varchar field where 'q' indicates a quiz, 'a' indicates and answer key, and null exists for all other types of (non-quiz) records.

Additional fields designate to whom and when course information, in this case, quizzes, are released.

  • secure: if secure is 'Y', only enrolled students, instructor and proxies may view
  • hidden: if hidden is 'Y', quiz does not appear in course for anyone
  • release_flag: if release_flag is 'Y', this indicates a record in the selective_release table is set for this quiz. Selective releases are set by date, by person (e.g., to a particular student), by course (if using joined sections - specify particular sections for release), or by page (i.e., uses users stats to see if the person has viewed a particular page first.)

RELATIONSHIPS BETWEEN QUIZZES, CATEGORIES, SECTIONS AND THE QUESTION CATALOG

...