DEVELOPING OF COMPUTATIONAL THINKING SKILLS USING STEM-PROBLEM BASED LEARNING WITH FORMULA CODING USING MICROSOFT EXCEL IN TOPIC OF SOLUTION FOR 10TH GRADE STUDENTS

Abstract

This action research aimed to (1) study guidelines of a learning management approach using STEM problem-based learning integrated with formula coding via Microsoft Excel on the topic of solutions for Grade 10th students, and (2) study the effects of this approach on students' computational thinking skills. The target group in this research was 40 Grade 10th students. Research instruments included lesson plans, reflective learning management records, a computational thinking (CT) skills test, and student activity logs. Qualitative data were analyzed using content analysis, and data reliability was ensured through triangulation of data sources and collection methods.The research findings revealed that the guidelines of the learning management approach using STEM problem-based learning integrated with formula coding via Microsoft Excel on the topic of solutions involved the several stages. In the problem confirmation stage, teachers should use the issues of chemical residues in agriculture and break them down into sub-problems. In the problem clarification stage, similar cases should be analyzed to identify critical components for problem-solving. The planning stage should involve designing problem-solving algorithms integrated with STEM and formula coding using Microsoft Excel. The evaluation stage is the most appropriate solution. After the intervention, students’ CT skills improved from a fair level to a good level.