Acharya Motibhai Patel Institute Of Computer Studies , Ganpat University, Kherva-384012 Online Examination System Presented By : Chaudhary Vijay R(12034211005) : Patel Jaydip H(13034212043) Semester : MCA - V Group no : 52 Internal Guide : Prof. Chandrakant D. Patel
Project Profile 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 My. SQL 2. 1 Tools Used Macromedia Dreamweaver 8 Internal Guide Prof. Chandrakant D. Patel Group No. 52 Developed By Chaudhary Vijay. (12034211005) Patel Jaydip. (13034212043)
Requirement Specification
Existing System ü 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.
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.
Functional Specification Admin: Manage user. Set paper. Manage exam. Manage Feedback. Student: Registration. give exam. view result. give feedback.
Minimum Hardware Requirement Server Side : Processor 2. 4 GHz RAM 4 GB HDD 10 GB Free Space Client Side : Processor 1 GHz RAM 512 MB HDD 5 GB Free Space
Minimum Software Requirement Server Side : Operating System Window Server 2003 Developing Tool Php 5. 2 Front End Apache 2. 2. 21 Back End My. SQL 2. 1 Client Side : Operating System Window 7 Browser Mozilla Firefox browser. or any Compatible
Time line chart (Gantt chart) Requirements(0 -10) Analysis(10 -20) A C T I V I T Y Designing(20 -40) Coding(35 -70) Testing(35 -80) Implementation(80 -90) Documentation(20 -90) 0 10 20 30 40 50 DAYS 60 70 80 90
Activity Diagram: - Admin
Student: -
Use Case Diagrams: - Admin Login Manage User Profile Manage Set Paper Admin Manage Exam Manage Feedback
Use Case Diagrams: - Student Registration Login Give Exam Student View Result Give Feedback
E-R Diagram: Total marks ename examid Exam Manage M M Result Give 1 examid Manage View 1 Result id Name studid User. Name 1 1 1 Admin Password 1 1 1 M Manage 1 Stud_id Student city 1 email Manage paperid M Manage M question Set Paper Feedback Exam no Give M Feedback Name address state
Data Dictionary: -
Table Name : registration Description : This table show information about Student. Sr. No Fields Name Data Type (Size) Constrains Field Description 1 Stud_id Int (5) Primary Key Identifies every Student. 2 fname Varchar (20) Not Null Student first name. Text. Box Not Null 3 mname Varchar (20) Not Null Student middle name. Text. Box Not Null 4 lname Varchar (20) Not Null Student last name. Textbox Not Null 5 bdate 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 Not Null Student City. Drop Down List Not Null Varchar (11) Control Name Validation Not Null
Continue…… Sr. No Fields Name Data Type (Size) 9 State 10 11 Costrains Field Description Control Name Varchar (11) Not Null Student State. Drop Not Null Down List Contact no Int (10) Student Contact no. Text. Box Not Null Email Varchar (50) Not Null Student Email. Text. Box Not Null Validation Example: Stud fname _id 1 Vijay Mname Lname Gender City Ragubhai Chaudhary Male State Contact email no vadali gujarat 97128226 vijay@gm 51 ail. com
Table Name : state_master Description : This table show information about State. Sr. No Field Name Data Type (Size) Constrains 1 stateid Int (5) Primary Key State id. 2 sname Varchar (20) Not Null Example: Stateid Sname 1 Gujarat 2 Goa Description State name. Control Name Validation Drop Down List Not Null
Table Name : city_master Description : This table show information about City. Sr. No Field Name Data Type (Size) Constrains Description 1 cityid Int (5) primary Key City id. 2 stateid Int(5) Foreign Key State id 3 cname Varchar(20 ) Not Null City name. Example: Cityid Stateid Cname 1 1 ahmedabad 2 2 gandhinagar Control Name Text Box Validation
Table Name : center_master Description : This table show information about Center. Sr. No Fields Name Data Type (Size) Constrains Field Description Control Name 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 Example: centerid 1 cname ahmedabad address Gujarat Cityid 1 Stateid 1 Validation
Table Name : exam_master Description : This table show information about exam. Sr. No Field Name Data Type(size) Constrains 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) Total Mark Of Exam. Not Null Description Control Name Example: Examid 1 2 3 4 ename Maths reasoning generalenglish generalknowledge Time duration 30 30 Total mark 120 120 Validation
Table Name : question_master Description : This table show information about Paper. Sr. No Fields Name Data Type (Size) Costrains Field Description Control Name 1 qid Int (5) Primary Key Student for question Id. 2 question Text Not Null Student Question. Text. Box 3 option 1 Varchar (20) Not Null Student question option. Radio Button 4 option 2 Varchar (20) Not Null Student question option. Radio Button 5 option 3 Varchar (20) Not Null Student question option. Radio Button 6 option 4 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. Validation
Example: qid question Option 1 Option 2 Option 3 Option 4 1 Hyper text markup langage hyper text protocal hyper text pre-proce hyper data a html full form. . . . answer examid 1 Table Name : paper Description : This table show information about paper. Sr. No Field Name Data Type(size) Constrains Description 1 Paperid Int (5) Primary Key Student paper id. 2 question Text Not Null Student Question. 3 Exam no Int (5) Not Null Student exam no. Control Name Text Box Validatio n
Example: paperid question Exam No 1 What is Php? 1 Table Name : result Description : This table show information about Paper. Sr. No Fields Name Data Type (Size) Costrains Field Description 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. Control Name Validation
Example: resultid studid examid passdate totalmark obtainmark seatno 1 1 -dec-2014 120 40 1 Table Name : session Description : This table show information about session. Sr. No Field Name Data Type(size) 1 username 2 3 Constrains Description Control Name Varchar (20) Not Null username. Text Box password Varchar (20) Not Null password. Text Box centerid Int (5) Center id. Not Null Example: Username password centerid Admin 1 Validatio n
Table Name : Admin_master Description : This table show information about admin. Data Type (Size) Costrains Field Description Control Name Sr. No Fields Name 1 Username Varchar (20) Primary Key username. Text. Box 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) Validation Foreign Key Student center id. Example: username password userlavel stud. Id center. Id Admin Visitor 1 1 Admin
Table Name : feedback Description : This table show information about feedback. Sr. No Fields Name Data Type (Size) Constrains Field Description Control Name 1 name Varchar (30) Not Null Identifies Student name. Text. Box 2 address Varchar (100) Not Null Student address. Text. Box 3 phone Varchar (10) Not Null Student phone no. Text. Box 4 city Varchar (20) Not Null Student city. Textbox 5 Postel code 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 Validation
Example: name address phone vijay vadali city state 9712822651 vadali Gujarat fax email feedback 234567 vijay@gmail. Hello friend com your site successful.
Sequence Diagram: - Admin
Sequence Diagram: - Student
Class Diagram: - 1 * Add * * 1 1 1 * Add 1 * 1 1 Add * *
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. php Description: - This Page Is Admin Home Page.
User Registration Page: Form Name: -adduser. php Description: - This Page Is student registration Page in basic information.
Add Center Page: Form Name: -addcenter. php Description: - This Page Is Add Center Page in State And City Wise.
Add Question Maths Page: - Form Name: - addquestion. php Description: - This Page Is Add Maths Question Page.
Add Question Reasoning Page: Form Name: - addquestion. php Description: - This Page Is Add Reasoning Question Page.
Add Question General English Page: Form Name: - addquestion. php Description: - This Page Is Add General English Question Page.
Add Question General Knowledge Page: Form Name: - addquestion. php Description: - This Page Is Add General Knowledge Question Page.
Edit User Page: Form Name: - edituser. php Description: - Are You Sure Add User Information.
Edit User Page: Form Name: - edituserprocess. php Description: - Edit User Information Are Easy To Modify.
Edit Center Page: Form Name: - editcenterprocess. php Description: - Admin Edit center in Particular Student.
Edit Question Maths Page: Form Name: - editprocess. php Description: - Admin Edit Question in Maths Page.
Edit Question Reasoning Page: Form Name: - editprocess. php Description: - Admin Edit Question in Reasoning Page.
Edit Question General English Page: Form Name: - editprocess. php Description: - Admin Edit Question in General English Page.
Edit Question General Knowledge Page: Form Name: - editprocess. php Description: - Admin Edit Question in General Knowledge Page.
Delete User Page: Form Name: - deleteuser. php Description: - Admin Delete User in Particuler Student.
Delete Center Page: Form Name: - deletecenter. php Description: - Admin Delete Center in Particuler Student.
Delete Question Maths Page: Form Name: - deletequestion. php Description: - Admin Delete Maths Question in Particuler Paper.
Delete Question Reasoning Page: Form Name: - deletequestion. php Description: - Admin Delete Reasoning Question in Particuler Paper.
Delete Question General English Page: Form Name: - deletequestion. php Description: - Admin Delete General English Question in Particuler Paper.
Delete Question General Knowledge Page: Form Name: - deletequestion. php Description: - Admin Delete General Knowledge Question in Particuler Paper.
View User Page: Form Name: - viewuser. php Description: - Admin Can View User in This Page.
View Center Page: Form Name: - viewcenter. php Description: - Admin Can View Center in This Page.
View Question Maths Page: Form Name: - viewquestion. php Description: - Admin Can View question in Maths Page.
View Question Reasoning Page: Form Name: - viewquestion. php Description: - Admin Can View question in Reasoning Page.
View Question General English Page: Form Name: - viewquestion. php Description: - Admin Can View question in General English Page.
View Question General Knowledge Page: Form Name: - viewquestion. php Description: - Admin Can View question in General Knowledge Page.
Generate Question Paper: Form Name: - viewallquestion. php Description: - Admin Can View all question in Generate Page.
Admin View Feedback: Form Name: - viewfeedback. php Description: - Admin Can View Feedback Page.
Student Side: - Student Registration Page: Form Name: - registration. php Description: - Student Can Registration Page in Fill Basic Information.
Student Login Page: Form Name: - index. php Description: - Student Can Login Into Username And Password.
Student Home Page: Form Name: - userexam. php Description: - Student Can Login Into Username And Password Is Correct In Home Page.
Maths Question Paper Page: Form Name: - givetest. php Description: - Student Can Maths Give Test In Page.
Maths Result Page: Form Name: - giveresult. php Description: - Student Can Maths Give Test In Declare Result Page.
General Knowledge Question Paper Page: Form Name: - givetest. php Description: - Student Can Generalknowledge Give Test Page.
General Knowledge Question Result Page: Form Name: - giveresult. php Description: - Student Can Generalknowledge Give Test In Declare Result Page.
Reasoning Question Page: Form Name: - givetest. php Description: - Student Can Reasoning Give Test Page.
Reasoning Question Result Page: Form Name: - giveresult. php Description: - Student Can Reasoning Give Test In Declare Result Page.
General English Question Page: Form Name: - givetest. php Description: - Student Can General English Give Test Page.
General English Question Result Page: Form Name: - giveresult. php Description: - Student Can General English Give Test In Declare Result Page.
Student Feedback Page: Form Name: - feedback. php Description: - Student Can Send Feedback Page.
Testing
No. Expected Result Actual Result Pass/Fail 1 Test Case Enter User. Name & Password Pass Click login button without Enter User. Name & Password username & password
No. Click on login button with username & password Expected Result Actual Result Pass/Fail 1 Test Case Login Successful Pass
No. Expected Result Actual Result Pass/Fail 1 Test Case Enter Registration Form. Pass System does not Allow Click Submit button without Registration.
No. Click Submit button with Registration And Validation. Expected Result Actual Result Pass/Fail 1 Test Case 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 Book Title Author PHP 6 and My. SQL 6 Bible Steve Suehring, Tim Converse, Joyce Park Edition 3 rd Edition Publication Bible publication Price 699 Web REFERENCE ü ü http: //www. tutorialspoint. com/php/ http: //www. w 3 schools. com/php_form_validation. asp http: //www. tutorialspoint. com/php_and_mysql. htm http: //www. google. com
Скачать презентацию Acharya Motibhai Patel Institute Of Computer Studies
3bb9ada3fe18dc28f2b68beb025d1b29.ppt