LITERASI FITUR DATA-FORM MS. EXCEL UNTUK MENGELOLA DATABASE ANGGOTA PERKUMPULAN KEMATIAN “LAZARUS” MALANG
Keywords:
Database, Data-Form, Ms. Excel
Abstract
This community service aims to develop technical skills in managing databases. So far, the “Lazarus" commission processed all regular membership fees manually. The repetitive work and recording errors happened along the way. With a total of 428 family members out of 993, the above data processing was inefficient and ineffective. Ms. Excel, especially the Data-Form feature will make database management easier for someone to process data entry, edit, search, and delete in a database table. When a database has been formed, the preparation of the annual report will also be able to be compiled efficiently & effectively, because the database is already stored in a soft file. Community service is carried out through training assistance. The activity begins with preparing teaching modules, followed by assisting to create a table model database in Ms. Excel. Subsequently, design a Data (Entry) Form model for recapitulation. The competencies have been achieved because in the end the database management has been simulated very well using real data & problems. Therefore, the final evaluation results declared that the database management model uses the Data Form successfully to help the "Lazarus" commission maximize its service.References
[1] Bansal, S. (2022). How to Create a Data Entry Form in Excel (Step by Step Guide). https://trumpexcel.com/data-entry-form/#Why-Do-You-Need-to-Know-About-Data-Entry-Forms, retrieved on January 2022.
[2] Chambers, R. (1995). Poverty and Livelihoods: Whose Reality Counts? Uner Kirdar dan Leonard Silk (eds.). People: From Impoverishment to Empowerment. New York University Press. New York.
[3] Chambers, R. (1996). Memahami Desa Secara Partisipatif. Kanisius. Yogyakarta.
[4] Christenson, J. A. & Robinson, J. W. R. (1989). Community Development in Perspective. Iowa State University Press. Iowa.
[5] Dosen Sosiologi (2022). Pengertian Pemberdayaan Masyarakat, Konsep, Jenis, Tujuan dan Contohnya. https://dosensosiologi.com/pemberdayaan-masyarakat-pengertian-konsep-jenis-dan-tujuannya-lengkap/. Diakses Juni 2022.
[6] Friedman, J. (1992). Empowerment: The Politics of Alternative Development. Basil Blackwell. Cambridge. Oxford.
[7] https:/www.kelasexcel.id/2018/02/data-entry-form-excel.html/Cara Input Data Menggunakan Data Form Excel Tanpa Macro, retrieved January 2022.
[8] Jamasy, O.(2004). Keadilan, Pemberdayaan dan Penanggulangan Kemiskinan. Bumi Putera. Jakarta.
[9] Kartasasmita, G. (1997). Pemberdayaan Masyarakat: Konsep Pembangunan yang Berakar pada Masyarakat. UGM. Yogyakarta.
[10] Kamil, M. (2009). Pendidikan Nonformal Pengembangan Melalui Pusat Kegiatan Belajar Mengajar (PKBM) di Indonesia (Sebuah Pembelajaran dari Kominkan Jepang). Alfabeta. Bandung.
[11] Latif, A. (2007). Pendidikan Berbasis Nilai Kemasyarakatan. Refika Aditama. Bandung.
[12] Purwadarminta. (2000). Model Pembelajaran Pendampingan, BPPLSP Jayagiri. Lembang.
[13] Setiana, L. (2005). Teknik Penyuluhan Dan Pemberdayaan Masyarakat. Ghalia Indonesia, Bogor.
[14] Shardlow, S. & Doel, M. (1993). Examination by triangulation: a model for practice teaching. Social Work Education, 12(3), pp.67-79.
[15] Wardani, T. I. (2022). Tutorial Membuat Data Form, Bahan Ajar untuk Prodi D-IV Jurusan Administrasi Niaga, Politeknik Negeri Malang.
[16] Wardani, T. I. (2020). Belajar Aplikasi Pengolah Lembar Kerja Dengan Mudah, Polinema Press, Malang.
[2] Chambers, R. (1995). Poverty and Livelihoods: Whose Reality Counts? Uner Kirdar dan Leonard Silk (eds.). People: From Impoverishment to Empowerment. New York University Press. New York.
[3] Chambers, R. (1996). Memahami Desa Secara Partisipatif. Kanisius. Yogyakarta.
[4] Christenson, J. A. & Robinson, J. W. R. (1989). Community Development in Perspective. Iowa State University Press. Iowa.
[5] Dosen Sosiologi (2022). Pengertian Pemberdayaan Masyarakat, Konsep, Jenis, Tujuan dan Contohnya. https://dosensosiologi.com/pemberdayaan-masyarakat-pengertian-konsep-jenis-dan-tujuannya-lengkap/. Diakses Juni 2022.
[6] Friedman, J. (1992). Empowerment: The Politics of Alternative Development. Basil Blackwell. Cambridge. Oxford.
[7] https:/www.kelasexcel.id/2018/02/data-entry-form-excel.html/Cara Input Data Menggunakan Data Form Excel Tanpa Macro, retrieved January 2022.
[8] Jamasy, O.(2004). Keadilan, Pemberdayaan dan Penanggulangan Kemiskinan. Bumi Putera. Jakarta.
[9] Kartasasmita, G. (1997). Pemberdayaan Masyarakat: Konsep Pembangunan yang Berakar pada Masyarakat. UGM. Yogyakarta.
[10] Kamil, M. (2009). Pendidikan Nonformal Pengembangan Melalui Pusat Kegiatan Belajar Mengajar (PKBM) di Indonesia (Sebuah Pembelajaran dari Kominkan Jepang). Alfabeta. Bandung.
[11] Latif, A. (2007). Pendidikan Berbasis Nilai Kemasyarakatan. Refika Aditama. Bandung.
[12] Purwadarminta. (2000). Model Pembelajaran Pendampingan, BPPLSP Jayagiri. Lembang.
[13] Setiana, L. (2005). Teknik Penyuluhan Dan Pemberdayaan Masyarakat. Ghalia Indonesia, Bogor.
[14] Shardlow, S. & Doel, M. (1993). Examination by triangulation: a model for practice teaching. Social Work Education, 12(3), pp.67-79.
[15] Wardani, T. I. (2022). Tutorial Membuat Data Form, Bahan Ajar untuk Prodi D-IV Jurusan Administrasi Niaga, Politeknik Negeri Malang.
[16] Wardani, T. I. (2020). Belajar Aplikasi Pengolah Lembar Kerja Dengan Mudah, Polinema Press, Malang.
Published
2022-12-30
Section
Articles
Copyright (c) 2022 Tri Istining Wardani, Asminah Rachmi, Dwi Sudjanarti, Umi Khabibah, Achmad Zaini
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution-ShareAlike License that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
- 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).
