Article Per Year (5 Year)
p-Index From 2021 - 2026
6.127
P-Index
This Author published in this journals
All Journal IJCCS (Indonesian Journal of Computing and Cybernetics Systems) ALGORITMA : JURNAL ILMU KOMPUTER DAN INFORMATIKA JURTEKSI Majalah Ilmiah Warta Dharmawangsa Reswara: Jurnal Pengabdian Kepada Masyarakat Jurnal Ilmu Komunikasi Network Media Syntax: Journal of Software Engineering, Computer Science and Information Technology Djtechno: Jurnal Teknologi Informasi Jurnal IPTEK Bagi Masyarakat DEVICE : JOURNAL OF INFORMATION SYSTEM, COMPUTER SCIENCE AND INFORMATION TECHNOLOGY Dharmawangsa: International Journal of the Social Sciences, Education and Humanitis Innovative: Journal Of Social Science Research Journal of Citizen Research and Development ABDI DALEM: Jurnal Pengabdian Kepada Masyarakat
J. Prayoga, J. Prayoga
Universitas Darmawangsa
Religion Agriculture, Biological Sciences & Forestry Humanities Biochemistry, Genetics & Molecular Biology Chemical Engineering, Chemistry & Bioengineering Computer Science & IT Control & Systems Engineering Decision Sciences, Operations Research & Management Economics, Econometrics & Finance Education Electrical & Electronics Engineering Languange, Linguistic, Communication & Media Law, Crime, Criminology & Criminal Justice Mechanical Engineering Medicine & Pharmacology Physics Public Health Social Sciences Other

Published : 52 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 52 Documents
Search

 2   3   4   5   6 
Audit Berbantuan Komputer Dan Data Analytics Prayoga, J.; Khairunisa, Dwi; Desfriyanti, Diva Kusuma; Ananda, Keysha Nabila; Putri, Mashayu Aulia; Ritonga, Nurul Izza Putri; Florida, Shinta
Jurnal Warta Dharmawangsa Vol 20, No 1 (2026)
Publisher : Universitas Dharmawangsa

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.46576/wdw.v20i1.8203

Abstract

Penelitian ini membahas penerapan Audit Berbantuan Komputer atau Computer Assisted Audit Techniques (CAATS) dalam mendukung proses audit berbasis data. Perkembangan sistem informasi menyebabkan meningkatnya volume dan kompleksitas data, sehingga pendekatan audit tradisional menjadi kurang memadai. Penelitian ini bertujuan untuk mengkaji konsep CAATS, jenis-jenis tools audit berbantuan komputer, serta pemanfaatan data analytics dalam proses audit. Metode penelitian yang digunakan adalah studi literatur dan studi kasus simulasi dengan ilustrasi pengelolaan data secara manual dan berbantuan komputer menggunakan Python. Hasil penelitian menunjukkan bahwa penerapan CAATS dan data analytics mampu meningkatkan efisiensi audit, memperluas cakupan pengujian, serta membantu auditor dalam mengidentifikasi data berisiko dan potensi anomali.
AUDIT SISTEM INFORMASI TERHADAP PERHITUNGAN WEIGHTED PRODUCT (WP) DI EXCEL Prayoga, J.; Gifary, Muhammad; Wiranata, Aldi; Maulana, Maulana; Nafriwan, Naufal; Nst, Rizqa Azahra; Kalista, Reva Nurul
Syntax : Journal of Software Engineering, Computer Science and Information Technology Vol 6, No 2 (2025): Desember 2025
Publisher : Universitas Dharmawangsa

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.46576/syntax.v6i2.8065

Abstract

 Penggunaan Microsoft Excel sebagai alat bantu perhitungan dalam Sistem Pendukung Keputusan (SPK) dengan metode Weighted Product (WP) semakin umum digunakan. Namun, perhitungan manual di Excel rentan terhadap kesalahan input, ketidaktepatan formula, dan inkonsistensi normalisasi bobot yang dapat menyebabkan hasil perankingan tidak valid. Penelitian ini bertujuan untuk melakukan audit sistem informasi terhadap file Excel yang digunakan dalam perhitungan metode WP guna memastikan integritas, akurasi, dan reliabilitas hasil.Audit dilakukan pada tiga komponen utama, yaitu input data, proses perhitungan (normalisasi bobot serta perhitungan nilai S dan V), dan output perankingan. Proses audit meliputi verifikasi kesesuaian rumus WP dengan teori, pengecekan konsistensi formula Excel, serta analisis kebenaran hasil perhitungan menggunakan data smartphone Xiaomi sebagai studi kasus.Hasil audit menunjukkan bahwa Excel dapat digunakan sebagai alat SPK sederhana apabila formula diterapkan secara benar dan konsisten sesuai aturan WP. Beberapa area kritis yang perlu diperhatikan meliputi penggunaan referensi absolut dan konsistensi formula antar baris. Penelitian ini menunjukkan bahwa audit sistem informasi berperan penting dalam menjaga integritas, akurasi, dan reliabilitas perhitungan WP di Excel serta memberikan rekomendasi untuk meminimalkan risiko kesalahan perhitungan. Kata Kunci: Audit Sistem Informasi, Weighted Product, Microsoft Excel, Verifikasi Formula, Sistem Pendukung Keputusan. ABSTRACTThe use of Microsoft Excel as a computational support tool in Decision Support Systems (DSS) applying the Weighted Product (WP) method has become increasingly common. However, manual calculations in Excel are prone to input errors, formula inaccuracies, and inconsistencies in weight normalization that may lead to invalid ranking results. This study aims to conduct an information system audit of an Excel file used to calculate the WP method to ensure the integrity, accuracy, and reliability of the calculations. The audit focuses on three main components: data input, calculation processes (weight normalization and S and V calculations), and ranking output. The audit includes verification of WP formulas against theoretical principles, consistency checks of Excel formulas, and validation of calculation results using Xiaomi smartphone data as a case study. The results show that Excel can function as a simple DSS tool if formulas are correctly and consistently applied according to WP rules. Critical issues identified include the use of absolute cell references and consistency of formulas across rows. This study demonstrates the role of information system audits in ensuring reliable WP calculations in Excel and provides recommendations to minimize calculation errors.Keywords: Information System Audit, Weighted Product, Microsoft Excel, Formula Verification, Decision Support System.
Co-Authors Adam Haris Al Firah Al Firah Al Hafiz, Reyva Ryo Alfarezy, Salman Ananda Hadi Elyas Ananda Hadi Elyas Ananda, Keysha Nabila Anggina, Arfah Anisma, Tiara Apridonal M, Yori Ardiata Ardiata Ari Nugroho Arini, Indah Aris Gunawan As’ari, Nabila Pramudita Ayu Nuriana br Ginting, Feby Ria Syahpitri Buyung Solihin Hasugian Desfriyanti, Diva Kusuma Dimas Fahreza Dores, Endri Dwi Tika Afriani Elyas, Ananda Hadi Emmy Syafitri Fahreza, Dimas Florida, Shinta Gifary, Muhammad Hafizh Abdillah Hutabarat, Emma Clodia Ibnu Rusydi Kalista, Reva Nurul Khairunisa, Dwi Kinanti, Dian Putri Latiffani, Chitra Lirinzha, Shifa Dwi Maharani, Dewi Mardiah Nasution Maulana Maulana, Maulana Muhammad Luthfi Nafriwan, Naufal Nasution, Mardiah Nst, Rizqa Azahra Nuriana, Ayu Permana, Ega Fitra Putri, Mashayu Aulia Rahma, Anisa Sri Ramadani, Cut Niaa Ramadani, Nisa Rasyad, Ismi Hamidah Ridho, Mhd Fahrul Ritonga, Nurul Izza Putri Rizky Maulana Ruyani Ruyani Sabrina Aulia Rahmah Salamah Salamah Saragi, Mutiara Gladies Satria, Welnof Sa’adah, Nur Siddik, Mohd. Siregar, Khairul Sri Fitria Jayusman Sri Wahyuni Sri Wahyuni Sry Handayani Sry Handayani, Sry Syaiful Amri Tiara Anisma Ummi Aminah Hasibuan Virdyra Tasril Virdyra Tasril Wiranata, Aldi Yasir, Amru Yori Apridonal M Zaman, Syakban Zelvi Gustiana Zhafar, Raihan Zulham Zulham