Online Examination System Group members Internal guide www

Online Examination System Group members: Internal guide: www. freestudentprojects. com

Objectives �Web based application which will help in conducting the Online Examination. �Reduces the time required to give the exam and know the results. �This project will provide an efficient platform both for the students and the teachers. �Better security and transparency in the examination. �This system will work efficiently and correctly as far as computer technology is concerned. www. freestudentprojects. com

Project Scope �Online Examination system is designed for Educational Institutes (like schools, colleges, universities, training institutes). �It saves time to prepare an exam and also it saves the time check the paper and prepare mark sheets �The system handles all the operations, and it generates certificate 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. www. freestudentprojects. com

Overview �Project category: Web based application �Software requirements: Ø XAMPP Software Ø Server: Apache server Ø Database: My. SQL server Ø IDE: Adobe Dreamweaver CS 6. 0 � Languages Used: Ø Front end: PHP 5. 0 Ø Back end: My. SQL Server 5. 3 www. freestudentprojects. com

�PHP: PHP (PHP: Hypertext Preprocessor) is a widelyused open source general-purpose scripting language that is especially suited for web development and can be embedded into HTML. �My. SQL: My. SQL is a database management system. It is the most popular database system used with PHP. www. freestudentprojects. com

User Characteristics : There are 3 kinds of users in the proposed system. �Students: The student will logon to the system and take his examination. �Examiner: Examiners of each course will prepare questions and its options and load into the software. �Administrator: The administrator is the main user of the system, and he can control complete website. www. freestudentprojects. com

Project Modules: �Login Module : Ø Student login module Ø Administrator login module Ø Teachers login module Ø Forgot password module �Accounts Module : Ø Student account module Ø Teachers account module www. freestudentprojects. com

�Examination Module: Ø Examination Timetable module Ø Examination module Ø Result module Ø Certificate module �Dashboard module: Ø Subject module Ø Course module Ø Students module Ø Report module Ø Users module www. freestudentprojects. com

�Question Bank Module Ø Question paper module Ø View question paper module Ø Add question module Ø Question type module �Results module: Ø Report module Ø Result module Ø Certificate module www. freestudentprojects. com

Limitations Ø In the case of system crash exams are not taken. Ø It creates problem if internet connection is slow. Future Scope �In future we can add Web cam based examination for security purpose. �We can add more features like Quiz application, Competitive exams, etc. www. freestudentprojects. com

System Design CFD (Level 0 DFD): www. freestudentprojects. com

• Data Flow Diagram : DFD Level-1 (Top Level DFD): www. freestudentprojects. com

�DFD Level 2: Course, subject, student www. freestudentprojects. com

�DFD Level 3: Questions www. freestudentprojects. com

DFD Level 4: Examination www. freestudentprojects. com

�DFD Level 5: www. freestudentprojects. com

Database Design The database for Online Examination System is organized into 8 tables: 1) exam 2) student 3) subject 4) course 5) user 6) question 7) result 8) certificate www. freestudentprojects. com

Entity –Relationship Diagram: www. freestudentprojects. com

Detailed Design • 4. 1 INTRODUTION: � In the detailed design we will decide the internal logic for the module, which implements the given specification. � Detailed design is one of the levels of the design process for software items. Detailed design, which is also known as logic design, involves the internal design of the modules and how the specification of the module can be satisfied. Detailed design is an extension of system design. � The basic goal in detailed design is to specify the logic for the different modules that have been specified during system design. Specifying the logic will require developing an algorithm that will implement the given specifications. www. freestudentprojects. com

Database Design: A database is inherent collection of data with some inherent meaning, designed, built and populated with data for a specific purpose. The following guideline has been followed by the database design: �Descriptive names for the tables, columns and indexes. �Singular names for tables and columns. �Proper data type for each column. www. freestudentprojects. com

Certificate Column Type Null Description certificateid int(10) Primary Key Certificate ID Examid int(11) Foreign key Exam ID scoredmarks float(10, 2) No Scored Marks Result varchar(25) No Result Date No Date Status varchar(25) No Status www. freestudentprojects. com

Course Column Type Null Description courseid int(10) Primary Key Course ID coursename varchar(25) No Course Name description Text No Description Status varchar(25) No Status www. freestudentprojects. com

Exam Column Type Null Description examid int(10) Primary Key Exam ID studentid Int(10) Foreign key Student ID Regno int(10) No Register Number subjectcode varchar(25) No Subject Code datetime Datetime No Date and Time Status varchar(10) No Status www. freestudentprojects. com

Question Column Queid Type int(10) Null Primary Key Description Question ID subjectid Int(10) Foreign key Subject ID subjectcode varchar(15) No Subject Code question Text No Question uploads Text No Documents of the Question option 1 Text No First Option option 2 Text No Second Option option 3 Text No Third Option option 4 Text No Fourth Option answer int(5) No Currect Answer marks Float(10, 2) No mark description Text No Description Status varchar(25) No Status www. freestudentprojects. com

Result Column Type Null Description resultid int(10) Primary Key Result ID examid int(11) Foreign Key Exam ID Queid int(11) Foreign Key Question ID Questiontype Varchar(25) No Question Type answerid int(10) Foreign Key Answer ID answersheet Text No Answer Sheet answeruploads Varchar(100) No Answer uploads Scoredmarks Float(10, 2) No Scored marks www. freestudentprojects. com

Student Column Type Null Description studid int(10) Primary Key Student ID password varchar(25) No Student Password courseid varchar(25) Foreign Key Course ID Semester Varchar(25) No Semester Regno Int(11) No Register Number name varchar(50) No Name Studentimg Varchar(100) No Student image dob Date No Date Of Birth address Text No Address contactno varchar(20) No Contact Number Emailid Varchar(50) No Email ID createdat Date No Create Date lastlogin datetime No Last Login status varchar(25) No Status www. freestudentprojects. com

Subject Column Type Null Description studid int(10) Primary Key Student ID password varchar(25) No Student Password courseid varchar(25) Foreign Key Course ID Semester Varchar(25) No Semester Regno Int(11) No Register Number name varchar(50) No Name Studentimg Varchar(100) No Student image dob Date No Date Of Birth address Text No Address contactno varchar(20) No Contact Number Emailid Varchar(50) No Email ID createdat Date No Create Date lastlogin datetime No Last Login status varchar(25) No Status www. freestudentprojects. com

User Column Type Null Description userid int(10) Primary Key User ID courseid int(11) Foreign Key Course ID name varchar(50) No Name designation varchar(25) No Designation usertype varchar(25) No User Type username varchar(25) No User Name Emailid Varchar(50) No Email ID password varchar(25) No User Password createdat Date No Create Date lastlogin Datetime No Last Login status varchar(25) No Status www. freestudentprojects. com

Structured English �Login Form: BEGIN IF (click on login) THEN Check the username and password, if the user exists then redirect to appropriate panel ELSE Display a message “Invalid Login ID and password entered” END IF END www. freestudentprojects. com

Change password form: BEGIN IF (old password matches) THEN Change the password to new password ELSE Display a message “Old password doesn’t match” END IF END www. freestudentprojects. com

FORGOT PASSWORD: BEGIN IF (the reg no entered is correct and change password is clicked) THEN Password is sent to the students email id ELSE Password is not sent END IF END www. freestudentprojects. com

ADD STUDENTS BEGIN IF (click on submit) THEN The student details from the form are inserted into the database and success message is displayed ELSE IF(any mandatory updates) THEN The student details are updated and stored in the database ELSE Invalid entry END IF END www. freestudentprojects. com

CERTIFICATE: BEGIN IF(click on submit)THEN The certificate of the respective student is generated ELSE Invalid entry END IF END www. freestudentprojects. com

VIEW STUDENT: BEGIN IF (View students is clicked)THEN Student records are displayed END IF END LOGOUT: BEGIN IF (logout is clicked)THEN The session ends and Home page is displayed END IF END www. freestudentprojects. com

TESTING Introduction: A project is incomplete without successful testing and implementation. A program or system design is perfect only when the communication between the user and the designer is complete and clear. A successful system design helps in efficient testing and implementation. Testing is vital to the success of the system. www. freestudentprojects. com

Objective of Testing: �Testing is a process of executing a program with the intent of finding an error. �A good test case is the one that has high probability of finding an as-yet undiscovered error. �A successful case is one uncovers as yet undiscovered error. � System testing is a stage of implementation, which is aimed at ensuring that the system works accurately and efficiently as per the user needs, before the live operation commences. As stated before testing is vital to the success of the system. System testing makes a logic assumption that if all the parts of the system are correct, the goal will be successfully achieved. The candidate system is subjected to a variety of tests. A series of tests are performed before the system is ready for the user acceptance tests. www. freestudentprojects. com

Testing Techniques: Different types of testing are: �Unit Testing �Integrated Testing �Black Box Testing �Validation Testing �User Acceptance Testing www. freestudentprojects. com

1 Unit Testing: � In this testing each sub module is tested individually with test data and then integrated to the overall system. Unit testing focuses verification effort on the smallest unit of the software design in the module or component. In fund flow analysis all modules of the system are tested separately. The testing was carried out during the coding stage itself. Each module was tested and it was being developed. All the modules were correct for error and finally worked satisfactorily. Integrated Testing: � This is a systematic technique for constructing the program structure while at the same time conducting tests to uncover errors with interfacing. Data can be lost across an interface; one module can have effect on other module; sub functionality may not be achieved. The testing was done with simple data. The developed data was run successfully with the test data. The need to integrate testing is to find overall system performance. All modules are combined and tested as a whole. Here errors uncovered are corrected for next testing steps. www. freestudentprojects. com

Black Box Testing: � It focuses on the functional requirements of the software. Black Box testing attempts to find errors in the following categories: � Incorrect or missing functions � Interface error � Errors in external device access � Performance error � Initialization and termination errors � The above testing was successfully carried out for the developed system. www. freestudentprojects. com

Validation Testing: � At the accumulation of integrated testing, software is completely assembled as a package, interfacing errors have been uncovered and corrected, and final series of software tests namely validation tests are performed. Validation succeeds when the software functions in a manner that can be easily accepted by the customer. After validation tests have been conducted, one of the possible conditions is satisfied: �The functions or performance characteristics confirmed to specialization are accepted. �The deviation from specifications is uncovered and a note of what is lacking is made. �The developed system has been tested satisfactorily and is also satisfactory. It is working efficiently. www. freestudentprojects. com

� User Acceptance Testing: User acceptance testing is key factor for the success of any system. The system under consideration was tested for user acceptance constantly, by keeping the users informed of the progress and incorporated changes suggested, at the development time itself. www. freestudentprojects. com

Test Cases: Home page: SERIAL NO TEST CONDITION EXPECTED RESULT 1. When the Student clicks “Log in” The Student Login Window is displayed Successful 2. 3. 4. When the user clicks “Log in” The User displayed When the admin clicks “Log in” The Admin Login Window is displayed Successful Forgot Password Displayed Successful When the student clicks “Forgot Password” www. freestudentprojects. com Login Window is Successful Window is

Login Forms (Student , User, Admin): SERIAL NO TEST CONDITION EXPECTED RESULT 1 When the “Submit” Regno and password is checked and students main form is displayed. Successful 2 When the admin clicks “submit” 3 username and password is When the admin clicks “submit”. checked and admin’s main form is displayed Student clicks username and password is checked and user’s main form is displayed www. freestudentprojects. com Successful

Forgot Password Form: SERIAL NO 1 TEST CONDITION When the student clicks “forgot pasword” EXPECTED RESULT Login credentials are send by Email. Successful www. freestudentprojects. com

Student Form SERIAL NO TEST CONDITION EXPECTED RESULT 1 When the student clicks “Home” Student panel and exam time table is displayed. Successful 2 When the Student clicks “Student profile” Student profile is displayed. Successful 3 When the. Student clicks “Change Password” Change password window is displayed Successful 4 When the Student clicks “Print Hall Ticket” Hall ticket page is displayed Successful 5 When the Student clicks “Attend Exam” Attend Exam form is displayed. Successful View Result Form is displayed Successful 6 When the Student clicks “View Result” 7 When the Student clicks “Certificate” Certificate form is displayed Successful 8 When the Student clicks “Logout” Home page is displayed. Successful www. freestudentprojects. com

Change Password Form: TEST CONDITION EXPECTED RESULT When the Student clicks “Change password” Student record updated successfully Successful SERIAL NO 1 www. freestudentprojects. com

Print Hall. Ticket Form: SERIAL NO TEST CONDITION EXPECTED RESULT 1. When the Student clicks “Print Hall. Ticket ” The print dialog box opens Successful www. freestudentprojects. com

View Result Form: SERIAL NO TEST CONDITION EXPECTED RESULT 1. If view result The page is clicked RESULT Results Successfull is displayed www. freestudentprojects. com

View Certificate Form: SERIAL NO TEST CONDITION EXPECTED RESULT 1. I f “certificate” is clicked The Certificate page Successful is displayed www. freestudentprojects. com RESULT

User Form: SERIAL NO TEST CONDITION EXPECTED RESULT 1 When the User clicks “Account” User. Profile will be displayed Successful 2 When the User clicks “Add students” Add students page will be displayed Successful View Student page will be displayed. 3 When the User clicks “View Students” Successful 4 When the. User clicks “Schedule Exam” Add New Exam Record page will be displayed. Successful 5 When the User clicks “View Exam” The View Exam page will be displayed. Successful 6 When the User clicks “Exam Result” View Result page will be displayed. Successful 7 When the User clicks “Log out” Home page is displayed Successful www. freestudentprojects. com

Add Students Form: SERIAL NO TEST CONDITION RESULT EXPECTED RESULT 1 When the User clicks “submit” www. freestudentprojects. com The record successfully. inserted Successful

View Student Form: SERIAL NO TEST CONDITION EXPECTED RESULT 1 When the user clicks “Edit” The Add Student form in edit mode will be displayed. Successful 2 When the user clicks “Delete” Student Record successfully. Successful www. freestudentprojects. com deleted

Schedule Exam Form: SERIAL NO TEST CONDITION EXPECTED RESULT 1 When the user clicks publish new exam Exam record successfully. Successful www. freestudentprojects. com inserted

View Exam Form: SERIAL NO TEST CONDITION EXPECTED RESULT 1 When the user clicks “Edit” The Add new exam record form in edit mode will be displayed. Successful 2 When the user clicks “Delete” Exam Record deleted successfully. Successful www. freestudentprojects. com

Admin Form: SERIAL NO TEST CONDITION EXPECTED RESULT 1 When the admin clicks “Dashboard” The dashboard page is displayed Successful 2 When the admin clicks “Add Student” Add student page is displayed Successful 3 When the. Admin clicks “View student” View student page is displayed. Successful Add new exam record page is displayed. 4 When the Admin clicks “schedule exam” 5 When the admin clicks “View Exam” 6 When the admin clicks “Exam Result” Successful View exam page is displayed. Successful View Result page is displayed. www. freestudentprojects. com

7 When the admin clicks “Certificate” Successful View certificate page is displayed. 8 When the admin clicks “Add course” 9 When the admin clicks “view course” View courseform is displayed Successful 10 When the admin clicks “Add subject” Add /Edit subject page is displayed Successful 11 When the admin clicks “View subject” View subject page is displayed Successful 12 When the questions” Add/Edit questions page is displayed Successful admin clicks “Add User login form is displayed. www. freestudentprojects. com Successful

13 When the admin clicks “View question” View question page is displayed Successful 14 When the admin clicks “Add user” Add/Edit users page is displayed Successful 15 When the admin clicks “View user” View Users page is displayed Successful 16 When the admin clicks “Logout” Successful Home page is displayed www. freestudentprojects. com

Add Students Form: SERIAL NO TEST CONDITION RESULT EXPECTED RESULT 1 When the Admin clicks “submit” The record successfully. www. freestudentprojects. com inserted Successful

View Student Form: SERIAL NO TEST CONDITION EXPECTED RESULT 1 When the admin clicks “Edit” The Add Student form in edit mode will be displayed. Successful 2 When the admin clicks “Delete” Student Record deleted successfully. Successful www. freestudentprojects. com

Schedule Exam Form: SERIAL NO TEST CONDITION EXPECTED RESULT 1 When the admin clicks publish new exam Exam record inserted successfully. Successful www. freestudentprojects. com

View Exam Form: SERIAL NO TEST CONDITION EXPECTED RESULT 1 When the admin clicks “Edit” The Add new exam record form in edit mode will be displayed. Successful Exam record deleted successfully. 2 When the admin clicks “Delete” www. freestudentprojects. com Successful

View Result Form: SERIAL NO TEST CONDITION 1. When the Admin the view result page Successful. Clicks “view result” will be displayed www. freestudentprojects. com EXPECTED RESULT

Add new Course Form: SERIAL NO TEST CONDITION RESULT EXPECTED RESULT 1 When the Admin clicks “submit” The Course record inserted successfully. www. freestudentprojects. com Successful

View Course Form: SERIAL NO TEST CONDITION EXPECTED RESULT 1 When the admin clicks “Edit” The Add new course form in edit mode will be displayed. Successful 2 When the admin clicks “Delete” course record deleted successfully. Successful www. freestudentprojects. com

Add new Subject Form: SERIAL NO TEST CONDITION RESULT EXPECTED RESULT 1 When the Admin clicks “submit” The subject record inserted successfully. www. freestudentprojects. com Successful

View Subject Form: SERIAL NO TEST CONDITION EXPECTED RESULT 1 When the admin clicks “Edit” The Add/Edit subject form in edit mode will be displayed. Successful 2 When the admin clicks “Delete” Subject record deleted successfully. Successful www. freestudentprojects. com

Add Question Form: SERIAL NO TEST CONDITION RESULT EXPECTED RESULT 1 When the Admin clicks “submit” The Question record inserted successfully. www. freestudentprojects. com Successful

View Question Form: SERIAL NO TEST CONDITION EXPECTED RESULT 1 When the admin clicks “Edit” The Question form in edit mode will be displayed. Successful 2 When the admin clicks “Delete” Question record deleted successfully. Successful www. freestudentprojects. com

Add User Form: SERIAL NO TEST CONDITION RESULT EXPECTED RESULT 1 When the Admin clicks “submit” www. freestudentprojects. com The User record inserted successfully. Successful

View User Form: SERIAL NO TEST CONDITION EXPECTED RESULT 1 When the admin clicks “Edit” The User form in edit mode will be displayed. Successful 2 When the admin clicks “Delete” User record deleted successfully. Successful www. freestudentprojects. com

Validations � � www. freestudentprojects. com

Snapshots www. freestudentprojects. com

www. freestudentprojects. com

www. freestudentprojects. com

www. freestudentprojects. com

www. freestudentprojects. com

www. freestudentprojects. com

www. freestudentprojects. com

www. freestudentprojects. com

www. freestudentprojects. com

www. freestudentprojects. com

www. freestudentprojects. com

www. freestudentprojects. com

BIBLIOGRAPHY �References : �Pankaj Jalote, An Integrated Approach to Software Engineering, Third Edition, Narosa Publications �www. w 3 schools. com – PHP and My. SQL tutorials �www. php. net – PHP Official site �www. mysql. com – My. SQL Database official site www. freestudentprojects. com