Claim Missing Document
Check
Articles

Found 3 Documents
Search

Pelatihan Pengolahan Data Sederhana Berbasis Spreadsheet untuk Mendukung Keputusan Usaha Mikro Segar Napitupulu; wenripin chandra
Journal of Public Health Vol 1 No 2 (2025): Jurnal Sinergi Digital untuk Pemberdayaan Masyarakat
Publisher : CV. Data Sinergi Digital

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.65853/sidena.v1i2.127

Abstract

Usaha mikro memiliki peran strategis dalam perekonomian Indonesia, namun sebagian besar pelaku usaha mikro masih mengelola data usaha secara manual sehingga rentan terhadap kesalahan dan tidak mampu menyediakan informasi yang akurat untuk pengambilan keputusan. Kegiatan Pengabdian kepada Masyarakat (PkM) ini bertujuan untuk meningkatkan kemampuan pelaku usaha mikro dalam mengolah data sederhana berbasis spreadsheet guna mendukung keputusan usaha yang lebih tepat. Metode yang digunakan meliputi pelatihan langsung dengan pendekatan praktik terbimbing, pre-test dan post-test, serta pendampingan pasca-pelatihan. Peserta pelatihan terdiri dari 30 pelaku usaha mikro di Kota Medan. Materi pelatihan mencakup pengenalan antarmuka spreadsheet, penggunaan formula dasar (SUM, AVERAGE, IF, COUNTIF), pembuatan tabel penjualan dan pengeluaran, serta visualisasi data melalui grafik sederhana. Hasil kegiatan menunjukkan peningkatan rata-rata skor pengetahuan peserta dari 42,5 pada pre-test menjadi 78,3 pada post-test, dengan selisih peningkatan sebesar 35,8 poin atau setara dengan peningkatan relatif sebesar 84,2% yang dihitung berdasarkan perbandingan terhadap skor awal. Sebanyak 93% peserta menyatakan bahwa pelatihan sangat bermanfaat dan relevan dengan kebutuhan usaha mereka. Kegiatan ini berkontribusi dalam memperkuat literasi digital pelaku usaha mikro serta mendorong pengambilan keputusan berbasis data di tingkat usaha mikro.
Evaluasi Keberhasilan Aplikasi CapCut dalam Pembuatan Video Promosi Produk: Pendekatan DeLone and McLean Riche Riche; Jepronel Saragih; Wenripin Chandra; Suminar Ariwibowo; Segar Napitupulu
SATESI: Jurnal Sains Teknologi dan Sistem Informasi Vol. 5 No. 1 (2025): April 2025
Publisher : Yayasan Pendidikan Penelitian Pengabdian ALGERO

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.54259/satesi.v5i1.4181

Abstract

CapCut is a popular video editing application among young people due to its diverse features and ease of use. This application is widely used for creating product promotional videos; however, several limitations affect user experience. Some common issues include video compression when uploaded from a PC, features experiencing bugs, and restrictions on using music outside the application. Therefore, this study aims to analyze the functionality of the CapCut application in supporting promotional video creation using the DeLone and McLean model.  Data collection was conducted online using the purposive sampling method, focusing on online business owners in North Sumatra. The total number of eligible respondents analyzed was 156, based on the Slovin formula. The collected data were analyzed using Structural Equation Modeling - Partial Least Squares (SEM-PLS) with the assistance of SmartPLS software.  The results indicate that system quality and the level of application usage have a positive and significant impact on user satisfaction. Furthermore, user satisfaction significantly contributes to the net benefits gained from using the application. However, the analysis also reveals that direct application usage does not significantly contribute to net benefits perceived by users.  These findings suggest that improving system quality and user experience are key factors in enhancing the benefits of CapCut for users in creating promotional videos. 
Model Data Mining untuk Penetapan Plafon Kredit dengan Algoritma C4.5 Frans Mikael Sinaga; Jefri Junifer Pangaribuan; Aulia Rizky Muhammad Hendrik Noor Asegaff; Wenripin Chandra; Riche Riche
INSOLOGI: Jurnal Sains dan Teknologi Vol. 4 No. 6 (2025): Desember 2025
Publisher : Yayasan Literasi Sains Indonesia

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.55123/insologi.v4i6.6656

Abstract

Manual credit limit determination in distributor companies is often subjective and inconsistent, increasing the risk of bad debts. This research aims to design an objective data mining model to support customer credit limit decisions at CV. XYZ. The method used is the Decision Tree with the C4.5 algorithm, applied to 66 historical records of customer payment data. Data analysis was performed by calculating Entropy and Information Gain values to build the decision tree, which was then validated using RapidMiner Studio software. The research successfully built a valid and consistent classification model. The "Piutang" (receivables/transaction volume per invoice) attribute was identified as the main determinant (root node), followed by the "Pembayaran" (payment history) attribute as a branch node. This model generates three interpretable decision rules, including the discovery of a risky pattern where high-volume customers with poor payment histories are associated with large credit limits. The proposed model can be implemented as a decision support tool to standardize credit policies, reduce subjectivity, and minimize the company's financial risk.