Design and Implementation of a Web Based Student Union Government SUG Accounting System

Design and Implementation of a Web Based Student Union Government (SUG) Accounting System

Project / Seminar Material
Reference ID: PS-5112-TM

DEDICATION

This research material titled “Design and Implementation of a Web Based Student Union Government (SUG) Accounting System” is dedicated to God for his enabling grace, and to all computer enthusiasts who contributed to make life a pleasant experience during my research documentation.

ACKNOWLEDGEMENT

I extend my sincere gratitude to all those who contributed to the completion of this project. Special thanks to my Supervisor (Name of your Supervisor), the Head of Department (Name of your HOD), the Lecturers in the department of Computer Science (CS), Book Authors and Profound Scholars of existing or related project material on “Design and Implementation of a Web Based Student Union Government (SUG) Accounting System” for their invaluable guidance, support, and expertise throughout the journey.

I am also grateful to your study area (mention any funding organizations, if applicable) for their financial assistance. This research would not have been possible without the encouragement and assistance of some stakeholders (mention any mentors, teachers, or colleagues). Additionally, I would like to acknowledge the understanding and patience of my family and friends during this endeavor. Your unwavering support has been a constant source of motivation. Thank you all for being part of this meaningful endeavor.

TABLE OF CONTENTS

PRELIMINARY PAGES


CHAPTER ONE

INTRODUCTION


    CHAPTER TWO

    LITERATURE REVIEW

    • 2.1 Introduction

    CHAPTER THREE

    SYSTEM ANALYSIS AND DESIGN

    • 3.1 Methodology Adopted
    • 3.1.1 Problem Identification Using SSADM
    • 3.2 Analysis of the Existing System
    • 3.2.1 Dataflow of the Existing System
    • 3.2.2 Disadvantages Of The Existing System
    • 3.2.3 Weakness of the existing System
    • 3.3 Feasibility Study
    • 3.3.1 Economic Feasibility
    • 3.3.2 Technical Feasibility
    • 3.3.3 Operational Feasibility
    • 3.4 Analysis of the Proposed System
    • 3.4.1 Data Flow Diagram of the Proposed System
    • 3.4.2 Advantages of the Proposed System
    • 3.4.3 Justification of the Proposed System
    • 3.5 Functional Requirements
    • 3.5.1 Use Case Diagram Of The Admin / User Privileges
    • 3.6 Data Requirements
    • 3.7 High Level Model of the Proposed System

    CHAPTER FOUR

    SYSTEM DESIGN AND IMPLEMENTATION

    • 4.1 Objectives of the Design
    • 4.2 Cohesion and Decomposition High level Model
    • 4.3 Control Center / Overall Dataflow Diagram
    • 4.3.1 Proposed System Operation Flowchart
    • 4.4 System Specification and Design
    • 4.4.1 Input and Output Specification
    • 4.4.2 Database Specification and Design
    • 4.4.3 Data Dictionary
    • 4.5 Choice and Justification of Programming Language
    • 4.6 Program Documentation
    • 4.7 Implementation Techniques
    • 4.7.1 System Testing
    • 4.8 Programming Module Specification
    • 4.8.1 Installation
    • 4.9 Computer Hardware Minimum Requirement
    • 4.10 Software Requirement
    • 4.11 Personnel / User Training
    • 4.12 File Maintenance Module

    CHAPTER FIVE

    SUMMARY, CONCLUSION AND RECOMMENDATION

    • 5.1 Introduction
    • 5.2 Summary
    • 5.3 Conclusion
    • 5.4 Recommendation

    REFERENCES

    APPENDIX A - “SOURCE CODE”

    APPENDIX B - “OBJECT PROGRAM”

    ABSTRACT

    Student union government is an elected body of student representatives within a university or college that manages student affairs, organizes events, and advocates for student interests. The aim of the study is to design and implement A Web Based Student Union Government (SUG) Accounting System. In achieving this aim, the following specific objectives were laid out as follows to develop an application software that will implement advanced security measures to protect sensitive financial information from unauthorized access, and create a system that provides 24/7 access to financial records from any location with an internet connection. The motivation that led to the implementation of the proposed system is there are mistakes in data entry, calculation errors, and misplacement of records which leads to inaccurate financial reporting and potential financial discrepancies. Also, the manual record-keeping and paper-based transactions obscure financial activities, making it difficult for stakeholders to monitor and verify the use of funds.

    The methodology adopted in this study is the structured system analysis and design methodology (SSADM) which is a technical approach for analyzing and designing an application or system by applying object throughout the software development process. The programming language used is HTML, CSS, JAVASCRIPT, PHP, SQL and JQUERY. The reason why web programming languages was used is because, it is platform independent and it is a web based application. The implementation of the proposed system will provide a streamlined and efficient way to manage finances, reducing the administrative burden and allowing officials to focus on other important activities. It also enhances accountability by providing clear, accessible financial records, which help in maintaining trust and credibility among the student body. The expected result is A Web Based Student Union Government (SUG) Accounting System will ensure reliability of financial data by using standardized templates and forms, minimize human errors in financial record-keeping and reporting through automated processes.


    Design and Implementation of a Web Based Student Union Government (SUG) Accounting System

    CHAPTER ONE

    1.1 Introduction

    A Web Based Student Union Government (SUG) Accounting System offers a comprehensive solution to these challenges. This system leverages modern web technologies to facilitate seamless financial management, ensuring that all transactions are recorded accurately and can be monitored in real-time. In today's digital age, the implementation of web-based systems has become integral to enhancing the efficiency and transparency of various organizational operations. A Student Union Government (SUG) is no exception, as it plays a pivotal role in managing student affairs, organizing events, and overseeing financial transactions within educational institutions.

    Traditional accounting methods often involve cumbersome paperwork and are prone to errors, inefficiencies, and a lack of real-time access to financial data. Consequently, there is a growing need for a streamlined, accessible, and reliable accounting system. Implementing a Web Based SUG Accounting System also aligns with the broader trend of digital transformation in education, where institutions are increasingly adopting digital tools to enhance administrative efficiency and student engagement. As such, this system is not just a technological upgrade but a strategic move towards modernizing student governance and financial management.

    As a prelude to other parts of this study, this chapter will discuss the background upon which this study was initiated, the statement of problems that led to this study, the Aim and Objectives of the study. Others are Significance of the study, Scope of work, Limitation of the study and Definition of technical terms.


    1.2 Background of Study

    The Student Union Government (SUG) plays a critical role in representing the interests of students, managing funds allocated for student activities, and ensuring the smooth operation of various student-centric initiatives within educational institutions. Traditionally, the accounting practices of SUGs have been manual and paper-based, often leading to inefficiencies, errors, and lack of transparency. This has sometimes resulted in mistrust among the student body regarding the management and utilization of funds. With the advent of digital technologies, there has been a significant shift towards the automation and digitization of administrative processes in educational institutions. The need for a Web Based Student Union Government (SUG) Accounting System arises from the increasing demand for efficiency, accuracy, and transparency in the management of student union finances. Such a system not only addresses the limitations of manual accounting but also aligns with the global trend of digital transformation in education.

    Every institution seeks for more efficient ways to carry out their duties. Account is a very sensitive aspect of every business organization and hence there is need for the adoption of computers to aid the computation and recording of account information. Accounting has long been an organizational function especially with the advent of non owner managers who need to update what is happening in the organization. Maintaining, preparation and presentation of accounts is crucial for effective decision making whether it is a nonprofit making organization or profit making because they have to report to the stakeholders of the organization through financial reports. However there was inefficient financial reporting due to loss of records, delay in preparation of records and its associated problems. In every organization for instance student union government, there is a system for maintaining accounts.

    A student union is an association of students in a particular place of education with stipulated rules/regulations to guide the operations of the association, purposely and primarily to protect and defend not only their interests but also the entire society. The purpose of these organizations is to represent students both within the institution and externally, including on local and national issues. Students’ unions are also responsible for providing a variety of services to students. Some of the major activities that are associated with student unions are:

    Students’ Welfare: With the aim of improving the lot of students in all areas connected directly and indirectly to their studies, the Student Union provides services such as monitoring prices of goods and services on campus, raising scholarship funds, finding jobs, improving public transportation and continually searching for discounts and benefits for students.

    Social activities: The Student Union seeks to enrich the social life of the campus by organizing activities such as parties, fairs and discounted trips for students and their friends; organizing fun trips and sports events; selling discounted tickets to concerts, plays and cultural events.

    Community Service: Student Union contribute to the community and society at large by organizing, initiating and encouraging various volunteer activities and organizations such as legal assistance to those in financial distress, blood donation drives, the collection of food, clothing and other necessities for the needy, and promoting environmental awareness on campus, by for instance encouraging recycling, among other activities.

    Responsible student union leadership is expected to:

    • Represent the interests of all it membership at local, regional, national and international levels.
    • Be accountable to its membership.
    • Operate efficient, high quality services and activities.
    • Promote constructive relations between students and the wider community.
    • Act professionally and responsibly to all external bodies.
    • Anticipate and respond to student needs and demands to ensure continuous improvement.

    Several studies have highlighted the benefits of implementing web-based accounting systems. These systems offer real-time access to financial data, reduce the likelihood of human error, and enhance the overall efficiency of financial management processes (Khurana & Mittal, 2021). Moreover, the integration of web-based accounting systems within SUG operations is reflective of the broader push towards e-governance in educational institutions. E-governance aims to leverage information and communication technologies to improve the delivery of services, increase participation, and make governance more transparent (Bhatnagar, 2004). For student unions, adopting such technologies is crucial in building trust with the student body and ensuring that funds are managed responsibly.

    In addition to improving financial management, a web-based SUG accounting system can also facilitate better decision-making. With access to real-time financial reports and analytics, SUG officials can make informed decisions regarding budget allocations, event planning, and resource management. This not only enhances the effectiveness of the student union but also ensures that resources are utilized in the best interest of the student community.


    1.3 Statement of Problem

    Investigation revealed that many institutions of student union government have long been accustomed to the use of manual methods for processing and presenting account information and it is common place for errors to occur making the accountants to repeat the process again. In addition, it is extremely time consuming to manually record and compute account information, the consequence of this is inefficiency as valuable time that could have been used for other problems is expended on preparing account information report. It is in view of this situation that this research study is carried out to develop an account system for student union government.

    Specifically, the implementation of a Web-Based Student Union Government (SUG) Accounting System addresses several critical problems inherent in traditional, manual accounting systems. Here are the key issues that such a system aims to solve:

    1. Lack of Transparency: Traditional accounting systems often suffer from a lack of transparency. Manual record-keeping and paper-based transactions can obscure financial activities, making it difficult for stakeholders to monitor and verify the use of funds.
    2. Inefficiency and Time Consumption: Manual accounting processes are time-consuming and labor-intensive. Generating financial reports, processing transactions, and managing budgets manually can lead to significant delays and inefficiencies.
    3. Human Errors and Inaccuracies: Human errors are common in manual accounting systems. Mistakes in data entry, calculation errors, and misplacement of records can lead to inaccurate financial reporting and potential financial discrepancies.
    4. Limited Accessibility: Traditional accounting records are often only accessible at specific locations and times, limiting the ability of stakeholders to access information when needed. This can hinder decision-making and accountability.
    5. Security and Data Loss: Physical records are vulnerable to damage, loss, or theft. Additionally, manual systems may lack adequate security measures to protect sensitive financial information.
    6. Difficulty in Financial Reporting and Analysis: Manual systems make it challenging to generate comprehensive financial reports and conduct in-depth financial analysis. This can hinder the ability of the student union government to make informed financial decisions.

    1.4 Aim and Objectives of the Study

    The aim of the study is to design and implement a web based student union government (SUG) accounting system. In achieving this aim, the following specific objectives were laid out as follows to develop an application software that will:

    1. Implement advanced security measures to protect sensitive financial information from unauthorized access;
    2. Create a system that provides 24/7 access to financial records from any location with an internet connection;
    3. Minimize human errors in financial record-keeping and reporting through automated processes;
    4. Ensure consistency and reliability of financial data by using standardized templates and forms; and
    5. Facilitate easy access to student union government financial information for authorized users, enabling better decision-making and accountability.

    1.5 Significance of Study

    The development and implementation of a Web-Based Student Union Government (SUG) Accounting System carry significant benefits for various stakeholders, each of whom plays a crucial role in the functioning and oversight of the student union’s financial activities.

    1. For Student Union Officials: This system provides a streamlined and efficient way to manage finances, reducing the administrative burden and allowing officials to focus on other important activities. It also enhances accountability by providing clear, accessible financial records, which help in maintaining trust and credibility among the student body.
    2. For the Student Body: Transparency in financial matters is significantly increased, allowing students to see exactly how their fees and funds are being used. This transparency fosters a sense of trust and engagement, as students can hold their representatives accountable for financial decisions and expenditures.
    3. For University Administration: A web-based accounting system simplifies the monitoring and auditing of the student union's financial activities. It provides the administration with real-time access to financial data, making it easier to oversee the proper use of funds and ensure compliance with university policies and regulations.
    4. For Auditors and Financial Oversight Bodies: The system provides comprehensive and easily accessible financial records, facilitating thorough audits and reviews. The accuracy and consistency of the data also reduce the likelihood of errors and discrepancies, making the auditing process more efficient and reliable.
    5. For Future Researchers and Developers: Implementing such a system creates a valuable case study for future research into the benefits and challenges of web-based financial management systems in educational institutions. It can also serve as a model for developing similar systems in other organizations, contributing to the broader field of financial management and information systems.

    1.6 Scope of the Study

    The scope of this research is focused on the Design and Implementation of a Web Based Student Union Government (SUG) Accounting System using Akwa Ibom State polytechnic Student Union Government as a case study.


    1.7 Limitations of the Study

    During the course of this study, many things militated against its completion, some of which are:

    1. Time Constraint: The time frame given to accomplish this project was very short due to school academic calendar and it was carried out under pressure which made the researcher not to implement some necessary features.
    2. Financial Constraint: Insufficient fund tends to impede the efficiency of the researcher in sourcing for the relevant materials, literature or information and in the process of data collection (internet).

    1.8 Definition of Terms

    Web-Based System:

    It is a software application that is accessed and operated over the internet using a web browser. Web-based systems allow users to interact with software hosted on a remote server, providing accessibility from any location with internet connectivity (Laudon & Laudon, 2020).

    Student Union Government (SUG):

    The elected body of student representatives within a university or college that manages student affairs, organizes events, and advocates for student interests. The SUG often handles significant financial transactions related to these activities (Nwadike, 2018).

    Accounting System:

    It is a structured process of recording, classifying, summarizing, and reporting financial transactions. It is designed to provide insights into the financial position and performance of an organization (Horngren, Harrison, & Oliver, 2017).

    Transparency:

    It is the quality of being open and accessible about financial activities, ensuring that stakeholders can see and understand how funds are being managed and spent. Transparency is crucial for building trust and accountability in financial management (Bushman, Piotroski, & Smith, 2004).

    Efficiency:

    The ability to accomplish a task with the least amount of wasted time and resources. in the context of an accounting system, efficiency refers to streamlined processes that reduce manual effort and improve overall productivity (Drucker, 2007).

    CHAPTER TWO

    2.0 Literature Review

    2.1 Introduction

    This chapter focuses on the review of related literature. A literature review includes the current knowledge as well as theoretical and methodological contributions to a particular topic. It documents the state of the art with respect to the topic you are writing. It surveys the literature in the topic selected. In this research work the literature review includes the …

    Summary Headlines for Design and Implementation of a Web Based Student Union Government (SUG) Accounting System