Claim Missing Document
Check
Articles

Found 2 Documents
Search

OPTIMALISASI PENGELOLAAN KAS RT BERBASIS DIGITAL MELALUI PELATIHAN DAN PENDAMPINGAN MICROSOFT EXCEL PADA RT 04/RW 04 BAMBU KUNING BATAM Amrizal Amrizal; Rika Harman; Sefni Melia Putri
PUAN INDONESIA Vol. 8 No. 1 (2026): Jurnal PUAN Indonesia Vol. 8 No. 1 Juli 2026
Publisher : ASOSIASI IDEBAHASA KEPRI

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.37296/jpi.v8i1.551

Abstract

Orderly and transparent financial management of Neighborhood Associations (Rukun Tetangga/RT) is an essential factor in supporting accountability in community fund management. One of the common challenges faced by RT administrators is the continued use of manual cash-book recording systems, which may lead to recording errors, data loss, and delays in preparing financial reports. This Community Service Program (PKM) aimed to optimize digital-based RT cash management through training and mentoring on the use of Microsoft Excel for the administrators of RT 04/RW 04, Bambu Kuning, Batam. The implementation methods included initial observation, socialization, training sessions, hands-on practice, and continuous mentoring. The training materials covered the creation of digital cash books, recording of cash inflows and outflows, the application of basic Microsoft Excel formulas, and the preparation of automated cash reports. The results demonstrated an improvement in participants’ knowledge and skills in managing RT finances digitally. After participating in the program, the participants were able to record financial transactions and independently generate cash reports using Microsoft Excel. This activity had a positive impact on enhancing the efficiency of financial administration, simplifying report preparation, and promoting transparency and accountability in the management of RT funds.
Sistem Informasi Monitoring Proses Pengumpulan Soal Ujian Berbasis Web pada Perguruan Tinggi Amrizal; Rika Harman; Sefni Melia Putri
Jurnal Desain Dan Analisis Teknologi Vol. 5 No. 2 (2026): Juli
Publisher : Aptikom Kepri

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.58520/jddat.v5i2.107

Abstract

Proses pengumpulan soal ujian di perguruan tinggi masih banyak dilakukan secara manual melalui surat elektronik atau aplikasi pesan, sehingga sering terjadi keterlambatan, kesulitan pemantauan, dan kurang optimalnya proses validasi. Penelitian ini bertujuan merancang Sistem Informasi Monitoring Proses Pengumpulan Soal Ujian berbasis web untuk mendukung pengumpulan, validasi, dan monitoring soal secara terintegrasi. Metode yang digunakan adalah Research and Development (R&D) dengan model Prototyping. Sistem dikembangkan menggunakan PHP dan MySQL dengan empat jenis pengguna, yaitu administrator, dosen, ketua program studi, dan dekan. Pengujian dilakukan menggunakan Black Box Testing untuk memastikan seluruh fungsi sistem berjalan sesuai kebutuhan. Hasil penelitian menunjukkan bahwa sistem mampu mempercepat proses pengumpulan soal, mempermudah monitoring status dan validasi, meningkatkan ketepatan waktu pengumpulan, serta menghasilkan informasi yang lebih akurat dan terdokumentasi. Sistem ini diharapkan mendukung efektivitas administrasi ujian dan transformasi digital tata kelola akademik di perguruan tinggi