Question How to create an Exam Question Bank

[yus786]

I run a Homework club and have been asked to design/create an Exam Question Bank.

Might be better to explain this using examples.

Say GCSE English: The Exam Bank will have 50 questions within. The user requires 10 questions to be printed. The Exam Bank would select 10 random questions and print them.

Would require this for about 15 subjects.

Any idea on how to start?

I'm looking for idea's and suggestions at this stage.

Thanks

 

[namliam]

I suggest you start with Normalizing your data then designing the database

 

[Steve R.]

I run a Homework club and have been asked to design/create an Exam Question Bank.

Well, I don't know if I am really going to help you or not, but I just happened to have a dusty old experiment lying aground. Attached is a sample database that I toyed with a year ago. Please be aware that this is highly incomplete and not tested. Also, I have NOT looked at in over a year, so I have forgotten how some of this works. Because it is highly incomplete, I am somewhat reluctant about posting, but you asked.

Essentially, what this program is designed to do is to randomize the answer questions so that the order of the answer will always be different. Clearly this will require that the student use a computer when answering the questions.

Take a look at "TblAnswer" this table identifies the correct answer and also the answers that should be displayed for each question. "AQUIDNUM" identifies the question that the answers belong too.

"tblQuestion" identifies the questions (test pool) to be asked. This table, as a test pool, will need to have a logical field added to identify the test questions that have been selected. Also, in your case, you may want to create another table or field to identify the subject area. See namliam's comment on normalization.

This project was an experiment that I toyed with, but never got around to completing. If this meets your needs, good luck on adapting. Keep in mind that this is (was) an unfinished project.

I hope that you will post back on how this turned out. Good Luck!!

-------------------------------------------------------------------
PS: I fixed the program to the extent that it now has correct answers so that you can verify that it is working and should not unexpectedly crash. However, I have not delved into issues, such as recording the answers or randomizing the questions themselves. I have also made no attempt to clean-up the code. Basically this is a skeleton (unfinished project) that can be used as a building block to do want you want, if it looks like it is what you want.

 

[HiTechCoach]

Attached is a great example of how to properly normalize database for a survey/questionnaire/test

 

[Seth Hall]

..........

 

[Steve R.]

..........

Can I assume that you resolved the issue?

I took a quick look. I note the number of answers appears to be established with the dimension statements below. Also, if I recall correctly, when the answer recordset is established for a question that the program tests to verify that number of answers is valid so that you don't have too many or two few.

Dim aryAnswernum(1 To 5) As Long
Dim strAnswerString(1 To 5) As String
Dim strAnswerHold(1 To 5) As String