• Journal of the Korean School Mathematics Society
• /
• v.15 no.4
• /
• pp.643-671
• /
• 2012

The purpose of this study was to examine How the exploratory activities using Excel and GSP which are exploratory software, in learning analytic geometry affected on the underachievers' analytic geometry concept development process. The subjects of 5 students who received the 8th~9th grades from their examination of the last semester, participated in a total of 7 units based on Skemp's intelligent learning model. The results of the study showed that there were two important cases found to nearly achieve the category $R_2$. One was reflective thinking could happen through exploratory software in category $R_1$. The other was the exploratory activities which could have the same effectiveness as the relational understanding in category $I_2$, as Skemp mentioned that there is a room to be achieved in the elementary level when such relational understanding is achieved.

• Proceedings of the Korea Society of Mathematical Education Conference
• /
• 2006.04a
• /
• pp.25-37
• /
• 2006

영재를 위한 수학교육은 우리의 당면과제 중 하나이다. 능력 있는 학생들의 학습이 속진에 한정되는 것 보다는 심화자료 및 수학적 소프트웨어와 함께 하는 것이 더 의미 있을 것으로 기대된다. 본 연구는 스프레트쉬트를 사용한 수학적 아이디어의 탐구에 관한 것이다. 다음에 대해 논의하기로 하겠다. i) 스프레드쉬트는 비전통적이면서도 이용이 용이하며, 수학적 통찰을 위한 매개물이다. ii) 풍부하고, 흥미릅고, 가치있는 수학적 주제에 대해 스프레드쉬트를 이용할 수 있다. iii) 스프레드쉬트를 사용하여 학생들이 수학적 아이디어에 대한 흥미를 고취시킬 수 있다. iv) 스프레드쉬트는 학생들에게 그들의 창의적인 시각화 기술을 공개할 기회를 줌으로써 수학에 대한 폭넓은 도식적 이해를 제공한다. v) animation을 포함한 스프레드쉬트 도식들의 적절한 사용은 유익하면서도 흥미롭다. vi) 학생들은 일상생활에 나타나는 수학의 흥미로움을 발견할 것이다. vii) 교사는 지금의 지도방식에 스프레드쉬트를 통합할 수 있다. 특히 스프레드쉬트는 다음과 같은 면모도 가지고 있다. i) 창의적인 수학적 스프레드쉬트 모델들의 실제 과정들이 그 자체로써 수학적 개념발달에 이용될수 있다. ii) 스프레드쉬트 모델은 심화된 주제의 탐색을 위한 의미 있는 탐구과제를 제공한다. iii) 스프레드쉬트는 현장에서 사용되는 실제적 수학 도구이다. - 과학자나 공학도들의 사용도 증가되고 있다. 이것의 사용은 학생들이 현장에서 사용할 기술을 취득하게 할 수 있고, 같은 컴퓨터의 소프트웨어를 사용하는 가족의 대화 수단이 되기도 한다. 본 연구에서 우리는 스프레드쉬트의 4가지 실증적 예를 들어 보겠다. 또한 다른 영역에서 발전된 스프레드쉬트 모델의 몇 가지 도식적 산출물도 포함 할 것이다. 우리는 가장 대중적인 스프레드 쉬트인 Microsoft Excel 프로그램을 사용하였다. Excel의 수행과 Excel 연산의 설명을 담은 CD와 함께 다양한 사례들에 대한 논의는 (8)을 참고하기 바란다. 본고에서는 graphic animation 기술, 스크롤바의 사용을 간단하게 개괄하겠다. '동적형상들(movies)'를 만들 수 있는 간단한 매크로의 사용 등의 내용들은 각 자료를 사용할 수 있는 Excel 파일의 예와 함께 [1]과 [8]에 설명하였었다. 많은 인쇄물과 on-line 참고문헌, 매체자료들도 함께 제공하였다.

• Journal of the Korea Institute of Information and Communication Engineering
• /
• v.23 no.9
• /
• pp.1173-1178
• /
• 2019

In this paper, we design a security management application module for an Excel VBA password file. You will set a password for the important VBA program file. If this password is lost, you set a new password. If you forgot the password after setting the password in the Excel VBA file, you will not be able to change the VBA source code. In this paper, we design a function to modify VBA file passwords conveniently. The VBA password modification module extracts VBA files from Excel files. The password can be modified by modifying specific field information in the extracted VBA program file. This allows you to modify the password for the VBA program file. The experiments were performed by implementing the contents proposed in this paper. As a result of the experiment, we can confirm that the password can be used by modifying the VBA file password.

• Journal of the Korean Data and Information Science Society
• /
• v.24 no.3
• /
• pp.593-601
• /
• 2013

We often need to include categorial variables as explanatory variables in regression models. The categorial variables in regression models can be quantified through dummy variables. In this study, we provide an education tool using Excel VBA for displaying regression lines along with test results for regression models with a continuous explanatory variable and one or two categorical explanatory variables. The regression lines with test results are provided step by step for the model(s) with interaction(s), the model(s) without interaction(s) but with dummy variables, and the model without dummy variable(s). With this tool, we can easily understand the meaning of dummy variables and interaction effect through graphics and further decide which model is more suited to the data on hand.

• Korean Journal of Materials Research
• /
• v.27 no.3
• /
• pp.172-178
• /
• 2017

The aim of this study is to consider the effect hydrogen on dezincification behavior of Cu-Zn alloys. The investigations include microstructural observations with scanning electron microscope and chemical composition analysis with energy dispersive spectrometer. The dezincification layer was found to occur in high pressure hydrogen atmosphere, not in air atmosphere. In addition, the layers penetrated into the inner side along the grain boundaries in the case of hydrogen condition. The shape of the dezincification layers was porous because of Zn dissolution from the ${\alpha}$ or ${\beta}$ phase. In the case of stress corrosion cracks formed in the Cu-Zn microstructure, the dezincification phenomenon with porous voids was also accompanied by grain boundary cracking.

• Proceedings of the Korean Institute of Information and Commucation Sciences Conference
• /
• 2013.10a
• /
• pp.671-674
• /
• 2013

In this paper, we propose an efficient data search system using data partitioning algorithm in Microsoft Excel. We propose to retrieve the data quickly using VBA functioning Excel. This algorithm is to specify the sheet you are looking for. Once the sheet is specified, it searches the beginning and the end of the data in the sheet. It compares desired key words and intermediate values, starting from the position of the cell. In this way, it will search data to the end. This proposed algorithm was implemented and tested using actual VBA program. The experimental results showed that the performance was more excellent than that of the conventional search method.

• Journal of the Korea Institute of Information and Communication Engineering
• /
• v.12 no.10
• /
• pp.1815-1821
• /
• 2008

Recently, Since growth of the ubiquitous computing environment and development of networking technology, User is a possible to connect the Internet out of constraints of time and space. Using RFID of core technique of ubiquitous computing, various application cases are increasing rapidly. In this paper, we propose design of the User-Centered Document Generation System which can makes several format of documents using RFID information stored in relational database. Our system can makes HTML file, EXCEL file and XML document file that provide for users over internet. Also, whenever user need to the document that can save easy and conveniently them on local computer and then is a possible to exploit them for other works.

• Water for future
• /
• v.41 no.1
• /
• pp.51-60
• /
• 2008

• The Proceedings of the Korean Institute of Illuminating and Electrical Installation Engineers
• /
• v.15 no.6
• /
• pp.9-13
• /
• 2001

• Water for future
• /
• v.41 no.3
• /
• pp.54-64
• /
• 2008