online examination system acharya motibhai patel institute of computer studies,ganpat university,...
TRANSCRIPT
Online Examination System
Acharya Motibhai Patel Institute Of Computer Studies ,Ganpat University, Kherva-384012
Presented By : Chaudhary Vijay R(12034211005)
: Patel Jaydip H(13034212043) Semester : MCA - V
Group no : 52
Internal Guide : Prof. Chandrakant D. Patel
Project Name Online Examination System
Objective This system provides healthy and less efforts management of course wise examination with paper settings, questions settings and students wise result.
Front-end PHP 5.2 & Wampserver 2.0
Back-end MySQL 2.1
Tools Used Macromedia Dreamweaver 8
Internal Guide Prof. Chandrakant D. Patel
Group No. 52
Developed By Chaudhary Vijay. (12034211005)Patel Jaydip. (13034212043)
Project Profile
Requirement Specification
In existing system every student have to fill the exam form manually and admit to specific course.
Exam form fill up process. Form checking process. Paper generation process. Paper checking process. Result generation process.
Then after student can get the examination No. into specific Time duration.
After attended the exam students does not view them result at the end of exam.
The main thing is that students cannot get them result When they want.
Existing System
Need For New System
In comparison to the present system the new proposed system will be less time consuming (Save Time).
Analysis will be very easy in proposed system as it is automated.
Result will be very precise and accurate and will be declared at the end of exam.
The proposed system is very secure as no chance of leakage of question paper because it will be dependent on the administrator only.
The log of appeared candidate and their marks are stored.
This system provide MCQ question Facility.
Admin:- Manage user.
Set paper.
Manage exam. Manage Feedback.
Student:- Registration.
give exam.
view result. give feedback.
Functional Specification
Processor 2.4 GHz
RAM 4 GB
HDD 10 GB Free Space
Minimum Hardware RequirementServer Side :-
Client Side :-
Processor 1 GHz
RAM 512 MB
HDD 5 GB Free Space
Operating System Window Server 2003
Developing Tool Php 5.2
Front End Apache 2.2.21
Back End MySQL 2.1
Minimum Software RequirementServer Side :-
Operating System Window 7
Browser Mozilla Firefox or any Compatible browser.
Client Side :-
Time line chart (Gantt chart)
0 10 20 30 40 50 60 70 80 90
Requirements(0-10)
Analysis(10-20)
Designing(20-40)
Coding(35-70)
Testing(35-80)
Implementation(80-90)
Documentation(20-90)
DAYS
ACTIVITY
Activity Diagram:- Admin
Student:-
Use Case Diagrams:- Admin
Login
Manage User Profile
ManageSet Paper
ManageExam
Manage Feedback
Admin
Use Case Diagrams:- Student
Registration
Login
Give Exam
View Result
Give Feedback
Student
E-R Diagram:-
ExamManage
Admin
Manage Feedback Give
Manage
Give
View
Manage
Student
Result
Manage
Set Paper
1
1
11
1
1
1
M M
M
1
1
M
M
M 1
UserName
Password
Nameaddress state
Feedback
paperid
question
Exam no
Name
Stud_id
city
Result id
studid
examid
examidename Total marks
Data Dictionary:-
Sr. No
FieldsName
Data Type (Size)
Constrains FieldDescription
Control Name
Validation
1 Stud_id Int (5) Primary Key
Identifies every Student.
Not Null
2 fname Varchar (20)
Not Null Student first name.
TextBox Not Null
3 mname Varchar (20)
Not Null Student middle name.
TextBox Not Null
4 lname Varchar (20)
Not Null Student last name.
Textbox Not Null
5 bdate date Not Null Student Date of Birth.
Drop Down List
Not Null
6 Gender Char (1) Not Null Student Gender. Radio Button Not Null
7 address Varchar (30)
Not Null Student Address Text Area Not Null
8 City Varchar (11)
Not Null Student City. Drop Down List
Not Null
Sr. No
FieldsName
Data Type(Size)
Costrains Field Description
Control Name
Validation
9 State Varchar (11) Not Null Student State. Drop Down List
Not Null
10 Contactno
Int (10) Not Null Student Contact no.
TextBox Not Null
11 Email Varchar (50) Not Null Student Email.
TextBox Not Null
Continue……
Example:-
Stud_id
fname Mname Lname Gender City State Contact no
1 Vijay Ragubhai Chaudhary Male vadali gujarat 9712822651
Sr. No
Field Name
Data Type (Size)
Constrains Description Control Name
Validation
1 stateid Int (5) Primary Key State id.
2 sname Varchar (20)
Not Null State name. Drop Down List
Not Null
Stateid Sname
1 Gujarat
2 Goa
Example:-
Sr. No
Field Name
Data Type (Size)
Constrains Description Control Name
Validation
1 cityid Int (5) primary Key City id.
2 stateid Int(5) Foreign Key State id
3 cname Varchar(20)
Not Null City name. Text Box
Cityid Stateid Cname
1 1 ahmedabad
2 2 gandhinagar
Example:-
Sr. No
FieldsName
Data Type (Size)
Constrains FieldDescription
Control Name
Validation
1 centerid Int (5) Primary key Identifies every Student.
2 cname Varchar (20) Not Null Identifies center name.
Text Box
3 address Varchar (20) Not Null Center address. Text Area
4 Cityid Int (5) Foreign key Center City. Drop Down List
5 Stateid Int (11) Foreign key Identifies State. Drop Down List
centerid cname address Cityid Stateid1 ahmedabad Gujarat 1 1
Example:-
Sr. No
Field Name
Data Type(size)
Constrains Description Control Name
Validation
1 examid Int (5) primary Key Student exam id.
2 ename Varchar (20) Not Null Exam name. Text Box
3 time duration
Varchar (20) Not Null Exam Time. Text Box
4 Total mark
Int (5) Not Null Total Mark Of Exam.
Example:-
Examid ename Time duration Total mark1 Maths 30 1202 reasoning 30 120
3 generalenglish 30 120
4 generalknowledge 30 120
Sr. No
FieldsName
Data Type(Size)
Costrains Field Description Control Name
Validation
1 qid Int (5) Primary Key
Student for question Id.
2 question Text Not Null Student Question. TextBox
3 option1 Varchar (20) Not Null Student question option.
Radio Button
4 option2 Varchar (20) Not Null Student question option.
Radio Button
5 option3 Varchar (20) Not Null Student question option.
Radio Button
6 option4 Varchar (20) Not Null Student question option.
Radio Button
7 answer Varchar (20) Not Null Student question answer.
8 examid Varchar (20) Foreign key
Student for exam Id.
Example:-
qid question Option1 Option2 Option3 Option4 answer examid
1 html full form.......
Hyper text markup langage
hyper text protocal
hyper text pre-proce
hyper data a 1
Sr. No
Field Name
Data Type(size)
Constrains Description Control Name
Validation
1 Paperid Int (5) Primary Key
Student paper id.
2 question Text Not Null Student Question.
Text Box
3 Exam no Int (5) Not Null Student exam no.
Example:-
paperid question Exam No
1 What is Php? 1
Sr. No
FieldsName
Data Type(Size)
Costrains Field Description
Control Name
Validation
1 resultid Int (5) Primary Key
Student for result Id.
2 studid Int (5) Primary key Student id.
3 examid Int (5) Foreign Key Student exam id.
4 passdate Date Not Null Student exam pass date.
5 totalmark Int (5) Not Null Student total mark.
Label
6 obtainmark Int (5) Not Null Student obtain mark.
Label
7 seatno Varchar (50) Not Null Student seat no.
Example:-
resultid studid examid passdate totalmark obtainmark seatno
1 1 1 1-dec-2014 120 40 1
Sr. No
Field Name
Data Type(size)
Constrains Description Control Name
Validation
1 username Varchar (20) Not Null username. Text Box
2 password Varchar (20) Not Null password. Text Box
3 centerid Int (5) Not Null Center id.
Example:-
Username password centerid
Admin Admin 1
Sr. No
FieldsName
Data Type(Size)
Costrains Field Description Control Name
Validation
1 Username Varchar (20) Primary Key
username. TextBox
2 password Varchar (20) Not Null password. Text Box
3 userlevel Varchar (20) Not Null Level of user. Drop Down List
4 studid Int (5) Foreign Key Student id.
5 centerid Int (5) Foreign Key Student center id.
Example:-
username password userlavel studId centerId
Admin Admin Visitor 1 1
Sr. No
FieldsName
Data Type (Size)
Constrains FieldDescription
Control Name
Validation
1 name Varchar (30) Not Null Identifies Student name.
TextBox
2 address Varchar (100) Not Null Student address. TextBox
3 phone Varchar (10) Not Null Student phone no. TextBox
4 city Varchar (20) Not Null Student city. Textbox
5 Postelcode
Varchar (6) Not Null Student Postal code.
Text Box
6 state Varchar (20) Not Null Student state. Text Box
7 fax Varchar (20) Not Null Student fax Text Box
8 email Varchar (50) Not Null Student email id. Text Box
9 feedback Varchar (300) Not Null Student Feedback Text Box
Example:-
name address phone city state fax email feedback
vijay vadali 9712822651 vadali Gujarat 234567 [email protected]
Hello friend your site successful.
Sequence Diagram:- Admin
Sequence Diagram:- Student
Add
1
*
**
*
*
1
1
1
1
Add
Add
*
*
1
1
1
1
Class Diagram:-
1
*
*
*
Collaboration Diagram:- Admin
Collaboration Diagram:- Student
Input Output Design:-
Admin Side:-Admin Login Page:-Form Name:-index.php Description: - This page is Admin Login Page.Admin is to put your correct username or password in text box they are Login.
Admin Home Page:-Form Name:-admin.phpDescription: - This Page Is Admin Home Page.
User Registration Page:-Form Name:-adduser.phpDescription: - This Page Is student registration Page in basic information.
Add Center Page:-Form Name:-addcenter.phpDescription: - This Page Is Add Center Page in State And City Wise.
Add Question Maths Page:- Form Name: - addquestion.phpDescription: - This Page Is Add Maths Question Page.
Add Question Reasoning Page:-Form Name: - addquestion.phpDescription: - This Page Is Add Reasoning Question Page.
Add Question General English Page:-Form Name: - addquestion.phpDescription: - This Page Is Add General English Question Page.
Add Question General Knowledge Page:-Form Name: - addquestion.phpDescription: - This Page Is Add General Knowledge Question Page.
Edit User Page:-Form Name: - edituser.phpDescription: - Are You Sure Add User Information.
Edit User Page:-Form Name: - edituserprocess.phpDescription: - Edit User Information Are Easy To Modify.
Edit Center Page:-Form Name: - editcenterprocess.phpDescription: - Admin Edit center in Particular Student.
Edit Question Maths Page:-Form Name: - editprocess.phpDescription: - Admin Edit Question in Maths Page.
Edit Question Reasoning Page:-Form Name: - editprocess.phpDescription: - Admin Edit Question in Reasoning Page.
Edit Question General English Page:-Form Name: - editprocess.phpDescription: - Admin Edit Question in General English Page.
Edit Question General Knowledge Page:-Form Name: - editprocess.phpDescription: - Admin Edit Question in General Knowledge Page.
Delete User Page:-Form Name: - deleteuser.phpDescription: - Admin Delete User in Particuler Student.
Delete Center Page:-Form Name: - deletecenter.phpDescription: - Admin Delete Center in Particuler Student.
Delete Question Maths Page:-Form Name: - deletequestion.phpDescription: - Admin Delete Maths Question in Particuler Paper.
Delete Question Reasoning Page:-Form Name: - deletequestion.phpDescription: - Admin Delete Reasoning Question in Particuler Paper.
Delete Question General English Page:-Form Name: - deletequestion.phpDescription: - Admin Delete General English Question in Particuler Paper.
Delete Question General Knowledge Page:-Form Name: - deletequestion.phpDescription: - Admin Delete General Knowledge Question in Particuler Paper.
View User Page:-Form Name: - viewuser.phpDescription: - Admin Can View User in This Page.
View Center Page:-Form Name: - viewcenter.phpDescription: - Admin Can View Center in This Page.
View Question Maths Page:-Form Name: - viewquestion.phpDescription: - Admin Can View question in Maths Page.
View Question Reasoning Page:-Form Name: - viewquestion.phpDescription: - Admin Can View question in Reasoning Page.
View Question General English Page:-Form Name: - viewquestion.phpDescription: - Admin Can View question in General English Page.
View Question General Knowledge Page:-Form Name: - viewquestion.phpDescription: - Admin Can View question in General Knowledge Page.
Generate Question Paper:-Form Name: - viewallquestion.phpDescription: - Admin Can View all question in Generate Page.
Admin View Feedback:-Form Name: - viewfeedback.phpDescription: - Admin Can View Feedback Page.
Student Side:-Student Registration Page:-Form Name: - registration.phpDescription: - Student Can Registration Page in Fill Basic Information.
Student Login Page:-Form Name: - index.phpDescription: - Student Can Login Into Username And Password.
Student Home Page:-Form Name: - userexam.phpDescription: - Student Can Login Into Username And Password Is Correct In Home Page.
Maths Question Paper Page:-Form Name: - givetest.phpDescription: - Student Can Maths Give Test In Page.
Maths Result Page:-Form Name: - giveresult.phpDescription: - Student Can Maths Give Test In Declare Result Page.
General Knowledge Question Paper Page:-Form Name: - givetest.phpDescription: - Student Can Generalknowledge Give Test Page.
General Knowledge Question Result Page:-Form Name: - giveresult.phpDescription: - Student Can Generalknowledge Give Test In Declare Result Page.
Reasoning Question Page:-Form Name: - givetest.phpDescription: - Student Can Reasoning Give Test Page.
Reasoning Question Result Page:-Form Name: - giveresult.phpDescription: - Student Can Reasoning Give Test In Declare Result Page.
General English Question Page:-Form Name: - givetest.phpDescription: - Student Can General English Give Test Page.
General English Question Result Page:-Form Name: - giveresult.phpDescription: - Student Can General English Give Test In Declare Result Page.
Student Feedback Page:-Form Name: - feedback.phpDescription: - Student Can Send Feedback Page.
Testing
No. Test Case Expected Result Actual Result Pass/Fail
1Click login button without username & password
Enter UserName & Password
Enter UserName & Password
Pass
No. Test Case Expected Result Actual Result Pass/Fail
1Click on login button with username & password
Login Successful
Login Successful
Pass
No. Test Case Expected Result Actual Result Pass/Fail
1Click Submit button without Registration.
System does not Allow Registration.
Enter Registration Form.
Pass
No. Test Case Expected Result Actual Result Pass/Fail
1Click Submit button with Registration And Validation.
Registration Successful.
Registration Successful.
Pass
FUTURE ENHANCEMENT In future we will send message and email to student.
The usage of software increases the efficiency, decreases the effort.
It has been thoroughly tested and implemented.
BIBLIOGRAPHY/REFERENCES
BOOK REFERENCES
Web REFERENCE
http://www.tutorialspoint.com/php/http://www.w3schools.com/php/php_form_validation.asp http://www.tutorialspoint.com/php/php_and_mysql.htmhttp://www.google.com
Book Title PHP6 and MySQL 6 Bible
Author Steve Suehring, Tim Converse, Joyce Park
Edition 3rd Edition
Publication Bible publication
Price 699