Abstract:Abstract: Choosing the right elementary school is a crucial milestone for a child's future. However, the large number of school options in Asahan Regency with diverse criteria such as accreditation, facilities, fees, curriculum,…
riculum, and accessibility often makes it difficult for parents. Decision-making tends to be based on subjective word-of-mouth recommendations, which risks triggering bias. This research aims to develop an adaptive and objective web-based elementary school selection Decision Support System (DSS) framework to minimize such bias. The system is designed using a hybrid model that combines the Simple Multi-Attribute Rating Technique (SMART) method as a dynamic criteria weighting engine based on parents' preferences, and the Technique for Order of Preference by Similarity to Ideal Solution (TOPSIS) method to rank ten alternative schools. System testing was conducted through black-box testing functionality and empirical accuracy testing using Spearman Rank Correlation involving 40 respondents. The black-box testing results confirmed that all main system operations ran perfectly with a 100% success rate. Validity testing demonstrated very high accuracy, with a Spearman correlation coefficient of 0.89, demonstrating significant alignment between the system's recommendations and actual choices on the ground. Thus, the SMART-TOPSIS framework has proven reliable as a data-driven approach to helping parents choose the best elementary school.
Keywords: decision support system; elementary school; SMART; TOPSIS
Abstrak: Memilih sekolah dasar yang tepat merupakan tonggak awal krusial bagi masa depan anak. Namun, banyaknya pilihan sekolah di Kabupaten Asahan dengan keberagaman kriteria seperti akreditasi, fasilitas, biaya, kurikulum, dan aksesibilitas sering kali menyulitkan orang tua. Pengambilan keputusan pun cenderung didasarkan pada rekomendasi subjektif dari mulut ke mulut, yang berisiko memicu bias. Penelitian ini bertujuan mengembangkan kerangka kerja Sistem Pendukung Keputusan (SPK) pemilihan sekolah dasar berbasis web yang adaptif dan objektif guna meminimalkan bias tersebut. Sistem dirancang menggunakan model hibrida yang mengombinasikan metode *Simple Multi-Attribute Rating Technique* (SMART) sebagai mesin pembobotan kriteria dinamis sesuai preferensi orang tua, serta metode *Technique for Order of Preference by Similarity to Ideal Solution* (TOPSIS) untuk memeringkat sepuluh sekolah alternatif. Pengujian sistem dilakukan melalui uji fungsionalitas *black-box testing* dan uji akurasi empiris menggunakan Korelasi Peringkat Spearman dengan melibatkan 40 responden. Hasil *black-box testing* mengonfirmasi seluruh operasi utama sistem berjalan sempurna dengan tingkat keberhasilan 100%. Uji validitas menunjukkan akurasi sangat tinggi dengan koefisien korelasi Spearman sebesar 0,89, membuktikan keselarasan signifikan antara rekomendasi sistem dan pilihan nyata di lapangan. Dengan demikian, kerangka SMART-TOPSIS ini terbukti andal sebagai pendekatan berbasis data untuk membantu orang tua memilih sekolah dasar terbaik.
Kata kunci: sekolah dasar; sistem pendukung keputusan; SMART; TOPSIS
Abstract:Abstract: Query performance is a critical factor in managing large-scale databases. One of the most widely used optimization techniques is indexing. This study aims to analyze the impact of indexing on query performance…
in PostgreSQL, compare the effectiveness of B-Tree and Hash indexes, and evaluate their influence on query planner decisions. A quantitative experimental approach was employed using the TPC-H benchmark dataset at scale factors SF0.1, SF1, and SF10. Experiments were conducted using EXPLAIN ANALYZE on exact match, range, and join queries under three conditions: without indexing, with B-Tree indexing, and with Hash indexing. The results demonstrate that indexing significantly improves query performance. For exact match queries on the SF10 dataset, execution time decreased from 93.36 ms without indexing to 0.034 ms using B-Tree and 0.045 ms using Hash indexes. For join queries, execution time was reduced from 857.77 ms to 0.180 ms using B-Tree and 0.079 ms using Hash indexes. B-Tree showed consistent performance across different query types, while Hash achieved the best results for equality-based queries. Furthermore, index usage influenced query planner decisions in selecting more efficient execution strategies. These findings indicate that appropriate index selection can substantially improve data access efficiency in PostgreSQL.
Keywords: b-tree index; hash index; PostgreSQL; query optimization; query planner
Abstrak: Performa query merupakan faktor penting dalam pengelolaan basis data berskala besar. Salah satu teknik optimasi yang umum digunakan adalah indexing. Penelitian ini bertujuan menganalisis pengaruh penggunaan indexing terhadap performa query pada PostgreSQL, membandingkan efektivitas B-Tree dan Hash index, serta mengevaluasi pengaruhnya terhadap keputusan query planner. Penelitian menggunakan metode eksperimen kuantitatif dengan dataset benchmark TPC-H pada skala SF0.1, SF1, dan SF10. Pengujian dilakukan menggunakan EXPLAIN ANALYZE pada exact match query, range query, dan join query dalam kondisi tanpa index, menggunakan B-Tree index, dan Hash index. Hasil penelitian menunjukkan bahwa indexing meningkatkan performa query secara signifikan. Pada exact match query dataset SF10, execution time menurun dari 93,36 ms tanpa index menjadi 0,034 ms menggunakan B-Tree dan 0,045 ms menggunakan Hash index. Pada join query, execution time berkurang dari 857,77 ms menjadi 0,180 ms menggunakan B-Tree dan 0,079 ms menggunakan Hash index. B-Tree menunjukkan performa yang konsisten pada berbagai jenis query, sedangkan Hash index memberikan performa terbaik pada query berbasis equality. Selain itu, penggunaan index memengaruhi keputusan query planner dalam memilih strategi eksekusi yang lebih efisien. Hasil penelitian menunjukkan bahwa pemilihan metode indexing yang tepat dapat meningkatkan efisiensi akses data pada PostgreSQL
Kata kunci: b-tree index; hash index; optimasi query; PostgreSQL; query planner
Abstract:Abstract: Student graduation is an urgent matter that is an indicator of the success of a university in producing its learning output. Several factors influence student graduation such as GPA, attendance, late taking credits,…
dits, and lack of student involvement in academic activities. The urgency of this research, universities need a method that is able to predict student graduation early so that it can provide academic intervention to students who have the potential to experience delays or fail to graduate. However, limited access to real academic data is often an obstacle in the development of predictive models, Therefore, this study aims to implement the XGBoost algorithm to predict student graduation based on several academic variables, namely the Cumulative Grade Point Average (GPA), the number of credits taken, the percentage of attendance, and the average grade of students. Model training using the XGBoost algorithm using a simulation dataset of 500 students who are labeled as graduating into two classes, namely passed and failed. The results of the study showed that the classification performance was very good with an accuracy value of 99.6%, Precision 99.7%, recall 99.4%.
Keywords: xgboost algorithm; data mining; student graduation
Abstrak: Kelulusan mahasiswa merupakan hal urgensi yang menjadi indikator keberhasilan sebuah perguruan tinggi dalam menghasilkan output pembelajarannya. Beberapa Faktor yang mempengaruhi kelulusan mahasiswa seperti IPK, kehadiran, keterlambatan pengambilan SKS, serta kurangnya keterlibatan mahasiswa dalam aktifitas akademik. Yang menjadi urgensi penelitian ini, Perguruan tinggi memerlukan suatu metode yang mampu memprediksi kelulusan mahasiswa secara dini sehingga dapat memberikan intervensi akademik kepada mahasiswa yang berpotensi mengalami keterlambatan atau tidak lulus. Namun, keterbatasan akses terhadap data akademik riil sering menjadi kendala dalam pengembangan model prediksi, Oleh karena itu, penelitian ini bertujuan mengimplementasikan algoritma XGBoost untuk memprediksi kelulusan mahasiswa berdasarkan beberapa variabel akademik, yaitu Indeks Prestasi Kumulatif (IPK), jumlah SKS yang ditempuh, persentase kehadiran, dan nilai rata-rata mahasiswa. Pelatihan model menggunakan algoritma XGBoost dengan menggunakan dataset simulasi 500 mahasiswa yang diberi label kelulusan menjadi dua kelas yaitu lulus dan tidak lulus. Hasil penelitian menunjukan bahwa performance klasifikasi yang sangat baik dengan nilai accurasi sebesar 99,6%, Precision 99,7%, recall 99,4%.
Kata kunci: algoritma xgbosst; kelulusan mahasiswa; penambangan data
Abstract:Abstract: The development of information technology has begun to enter the world of education, especially universities, one of which is the academic information system because with this system it greatly influences the learning…
earning process and also in the delivery of information. A web-based academic information system is very adequate, but there are several obstacles such as in learning that does not require a laptop device, it will be very disruptive if the implementation of attendance and others is done on a mobile phone but with a web view. So this research aims to design a mobile-based UI/UX academic information system application with the hope that it can be an alternative in accessing the use of academic information systems for lecturers and students can also be accessed anytime and anywhere through mobile phones with a comfortable display. This study also tested the UI/UX design prototype to assess its feasibility. This test uses the system usability scale (SUS) method with a convident interval validation of 95% to determine the lower and upper limits of the SUS value. For the final score of SUS obtained was 78.75, and in the 95% CI test a Lower CI of 66.27 was produced, and for the Upper CI of 91.23 so that it was given a grade of B. It can be concluded that the design developed in this study is worthy of further development.
Keywords: academic information systems; design thinking; system usability scale
Abstrak: Perkembangan teknologi informasi sudah mulai masuk kedalam dunia pendidikan terutama perguruan tinggi, salah satunya sistem informasi akademik karena dengan adanya sistem ini sangat mempengarusi proses pembelajaran dan juga dalam penyampaian informasi. Sistem informasi akademik berbasis web sudah sangat memadai namun ada beberapa kendala seperti dalam pembelajaran yang tidak memerlukan perangkat laptop akan sangat menganggu jika pelaksanaan absensi dan lainya dilakukan pada ponsel tapi dengan tampilan web. Sehingga penelitian ini bertujuan untuk merancang UI/UX aplikasi sistem informasi akademik berbasis mobile dengan harapan dapat menjadi alternatif dalam akses penggunaan sistem informasi akademik bagi dosen dan mahasiswa juga dapat diakses kapan saja dan dimana saja melalui ponsel dengan tampilan yang nyaman. Penelitian ini juga melakukan pengujian terhadap prototype desain UI/UX untuk menilai kelayakannya. Pengujian ini menggunaka metode system usability scale (SUS) dengan validasi convident interval 95% untuk mengetahui batas bawah dan batas atas nilai SUS. Untuk nilai akhir SUS yang didapatkan adalah 78,75, dan dalam pengujian CI 95 % dihasilkan CI Lower 66,27, dan untuk CI Upper 91,23 Sehingga mendapat grade B. Dapat disumpulkan bahwa desain yang dikembangkan dalam penelitian ini layak untuk dikembangkan lebih lanjut.
Kata kunci: sistem informasi akademik; desain thinking; system usability scale
Abstract:Abstract: The rapid degradation of mangrove ecosystems threatens coastal biodiversity, shoreline stability, and carbon sequestration capacity, particularly in areas experiencing intense human activity. However, community-based…
-based participatory mangrove monitoring remains limited due to the lack of accessible and user-friendly digital tools. This study aims to design an intuitive mobile application for mangrove tree detection and participatory ecological monitoring using a User-Centered Design (UCD) approach. The research was conducted iteratively through user needs analysis, prototype development, and usability evaluation involving local governments, conservation practitioners, and non-expert users. The proposed application integrates machine learning for automated mangrove recognition with geospatial visualization and real-time feedback to support field-based monitoring. Usability evaluation using the System Usability Scale (SUS) yielded an overall score of 82.3, categorized as excellent usability, indicating high user satisfaction and intuitive interaction. The results demonstrate that integrating UCD and machine learning enhances usability, user engagement, and the accuracy of mangrove documentation under real field conditions. Overall, this study presents a field-ready, user-centered mobile solution that bridges usability engineering and participatory mangrove monitoring as a replicable model for inclusive ecological application development.
Keywords: Carbon sequestration; mangrove monitoring; mobile application; user-centered design; usability evaluation
Abstrak: Degradasi ekosistem mangrove yang semakin cepat mengancam keanekaragaman hayati pesisir, stabilitas garis pantai, dan kapasitas sekuestrasi karbon, terutama di wilayah dengan aktivitas manusia yang intens. Namun, pemantauan mangrove secara partisipatif berbasis komunitas masih terbatas akibat kurangnya perangkat digital yang mudah diakses dan ramah pengguna. Penelitian ini bertujuan merancang aplikasi mobile yang intuitif untuk deteksi pohon mangrove dan pemantauan ekologi partisipatif dengan menggunakan pendekatan User-Centered Design (UCD). Penelitian dilakukan secara iteratif melalui analisis kebutuhan pengguna, pengembangan prototipe, dan evaluasi kegunaan dengan melibatkan pemerintah daerah, praktisi konservasi, serta pengguna non-ahli. Aplikasi yang diusulkan mengintegrasikan pembelajaran mesin untuk pengenalan mangrove secara otomatis dengan visualisasi geospasial dan umpan balik waktu nyata guna mendukung pemantauan di lapangan. Evaluasi kegunaan menggunakan System Usability Scale (SUS) menghasilkan skor keseluruhan sebesar 82,3 yang termasuk dalam kategori kegunaan sangat baik, menunjukkan tingkat kepuasan pengguna yang tinggi dan interaksi yang intuitif. Hasil penelitian menunjukkan bahwa integrasi UCD dan pembelajaran mesin meningkatkan kegunaan, keterlibatan pengguna, serta akurasi dokumentasi mangrove dalam kondisi lapangan. Secara keseluruhan, penelitian ini menyajikan solusi mobile berbasis UCD yang siap digunakan di lapangan dan menjembatani rekayasa kegunaan dengan pemantauan mangrove partisipatif sebagai model replikatif bagi pengembangan aplikasi ekologi yang inklusif.
Kata kunci: Carbon sequestration; mangrove monitoring; mobile application; user-centered design; usability evaluation
Abstract:Abstract: The rapid development of information and communication technology has prompted the government to provide digital-based services, including in the management of demographic data. This study aims to apply the Task-Centered…
k-Centered System Design (TCSD) method in designing the Muara Enim Regency Demographic Data Information System. The TCSD method was chosen to ensure that the prototype design process was systematic and focused on user needs and tasks. The research stages included identification, user-centered needs analysis, scenario-based design, and walkthrough evaluation. The designed prototype supports several main tasks, including viewing demographic statistics, searching for specific data, submitting data download requests, and contacting the admin. The evaluation was conducted through online usability testing using the Maze platform with the System Usability Scale (SUS) instrument involving 13 respondents. The evaluation results showed an average SUS score of 78.5, which falls into the “good” category. This confirms that the interface design has met usability standards, is user-friendly, and is capable of supporting user needs in accessing and managing demographic data. Thus, the application of the TCSD method has proven to be effective in producing an interface design that is focused on user tasks and can be the basis for further system development.
Keywords: system usability scale; task centered system design; user interface
Abstract:Abstract: Current technological developments play a crucial role in driving the tourism industry, one of which is the utilization of technology. However, tourist attractions in border areas face challenges such as limited…
d access to digital information and a lack of interactive media to present local wisdom such as history, customs, and culture. This study aims to develop and implement a QR Code-based Web-based Augmented Reality (WebAR) to digitize local wisdom at tourist attractions, making information more engaging and accessible to tourists. The research methodology adopted three approaches: UCD (User-Centered Design), Agile methods, and TAM (Technology Acceptance Model). This platform contains the local wisdom of two tourist villages in the border area, namely Sebujit Village and Jagoi Babang Village. The results of testing and evaluation using multiple linear regression and SEM-PLS methods on 45 respondents showed that the WebAR technology acceptance model was significant (F = 6.583; p < 0.001). User Attitude (ATU) is a key variable that significantly influences Intention to Use (BI) (β=0.429; p=0.001), while Ease of Use (PEOU) and Benefit (PU) indirectly influence BI through ATU. As additional validation, the classification test yielded an accuracy of 88.90% and an F1-score of 0.941, confirming that QR Code-based WebAR is effective and well-received as a digital information and promotion medium for local wisdom in border areas.
Keywords: border areas; local wisdom; qr code; tourist attractions; web augmented reality.
Abstrak: Perkembangan teknologi saat ini memiliki peran penting dalam mendorong industri pariwisata, salah satunya dengan pemanfaatan teknologi. Namun, objek wisata di daerah perbatasan menghadapi tantangan seperti keterbatasan akses informasi digital dan kurangnya media interaktif untuk menyajikan kearifan lokal seperti sejarah, adat istiadat, dan budaya. Penelitian ini bertujuan untuk mengembangkan dan mengimplementasikan Web-based Augmented Reality (WebAR) berbasis QR Code untuk digitalisasi kearifan lokal objek wisata, menjadikan informasi lebih menarik dan mudah diakses bagi wisatawan. Metodologi penelitian mengadopsi tiga pendekatan, UCD (User-Centered Design), metode Agile, dan TAM (Technology Acceptance Model). Platform ini memuat kearifan lokal dua desa wisata di daerah perbatasan, yaitu Desa Sebujit dan Desa Jagoi Babang. Hasil pengujian dan evaluasi dengan metode regresi linier berganda dan SEM-PLS pada 45 responden menunjukkan bahwa model penerimaan teknologi WebAR ini signifikan (F = 6.583; p < 0.001). Sikap Pengguna (ATU) menjadi variabel kunci yang berpengaruh signifikan terhadap Niat Penggunaan (BI) (β=0.429; p=0.001), sementara Kemudahan Penggunaan (PEOU) dan Manfaat (PU) memengaruhi BI secara tidak langsung melalui ATU. Sebagai validasi tambahan, uji klasifikasi menghasilkan akurasi 88,90% dan F1-score 0,941, yang menegaskan bahwa WebAR berbasis Kode QR efektif dan dapat diterima dengan baik sebagai media informasi dan promosi digital kearifan lokal di wilayah perbatasan.
Kata Kunci: daerah perbatasan; kearifan lokal; qr code; web augmented reality.
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: Higher education plays an essential role in improving human resource quality, one of which is through the institution’s ability to monitor and predict student graduation outcomes. This study does not focus on a…
a specific university but utilizes the publicly available Students Performance in Exams dataset from Kaggle, consisting of 1,000 student records containing mathematics, reading, and writing scores, along with demographic attributes such as gender, parental education level, lunch type, and test preparation participation. The data were processed through a feature engineering stage by adding an average score variable as an early indicator of graduation status. A predictive model was developed using the Random Forest Classifier, achieving an accuracy of 94.5%. The final model was integrated into a Streamlit-based web application to provide an accessible tool for academic stakeholders. The results indicate that the proposed model can serve as an effective decision-support tool for early evaluation of students’ likelihood of graduation.
Keywords: prediction; random forest classifier, streamlit, student graduation.
Abstrak: Pendidikan tinggi memegang peran penting dalam peningkatan kualitas sumber daya manusia, salah satunya melalui kemampuan institusi dalam memantau dan memprediksi tingkat kelulusan mahasiswa. Penelitian ini tidak berfokus pada perguruan tinggi tertentu, melainkan menggunakan dataset publik Students Performance in Exams dari Kaggle yang berisi 1.000 data mahasiswa, terdiri atas nilai matematika, membaca, menulis, serta atribut demografis seperti gender, tingkat pendidikan orang tua, jenis makan siang, dan partisipasi kursus persiapan. Data diolah melalui tahap feature engineering dengan menambahkan variabel average score sebagai indikator awal kelulusan. Model prediksi dibangun menggunakan algoritma Random Forest Classifier, yang menghasilkan tingkat akurasi sebesar 94,5%. Model ini kemudian diimplementasikan ke dalam aplikasi web berbasis Streamlit untuk memberikan layanan prediksi yang mudah diakses oleh pihak akademik. Hasil penelitian menunjukkan bahwa model mampu digunakan sebagai alat pendukung keputusan untuk melakukan evaluasi dini terhadap potensi kelulusan mahasiswa.
Kata kunci: kelulusan mahasiswa; prediksi; random forest classifier; streamlit.
Abstract: Abstract: The Ombudsman of the Republic of Indonesia is an institution tasked with supervising the administration of public services and handling community complaint reports related to allegations of maladministration.…
on. The purpose of this research is to create a decision support system using the Analytic Hierarchy Process (AHP) method, which facilitates the determination of priority handling of community complaint reports at the Ombudsman of the Republic of Indonesia Bengkulu Representation. This decision support system is built on a web-based platform using PHP programming language with a MySQL database that can be accessed offline by the admin of the Ombudsman. With the existence of this priority recommendation, it is expected that work will become more effective and efficient, as resources can be focused on reports that most need attention. Based on the test data used, which consists of 12 Community Complaint Reports from July 2024, it was found that the priority handling recommendations for community complaint reports were derived from 3 reports with the highest final AHP values. The recommended priority handling reports are registration number 0021/LM/VII/2024/BKL with a final AHP value of 2.074, registration number 0020/LM/VII/2024/BKL with a final AHP value of 1.964, and registration number 0018/LM/VII/2024/BKL with a final AHP value of 1.866.
Keywords: decision support system; priority recommendation; public complaint report; AHP Method (analytic hierarchy process method)