Desain Pembelajaran Penyajian Data Berbasis Konteks Ukuran Sepatu melalui Problem Based Learning dan Microsoft Excel

Abstract

This study addresses the persistent challenges in students' understanding of data presentation in statistics, as evidenced by consistently low achievement levels in national mathematics assessments and daily tests at MTS Al-Fakhriyyah. To bridge the gap between abstract statistical concepts and students’ real-life experiences, a contextualized instructional design was developed using shoe size data within a problem-based learning framework supported by Microsoft Excel. The research employed a design research methodology, encompassing preliminary analysis, iterative pilot and teaching experiments, and retrospective analysis to refine a hypothetical learning trajectory and establish a local instruction theory. Data were collected through classroom observations, interviews, video recordings, and written assessments involving grade VII students. Findings indicate that integrating real-world contexts and technology significantly enhances students’ engagement, understanding, and operational skills in presenting data as tables, percentages, and pie charts. The revised instructional materials, especially the student worksheets with detailed Excel guidance, effectively addressed procedural difficulties, resulting in a marked improvement in learning outcomes—from an average achievement of 90.67% in the pilot phase to 93.82% in the teaching experiment. The study demonstrates that a contextual and technology-assisted problem-based learning model not only facilitates meaningful learning but also develops students’ digital competencies, offering a replicable approach for mathematics educators. This innovative design is recommended for broader implementation and further exploration across various mathematical topics and educational settings to foster adaptive, high-level mathematical skills in the digital era.