ProjectII "ExamFlex: Exam Cell Automation System" Submittedinpartialfulfillmentoftherequirementsforthedegreeof Bachelor of Engineering by (Ansari Safiya Nizamuddin Rehana) Roll No. 12CO02 (Ansari Uruj Abdul Hadi Rukhsana) Roll No. 14DCO52 (Sayyed Tabrez Naushad Ahmed Anisa) Roll No. 14DCO63 (Sirkhot Salman Sadique Nazli) Roll No. 14DCO68 Supervisor (Prof. Tabrez Khan) Co-Supervisor (Asst. Prof. Mohammad Salman Shamsi) Department of Computer Engineering, SchoolofEngineeringandTechnology Anjuman-I-Islam’sKalsekarTechnicalCampus PlotNo. 2 3,Sector-16,NearThanaNaka,KhandaGaon, NewPanvel,NaviMumbai. 410206 AcademicYear: 2016-2017 CERTIFICATE Department of Computer Engineering, SchoolofEngineeringandTechnology, Anjuman-I-Islam’sKalsekarTechnicalCampus KhandaGaon,NewPanvel,NaviMumbai. 410206 This is to certify that the project entitled ËxamFlex: Exam Cell Automation System¨ is a bonafide work of Ansari Safiya Nizamuddin Rehana, Ansari Uruj Abdul Hadi Rukhsana, SayyedTabrezNaushadAhmedAnisa,SirkhotSalmanSadiqueNazli(RollNo.: 12CO02, 14DCO52, 14DCO63, 14DCO68) submitted to the University of Mumbai in partial fulfillment of the requirement for the award of the degree of Bachelor of Engineering in Department of ComputerEngineering. Prof. TabrezKhan Prof. JavedSheikh Supervisor ProjectCoordinator Prof. TabrezKhan Dr. AbdulRazakHonnutagi HeadofDepartment Director Project II Approval for Bachelor of Engineering ThisprojectentitledËxamFlex: ExamCellAutomationSystem¨ byAnsariSafiya NizamuddinRehana,AnsariUrujAbdulHadiRukhsana,SayyedTabrezNaushadAhmed Anisa,SirkhotSalmanSadiqueNazliisapprovedforthedegreeofBachelorofEngineering inDepartmentofComputerEngineering. Examiners 1. .............................. 2. .............................. Supervisors 1. .............................. 2. .............................. Chairman ............................. Declaration I declare that this written submission represents my ideas in my own words and where others ideasorwordshavebeenincluded,Ihaveadequatelycitedandreferencedtheoriginalsources. I also declare that I have adhered to all principles of academic honesty and integrity and have not misrepresented or fabricated or falsified any idea/data/fact/source in my submission. I un- derstandthatanyviolationoftheabovewillbecausefordisciplinaryactionbytheInstituteand can also evoke penal action from the sources which have thus not been properly cited or from whomproperpermissionhasnotbeentakenwhenneeded. AnsariSafiyaNizamuddinRehana RollNumber: 12CO02 AnsariUrujAbdulHadiRukhsana RollNumber: 14DCO52 SayyedTabrezNaushadAhmedAnisa RollNumber: 14DCO63 SirkhotSalmanSadiqueNazli RollNumber: 14DCO68 Abstract Tittle: ExamFlex-ExamCellAutomationSystem The admission or registration process of college is necessary on periodic basis in every educa- tional institution. It should be accurate and less bulky. This manual process of student registra- tion and result generation is always bulky and tedious. All these problems can be eliminated if the college system is automated. By automating this system, the examination coordinators can easilyconducttheregistrationofstudentsandthegenerationofresultssystematically. Thesys- temisanefficient,decisiveresourceforinstitutionsandstudents. Itwillhelpatdifferentlevels forbringingreliability,efficiency,scalability,transparencyandrobustsolutions. Byautomating thecollegesystem,theresultscanbedeclaredinaflexiblemannerandmostimportantlyitwill be error free and student registration, filling of online exam form, revaluation form for respec- tive subjects, filling of KT form, generation of hall tickets and respective results etc. Also the students will be able to check their marks for every practical, oral, term works, unit tests along with the final theory exam mark sheets. So an attempt has been made to make it easy for exam cellstaffaswellasthestudents. AnsariSafiyaNizamuddinRehana AnsariUrujAbdulHadiRukhsana RollNo: 12CO02 RollNo: 14DCO52 B.E.(ComputerEngineering) B.E.(ComputerEngineering) UniversityofMumbai. UniversityofMumbai. SayyedTabrezNaushadAhmedAnisa SirkhotSalmanSadiqueNazli RollNo: 14DCO63 RollNo: 14DCO68 B.E.(ComputerEngineering) B.E.(ComputerEngineering) UniversityofMumbai. UniversityofMumbai. iv Contents ProjectIIApprovalforBachelorofEngineering . . . . . . . . . . . . . . . . . . . . ii Declaration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . iii TableofContents . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . vii ListofFigures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . viii listofTables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ix KeywordsAndGlossary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . x 1 ProjectOverview 1 1.1 Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 1.1.1 Motivation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 1.2 ProblemDefinition . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 1.3 CurrentSystems . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 1.4 TheProblemswithCurrentSystem . . . . . . . . . . . . . . . . . . . . . . . . 2 1.4.1 AdvantagesOverCurrentSystem . . . . . . . . . . . . . . . . . . . . 2 1.5 GoalsandObjectives . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 1.6 ScopeandApplications . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 2 ReviewOfLiterature 4 2.1 XamClickExamCellAutomationSystembyHarshaKhutafale,HardikaMate, Vaishnavi Sabnawis, Prof. Nilesh Patil, International Journal of Advanced Re- searchinComputerScienceandSoftwareEngineering-2016 . . . . . . . . . . 4 2.1.1 Description . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 2.1.2 Drawbacks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 2.1.3 OvercomingDrawbacks . . . . . . . . . . . . . . . . . . . . . . . . . 5 2.2 Exam-CellAutomationSystem: Nevonprojects.com[2] . . . . . . . . . . . . . 6 2.2.1 Description . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 2.2.2 Drawbacks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 2.2.3 OvercomingDrawbacks . . . . . . . . . . . . . . . . . . . . . . . . . 6 2.3 AutomatedExaminationSupportSystembyBondreRutujaAvinash,DurgiVar- shaVijaykumar,MohitePradneshRajeev,ParkarVishalV,InternationalJournal ofCurrentEngineeringandTechnology-2015 . . . . . . . . . . . . . . . . . . 7 2.3.1 Description . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 2.3.2 Drawbacks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 v 2.3.3 OvercomingDrawbacks . . . . . . . . . . . . . . . . . . . . . . . . . 7 2.4 VIVA&KHUSHI . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 2.4.1 Description . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 2.4.2 Drawbacks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 2.4.3 OvercomingDrawbacks . . . . . . . . . . . . . . . . . . . . . . . . . 8 2.5 PDFMarksheetGenerator,SanketMandare,TyagrajSonawane,AmanTrivedi, K.T.V.Reddy,I.J.InformationTechnologyandComputerScience,2014 . . . 9 2.5.1 Description . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 2.5.2 Drawbacks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 2.5.3 OvercomingDrawbacks . . . . . . . . . . . . . . . . . . . . . . . . . 9 2.6 TechnologicalReview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 2.6.1 PHP . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 2.6.2 MySQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 2.6.3 Bootstrap . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 2.6.4 Dia . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 3 RequirementAnalysis 12 3.1 PlatformRequirement: . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 3.1.1 SupportiveOperatingSystems: . . . . . . . . . . . . . . . . . . . . . 12 3.2 SoftwareRequirement: . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 3.3 HardwareRequirement: . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 4 SystemDesignandArchitecture 15 4.1 SystemArchitecture . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 4.2 UsecaseDiagram . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16 4.2.1 UsecaseReport . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 4.3 EERDiagram . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 4.4 DataFlowDiagrams . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 4.4.1 Level0DFD . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 4.4.2 Level1DFD . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 4.4.3 Level2DFD . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 4.5 ComponentDiagram . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 5 Methodology 24 5.1 ExamFlex(ExamCellAutomationSystem) . . . . . . . . . . . . . . . . . . . 24 5.1.1 Module1: Login . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25 5.1.2 Module2: GenerationofExamForm . . . . . . . . . . . . . . . . . . 26 5.1.3 Module3: GenerationofResult . . . . . . . . . . . . . . . . . . . . . 27 5.1.4 Module4: GenerationofGazette . . . . . . . . . . . . . . . . . . . . 28 5.2 SequenceDiagrams . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 5.3 ActivityDiagram . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 vi 6 ImplementationDetails 32 6.1 AssumptionsAndDependencies . . . . . . . . . . . . . . . . . . . . . . . . . 32 6.1.1 Assumptions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32 6.1.2 Dependencies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32 6.2 ImplementationMethodologies . . . . . . . . . . . . . . . . . . . . . . . . . . 32 7 ResultsandAnalysis 33 7.1 TestcasesandResult . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33 7.2 AnalyticalDiscussion . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34 7.2.1 SystemOutput . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34 8 ConclusionandFutureScope 37 8.1 Conclusion . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37 8.2 Limitations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37 8.3 FutureEnhancement . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38 References 39 9 AppendixA 41 9.1 SGPI/CGPICalculation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41 9.2 MumbaiUniversityGradingSystem . . . . . . . . . . . . . . . . . . . . . . . 42 9.3 CGPIEquivalentMarks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42 Acknowledgment 43 vii List of Figures 3.1 XAMPP . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 3.2 WebBrowser . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 3.3 MySQLLogo . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 3.4 Computer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 4.1 SystemArchitecture . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 4.2 Usecase . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16 4.3 EERdiagram . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 4.4 DFDLevel0 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 4.5 DFDLevel1 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 4.6 DFDLevel2.1 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 4.7 DFDLevel2.2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22 4.8 ComponentDiagram . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 5.1 Flowchart: LoginProcess . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25 5.2 FlowchartforGenerationofExamForm/K.T.Form . . . . . . . . . . . . . . . 26 5.3 FlowchartonGenerationofResults . . . . . . . . . . . . . . . . . . . . . . . 27 5.4 FlowchartonGenerationofGazetteCopies . . . . . . . . . . . . . . . . . . . 28 5.5 SequenceDiagram1 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 5.6 SequenceDiagram2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 5.7 ActivityDiagram . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 7.1 GazetteOutput1 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34 7.2 GazetteOutput2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35 7.3 GazetteOutput3 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36 9.1 SGPAFormula . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41 9.2 CGPAFormula . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41 viii List of Tables 4.1 CGPIGradingSystem . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 9.1 LetterGradeswithrespectiveGradePoints . . . . . . . . . . . . . . . . . . . 42 9.2 CGPIGradingSystem . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42 ix
Description: