Implementasi Data Kependudukan Berbasis Statistik dan Excel

Authors

  • Alfisyahrina Hapsery Universitas PGRI Adi Buana Surabaya
  • Sari Cahyaningtias Universitas PGRI Adi Buana Surabaya
  • Edy Sulistiyawan Universitas PGRI Adi Buana Surabaya

DOI:

https://doi.org/10.18196/berdikari.v9i2.9122

Keywords:

Population Data, Ms. Excel, Descriptive Statistics, Data Visualization

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%.

Author Biography

Alfisyahrina Hapsery, Universitas PGRI Adi Buana Surabaya

Statistics

References

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

Downloads

Published

2021-08-31

Issue

Section

Articles