S
Senexis
Hello,
I'm trying to create a database that will be used for creating unique
multiple choice tests based off of a list of questions and answers.
Pretty simple concept but I want to be able to generate random question sets
based on the question grouping, and then since this is a multiple choice
test, be able to generate each question with a different stacking of answers.
I figure I should create three tables.
1, (tbl_Student_data) being the student data.
2, (tbl_Base_questions) being the table that stores the question, the
correct answer, and "obvious distracter" (dummy) answers plus any other
question data like the section the question comes from.
3, (tbl_Student_Questions) being the main table that I work off of for
student test interaction form, reports, etc.
My idea is that a test admin would be able to use a form to generate
questions from the tbl_Base_questions, coupled with the data from
tbl_Student_data to make a unique test each time, and then be able to keep
that test to later have the student be able to either take the test based off
of those unique questions on a secured front end version of the DB, and also
be able to run calculations, reports, and etc off of as well.
My problem that I run into is, how do I get random records from individual
question groups (they're say 50 sections of test material 001-050 and within
each group there are individual questions pertaining to that group/section)
that add up to the total number of questions the Test Admin decides to make
each test. (I can always just have a choice of preset total question tests
as well) And then randomly sort all the answers for each question making for
a "unique" test each time.
I figure the answer to this might be if at the time of generating test
records to the tbl_Student_Questions, I have records set in the
tbl_Student_Questions to be an auto-number random, there by after the append
query gets done merging the tables tbl_Student_data and tbl_Base_questions,
each record appended would have a random number that I could later do
something with. None the less, the goal is to be able to pull random
questions from all question groups (sections) for a total either defined by a
test admin or set number and for each of these questions be able to have
randomly stacked multiple choice answers, while still being able to base
editable forms, queries, reports, etc!
Is there a simple solution to this?
Thanks!
I'm trying to create a database that will be used for creating unique
multiple choice tests based off of a list of questions and answers.
Pretty simple concept but I want to be able to generate random question sets
based on the question grouping, and then since this is a multiple choice
test, be able to generate each question with a different stacking of answers.
I figure I should create three tables.
1, (tbl_Student_data) being the student data.
2, (tbl_Base_questions) being the table that stores the question, the
correct answer, and "obvious distracter" (dummy) answers plus any other
question data like the section the question comes from.
3, (tbl_Student_Questions) being the main table that I work off of for
student test interaction form, reports, etc.
My idea is that a test admin would be able to use a form to generate
questions from the tbl_Base_questions, coupled with the data from
tbl_Student_data to make a unique test each time, and then be able to keep
that test to later have the student be able to either take the test based off
of those unique questions on a secured front end version of the DB, and also
be able to run calculations, reports, and etc off of as well.
My problem that I run into is, how do I get random records from individual
question groups (they're say 50 sections of test material 001-050 and within
each group there are individual questions pertaining to that group/section)
that add up to the total number of questions the Test Admin decides to make
each test. (I can always just have a choice of preset total question tests
as well) And then randomly sort all the answers for each question making for
a "unique" test each time.
I figure the answer to this might be if at the time of generating test
records to the tbl_Student_Questions, I have records set in the
tbl_Student_Questions to be an auto-number random, there by after the append
query gets done merging the tables tbl_Student_data and tbl_Base_questions,
each record appended would have a random number that I could later do
something with. None the less, the goal is to be able to pull random
questions from all question groups (sections) for a total either defined by a
test admin or set number and for each of these questions be able to have
randomly stacked multiple choice answers, while still being able to base
editable forms, queries, reports, etc!
Is there a simple solution to this?
Thanks!