I would like to develop an online but i don't know how to start.I would like to start from the scratch. I hope someone with good heart will help me and i will appreciate any help.
Objective:
1. The question will be multiple choice
2. The answers will chosen using a radio button
3. The questions will be thrown randomly
4. The questions will be 1-30 only
5. Before submitting the answer it will display all your answer
6. Then after cliking submit button it will display your score together with the percentage
I see you have prepared little specification of your requirements, which is almost enough for simple online examination system which will accept only one type of answers, multiple choice answers.
Now, the next thing you should think about is WHERE YOU ARE GOING TO STORE THE DATA?
Database is the best way, as you may already know. So, no matter of what Database Management System you will use (I prefer MS SQL) you will have to first design your database, then do implementation.
For such system, you won't need to have a lot of database tables unless you have some other specifications, not only these you've already stated.
So, you need to have one table for the Users who will take the exam. USERS (UserId, username, password, email, address) etc.
Next, you will need to have database tables where you are going to store the Questions and Answers. For example: Questions (SessionId, QuestionId, Question, CorrectAnswer) Answers (SessionId, QuestionId, Answer1, Answer2, Answer3, Answer4, Answer5, Answer6) etc.
then you can add up some more tables depending on your needs.
Once you have finished with your database, next you will have to define how you are going to do the programming.
If you have basic skills of ASP.NET / C#.NET, you may start by simply defining the security of your system by providing Login pages for the users.
After that, you will have to start with the programming. There are millions of possible ways to do the programming. Once you get there, we may continue with the conversation about this here.
But, I will recommend you to look at the following compilation of Video materials which directly shows HOWTO create Quizz System using ASP.NET - Here are your links:
Thank you for your responce and i appreciate it so much. I will keep you posted about my online exam developing and i hope you can help me in the future.. Again thank you for your time and effort to help me out.
To get started, you should firstly make choice which Database Management System you will use.
MS SQL is one of the best, but, as we know that you are not going to have very large database, MS Access may also fit.
As you may have noticed in the video tutorials, MS SQL database is used for the Quiz Engine Application.
So, I will need to know what is your level of databases knowledge and your experience with .NET ?
This is important for me in order to give you the best path to get started with your database.
NOTE: If you've watched the videos I've provided, you may have noticed how the database is organized.
Please, don't hurry up with programming. First make your database, then start with the programming part. This is, of course, very important in order not to stuck afterwards.
Best Regards,
Hajan
Best Regards,
Hajan
Dont forget to Mark as Answer the answer that solved your problem!
Once again sir i would like to thank, im just new in the programming that is why i really need help...
but none the les im so thankful for your assistance extended to me...
Hello there,
Well, can we start by working on MS SQL Server Express Edition 2005 ? (If you don't have it installed,
HERE you can find everything you need)
You will also need SQL Server Management Studio (If you don't have one, click
HERE to download)
So, if you are very beginner in databases, I will recommend you to start by learning from the Video Tutorials we have here in
www.ASP.net website.
SQL Server Video Tutorials
http://www.asp.net/learn/sql-videos/ - this is one of the best video compilation from where you can learn SQL Server basics for very short period of time
ASP.NET 2.0 for Beginners using Visual Web Developer
Please, watch the SQL Server Video Tutorials and give me feedback what you have learnt. Then, I will prepare script for you to create the Online Examination application database with proper explanations on WHAT is WHAT.
Hope I've given you good starting point :)
All the best,
Hajan
Best Regards,
Hajan
Dont forget to Mark as Answer the answer that solved your problem!
Very nice application. I have just passed tru the methods you've created and I think it's Ok.
The only thing I don't like (especially it's not so good for beginners) is that it uses XML as datasource and it's quite harder to maintain then standard database on MS SQL server or other DBMS's.
Insert,Update,Delete etc will be much harder to implement then doing the same by Queries using Database Management System.
So, my opinion to techteam is:
- Look at the code that ganaparthi provided and try to get the idea but do your application (if you want to learn & accomplish) using database as data source.
Regards,
Hajan
Best Regards,
Hajan
Dont forget to Mark as Answer the answer that solved your problem!
techteam
None
0 Points
39 Posts
How to create online exam
Aug 08, 2009 12:20 AM|LINK
Hi to all Masters and Gurus,
I would like to develop an online but i don't know how to start.I would like to start from the scratch. I hope someone with good heart will help me and i will appreciate any help.
Objective:
1. The question will be multiple choice
2. The answers will chosen using a radio button
3. The questions will be thrown randomly
4. The questions will be 1-30 only
5. Before submitting the answer it will display all your answer
6. Then after cliking submit button it will display your score together with the percentage
thanks to all
techteam
hajan
Star
10655 Points
1782 Posts
Re: How to create online exam
Aug 08, 2009 01:56 AM|LINK
Hello there...
I see you have prepared little specification of your requirements, which is almost enough for simple online examination system which will accept only one type of answers, multiple choice answers.
Now, the next thing you should think about is WHERE YOU ARE GOING TO STORE THE DATA?
Database is the best way, as you may already know. So, no matter of what Database Management System you will use (I prefer MS SQL) you will have to first design your database, then do implementation.
For such system, you won't need to have a lot of database tables unless you have some other specifications, not only these you've already stated.
So, you need to have one table for the Users who will take the exam.
USERS (UserId, username, password, email, address) etc.
Next, you will need to have database tables where you are going to store the Questions and Answers. For example:
Questions (SessionId, QuestionId, Question, CorrectAnswer)
Answers (SessionId, QuestionId, Answer1, Answer2, Answer3, Answer4, Answer5, Answer6) etc.
then you can add up some more tables depending on your needs.
Once you have finished with your database, next you will have to define how you are going to do the programming.
If you have basic skills of ASP.NET / C#.NET, you may start by simply defining the security of your system by providing Login pages for the users.
After that, you will have to start with the programming. There are millions of possible ways to do the programming. Once you get there, we may continue with the conversation about this here.
But, I will recommend you to look at the following compilation of Video materials which directly shows HOWTO create Quizz System using ASP.NET - Here are your links:
Building Quizzes Engine part 1
Building Quizzes Engine part 2
Building Quizzes Engine part 3
Building Quizzes Engine part 4
Hope this helps...
Best Regards,
Hajan
Hajan
Dont forget to Mark as Answer the answer that solved your problem!
My ASP.NET Weblog
techteam
None
0 Points
39 Posts
Re: How to create online exam
Aug 08, 2009 03:33 PM|LINK
Good day Mr.Hajan,
Thank you for your responce and i appreciate it so much. I will keep you posted about my online exam developing and i hope you can help me in the future.. Again thank you for your time and effort to help me out.
hajan
Star
10655 Points
1782 Posts
Re: How to create online exam
Aug 08, 2009 06:26 PM|LINK
Good day my friend,
Just go on with your project and have a good luck with everything you are going to do.
Please, don't hesitate to ASK anything you need in order to accomplish your project successfully.
Best Regards,
Hajan
Hajan
Dont forget to Mark as Answer the answer that solved your problem!
My ASP.NET Weblog
techteam
None
0 Points
39 Posts
Re: How to create online exam
Aug 10, 2009 07:50 AM|LINK
Good day Sir,
I would like to ask how will i start with my database and i would like to use radio button and the question will be displayed using label
Thanks a lot
Alex,
hajan
Star
10655 Points
1782 Posts
Re: How to create online exam
Aug 10, 2009 08:08 AM|LINK
Hello Alex,
You have sample database for Quiz / Examination application in the Building Quizzes Engine part 2 video.
To get started, you should firstly make choice which Database Management System you will use.
MS SQL is one of the best, but, as we know that you are not going to have very large database, MS Access may also fit.
As you may have noticed in the video tutorials, MS SQL database is used for the Quiz Engine Application.
So, I will need to know what is your level of databases knowledge and your experience with .NET ?
This is important for me in order to give you the best path to get started with your database.
NOTE: If you've watched the videos I've provided, you may have noticed how the database is organized.
Please, don't hurry up with programming. First make your database, then start with the programming part. This is, of course, very important in order not to stuck afterwards.
Best Regards,
Hajan
Hajan
Dont forget to Mark as Answer the answer that solved your problem!
My ASP.NET Weblog
techteam
None
0 Points
39 Posts
Re: How to create online exam
Aug 10, 2009 09:58 AM|LINK
Once again sir i would like to thank, im just new in the programming that is why i really need help...
but none the les im so thankful for your assistance extended to me...
hajan
Star
10655 Points
1782 Posts
Re: How to create online exam
Aug 10, 2009 10:13 AM|LINK
Hello there,
Well, can we start by working on MS SQL Server Express Edition 2005 ? (If you don't have it installed, HERE you can find everything you need)
You will also need SQL Server Management Studio (If you don't have one, click HERE to download)
So, if you are very beginner in databases, I will recommend you to start by learning from the Video Tutorials we have here in www.ASP.net website.
SQL Server Video Tutorials
http://www.asp.net/learn/sql-videos/ - this is one of the best video compilation from where you can learn SQL Server basics for very short period of time
ASP.NET 2.0 for Beginners using Visual Web Developer
http://www.asp.net/learn/videos/#cms_video_1381
Please, watch the SQL Server Video Tutorials and give me feedback what you have learnt. Then, I will prepare script for you to create the Online Examination application database with proper explanations on WHAT is WHAT.
Hope I've given you good starting point :)
All the best,
Hajan
Hajan
Dont forget to Mark as Answer the answer that solved your problem!
My ASP.NET Weblog
ganaparthi
Participant
1266 Points
330 Posts
Re: How to create online exam
Aug 10, 2009 10:18 AM|LINK
Hi
I Created One Online Examination Application using C#,Asp.Net And Xml Database..
Please Refer It May Help ful to ur Project..
http://srinuganaparthi.wordpress.com/2009/04/29/online-quiz-using-c-and-xml-data/
Bye..
All the Best
Srinivas Ganaparthi,
'All things are difficult before they are easy'
My Blog
hajan
Star
10655 Points
1782 Posts
Re: How to create online exam
Aug 10, 2009 10:26 AM|LINK
Very nice application. I have just passed tru the methods you've created and I think it's Ok.
The only thing I don't like (especially it's not so good for beginners) is that it uses XML as datasource and it's quite harder to maintain then standard database on MS SQL server or other DBMS's.
Insert,Update,Delete etc will be much harder to implement then doing the same by Queries using Database Management System.
So, my opinion to techteam is:
- Look at the code that ganaparthi provided and try to get the idea but do your application (if you want to learn & accomplish) using database as data source.
Regards,
Hajan
Hajan
Dont forget to Mark as Answer the answer that solved your problem!
My ASP.NET Weblog