June 21, 2024 | 9:00 AM to 4:30 PM | Telengtan Hall, University of Asia and the Pacific
Eureka: Innovating Institutional Management Systems is a research colloquium that will showcase the capstone projects of successful 4th year IT students. The projects featured in this colloquium address the critical need for institutions to modernize their management systems. By integrating day-to-day operations into a digital platform, these projects offer institutions an efficient and effective way to manage their operations.
Through this colloquium, we aim to highlight the importance of innovative management systems in modern institutional practices. With the help of advanced technology, institutions can streamline their operations, increase productivity, and improve overall efficiency and effectiveness.
The research colloquium also aims to showcase the expertise and skills of our IT students in developing innovative solutions for real-world institutional challenges. By presenting their capstone projects, the students demonstrate their ability to apply theoretical knowledge in practical and meaningful ways.
9:00 AM - 12:00 PM : Morning Presentations
12:00 PM - 1:30 PM : Lunch Break
1:30 PM - 4:00 PM : Afternoon Batch Presentation
4:00 PM - 4:30 PM : Closing Remarks
Bluen Ginez, Kenneth Gaite, Jethro Jumawan
As the educational institution continues to grow with its increasing number of students since its inception, there is a need to employ more teachers so as to provide and guide their students with the education that the school guarantees. Currently, Fountain International School uses a computerized payroll system by means of Microsoft Excel. Their preparation for payroll every month is very time consuming and crucial for the accounting department as they strictly follow the policies stated in DepEd Order No. 30, series of 2011 which demand the strict observance on the minimum net pay requirement as provided by the annual General Appropriations (GAA); and in agreement with DepEd Automatic Payroll Deduction Scheme (APDS).
The proposal for FISE is to create a system which consolidates the RFID and the Payroll system for their employees. Creating this system will streamline and automate the process of the employees’ salary as well as provide the institution with an adequate and efficient database based on the records of the employees’ time in and out of the school.
The proposed system is a web platform that shall facilitate the storing, updating and securing the data containing the employees’ payroll amount and history. This platform will be accessible to both the employees and the administrators who will supervise the system. The employees will be able to view their daily salaries from any device, and the administrators can monitor the new entries in the system and intervene if an occasion arises. The data is saved automatically as employees time in and out of the RFID system.
The goal of this proposal is to gather credible and relevant information to develop a unified system that will help the institution streamline their operations. The purpose of the system is to facilitate and provide the school with the records of the employees’ time entries and automatically generate their daily wage based on their attendance. With this, the system’s efficiency is maximized as the current payroll system is operated manually by administrators and the accounting department.
Luigi Aquino, Gian dela Chica, Joseph Gonzales
With a focus on barrio San Antonio, this study underlines the critical need to create an online information system for efficient database maintenance in the barrio. In an era of rapid technological breakthroughs, the use of digital tools and platforms has become critical for successful government and community service delivery. The primary goal of this research is to ensure that the barangay's information on its citizens is both accurate and secure because the information provided will determine whether or not "ayudas" are properly given, as well as whether or not the personal information of citizens residing nearby is up to date, safe, and accurate.
The study looks into the current condition of barangay database management in San Antonio and analyzes the obstacles and limits impeding its efficacy. It also looks at the potential benefits and opportunities that come with implementing an online information system, such as improved data accuracy, accessibility, and real-time information exchange.
The study's conclusions are applicable not only to Barangay San Antonio but also to other local government organizations looking to modernize their database management procedures. The successful adoption of an online information system can lead to more informed decision-making, increased transparency, and improved community service quality. Furthermore, it can serve as a model for adopting technology in governance, ensuring that barangays are well-equipped to satisfy their people's increasing requirements in the digital age.
Keywords: Barangay Management Information System, BMIS, Citizen, Registered
Jose Hector Tarcisio P. Calilung, Alejandro Rafael R. Garcia, Tomothy Russel A. Tan
This research paper addresses the imperative need for The Coffee Estate (TCE) to modernize its inventory management system. TCE, a coffee company in the Philippines, faces challenges stemming from outdated procedures, particularly in recording transactions and managing inventory. The company's current system relies heavily on manual processes, leading to inefficiencies in data collection and synthesis, hindering effective decision-making.
The study delves into the intricacies of TCE's existing business processes, identifying key pain points such as time-consuming accounting procedures, a lack of comprehensive inventory and sales overviews, and the risks associated with overstocking and understocking. These challenges necessitate the development of an advanced Inventory Management System (IMS) tailored to the unique requirements of TCE.
The objectives of the project encompass providing accurate and timely information to management, recommending restocking activities, and streamlining recording and accounting processes. The IMS aims to integrate data from physical and online operations, offering a cohesive platform for analyzing product statistics and facilitating more informed decision-making.
While the IMS does not directly interface with accounting programs, it instead generates compatible with QuickBooks, TCE's accounting software. The system's scope includes tracking inventory levels, notifying management of restocking needs, and substantially reducing the time spent on daily accounting processes. The project's significance lies in improving stock levels, providing holistic information to management, and allowing staff to dedicate more time to customer service.
Comparisons with existing solutions reveal the uniqueness of TCE's requirements, such as the need for accounting-compatible le creation and integration with e-commerce platforms. The current implementation of the project demonstrates its effectiveness in meeting the client's needs, utilizing Spring, React, and MySQL to deliver a robust and impactful solution.
Keywords: Inventory Management System, Coffee Industry, TCE IMS, E-commerce, Business Efficiency
Juan Gabriel Gaza, Rafael Gonzales
Virginia Ramirez Cruz National High School (VRCNHS) must adhere to the Department of Education's Learner Information System (LIS) mandates for digitizing student information. However, the LIS struggles with peak user loads, rigid policy constraints, and a data scope that fails to meet the school's specific needs, leading to reliance on manual, inefficient, and costly information management processes by VRCNHS advisers. This study proposes a customized Student Information Management System tailored to the unique requirements of VRCNHS staff and students. This innovative system facilitates user registration for teachers and administrators alike, enabling the addition, modification, or deletion of user profiles and student marks with ease, thus significantly streamlining administrative tasks. Unlike a replacement, this system aims to complement and enhance the LIS by providing a comprehensive solution for efficiently managing student information, tracking student histories, and automating manual processes. The implementation of this system is poised to revolutionize how VRCNHS manages its student information, offering a model for other schools facing similar challenges.
Keywords: VRCNHS (Virginia Ramirez Cruz National High School), Learner Information System (LIS), Student Information Management System, Data management
Sherilyn N. Bamba, Charity Marie A. Moneda, Mariah Agatha P. Quilinguin
This study addresses the critical need for the Quality Management Office (QMO) of the National Center for Mental Health (NCMH) to modernize its document management system. NCMH, a government mental health hospital in the Philippines, faces challenges with outdated manual processes for QMO documents, hindering the seamless flow of information.
The research identifies key issues such as time-consuming record-keeping, a lack of comprehensive tracking mechanisms, and the risks associated with document misplacement. The project aims to develop a technology-driven Web-based Document Management System tailored to NCMH QMO's unique requirements.
The system provides an efficient means of recording and tracking documents, ensuring accountability in document movement, and digitizing the overall document management workflow. The system also integrates data from various pavilions within the institution, offering a unified platform for visualizing document flow and supporting informed decision-making.
While not interfacing with patient records, the system generates digital versions of the documents requested by users. It provides a visual representation of a document's journey through pavilions, along with the corresponding date and time of each transfer. The project's significance lies in digitizing NCMH's document operations for increased efficiency, transparency, and accountability.
After a series of User Acceptance Tests that was done with the future users of the system, it was found that the proposed document management system expanded beyond its initial scope, incorporating additional features like real-time traceability and controlled document distribution. The structure of the project also shows robustness and extensiveness to ensure the system meets the diverse needs of users within the organization. With this, the Web-based Document Management System is able to help the users to accomplish their job more efficiently, resulting in increased productivity in managing document requests and processing documents.
Keywords: Document Management System, Web-based System