PENGENALAN PEMANFAATAN BASIS DATA (DATABASE) PADA MICROSOFT EXCEL PADA KANTOR DESA UNTUK MEMBANTU PENCATATAN DAN PENGELOLAAN DATA
DOI:
https://doi.org/10.31764/jmm.v8i1.20636Keywords:
Rawapanjang Village, Introduction, Utilization, Database, Microsoft Excel.Abstract
Abstrak: Pemanfaatan teknologi informasi menjadi penting di era digital. Kantor desa tidak lagi melalukan pelayanan secara manual dengan mencatatkan dan mengolah data menggunakan kertas dan pena. Saat ini, para pegawai di kantor desa juga dituntut dapat memanfaatkan berbagai perangkat digital seperti perangkat lunak Microsoft Excel. Oleh karena itu, tim dari dosen Fakultas Ilmu Komputer UPN Veteran Jakarta berupaya melaksanakan pengenalan pemanfaatan database pada Microsoft Excel sebagai upaya realisasi kegiatan pengabdian kepada masyarakat. Tujuan kegiatan ini yaitu membantu memberi pengenalan hard skill terkait pemanfaatan database pada Microsoft Excel untuk mencatat dan mengolah data. Kegiatan dilaksanakan melalui metode sosialisasi pemaparan materi. Kegiatan pengabdian ini dilaksanakan di satu mitra yaitu Kantor Desa Rawapanjang dengan melibatkan peserta sebanyak 11 perangkat desa. Pada pre-test pemateri menanyakan fungsi dari beberapa menu yang terdapat pada Microsoft Excel. Pada akhir kegiatan dilakukan pemberian post-test untuk menguji pemahaman peserta melalui tanya jawab secara lisan 5 soal terkait materi yang disampaikan. Berdasarkan hasil pengabdian, diketahui 90% peserta dapat menjawab 5 soal post-test dengan tepat. Sebagai evaluasi dan upaya berkelanjutan akan dilaksanakan pelatihan dan pendampingan implementasi dari konsep pengenalan yang telah dipelajari melalui praktik.
Abstract: The use of information technology is important in the digital era. Village offices no longer carry out services manually by recording and processing data using paper and pen. Currently, employees at village offices are also required to be able to utilize various digital tools such as Microsoft Excel software. Therefore, a team of lecturers from the Faculty of Computer Science, UPN Veteran Jakarta, is trying to introduce the use of databases in Microsoft Excel as an effort to realize community service activities. The aim of this activity is to help provide an introduction to hard skills related to using databases in Microsoft Excel to record and process data. Activities are carried out through the socialization method of presenting material. This service activity was carried out at one partner, namely the Rawapanjang Village Office, involving 11 village officials as participants. In the pre-test the speaker asked about the functions of several menus in Microsoft Excel. At the end of the activity, a post-test was given to test participants' understanding through verbal question and answer questions regarding the material presented. Based on the results of the service, it is known that 90% of participants were able to answer the 5 post-test questions correctly. As an evaluation and ongoing effort, training and assistance will be carried out in the implementation of introductory concepts that have been learned through practice.
References
Aditama, P. W., Indrawan, I. G. A., Wiguna, I. K. A. G., & Atmaja, K. J. (2021). Pelatihan Penggunaan Microsoft Office Dan Email Untuk Administrasi Surat Menyurat Di Dinas Perhubungan Provinsi Bali. Jurnal WIDYA LAKSMI, 1(1), 37–42.
Adnan, -, Erna, -, Zainuddin, -, Surahman, B., Ratnawati, -, Sabri, -, Ramiati, -, Hidayah, I., Amna, -, Kamarudin, A. P., & Saputra, W. T. M. (2023). Peningkatkan Kompetensi Aparat Desa Untuk Menyediakan Surat-Menyurat Menggunakan Fitur Mail Merge Dalam Microsoft Word Dan Microsoft Excel. Aptekmas: Jurnal Pengabdian Kepada Masyarakat, 6(2), 140–147. https://doi.org/10.36257/apts.vxix
Arista, A. (2022). Comparison Decision Tree and Logistic Regression Machine Learning Classification Algorithms to determine Covid-19. Sinkron: Jurnal Dan Penelitian Teknik Informatika, 7(1), 59–65. https://doi.org/10.33395/sinkron.v7i1.11243
Arista, A., & Abbas, B. S. (2022). Using the UTAUT2 model to explain teacher acceptance of work performance assessment system. International Journal of Evaluation and Research in Education (IJERE), 11(4), 2200–2208. https://doi.org/10.11591/ijere.v11i4.22561
Arista, A., Ernawati, I., Purabaya, R. H., & Abdullah, E. F. H. S. (2023). The Extension of the UTAUT2 Model: A Case Study of Indonesian SMEs Acceptance of Social Commerce. JOIV: International Journal on Informatics Visualization, 7(4), 2404–2414. www.joiv.org/index.php/joiv
Arista, A., Matondang, N., & Wadu, R. M. B. (2023). Pengenalan Dan Pembelajaran Teknologi Kepada Peserta Didik Sekolah Rakyat. JMM (Jurnal Masyarakat Mandiri), 7(4), 3794–3801. https://doi.org/10.31764/jmm.v7i4.16385
Arista, A., Muliawati, A., & Rahayu, T. (2022). Peningkatan Mutu Sumber Daya Yang Mandiri Melalui Teknologi Informasi. JMM (Jurnal Masyarakat Mandiri), 6(5), 3712–3719. https://doi.org/10.31764/jmm.v6i5.10177
Arista, A., Muliawati, A., & Rahayu, T. (2023). Pendampingan Implementasi Fungsi Agregat Dalam Membantu Pengelolaan Data. JMM (Jurnal Masyarakat Mandiri), 7(4), 3089–3097. https://doi.org/10.31764/jmm.v7i4.15521
Arista, A., & Ngafidin, K. N. M. (2022). An Information System Risk Management of a Higher Education Computing Environment. International Journal on Advanced Science, Engineering and Information Technology (IJASEIT), 12(2), 557–564. https://doi.org/10.18517/ijaseit.12.2.13953
Arista, A., Purabaya, R. H., & Isnainiyah, I. N. (2023). Pendampingan Pendidikan Dan Pelatihan Pemasaran Digital Berbasis Media Sosial Instagram. JMM (Jurnal Masyarakat Mandiri), 7(3), 2730–2737. https://doi.org/10.31764/jmm.v7i3.14861
Arista, A., Purbaya, M. E., & Ngafidin, K. N. M. (2021). Digital business roadmap webinar: Exploring creative digital business idea. Community Empowerment, 6(12), 2193–2199. https://doi.org/10.31603/ce.6290
Arista, A., Purbaya, M. E., & Ngafidin, K. N. M. (2023). Menghubungkan Akademik dan Industri, Peta Jalan Bisnis Digital: Ide Kreatif Bisnis Digital. JPPM (Jurnal Pengabdian Dan Pemberdayaan Masyarakat), 7(2), 239. https://doi.org/10.30595/jppm.v7i2.10426
Arista, A., Shuib, L., & Ismail, M. A. (2023a). A Glimpse of chatGPT: An Introduction of Features, Challenges, and Threads in Higher Education. 2023 International Conference on Informatics, Multimedia, Cyber and Informations System (ICIMCIS), 694–698. https://doi.org/10.1109/ICIMCIS60089.2023.10349057
Arista, A., Shuib, L., & Ismail, M. A. (2023b). An Overview chatGPT in Higher Education in Indonesia and Malaysia. 2023 International Conference on Informatics, Multimedia, Cyber and Informations System (ICIMCIS), 273–277. https://doi.org/10.1109/ICIMCIS60089.2023.10349053
Hidayat, M., Nursiti, N., & Handari, H. (2023). Pelatihan Penggunaan Microsoft Excel dalam Rekapitulasi Data di Balai Warga 03 Kelurahan Paseban Kecamatan Senen Provinsi Jakarta Pusat. KANGMAS: Karya Ilmiah Pengabdian Masyarakat, 4(2), 51–55. https://doi.org/10.37010/kangmas.v4i2.1188
Kustian, N., Muthoharoh, N. B., & Ridwan, R. (2020). Penggunaan Komputer Dan Pengolahan Data Dengan Microsoft Excel Pada Posyandu Asoka Ii Jatiranggon Bekasi. Jurnal PKM: Pengabdian Kepada Masyarakat, 03(03).
Ngafidin, K. N. M., Arista, A., & Amriza, R. N. S. (2021). Implementasi Firebase Realtime Database pada Aplikasi FeedbackMe sebagai Penghubung Guru dan Orang Tua. Jurnal RESTI (Rekayasa Sistem Dan Teknologi Informasi), 5(2), 327–334. https://doi.org/10.29207/resti.v5i2.2909
Ngafidin, K. N. M., Purbaya, M. E., & Arista, A. (2022). Sosialisasi Link and Match Teknologi Informasi antara Dunia Akademik dan Kebutuhan Industri: Kiat-Kiat Menjadi Android Developer. Adi Widya: Jurnal Pengabdian Masyarakat, 6(1), 37–45. https://doi.org/10.33061/awpm.v6i1.5818
Purabaya, R. H., Kraugusteeliana, K., & Arista, A. (2022). Socio-economic empowerment of the Tengkurak Village society through education assistance and social media-based digital marketing training. Community Empowerment, 7(9), 1591–1594. https://doi.org/10.31603/ce.7853
Salsabiila, S. Z., Nurramdhani Irmanda, H., & Arista, A. (2023). Comparison of Fasttext and Word2Vec Weighting Techniques for Classification of Multiclass Emotions Using the Conv-LSTM Method. 2023 International Conference on Informatics, Multimedia, Cyber and Informations System (ICIMCIS), 125–130. https://doi.org/10.1109/ICIMCIS60089.2023.10349034
Septa, R., Sobirin, H. A., Darri, S. W., & Kristanti, M. A. (2023). Edukasi Pembuatan Laporan Kerja Menggunakan Microsoft Excel Guna Mendukung Keahlian Bidang Ekonomi di Daerah Tangerang Selatan, Banten. PROGRESIF, 3(1), 17–24.
Susanty, M., Setiawan, E., Wahyu, ;, Wibowo, K., Nugroho, H., Ade Irawan, ;, Tasmi, ;, Koyimatu, ; Muhamad, Aulia, ;, Annisa, R., Teguh, ;, Nugroho, A., & Yunita, A. (2022). Peningkatan Literasi Komputer Melalui Pelatihan Micosoft Excel Advanced Untuk Efisiensi Pekerjaan di Instansi Pemerintahan. 4(2), 2655–5956. https://doi.org/10.33322/terang.v4i2.1528
Theresiawati, T., Seta, H. B., & Arista, A. (2023). Implementing quality function deployment using service quality and Kano model to the quality of e-learning. International Journal of Evaluation and Research in Education (IJERE), 12(3), 1560–1571. https://doi.org/10.11591/ijere.v12i3.25511
Tjahjanto, -, Arista, A., & Ermatita, -. (2022). Application of the Waterfall Method in Information System for State-owned inventories Management Development. Sinkron: Jurnal Dan Penelitian Teknik Informatika, 7(4), 2182–2192. https://doi.org/10.33395/sinkron.v7i4.11678
Downloads
Published
Issue
Section
License
Authors who publish articles in JMM (Jurnal Masyarakat Mandiri) agree to the following terms:
- Authors retain copyright of the article and grant the journal right of first publication with the work simultaneously licensed under a CC-BY-SA or The Creative Commons Attribution–ShareAlike License.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).
