Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2007
    Location
    Seattle
    Posts
    7

    Question Unanswered: Design multiple choice pre-post test

    Hi: I am new to this forum. Thanks in advance for any help you all may provide. I can really use it! I am creating a database of multiple choice questions that will be used to: (1) generate pre and post tests; (2) score pre and post tests; (3) report test results. The master list is about 60 questions in length. Answer sets range on an average of 4-5 per question, and each answer set is different (unique to that question). I created a Questions table containing the following fields: Subject (there are about 10 categories); Question ID, Question, Correct Answer, Student Answer, and Answer Set (which may contain 4 or 5 possible answers in a drop down or combo box). I am not sure that I've set this up correctly. Once I've figured this part out, I know I'll be back for help on the rest of my tasks. Thanks again for your help.
    --Kathy

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Quote Originally Posted by karingwood
    I created a Questions table containing the following fields: Subject (there are about 10 categories); Question ID, Question, Correct Answer, Student Answer, and Answer Set
    With this setup only one student can answer each question.
    George
    Home | Blog

  3. #3
    Join Date
    Nov 2007
    Location
    Seattle
    Posts
    7

    error of my ways

    Yes, I see now that this won't work. Can you offer any suggestions? Thanks.

    Kathy

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    One quiz can have many questions.
    (or is it many quiz's have many questions)...

    One student can answer many questions...

    How's that for a start?
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •