Quiz Test Maker


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!
 
Ad

Advertisements

T

Tony Dondero

Did this work? Have you done this? I was looking at doing something
similar. If you got it to work I would be interested in the file if you
wouldn't mind emailing it to me at (e-mail address removed). If it is a huge
file, let me know and I can get a different email address that wont bounce it.

Tony Dondero
 
S

smith.smith361

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!
You can try test generator software or online exam software from epractize labs.
The software found all request you have asked.

8 types questions.
Random test.
Automatic evaluation.
Summary report.
Focus lab etc.

Best suitable for educators, trainers and recruiters etc..

Free download at http://www.epractizelabs.com/test-generator/

Take a free trail online exam software at http://www.onlineexamlab.com/sel/register.html
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Quiz Question 4
Web Based Query Maker 0
TEST RESULTS 1
Testing for null 4
test for string 4
HCT Modem test 1
Test Boxes to Fields 12
test for error in if statement 2

Top