Implementasi Data Kependudukan Berbasis Statistik dan Excel
Alfisyahrina Hapsery, Sari Cahyaningtias, Edy Sulistiyawan
Abstract
The digital era demands that all components of institutional infrastructures be able to adapt for effective and efficient activities’ management. Gedangan Village, Sedayu, Gresik, as a government institution, must be able to adapt to the development of the digital age as well. However, the lack of knowledge and skills of village officials regarding information technology has become an overwhelming obstacle. The purpose of the community service program in Gedangan village was to increase the capacity of village government officials in the mastery and application of statistical and excel-based information technology. The methods applied in achieving the objectives were lectures and practicals. The results of the program showed improvement of knowledge and skills of the village apparatus in the analysis and presentation of population data based on statistics and excel. The increased capacity was indicated by the ability of the improvement participants to answer correctly from the 7 (seven) questions. All participants were able to answer correctly from 5 questions reaching 100%, 1 question of 83.3%, and the last question with 66.67%.
Keywords
Population Data; Ms. Excel; Descriptive Statistics; Data Visualization
Bhattacharyya, Gouri K. & Richard A.Johnson. 2009. Statistical Principles And Methods (6th ed). United States: John Wiley & Sons, Inc.
Creswell J. 2015. Riset Pendidikan Perencanaan Pelaksanaan dan Evaluasi Riset Kualitatif dan Kuantitatif. Yogyakarta: Pustaka pelajar.
Guerrero, H. 2019. Excel Data Analysis, Modeling and Simulation. (2th ed). USA: Springer.
Hidayat, W. & Rahardjoo, N. 2014. Visualisasi Data Jumlah Penduduk Dalam Bentuk Kartogram (Studi Kasus Di Daerah Istimewa Yogyakarta). Jurnal Bumi Indonesia (pp 1-10). Yogyakarta : Univeritas Gajah Mada.
Heiberger, R.M. & Holland, B. 2015. Statistical Analysis and Data Display, An Intermediate Course with Examples in R. (2th ed). London : Springer.
Patmawati, H. & Santika, S. 2016. Penggunaan Software Microsoft Excel sebagai Alternatif Pengolahan Data Statistika Penelitian Mahasiswa Tingkat Akhir. Prossiding Seminar Nasional Matematika X. (pp 124-129). Semarang : Universitas Negeri Semarang.
Sahid. 2006. Analisis Data Statistiks dengan MS Excel. Laboratorium Komputer Jurdik Matematika FMIPA UNY.
Panjaitan, D. J., & Firmansyah. (2018). Pelatihan Pengolahan Data Statistik dengan Menggunakan SPSS. Prossiding Seminar Nasional Hasil Pengabdian. (pp 38-45). Medan : Universitas Muslim Nusantara Al-Washlliyah