DESIGN AND IMPLEMENTATION OF A SOFTWARE RESULT PROCESSING AND TRANSCRIPT GENERATION
Result processing can be seen as a continuous process of converting data (scores, grade points, credit units etc) into a definite and meaningful information (statement of result, transcripts etc). These results are used to check the performance of each student in various courses. These results when processed manually leads to many problems such as error during computation, insecurity of results, untidy results after changes must have been effected and work load on the exam officer(s) etc. However, designing and implementing, as well as the computerization of result processing and transcript generation system will reduce these problems to the barest minimum. Providing password can do this, which grants access to only authorized user(s). Corrections or changes are effected without making the work untidy. Also stress on exam officer(s) is or are reduced. The design and implementation will be developed using the structured system analysis and design methodology (SSADM). The new system was designed using Visual Basic and MS Access. This language was chosen because of its easy syntax and features for developing web applications.
Programming Language: BASIC (For Other Programming Languages Click Here)
Programming Environment: Windows XP, Windows Vista, Windows 7, Windows 8
Software Requirement: Visual Basic Studio 6.0 or Any Higher Version, MicroSoft Access
TABLE OF CONTENT
Table of content
1.2 Background of the study
1.3 Statement of the problem
1.4 Objective of the study
1.5 Significance of the study
1.6 Scope of the study
1.7 Limitations of the study
2.0 LITERATURE REVIEW
2.2 Benefits of Design
2.3 Result and Process
3.0 SYSTEM ANALYSIS AND DESIGN
3.2 Problem Identification
3.3 Feasibility Study
3.4 System Analysis
3.5 System Design
3.6 Program Coding
3.7 Program Testing
3.8 System Implementation
3.9 The Organizational Structure
3.10 Demographic Variables
3.11 Data Flow Diagram of the Present System
3.12 Information Flow
3.13 Weakness Identified
3.14 High Level Model of the Proposed System
4.2 Objectives of the New System
4.3 Main Menu
4.8 Database Specification
4.9 Course Registration
4.10 Departmental Registration
4.11 Student Result
4.11.1 Student Information Form
4.12 Input Format
4.13 Output Format
4.14 Mathematical Specifications
4.15 Overall Data Flow Diagram
4.16 Data Dictionary
4.17 Choice of Programming Language
4.18 System Documentation and Implementation
4.19 System Requirement
4.20 Hardware Requirement
4.21 Software Requirements
4.22 How To Install the Software
4.23 Training of Operators and Application Details
4.24 Training of Operators
4.25 Application Details
4.26 Implementation Detail
4.27 Direct Changeover
4.28 Phase Segmented Changeover
4.29 Parallel Changeover
4.30 Changeover Recommended
4.32 Maintenance Details
5.0 SUMMARY, CONCLUSION AND RECOMMENDATION
Appendix CHAPTER ONE
A system is a collection of inter-related and inter-connected components that work together to perform or carryout a specific task in order to accomplish a particular goal. For every system, security is a paramount issue. Due to multiple security incidents around the world and the loss of sensitive data, it has become necessary to put in place a mechanism to prevent unauthorized access into the server housing a sensitive system such as the Student Result Processing System through scripts run on the website. This project is therefore concerned with designing and implementing a Php/MySQL to serve as the security mechanism between the front-end and back-end of the already existing Student Result Processing System. The Student Result Processing System automatically handle students' activities in the Department ranging from student registration, keeping of students' files for decision making, computation and generation of students' grade points and transcripts respectively.
1.1 STATEMENT OF PROBLEM
The problems identified to be solved by this project include the following:
⦁ The safety of students records located on the server.
⦁ The location of administrator passwords in the script file easily accessible via the website.
⦁ Easy access and 4available of student transcript on demand.
1.2 PURPOSE OF STUDY
The major purpose of this study is to design and implement a secure database system to record and manage student information and their result from year one to final year.
1.3 SIGNIFICANCE OF STUDY
This project work will be of immense help in securing student details and results stored on the Student Result Processing System in the Departments of Computer Science and prevent malicious attacks and ease the delay experienced in the manual examination result processing system. Below are the advantages of this project:
⦁ Provide a security mechanism for the Students’ Result Processing System.
⦁ To ensure reliability and transparency in the creation and computation of results
⦁ It provides security mechanism to check student or staff mischievous act of changing marks or grades on the result sheet.
⦁ The system is secure from unauthorized access that can effect changes in grades of students and generation of accurate and error free student results information is assured.
⦁ The separation of the front end and the back end to ensure data stored on the server is secure.
⦁ It will ensure high level quality service development of the management which will ensure that students are not subjected to undue suffering in collection of their transcript or clearance prior to the deployment for youth service.
1.6 OBJECTIVES OF STUDY
The aims and objectives of this project work are as follows:
. To place a safety mechanism in the Student Result Processing System and separate the front end from the back end.
. It will ensure high level quality service development of the management which will ensure that students are not subjected to undue suffering in collection of their transcript or clearance prior to the deployment for youth service.
1.7 SCOPE OF STUDY
This project work will cover the entire back-end protection of the Student Result Processing System in the Departments of Computer Science, print student transcript at the completion of student academy year in the school. Process student registration and also staff registration, grant access to staff to allow them access the system.
Realizing the financial and time constraints usually associated with students in project of this nature, there is no research carried out that does not experience some difficulties. This work is no exception; the following factors posed serious limitations to the research work.
Financial constraints: a study like this nature is expected to be carried out on a broader base but because of lack of funds required, some function and programs could not be applied.
Time constraint: in the course of the study, time posed a serious problem in carrying out the test. The duration given for the conduct of this study was short.
Non-availability of materials: during the course of this research, there were non-availability of some critical documents and materials which were classified as confidential.
1.9 DEFINITION OF TERMS
The following are the terms used in the work:
1. DATA: In computing, data is a collection of observations that has been translated into a form that is more convenient to move or process for useful decision making.
2. PROCESS: This is a series of actions that occur with respect to time in order to achieve a particular result. It is a program in execution.
4. SECURITY: This is the something that provides a sense of protection against loss, attack, or harm.
5. MECHANISM: This includes the methods, procedures, or processes involved in the way something works or is done
6. DESIGN: Design is the creation of a plan or architectural blueprints that is used for the development of software’s.
7. DATABASE: This is an organized collection of data for easy retrieval and updating.
8. SCALABILITY: Scalability is the ability of a system, network, or process, to handle a growing amount of work in a capable manner or its ability to be enlarged to accommodate that growth.
9. TESTING: This can be described as a process of establishing that a software has attained a specific degree of quality with respect to user and system requirements and it is free of errors.
10. SOFTWARE: Software refers to the programs that control the hardware and produce the desired information or results.
11. BACK-END: This specifies all the actions that are done on the server and the data stored there.
12. FRONT-END: This specifies the actions carried out on the web browser of a client accessing the server..