Online Exam

[raghulvarma]

I am developing a online exam project in that I have a table which has questions and every question has different marks.I am selecting questions in a random manner using newid(), now I am facing with a problwm , the problem is the questions are selected even after it reaches total (100) marks and also it the total comes to 98 the system selects a 3 mark question hence the total reaches more than 100.how to solve this problem. I have 1,2,3,4 mark questions.
Plz experts help me out to solve this problem

thanks in advance
raghul

[kenobewan]

More information about your platform and how far you got so far.

[raghulvarma]

More information about your platform and how far you got so far.

I have almost compleated my project, my platform is asp.net . and my back end is sql. I got the logic also for it , it goes like this
The max mark that has been assigned to a question is 4 so by reducing 4 from
100 we get 96, then when it reaches 96 we need to check 4 the condition ,
if 96 (select a 4 mark question)
else if 97 (select 3 mark question)
else if 98 (select 2 mark question)
if 99 (select a 1 mark question)
is there any other logic to do ???

now I have got another doubt
As I am selecting the questions in random when I press previous button then it has to go to the exaxt previous question. ie when questions are like 5,6,2,8 then when the user is in 8th question then he has to go back like 2,6,5.
can we get the history ?
I tried with session storing the question number in a label and getting that but the problem is it would go only to the (n-1) and not to (n-2) , and so on

help me out thanx in advance

[Shashi Sadasivan]

I have almost compleated my project, my platform is asp.net . and my back end is sql. I got the logic also for it , it goes like this
The max mark that has been assigned to a question is 4 so by reducing 4 from
100 we get 96, then when it reaches 96 we need to check 4 the condition ,
if 96 (select a 4 mark question)
else if 97 (select 3 mark question)
else if 98 (select 2 mark question)
if 99 (select a 1 mark question)
is there any other logic to do ???

You could use an switch case statement, but it the logic still remains the same.

now I have got another doubt
As I am selecting the questions in random when I press previous button then it has to go to the exaxt previous question. ie when questions are like 5,6,2,8 then when the user is in 8th question then he has to go back like 2,6,5.
can we get the history ?
I tried with session storing the question number in a label and getting that but the problem is it would go only to the (n-1) and not to (n-2) , and so on

help me out thanx in advance

Instead of using a invisible label why not have a session variable?
At this time we still do not know what platform you are working on.
I will assume that you creating this as an ASP .Net application.
in which case, you can use a session variable of type List<int>
and keep adding the question number as you progress the questions. they will be stored in the same sequence you add them, so u can iterate the opposite way. This will however not work with .Net 1.1 , in which case you would have to use vector or arrays.