Personnel Information System Using Microsoft Excel (Case Study: Bima City Health Office)

Sistem Informasi Kepegawaian Dengan Menggunakan Microsoft Excel (Studi Kasus: Dinas Kesehatan Kota Bima)

  • Wulan Ramdhani Universitas ‘Aisyiyah Yogyakarta, Indonesia
  • Arizona Firdonsyah Universitas ‘Aisyiyah Yogyakarta, Indonesia
Keywords: Information Systems, Staffing, Microsoft Excel

Abstract

Information system is a system that has the ability to collect information from all sources and use various media to display information.  Microsoft Excel is a spreasheet application program (electronic worksheet), the function of Microsoft Excel is to perform calculation operations and can present data in table form, while the filter and sort data functions are used to sort or filter data, for example: the ascending function and descending to sort data from the largest or from the smallest, the Sort By and Sort On features, in addition to the filter function to display data with certain criteria, the filter feature function or often referred to as autofilter, which functions to display certain rows of data according to filters already applied and hides the rest of the remaining rows of data. This study aims to facilitate the search for staffing data at the Health Office of the City of Bima, the method of data collection using 2 methods, namely literature study and observation, the results of research that have been conducted are that there is no personnel information system because the process of searching and recording personnel data is still done manually.

References

R. Harisca, A. Huda, and L. Slamet, “Pengembangan Sistem Informasi Kepegawaian Berbasis Web Pada Man 1 Padang,” J. Vokasional Tek. Elektron. Dan Inform., vol. 5, no. 2, pp. 148–154, 2017.

W. W. Widiyanto, “Analisa Metodologi Pengembangan Sistem Dengan Perbandingan Model Perangkat Lunak Sistem Informasi Kepegawaian Menggunakan Waterfall Development Model, Model Prototype, Dan Model Rapid Application Development (Rad),” J. Inf. Politek. Indonusa Surakarta ISSN, vol. 4, no. 1, pp. 34–40, 2018.

M. Tonggiroh, “Sistem Informasi Kepegawaian Pada Kantor Dewan Teknologi Informasi Dan Komunikasi Provinsi Papua Berbasis Web,” Buku Mater. IT Lit., vol. 2, no. 1, pp. 1–116, 2018.

N. Resources et al., “Faktor-Faktor yang Mempengaruhi Kinerja Pegawai di Kabupaten Banggai Kepulauan,” Director, vol. 15, no. 40, pp. 6–13, 2018.

H. D. Lumbanraja, “Perancangan Sistem Informasi Akademik Online Menggunakan Black Box Testing Pada Sekolah Tinggi Ilmu Ekonomi Surya Nusantara,” TeIKa, vol. 8, no. 2, pp. 9–18, 2018, doi: 10.36342/teika.v8i2.664.

R. Juwita, “Pengaruh Set Kesempatan Investasi Terhadap Informasi Prediktif Laba Dalam Manajemen Laba,” vol. 4, no. 2, 2018.

S. Petro and K. H. Swatan, “Pelatihan Microsoft Excel Sebagai Penunjang Ketrampilan Hard Skill Bagi Siswa Pada Smk Ypsei Palangka Raya,” J. Abdimas BSI J. Pengabdi. Kpd. Masy., vol. 2, no. 2, pp. 280–286, 2019, doi: 10.31294/jabdimas.v2i2.6011.

D. K. K. Bima, “Tentang Dinas Kesehatan,” dikes.bimakota.go.id, 2018. .

S. Supriyadi, “Community of Practitioners: Solusi Alternatif Berbagi Pengetahuan antar Pustakawan,” Lentera Pustaka J. Kaji. Ilmu Perpustakaan, Inf. dan Kearsipan, vol. 2, no. 2, p. 83, 2017, doi: 10.14710/lenpust.v2i2.13476.

N. I. Pratiwi, “Penggunaan Media Video Call dalam Teknologi Komunikasi,” J. Ilm. Din. Sos., vol. 1, no. 2, pp. 202–224, 2017.

Published
2021-07-14