Publication Search

This study addresses the inefficiencies in the manual student payment administration system currently used at SMK Bina Insan Nusantara, which relies on handwritten ledgers and Microsoft Excel spreadsheets, leading to frequent data errors, delayed reporting, and difficulties in retrieving payment records. The research aims to design a web-based information system to streamline the recording, monitoring, and reporting of student payments. A descriptive research approach was employed, with data collected through direct observation, semi-structured interviews with administrative staff, and literature review. System analysis was conducted using the PIECES framework, and system design followed the Unified Modeling Language (UML) methodology. The proposed system features user authentication, student data management, real-time payment input, digital receipt generation, and automated reporting (daily, monthly, and yearly). Black-box testing confirmed that the system functions as intended, validating inputs, processing transactions accurately, and generating reliable outputs. Findings indicate that the web-based system significantly improves data accuracy, operational efficiency, accessibility, and service quality compared to the existing manual process. The implementation of this system enables school administrators to manage payments more effectively, provides students and parents with timely access to payment information, and supports faster, data-driven decision-making by school leadership and the foundation. Future enhancements could include mobile integration and online payment gateways.

PT Intelix, a technology and information company with numerous collaborative projects, faces challenges in effective project management and monitoring. Despite utilizing project management applications like Jira, the generation of final reports often remains a manual process using Microsoft Excel, which is time-consuming and prone to errors. To address these issues, PT Intelix developed an internal Project Management application, yet it required further enhancements in its dashboard and reporting features for more detailed project monitoring optimization. This research aims to develop the Dashboard menu by adding a priority project table and several sub-menus in the Report menu to accelerate and simplify the preparation of final project reports. The development methodology employed is Agile Kanban, encompassing planning, system and interface design, incremental development and implementation, and testing. System functionality testing was conducted using Black Box Testing and User Acceptance Test (UAT) involving the project owner and end-users from PT Intelix. Test results showed all main functions running smoothly and stably, with all black box scenarios passing. UAT testing on six menus received a "very good" response from the project owner and users. The SUS evaluation of three users scored a 5 on the scale, with several scoring a 4, indicating a good system. Performance testing with 10 simultaneous users also demonstrated stable traffic and no errors.. The development of High Priority Project, Milestone Project, and Implementation Project features on the Dashboard successfully presented more detailed project information, while the addition of sub-menus in the Report accelerated report generation. Thus, this development successfully optimized integrated project monitoring and reporting at PT Intelix, reducing manual effort and enhancing data accuracy for decision-making.

This research animed to analyze the cash sales accounting information system at PT Garam Pintar Asia.The research method employed was descripitive qualitative since the data collected consisted of statements obtained by the resear cher. The data collection techniques used in this study were interviews, observations, and documentation.The sources of data consistend of both primary and secondary data. The result of this study indicated that the cash sales accounting information system implemented by PT Garam Pintar Asia was still not effective. This was evident in the absence of a clear separation of duties for functions related to cash sales, with the cashier concurrently handling cash and accounting functions. The documentation employed within the cash sales accounting information system did not conform to established accounting standards, as the company had yet to implement formal cash sales invoices and cash register receipts, relying instead on simple handwritten notes as evidence of payment. Furthermore, the company had not designed a cash sales flowchart and did not yet have a financial application to manage cash sales transactions.Instead, Microsoft Excel was used merely to record cash sales transactions, proofs of transactions, and sales reports.

The rapid development of technology has greatly assisted human work in various fields, including education. One tangible outcome of technological progress is the availability of Microsoft Office applications, which consist of Microsoft Word, Microsoft Excel, and Microsoft PowerPoint. Microsoft Word functions as a word processing software that allows users to create, edit, and format documents, while Microsoft Excel is used for managing numbers and data, and PowerPoint plays an important role in preparing engaging presentations. However, the teachers at SD Masehi Kadu Eta are not yet able to operate Microsoft Word, Excel, and PowerPoint optimally, as the school has never conducted any specific training. Therefore, this community service program focused on providing training on how to utilize Microsoft Office for teachers at SD Masehi Kadu Eta. The training aimed to improve teachers’ knowledge and skills in using information technology, particularly in operating Microsoft Word, Excel, and PowerPoint. Through this program, teachers gained not only new experiences but also basic skills that can support their daily tasks, such as preparing school administration documents, creating reports, and developing more systematic teaching materials. The results of the program showed that the training provided significant benefits. Teachers demonstrated strong enthusiasm, actively participated in every session, and showed improvement in their understanding of Microsoft Office applications. They also expressed their expectations for similar activities to be carried out regularly so that their skills could continue to improve and better equip them to face the ongoing development of information and communication technology in the future.

This community service program was designed to enhance the inventory management skills of santri at Pesantren Assyifa through the use of spreadsheet technology. Many pesantren-based business units still rely on manual inventory methods, leading to inefficiencies, stock errors, and operational delays. To address this issue, a structured training program was conducted involving 25 selected santri actively engaged in the pesantren’s economic units. The program consisted of three interactive sessions covering basic inventory concepts, spreadsheet functions, and hands-on design of inventory tracking systems. Using tools like Microsoft Excel and Google Sheets, participants were guided to create real-time stock records, calculate inventory movement, and generate reports. The success of the training was measured through pre- and post-tests, spreadsheet project submissions, and participant feedback surveys. The results showed a 68% average increase in test scores, a 96% project completion rate, and a 4.6/5 satisfaction score. Additionally, 84% of participants applied the system directly within pesantren business units. Feedback from participants indicated high engagement, practical usefulness, and a strong desire for follow-up training. This initiative demonstrated the effectiveness of integrating digital tools into pesantren education, contributing to the development of digitally literate and economically empowered santri.