• 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.

• Journal of KIISE:Software and Applications
• /
• v.30 no.11
• /
• pp.1102-1111
• /
• 2003

Spreadsheet is one of the most widely used programming tool because of its ease of use, however there have been few researches on applying object-oriented techniques in developing spreadsheet applications. Generally, spreadsheet applications contain a lot of errors, and spreadsheet has some drawbacks such as low reusability and hard maintenance. In order to solve these problems, we introduce an object-oriented spreadsheet system, named XCEL. It enables users to develop applications using systematic techniques with data modelling method, and allows users to apply object-oriented technologies to spreadsheet programming. The data modelling method allows to define classes using XML and flowchart, and the spreadsheet represents an object with contiguous cells. XCEL has advantage that users can apply object-oriented technology to spreadsheet programming.

• 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 참고문헌, 매체자료들도 함께 제공하였다.

• Proceedings of the Korean Information Science Society Conference
• /
• 2008.06c
• /
• pp.21-25
• /
• 2008

온라인 분석 처리(On-Line Analytical Processing: OLAP)은 데이터 웨어하우스로부터 다차원 데이터를 분석하거나 의사 결정을 위한 유용한 정보를 제공하고 있다. 데이터 분석을 위해, OLAP에서는 다차원 데이터를 표현한 스프레드시트(spreadsheet) 또는 피벗 테이블(PIVOT table)을 널리 사용하고 있다. 스프레드시트와 피벗 테이블은 서로 유사한 형태로써 분석의 기준이 되는 애트리뷰트들이 많은 구조이다. 사용자들은 흔히 사용되고 있는 SQL 구문을 이용하여 스프레드시트 또는 피벗 테이블에서 손쉬운 데이터 분석을 요구한다. 그러나, RDBMS에서 제공하는 SQL 구문의 사용으로, 이는 다차원 데이터를 효과적으로 분석할 수 없다. 그 이유는 SQL 구문이 다양한 데이터 분석의 목적으로 사용되거나, 요약된 집계 정보를 도출하는 데 한계가 있기 때문이다. 따라서, 본 연구에서는 SQL 구문을 확장하여 다차원 데이터를 표현한 스프레드시트를 손쉽게 조작하고, 요약된 집계를 계산하는 셀(cell) 구문을 제안한다. 이 방법은 스프레드시트와 피벗 테이블에서 행과 열이 교차하는 좌표(coordinate)를 이용하여, 특정 셀의 조작 및 선택한 부분/전체 영역에 대한 집계 정보를 계산하는 방법이다. 결과적으로, RDBMS에서 사용되는 SQL 구문이 친숙한 사용자들이 제안한 셀 구문을 이용하면, 다양한 관점에 따라 손쉽게 스프레드시트와 피벗 테이블을 다룰 수 있을 것으로 사료된다.

• Journal of ILASS-Korea
• /
• v.12 no.4
• /
• pp.198-203
• /
• 2007

In the present work, surface wetting effect on spread-splash regime and transition criterion of the water and ethanol droplets impacting an unheated dry wall has been experimentally investigated. The droplet was directed on a polished STS plate and a glass slide, and the impinging behavior was visualized and recorded using a CCD camera. Droplet diameter and velocity approaching the wall were measured as well. The critical Sommerfeld number representing the spread-splash boundary for the ethanol droplet impinging on the substrates turned out to be smaller compared to that for the water droplet impinging on the substrates with the surface roughness condition remained unchanged. The shift of the transition boundary is considered to be due to the effect of the surface wettability represented by static contact angle and surface tension of droplet.

• Proceedings of the KSME Conference
• /
• 2007.05b
• /
• pp.2067-2072
• /
• 2007

Understanding of the impinging behavior of an electrically charged spray is essential in determining appropriate operating conditions for electro-spraying of paints, surface coating materials and insecticides. In the present work, as an initial step, the wall impact of an electrically charged droplet has been experimentally investigated. The charged drops were directed on the surface of a paraffin wax, and the impinging behavior was visualized and recorded using a CCD camera to identify the impingement regime. The spread-rebound boundary for the charged drop turned out to be smaller compared to that for an electrically neutral droplet under the same surface condition. The shift of the transition criterion is considered to be due to the discrepancy between the maximum spread ratio of the electrically charged droplet and that of the neutral droplet.

• Proceedings of the KSME Conference
• /
• 2008.11b
• /
• pp.2995-3000
• /
• 2008

Understanding of the impinging behavior of an electrically charged spray is essential in determining appropriate operating conditions for electro-spraying of paints, surface coating materials and insecticides. In the present work, the wall impact behavior of an electrically charged drop has been investigated and compared with that of a neutral drop experimentally. The critical Sommerfeld number representing the spread-splash boundary for the charged drop impacting on the dielectric substrate turned out to be larger compared to that for the neutral drop with the same surface condition. The change of the transition boundary is due to the increase in the surface wettability of the drop on the substrate. However, with the electrically conducting substrates, the charging effect on the transition boundary appeared negligible. This is because the electric discharging time is much shorter than the time required for the flattened drop to reach its maximum extent.

• The Korean Journal of Financial Management
• /
• v.27 no.1
• /
• pp.181-208
• /
• 2010

In July 2007, Korean government has passed "The Capital Market and Financial Investment Services Act" to further develop the capital markets and the Act was to become effective in February 2009. Using a large sample of Korean firms, we have examined (i) the effect of underwriting activities on the firm value (bond spread) comparing commercial bank and investment bank, and (ii) the determinants of the firm value changes following underwriting activities of bank. To test our goal, we collected a wide range of samples of data for bond issuing activities executed by Korean firms listed on the Korea Stock Exchange (KSE) between 2000 and 2003. Our paper is distinguished from previous studies on this subject in a way that we analyzed the effect of corporate bond underwriting activities with regard to commercial banking and investment banking. Initially, we set up a hypothesis that "Certification View" and "Conflict-of-interest View" are major driving forces behind cross-firm differences in performance following bond issuance. We find that, in general, underwriting by investment bank (securities company) brings a positive effect on the firm value (spread between bench mark rate and bond issuing rate). This result indicates that firm value has been negatively affected by the bank underwriting and provides the evidence for "Conflict-of-interest View" in Korea. Our studies have also revealed that any change in firm value following bond issuance is positively related with the firm size (total asset), operating performance, liquidity (cashflow), and equity ownership by foreign investors. Overall, our results support the view that bank underwriting activities can play an important role in determining firm value and financial strategies under "The Capital Market and Financial Investment Services Act" of 2007.

• Journal of Korea Society of Industrial Information Systems
• /
• v.28 no.2
• /
• pp.11-19
• /
• 2023

In this paper, we propose the methods of invoice document structure recognition and of making a spreadsheet electronic document. The texts and block location information of word blocks are recognized by an optical character recognition engine through deep learning. The word blocks on the same row and same column are found through their coordinates. The document area is divided through arrangement information of the word blocks. The character recognition result is inputted in the spreadsheet based on the document structure. In simulation result, the item placement through the proposed method shows an average accuracy of 92.30%.

• Journal of the Korea Computer Industry Society
• /
• v.3 no.8
• /
• pp.1007-1018
• /
• 2002

A systematic and multi-dimensional analysis in evaluation results may play a role of providing both learners and instructors with essential information. Conventional types of evaluation research have a tendency of partiality for developing evaluation tools, and analyzing the evaluation results has mostly been fragmentary and a one-dimensional analysis. In this study, through analyzing evaluation results in a multi-dimensional way, a multi-dimensional evaluation result analyzing system was developed for the purpose of providing various information for both learners and instructors to accomplish quality learning teaching. Dimensions are classified into four dimensions including period, student, difficulty degree, and evaluation domain. Analysis results are presented in various types of Dcube, graphs, and spreadsheets.