Trialogical model in data analysis using spreadsheet

Mahamsiatus Kamaruddin

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.

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