HELP!!! MCQ Questionaire for ASP.NET USING VB

Question

2.00/5 (2 votes)

See more:

Hi, Im quite new here.

I have to design a website for physics question mcq test.
this is how it goes,

there are 12 topics
students have to take test,(test consist 10 questions per topic)

I have more than 10 question per topic in the database., thus the test questions have to be randomize from database and not repeated.

need to have A timer function

after they have taken the test

have to calculate their score,
show their score,
allows them to retake once if they fail

now im stuck and i don't know where to continue from.

I have done the simple registeration part.
and my database for questions are, (id, topic, questions, ans, choice1, choice2, choice3, choice4)

Eg, the question is,

|Questions| choice 1| choice 2| choice 3| choice4|

What is the formula of density ? (m*v) ｜　(m/v) | (v*v) | (v/v)

(radiobutton) Choice 1
(radiobutton) Choice 2
(radiobutton) Choice 3
(radiobutton) Choice 4

i need help/advice on how to design the database and how to create the above requirements. please help.

thank you so much.

p/s: do i need more database instead?

Posted 4-Feb-12 6:31am

thebusygirl

Updated 4-Feb-12 6:49am

v2

Add a Solution

Comments

Sergey Alexandrovich Kryukov 4-Feb-12 17:19pm

It could not be "physics". All these tests is just a way to kill the remains of education, the fake education, the way to turn people into zombie. More and more colleges do not teach anything, just do completely useless training in answering useless questions.
--SA

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Christian Graus · Answer 1 · 2012-02-04T07:38:00

Solution 1

As you said, you need to do this. If it's homework, as seems likely, you won't learn anything by us telling you how to do it. By all means, ask specific questions if you get stuck, but the teacher is not trying to teach you how to write a questionairre website, they are trying to teach you how to use google, do basic research, and work things out for yourself. If you can't do those things, you will be unemployable, even if you pass your course b/c we did the work for you.

Posted 4-Feb-12 7:38am

Christian Graus

Comments

Sergey Alexandrovich Kryukov 4-Feb-12 17:20pm

Homework or not -- who cares? The problem itself... please see my comment to the question.
--SA

Christian Graus 4-Feb-12 17:43pm

It matters because a person doing homework, is still learning, and should be learning how to learn, not learning how to ask random strangers for help. I'd still help someone with homework, if I felt they had tried and asked a real question, but I would answer differently, on the basis that I'd be giving instruction to someone with less experience, and I'd expect that I'd be instructing them also on how to do basic research, etc.

thebusygirl 5-Feb-12 12:02pm

hi @Christian Graus, I have done my basic research, that's why i have done my first part. but i tried my ways to setup my questions database etc, 3 different people gave me 3 different answer. yet, i tried every single one of it. im not trying to ask for solution, im asking for advices. i have no choice thus i posted this at here. but without you even understanding my situation, you judged me :(

this task is supposed to be group work but my partner just gave up without even trying and left me alone doing two people's work.... am at my wits' end that's why i posted here. i have tried so many times and im not giving up. i hope you understand.

before you learn how to walk, u need to learn how to crawl. everything takes time. no one is born talented.

and i made it clear enough, i need advices/help. i did not say i need solutions.. even if some kind souls would to give me solutions, i will also need to know how to understand before i can use it....

thank you once again.

Christian Graus 5-Feb-12 15:58pm

Quite simply, several approaches will work. You will get more help if you try one, post code, and ask specific questions.

thebusygirl 6-Feb-12 0:46am

alright, thanks so much for the info. sorry. pls pardon me. cos, im new here. will post my code up instead :D

Simon_Whale · Answer 2 · 2012-02-04T13:17:00

Solution 2

I see your simple database design as follows

1. student
2. Questions
3. PossibleAnswers
4. ActualAnswers
5. StudentsResults

I dont want to do all the work so I have only put how I would list the tables from the information given. I would also suggest some reading for you 10 Useful articles about Database design[^]

Posted 4-Feb-12 13:17pm

Simon_Whale

Comments

thebusygirl 5-Feb-12 12:06pm

thank you so much i will research and try to figure it out :) I really appreciate it so much! thanks Simon_whale !!!! REALLY THANK YOU!!!!!