This project contains a sample web application for online MCQ exam system. As a sample it only contains the backend part of the web application.
The project code might be used in various environments after some sort of tweaking but it has been tested in a specific environment. The following tools has been used in the test environment:
- Programming IDE: Visual Studio 2015
- Programming Framework: ASP.NET 4.5 (MVC is preferable but Web Forms should work just fine)
- Database Tool:
- Oracle Database 12c with Oracle Developer Tools for Visual Studio
- Navicat (optional, just needed to redesign the ERD of the database)
- Configure: Please refer to
Database/_Readme.txtfile to install or uninstall database configuration. - Edit: You can directly edit the database scripts in
Database/Scriptsfolder. But for convenience, please openDatabase/Q-Zone.ndmfile with Navicat and edit the database within the app.
After performing the above, you can run easily the project. Please do the followings to run the project:
- Open
Q-Zone.slnwith Visual Studio 2015. - Add a new ASP.NET project to the solution. You can use either MVC or Web Forms but MVC is preferable.
- Add some code to integrate with
Q-Zone.Models. Please refer to Code Overview section for more details.
To view the summary of Q-Zone.Models, please refer to Q-Zone.Models/Models.txt file. Here, the in-depth code overview has been discussed.
It connects the other parts of this project with Oracle database. Cool thing is: the data connector alone can be used in other projects for the same purpose. In this case, you just need to remove the references of Q_Zone and all should be fine.
To sign up, login, logout or delete own account, you need the code. Most of the methods of UserAuthorization have their own documentations, though method names are self-explanatory.
User can view or change his/her own email, password or name. Most of the methods have their own documentations, though method names are self-explanatory.
User can add or view his/her own topics. He/She can also search for some specific topics in his/her topic bank. To delete a topic from the user, please use Delete() method of the corresponding Topic instance.
User can view all the questions in a topic. He/She can change the topic name or even delete the topic along with all the containing questions and quizzes. He/She can also search some specific questions in the topic. To add a new question, call QuestionBank.AddQuestion(topic) passing the corresponding Topic instance.
It is very similar to Topic Bank. User can add, view or search questions. Like Topic Bank, to delete a question, use Delete() method of the corresponding Question instance.
User can perform various operations to his/her own question. Most of the methods have their own documentations, though method names are self-explanatory.
It is very similar to Topic Bank or Question Bank.
User can perform various operations to his/her own quiz. Most of the methods have their own documentations, though method names are self-explanatory. Student user has to use Answer Sheet to give answers to the questions of a quiz.
During a quiz, student user has to use this class. Student user must have to call Submit() before timeout of the quiz. Most of the methods have their own documentations, though method names are self-explanatory.
The name is self-explanatory. Besides most of the methods have their own documentations, though method names are self-explanatory.
It contains some useful methods related to rank list. All of the methods have their own documentations, though method names are self-explanatory.
Here are 2 files:
Encryption.cshas been used in store encrypted passwords in the database. But using it, you may encrypt other things.ValidFormat.cshas been used to check valid email format for database entry.
This is for performing unit test covering many methods of Q-Zone.Models. As unit testing framework, it uses MSTest which comes with Visual Studio 2015.
- Username, password, email
- Change password using current password
- Change email or name
- Add questions (all have fixed marks and minus marks)
- Select topic
- Write question
- Add/Delete options (total 5 options)
- Add correct answer first
- Add 4 incorrect options
- Edit options
- Select difficulty level
- View self-created questions
- By topic
- By browsing questions
- By searching phrase or difficulty
- By topic
- Edit and delete questions (options shown next to questions)
- Select topic
- Add random questions (ordering of options may be different for different participants)
- Choose the number of random questions
- Choose by difficulty or undefined difficulty
- Add fixed questions (ordering of options may be different for different participants)
- By browsing questions
- By searching phrase or difficulty
- View added questions
- Delete questions
- Reorder questions
- Set date, time and duration
- Receive quiz ID
- View self-created quizzes
- By browsing quizzes
- By date or topic
- By quiz ID
- If not self-created, then inform user and show nothing
- By browsing quizzes
- Edit quizzes that have not happened yet (option shown next to quizzes)
- Delete quizzes
- Enter quiz ID
- Show countdown timer
- Before quiz
- During quiz
- After submitting all quiz answers
- Receive marks and percent
- Receive correct answers for quiz questions
- Show link to rank list if quiz duration is over
- View rank lists for past quizzes (does not matter if user is a participant or not)
- By browsing participated quizzes
- By date or topic
- By quiz ID
- If quiz is not over, then inform user and show nothing
- By browsing participated quizzes
- Highlight own rank among others if participated
- View correct answers for quiz questions