스프레드시트는 표, 그래프 기능 그리고 셀 참조 기능을 가지고 있고, 이러한 기능은 모델링 활동에서 중요한 역할을 한다. 이 글에서는 스프레드시트를 활용한 수학적 모델링 활동에서의 수학적 규칙의 발견과 이의 정당화 과정을 알아보고자 한다. 이를 위해 스프레드시트 환경이 특정 문제 상황의 해결에 어떻게 도움을 주는 지 알아보고, 어떻게 특정한 문제 상황을 일반적인 문제 상황으로 바꿀 수 있도록 하는지를 알아본다. 또한 문제 상황 속에 내재하는 수학적 규칙의 발견에 이르는 과정을 알아보고, 발견한 규칙의 정당화 유형과 스프레드시트가 정당화에 어떤 영향을 미치는지를 알아본다.
The Purpose of this study is to explore he mathematical discovery and justification of six 10th grade students through mathematical modeling activities in spreadsheet environments. The students investigated problem situations with a spreadsheet, which seem to be difficult to solve in paper and pencil environment. In spreadsheet environments, it is easy for students to form a data table and graph by inputting and copying spreadsheet formulas, and to make change specific variable by making a scroll bar. In this study those functions of spreadsheet play an important role in discovery and justification of mathematical rules which underlie in the problem situations. In modeling activities, the students could solve the problem situations and find the mathematical rules by using those functions of spreadsheets. They used two types of trial and error strategies to find the rules. The first type was to insert rows between two adjacent rows and the second was to make scroll bars connecting specific variable and change the variable by moving he scroll bars. The spreadsheet environments also help students to justify their findings deductively and convince them that their findings are true by checking various cases of the Problem situations.
