PERFORMA FOR APPROVAL OF B.TECH VIII SEM MAJOR PROJECT
Major Project Proposal No______________________________ (For office use only) 1. Name of the student______________________________
2. Enrolment of the student__________________________ 3. E-mail:________________________________________ 4. Mob. No._______________________________________ 5. Title of the Major Project_________________________ 6. Name of the Guide_______________________________
For Office Use Only:
Approved Approv ed
Not Approved
Signature Signatur e of the Guide Date: __________
Suggestions for reforming the Major Project: 1. 2. 3. 4.
1
INDEX
S.NO.
PARTICULARS
PAGE NO.
1.
Acknowledgement
3
2
Introduction and objective
4
3
Analysis
5
4
Feasibility study
5
5
Data flow diagram and ER Diagram
6
6
Requirement of project
10
7
Modules
11
8
Table structure
13
9
Data dictionary
15
10
Types of report
17
11
Conclusion
18
12
Future scope
18
2
ACKNOWLEDGEMENT
I am very grateful to my major project guide _____________for giving his valuable time and constructive guidance in preparing the Synopsis/Major Project. It would not have been possible to complete this major project in short period of time without his kind encouragement and valuable guidance.
PURVA GUPTA
3
INTRODUCTION AND OBJECTIVE OF ONLINE EXAMINATION Online
Examination System is a software application which allows a particular institute to
arrange, conduct and manage any objective examination via online. An
Online
Examination is one wherein a student answers his exam on the computer and
submits his answers. The submitted answers are evaluated by the examination software and the results are available immediately. This saves the evaluation time. Main objective of online examination is to provide the system which is secure, easy to use reliable and accurate and also we do not need an examiner to conduct any test.
Technology used y
PHP, HTML,CSS ( front end)
y
MySQL(back end)
Need of the proposed system: 1.
Online
Examination System is designed for Educational Institutes like Schools, Colleges, and Private Institutes to conduct logic tests of their students on a regular basis.
2.
The system handles all the operations and generates reports as soon as the test is completed which saves the precious time of faculties spent on reviewing answer sheets.
3.
The existing system is weak when it comes to surprise test organizations whereas this system can make it possible very easily.
4.
Even the test contains 100 or more questions can be easily checked in few seconds which is not possible manually.
5.
The online examination helps us to conduct the chaptertest which helps the student to check it¶s on potential.
6.
The online exam reducing the cheating because the random question appears in each attempt.
7.
The student will select the subject according to his choice and give the exam
8.
The result page contains all questions with its correct answer so student can correct herself.
4
ANALYSIS FEASIBILITY STUDY 1) ECONOMIC FEASIBILITY:
Economic analysis is most frequently used for evaluation of theeffectiveness of the system. More commonly knows as cost/benefit analysesis the procedure to determine the benefit and saving that are expected from asystem and compare them with costs, decisions is made to design andimplement the system. Thus this project is economical feasible because we are using existing tools and software to develop it. We do not need to buy any other software. We are going to use following tools and software: y
WAMP5 1.7.2
y
DREAMWEAVER
2) TECHNICAL FEASIBILITY: Technical feasibility means whether reliable hardware and software, technical resources capable of meeting the needs of a proposed system can be acquired or developed by an organization in the required time. Technical feasibility centres on the existing system and to what extent it can support the proposed system .The system offers greater levels of user friendliness combined with
greater processing speed. Therefore, the cost of maintenance can be reduced. Since, processing speed is very high and the work is reduced in the maintenance point of view, so we can say project is technical f easible
3) OPERATIONAL FEASIBILITY: O perational
feasibility is mainly concerned with issues like whether the system will be used if it is
developed and implemented. These modules are operational feasible because we have technical skilled persons who can built these module easily. No one needs to learn any new technology or training. The module is very easy to understand and very easy to implement with the existing infrastructure. Therefore operational activities are very fast, so the module can be developed in minimum time with fewer efforts. Thus by reviewing the above mentioned different feasibilities we can say that the project is feasible from all three aspects
5
DATA FLOW DIAGRAM
DFD DIAGRAM LEVEL 0
ONLINE USER
EXAMINATION
RESULT
6
DFD DIAGRAM LEVEL-1
1.0 User SELECT TYPE OF TEST TEST
2.0
RESULT
7
DFD DIAGRAM LEVEL-2
1.1
User
SELECT SUBJECT
LIST
1.2 SELECT
CATEGORY
TEST
1.3 RESULT specification
8
ER DIAGRAM
9
REQUIREMENT OF PROJECT
Hardware Requirement y
Processor
:
1.70GHz and above
y
Main Memory
:
512MB
y
Hard Disk
:
20GB
y
Disk Space
:
100MB
y
Floppy Disk Drive
:
1.44MB
y
Keyboard
:
Any
y
Mouse
:
Any
y
Monitor
:
Any
Software Requirement y
Operating System: Window-XP
y
Front End-PHP
y
Back End-MYSQL
y
Apache Friends
y
Adobe Dreamweaver
y
WAMP Server
10
MODULES
1. USER MODULE y
Register on site
y
Login
on site
y
Select the subject for test
y
Mock test
y
Chapter test
y
Full length test
y
Give Exam
y
View results
2. TEACHER MODULE y
Register on site
y
Login
y
U pload
the questions
y
U pdate
question
y
U pdate
result
on site
3. ADMIN MODULE y
Manage subject
y
Manage chapter
y
Manage question
y
Manage users and teachers
y
U pdate
profile
11
Description of module
1. User
USER MODULE
Module is related with the user information that has login . when a new user visit on our
site then the user need to register himself before login .The information he need to fill in Registration form are Name, Roll no , Email ID , Password ,branch are in the profile which comes from Registration. As he complete with the registration process and fill all detail by fulfilling all validation. Then he just login with his Roll no and Password. If the user is already registered then he can login in the site and can select the subject, then select the kind of test he wants to perform and obtain the result. So this module provides the security against the unauthorized users and conducts the test and generates the result instantly.
2.
TEACHER MODULE
Similar to user/student module, teacher also have to register themselves , registered teacher can login and perform various actions like, they
can upload questions under various
categories, and various subjects update question( Add and Delete) .
3.
ADMIN MODULE
Admin module is related with the admin authorized to maintain the complete database of the system.to provide the security , here only admin can login for that login form is made on which proper validation are applied to provide the complete security .The authorized admin is allowed to
manage the user and teachers. Admin can also perform various modifications like; removeregistered user/teacher, update subjects, questions. Results and reports will be managed by the admin.
.
12
TABLE STRUCTURE 1. ADMIN TABLE S.NO
FIELD NAME
DATA TYPE
NULL/NOT NULL
1.
User
Varchar(50)
NOT NULL
2.
Password
Varchar(20)
NOT NULL
3.
User
Text(20)
NOT NULL
name
Type
2. TEACHER REGISTRATION TABLE S.NO
FIELD NAME
DATA TYPE
NOT NULL
1.
Teacher ID
Varchar (20)
NOT NULL
2.
Teacher Name
Text (20)
NOT NULL
3.
Department
Text (50)
NOT NULL
3. STUDENT REGISTRATION TABLE S.NO
FIELD NAME
DATA TYPE
NULL/NOT NULL
1.
Roll no
Varchar (20)
NOT NULL
2.
Name
(20)
Text NOT NULL
3.
Email_id
Varchar (20)
NOT NULL
4.
Password
Varchar (20)
NOT NULL
5.
Cpassword
Varchar (20)
NOT NULL
6.
Branch
Text(20)
NOT NULL
13
4. SUBJECT TABLE S.NO
FIELD NAME
DATA TYPE
NULL/NOT NULL
1.
Subject code
Varchar (20)
NOT NULL
2.
Subject name
Text(20)
NOT NULL
3.
Semester
Text (20)
NOT NULL
5. QUESTION TABLE S.NO
FIELD NAME
DATA TYPE
NULL/NOT NULL
1.
Subject code
Varchar(5)
NOT NULL
2.
Question
Varchar(50)
NOT NULL
3.
O ption 1
Varchar(20)
NOT NULL
4.
O
ption 2
Varchar(2 0)
NOT NULL
5.
O
ption 3
Varchar(2 0)
NOT NULL
6.
O
ption 4
Varchar(2 0)
NOT NULL
7.
Correct option
Varchar(20)
NOT NULL
14
DATA DICTIONARY
1. ADMIN TABLE S.NO
FIELD NAME
DATA TYPE
DESCRIPTION
1.
User
Varchar
Store user name for checking correct Username
2.
Password
Varchar
Store password corresponding to username
3.
User
Text
Administrator or User
name
Type
2. TEACHER REGISTRATION TABLE S.NO
FIELD NAME
DATA TYPE
DESCRIPTION
1.
Teacher ID
Varchar
Unique
2.
Teacher Name
Text
Name of the teacher
3.
Department
Text
Department of the teacher
key for Every Teacher
3. STUDENT REGISTRATION TABLE S.NO
FIELD NAME
DATA TYPE
DESCRIPTION
1.
Roll no
Varchar
PRIMARY key for Every student
2.
Name
Text
Name of student
3.
Email_id
Varchar
Unique
4.
Password
Varchar
Password of the student
5.
Cpassword
Varchar
Confirm password
6.
Branch
Text
Branch
key for Every student
of the student
15
4. SUBJECT TABLE S.NO
FIELD NAME
DATA TYPE
DESCRIPTION
1.
Subject code
Varchar
Code of the subject
2.
Subject name
Text
Name of the subject
3.
Semester
Text
Semester of the particular subject
5. QUESTION TABLE S.NO
FIELD NAME
DATA TYPE
DESCRIPTION
1.
Subject code
Varchar
Code of the subject
2.
Question
Varchar
Question
3.
O ption 1
Varchar
First choice
4.
O
ption 2
Varchar
Second choice
5.
O
ption 3
Varchar
Third choice
6.
O
ption 4
Varchar
Fourth choice
7.
Correct option
Varchar
Correct answer
TEXT:- It stores the character. VARCHAR:- It uses to store the character and integer values. PRIMARY KEY: it¶s the type of candidate key and it cannot be null. UNIQUE KEY: A unique key can uniquely identify each row in a table. FOREIGN KEY: a foreign key is a field in a relational table that matches a candidate key of another table. 1. USER TABLE: y
R OLL NO- PRIMARY KEY
y
EMAIL ID ± U NIQUE KEY
2. TEACHER TABLE: y
TEACHER ID- PRIMARY KEY 16
3.ADMIN TABLE: y
USERNAME-
PRIMARY KEY
4. SUBJECT TABLE: y
SUBJECT CODE- PRIMARY KEY
5.QUESTION TABLE: y
SUBJECT CODE: FOREIGN KEY
TYPES OF REPORT CRYSTAL REPORT:
Crystal report is a report designer tool to design and report from wide range of data source such as database, xml file etc. crystal report allows users to graphically design data connection¶s and report layout.
Users
can select and link tables from wide range of data
sources such as MS ±excel spread sheets, S QL database, oracle database, and any file system information. Fields from these tables can be placed on the report design surface, and can also be used in custom formulas. Formulas can be evaluated at several phases during report generation as specified by the developer. In this project we can generate report of the marks obtained by student in the form of mark sheet and other details. Two types of reports can be generated by the system when user conduct the test, they are: RESULT:
This consists of the total marks obtained by the student. It also shows the total attempted question by the student in the test. The marksheet displays the total number of correct question. And also display the student detail like rollno, name, branch, subject name, semester. TEST ANALYSIS:
This report displays all the question of attempted test along with their correct answer and its brief description given by the respective teacher.
17
CONCLUSION: Online
Examination System forms the lifeline of the Educational Institutes to the functioning
of the Examination. It is very essential for an Institute to handle the Examinations and their results. It is very useful for an Institute to test its students continuously for their mutual development. This system is helpful for conducting(M.C) Multiple Choice Examinations which can be conducted regularly as well as for surprise tests and provides immediate results saving the precious time of faculties to check the papers and prepare mark sheets .The IT initiatives have encouraged various
Organizations
to develop systems to facilitate their day to
day operations. This system helps in conducting examinations quickly and can thus help in saving time and the operations will be carried out efficiently .With the effective use, any Institute can apply the ³ Online Examination System´ for conducting quick examinations and getting better results in less time.
FUTURE SCOPE y
The product feature can be provide so that the user can even buy the product online and become the member and test him every day, the product may be time bounded or may be number of time test conducted.
y
While making it online project we can make our project specific to particular city so at a time number of student of particular college or school can conduct the test on the mentioned city only.
y
The system can generate the report which provide the comparison of results of various exam taken by the user in different subjects in graphical form
18