Examination Management Syste

Title of the Project
Introduction to Purpose System (Examination Management System)

Examination Management System is a software developed for the students who give exams in
colleges and institutes. It facilitates to access the examination information of a particular student
in a particular class. The information is sorted by the operators, which will be provided by the
teacher for a particular class. This system will also help in evaluating examination eligibility
criteria of a student.
The purpose of developing examination management system is to computerized the traditional

way of taking exams. Another purpose for developing this software is to generate the report
automatically about the sitting arrangement during exams at the end of the session or in the
between of the session.
The scope of the project is the system on which the software is installed, i.e. the project is
developed as a desktop application, and it will work for a particular institute. But later on the
project can be modified to operate it online.
Examination Management System basically has two main modules for proper functioning
 First module is admin which has right for creating new examination cell for new batch
and update student results.
 Second module is handled by the user which can be a faulty or an operator. User has a
right to see the results.
The main purpose of the online examination program is that it allows companies/institutions to
perform examinations to any number of applicants at once, in a computerized manner. It
decreases enough time intake and amount of work that exist in the current program of evaluation.
It also allows in saving the record of each evaluation and the results are also saved in the
program. This makes the seeking of the information easier than the current program.
Examination Management System is very useful for Educational Institute to prepare an exam,
safe the time that will take to check the paper and prepare mark sheets. It will help the Institute to
testing of students and develop their skills. But the disadvantages for this system, it takes a lot of
times when you prepare the exam at the first time for usage. And we are needs number of
computers with the same number of students.
The effective use of "Examination Management System", any Educational Institute or training
centers can be use it to develop their strategy for putting the exams, and for getting better results
in less time.
Objectives Of the Project
The primary objective of the program is to effectively assess the applicant thoroughly through a
completely automated system that not only helps you to save a lot of time but also gives quick
outcomes. It is a cost-effective and well-known indicates of mass- assessment program.
Corporate between the data stored in the server of the Institution and our On-line Exam system.
To deal with On-line System in an easy way and an efficient mannered. (connection process)
Create strong and secrete data base that allow for any connection in a secret way, to prevent any
outside or inside attacks.
Specify a privilege for each person to allow each person use this system to create his own exam.
And have a complete control on his exam.
Allow each person to create more than one exam with different way to create variant questions.
Scope and limitations:

 Examination Management system is designed for Educational Institutes (like schools,
universities, training centers).
 The system handles all the operations, and generates reports as soon as the test is finish,
that includes name, mark, time spent to solve the exam.
 Allow students to see or display his answers after the exam is finish.
 The type of questions is only multiple choice or true and false.
SYSTEM ANALYSIS
2.1 Existing system

The Existing system of conducting examination process is manual. It has so many
problems. So we introduce a new system, which is fully computerized. Existing system is a large
man power process and is difficult to implement. Working of existing system is given below: -
Student Registration is the first process . As the part of the registration, the student has to
enter his name, address etc into the registration form. After the registration, make the question
papers and it will give to the prospective student. The question papers contain total mark,
subject, duration, question paper etc.
A group of person does evaluation of answer sheet. After the evaluation of the Answer
sheet , the result is published. And also make the mark list.
2.2 Proposed system

The main objective of the online examination system is that it helps
companies/institutions to conduct exams to any number of candidates at a time, in an automated
manner. It reduces the time consumption and workload that exist in the current system of
examination. It also helps in storing the record of each examination and the results are also
stored in the system. This makes the searching of the records easier than the existing system.
2.3 Objectives of the proposed system

The main purpose of the system is to efficiently evaluate the candidate thoroughly
through a fully automated system that not only saves a lot of time but also gives fast results. It is
a cost-effective and popular means of mass- evaluation system.
2.4 Feasibility study
Feasibility is a measure of how beneficial the development of the information system will
be to an organization. This is done by investigating the existing system in the area under
investigation or generally ideas about a new system. It is a test of a system proposal according to
its workability, impact on the organization, ability to meet user needs, and effective use of
resources.
Three key considerations are involved in the feasibility analysis: economic, technical, and legal.
Economic feasibility:
Economic analysis is the most frequently used method for evaluating the
effectiveness of a proposed system. It is more commonly known as cost benefit analysis, the
procedure to determine the benefits and saving that are expected from a candidate system and
compare them with costs. If the benefits outweigh costs then a decision is made to design and
implement the system. Otherwise make alterations in the proposed system.
The innovation of the new system has much influence on the economical side of the
company. Manuel system is highly cost driven due to the high labor costs. So if a company
registers with the Online_Examination site, they can automate their day-to-day activities. Thus
the system is economically feasible.
Technical feasibility:
In examining Technical feasibility of the system, more importance is given to the
hardware interaction part of the system. The assessments of technical feasibility centers on the
existing system and to what extent it can support the proposed addition. This was based on an
outline design of system requirements in turns of inputs, files, programs, procedures, and staff. It
involves financial considerations to accommodate technical enhancements. Online Examination

being a web based application, it uses .Net framework, 800MHZ computer, 20 GB Hard disk.
Legal feasibility:
People are inherently resistant to change, and computers have been known to
facilitate change. An estimate should be made about the reaction of the user staff towards the
development of a computerized system. Computer installations have something to do with
turnover, transfers and changes in job status. The introduction of a candidate system requires
special effort to educate, sell and train the staff for conducting the business.
Features of Purposed System:
These are the important features of the project Courier Management System:
 In computer system the person has to fill the various forms & number of copies of the
forms can be easily generated at a time.
 In computer system, it is not necessary to create the Manifest but we can directly print it,
which saves our time.
 It contains better storage capacity.
 Accuracy in work.
 Easy & fast retrieval of information.
 Well-designed reports.
 Decrease the load of the person involve in existing manual system.
 Access of any information individually.
 Work becomes very speedy.
 Easy to update information.
Feasibility Study:
After doing the system study and analyzing all the existing or required functionalities of the
system, the next task is to do the feasibility study for the project. All projects are feasible - given
unlimited resources and infinite time.
Feasibility study includes consideration of all the possible ways to provide a solution to the given
problem. The proposed solution should satisfy all the user requirements and should be flexible
enough so that future changes can be easily done based on the future upcoming requirements.
A. Economical Feasibility
This is a very important aspect to be considered while developing a project. We decided
the technology based on minimum possible cost factor.
All hardware and software cost has to be borne by the organization.
Overall we have estimated that the benefits the organization is going to receive from the
proposed system will surely overcome the initial costs and the later on running cost for system.
B. Technical Feasibility
This included the study of function, performance and constraints that may affect the
ability to achieve an acceptable system. For this feasibility study, we studied complete
functionality to be provided in the system, as described in the System Requirement Specification
(SRS), and checked if everything was possible using Visual Basic 6.0 and MS Access.
C. Operational Feasibility
No doubt the proposed system is fully GUI based that is very user friendly and all inputs
to be taken all self-explanatory even to a layman. Besides, a proper training has been conducted
to let know the essence of the system to the users so that they feel comfortable with new system.
As far our study is concerned the clients are comfortable and happy as the system has cut down
their loads and doing.
System Requirements:
Software Requirement:
 Visual Basic 6.0
 MS Access
 Windows 2000, XP, 7 etc
Hardware Requirements:
 Processor Pentium IV or higher version.
 Ram 128 MB or above
 Hard Disk 150 MB or above
Project Category:
Relational Database Management System (RDBMS) : This is an RDBMS based
project which is currently using MySQL for all the transaction statements. MySQL is
an opensource RDBMS System.
Brief Introduction about RDBSM :
A relational database management system (RDBMS) is a database management
system (DBMS) that is based on the relational model as invented by E. F. Codd, of
IBM's San Jose Research Laboratory. Many popular databases currently in use are
based on the relational database model.
RDBMSs have become a predominant choice for the storage of information in new
databases used for financial records, manufacturing and logistical information,
personnel data, and much more since the 1980s. Relational databases have often
replaced legacy hierarchical databases and network databases because they are
easier to understand and use. However, relational databases have been challenged
by object databases, which were introduced in an attempt to address the object-
relational impedance mismatch in relational database, and XML databases.
RDBMS Architecture Diagram
Tools/Platform, Hardware and Software Requirement specifications:
For setting this ecommerce portal, it requires certain technical requirements to be
met for the store to operate properly. First, a web server must be created to make
the ecommerce store publicly available on the web. Domain names and hosting
services can easily be purchased for an affordable price. When selecting a hosting
service, you should check to see that these server requirements are provided and
installed on their web servers:
SYSTEM ANALYSIS
The analysis model is a concise, precise abstraction of what
the desired system must do, and not how it will be done after
the study of the existing system is completed. This basically
includes system study and the requirement analysis.
Interacting with the clients regarding their requirements and
expectations from the system does requirement analysis.
The steps, which are essential for system analysis, are:
1. Research and define essential components.

2. Analyze current processes and identify gaps.
3. Interview users, Trainee, Trainers and other concerned
personnel regarding essential components and current
processes.
4. Write requirements document.
5. Define standards for standards, policies, and procedures.
6. Review draft requirements document with users, Trainee,
Trainers and other concerned personnel.
7. Update and expand project plan.
FEASIBILITY STUDY
At this stage, the analyst estimates the urgency of the project and
estimates the development cost.
In feasibility analysis, we have to study the following:
1) Technical Feasibility:
Technical feasibility is concerned with the availability of

hardware and software required for the development of the
system, to see compatibility and maturity of the technology
proposed to be used and to see the availability of the
required technical manpower to develop the system.
After the study we came to conclusion that we proceed

further with the tools and development environment chosen
by us. This was important in our case as we were working
on two various phases of the department that will need to
be integrated in future to make an extended system.
2) Operational Feasibility:
Operational feasibility is all about problems that may arise

during operations. There are two aspects related with this
issue:
 What is the probability that the solution developed may
not be put to use or may not work?
 What is the inclination of the management and end

users towards the solution? Though, there is very least
possibility of management being averse to the solution,
there is a significant probability that the end users may
not be interested in using the solution due to lack of
training, insight etc.
3) Economic Feasibility:
It is the measure of cost effectiveness of the project. The

economic feasibility is nothing but judging whether the
possible benefit of solving the problems is worthwhile of
not. At the feasibility study level, it is impossible to estimate
the cost because member’s requirements and alternative
solutions have not been identified at this stage. However,
when the specific requirements and solutions have been
identified, the analyst weighs the cost and benefits of all
solutions, this is called “cost benefit analysis.
PROJECT PLANNING
Software project plan can be viewed as the following:
1) Within the organisation: How the project is to be

implemented? What are various constraints (time, cost,
staff)? What is market strategy?
2) With respect to the customer: Weekly or timely meetings with

the customer with presentation on status reports.
Customers feedback is also taken and further modification
and developments are done. Project milestones and
deliverables are also presented to the customer.
For a successful software project, the following steps can be

followed:
 Select a project
o Identifying project’s aims and objectives
o Understanding requirements and specification
o Methods of analysis, design and implementation
o Testing techniques
o Documentation
 Project milestones and deliverables
 Budget allocation
o Exceeding limits within control
 Project Estimates
o Cost
o Time
o Size of code
o Duration
 Resource Allocation
o Hardware
o Software
o Previous relevant project information
o Digital Library
 Risk Management
o Risk avoidance
o Risk detection
System Design
In this phase, a logical system is built which fulfils the given

requirements. Design phase of software development deals with
transforming the customer’s requirements into a logically working
system. Normally, design is performed in the following in the
following two steps:
1) Primary Design Phase: In this phase, the system is designed

at block level. The blocks are created on the basis of
analysis done in the problem identification phase. Different
blocks are created for different functions emphasis is put on
minimising the information flow between blocks. Thus, all
activities which require more interaction are kept in one
block.
2) Secondary Design Phase : In the secondary phase the

detailed design of every block is performed.
The general tasks involved in the design process are the

following:
I. Design various blocks for overall system processes.
II. Design smaller, compact and workable modules in each

block.
III. Design various database structures.

IV. Specify details of programs to achieve desired
functionality.
V. Design the form of inputs, and outputs of the system.
VI. Perform documentation of the design.
VII. System reviews.
User Interface Design

User Interface Design is concerned with the dialogue between a
user and the computer. It is concerned with everything from
starting the system or logging into the system to the eventually
presentation of desired inputs and outputs. The overall flow of
screens and messages is called a dialogue.
The following steps are various guidelines for User
Interface Design:
1) The system user should always be aware of what to do next.
2) The screen should be formatted so that various types of
information, instructions and messages always appear in the
same general display area.

3) Message, instructions or information should be displayed
long enough to allow the system user to read them.
4) Use display attributes sparingly.
5) Default values for fields and answers to be entered by the
user should be specified.
6) A user should not be allowed to proceed without correcting
an error.
7) The system user should never get an operating system
message or fatal error.

TESTING
Testing is the process in which the system is run on
manually created input so that the system is correctly working as
desired or not.
During systems testing, the system is used experimentally

to ensure that the software does not fail. In other words, we can
say that it will run according to its specifications and in the way
users expect. Special test data are input for processing, and the
results examined.
A limited number of users may be allowed to use the system

so that analyst can see whether they try to use it in unforeseen
ways. It is desirable to discover any surprises before the
organization implements the system and depends on it.
Testing of a system is generally done in two phases – One is Unit

Testing which is done for each module independently on its
completion and the other one is System Testing which is done at
the end of a project.
VALIDATION CRITERIA
The validation criteria in this project are as follows...
In E-Commerce Portal System also, the user inputs are

validated before storing them, and then further for displaying etc.
The main validations that are done in E-Commerce Portal System
are as follows –
All the screens have a similar look and feel. They all have the
almost same color combinations in its background. This provides
a better user interface to the users.
1) The primary key values cannot be duplicated.
2) All the entries in any combo box have been sorted in

alphabetical order. This helps a user while selecting a value
from the combo box.
IMPORTANCE OF TESTING
During systems testing, the system is used experimentally to
ensure that the software does not fail. In other words, we can
say that it will run according to its specifications and in the way
users expect. Special test data are input for processing, and the
results examined.
The importance of system testing is that the system is

expected to run according to member’s requirement before
delivering it to the customer.
Implementing
&
Testing
THE STEPS IN THE SOFTWARE TESTING

The steps involved during Unit testing are as follows:
a) Preparation of the test cases.

b) Preparation of the possible test data with all the validation
checks.
c) Complete code review of the module.
d) Actual testing done manually.
e) Modifications done for the errors found during testing.
f) Prepared the test result scripts.
The unit testing done included the testing of the following items:
1) Functionality of the entire module/forms.

2) Validations for user input.
3) Checking of the Coding standards to be maintained during
coding.
4) Testing the module with all the possible test data.
5) Testing of the functionality involving all type of calculations
etc.
6) Commenting standard in the source files.
After completing the Unit testing of all the modules, the whole
system is integrated with all its dependencies in that module.
While System Integration, We integrated the modules one by one
and tested the system at each step. This helped in reduction of
errors at the time of the system testing.
The steps involved during System testing are as follows:

 Integration of all the modules/forms in the system.
 Preparation of the test cases.
 Preparation of the possible test data with all the validation
checks.
 Actual testing done manually.
 Recording of all the reproduced errors.
 Modifications done for the errors found during testing.
The System Testing done included the testing of the
following items:
1. Functionality of the entire system as a whole.

2. User Interface of the system.
3. Testing the dependent modules together with all the
possibletest data scripts.
4. Verification and Validation testing.
5. Testing the reports with all its functionality.
After the completion of system testing, the next following phase

was the Acceptance Testing. Clients at their end did this and
accepted the system with appreciation.
Thus, we reached the final phase of the project delivery.

There are other six tests, which fall under special category. They
are described below:
i. Peak Load Test: It determines whether the system will

handle the volume of activities that occur when the system
is at the peak of its processing demand. For example, test
the system by activating all terminals at the same time.
ii. Storage Testing: It determines the capacity of the system to

store transaction data on a disk or in other files.
iii. Performance Time Testing: it determines the length of time

system used by the system to process transaction data. This
test is conducted prior to implementation to determine how
long it takes to get a response to an inquiry, make a backup
copy of a file, or send a transmission and get a response.
iv. Recovery Testing: This testing determines the ability of user
to recover data or re-start system after failure. For example,
load backup copy of data and resume processing without
data or integrity loss.
v. Procedure Testing: It determines the clarity of

documentation on operation and uses of system by having
users do exactly what manuals request. For example,
powering down system at the end of week or responding to
paper-out light on printer.
vi. Human Factors Testing: It determines how users will use the
system when processing data or preparing reports.
COST ESTIMATION OF THE PROJECT
Software cost comprises a small percentage of overall computer-

based system cost. There are a number of factors, which are
considered, that can affect the ultimate cost of the software such
as - human, technical, Hardware and Software availability etc.
The main point that was considered during the cost estimation of
project was its sizing. In spite of complete software sizing,
function point and approximate lines of code were also used to
"size" each element of the Software and their costing.
The cost estimation done by me for Project also depend upon the
baseline metrics collected from past projects and these were
used in conjunction with estimation variables to develop cost and
effort projections.
We have basically estimated this project mainly on two bases -
1) Effort Estimation - This refers to the total man-hours required

for the development of the project. It even includes the time
required for doing documentation and user manual.
2) Hardware Required Estimation - This includes the cost of the

PCs and the hardware cost required for development of this
project.
GANTT CHART
January February March
Requirement Gathering
Analysis
Design
Coding
Testing
Implement
W W W W W W W W W W W W4
1 2 3 4 1 2 3 4 1 2 3
Wi‘s are weeks of the months, for i =1, 2, 3, 4

0- level DFD:
User/Administra
tor
Sys Output
tem
1- level DFD:
Login
Proces
s
Attendan Report
ce entry Generati
Student Questi
entry on on
entry
Data Dictionary of the Project
Examination Management
System
User Table Fields and Datatype
Field Name Datatype
user_id Autonumber
User_name Text
User_Password Text
User_level Text
User_user_id Integer
Subject Table Fields and Datatype

Field Name Datatype
subject_id Autonumber
Subject_name text
Branch Table Fields and Datatype

Field Name Datatype
branch_id Autonumber
branch _name text
Teacher Table Fields and Datatype

Field Name Datatype
teacher_id Autonumber
teacher _name text
teacher_local_address Text
teacher_permanent_address Text
teacher_phone Text
teacher_email Text
teacher_gender Text
Student Table Fields and Datatype

Field Name Datatype
student_id Autonumber
Student_roll Text
Student_course text
student _name text
student_local_address Text
student_permanent_address Text
student_phone Text
student_email Text
student_gender Text
Question Table Fields and Datatype

Field Name Datatype
question_id Autonumber
question_branch_id text
question_subject_id Text
question_title Text
question_ans1 Text
question_ans2 Text
question_ans3 Text
question_ans4 Text
question_correct text
Exam Result Table Fields and Datatype

Field Name Datatype
result_id Autonumber
result_user_id text
result_question_id text
result_answer text
result_correct text
result_exam_id text
Student Result Table Fields and Datatype

Field Name Datatype
result_id Autonumber
result_exam_id text
result_student_id text
result_branch_id text
result_subject_id text
result_total_question text
result_incorrect_answer text
result_correct_answer text
Screens of the Project
System
Coding of the Project
System
Code of MDI Form:
Private Sub abt_Click()
frmAbout1.Show
End Sub
Private Sub binfo_Click()

book_info.Show
End Sub
Private Sub branch_report_Click()

BranchReport.Show
End Sub
Private Sub changePass_Click()

frmChangePass.Show
End Sub
Private Sub exit_Click()

End
End Sub
Private Sub MDIForm_Load()

Call db
If userLevel = "student" Then
question_management.Visible = False
teacher_management.Visible = False
users_management.Visible = False
student_management.Visible = False
student_result.Visible = False
openwin.Visible = False
project_repots.Visible = False
frmExam.Show
End If
If userLevel = "teacher" Then

question_management.Visible = True
teacher_management.Visible = False
users_management.Visible = False
student_management.Visible = False
student_result.Visible = False
openwin.Visible = False
project_repots.Visible = False
frmQuestions.Show
End If
End Sub
Private Sub question_management_Click()

frmQuestions.Show
End Sub
Private Sub question_report_Click()
Questions.Show
End Sub
Private Sub Results_Click()

ResultReport.Show
End Sub
Private Sub student_management_Click()

frmStudent.Show
End Sub
Private Sub student_report_Click()

StudentReport.Show
End Sub
Private Sub subject_management_Click()

frmSubject.Show
End Sub
Private Sub branch_management_Click()
frmBranch.Show
End Sub
Private Sub subject_report_Click()

SubjectReport.Show
End Sub
Private Sub teacher_management_Click()

frmTeacher.Show
End Sub
Private Sub teacher_report_Click()

TeacherReport.Show
End Sub
Private Sub users_management_Click()

frmUsers.Show
End Sub
Code of Branch
Private Sub Command1_Click()
Dim rs As New ADODB.Recordset
If branch_id.Text <> "" Then
rs.Open "select * from branch where branch_id = " & Trim(branch_id.Text), cn,
adOpenKeyset, adLockOptimistic
rs!branch_id = branch_id.Text rs!
branch_name = branch_name.Text
rs.Update
MsgBox "Branch Updated Successfully", vbInformation
Else
rs.Open "branch", cn, adOpenKeyset, adLockOptimistic
rs.AddNew
rs!branch_name = branch_name.Text
rs.Update
MsgBox "Branch Added Successfully", vbInformation
End If
Command1.Caption = "Save Record"
Command2.Visible = False
Call Branch_Fill
Call frmclear
End Sub
Public Sub Branch_Fill()
branchList.ListItems.Clear
Set rs = New ADODB.Recordset
Dim o_ListItem As ListItem
rs.Open "select * from branch", cn, adOpenKeyset, adLockOptimistic
Do While Not rs.EOF = True
Set o_ListItem = branchList.ListItems.Add(, , rs!branch_id)
o_ListItem.SubItems(1) = rs!branch_name
rs.MoveNext
Loop
rs.Close
End Sub
Private Sub cmdadd_Click()

rs.Open "branch", cn, adOpenKeyset, adLockOptimistic
rs.AddNew
rs!branch_name = branch_name.Text
rs.Update
MsgBox "Branch Saved Successfully", vbInformation
Call frmclear
Call Branch_Fill
End Sub
Private Sub cmddel_Click()

rs.Open "select * from branch where branch_id = " & Trim(branch_id.Text), cn,
ans = MsgBox("Are you sure to delete!", vbYesNo + vbInformation)
If ans = 6 Then
rs.Delete
MsgBox "Branch Deleted Successfully", vbInformation
Call Branch_Fill
End If
Call frmclear
End Sub
Private Sub cmdfind_Click()

Dim ID As String
ID = InputBox("Enter the ID", "")
rs.Open "select * from branch where branch_id =" & ID & " ", cn, adOpenKeyset,
adLockOptimistic
If rs.EOF = True Then

MsgBox "Record Not Found", vbInformation, "Not Exit"
Exit Sub
Else
branch_id.Text = rs!branch_id
branch_name.Text = rs!branch_name
rs.MoveNext
End If
End Sub
Private Sub cmdupdate_Click()
rs.Open "select * from branch where branch_id =" & branch_id.Text & " ", cn, adOpenKeyset,
adLockOptimistic
rs!branch_id = branch_id.Text rs!
branch_name = branch_name.Text
rs.Update
MsgBox "Branch Updated Successfully", vbInformation

Call frmclear
Call Branch_Fill
End Sub
Private Sub Form_Load()

Call Branch_Fill
End Sub
Private Sub branchList_ItemClick(ByVal Item As MSComctlLib.ListItem)

branch_id.Text = branchList.SelectedItem.Text
branch_name.Text = branchList.SelectedItem.SubItems(1)
End Sub
Public Function frmclear()
For Each Control In Me
If TypeOf Control Is TextBox Then
Control.Text = ""
End If
Next
End Function
Code of Change Password
rs.Open "select * from users where user_id =" & userLoginID & " ", cn, adOpenKeyset,
adLockOptimistic
If newPassword.Text <> confirmPassword.Text Then
MsgBox "New Password and Confirm Password does not match.", vbInformation
Exit Sub
End If
If rs!user_password <> oldPassword.Text Then
MsgBox "Old Password does not match", vbInformation
Exit Sub
End If
rs.Close
rs.Open "select * from users where user_id =" & userLoginID & " ", cn, adOpenKeyset,
adLockOptimistic
rs!user_password = newPassword.Text
rs.Update
MsgBox "Password changed successfully", vbInformation
End Sub
Private Sub cmdexit_Click()

Unload Me
En
End Sub
Code of Exam Form
Dim questionID() As Integer
Dim ques_rs As New ADODB.Recordset

Dim answer As String
'Get the Answer

If Option1.Value = True Then
answer = ques_rs!question_ans1
Option1.Value = False
ElseIf Option2.Value = True Then
End If
If answer = "" Then

MsgBox "Choose the answer"
Exit Sub
End If
'Save the Answer into Database

rs.Open "exam_result", cn, adOpenKeyset, adLockOptimistic
rs.AddNew
rs!result_user_id = userLoginID rs!
result_question_id = ques_rs!question_id
rs!result_answer = answer rs!
result_exam_id = examID rs!result_correct
= ques_rs!question_correct rs.Update
rs.Close
'Move the Question into next
ques_rs.MoveNext
If ques_rs.EOF = True
Then Me.Hide
frmResult.Show
Exit Sub
End If
question.Caption = ques_rs!question_title
Option1.Caption = ques_rs!question_ans1
End Sub

question_frame.Visible = True
question_choice.Visible = False
Call QuestionList
End Sub

Call fillSubject
Call fillBranch
examID = (Now - DateSerial(1970, 1, 1)) * 86400
End Sub
Public Sub QuestionList()

ques_rs.Open "select * from question where question_branch_id ='" &
question_branch_id.Text & "' AND question_subject_id = '" & question_subject_id.Text & "'",
cn, adOpenKeyset, adLockOptimistic
question.Caption = ques_rs!question_title
Option2.Caption = ques_rs!
questiorthyn_ans2 Option3.Caption =
ques_rs!question_ans3 Option4.Caption =
ques_rs!question_ans4
branchID = question_branch_id.Text
subjectID = question_subject_id.Text
End Sub
Public Function fillSubject()

rs.Open "select * from subject", cn, adOpenKeyset, adLockOptimistic
question_subject_id.AddItem rs!subject_name
rs.MoveNext
Loop
rs.Close
End Function
Public Function fillBranch()

question_branch_id.AddItem rs!branch_name
rs.MoveNext
Loop
rs.Close
End Function
Code of Login Form
Private Sub cmdok_Click()
If Trim(txtusername.Text) = "" Then

MsgBox "Please Enter the User_Name before enter.", , "Blank Value"
txtusername.SetFocus
Exit Sub
ElseIf Trim(txtpassword.Text) = "" Then

MsgBox "Please Enter Password before enter.", , "Blank Value"
txtpassword.SetFocus
Exit Sub
End If
rs.Open "select * from users WHERE user_name = '" & Trim(txtusername.Text) & "'", cn,
If Trim(txtusername.Text) = Trim(rs!user_name) And Trim(txtpassword.Text) = Trim(rs!
user_password) Then
Unload Me
userLoginID = rs!user_user_id
userLevel = rs!user_level
frmSplash.Show
cn.Close
Else
MsgBox "Invalid user name"
End If
End Sub
End
End Sub

Call db
End Sub
Private Sub tmrblink_Timer()
If lblblink.Visible = True Then

lblblink.Visible = False
ElseIf lblblink.Visible = False Then
lblblink.Visible = True
End If
End Sub
Code of Question Form

rs.Open "question", cn, adOpenKeyset, adLockOptimistic
rs.AddNew
rs!question_branch_id = question_branch_id.Text rs!

question_subject_id = question_subject_id.Text rs!
question_title = question_title.Text rs!question_ans1
= question_ans1.Text rs!question_ans2 =
question_ans2.Text rs!question_ans3 =
question_ans4.Text rs!question_correct =
question_correct.Text
rs.Update
MsgBox "successfully Added", vbInformation
Call frmclear
Call List_Fill
End Sub
Private Sub cmdclear_Click()

Call frmclear
End Sub

rs.Open "select * from question where question_id =" & question_id.Text & " ", cn,
ans = MsgBox("Are u sure to delete the record", vbYesNo + vbInformation)
If ans = 6 Then
rs.Delete
Call frmclear
Call List_Fill
End If
End Sub

Unload Me
End Sub

Dim ID As String
rs.Open "select * from question where question_id =" & ID & " ", cn, adOpenKeyset,
adLockOptimistic
Exit Sub
Else
question_id.Text = rs!question_id
question_branch_id.Text = rs!question_branch_id
question_subject_id.Text = rs!question_subject_id
question_title.Text = rs!question_title
question_ans1.Text = rs!question_ans1
question_correct.Text = rs!question_correct
rs.MoveNext
End If
End Sub

On Error Resume Next
rs.Open "select * from question where question_id =" & question_id.Text & " ", cn,
rs!question_id = question_id.Text rs!
question_branch_id = question_branch_id.Text rs!
question_subject_id = question_subject_id.Text rs!
question_title = question_title.Text rs!question_ans1
= question_ans1.Text rs!question_ans2 =
question_ans4.Text rs!question_correct =
question_correct.Text
rs.Update
MsgBox "successfully Update", vbInformation

Call frmclear
Call List_Fill
End Sub

Control.Text = ""
End If
Next
End Function

Call List_Fill
Call fillSubject
Call fillBranch
End Sub
Public Sub List_Fill()

itemListing.ListItems.Clear

rs.Open "select * from question", cn, adOpenKeyset, adLockOptimistic
Set o_ListItem = itemListing.ListItems.Add(, , rs!question_id)
o_ListItem.SubItems(1) = rs!question_branch_id
o_ListItem.SubItems(2) = rs!question_subject_id
o_ListItem.SubItems(3) = rs!question_title
o_ListItem.SubItems(4) = rs!question_ans1
o_ListItem.SubItems(8) = rs!question_correct
rs.MoveNext
Loop
rs.Close
End Sub
Private Sub itemListing_ItemClick(ByVal Item As MSComctlLib.ListItem)

question_id.Text = itemListing.SelectedItem.Text
question_branch_id.Text = itemListing.SelectedItem.SubItems(1)
question_subject_id.Text = itemListing.SelectedItem.SubItems(2)
question_title.Text = itemListing.SelectedItem.SubItems(3)
question_ans1.Text = itemListing.SelectedItem.SubItems(4)
question_correct.Text = itemListing.SelectedItem.SubItems(8)
End Sub
Public Function fillSubject()

question_subject_id.AddItem rs!subject_name
rs.MoveNext
Loop
rs.Close
End Function
Public Function fillBranch()

question_branch_id.AddItem rs!branch_name
rs.MoveNext
Loop
rs.Close
End Function
Code of Result Form
End
End Sub

Call calculateResult
End Sub
Public Function calculateResult()

examID = "1440246940"
' Total Correct and InCorrrect Answer
correctAnswer = 0
inCorrectAnswer = 0
totalQuestion = 0
rs.Open "select * from exam_result where result_exam_id = '" & examID & "'", cn,
If rs!result_answer = rs!result_correct Then
correctAnswer = correctAnswer + 1
Else
inCorrectAnswer = inCorrectAnswer + 1
End If
totalQuestion = totalQuestion + 1
rs.MoveNext
Loop
rs.Close
' Save the Result into Database

rs.Open "student_results", cn, adOpenKeyset, adLockOptimistic
rs.AddNew
rs!result_exam_id = examID rs!
result_student_id = userLoginID rs!
result_branch_id = branchID rs!
result_subject_id = subjectID rs!
result_total_question = totalQuestion rs!
result_incorrect_answer = inCorrectAnswer
rs!result_correct_answer = correctAnswer
rs.Update
' Set the Lable Text

your_id.Caption = userLoginID
branch.Caption = branchID
subject.Caption = subjectID
correct.Caption = correctAnswer
incorrect.Caption = inCorrectAnswer
question.Caption = totalQuestion
End Function
Code of Student Form

rs.Open "student", cn, adOpenKeyset, adLockOptimistic
rs.AddNew
rs!student_name = student_name.Text rs!
student_course = student_course.Text rs!
student_roll = student_roll.Text rs!
student_email = student_email.Text rs!
student_mobile = student_mobile.Text rs!
student_address = student_address.Text
If student_male.Value = True Then rs!student_gender = 1

If student_female.Value = True Then rs!student_gender =
2 rs.Update
Call frmclear
Call List_Fill
End Sub

Call frmclear
End Sub
rs.Open "select * from student where student_id =" & student_id.Text & " ", cn, adOpenKeyset,
adLockOptimistic
If ans = 6 Then
rs.Delete
Call frmclear
Call List_Fill
End If
End Sub

Unload Me
End Sub

Dim ID As String
rs.Open "select * from student where student_id = " & ID & " ", cn, adOpenKeyset,
adLockOptimistic
Exit Sub
Else
student_id.Text = rs!student_id
student_name.Text = rs!student_name
student_course.Text = rs!student_course
student_roll.Text = rs!student_roll
student_email.Text = rs!student_email
student_mobile.Text = rs!student_mobile
student_address.Text = rs!student_address
If rs!student_gender = 1 Then
student_male.Value = True
Else
student_female.Value = True
End If
rs.MoveNext
End If
End Sub

rs.Open "select * from student where student_id =" & student_id.Text & " ", cn,
rs!student_id = student_id.Text rs!
student_name = student_name.Text rs!
student_course = student_course.Text rs!
student_roll = student_roll.Text rs!
student_email = student_email.Text rs!
student_mobile = student_mobile.Text rs!
student_address = student_address.Text
If student_male.Value = True Then rs!student_gender = 1

If student_female.Value = True Then rs!student_gender =
2 rs.Update

Call frmclear
Call List_Fill
End Sub

Control.Text = ""
End If
Next
End Function

Call List_Fill
End Sub


rs.Open "select * from student", cn, adOpenKeyset, adLockOptimistic
Set o_ListItem = itemListing.ListItems.Add(, , rs!student_id)
o_ListItem.SubItems(1) = rs!student_name
o_ListItem.SubItems(2) = rs!student_course
o_ListItem.SubItems(3) = rs!student_roll
o_ListItem.SubItems(4) = rs!student_email
o_ListItem.SubItems(5) = rs!student_mobile
o_ListItem.SubItems(6) = rs!student_address
o_ListItem.SubItems(7) = rs!student_gender
rs.MoveNext
Loop
rs.Close
End Sub

student_id.Text = itemListing.SelectedItem.Text
student_name.Text = itemListing.SelectedItem.SubItems(1)
student_course.Text = itemListing.SelectedItem.SubItems(2)
student_roll.Text = itemListing.SelectedItem.SubItems(3)
student_email.Text = itemListing.SelectedItem.SubItems(4)
student_mobile.Text = itemListing.SelectedItem.SubItems(5)
student_address.Text = itemListing.SelectedItem.SubItems(6)
If itemListing.SelectedItem.SubItems(7) = 1 Then
student_male.Value = True
Else
student_female.Value = True
End If
End Sub
Code of Subject Form
rs.Open "subject", cn, adOpenKeyset, adLockOptimistic
rs.AddNew
rs!subject_name = subject_name.Text
rs.Update
MsgBox "Subject Updated Successfully", vbInformation
Call frmclear
Call Subject_Fill
End Sub
Public Sub Subject_Fill()

subjectList.ListItems.Clear

Set o_ListItem = subjectList.ListItems.Add(, , rs!subject_id)
o_ListItem.SubItems(1) = rs!subject_name
rs.MoveNext
Loop
rs.Close
End Sub

rs.Open "select * from subject where subject_id = " & Trim(subject_id.Text), cn,
ans = MsgBox("Are you sure to delete!", vbYesNo + vbInformation)
If ans = 6 Then
rs.Delete
MsgBox "record deleted", vbInformation
Call Subject_Fill
End If
Call frmclear
End Sub

Dim ID As String
rs.Open "select * from subject where subject_id = " & ID & " ", cn, adOpenKeyset,
adLockOptimistic

Exit Sub
Else
subject_id.Text = rs!subject_id
subject_name.Text = rs!subject_name
rs.MoveNext
End If
End Sub

rs.Open "select * from subject where subject_id =" & subject_id.Text & " ", cn,
rs!subject_id = subject_id.Text rs!
subject_name = subject_name.Text
rs.Update
MsgBox "Subject Successfully Update", vbInformation

Call frmclear
Call Subject_Fill
End Sub

Call Subject_Fill
End Sub
Private Sub subjectList_ItemClick(ByVal Item As MSComctlLib.ListItem)

subject_id.Text = subjectList.SelectedItem.Text
subject_name.Text = subjectList.SelectedItem.SubItems(1)
End Sub
Control.Text = ""
End If
Next
End Function

Code of User Form
rs.Open "users", cn, adOpenKeyset, adLockOptimistic
rs.AddNew
rs!user_name = user_name.Text rs!

user_password = user_password.Text rs!
user_level = user_level.Text rs!
user_user_id = user_user_id.Text
rs.Update
Call frmclear
Call List_Fill
End Sub

Call frmclear
End Sub

rs.Open "select * from users where user_id =" & user_id.Text & " ", cn, adOpenKeyset,
adLockOptimistic
If ans = 6 Then
rs.Delete
Call frmclear
Call List_Fill
End If
End Sub

Unload Me
End Sub

Dim ID As String
rs.Open "select * from users where user_id = " & ID & " ", cn, adOpenKeyset, adLockOptimistic

Exit Sub
Else
user_id.Text = rs!user_id
user_name.Text = rs!user_name
user_password.Text = rs!user_password
user_level.Text = rs!user_level
user_user_id.Text = rs!user_user_id
rs.MoveNext
End If
End Sub

rs.Open "select * from users where user_id =" & user_id.Text & " ", cn, adOpenKeyset,
adLockOptimistic
rs!user_id = user_id.Text rs!
user_name = user_name.Text
rs!user_password = user_password.Text rs!
user_level = user_level.Text rs!
user_user_id = user_user_id.Text
rs.Update

Call frmclear
Call List_Fill
End Sub

Control.Text = ""
End If
Next
End Function

Call List_Fill
Call fillLevel
End Sub


rs.Open "select * from users", cn, adOpenKeyset, adLockOptimistic
Set o_ListItem = itemListing.ListItems.Add(, , rs!user_id)
o_ListItem.SubItems(1) = rs!user_name
o_ListItem.SubItems(2) = rs!user_password
o_ListItem.SubItems(3) = rs!user_level
o_ListItem.SubItems(4) = rs!user_user_id
rs.MoveNext
Loop
rs.Close
End Sub

user_id.Text = itemListing.SelectedItem.Text
user_name.Text = itemListing.SelectedItem.SubItems(1)
user_password.Text = itemListing.SelectedItem.SubItems(2)
user_level.Text = itemListing.SelectedItem.SubItems(3)
user_user_id.Text = itemListing.SelectedItem.SubItems(4)
End Sub
Public Function fillLevel()

user_level.AddItem "Admin"
user_level.AddItem "Teacher"
user_level.AddItem "Student"
End Function
Private Sub user_level_Click()
user_user_id.Clear
If user_level.Text = "Teacher" Then
user_user_id.Text = "Select Teacher ID"
rs.Open "select * from teacher", cn, adOpenKeyset, adLockOptimistic
user_user_id.AddItem rs!teacher_id
rs.MoveNext
Loop
rs.Close
ElseIf user_level.Text = "Student" Then
user_user_id.Text = "Select Student ID"
rs.Open "select * from student", cn, adOpenKeyset, adLockOptimistic
user_user_id.AddItem rs!student_id
rs.MoveNext
Loop
rs.Close
End If
End Sub
Code of Module
Public cn As New ADODB.Connection
Public userLoginID As String
Public userLevel As String
Public examID As String
Public branchID As String
Public subjectID As String
Public Function db()

cn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\
Priyanka\Documents\Examination.accdb;Persist Security Info=False;"
cn.Open
End Function
Conclusion
The Examination Management System is developed using Visual Basic fully meets the
objectives of the system which it has been developed. The system design and analysis has
reached a steady state where all bugs have been eliminated. The system is operated at a
high level of efficiency and all the teachers and user associated with the system
understands its advantage. The system solves the problem. It was intended to solve as
requirement specification.
References and Bibliography:
 https://msdn.microsoft.com/en-us/library/9zyzc0tw(v=vs.90).aspx
 http://vb6reference.tomswebdesign.net/
 http://www.slideshare.net/harinipriya2/visual-basic-6-the-complete-reference
 http://www.tutorialspoint.com/listtutorials/ms-access/1
 http://www.quackit.com/microsoft_access/tutorial/

Examination Management Syste

Uploaded by

Copyright:

Available Formats

Examination Management Syste

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Examination Management Syste

Uploaded by

Copyright:

Available Formats

Title of the Project

Introduction to Purpose System (Examination Management System)

The purpose of developing examination management system is to computerized the traditional

Scope and limitations:

2.1 Existing system

2.2 Proposed system

2.3 Objectives of the proposed system

2.4 Feasibility study

involves financial considerations to accommodate technical enhancements. Online Examination

1. Research and define essential components.

In feasibility analysis, we have to study the following:

Technical feasibility is concerned with the availability of

After the study we came to conclusion that we proceed

Operational feasibility is all about problems that may arise

 What is the inclination of the management and end

It is the measure of cost effectiveness of the project. The

1) Within the organisation: How the project is to be

2) With respect to the customer: Weekly or timely meetings with

For a successful software project, the following steps can be

o Identifying project’s aims and objectives

o Understanding requirements and specification

o Methods of analysis, design and implementation

o Exceeding limits within control

o Previous relevant project information

In this phase, a logical system is built which fulfils the given

1) Primary Design Phase: In this phase, the system is designed

2) Secondary Design Phase : In the secondary phase the

The general tasks involved in the design process are the

I. Design various blocks for overall system processes.

II. Design smaller, compact and workable modules in each

III. Design various database structures.

V. Design the form of inputs, and outputs of the system.

VI. Perform documentation of the design.

VII. System reviews.

User Interface Design

user and the computer. It is concerned with everything from

starting the system or logging into the system to the eventually

presentation of desired inputs and outputs. The overall flow of

screens and messages is called a dialogue.

The following steps are various guidelines for User

1) The system user should always be aware of what to do next.

2) The screen should be formatted so that various types of

information, instructions and messages always appear in the

same general display area.

long enough to allow the system user to read them.

4) Use display attributes sparingly.

5) Default values for fields and answers to be entered by the

user should be specified.

6) A user should not be allowed to proceed without correcting

7) The system user should never get an operating system

message or fatal error.

During systems testing, the system is used experimentally

A limited number of users may be allowed to use the system

Testing of a system is generally done in two phases – One is Unit

In E-Commerce Portal System also, the user inputs are

1) The primary key values cannot be duplicated.

2) All the entries in any combo box have been sorted in

The importance of system testing is that the system is