Trialogical Model in Data Analysis Using Spreadsheet

Trialogikal Model dalam Analisis Data Menggunakan Hamparan Elektronik

  • Mahamsiatus Kamaruddin IPG Kampus Pendidikan Teknik
Keywords: data analysis, Trialogical Model, Microsoft Excel spreadsheet

Abstract

Abstract

The advance of information technology and the availability of data in education management provide an opportunity, to run data analysis to assist top management in decision making. Information technology can transform data analysis in a more concise format, accurate, and in a short time, by using any available office application software which is already installed on the computer. However, even though the management at an operational-level in an organization usually already has the software installed on a computer to support the managing of data, the extent of knowledge and skills to use the software efficiently in decision making is still limited. This study applies the Trialogical Model to implement decision support tools for data analysis of distribution lecturer’s teaching and learning (TnL) hour at IPG Kampus Pendidikan Teknik (IPGKPT) by grade specifications. A literature review using the interpretive paradigm involved the Trialogical Model (includes Monological and Dialogical), which is a knowledge-based model was carried out to run the data analysis using a Microsoft (Ms) Excel spreadsheet with Visual Basic for Application (VBA) and graphical interface. The findings show the usability of the Trialogical Model in the development of the decision support tool for TnL data analysis.

Abstrak

Kemajuan teknologi maklumat dan ketersediaan data dalam pengurusan pendidikan memberikan peluang, analisis data dilakukan untuk membantu pihak pengurusan membuat keputusan. Teknologi maklumat dapat mengubah analisis data dalam format yang lebih ringkas, tepat, dan dapat diakses dalam waktu yang singkat, dengan menggunakan perisian aplikasi pejabat yang sedia dipasang pada komputer. Namun, walaupun pihak pengurusan pada pelbagai peringkat operasi dalam organisasi mempunyai perisian yang tersedia dipasang pada komputer masing-masing, namun sejauh mana pengetahuan dan kemahiran menggunakan perisian dengan cekap dalam mengurus membuat keputusan masih terbatas. Kajian ini menggunakan Model Trialogikal untuk melaksana alat sokongan keputusan analisis data berkaitan agihan jam pengajaran dan pembelajaran (PdP) pensyarah di IPG Kampus Pendidikan Teknik (IPGKPT) mengikut spesifikasi gred. Tinjauan literatur menggunakan paradigma interpretatif melibatkan Model Trialogikal (termasuk Monologikal dan Dialogikal), yang merupakan model berdasarkan pengetahuan dilakukan untuk melaksana analisis data tersebut menggunakan perisian hamparan elektronik Microsoft (Ms) Excel dengan Visual Basic for Application (VBA) beserta antara muka grafik. Hasil kajian menunjukkan kebolehgunaan Model Trialogikal untuk menjana alat sokongan keputusan analisis data agihan PdP.

Downloads

Download data is not yet available.

References

Donato, R. D., Garofalo, M., Malandrino, D, Pellegrino, M. A., Petta, A. & Scarano, V. (2019). Linked Data Queriesby a Trialogical Learning Approach. In proceedings of the 2019 IEEE 23rd International Conference on Computer Supported Cooperative Work in Design (CSCWD), Porto, Portugal. 117-122, DOI:10.1109/CSCWD.2019.8791867.
Institut Pendidikan Guru Malaysia (2019). Garis Panduan Amanah Tugasan Pensyarah (ATP).
Karlgren, K., Paavola, S. & Ligorio, M. B. (2020). Introduction: What are knowledge work practices in education? How can we
study and promote them?. Research Papers in Education, 35(1), 1-7, DOI:10.1080/02671522.2019.1677761.
Kusmin, M. (2019). Inquiry-Based Learning and Trialogical Knowledge-Creation Approach in Smart Schoolhouse Supported by IoT Devices. In proceedings of the 2019 IEEE Global Engineering Education Conference (EDUCON), Dubai, United
Arab Emirates. 571-575, DOI:10.1109/EDUCON.2019.8725232.
Paavola, S. & Hakkarainen, K. (2009). From Meaning Making to Joint Construction of Knowledge Practices and Artifacts – A
Trialogical Approach to CSCL. In proceedings of the Computer Supported Collaborative Learning Practices: CSCL2009.
83–92.
Rozalia, R. V., & Valentin, T. (2008). Spreadsheet–Based Decision Support System. In proceedings of the European Integration
- New Challenges for the Romanian Economy Conference, Romania. 4, 1509-1514.
Sansone, N., Cesareni, D. & Ligorio, M. (2016). The Trialogical Learning Approach to innovate teaching. Italian Journal of
Educational Technology, 24(2), 82.
Seref, M. & Ahuja, R. (2008) Spreadsheet-Based Decision Support Systems. In: Handbook on Decision Support Systems 1.
International Handbooks, Information System. Springer, Berlin, Heidelberg.
Stair, R. & Reynolds, G. (2010). Information Systems (9th Edition). Cengage, Canada.
Stefanova, S. & Vasileva, T. (2014). Trialogical Approach to Knowledge Practices in CAD Education. Annual Journal of
Electronics, 8. 150-153.
Tammeorg, P., Mykkanen, A., Rantamaki, T., Lakkala, M. & Muukonen, H. (2019). Improving Group Work Practices in
Teaching Life Sciences: Trialogical Learning. Res Sci Educ. 49, 809–828. DOI:10.1007/s11165-017-9649-8.
Turban, E., Aronson, J. E, Liang T. P. & Sharda, R. (2007). Decision Support and Business Intelligence Systems (8th Edition).
Pearson Education, Inc New Jersey, USA.
Urtis, T. (2011). Excel VBA 24 hour Trainer. John Wiley Publishing, Inc., Indianapolis, Indiana.
Published
2020-06-22
How to Cite
Kamaruddin, M. (2020). Trialogical Model in Data Analysis Using Spreadsheet. Journal of ICT in Education, 7(2), 54-64. Retrieved from https://ejournal.upsi.edu.my/index.php/JICTIE/article/view/4573