Search Articles & Publications

Showing 109 articles found for "Excel"

Implementation Of The Advanced Encryption Standard-128 Algorithm And Huffman Compression To Protect Student Grade Data

Dzulfikar Ahmad Firdaus, Fida Maisa Hana, Widya Cholid Wahyudin
Abstract: Student grade data is personal data that must be protected under Indonesian Law Number 27 of 2022 on Personal Data Protection, yet the rising number of data breaches in the education sector shows that such protection has… not been optimally implemented. This study implements the 128-bit Advanced Encryption Standard (AES) algorithm combined with Huffman compression to protect the confidentiality and integrity of student grade files in Excel (.xlsx) format, and evaluates its effectiveness through functional, performance, and security testing. The system was developed as a Python desktop application with a CustomTkinter interface, in which the encryption process runs Huffman compression before AES-128, while integrity verification uses SHA-256 hashing. Testing was conducted on seven student grade files from MA Ma'ahid Kudus. The results show that all files were successfully encrypted and decrypted without failure or data alteration, with encryption times of 0.0142-0.0828 seconds and decryption times of 0.0046-0.1417 seconds. The SHA-256 hash values of the original and decrypted files were identical for all samples, yielding 100% recovery accuracy, while the file size increase from padding and header insertion ranged only from 1,092 to 1,101 bytes. The study concludes that the combination of AES-128 and Huffman compression is an effective and efficient solution for protecting student grade data in educational institutions.

IMPROVING CHILDREN'S SONG SINGING SKILLS THROUGH INSTRUCTIONAL VIDEOS IN GRADE II AT SDN 6 KABILA, BONE BOLANGO REGENCY

Dalle, Elfira Adhelia, Husain, Rustam I, Monoarfa, Fidyawati, Pulukadang, Mimy Astuty, Nurainun, Nurainun
Abstract: This study aims to improve children's singing ability through the use of video-based learning in second-grade students at SDN 6 Kabila, Bone Bolango Regency. The research problem identified was the low singing ability of… students due to the lack of engaging learning media. Video-based learning was employed to help students understand pitch, rhythm, and lyrics, thereby enhancing their confidence, interest, and singing skills in music education. This study adopted a Classroom Action Research (CAR) design following the Kemmis and McTaggart spiral model, conducted in two cycles (Cycle I with two meetings and Cycle II with one meeting). The subjects were 21 second-grade students (9 males and 12 females). Data collection techniques included observation, tests (performance assessments), interviews, and documentation. Data were analyzed descriptively to determine improvements in students' singing ability across four indicators: pitch accuracy, rhythmic accuracy, lyric mastery, and expression with self-confidence. The results showed that students' initial singing ability was low, with only 28% achieving the minimum mastery criterion (KKM). After implementing video-based learning, students' mastery increased to 43% in Cycle I Meeting I, 62% in Cycle I Meeting II, and 90% in Cycle II Meeting I. Teacher activity improved from 60% (adequate) to 96% (excellent), and student activity increased from 59% (adequate) to 96% (excellent). These findings demonstrate that video-based learning effectively improves children's singing ability, confidence, and active participation in music education at the elementary school level.

IMPROVING CHILDREN'S SINGING ABILITY THROUGH VIDEO-BASED LEARNING IN SECOND GRADE OF SDN 6 KABILA, BONE BOLANGO REGENCY

Dalle, Elfira Adhelia, Husain, Rustam I, Monoarfa, Fidyawati, Pulukadang, Mimy Astuty, Nurainun, Nurainun
Abstract: This study aims to improve children's singing ability through the use of video-based learning in second-grade students at SDN 6 Kabila, Bone Bolango Regency. The research problem identified was the low singing ability of… students due to the lack of engaging learning media. Video-based learning was employed to help students understand pitch, rhythm, and lyrics, thereby enhancing their confidence, interest, and singing skills in music education. This study adopted a Classroom Action Research (CAR) design following the Kemmis and McTaggart spiral model, conducted in two cycles (Cycle I with two meetings and Cycle II with one meeting). The subjects were 21 second-grade students (9 males and 12 females). Data collection techniques included observation, tests (performance assessments), interviews, and documentation. Data were analyzed descriptively to determine improvements in students' singing ability across four indicators: pitch accuracy, rhythmic accuracy, lyric mastery, and expression with self-confidence. The results showed that students' initial singing ability was low, with only 28% achieving the minimum mastery criterion (KKM). After implementing video-based learning, students' mastery increased to 43% in Cycle I Meeting I, 62% in Cycle I Meeting II, and 90% in Cycle II Meeting I. Teacher activity improved from 60% (adequate) to 96% (excellent), and student activity increased from 59% (adequate) to 96% (excellent). These findings demonstrate that video-based learning effectively improves children's singing ability, confidence, and active participation in music education at the elementary school level.

Pendampingan Pembuatan Quick Response Code Indonesian Standard (Qris) Sebagai Upaya Digitalisasi Sistem Pembayaran Pada Pelaku Umkm Di Desa Mak Teduh, Kecamatan Kerumutan, Kabupaten Pelalawan Oleh Mahasiswa KUKERTA Universitas Riau

M. Rasuli, Excelenta Perangin-angin, Nataliya, Vina Puja Aqustin, Marshanda Lasmora Ida Sianturi, Defanny Febianti, Siti Azqia Zahra, Zahratul Keysa Benaya, Yulis, Muhammad Ikram Syawly Al-afif Annur, Hanif Ananda Tovani
Abstract: Usaha Mikro, Kecil, dan Menengah (UMKM) merupakan tulang punggung perekonomian Indonesia yang menyumbang lebih dari 60% Produk Domestik Bruto (PDB) nasional, namun sebagian besar pelaku UMKM di wilayah pedesaan, termasuk… di Desa Mak Teduh, Kecamatan Kerumutan, Kabupaten Pelalawan, masih menggantungkan transaksi usahanya pada sistem pembayaran tunai. Kondisi ini menjadikan UMKM tertinggal dalam arus digitalisasi ekonomi nasional yang terus berkembang pesat, khususnya melalui perluasan penggunaan Quick Response Code Indonesian Standard (QRIS) oleh Bank Indonesia. Kegiatan pengabdian ini bertujuan untuk memberikan pendampingan pembuatan dan penggunaan QRIS kepada pelaku UMKM di Desa Mak Teduh sebagai upaya mendorong digitalisasi sistem pembayaran, memperluas inklusi keuangan, serta meningkatkan daya saing usaha di era ekonomi digital. Kegiatan dilaksanakan melalui program Kuliah Kerja Nyata (KUKERTA) Universitas Riau Tahun 2026 dengan tahapan observasi, identifikasi permasalahan, koordinasi dengan pemerintah desa, sosialisasi, pendampingan pendaftaran, hingga evaluasi. Hasil kegiatan menunjukkan peningkatan pemahaman pelaku UMKM terhadap manfaat QRIS, meningkatnya jumlah pelaku usaha yang berhasil mendaftarkan QRIS, serta respons positif terhadap kemudahan bertransaksi non-tunai. Meskipun demikian, kegiatan ini juga menghadapi kendala berupa keterbatasan jaringan internet, minimnya literasi digital pada pelaku usaha lanjut usia, dan ketiadaan dokumen legalitas usaha. Kegiatan pengabdian ini diharapkan dapat menjadi model pendampingan digitalisasi UMKM yang berkelanjutan bagi desa-desa dengan karakteristik serupa di wilayah Provinsi Riau.

STRATEGY FOR STRENGTHENING THE REGIONAL ECONOMIC RESILIENCE OF NORTH SUMATERA PROVINCE THROUGH SUSTAINABLE ECONOMIC TRANSFORMATION

Nasution, Zulkarnain, Japina, Henky
Abstract: This study aims to analyze the influence of Regional Economic Innovation and Green Economy on Regional Economic Resilience with Digital Governance as a moderation variable in 33 districts/cities in North Sumatra Province… for the 2020–2025 period. The study uses an explanatory quantitative approach with secondary data in the form of panel data which is analyzed using panel data regression through Common Effect Model, Fixed Effect Model, and Random Effect Model. The selection of the best model was carried out using the Chow Test, Hausman Test, and Lagrange Multiplier Test, while hypothesis testing was carried out through t-test, F test, determination coefficient, and Moderated Regression Analysis (MRA). The results of the study show that the Fixed Effect Model is the best model. Regional Economic Innovation, Green Economy, and Digital Governance have a positive and significant effect on Regional Economic Resilience. In addition, Digital Governance has been proven to strengthen the influence of Regional Economic Innovation and Green Economy on Regional Economic Resilience. The Adjusted R² value of 81.8% indicates that the model has an excellent ability to explain variations in regional economic resilience. These findings affirm the importance of strengthening regional innovation, implementing a green economy, and accelerating the transformation of digital government as a sustainable, adaptive, inclusive, and competitive regional economic development strategy in North Sumatra Province.

Construction of Auditor Profession Ethics in The Era of Digital Disruption: a Phenomenological Study of Public Accounting Firm in Surabaya

Sulaiman, Nur Islamiati, Sri Trisnaningsih, Hero Priono
Abstract: This study aims to explore auditors' experiences in digital auditing practices, the meaning of professional ethics, and ethical dilemmas in the context of digital disruption using a phenomenological approach. The study was… as conducted at a Public Accounting Firm (KAP) in Surabaya, with auditors who had experience in technology-based audits as informants. Data were collected through in-depth interviews, observation, and documentation, then analyzed using a phenomenological approach supported by NVivo software. The results show that digital auditing practices are still dominated by the use of simple technologies such as Microsoft Excel for data processing, analysis, and audit documentation. Although technology increases efficiency, auditors still do not fully rely on the system and still use professional judgment to maintain the reliability of audit results. Professional ethics is understood as a primary foundation that remains valid, but is reinterpreted in the digital context, particularly related to efficiency pressures and technological risks. Ethical dilemmas arise due to time constraints, incomplete data, and client demands, so auditors tend to prioritize the sufficiency of evidence and prudence in decision-making. Overall, this study concludes that digital disruption does not change the fundamental values ​​of auditors' professional ethics, but rather reconstructs their meaning through work experiences and professional interactions.

Procurement Liberation: How School Districts are Cutting 47% of Purchasing Waste by 2025

Dzreke, Simon Suwanzy
Abstract: A mid-sized school district could achieve annual savings of $2.3 million—sufficient to support significant teacher salary increases—by streamlining procurement processes and reducing the number of suppliers from 87 to 12.… o 12. This practical success reflects the operational rigor of enterprise models, exemplified by Walmart Business, which has been successfully tailored for K-12 education. The study indicates a systemic crisis. Sixty-eight percent of U.S. districts experience a 19% loss of their non-payroll budgets due to procurement inefficiencies, resulting in significant financial losses for classrooms attributed to fragmented purchasing and compliance deficiencies. The study employs a rigorous mixed-methods analysis, incorporating in-depth case studies from 35 districts, a national survey of 300 procurement officers, and comprehensive spend analytics, to illustrate the transformative outcomes associated with enhanced procurement maturity. Consolidated purchasing platforms reduce processing costs by 53% and capture 92% of rebates. Additionally, the new Procurement Simplicity Scorecard predicts 79% efficiency gains, offering leaders a practical diagnostic tool. This study presents two validated innovations: the K-12 Procurement Maturity Model, which delineates a phased progression from fragmentation to strategic excellence, and the Zero-Waste Playbook, which details tactical measures for waste elimination. The evidence indicates that reengineering procurement is not merely an administrative concern; it represents a significant, frequently neglected mechanism for generating billions in savings by 2025. These funds have the potential to enhance arts programs, update outdated STEM laboratories, and recruit and retain high-quality educators. This research offers a definitive framework for districts aiming to transform waste into opportunities for equity.

Comparative Analysis of Financial Statements With a Financial Ratio Approach

Angreyani, Andi Dewi
Abstract: The purpose of this study is to analyze the comparison of financial statements of two leading food companies in Indonesia, PT. Indofood Sukses Makmur, Tbk and PT. Siantar Top, Tbk. This research uses financial statements… from PT. Indofood Sukses Makmur, Tbk and PT. Siantar Top, Tbk from 2022. The results of the data analysis show that PT. Indofood Sukses Makmur, Tbk and PT. Siantar Top, Tbk has an excellent liquidity ratio and the ability to settle debts. On the contrary, PT. Siantar Top has a better solvency ratio than PT. Indofood Sukses Makmur, Tbk. Activity ratio of PT. Indofood Sukses Makmur, Tbk and PT. Siantar Top, Tbk shows that both companies in terms of optimizing their assets, PT. Indofood is not good because the results are below industry standards. In addition, the profitability ratio of PT. Indofood showed better profit achievement performance than PT. Siantar Top, Tbk

Analysis of Stock Portfolio Performance Using The Jensen Method

Musa, Chalid Imran, Anwar
Abstract: Measuring portfolio performance cannot only be seen from the returns, but also must pay attention to the risks that investors will bear. Measuring the performance of a stock portfolio can be facilitated by using a proxy,… namely LQ 45 shares, which are liquid stocks with high market capitalization, have high trading frequency, have good growth prospects and financial conditions, are not volatile and have been objectively selected by the IDX and are stocks. which is safe to own because the fundamental performance of these stocks is good, so that from a risk perspective the LQ 45 stock group has the lowest risk compared to other stocks. The research objective was to determine portfolio performance assessment using the Jensen method, a case study of the LQ45 index on the Indonesian stock exchange for the 2019-2022 period. The population in this study is LQ45 index shares on the Indonesian stock exchange for the 2019-2022 period based on a purposive sampling technique. Data collection is documentation and literature study. The data analysis that will be used in this study is by using the Microsoft Excel 2010 application program to form an optimal portfolio using the Single index model and to assess the performance of a stock portfolio using the Jensen index method. the results of portfolio performance analysis of Jensen's Alpha LQ45 index optimal stocks and obtaining an average RVOR value of 0.0207 or 2.07%.

MENINGKATKAN KOMPETENSI BAHASA INGGRIS MELALUI COMMUNICATIVE LANGUAGE TEACHING DI KECAMATAN PADANGRATU

Hartono, Masduki, Sri Hartiningsih
Abstract: Globalisasi dan Masyarakat Ekonomi ASEAN (MEA) menuntut penguasaan Bahasa Inggris sebagai kompetensi dasar. Namun, masalah utama di Kecamatan Padangratu adalah rendahnya tingkat literasi Bahasa Inggris pada siswa SD hingga… ga SMA, yang berada jauh di bawah standar kompetensi minimum. Kondisi ini diperparah oleh terbatasnya akses terhadap lembaga pendidikan non-formal yang berkualitas, metode pengajaran yang konvensional, serta kurangnya lingkungan yang mendukung untuk praktik. Program pengabdian masyarakat ini bertujuan untuk mendirikan Excellent Learning Center (ELC) sebagai lembaga kursus Bahasa Inggris yang terjangkau dan berkualitas, meningkatkan kemampuan literasi Bahasa Inggris peserta secara signifikan, serta menerapkan metode pembelajaran yang komunikatif, interaktif, dan menyenangkan. Melalui metode pelaksanaan tiga tahap—persiapan, implementasi, dan evaluasi—program berhasil meningkatkan skor rata-rata tes Bahasa Inggris peserta sebesar 37,8%. Hasil menunjukkan bahwa pendekatan pembelajaran komunikatif dan interaktif yang diterapkan di ELC efektif dalam meningkatkan motivasi dan kompetensi peserta, terutama pada keterampilan membaca dan mendengarkan.