Data Insights: Menerapkan Analisis Deskriptif dan Semantik Diferensial menggunakan Microsoft Excel
DOI:
https://doi.org/10.36350/kiat.v1i1.14Keywords:
Semantic diferensial, Descriptive Analysis, Microsoft ExcelAbstract
The purpose of this Community Service activity is to enhance participants' understanding of the basic concepts of data analysis and its application in research, equip participants with practical skills in using Microsoft Excel to process and analyze data, and assist participants in presenting data analysis results effectively and attractively. This training method includes three different methodologies: presentation method, demonstration method, and practice method. The results of this activity showed that participants were able to create visualizations of descriptive data analysis in the form of attractive and easy-to-understand graphs, making the presented information easier for readers to digest. Participants were then invited to practice creating graphs using the provided dataset with Ms Excel, allowing them to directly experience the benefits of the techniques taught. The graphs created were multi-series graphs to display all the data, and 3D graphs to display each individual data point. The training conducted was able to enhance students' knowledge and skills in using Microsoft Excel for data processing and visual presentation of descriptive analysis.
References
Davenport. Analisis di Tempat Kerja: Keputusan yang Lebih Cerdas, Hasil yang Lebih Bagus. Pers Ulasan Bisnis Harvard; 2013.
Shmueli, Koppius. Analisis Prediktif dalam Penelitian Sistem Informasi. MIS Kuartalan. 2011;35(3):553–72.
Bhimani. Akuntansi Manajemen dalam Ekonomi Digital. Routledge; 2012.
Creswell. Desain Penelitian: Pendekatan Metode Kualitatif, Kuantitatif, dan Campuran. Publikasi Sage; 2017.
Roberts R, Johnson P. Understanding the quality of data: a concept map for ‘the thinking behind the doing’ in scientific practice. Curric J. 2015 Sep 3;26(3):345–69.
Yonatan YK, Saepudin TH, Ananda Putra Siaga, M. Arifin, Hidayat, Rafli Nur Firmansyah, et al. Dampak Teknologi Lanjutan Terhadap Keamanan Data Manajemen Sekuriti: Tantangan dan Peluang di Era Digital. Journal of Engineering Environtmental Energy and Science. 2024 Jun 30;3(2):59–66.
Diana AF, Madani MS. STRATEGI EFEKTIF PENGELOLAAN DAN ANALISIS DATA PT. NUSANTARA BUILDING INDUSTRIES DENGAN MICROSOFT EXCEL . INTIMAS. 2024;4(2):72–82.
Arithkel. Excel sebagai Alat Ampuh untuk Manajemen dan Analisis Data. Jurnal Ilmu Data dan Analisis. 2021;
Rahman, Yuridka, Sari. Pelatihan Komputer Program Microsoft Excel 2013 pada SMAN 12 Banjarmasin. Jurnal Pengabdian Al-Ikhlas. 2015;
Smith. Memulai dengan Power Query di Excel. Jurnal Analisis Data. 2023;15(2):45–58.
Novita D, Sihotang FP, Khairani S. Pelatihan Penggunaan Microsoft Excel Untuk Mengolah Data Bagi Siswa/i SMK Bina Cipta Palembang. FORDICATE. 2023 Apr 20;2(2):109–18.
