The Effects on Problem Solving of Linear Function Using Excel

엑셀의 활용이 일차함수 문제해결에 미치는 효과

The purpose of this study is to search an effective teaching & learning program by examining how much does Excel affect on problem solving of linear function. This study was based on qualitative case study. Teaching experiment was performed for seven periods with five students in 8th graders. Pre and posts tests were attempted to analyze the changes of student's ability on problem solving of linear function. The analysis of tests were performed in category with correct process-object perspective, near process-object perspective, incorrect process-object perspective. According to this study, the subjects showed an improvement on problem solving perspective of linear function. This meant that lessons using Excel had influenced on the problem solving of linear function. We noticed that exploring the learning environment with Excel could supplement paper-and-pencil environment. We believed that Excel with an intuitive dynamic and explorative skills can play a role in scaffolding to support problem solving of linear function.

본 연구의 목적은 엑셀의 활용이 일차함수의 문제해결에 어떤 영향을 미치는가를 알아보는데 있다. 엑셀을 활용한 교수실험 전과 후에 학생들의 함수에 관한 문제해결에서의 변화를 알아보기 위해 사전 사후 문제해결검사를 실시하였다. 문제해결검사 분석은 정확한 과정-대상관점, 근접한 과정-대상관점, 부정확한 과정-대상관점으로 범주화해 이루어졌다. 문제해결검사 분석 결과, 교수실험에 참여한 학생들 모두 일차함수에 관한 문제해결관점이 바람직한 방향으로 변화되었다. 엑셀을 활용한 탐구학습환경이 지필환경의 제한점을 보완할 수 있다는 시사점을 도출하였다.