Innovative and effective spreadsheet tool for learning sentiment analysis and prediction

• Main Authors: CHEONG, Michelle L. F., CHEN, Jean Yun-Chen
• Format: text
• Language: English
• Published: Institutional Knowledge at Singapore Management University 2022
• Subjects: Sentiment analysis and prediction; spreadsheet tool; less technically inclined students; Databases and Information Systems; Educational Assessment, Evaluation, and Research; Numerical Analysis and Scientific Computing
• Online Access: https://ink.library.smu.edu.sg/sis_research/7594; https://ink.library.smu.edu.sg/context/sis_research/article/8597/viewcontent/ICCE2022_ExcelTool_pvoa.pdf
• Institution: Singapore Management University

In this paper, we describe a spreadsheet tool which was developed and implemented to teach sentiment analysis and prediction to university students who are less technically inclined. We adopted the “Use-Modify-Create” cycle to ensure that the students learn the computing concepts and practices in a progressive and active learning manner, and we evaluated the effectiveness of the tool using the Learning Object Evaluation Scale for Students (LOES-S). The evaluation shows that our tool performed well in terms of quality, learn and engagement constructs, and our paired T-test shows strong evidence that, on average, the course module with the tool does lead to improvement in the students’ knowledge in sentiment analysis and prediction.