스프레드시트 환경에서 모델링 활동을 통한 수학적 발견과 정당화 = Mathematical Discovery and Justification through Modeling Activity in Spreadsheet Environment

다국어 초록 (Multilingual Abstract)

The purpose of this study is to explore the mathematical discovery and justification of six 10th grade students through mathe- matical modeling activities in spreadsheet environments. The students investigated pro- blem 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 for- mulas, 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 mathe-matical 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 the scroll bars. The spreadsheet environ- ments also help students to justify their findings deductively and convince them that their findings are true by checking various cases of the problem situations.

국문 초록 (Abstract)

스프레드시트는 표, 그래프 기능 그리고 셀 참조 기능을 가지고 있고, 이러한 기능은 모델링 활동에서 중요한 역할을 한다. 이 글에서는 스프레드시트를 활용한 수학적 모델링 활동에서의 수학적 규칙의 발견과 이의 정당화 과정을 알아보고자 한다. 이를 위해 스프레드시트 환경이 특정 문제 상황의 해결에 어떻게 도움을 주는지 알아보고, 어떻게 특정한 문제 상황을 일반적인 문제 상황으로 바꿀 수 있도록 하는지를 알아본다. 또한 문제 상황 속에 내재하는 수학적 규칙의 발견에 이르는 과정을 알아보고, 발견한 규칙의 정당화 유형과 스프레드시트가 정당화에 어떤 영향을 미치는지를 알아본다.

참고문헌 (Reference)

1 "The active modeler: Mathematical modeling with Microsoft Excel" Brooks Cole publishing company 2004

2 "The Art of Modeling with Spreadsheets" Inc 2004

3 "Spreadsheets in Mathe- matical Education" 25 (25): 1994

4 "Spreadsheet use in an elementary statistics course" Columbia University Teachers College 2001

5 "Spreadsheet generalizing and paper and pencil generalizing, Proceedings of the 28th conference of the International Group for the Psychology of Mathematics Edu- cation" 4 : 441-448, 2004

6 "Spreadsheet fluid dyna- mics for aeronautical course problems" 17 (17): 294-311, 2001

7 "Spread- sheets in education-the first 25 Years" 1 (1): 18-43, 2003

8 "Principles and standards for school mathematics" 2000

9 "Mathematics curriculum development for computerized environ-ments: A designer-researcher-teacher -learner activity, Handbook of International Research in Mathematics Education. (pp. 657-694)" 657-694, 2002

10 "Mathematics as an educational task" 1973

11 "Mathematical modelling: The interaction of culture and practice" 39 : 167-183, 1999

12 "How to use the spreadsheet as a tool in the secondary school mathematics classroom National Council of Teachers of Mathe- matics" 1990

13 "How spreadsheets can aid a variety of mathematical learning activities from primary to tertiary level Technology in mathematics teaching A bridge between teaching and learning" 117-124, 1993

14 "Cognitive processes in a spreadsheet environment, Proceedings of the 23rd conference of the International Group for the Psychology of Mathematics Education" 2 : 337-344, 1999

15 "Asking and answering all sorts of scientific questions using spreadsheets" 77 : 43-53, 1996

16 "Applications and modelling in learning and teaching mathematics" 1989

17 "An excellent bridge to algebra" 91 (91): 382-383, 1998

18 "A spreadsheet approach to solving algebra problems Journal of Mathematical be- havior" & roja : 353-383, 1993