Design for quizzes/evaluations in NPAC student db

Goals:

  1. To extend the current survey questions part of the student database to include on-line quizzes and evaluation forms. It makes sense to design these all together as all depend on a design for questions. The differences will be in whether they are graded and what kind of statistics and reports are generated.

  2. It is also our goal that the design be compatible with other well-known systems. This document discusses the design of WebCT, and other designs relating to students, quizzes and course materials will be examined, such as IMS and PAPI.

WebCT on-line quizzes and surveys

We report here on what we surmise to be the information kept for quizzes and questions, and for courses and students as it relates to the quizzes. This is reverse engineering as we have no design document; we examine the functionality of webct and surmise what information must be kept. (Of course, we have files created by the CGI scripts with : separated fields, but these are undocumented and there are in the neighborhood of a hundred scripts, so it would be pretty hard to read the scripts to see what the fields are.)

Quizzes are created as sets of questions and belong to a particular course.

Quizzes:

There are also surveys, but they seem to go to same creation pages as quizzes.

Questions:

Question Sets:

Students

When you create a quiz for a course, columns are made for each student to have a grade from that quiz.

Answer Sets

Whenever a student takes a quiz or a survey, record the answers of that student.


Remarks for NPAC student database

These question designs almost look sufficient for the quizzes, surveys and evaluation questionnaires that I want to give. The only additional thing is what we currently have on surveys: I would like to be able to design a set of multiple choice questions that all have the same set of answers. This would lead to a nicer display and also to an easier definition page, as you wouldn't have to retype all the answers.

Also for the quizzes, surveys and evaluations, I think it is useful to distinguish which they are. And in addition to the items that they mention about the appearance of the quiz, I would like to be able to add text at various points in the layout of the quiz/survey/evaluation.

For all quizzes/surveys/evaluations, I would like to be able to review the answers of individual students (which I can't do now for surveys) in addition to getting overall statistics.


Nancy McCracken