DESIGN AND IMPLEMENTATION OF AN ONLINE RESULT CHECKER ABSTRACT: In Nigerian Universities a lot of time is spent by students, faculty and lecturers in effecting result processes.This project focuses on solving the problem by developing an application to solve the problem inherent to the delivery of examination information services in Nigerian universities using the University of Calabar as a case study. The MyResult Application is a web-based application intended to be accessible from the internet. This allows the application to be available to both mobile phone users and PC users who can access the internet from their devices. The MyResult system was developed using open source web technologies notably HTML, PHP and MySQL. The MyResult system produced in this research work has functions that will enable students to check course results, view computed GPAs and log complaints with maximum ease.The developed application was tested using the XAMP application suite and the test results show that the application works as expected.TABLE OF CONTENTSTitle Page i Certification ii Dedication iii Acknowledgements iv Table of Contents vList of Figures xList of Tables xi Abstract xii Chapter 1: General Introduction 11.1 Introduction 11.2 Problem Definition 21.3 Objective of Study 31.4 Research Justification 31.5 Research Methodology 41.6 Scope and Limitation of Study 51.7 Definition of Terms 61.8 Chapter Layout 8Chapter 2: Literature Review and State-of-the-Art 92.1 Introduction 92.2 The internet 102.2.1 Rich internet applications 102.2.2. Adobe integrated Runtime 122.3 Mobile applications platforms today 122.3.1 The Mobile Web 132.3.2 Rich Mobile Applications 184.108.40.206 Symbian 220.127.116.11 Android 18.104.22.168 Apple Ios 162.4 Review of related Research 182.4.1 Proposed Contribution 20 Chapter 3: System Design 223.1 Introduction 223.2 System Requirement Specifications 233.3 System Design 253.3.1 Logical Design 222.214.171.124 Input Design 2126.96.36.199 Output Design 2188.8.131.52 Menu Design 3184.108.40.206 Use Cases 3220.127.116.11 Activity Diagram 318.104.22.168 Class Diagram 393.3.2 Physical Design 422.214.171.124 Program Specifications 4126.96.36.199 System Controls 4188.8.131.52 Layout of files 4184.108.40.206 Database Structure 51 Chapter 4: System Implementation 524.1 Introduction 524.2 Features and Choice of Implementation Language 524.3 System Testing Strategies 544.3.1 Unit Test 544.3.2 Integration Test 574.3.3 Alpha Test 584.3.4 Beta Test 584.4 Target Computer System Requirements 594.5 Software Maintenance Issues 614.5.1 Corrective Maintenance 614.5.2 Preventive Maintenance 624.5.3 Adaptive Maintenance 63Chapter 5: Summary, Conclusions & Recommendations 645.1 Summary of the Study 645.2 Application of the software to the problem domain 645.3 Recommendations 655.4 Conclusions 675.5 future researches 67References 68Appendix A: Detailed Program Code 68Appendix B: Program Screen Capture 127LIST OF FIGURESFigure 3.1: Student registration Screen. 29Figure 3.2: Student LOGIN Screen. 29Figure 3.3: View Results (Grades) Screen. 30Figure 3.4: View Results (GPA) Screen. 30Figure 3.5: Make compliant screen. 31Figure 3.6: Course Score Input Screen. 32Figure 3.7: View Student Complaints Screen. 33Figure 3.8: Use Case Model for the MyResults online results checker application system. 36Figure 3.9: Activity diagram for the MyResults examination results checker. 38Figure 3.10: Class Diagram illustrating the MyResults system. 40Figure 3.11:Section of the pseudo code underlying the MyResults application. 45Figure 3.12 Database structure. 51Figure B1: Student Login Screen. 127Figure B2: Student Registration Screen. 128Figure B3: Student Home Screen 128Figure B4: View Grades Screen 129Figure B5: View GPA Screen 129Figure B6: Log Complain Screen 130Figure B7: Admin Home Screen 130Figure B8: Record Score (Student Selection) Screen 131Figure B9: Record Score (Data Input) Screen 131Figure B10: View Student Complains Screen 132Figure B11: View Registered Students Screen 132 LIST OF TABLESTable 3.1:Help Ticket status description for the MyResults examination results information system. 25 Table 3.2: Input functions identified within the proposed MyResults system. 28Table 3.3: Layout of students table. 47Table 3.4 Layout of student course table. 48Table 3.5Layout of courses table. 49Table 3.6Layout of school session table. 50Table 3.7Layout of complaint table. 50CHAPTER ONEGENERAL INTRODUCTION1.1 IntroductionIt seems quite a safe bet to assert that the Internet and mobile Communication have had a preponderant influence on the way the world relates today. On the other hand, education remains a sine qua non fact of life for the overwhelming majority of human society In Nigeria; the educational sector has experienced marked changes as a result of the introduction of internet-based services. In one case, results for the UTME (Universities Tertiary Matriculation Examination) are now processed and released within days of the examination being written, an ever-increasing number of universities are employing the Internet to deliver a widening range of information and support services, covering such areas as admissions, student registration, examination records, and distance learning.This work is an attempt at delivering an online system capable of delivering examination results on demand, using the University of Calabar as case study. This application will also provide capability to assist students, lecturers and administrative personnel interact in resolving any result-related complaints.This chapter introduces the work as an entity, discussing the issues which are fundamental to the work ab initio:a. The problem scenarios which, prima facie, lend necessity to the work;b. The modalities pertaining to the realization of the solution system;c. The content and extent to which the work will be carried out;d. Definitions of key terms relevant to the central theme of the work.1.2 Problem DefinitionThe major problems regarding the delivery of examination information services in Nigerian universities include:a. Delays in the release of results;b. Errors inherent in handling and assessment of answer scripts;c. Delays in marking answer scripts; andd. Cumbersome response systems – where they exist – for handling result-related complaints.1.3 Objective Of StudyFrom the foregoing, the objectives of the study become quite clear – as a result, the study aims to achieve the following:a. Conceptual design for a secure, accessible and user-friendly online examination results system for a university, using the University of Calabar, UNICAL, as case study;b. Development of such a system to demonstrate its functionality, using the XAMP (cross-browser Apache/MySQL/PHP) web server framework;c. Perform tests on the said system to assure functionality, accessibility and usability of the system.1.4 Research JustificationJustification for engaging in this study can be drawn from the following reasons:a. The need to demonstrate the effectiveness of employing mobiledriven information systems as a viable complement to systems based on the regular Web, within the university information framework; andb. The need to achieve a greater degree of responsiveness among stakeholders in the results system – students, lecturers and system administrators – enabling them collaborate effectively to resolve result-related complaints.1.5 Research MethodologyIn order to realize the objectives of this study, it is pertinent that, as in all matters of substance, strategy be employed in achieving set goals. The methodology employed in the course of this study is outlined thus:a. Outline a set of requirements to be met by the system proposed;b. Conceive and implement the design of the said system as a webbased application, largely using UML, the Unified Modelling Language, along the lines of an object-oriented approach;c. Development of the solution system using Adobe Dreamweaver CS5, a RAD (Rapid Application Development) IDE for creating Websites and applications.d. Deployment of the solution system for testing: after the solution is developed, it will be uploaded onto a free web server for the purposes of demonstrating its functionality.e. Beta testing on the hosted solution to confirm its conformity to the system requirement specifications earlier outlined;f. Detailed reporting of the findings stated above, with deduced inferences, and noted grounds for future innovation.1.6 Scope And Limitations Of The StudyIn the course of realizing this project, I shall take into account the consideration that all development and analysis regarding the project will becentered on internet standards and technology.In full, the scope of the work is outlined thus:a. The solution, as conceived and developed in this study, will focus on examinations for undergraduate courses only;b. The questions delivered by the solution will be of two formats, viz, multiple-choice and subjective;c. As conceived, the solution shall comprise of the following modules: i. A result search application for students, based on the Internet, through which students and lecturers can search and view results, as well as interact regarding result-related complaints;ii. A back-end application, to be used by lecturers and administrators, for the management of essential information for the system, such as course allocations, course student listsiii. User authentication modules, which will employ unique modes of authentication to uniquely identify users, and maintain user state within the application.In addition, a number of limitations exist which must be noted. These include:a. The proprietary nature of the school portal will make it rather difficult to access the data schema used by it; hence, the data schemas employed by the proposed system will for the most part be theoretical in nature. However, this can be surmounted with adequate cooperation from relevant agencies within the University Management;b. The time-critical nature of the study informs my use of prototype-based RAD to develop the proposed solution.1.7 Definition Of Termsa. Beta testing: Testing carried out on software independent of its manufacturer by external users.b. Internet application: A Web site with dynamic, i.e. data-source oriented user-specific, content, which usually requires some form of user authentication.c. Mobile device: Any device with the functionality for information management and transfer free from spatial and temporal constraints. Such devices include mobile phones, smart phones, PDAs (personal digital assistants), tablets and readers, amongOthers.d. Mobile Web: The Internet, as accessible to mobile devices and computer systeme. RAD: rapid application development, a style of programming in which emphasis is placed on speed and delivery, usually employing extensive use of IDE (integrated development environment) capability.f. UML: Unified Modeling Language, the international standard for specifying, visualizing, constructing and documenting the artifacts of software systems.g. User authentication: the process within the context of an Internet application wherein eligible users are granted clearance to enter – and use – the application;h. User state: the full set of all user-specific program data within a program or Internet application.i. online result system:It is web based software, that can process course registration and output results to the user.j. Web application: see Internet application.1.8 Chapter LayoutThe work contains a total of five chapters: the first, titled “General Introduction”, true to form, expatiates on the introductory concepts underpinning this study. Chapter 2, “Literature Review and State of the Art”, offers an exposition into the research which has been carried out prior to the present time. Chapter 3, “System Design Methodology”, deals with the analysis workflow of the solution development process, while Chapter 4, “System Implementation”, focuses on the implementation workflow, discussing details of the implemented system, in relation tothe processes employed in its realization. In conclusion, the final chapter, “Recommendations & Conclusion”, Ireprise a brief synopsis of the work in its entirety as sequel to my inferences from the system implementation phase, in relation tothose areas where innovations in this field can be made..