ADVANCED COLLEGE OF ENGINEERING AND MANAGEMENT M ANAGEMENT KUPONDOLE, LALITPUR
A PROPOSAL ON ONLINE EXAMINATION FOR B.E ENTRANCE
SUBMITTED BY:
SUBMITTED TO:
Ambika Singh(505) Manzil Bhujel(518) Nikita Acharya(519) Pratima Lingden(525)
DEPARTMENT OF COMPUTER AND ELECTRONICS ENGINEERING
10th JULY 2011
Abstract Today most of the universities or colleges are conducting their exams online to be a part of this fastest growing world. Online examination system is a web based software application that allows a particular institute to arrange, conduct and manage the objective examination via online. Online examination system is helpful for educational purpose to conduct logic test besides the subjective on a regular basis. It also reduces the administrator’s load and helps provide the flexibility to teacher’s need for mass evaluation. The online examination will be conducted co nducted at the same time at different centers located at different parts of country. There will be an invigilator at each center for the purpose of user authentication.
i
Acknowledgement We would like to express our most sincere gratitude and appreciation to our project teacher Er.Badri Adhikari of Department of Computer and Electronics for supervising our work. His fruitful suggestions, friendly attitude and continued encouragement were the sources of inspiration for us at every stage of our work. We must acknowledge our gratitude to Er.Shyan Kirat Rai and Mr.Anil K.C for giving us valuable advices regarding our project. We would like to acknowledge and thank our group members and seniors of our college for their sincere advice and constant guidance and supervision and continuous encouragement throughout the preparation of the project. We would also like to thank all the peoples who are directly or indirectly involved. At last, but not the least we would like to thank the management of our college for providing us the good environment for developing our project.
ii
Table of Contents Abstract .......................................................................................................................................................... i Acknowledgement .................................................................................................................................... ii List of Figures............................................................................................................................................. iv 1
Introduction ........................................................................................................... ............................ 1
2
Objective and scope ........................................................................................................................ 2
3
4
2.1
Objectives ......................................................... ......................................................... .................. 2
2.2
Scope ........................................................ ......................................................... ............................ 2
Literature Review .......................................................... ....................................................... ........... 3 3.1
Background ................................................................................................................................ 3
3.2
Existing Situation ................................................................................................. .................... 3
3.3
JAVA......................................................................................................... ...................................... 4
3.4
MYSQL .......................................................................................................................................... 5
3.5
JSP .................................................................................................................................................. 5
3.6
E-R diagram ..................................................... ......................................................... .................. 6
3.7
System Environment .................................................................................................. ........... 7
3.7.1
Hardware requirements ......................................................... ...................................... 7
3.7.2
Software requirements ................................................................................................. 7
Design Diagrams .............................................................................................................................. 8 4.1
5
Use Case Diagram.......................................................................................................... ........... 8
4.1.1
Use Case Diagram for Student ........................................................ ............................ 8
4.1.2
Use Case Diagram for Invigilator .............................................................................. 9
4.1.3
Use Case Diagram for Exam section ....................................................... ................10
Feasibility Study .............................................................................................................................11 5.1
Economic Feasibility ...................................................... .......................................................11
5.2
Technical Feasibility .............................................................................................................11
5.3
Operational Feasibility .........................................................................................................12
6
Architecture of ONLINE EXAMINATION ..................................................... ..........................13
7
Project Schedule .............................................................................................................................14
8
Conclusion ........................................................................................................................................15
9
References ........................................................................................................................................16
iii
List of Figures Figure 1:-Online examination ............................................................................................................. 1 Figure 2:- Present Situation ................................................................................................................ 4 Figure 3:- Mass evaluation .................................................................................................................. 4 Figure 4:- ER Diagram of Online Examination ........................................................................... 6 Figure 5:-Use Case Diagram for Student ..................................................................................... 8 Figure 6:-Use Case Diagram for Invigilator ................................................................................. 9 Figure 7:-Use Case Diagram of Exam Section........................................................................10 Figure 8:- Architecture of web based Online Examination .................................................13 Figure 9:- Gantt chart ...........................................................................................................................14
iv
1 Introduction With response to the growing number of students entering universities, many universities and colleges prefer to conduct online examinations for their entrance, which are suitable for mass evaluation. This method could evaluate student’s achievement, and helps to give fair scores. The main objective of Online Examination System is to efficiently evaluate the candidate thoroughly through a fully automated system that not only saves lot of time but also gives fast results. For teachers, it would give flexibility to fit their needs and to the students there will be no loss in time for the need of using extra thing like paper, pen etc. This system also focuses on how to provide a secure environment for Online Examination. Institute of Engineering (IOE) is one of the top technical institutes under Tribhuvan University (TU) and is governing body for engineering and architecture education under the umbrella of TU. It was established in 1972, IOE is Nepal's oldest and the widest engineering education consortium. IOE provides Diploma, Bachelors, Masters and Ph.D. degrees in engineering and architecture education through its constituent campuses and several private colleges affiliated to it. This software is targeted for the B.E entrance. The candidates will have an individual login. The candidates will be provided the individual login username and password at the centre after submission of entrance form and voucher. At each centre’s, there will be an invigilator for the purpose of identification of candidates appearing for examination. After the completion of login process for all the students the timer will be set and the candidates can start attempting the question. When the timer is up, there is automatic submission of answers.
Figure 1:-Online examination
1
2 Objective and scope This encloses the needs and scope of the development of the project. The objectives can be explained as following:-
2.1 Objectives
To conduct the examination in an efficient manner and reduce the tedious paper work. To efficiently evaluate the candidate thoroughly through a fully automated system that not only saves lot of time but also gives fast results. To store the logs of appeared candidates and their marks and backup for future use. To save the time of exam section and minimize the use of manpower. To facilitate the examiner.
2.2 Scope
This can be used in educational institutions as well as in corporate world. It helps to efficiently reduce the load of administrator’s mass educational evaluation. It also reduces the waste of time of candidates for using extra things like paper, pen, scale, etc. It gives quick result and forbids the unfair scores. It is focused on the benefit of both the student and exam conduction section.
2
3 Literature Review Today’s world is computer dominated world. Each and every field is dependent on computer to perform the task ranging from simple to complex one. Computer has been applied in almost every field among which Education field is one of them. So we intended to develop a computer based online examination system that will help in smoothening the BE entrance.
3.1 Background B.E entrance examination is one of the competitive exams conducted in Nepal. Many candidates target for this examination from all over the places of Nepal. As for this mass evaluation our proposed system “Online Examination System for B.E Entrance” can stand a better way. The present exam conducting format includes different processes like:
Sit arrangement Printing questions Question/answer sheet Admit card checking Candidates confirmation
This process being done manually, it requires more time and manpower. For this extra consumption of time, this system provides the better solution. Since there are many candidates for B.E entrance, there are different centre’s chosen for conducting the entrance exam. The main risk in paper format is the probability of losing the answer sheet. This system converts all the paper work into computer work. Each candidate will be provided with a unique user-name and password for the security while appearing the exam to prevent the unauthorized access. Regarding more security the image of the candidate is shown after the login. Then the timer will be set after the login and after each candidate is being sitted the questions will be provided. So this system will stand as the helping hand for the B.E entrance.
3.2 Existing Situation Institute of engineering affiliated to Tribhuvan University, is a leading college of Nepal. Every year many candidates apply for the BE entrance examination. Presently IOE is using the paper based system for managing BE entrance exam. The paperwork has provided them with a lot of confusion and conflicts during the decision making so that some of their decision remains pending and some are 3
decided under bad consequences. The alternative is the online examination system that has been designed especially for the purpose of BE entrance. The paper based works are replaced by the computerized semi-automatic system which is an efficient method in under developed country such as Nepal.
Figure 2:- Present Situation
Figure 3:- Mass evaluation
3.3 JAVA Java is great programming language for the development of enterprise grade applications. This programming Language is evolved from a language named Oak. Oak was developed in the early nineties at Sun Microsystems as a platformindependent language aimed at allowing entertainment appliances such as video game consoles and VCRs to communicate. Oak was first slated to appear in television set-top boxes designed to provide video-on-demand services. Oak was 4
unsuccessful so in 1995 Sun changed the name to Java and modified the language to take advantage of the burgeoning World Wide Web. Java is an object-oriented language, and this is very similar to C++. Java Programming Language is simplified to eliminate language features that cause common programming errors. Java source code files are compiled into a format called byte-code, which can then be executed by a Java interpreter.
3.4 MYSQL MYSQL, pronounced as “MY S-Q-L” or “MY SEQUEL” is an open source relational database management system (RDBMS) that runs as a server providing multiuser access to a number of databases. The SQL phrase stands for Structured Query Language. It is used for adding, removing and modifying information in the database Standard SQL commands, such as ADD, DROP, INSERT and UPDATE can be used with MYSQL. A websites that uses may include web pages that access information from the database. These pages are often referred as “dynamic” meaning the content of each page is generated from a database as the page loads.it is also Open Source and freely accessible. MYSQL is used to access the databases on the internet due to its connectivity, speed and security. It was developed to manage large databases.
3.5 JSP Java Server Pages or JSP for short is Sun's solution for developing dynamic web sites. JSP provide excellent server side scripting support for creating database driven web applications. JSP enable the developers to directly insert java code into jsp file, this makes the development process very simple and its maintenance also becomes very easy. JSP pages are efficient, it loads into the web servers memory on receiving the request very first time and the subsequent calls are served within a very short period of time. In today's environment most web sites servers dynamic pages based on user request. Database is very convenient way to store the data of users and other things. JDBC provide excellent database connectivity in heterogeneous database environment. Using JSP and JDBC it’s very easy to develop database driven web application. Java is known for its characteristic of "write once, run anywhere." JSP pages are platform independent.
5
3.6 E-R diagram
centre
Exam id
Exam date
Invigilator Exam
Gives
Has
Phone no.
DOB category
Question id
Gender Username
Difficulty Student Address
Question no.
Question
Type Choice 4
Password
Image location
Choice 2 Choice 1
Choice 3
Figure 4:- ER Diagram of Online Examination
6
3.7
System Environment For design and development given system environment is required.
3.7.1 Hardware requirements Processor:
Pentium-IV 2.6 GHz or above
Hard Disk Drive:
4 GB or above
Monitor:
LCD or CRT as softcopy display
Keyboard:
PS/2
Mouse:
Better optical
RAM:
1 GB or above recommended
3.7.2 Software requirements Front End
:
JSP
Back End
:
MYSQL Server 2005
Operating System Language
:
:
Windows, Linux JAVA
7
4 Design Diagrams 4.1 Use Case Diagram 4.1.1 Use Case Diagram for Student
Appear exam
Provide question
Answer
Result
Centre/location
Image
Student
Figure 5:-Use Case Diagram for Student
8
4.1.2 Use Case Diagram for Invigilator
Image of student
Exam date
Centre/location
Invigilator
Figure 6:-Use Case Diagram for Invigilator
9
4.1.3 Use Case Diagram for Exam section
Online Examination System
Conduct exam
Provide question Questions
Collect answers
Exam date
Centre/location Exam section Provide username And password
Print result
Figure 7:-Use Case Diagram of Exam Section
10
5 Feasibility Study Feasibility study is about the viability of a system. The proposed system has to be examined for its technical, economical and operational feasibility. Feasibility is evaluated from developer and user's point of view. Developer sees whether they have the required technology or manpower to build the required system. Is building the new system really going to benefit the customer? Does the customer have the required money to build that type of a system? All these issues are covered in the feasibility study of the system. The feasibility of the system is evaluated on the three main issues: technical, economical, and operational. Another issue in this regard is the legal feasibility of the project. The feasibility study investigates the problem and the information needs of the stakeholders. It seeks to determine the resources required to provide an information systems solution, the cost and benefits of such a solution, and the feasibility of such a solution.
5.1 Economic Feasibility It is a process of identifying the airfare search benefits with a development project. Project is found to be economically feasible since security is the need of the time. Economic analysis is most frequently used for evaluation of the effectiveness of the system. This part of feasibility study gives the top management the economic justification for the new system. This is an important input to the management, because very often the top management does not like to get confounded by the various technicalities that bound to be associated with a project of this kind. A simple economic analysis that gives the actual comparison of costs and benefits is much more meaningful in such cases. In the system, the organization is most satisfied by economic feasibility. Because, if the organization implements this system, it need not require an additional hardware resources as well as it will be saving lot of time.
5.2 Technical Feasibility It is the process of assessing the development application ability to construct a proposed system. According to feasibility analysis procedure the technical feasibility of the system is analyzed and the technical requirements such as software facilities, procedure, inputs are identified. Test is made to see whether reliable hardware and software, technical resources are capable of meeting the 11
needs of a proposed system and can be acquired or developed by webpage in the required time. Technical feasibility centers on the existing manual system of the test management process and to what extent it can support the system.
5.3 Operational Feasibility Operational feasibility study is a must, because it ensures that the implementation of the software as an application should be high . People are inherently resistant to change and computer has been known to facilitate changes. An estimate should be made of how strong the user is likely to move towards the development of computerized system. There are various levels of users in order to ensure proper authentication and authorization and security of sensitive data of the organization.
12
6 Architecture of ONLINE EXAMINATION
Client
Client
1
Web and Application server Online Exam Business Logic
2
DATABASE SERVER
3
App DB
Figure 8:- Architecture of web based Online Examination
1- Client tier 2- Application tier 3- Database tier
13
7 Project Schedule
Figure 9:- Gantt chart
14
8 Conclusion Online examination system is a web based application that provides facility to conduct online examination at a certain centre. It saves time, as it allows number of students to give the exam at a time. Administrator has a privilege to create, modify and delete the test papers and its particular questions. User can register, login and give the test with his specific id, and can see the r esults as well.
15
9 References
http://en.wikipedia.org/wiki/Institute_of_Engineering http://www.sql-tutorial.net/ http://www.roseindia.net/jsp/jsp.htm http://en.wikipedia.org/wiki/JavaServer_Pages http://en.wikipedia.org/wiki/Java_(programming_language) www.google.com http://en.wikipedia.org/wiki/MySQL
16
