Abstract:Abstract: Bakery MSMEs in Kisaran City play a significant role in the local economy, but their distribution data is still managed manually, making it difficult to access and analyze. This study aims to develop a WebGIS-based…
ased Geographic Information System to map and manage bakery MSME data digitally and in an integrated manner. The research methods include field surveys, spatial and non-spatial data collection, system design using UML, development with Leaflet.js and MySQL, and testing using the blackbox method. The results show that the resulting system is capable of displaying interactive maps with location details, business information, and an easy-to-use search feature. This system makes it easier for the government, business actors, and the public to access MSME information and supports data-based economic development planning. With the output in the form of publications in accredited journals, this research is expected to be an effective solution for MSME data management in other regions.
Keyword: bakery; mapping; MSME; WebGIS
Abstrak: UMKM toko roti di Kota Kisaran memiliki peran penting dalam perekonomian lokal, namun data persebarannya masih dikelola secara manual sehingga sulit diakses dan dianalisis. Penelitian ini bertujuan mengembangkan Sistem Informasi Geografis berbasis WebGIS untuk memetakan dan mengelola data UMKM toko roti secara digital dan terintegrasi. Metode penelitian meliputi survei lapangan, pengumpulan data spasial dan non-spasial, perancangan sistem menggunakan UML, pengembangan dengan Leaflet.js dan MySQL, serta pengujian menggunakan metode blackbox. Hasil penelitian menunjukkan sistem yang dihasilkan mampu menampilkan peta interaktif dengan detail lokasi, informasi usaha, dan fitur pencarian yang mudah digunakan. Sistem ini mempermudah pemerintah, pelaku usaha, dan masyarakat dalam mengakses informasi UMKM, serta mendukung perencanaan pembangunan ekonomi berbasis data. Dengan luaran berupa publikasi pada jurnal terakreditasi, penelitian ini diharapkan menjadi solusi efektif untuk pengelolaan data UMKM di daerah lain.
Kata kunci; pemetaan; toko roti; UMKM; WebGIS
Abstract:Abstract: The development of digital learning systems requires not only effective content delivery but also database consistency and performance, particularly when used at scale by lecturers and students. Weaknesses in database…
atabase design can lead to data duplication, relational violations, and transaction failures that compromise system reliability. This study designed the Royal Mengajar application using PHP and MySQL, supported by JavaScript, HTML, and Bootstrap 5. The Crowdsourced Academic Content model enables lecturers to contribute learning materials openly, while students evaluate them through a user rating system. The objective of this research is to design and optimize the database architecture of the Royal Mengajar application by implementing multiple control mechanisms—namely views, triggers, transactions, and constraints—to enhance data efficiency, consistency, and integrity in digital learning environments. Database optimization focuses on the use of views to improve query efficiency, triggers to maintain automatic consistency, transactions to ensure atomicity in multi-table operations, and constraints to preserve data integrity. The results show that views reduced the average query execution time to 0.12 seconds, triggers maintained consistency without manual intervention, and constraints achieved 100% referential integrity. The application of these mechanisms significantly improved system speed, reduced data redundancy, and enhanced information reliability, thus reinforcing the sustainability of Royal Mengajar as a community-driven learning platform
Keywords: crowdsourced academic content; constraint; database optimization; trigger.
Abstrak: Pengembangan sistem pembelajaran digital tidak hanya menuntut penyajian materi, tetapi juga konsistensi serta kinerja basis data ketika sistem digunakan secara masif oleh dosen dan mahasiswa. Kelemahan rancangan database dapat menimbulkan duplikasi data, pelanggaran relasi, dan kegagalan transaksi yang memengaruhi keandalan sistem. Penelitian ini merancang aplikasi Royal Mengajar berbasis PHP dan MySQL dengan dukungan JavaScript, HTML, dan Bootstrap 5. Model Crowdsourced Academic Content memungkinkan dosen berkontribusi secara terbuka, sedangkan mahasiswa melakukan evaluasi melalui user rating system. Tujuan penelitian ini adalah untuk merancang dan mengoptimalkan basis data aplikasi Royal Mengajar melalui penerapan berbagai mekanisme pengendali, seperti view, trigger, transaction, dan constraint, guna meningkatkan efisiensi, konsistensi, dan integritas data dalam sistem pembelajaran digital. Optimalisasi database difokuskan pada penerapan view untuk efisiensi query, trigger untuk menjaga konsistensi otomatis, transaction untuk memastikan atomicity pada operasi multi-tabel, serta constraint guna menjamin integritas data. Hasil pengujian menunjukkan view menurunkan rata-rata waktu eksekusi query menjadi 0,12 detik, trigger menjaga konsistensi tanpa intervensi manual, dan constraint memastikan integritas referensial tercapai 100%. Penerapan mekanisme ini berdampak pada peningkatan kecepatan sistem, berkurangnya redundansi, serta keandalan informasi yang lebih tinggi, sehingga mendukung keberlanjutan Royal Mengajar sebagai platform pembelajaran berbasis kontribusi komunitas.
Kata kunci: basis data; optimasi; trigger; constraint; crowdsourced academic content.
Abstract:Abstract: The Academic Information System (SIAKAD) plays an important role in supporting the management of academic administration in higher education institutions, particularly for students. ABC University has implemented…
ed SIAKAD since 2018 to facilitate administrative ativities in line with its motto of a high technology campus. This study aims to measure the sucess of SIAKAD usage from the aspects of acceptance, satisfaction, suitability, and perceived benefits. The integration of the Unified Theory of Acceptance and Use of Technology (UTAUT), DeLone & McLean, and Task Technology Fit (TTF) models was carried out to obain a more comprehensive overview in assessing the success of SIAKAD. UTAUT explains the factors influencing the intention to use, DeLone & McLean emphasizes the relationship between system quality and both user satisfaction and net benefits, while TTF evaluates the fit between technology and user tasks. By combining these three models, the study addresses the limitations of each model and produces a more holistic approach in measuring acceptance, success, and the appropriateness of system use. The testing was conducted using SPSS and Structural Equation Modeling (SEM) analysis through AMOS.
Keywords: siakad; utaut; delone&mclean; penerimaan teknologi; sem
Abstract:Abstract: Ineffective drug demand management can lead to problems such as imbalanced drug distribution, excess stock, or shortages in community health centers. To address this, data mining can be utilized to support the…
planning and control process of drug inventory. Clustering techniques were chosen because they are able to group drug data based on certain characteristics, thus identifying stable and unstable drug supply patterns. This study aims to group drug data at Simpang Kawat Community Health Center in Jambi City, which can be used as a reference in planning drug needs in the next period. Data grouping is divided into three categories: slow-moving, medium-moving, and fast-moving. The research data includes attributes of drug name, initial stock, receipt, inventory, usage, and final stock, with a total of 1758 data sets, which were processed using the CRISP-DM framework through the RapidMiner application. Cluster quality evaluation was carried out using the Davies-Bouldin Index (DBI). The results showed that the K-Means algorithm obtained a DBI value of 0.175, smaller than K-Medoids which obtained a value of 0.354. Because a smaller DBI value indicates better cluster quality, K-Means provides more optimal clustering results than K-Medoids. Through these clustering results, community health centers can utilize drug cluster information to support more efficient drug procurement planning, as well as reduce the risk of excess or shortage of stock.
Keywords: data mining; clustering; k-means; k-medoids; davies-bouldin index
Abstract:The development of digital technology encourages universities to improve effectiveness and efficiency in data management, particularly in recording and reporting faculty performance. Some lecturers still face difficulties…
s in reporting their performance in the SISTER application due to challenges in locating documents scattered across various archives, which often leads to issues such as delays in reporting, low information accuracy, and lack of transparency of faculty performance documents for institutional needs. This study aims to optimize the digitalization of faculty performance documents based on cloud computing using the Agile Unified Process (AUP) approach, which is implemented in the development of a cloud-based system by utilizing Google Drive as the storage medium for digital faculty performance documents. The AUP methodology was chosen for its ability to combine flexible iterative and incremental principles, allowing the system to adapt quickly and continuously to user needs. Testing using Equivalence Partitioning, based on the functional and non-functional requirements of the system, has shown results in accordance with expectations.
Abstract:Abstract: The management of veterinary drug stocks at the Veterinary Clinic Technical Implementation Unit (UPTD) of the North Sumatra Province Plantation and Livestock Service faces obstacles in the form of discrepancies…
between supply and demand, resulting in excess stock and budget waste. Uncertain demand for drugs is a factor that complicates decision-making in stock provision. This study aims to optimize drug stock management using the Mamdani fuzzy logic method, which is capable of handling data uncertainty and modeling information linguistically. Three input variables are used, namely initial stock, demand, and number of visits, with the output being the final stock. The process involves fuzzification, inference based on IF–THEN rules, and defuzzification using the centroid method. The results show that the developed system has a good accuracy level with a MAPE value of 17.52%, which means that this model is effective in providing optimal and efficient drug stock recommendations in a veterinary clinic environment.
Keywords: fuzzy mamdani; optimization; animal drug stock.
Abstract:Abstract: The development of information technology encourages businesses to take over digital systems in business operations, even in the sales process. The Point of Sales (POS) system is the leading solution for recording…
ing transactions, managing stock, and creating sales reports efficiently. This study aims to develop a POS application based on a website and make it easier for administrators to manage sales transactions, making them faster and more efficient. This system is made with a structured Agile Development method, requirements, design, development, testing, deployment, and implementation. The framework used is the Laravel framework, with system testing conducted using BlackBox. The test results show that the system is on track and that the efficiency of the transaction and reporting process can be increased. A web-based basis allows users to manage their business more easily in real time because this application is flexible and can be used on various devices.
Keywords: agile model;laravel;point of sales; websites
Abstrak: Pengembangan teknologi informasi mendorong bisnis untuk mengambil alih sistem digital dalam operasi bisnis, bahkan dalam proses penjualan. Sistem Point of Sales (POS) adalah solusi utama untuk merekam transaksi, mengelola stok dan membuat laporan penjualan secara efisien. Tujuan dari penelitian ini adalah untuk mengembangan aplikasi POS berdasarkan situs web dan memudahkan administrator dalam mengelola transaksi penjualan, membuatnya lebih cepat dan lebih efisien. Sistem ini dibuat dengan metode Agile Development yang terstruktur, requirement, design, development, testing, deployment, dan implementation serta kerangka kerja yang digunakan yaitu framework Laravel dengan pengujian sistem menggunakan Blackbox. Hasil pengujian menunjukkan bahwa sistem berada di jalur dan bahwa efisiensi proses transaksi dan pelaporan dapat meningkat. Dengan berbasis web memungkinkan pengguna untuk lebih mudah mengelola bisnisnya secara real time, karena aplikasi ini fleksibel melalui berbagai perangkat.
Kata kunci: model agile;laravel;point of sales;website
Abstract:Abstract: On-time graduation is an important indicator in measuring the success of higher education and reflects the effectiveness of the academic process in higher education. Royal University, especially the Information…
Systems Study Program, still faces challenges in increasing the percentage of students who graduate on time. This study aims to identify factors that influence students' on-time graduation and build a prediction model using the multiple linear regression method. This method was chosen because it is able to analyze the simultaneous influence of several independent numeric variables on one dependent variable, making it suitable for studying the complex relationship between factors that influence student graduation. The independent variables analyzed in this study include GPA, parental income, and student part-time jobs with student graduation as the dependent variable. The results showed that parental income and part-time jobs had a significant positive effect on on-time graduation, while GPA had a negative effect. The model built had an R² value of 0.6153 and a standard error of 4.0653, indicating that the model was quite strong and accurate. These findings recommend Universitas Royal to strengthen the academic monitoring system and support working students, as well as design policies based on students' socio-economic conditions to increase the on-time graduation rate.
Keywords: multiple linear regression; on-time graduation; students.
Abstrak: Kelulusan tepat waktu merupakan indikator penting dalam mengukur keberhasilan pendidikan tinggi serta mencerminkan efektivitas proses akademik di perguruan tinggi. Universitas Royal, khususnya Program Studi Sistem Informasi, masih menghadapi tantangan dalam meningkatkan persentase mahasiswa yang lulus tepat waktu. Penelitian ini bertujuan untuk mengidentifikasi faktor-faktor yang memengaruhi kelulusan tepat waktu mahasiswa serta membangun model prediksi menggunakan metode regresi linear berganda. Metode ini dipilih karena mampu menganalisis pengaruh simultan beberapa variabel independen numerik terhadap satu variabel dependen, sehingga sesuai untuk mengkaji hubungan kompleks antar faktor yang memengaruhi kelulusan mahasiswa. Variabel independen yang dianalisis dalam penelitian ini meliputi IPK, penghasilan orangtua, dan pekerjaan sambilan mahasiswa dengan kelulusan mahasiswa sebagai variabel dependen. Hasil penelitian menunjukkan bahwa penghasilan orangtua dan pekerjaan sambilan berpengaruh positif signifikan terhadap kelulusan tepat waktu, sedangkan IPK justru memiliki pengaruh negatif. Model yang dibangun memiliki nilai R² sebesar 0,6153 dan standar error 4,0653, menandakan model cukup kuat dan akurat. Temuan ini merekomendasikan Universitas Royal untuk memperkuat sistem monitoring akademik dan mendukung mahasiswa yang bekerja, serta merancang kebijakan berbasis kondisi sosial-ekonomi mahasiswa guna meningkatkan angka kelulusan tepat waktu.
Kata kunci: kelulusan tepat waktu; mahasiswa; regresi linear berganda.
Abstract:Abstract: Information Technology has impacted various sectors, including education. Learning Management Systems (LMS) are designed to facilitate lecturers and students in accessing academic activities such as online learning.…
ning. This study aims to analyze the effectiveness of Learning Management Systems (LMS) among higher education institutions in Indonesia. This analysis is crucial for assessing the effectiveness of LMS use by universities in Indonesia, enabling investments in LMS to yield optimal results. The study employed the D&M IS Success Model and PLS-SEM to evaluate the relationships between various variables, including system, information, service quality, user satisfaction, and benefits. Simple random sampling was used to collect data from 170 universities in Indonesia. This study employed PLS-SEM to investigate the observed variables, including validity and reliability testing, which involves assessing reliability, convergent validity, and discriminant validity. This current study found that all the hypotheses were accepted with p-values below 0,05. These findings contribute to universities paying attention to aspects of system, information, and service quality in Learning Management Systems (LMS) to improve user satisfaction and create a positive perception of benefits. Therefore, this research yields significant results that contribute to higher education in Indonesia, as well as the advancement of knowledge in management information systems.
Keywords: delone and mclean; information system success; LMS; SEM-PLS.
Abstrak: Teknologi Informasi telah memengaruhi berbagai sektor, termasuk pendidikan. Learning Management System (LMS) dirancang untuk memfasilitasi dosen dan mahasiswa dalam mengakses kegiatan akademik seperti pembelajaran daring. Penelitian ini bertujuan untuk menganalisis efektivitas penggunaan Learning Management System (LMS) di perguruan tinggi di Indonesia. Analisis ini penting untuk menilai sejauh mana efektivitas penggunaan LMS oleh universitas-universitas di Indonesia, sehingga investasi dalam LMS dapat mem-berika n hasil yang optimal.Penelitian ini menggunakan model D&M IS Success Model dan metode PLS-SEM untuk mengevaluasi hubungan antara berbagai variabel, termasuk kuali-tas sistem, informasi, layanan, kepuasan pengguna, dan manfaat. Teknik simple random sampling digunakan untuk mengumpulkan data dari 170 perguruan tinggi di Indonesia. Penelitian ini menggunakan PLS-SEM untuk mengkaji variabel-variabel yang diamati, ter-masuk pengujian validitas dan reliabilitas, yang mencakup penilaian reliabilitas, validitas konvergen, dan validitas diskriminan. Hasil dari penelitian ini menunjukkan bahwa semua hipotesis diterima dengan nilai p di bawah 0,05. Temuan ini mendorong universitas untuk memberikan perhatian pada aspek kualitas sistem, informasi, dan layanan dalam penggunaan LMS guna meningkatkan kepuasan pengguna dan menciptakan persepsi posi-tif terhadap manfaatnya. Oleh karena itu, penelitian ini memberikan hasil yang signifikan bagi perguruan tinggi di Indonesia serta turut berkontribusi dalam pengembangan ilmu di bidang sistem informasi manajemen.
Kata kunci: delone and mclean; kesuksesan sistem informasi; LMS; SEM-PLS
Abstract:Abstract: Computer networks are not just additional facilities in the campus environment, but computer networks help the overall academic activities and social relations of students. This research aims to overcome the problem…
oblem of uneven wifi internet networks and less than optimal SSID management in UHAMKA flats, which has an impact on student access to information and communication. The method used is PPDIOO with simulation using Cisco Packet Tracer and the chosen star topology to provide a stable connection and easy network management. The results of the simulation show that all devices are well connected to each other, as indicated by the successful IP ping test between devices. The research concluded that the PPDIOO method was successful in designing an effective and structured internet network in the students' living environment. So that it can improve access to academic activities and good communication.
Keywords: cisco packet tracer; computer networks; PPDIOO
Abstrak: Jaringan komputer bukan hanya sekedar fasilitas tambahan dalam lingkungan kampus, tetapi jaringan komputer membantu keseluruan aktivitas akademik dan hubungan sosial mahasiswa. Penelitian ini bertujuan mengatasi permasalahan jaringan internet wifi yang belum merata dan pengelolaan SSID yang kurang optimal di rusunawa UHAMKA, sehingga berdampak pada akses informasi dan komunikasi mahasiswa. Metode yang digunakan adalah PPDIOO dengan simulasi menggunakan cisco packet tracer dan topologi star yang dipilih untuk memberikan koneksi stabil dan pengelolaan jaringan yang mudah. Hasil dari simulasi menunjukan seluruh perangkat saling terhubung dengan baik, ditandai dengan berhasilnya pengujian ping IP antar perangkat. Penelitian menyimpulkan metode PPDIOO berhasil dalam merancang jaringan internet yang efektif dan terstruktur di lingkungan tempat tinggal mahasiswa. Sehingga dapat meningkatkan akses aktivitas akademik dan komunikasi secara baik.
Kata kunci: cisco packet tracer; jaringan komputer; PPDIOO