Abstract:Course timetable preparation in the Information Technology Study Program at Universitas PGRI Sumatera Barat is still performed in spreadsheets, typically requires three to five days, and can produce instructor, class, or…
room conflicts. This study develops a web-based scheduling information system that centralizes timetable data, detects collisions automatically, and offers alternatives with support from the Google Gemini API. Development followed the Waterfall System Development Life Cycle, comprising requirements analysis, design, implementation, testing, deployment, and maintenance. The application was built with PHP, Laravel, and MySQL. A deterministic rule identifies overlapping allocations involving the same instructor, class, or room on the same day. Gemini is used only to rank and explain feasible candidates; the application revalidates each recommendation, and the Study Program Secretary retains final approval. Black-box testing of ten functions achieved a 100% success rate. Beta testing produced an average score of 89.22% from three experts and 89.79% from two users, with both results classified as Very Good. The findings indicate that the system is highly feasible for integrated course timetable preparation and administration.
Abstract:The development of information technology has significantly influenced information management and dissemination, including in road infrastructure. However, road condition data collection in Muara Bulian is still conducted…
d manually, resulting in ineffective data management and limited public access to accurate information. This study aims to design and develop a web-based Geographic Information System (Web-GIS) for road conditions in Muara Bulian. The study employed a descriptive qualitative method using observation, interviews, documentation, and literature review for data collection. The system was developed using the Waterfall model, consisting of requirements analysis, system design, implementation, and testing. The application was developed using Python and the Flask framework, with SQLite as the database and Leaflet.js and QGIS to support interactive map visualization. The results show that the system can display road condition information through interactive digital maps, provide road location search and detailed information, support basemap switching, facilitate road data management, and generate reports. Black Box Testing confirmed that all system functions operated according to the specified requirements. The Web-GIS is expected to support the government in managing road infrastructure data and facilitate public access to road condition information effectively and efficiently.
Abstract:The rapid growth of electronic transactions necessitates systems capable of monitoring seller quality and reputation across marketplace platforms. This study aims to design and implement a seller referral system on a Laravel…
avel 13 based e-commerce platform integrated with performance monitoring and seller accountability mechanisms. Built using the Prototype model encompassing communication, planning, modeling, prototyping, and deployment phases the system utilizes MySQL for database management. Registered sellers can distribute unique referral codes to prospective sellers, with the system automatically recording these relationships to enable structured tracking of activities, product counts, store ratings, and access status of referred sellers. Functional testing conducted via a black-box approach demonstrated that the authentication, referral registration, dashboard, monitoring, order management, and store settings modules operated strictly according to specifications, achieving a 100% test case pass rate. The primary contribution of this research lies in shifting the referral paradigm from simple user acquisition to a peer-accountability framework that holds referring sellers responsible for the performance of their recruits, thereby mitigating the presence of unreliable sellers and fostering greater trust in the online shopping environment.
Abstract:The implementation of examinations at SMA Negeri 7 Sarolangun previously encountered operational challenges due to an unintegrated workflow, where exam authoring was conducted via Google Forms and exam delivery relied on…
an Android-based third-party application paired with a custom keyboard. This workflow caused severe device incompatibility, system crashes, and manual score recapitulation delays lasting up to one week. This research aims to design and develop an integrated web-based examination application utilizing the Django framework under the Rapid Application Development (RAD) model to support Midterm (PTS) and Final (PAS) semester exams. The application features master data management, manual question authoring and bulk imports via Excel, token-protected scheduling, asynchronous AJAX auto-saving on computer-based test (CBT) sheets, live proctoring controls, auto-grading, score visibility authorization (Hide Score), and dynamic class-filtered report exports in Excel and PDF formats. System evaluation was conducted through Alpha testing (White Box and Black Box testing) and Beta testing (ISO/IEC 25010:2011 quality evaluation by system experts and End-User Computing Satisfaction/EUCS by end-users). Alpha testing verified that all 29 independent logic paths in White Box testing executed without branching errors and Black Box testing achieved 100% validity across 13 functional modules. Beta testing with 2 system experts yielded an average score of 98.25% (Very Good), and end-user testing involving 27 respondents achieved an average satisfaction score of 84.75% (Very Good). Thus, the developed system is highly feasible, reliable, and effective for school examination operations.
Abstract:The attendance system at SMK Negeri 1 Talamau has so far been focused mainly on teachers and relies on a fingerprint method that frequently experiences problems such as reading failures, system errors, and delayed data synchronization.…
ynchronization. This research aims to develop a QR Code-based online attendance mobile application that can be used by both teachers and students in real time. The research method used is Research and Development (R&D) with the Waterfall software development model, covering the stages of requirements analysis, design, implementation, testing, deployment, and maintenance. The application was developed using WebApp as the mobile platform, Laravel as the backend, and MySQL as the database. The student attendance process is carried out by scanning a QR Code displayed by the teacher, after which attendance data is automatically stored in the database via a REST API. System testing was conducted through alpha testing (white box and black box) as well as beta testing involving experts and end users. The test results show that all primary system functions run according to the design. Beta testing with experts obtained an average score of 86%, categorized as very good, while beta testing with users obtained an average score of 96%, also categorized as very good. The developed application is considered feasible for use and able to improve the effectiveness and efficiency of the attendance process at the school.
Abstract:Advances in information technology have driven digital transformation across many sectors, including education. One administrative service that is still largely handled conventionally is the announcement of student graduation…
ation results and the distribution of Graduation Certificates (Surat Keterangan Lulus/SKL), which makes the delivery of information relatively inefficient. This study aims to build a web-based Student Graduation Information System for vocational high schools (SMK) that simplifies graduation-data management for school administrators and gives students online access to their graduation information. The system was built using the Waterfall method, covering requirements analysis, design, implementation, testing, and maintenance, and was implemented with the Laravel framework, the PHP programming language, a MySQL database, and a Bootstrap interface. It serves two types of users: administrators, who manage graduation data, and students, who can check their graduation status without logging in by entering their National Student Identification Number (NISN). Students who pass can download their SKL directly in PDF format. The system was evaluated through Black Box Testing and the System Usability Scale (SUS). Testing showed that every system function operated as intended, while the usability evaluation returned an average SUS score of 84.5, placing it in the Excellent (Grade A) category. Overall, the system improves the efficiency of school administration, speeds up the delivery of graduation information, and supports the broader digitalization of educational services.
Abstract:Drug abuse is a problem that can be influenced by various interrelated factors. This study aims to apply Mamdani Fuzzy logic in predicting the level of drug abuse in Padang City based on several factors obtained from documentation…
umentation and interviews. The input variables used consist of the Age of the Perpetrator, Environment, Socializing, Gender, and Family, while the output variable is the Level of Drug Abuse with Low and High categories. The research stages include data collection, determining variables and fuzzy sets, fuzzification, forming if-then rules, inference using the minimum operator, composition using the maximum operator, and defuzzification using the centroid method. A total of 64 fuzzy rules are used to connect the combination of input variables with the output. Testing is done through manual calculations and implementation using MATLAB. The test results show that the output categories from manual calculations and MATLAB are the same in three test data, namely High, High, and Low. These results indicate that the Mamdani Fuzzy method can be used in modeling the level of drug abuse based on the variables used.
Abstract:Student grade data is personal data that must be protected under Indonesian Law Number 27 of 2022 on Personal Data Protection, yet the rising number of data breaches in the education sector shows that such protection has…
not been optimally implemented. This study implements the 128-bit Advanced Encryption Standard (AES) algorithm combined with Huffman compression to protect the confidentiality and integrity of student grade files in Excel (.xlsx) format, and evaluates its effectiveness through functional, performance, and security testing. The system was developed as a Python desktop application with a CustomTkinter interface, in which the encryption process runs Huffman compression before AES-128, while integrity verification uses SHA-256 hashing. Testing was conducted on seven student grade files from MA Ma'ahid Kudus. The results show that all files were successfully encrypted and decrypted without failure or data alteration, with encryption times of 0.0142-0.0828 seconds and decryption times of 0.0046-0.1417 seconds. The SHA-256 hash values of the original and decrypted files were identical for all samples, yielding 100% recovery accuracy, while the file size increase from padding and header insertion ranged only from 1,092 to 1,101 bytes. The study concludes that the combination of AES-128 and Huffman compression is an effective and efficient solution for protecting student grade data in educational institutions.
Abstract:Dinas Komunikasi dan Informatika Provinsi Jambi masih melaksanakan proses pencatatan dan monitoring barang masuk secara manual menggunakan dokumen administrasi dan aplikasi perkantoran sederhana, sehingga menimbulkan kendala…
dala berupa kesalahan pencatatan, keterlambatan pencarian data, dan kesulitan penyusunan laporan. Penelitian ini bertujuan merancang Sistem Monitoring dan Pengelolaan Barang Masuk Berbasis Web untuk membantu proses pencatatan, monitoring, pencarian, dan pelaporan data barang masuk secara lebih efektif. Metode pengembangan yang digunakan adalah Waterfall, meliputi analisis kebutuhan, perancangan, implementasi, pengujian, dan pemeliharaan, dengan pemodelan menggunakan UML serta basis data MySQL. Hasil penelitian menunjukkan bahwa sistem yang dibangun mampu mempermudah proses pencatatan barang, mempercepat pencarian data, meningkatkan akurasi penyimpanan data, serta menyederhanakan penyusunan laporan secara otomatis.
The Communication and Informatics Office of Jambi Province still records and monitors incoming goods manually using administrative documents and basic office applications, resulting in recording errors, delayed data retrieval, and difficulties in report preparation. This study aims to design a Web-Based Monitoring and Management System for Incoming Goods to support recording, monitoring, searching, and reporting processes more effectively. The system was developed using the Waterfall method, covering requirements analysis, design, implementation, testing, and maintenance, modeled with UML and a MySQL database. The results show that the developed system simplifies the recording of goods, accelerates data search, improves data storage accuracy, and streamlines automatic report generation.
Abstract:This study examines how leadership and work-life balance influence employee performance directly and indirectly through employee engagement at the Fisheries Service of Central Maluku Regency. A descriptive quantitative,…
causal-correlational design was applied to the entire population of 49 employees using total sampling. Data were analyzed through descriptive statistics, path analysis, and Sobel tests to estimate direct, indirect, and mediating effects. The findings show that leadership significantly affects employee engagement (beta = 0.582; p < 0.001), while work-life balance also has a significant, although smaller, effect on engagement (beta = 0.129; p = 0.005). Employee engagement strongly affects performance (beta = 0.942; p < 0.001). In contrast, the direct effects of leadership (beta = 0.034; p = 0.613) and work-life balance (beta = -0.008; p = 0.756) on performance are not significant. Sobel testing confirms that employee engagement mediates the effect of leadership on performance (p = 0.00015) and the effect of work-life balance on performance (p = 0.03). The model explains 92.4% of the variance in performance. The study's novelty lies in demonstrating, within a local public-sector context, that leadership and work-life balance improve performance primarily by strengthening employee engagement rather than through direct effects. These findings imply that public organizations should prioritize engagement-oriented leadership and work-life policies to achieve sustainable employee performance.