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: Stroke is one of the leading causes of death and disability in various parts of the world, including in Indonesia. Along with the development of digital technology, the use of Machine Learning in the health sector…
tor is growing, one of which is in an effort to predict the occurrence of stroke. This study aims to implement the Logistic Regression algorithm in predicting the likelihood of a person having a stroke based on data from the Brain Stroke dataset. The research process includes data preprocessing (missing value handling, normalization, and label encoding), dividing the data into 80% training data and 20% test data, as well as model training. The model was then evaluated using several measures such as accuracy, precision, recall, F1-score, and ROC-AUC, as well as a confusion matrix. The results of the study showed that Logistic Regression was able to provide stroke classification results with an accuracy of 82.4%, precision of 80.1%, recall of 78.6%, F1-score of 79.3%, and a ROC-AUC value of 0.87. Then, the model is integrated into applications that use Streamlit, so it can be used interactively to predict stroke risk in new data. The results of this study show that the combination of Machine Learning and web-based applications has the potential to support efforts to detect early stroke risk.
Keywords: logistic regression; machine learning; prediction; streamlit; stroke.
Abstrak: Stroke adalah salah satu penyebab utama kematian dan kecacatan di berbagai belahan dunia, termasuk di Indonesia. Seiring perkembangan teknologi digital, penggunaan Machine Learning dalam bidang kesehatan semakin berkembang, salah satunya dalam upaya memprediksi terjadinya penyakit stroke. Penelitian ini bertujuan untuk mengimplementasikan algoritma Logistic Regression dalam memprediksi kemungkinan seseorang mengalami stroke berdasarkan data dari dataset Brain Stroke. Proses penelitian meliputi preprocessing data (penanganan missing value, normalisasi, dan label encoding), membagi data menjadi 80% data latih dan 20% data uji, serta pelatihan model. Model kemudian dievaluasi menggunakan beberapa ukuran seperti akurasi, precision, recall, F1-score, dan ROC-AUC, serta confusion matrix. Hasil penelitian menunjukkan bahwa Logistic Regression mampu memberikan hasil klasifikasi penyakit stroke dengan akurasi sebesar 82,4%, precision 80,1%, recall 78,6%, F1-score 79,3%, dan nilai ROC-AUC sebesar 0,87. Kemudian, model tersebut diintegrasikan ke dalam aplikasi yang menggunakan Streamlit, sehingga dapat digunakan secara interaktif untuk memprediksi risiko stroke pada data baru. Hasil penelitian ini menunjukkan bahwa kombinasi Machine Learning dan aplikasi berbasis web berpotensi mendukung upaya deteksi dini risiko stroke.
Kata kunci: logistic regression; machine learning; prediksi; streamlit; stroke.
Abstract:Abstract: Posyandu cadres play an important role in supporting community health services at the village and sub-district levels. However, the selection process for the best cadres is often carried out subjectively without…
t clear and standardized criteria. This condition can lead to a decline in service quality and reduced cadre motivation. Therefore, a decision support system is needed to provide assessments that are objective, measurable, and accountable. This study aims to optimize the Posyandu cadre selection process in Lubuk Kilangan District through the development of a decision support system based on a hybrid method: Analytical Hierarchy Process (AHP) and Technique for Order Preference by Similarity to Ideal Solution (TOPSIS). The AHP method is applied to determine the weight of each selection criterion based on its level of importance through pairwise comparisons. Subsequently, TOPSIS is used to rank candidates according to their proximity to the ideal solution. The methodology includes a literature review, primary data collection through interviews and questionnaires with stakeholders (community health centers, cadres, and village officials), as well as the implementation and testing of the AHP–TOPSIS–based system.
Keywords: Posyandu, Cadre, AHP, TOPSIS, Decision Support System
Abstrak: Kader Posyandu memiliki peran penting dalam mendukung layanan kesehatan masyarakat di tingkat desa dan kelurahan. Namun, proses pemilihan kader terbaik masih sering dilakukan secara subjektif tanpa acuan kriteria yang jelas dan terstandarisasi. Kondisi ini dapat mengakibatkan penurunan kualitas pelayanan serta rendahnya motivasi kader. Oleh karena itu, dibutuhkan suatu sistem penunjang keputusan yang mampu memberikan hasil penilaian yang objektif, terukur, dan dapat dipertanggungjawabkan. Penelitian ini bertujuan untuk mengoptimalkan proses pemilihan kader Posyandu di Kecamatan Lubuk Kilangan melalui pengembangan sistem penunjang keputusan berbasis metode hybrid Analytical Hierarchy Process (AHP) dan Technique for Order Preference by Similarity to Ideal Solution (TOPSIS). Metode AHP digunakan untuk menetapkan bobot masing-masing kriteria pemilihan kader berdasarkan tingkat kepentingan melalui perbandingan berpasangan. Selanjutnya, metode TOPSIS digunakan untuk melakukan pemeringkatan calon kader berdasarkan kedekatannya terhadap solusi ideal. Metode yang digunakan dalam penelitian ini mencakup studi literatur, pengumpulan data primer melalui wawancara dan kuesioner kepada stakeholder terkait (puskesmas, kader, dan perangkat desa), serta implementasi dan pengujian sistem berbasis AHP-TOPSIS.
Kata kunci: Posyandu, Kader, AHP, TOPSIS, Sistem Pendukung Keputusan
Abstract:Abstrack: This research aims to improve battery performance and safety on the ECGO2 electric motorcycle by re-assembling the battery system using 18650 lithium cells, Daly BMS 13S/7A battery management system, and XH-M604…
4 module. The configuration used is 13S5P (65 cells), resulting in a total voltage of 48.1 V and a capacity of 14 Ah, or equivalent to 673.4 Wh of energy. Compared to the ECGO2 built-in battery that requires 4-7 hours of charging time, this system is able to speed up charging to ±1.6 hours using a 7 A current charger. Test results using an oscilloscope show that the voltage of the assembled battery is more stable under load than that of a single battery, with minimal ripple. The estimated operating time of an 800 W electric motor using a 673.4 Wh battery is about 50 minutes. To achieve 2 hours of operation, the 13S10P configuration or energy-saving mode (400-500 W) can be used. The system is also more cost-effective at Rp2,678 per Wh compared to the manufacturer's version of Rp4,464 per Wh, as well as improved safety against leakage and overheating.
Keywords: 18650 lithium battery; daly bms; electric motorcycle; fast charging.
Abstrak: Penelitian ini bertujuan untuk meningkatkan performa dan keamanan baterai pada sepeda motor listrik ECGO2 dengan merakit ulang sistem baterai menggunakan sel lithium 18650, sistem manajemen baterai Daly BMS 13S/7A, dan modul XH-M604. Konfigurasi yang digunakan adalah 13S5P (65 sel), menghasilkan tegangan total 48,1 V dan kapasitas 14 Ah, atau setara dengan energi 673,4 Wh. Dibandingkan baterai bawaan ECGO2 yang memerlukan waktu pengisian 4–7 jam, sistem ini mampu mempercepat pengisian menjadi ±1,6 jam menggunakan charger arus 7 A. Hasil pengujian menggunakan osiloskop menunjukkan bahwa tegangan baterai rakitan lebih stabil di bawah beban dibandingkan baterai tunggal, dengan ripple minimal. Estimasi lama pengoperasian motor listrik 800 W menggunakan baterai 673,4 Wh adalah sekitar 50 menit. Untuk mencapai 2 jam pengoperasian, dapat digunakan konfigurasi 13S10P atau mode hemat energi (400–500 W). Sistem ini juga lebih hemat biaya dengan efisiensi harga Rp2.678 per Wh dibandingkan Rp4.464 per Wh versi pabrikan, serta meningkatkan keamanan terhadap kebocoran dan panas berlebih.
Kata kunci: baterai lithium 18650; daly bms; sepeda motor listrik; pengisian daya cepat.
Abstract:Abstract: Recommendation systems are becoming increasingly important with the growth of streaming platforms. The purpose of this study is to compare the performance of Content-Based Filtering, Neural Collaborative Filtering,…
ing, and a combination of both in a movie recommendation system. The method used in this study involves retrieving movie details from the TMDB API and ratings from the MovieLens 32M Dataset (2010-2023). Each model's performance is evaluated using evaluation metrics such as RMSE and MAE. The results of this study indicate that Neural Collaborative Filtering achieves the best prediction performance (RMSE = 0.785423, MAE = 0.581262), followed by the hybrid model (RMSE = 0.800863, MAE = 0.660872), while Content-Based Filtering produces low performance and limits the capabilities of the hybrid model. In conclusion, these findings highlight the superiority of latent feature-based models such as NCF that learn directly from user interaction patterns over content-based approaches in the context of modern recommendation systems.
Keywords: content-based filtering; hybrid filtering; movie recommendation; neural collaborative filtering.
Abstrak: Sistem rekomendasi menjadi semakin penting seiring berkembangnya platform streaming. Tujuan dari penelitian ini adalah membandingkan kinerja Content-Based Filtering, Neural Collaborative Filtering dan kombinasi keduanya dalam sistem rekomendasi film. Metode yang digunakan dalam penelitian ini melibatkan pengambilan detail film dari TMDB API dan rating dari dataset MovieLens 32M Dataset (2010-2023). Setiap peforma model dievaluasi dengan menggunakan metrik evaluasi seperti RMSE dan MAE. Hasil dari penelitian ini menunjukkan bahwa Neural Collaborative Filtering mencapai kinerja prediksi terbaik (RMSE = 0.785423, MAE = 0.581262), diikuti oleh model hybrid (RMSE = 0.800863, MAE = 0.660872), sementara Content-Based Filtering menghasilkankan peforma yang rendah dan membatasi kemampuan model hybrid. Kesimpulannya, penelitian ini menyoroti superiotas model berbasis latent feature seperti NCF yang belajar langsung dari pola interaksi pengguna dibandingkan pendekatan berbasis konten dalam konteks sistem rekomendasi modern.
Kata kunci: content-based filtering; hybrid filtering; neural collaborative filtering; rekomendasi film.
Abstract:Abstract: This study applies an integrated approach to optimize heart failure classification. The main objective is to address the challenge of class imbalance in medical datasets and to improve the accuracy, sensitivity,…
, and generalization of the classification model. The urgency of this issue is emphasized by statistics showing that cardiovascular diseases cause approximately 17.9 million deaths worldwide each year. Using a quantitative experimental approach, this study analyzes the "Heart Failure Prediction Dataset" from Kaggle, which consists of 918 records. The data were processed through normalization and encoding, followed by the application of SMOTE on the training set to balance class distribution. This step successfully increased model accuracy from 88.41% to 90.22% and minority class recall from 0.82 to 0.88. Furthermore, Bayesian Optimization was employed to refine the hyperparameters of SVM, resulting in a final model with an accuracy of 89.13% that demonstrated better generalization. This integrated approach significantly enhances the stability, sensitivity, and generalization of the model, making it a reliable tool for clinical decision support systems in predicting heart failure.
Keywords: bayesian optimization; heart failure; machine learning; SMOTE; SVM.
Abstrak: Penelitian ini menerapkan pendekatan terintegrasi untuk mengoptimalkan klasifikasi gagal jantung. Tujuan utama studi ini adalah untuk mengatasi tantangan ketidakseimbangan kelas dalam dataset medis dan meningkatkan akurasi, sensitivitas, serta generalisasi model klasifikasi. Urgensi ini ditegaskan oleh statistik yang menunjukkan bahwa penyakit kardiovaskular menyebabkan sekitar 17,9 juta kematian setiap tahun secara global. Menggunakan pendekatan eksperimental kuantitatif, penelitian ini menganalisis "Heart Failure Prediction Dataset" dari Kaggle, yang terdiri dari 918 catatan. Data diproses dengan normalisasi dan encoding, lalu SMOTE diterapkan pada data pelatihan untuk menyeimbangkan distribusi kelas. Langkah ini berhasil meningkatkan akurasi dari 88,41% menjadi 90,22% dan recall kelas minoritas dari 0,82 menjadi 0,88. Selanjutnya, Bayesian Optimization menyempurnakan hyperparameter SVM, menghasilkan model akhir dengan akurasi 89,13% yang menunjukkan generalisasi lebih baik. Pendekatan terintegrasi ini secara signifikan meningkatkan stabilitas, sensitivitas, dan generalisasi model. Hasil penelitian ini menjadikannya alat yang andal untuk sistem pendukung keputusan klinis dalam prediksi gagal jantung.
Kata kunci: bayesian optimization; gagal jantung; machine learning; SMOTE; SVM
Abstract:Abstract: Teacher performance appraisal is a very important aspect in improving the quality of education today, but often occurs during the assessment process of subjectivity constraints and lack of a structured system,…
in this study aims to build a data structure modeling and facilitate the school MAS Islamiyah Hessa Air Genting in the assessment to determine the best teacher transparently and measurably by using the Technique for Order Preference by Similarity to Ideal Solution (TOPSIS) algorithm. The TOPSIS method was chosen because it is able to provide ranking results based on the closeness of alternatives to the ideal solution. In this modeling, assessment criteria data such as pedagogical, professional, personality, social competencies, as well as other indicators such as teacher discipline and achievement are modeled structurally in a relational database. The results show that the designed data structure is able to support the decision-making process efficiently and objectively.
Keywords: data structure; decision support system; teacher assessment; topsis; ranking.
Abstrak: Penilaian kinerja guru merupakan aspek yang sangat penting dalam peningkatan mutu pendidikan saat ini, namun sering terjadi saat proses penilaian kendala subjektivitas dan kurangnya sistem yang terstruktur, dalam penelitian ini bertujuan untuk membangun pemodelan struktur data serta mempermudah pihak sekolah MAS Islamiyah Hessa Air Genting dalam penilaian untuk menentukan guru terbaik secara transparan dan terukur dengan menggunakan algoritma Technique for Order Preference by Similarity to Ideal Solution (TOPSIS). Metode TOPSIS dipilih karena mampu memberikan hasil perankingan berdasarkan kedekatan alternatif terhadap solusi ideal. Dalam pemodelan ini, data kriteria penilaian seperti kompetensi pedagogik, profesional, kepribadian, sosial, serta indikator lain seperti kedisiplinan dan prestasi guru dimodelkan secara terstruktur dalam basis data relasional. Hasil penelitian menunjukkan bahwa struktur data yang dirancang mampu mendukung proses pengambilan keputusan secara efisien dan objektif.
Kata kunci: struktur data; topsis; penilaian guru; sistem pendukung keputusan; perangkingan
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: The Ministry of Education, Culture, Research, and Technology, has developed guidelines for the Internal Quality Assurance System or known as SPMI, that is being implemented through the Internal Quality Audit (IQA)…
QA) with the PPEPP cycle, namely Determination (P), Implemen-tation (P), Evaluation (E), Control (P), and Improvement (P). Some universities have implemented IQA with system. The problem is that the system does not line well with the PPEPP cycle, which results in unsatisfactory audit results. The purpose of this study is to evaluate how well the university-owned AQI system features in line the PPEPP cycle and to highlight development opportunities. The method used Feature Oriented Domain analysis (FODA) and Acceptance Testing. This study delivered an analysis of IQA system features that consistent with PPEPP. The FODA results were validated by expert and tested with User Acceptance Test (UAT) with 89.98% user response that the system is acceptable. The research contributes to universities' understanding of the features necessary in the AQI system, which has an impact on the perfection of the university AQI system design in accordance with the PPEPP cycle.
Keywords: FODA; IQA system; PPEPP cycle; SPMI
Abstrak: Kementerian Pendidikan, Kebudayaan, Riset, dan Teknologi telah menyusun pedoman Sistem Penjaminan Mutu Internal atau yang dikenal dengan SPMI, yang diimplementasikan melalui Audit Mutu Internal (AMI) dengan siklus PPEPP, yaitu Penetapan (P), Pelaksanaan (P), Evaluasi (E), Pengendalian (P), dan Peningkatan (P). Beberapa perguruan tinggi telah mengimplementasikan AMI dengan sistem. Permasalahannya, sistem tersebut tidak sejalan dengan siklus PPEPP, sehingga hasil audit kurang memuaskan. Tujuan dari penelitian ini adalah untuk mengevaluasi seberapa baik fitur sistem AMI milik perguruan tinggi sejalan dengan siklus PPEPP dan menyoroti peluang pengembangan. Metode yang digunakan adalah analisis Feature Oriented Domain (FODA) dan Acceptance Testing. Penelitian ini menghasilkan analisis fitur sistem AMI yang konsisten dengan PPEPP. Hasil FODA divalidasi oleh ahli dan diuji dengan User Acceptance Test (UAT) dengan 89,98% respon pengguna bahwa sistem dapat diterima. Penelitian ini memberikan kontribusi terhadap pemahaman universitas terhadap fitur-fitur yang diperlukan dalam sistem AMI, yang berdampak pada kesempurnaan desain sistem AMI universitas sesuai dengan siklus PPEPP.
Kata kunci: FODA; siklus PPEPP; sistem AMI; SPMI
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.