Скачать презентацию Acharya Motibhai Patel Institute Of Computer Studies Скачать презентацию Acharya Motibhai Patel Institute Of Computer Studies

3bb9ada3fe18dc28f2b68beb025d1b29.ppt

  • Количество слайдов: 83

Acharya Motibhai Patel Institute Of Computer Studies , Ganpat University, Kherva-384012 Online Examination System 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 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 Requirement Specification

Existing System ü In existing system every student have to fill the exam form 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 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 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 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 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 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 Activity Diagram: - Admin

Student: - Student: -

Use Case Diagrams: - Admin Login Manage User Profile Manage Set Paper Admin Manage 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 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 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: - Data Dictionary: -

Table Name : registration Description : This table show information about Student. Sr. No 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 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 [email protected] 51 ail. com

Table Name : state_master Description : This table show information about State. Sr. No 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 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 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 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 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 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 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 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 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 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 Example: name address phone vijay vadali city state 9712822651 vadali Gujarat fax email feedback 234567 [email protected] Hello friend com your site successful.

Sequence Diagram: - Admin Sequence Diagram: - Admin

Sequence Diagram: - Student Sequence Diagram: - Student

Class Diagram: - 1 * Add * * 1 1 1 * Add 1 Class Diagram: - 1 * Add * * 1 1 1 * Add 1 * 1 1 Add * *

Collaboration Diagram: - Admin Collaboration Diagram: - Admin

Collaboration Diagram: - Student Collaboration Diagram: - Student

Input Output Design: - Input Output Design: -

 Admin Side: - Admin Login Page: Form Name: -index. php Description: - This 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Admin View Feedback: Form Name: - viewfeedback. php Description: - Admin Can View Feedback Page.

 Student Side: - Student Registration Page: Form Name: - registration. php Description: - 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 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 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 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 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 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 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 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 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 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 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 Student Feedback Page: Form Name: - feedback. php Description: - Student Can Send Feedback Page.

Testing Testing

No. Expected Result Actual Result Pass/Fail 1 Test Case Enter User. Name & Password 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 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 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 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. 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 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