Claim Missing Document
Check
Articles

Found 15 Documents
Search

Implementasi Sistem Informasi: Peran Microsoft Excel Dalam Praktik Akuntansi  Pada SMK Negeri Tenggarong Kutai Kartanegara Suyudi, Muhammad; Kusumah, Angga
Jurnal Pengabdian Sosial Vol. 2 No. 8 (2025): Juni
Publisher : PT. Amirul Bangun Bangsa

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.59837/1xswym52

Abstract

Penulisan artikel ini merupakan produk dari kegiatan pengabdian kepada masyarakat yang bertujuan untuk mengenalkan microsoft excel dalam praktik akuntansi yang diselenggarakan pada lembaga pendidikan kejuruan di SMK Negeri Tenggarong, Kutai Kartanegara, Kalimantan Timur, Indonesia. Melalui kegiatan ini diharapkan pemahaman microsoft excel dalam praktik olah data akuntansi membantu para siswa SMK mampu menyelesaikan tugas dan pekerjaan olah data akuntansi lebih efektif, terstruktur dan akuntabel. Proses pembelajaran tentang microsoft excel sebagai aplikasi olah data berbasis excel yang diajarkan guru praktik di sekolah. Pembelajaran mengenalkan microsoft excel masih lebih bersifat pemahaman logika dasar seperti: (if-lookup-vlookup-hlookup-left-right-mid-lower-upper-proper, sum, min, max, count, dst) yang umum dalam software microsoft excel. Melalui kegiatan ini, tim PKM Jurusan Akuntansi Polnes bermaksud untuk mengenalkan dan memahamkan bagaimana melakukan olah data akuntansi dengan cepat.  Metode PKM yang digunakan untuk merealisasikan tujuan adalah: Tim PKM menyediakan materi pelatihan yang simple dan praktis mudah difahami dan di implementasikan.  Cakupan materi dalam kegiatan PkM meliputi olah data:  a). Peran excel menghitung nilai pen­yusutan aktiva tetap menggunakan fungsi SLN-DB-DDB-SYD secara cepat dan akurat.  b) Mengitung dan menetapkan besaran CKP (cadangan kerugian piutang) perusa­haan melalui perhitungan aging schedule dalam memprediksi besaran CKP yang ditetapkan dalam Neraca. Tujuan kegiatan PKM dimaksudkan untuk memberikan bekal dan pemahaman kepada siswa dalam menghadapi uji kompetensi ke depannya. Dimana dalam materi uji kompetensi keahlian juga terdapat muatan dan kandungan materi tentang microsoft excel. Manfaat kegiatan pelatihan ini memiliki peran ganda, ungkapan ini selaras dengan apresiasi yang positif dari para guru sekolah dan para peserta pelatihan. Semoga kegiatan ini memiliki nilai guna dan manfaat guna khususnya kepada siswa dan kepada semua.
Project management planning of the small house construction in samarinda using the critical path method (CPM) Surahman, Surahma; Kusumah, Angga; Tiara, Tiara; S. Tomby, Rindayani; Nurmaulida, Nurmaulida
Enrichment : Journal of Management Vol. 14 No. 3 (2024): August: Management Science And Field
Publisher : Institute of Computer Science (IOCS)

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.35335/enrichment.v14i3.1939

Abstract

The house construction project was carried out in a span of 120 days involving 6 people. Data processing is carried out to ensure the smooth implementation of the project in accordance with the predetermined plan. By using the literature study method and secondary data processing, this study aims to develop an effective and efficient house construction project management plan, the method used in this project planning is the CPM critical path method (Critical path method). The project is carried out by 6 people, all materials such as sand, stone, cement and wood have been prepared in advance by the project owner. The information used in this analysis is based on direct interviews between the project owner and the researcher. Thus, the main conclusion is that effective and efficient project management, including careful budget planning and good control, is very important in ensuring the success of house construction. By maintaining a balance between time, budget, and quality, and applying the latest management techniques, the house construction project can be completed well in accordance with the set plan. The house construction project was carried out in a span of 120 days involving 6 people, with Mr. Ardiansyah in charge of project management. All materials such as sand, stone, cement, and wood have been prepared in advance by the project owner, ensuring the availability of construction materials during implementation. Normal and quick duration work network analysis is used to understand the sequence of construction activities, fastest duration, and normal duration of each project activity. By utilizing the CPM method, the critical path of the shophouse construction project can be identified to calculate the estimated project completion time and the minimum duration required.
Rancang Bangun Sistem Informasi Administrasi Santri Pondok Pesantren Darul Musthofa Sangatta dengan Menggunakan Macro VBA Excel Kusumah, Angga; Musa, Ibrahim; Marwanto, Marwanto; Estiningtyas, Naya; Safitri, Salsabela Nur
Jurnal Sistem Informasi Akuntansi Vol. 5 No. 2 (2024): Periode September 2024
Publisher : LPPM Universitas Bina Sarana Informatika

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.31294/justian.v5i2.7406

Abstract

The rapid advancement of information technology, particularly Microsoft Excel, facilitates the management of administrative data in educational institutions. Information systems are crucial for enhancing efficiency and effectiveness. The administration at Pondok Pesantren Darul Musthofa Sangatta is conducted manually, resulting in deficiencies such as inaccurate data, difficulties in information retrieval, limitations in student data management, and inefficient operations. The student administration information system is considered a solution to address these challenges. This system facilitates the management of student administrative data for administrators. The system is developed using the waterfall methodology, encompassing phases of requirement analysis, design, coding with VBA Macro in Microsoft Excel, testing, and maintenance. This study has produced a web-based student administration information system at Pondok Pesantren Darul Musthofa Sangatta. The system streamlines the administration of student data within the institution, conserving time, effort, and resources. Furthermore, it allows students and parents/guardians to access administrative information, including monthly payments, re-registration, and remaining funds. The system has been customized to meet the specific requirements of Pondok Pesantren Darul Musthofa Sangatta
Implementasi Microsoft Acces Dalam Sistem Informasi Manajemen Usaha Wadah Laundry Syadiva, Nayla Putri; Salsabila, Mutia; Billa, Wulan Juani Salsa; Nur Asy Syifa'; Kusumah, Angga
Jurnal Sistem Informasi Akuntansi Vol. 6 No. 2 (2025): Periode September 2025
Publisher : LPPM Universitas Bina Sarana Informatika

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.31294/ckm3jh98

Abstract

Wadah Laundry is a business that records transactions manually without a structured bookkeeping system. This leads to difficulties in monitoring operational income and expenses, making it unclear whether the business is generating profit or loss. Therefore, this study aims to develop an information system based on Microsoft Access to facilitate transaction recording, monitor financial flows, and calculate profit or loss more accurately. This research employs a field study method by collecting data directly through observations and interviews related to the business’s operational processes. The developed system includes key features such as customer transaction recording, customer data management, data storage, editing, deletion, and report generation as needed. The implementation results show that this system can help process data more effectively, making transaction recording more organized and accurate. Thus, the developed application is expected to support Wadah Laundry’s operations by improving business management efficiency.
COACHING CLINIC: METODOLOGI DAN KONSTRUKSI TEORI ILMU MANAJEMEN DI STIMI SAMARINDA Kusumah, Angga; Suyudi, Muhammad; Cahyono, Aris Tri; Rahman, Fatahul; Santoso, Bejo; Maulidani, Yurdi; Nurhaliza, Putri
JUAN: Jurnal Pengabdian Nusantara Vol. 2 No. 4 (2025): Oktober 2025
Publisher : CV Sentra Nusa Connection

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.63545/juan.v2.i4.180

Abstract

Kegiatan pengabdian kepada masyarakat ini bertujuan untuk memperkuat kemampuan peserta dalam metodologi dan proses konstruksi teori melalui pengembangan atau mengadaptasi teori yang telah ada agar relevan dengan konteks manajerial kontemporer. Selain itu, kegiatan ini menekankan pentingnya pemilihan metode penelitian yang tepat agar hasil penelitian memiliki validitas dan reliabilitas yang tinggi yang sesuai dengan etika akademik dan standar keilmuan manajemen. Coaching Clinic ini diharapkan menjadi sarana pembentukan paradigma ilmiah yang mendukung pengembangan ilmu manajemen berbasis riset. Metode pelaksanaan dengan pendekatan partisipatif, interaktif dan berbasis praktik ilmiah. Sebanyak 87 peserta yang mengikuti kegiatan ini. Hasil kegiatan dibuktikan dengan tersusunnya framework penelitian yang lebih sistematis dan berbasis teori manajemen yang relevan. Kegiatan ini diharapkan menjadi langkah awal pembentukan budaya riset di kalangan Mahasiswa STIMI Samarinda.