Sosialisasi Pengenalan Formula Array pada Excel untuk Siswa Siswi SMA 1 Gunung Talang Solok

  • Sepsa Nur Rahman Universitas Putra Indonesia YPTK Padang
  • Irohito Nozomi Universitas Putra Indonesia YPTK Padang
  • Surmayanti Surmayanti This Community Service aims to socialize the introduction of array formulas in Excel to SMA 1 Gunung Talang Solok students. Array formulas are a very useful feature in data processing in Excel, but are often not widely known by high school students. The method used in this research is a socialization method which involves presentations, demonstrations, and direct practice using array formulas in Excel. Socialization was carried out in the form of training involving SMA 1 Gunung Talang Solok students. The research results showed that the socialization of the introduction of array formulas in Excel had a positive impact on students at SMA 1 Gunung Talang Solok. After following the socialization, students were able to understand and apply array formulas in data processing in Excel. They are able to create array formulas that are more efficient and accurate in completing tasks that involve data processing
Keywords: Socialization, Array Formula, Excel, High School Students, Data Processing

Abstract

This Community Service aims to socialize the introduction of array formulas in Excel to SMA 1 Gunung Talang Solok students. Array formulas are a very useful feature in data processing in Excel, but are often not widely known by high school students. The method used in this research is a socialization method which involves presentations, demonstrations, and direct practice using array formulas in Excel. Socialization was carried out in the form of training involving SMA 1 Gunung Talang Solok students. The research results showed that the socialization of the introduction of array formulas in Excel had a positive impact on students at SMA 1 Gunung Talang Solok. After following the socialization, students were able to understand and apply array formulas in data processing in Excel. They are able to create array formulas that are more efficient and accurate in completing tasks that involve data processing

References

Day, R. A. & Gastel, B. (2019). How to Write and Publish a Scientific Paper, 5th edition. Cambridge: Cambridge University Press. doi:10.1108/rr.1999.13.4.32.209
Ernst & Young (2019). Megatrends 2015: Making Sense of a World in Motion, EY.com, Hal. 1–54. doi: 1001663
Jatmiko, W., Alhamidi, M. R., Purbarani, S. C., Fazriah, N., Rachmasari, A. R., dkk. (2018). Buku Proposal Hibah Riset: Dari Ide Hingga Didanai. Fakultas Ilmu Komputer Universitas Indonesia.
Na’am, J. (2018). Edge detection on objects of medical image with enhancement multiple morphological gradient method. 2017 4th International Conference on Electrical Engineering, Computer Science and Informatics (EECSI). doi:10.1109/eecsi.2017.8239085
Na`am, J., Defit, S., Yuhandri, & Santony, J. (2020). Pedoman Penyusunan dan Penulisan Disertasi Program Doktor Teknologi Informasi. Universitas Putra Indonesia YPTK Padang. UPI-YPTK Press.
Ristekdikti (2019). Panduan Penelitian dan Pengabdian Kepada Masyarakat Edisi XII Revisi Tahun 2019 versi 2.0.
Ristekdikti (2019). Permenristekdikti Nomor 42 Tahun 2016.
Santony, J., & Na`am, J. (2019). Infiltrate Object Extraction in X-ray Image by Using Math-Morphology Method and Feature Region Analysis. International Journal on Advanced Science, Engineering and Information Technology, 6(2), 239. doi:10.18517/ijaseit.6.2.763
Sullivan, J., Karra, K., Moxon, S. A., Vallejos, A., Motenko, H., dkk. (2019) InterMOD: integrated data and tools for the unification of model organism research. Sci Rep 3:1802
Balaban, I., & Balaban, M. E. (2018). Enhancing Students’ Mathematical Problem-Solving Skills through Excel Spreadsheets. Eurasia Journal of Mathematics, Science and Technology Education, 14(1), 385-395.
Kurniawan, R. (2019). Peningkatan Kualitas Pembelajaran Microsoft Excel melalui Pendekatan Problem Based Learning (PBL) pada Siswa Kelas X SMK. Journal of Educational Science and Technology (EST), 5(2), 107-114.
Majid, A., & Surya, E. (2017). Efektivitas Penggunaan Microsoft Excel dalam Pembelajaran Matematika. Jurnal Pendidikan Matematika Raflesia, 1(1), 46-54.
Prasetyo, A. P., & Hidayat, R. (2018). Peningkatan Kemampuan Pemecahan Masalah Matematika melalui Penggunaan Microsoft Excel pada Siswa Kelas X SMA Negeri 1 Sooko Mojokerto. Jurnal Riset Pendidikan Matematika, 5(2), 201-210.
Siswanto, J., & Wibowo, B. (2019). Peningkatan Keterampilan Berpikir Kritis Siswa melalui Pembelajaran Excel pada Mata Pelajaran Matematika di Kelas VII SMP Negeri 3 Jember. Jurnal Pendidikan Matematika dan Ilmu Pengetahuan Alam, 2(1), 1-8.
Supriyanto, B., & Setyosari, P. (2020). Peningkatan Kemampuan Pemecahan Masalah Matematika Siswa melalui Pembelajaran Berbasis Excel. Jurnal Pendidikan Matematika dan Sains, 4(1), 11-17.
Wahyuni, E. S., & Kurniawan, R. (2018). Peningkatan Motivasi Belajar Siswa melalui Pembelajaran Excel pada Mata Pelajaran Matematika. Jurnal Pendidikan Matematika Raflesia, 2(1), 1-8.
Yuniarti, D., & Widyastuti, E. (2019). Penerapan Model Pembelajaran Kooperatif Tipe Numbered Heads Together (NHT) dengan Menggunakan Microsoft Excel untuk Meningkatkan Hasil Belajar Siswa. Jurnal Inovasi Pendidikan IPA, 5(1), 1-8.
Yusuf, M., & Kurniawan, R. (2020). Peningkatan Kualitas Pembelajaran Microsoft Excel melalui Pendekatan Problem Based Learning (PBL) pada Mata Pelajaran Komputer dan Jaringan Dasar. Jurnal Pendidikan Vokasi, 10(1), 105-114.
Zainuddin, A. M., & Kurniawan, R. (2020). Peningkatan Kualitas Pembelajaran Microsoft Excel melalui Pendekatan Problem Based Learning (PBL) pada Mata Pelajaran Komputer dan Jaringan Dasar. Jurnal Pendidikan Vokasi, 10(1), 105-114.
Published
2024-01-13
How to Cite
Rahman, S. N., Nozomi, I., & Surmayanti, S. (2024). Sosialisasi Pengenalan Formula Array pada Excel untuk Siswa Siswi SMA 1 Gunung Talang Solok. Jurnal Pengabdian Masyarakat Dharma Andalas, 2(2), 91-95. https://doi.org/10.47233/jpmda.v2i2.1235