• Title/Summary/Keyword: 스프레드시트 활용 수업

Search Result 8, Processing Time 0.02 seconds

The Study on Using Spreadsheet in Probability and Statistics Area of High School (고등학교 확률 통계 영역에서 스프레드시트 활용에 대한 연구)

  • Lee, Jong-Hak
    • School Mathematics
    • /
    • v.13 no.3
    • /
    • pp.363-384
    • /
    • 2011
  • This study is based on the recognition that the school mathematics education should reinforce the heuristic and constructional aspects related with discoveries of mathematical rules and understanding of mathematical concepts from real world situations as well as the deductive and formal aspects emphasizing on mathematical contents precisely. The 11th grade students of one class from a city high school with average were chosen. They were given time to learn various functions of Excel in regular classes of "Information Society and Computer" subject. They don't have difficulty using cells, mathematical functions and statistical functions in spreadsheet. Experiment was performed for six weeks and there were two hours of classes in a week. Considering the results of this research, teaching materials using spreadsheets play an important role in helping students to experience probabilistic and statistical reasoning and construct mathematical thinking. This implies that teaching materials using spreadsheet provide students with an opportunity to interact with probabilistic and statistical situations by adopting engineering which can encourage students to observe and experience various aspects of real world in authentic situations.

  • PDF

On Exploring the Properties of Pythagorean Triples Using Spreadsheets (스프레드시트를 활용한 피타고라스 삼원수 성질의 탐구)

  • Son, Hong-Chan
    • Communications of Mathematical Education
    • /
    • v.25 no.1
    • /
    • pp.147-166
    • /
    • 2011
  • In this paper, we listed and discussed the properties of the Pythagorean triples which 5 gifted 9th graders could draw in spreadsheets environments. And we also discussed their implications. In detail, in spreadsheets environments students could make the table of Pythagorean triples easily under several conditions of generate numbers of Pythagorean triples. And they could draw several properties of Pythagorean triples from the tables and could prove them. In spreadsheets environments it is easy to give students chances of generalization of the properties of Pythagorean triples which they had obtained from the concrete table of Pythagorean triples.

A Study on Teaching and Learning using Spreadsheet in ICT-applied Elementary School Math. Education (초등학교 수학과 ICT 활용 교육에서 스프레드시트를 활용한 교수-학습에 관한 연구)

  • Kim, Jung-Hwan;Gu, Jung-Mo;Han, Byoung-Rae
    • Journal of The Korean Association of Information Education
    • /
    • v.13 no.3
    • /
    • pp.325-339
    • /
    • 2009
  • Many current researches are limited in the statistics field, which is a part of mathematics class in the secondary school. Moreover, it's hard to apply to the elementary school since they are written in English. To overcome this limitations, the objectives from the unit that is suitable for using EXCEL in the elementary mathematics lessons are selected in this research. And a problem-based learning model for these lessons would be introduced that it can help students to focus on solving substances of the problems by reducing the time for arithmetic calculation.

  • PDF

The Effect of Education Data Visualization using Google Spreadsheet Program on improvement of creativity of Forth and Fifth Grade Students (구글 스프레드시트를 활용한 데이터 시각화 교육이 초등학교 4·5학년 학생의 창의성 향상에 미치는 효과)

  • Kim, Jungah;Kim, Minbum;Kim, Taehun;Kim, Yongmin;Kim, Jonghoon
    • Journal of The Korean Association of Information Education
    • /
    • v.23 no.4
    • /
    • pp.293-302
    • /
    • 2019
  • In this study, we developed the google spreadsheet education program which focuses on the education data visualization. And we applied it to forth and fifth grade students, and then verified its effect. The developed program was applied to 29 forth and fifth grade students for 36 classes in six days. Application of the program In order to verify the effect on creativity, Torrance Tests of Creative Thinking Figures A and B were introduced and pretests and post tests were carried out. As a result of the verification, it was found that the google spreadsheet education program which focuses on the education data visualization has positive effects on the creativity factors of the elementary school forth and fifth grade students.

Effect of data science education program using spreadsheet on improvement of elementary school computational thinking (스프레드시트를 활용한 데이터 과학 교육 프로그램이 초등학생의 컴퓨팅 사고력 향상에 미치는 효과)

  • Kim, Yongmin;Kim, Jonghoon
    • Journal of The Korean Association of Information Education
    • /
    • v.21 no.2
    • /
    • pp.219-230
    • /
    • 2017
  • In this study, we developed a data science education program using spreadsheet, applied it after educational method to improve elementary school student 's Computational Thinking, and then verified its effect. Based on the results of preliminary requirement analysis conducted by Rossett's request analysis the educational program was developed based on the procedure of the ADDIE model which is the representative model of the teaching design based on the result of prior requirement analysis of 205 elementary school students and computer teaching major 20 incumbent elementary school teachers, applying Rossett's requirement analysis model. In order to verify the effect of the developed educational program, we are promoting 42 hours of lecture for a total of 6 days for 20 students of applicants who volunteered for volunteer votes of educational donation programs implemented at ${\bigcirc}{\bigcirc}$University, We analyzed the educational effect using the results of pre-post test. As a result of the analysis, we learned that the educational program developed in this study is effective for improving elementary school student 's Computational Thinking.

Effects of Spreadsheet-used Instruction on Statistical Thinking and Attitude (스프래드시트를 활용한 수엽이 통계적 사고 및 태도에 미치는 효과)

  • Lee, Jong-Hak;Kim, Won-Kyoung
    • The Mathematical Education
    • /
    • v.50 no.2
    • /
    • pp.185-212
    • /
    • 2011
  • The purpose of this study is to analyze whether spreadsheet-used instruction can improve statistical thinking ability and attitude and also to identify what characteristics of statistical thinking is constructed. For this study, a subject of 2 classes were randomly selected among the 12 classes of the 11th grader in D high school and designated one class as the experimental group and the other class as the control group. Eight hours of the spread sheet-used instruction and the traditional textbook-oriented instruction had been carried out in each class. The research findings are as follows. First, the spread sheet-used instruction is shown to be more effective in enhancing statistical thinking than the traditional textbook-oriented instruction. Second, the spread sheet-used instruction is shown to be more effective in improving statistical attitude than the traditional textbook-oriented instruction. Third, students have shown the various characteristics of statistical thinking in the data descriptive process, data arrange-summary process, data representing process, and data analying process through the spread sheet-used instructions. Hence, the spread sheet-used instruction is recommended in teaching statistics.

Comparative Analysis of Influential Factors on Computer-Based Mathematics Assessment between Korea and Singapore (우리나라와 싱가포르의 컴퓨터 기반 수학 평가 결과에 대한 영향 요인 비교 분석)

  • Rim, Haemee;Jung, Hyekyun
    • Journal of Educational Research in Mathematics
    • /
    • v.27 no.2
    • /
    • pp.157-170
    • /
    • 2017
  • Mathematics was the main domain of PISA 2012, and both paper-based and computer-based assessment of mathematics (CBAM) were conducted. PISA 2012 was the first large-scale computer-based mathematics assessment in Korea, and it is meaningful in that it evaluated students' mathematical literacy in problem situations using dynamic geometry, graph, and spreadsheet. Although Korea ranked third in CBAM, the use of ICT in mathematics lessons appeared to be low. On the other hand, this study focused on Singapore, which ranked first in CBAM. The Singapore Ministry of Education developed online programs such as AlgeTools and AlgeDisc, and implemented the programs in classes by specifying them in mathematics curriculum and textbooks. Thus, this study investigated influential factors on computer-based assessment of mathematics by comparing the results of Korea and Singapore, and aimed to provide meaningful evidence on the direction of Korea's ICT-based mathematics education. The results showed that ICT use at home for school related tasks, attitudes towards computers as a tool for school learning, and openness and perseverance of problem solving were positively associated with computer-based mathematics performance, whereas the use of ICT in mathematics class by teacher demonstration was negatively related. Efforts are needed to improve computer use and enhance teaching techniques related to ICT use in Korean math classes. Future research is recommended to examine how effectively teachers use ICT in mathematics class in Singapore.

그래프 마법사와 함수교육

  • Ryu, Jae-Gu
    • Communications of Mathematical Education
    • /
    • v.10
    • /
    • pp.519-528
    • /
    • 2000
  • 최근 10 여년 동안 교육 현장의 각 부분에 여러 가지 종류의 테크놀로지가 도입되면서, 교육의 내용과 방법에 있어서 점진적인 변화가 나타나고 있다. 예를들어, 수학 과목에 있어서는 그래픽 계산기, 도형 및 기하 학습 프로그램, 스프레드 시트, 함수 그래픽 프로그램 등의 도입으로 교과 과정 전반에 걸친 변화가 일고 있는데, 처음에는 이들 테크놀로지가 단순히 기존의 수업에서 수많은 반복을 요하거나, 지필식 방식으로는 정확하게 나타내기 어려운 도형이나 그래프를 빠르고 정확하게 그려내주는 보조수단으로 사용되었지만, 시간이 지나면서 이들 테크놀로지에 대한 활용도가 높아지게 되고, 이들 테크놀로지에 대한 교사들의 활용능력이 증대됨에 다라서, 이러한 테크놀로지가 단순한 보조수단에 머무르지 않고 주지에 기술이나 개념을 설명하는 방법 자체를 변화시키고 있다. 예를들어, 함수 교육에 있어서 그래픽 프로그램이 사용될 때에도, 초기 단계에서는 이들 함수의 개념을 설명할 때에는 거의 집합론이나 대수학적인 방법을 이용하였고, 최종 단계로 이들 함수를 좌표계 위에 표현하기 위한 보조수단으로 잠깐씩 사용되는 경우가 대부분이었으나, 최근들어서는 함수 학습의 초기과정부터 곧바로 이들 그래프 프로그램을 적극적으로 도입하여 학습자로 하여금 다양한 그래프 조작을 하게 함으로써, 어려운 집합론이나 대수학적인 개념을 도입하지 않고서도 함수에 대한 개념을 시각적으로 직관적으로 파악하도록 하는 학습 방안들이 제시되고 있는 것이다. 본 고에서는 현행 중고등학교 함수 교육 과정에서 그래프에 대한 다양한 조작 기능을 제공함으로써 학습자로 하여금, 제시되는 함수에 대한 시각적이고 직관적인 이미지를 가질 수 있도록 하기 위해서 개발된 ‘그래프 마법사’라는 프로그램을 소개하고자 한다.

  • PDF