Some Suggestion needed!!!!!

1. Senior Member
Join Date
Dec 1969
Posts
111

## Some Suggestion needed!!!!!

Hi!<BR> I am working on a online examination project.<BR> Let me brief about it. <BR>There is a supervisor who selects a subject for a particular batch of students. Now when the batch(students) get to their page(after getting authorized) theres a link &#039;Questions&#039;, as they click on to this link one question comes after the other(one question can be attempted only once) & every student gets a &#039;unique&#039; question.<BR><BR>I have a table structure like<BR><BR> Tb1<BR> -----<BR> QuestId<BR> Subject<BR> Question<BR> Answer<BR><BR>Questions are stored randomly, so when the supervisor select subject as &#039;Math&#039; then all questions related to Math will come up in the recordset<BR><BR>Now the problem is <BR># How to allocate question(unique) to each student.<BR># if there is a batch of 4 students & no of questions in Tb1 related to &#039;Maths&#039; are 20 then each student should get 5 questions each.<BR># if there is a batch of 4 students & no of questions in Tb1 related to &#039;Maths&#039; are 18 then first 2 students(on a first come first serve basis)will get 5 questions & other 2 who have loggen in later will get 4 each.<BR><BR>Hope you got the problem.<BR><BR>Waiting for some suggestions.<BR><BR>Thanks for your valuable time & patience to go through this.<BR><BR>

2. Member
Join Date
Dec 1969
Posts
70

## Some idea, though

don&#039;t know whether it will work. When a student log&#039;s in create a session variable and then store this value in the application variable too, so that u can get an idea on how many people are logged(or do u have definite information about the no. of students in a batch?). <BR><BR>Then for the first person give question no. 1 and second one gets question no. 2. if there are 4 students then 5 question will again go to student 1.<BR><BR>i know it is easy to give ideas(not so easy!) and difficult to make it work. <BR><BR>Anyway best of luck

3. Senior Member
Join Date
Dec 1969
Posts
111

## RE: Some idea, though

Thanks!<BR><BR>Its an Intranet Application running in an Institute.<BR><BR>No, Students in a batch are not fixed they can vary anywhere between 3-5.<BR>They are given a time period in which they can login and attend to the questions.<BR><BR>I have something like to have all those question related to the particular subject into a temporary table called TbBatch1 and from there to pick questions accordingly but in that too i am facing some problems<BR><BR>What do you suggest.

#### Posting Permissions

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