• 한국콘크리트학회:학술대회논문집
• /
• 한국콘크리트학회 2000년도 가을 학술발표회논문집(I)
• /
• pp.247-252
• /
• 2000

The practical computer program COL3 was developed through this study to design of arbitrarily shaped reinforced concrete slender columns subjected to combined compression and biaxial bending. The program COL3 has been developed for user-friendly environment using spreadsheets. Several examples including for analysis of geometrically complex column sections subjected biaxial bending are introduced in this paper.

• 한국콘크리트학회:학술대회논문집
• /
• 한국콘크리트학회 1998년도 가을 학술발표대회 논문집(III)
• /
• pp.627-632
• /
• 1998

This study developed practical computer program COL2 to design of generic shape reinforced concrete short columns subjected to combined compression and biaxial bending. The program COL2 has been developed for user-friendly environment using Excel 97 for windows 95. Several examples including for analysis of geometrically complex column sections subjected biaxial bending are included in this paper.

• 실천공학교육논문지
• /
• 제13권2호
• /
• pp.233-242
• /
• 2021

본 논문에서는 비전공자들을 위한 교양과정으로, 기초 인공신경망 과목 커리큘럼을 설계하기 위해, 지도학습 인공신경망 매개변수 최적화 방법과 활성화함수에 대한 기초 교육 방법을 제안하였다. 이를 위해, 프로그래밍 없이, 매개 변수 최적화 해를 스프레드시트로 찾는 방법을 적용하였다. 본 교육 방법을 통해, 인공신경망 동작 및 구현의 기초 원리 교육에 집중할 수 있다. 그리고, 스프레드시트의 시각화된 데이터를 통해 비전공자들의 관심과 교육 효과를 높일 수 있다. 제안한 내용은 인공뉴런과 Sigmoid, ReLU 활성화 함수, 지도학습데이터의 생성, 지도학습 인공신경망 구성과 매개변수 최적화, 스프레드시트를 이용한 지도학습 인공신경망 구현 및 성능 분석 그리고 교육 만족도 분석으로 구성되었다. 본 논문에서는 Sigmoid 뉴런 인공신경망과 ReLU 뉴런 인공신경망에 대해 음수허용 매개변수 최적화를 고려하여, 인공신경망 매개변수 최적화에 대한 네가지 성능분석결과를 교육하는 방법을 제안하고 교육 만족도 분석을 실시하였다.

• 대한안전경영과학회지
• /
• 제10권3호
• /
• pp.245-251
• /
• 2008

The research proposes three ANOVA(Analysis of Variance) tests using expected mean square(EMS) algorithms in various split-plot designs. The variance tests consist of Never-Pool test, Sometimes-Pool test and Always-Pool test. This paper also presents two EMS algorithms such as standard method and easy method. These algorithms are useful to make a decision rule for pooling. Numerical examples are illustrated for various split-plot designs such as split-plot designs, split-split-plot designs, repetition split-plot designs, and nested designs. Pragmatically, the results are summarized and compared with popular ANOVA spreadsheets and data model equations.

• 한국수학교육학회지시리즈A:수학교육
• /
• 제40권1호
• /
• pp.93-102
• /
• 2001

The world we live in is called the age of information. Thus communication and computers are doing the central role in it. When one studies the mathematical problem, the use of tools such as computers, calculators and technology is available for all students, and then students are actively engaged in reasoning, communicating, problem solving, and making connections with mathematics, between mathematics and other disciplines. The use of technology extends to include computer algebra systems, spreadsheets, dynamic geometry software and the Internet and help active learning of students by analyzing data and realizing mathematical models visually. In this paper, we explain concepts of transformation, linear transformation, congruence transformation and homothety, and introduce interesting, meaningful and visual models for teaching of a plane transformation geomeoy which are obtained by using Mathematica. Moreover, this study will show how to visualize linear transformation for student's better understanding in teaching a plane transformation geometry in classroom. New development of these kinds of teaching-learning methods can simulate student's curiosity about mathematics and their interest. Therefore these models will give teachers the active teaching and also give students the successful loaming for obtaining the concept of linear transformation.

• 정보교육학회논문지
• /
• 제25권3호
• /
• pp.459-469
• /
• 2021

본 논문에서는 현장 교사 및 예비교사를 위한 기초 데이터과학 실습 교육 사례를 연구하였다. 본 논문에서는 기초 데이터과학 교육을 위해, 스프레드시트 SW를 데이터 수집 및 분석 도구로 사용하였다. 이후 데이터 가공, 예측 가설 및 예측 모델 검증을 위한 통계학을 교육하였다. 또한, 수천명 단위의 공공 빅데이터를 수집 및 가공하고, 모집단 예측 가설 및 예측 모델을 검증하는 교육 사례를 제안하였다. 이와 같은 데이터과학의 기초 교육내용을 담아, 스프레드시트 도구를 활용한 34시간 17주 교육 과정을 제시하였다. 데이터 수집, 가공 및 분석을 위한 도구로서, 스프레드시트는 파이썬과 달리, 프로그래밍 언어 및 자료구조에 대한 학습 부담이 없고, 질적 데이터와 양적 데이터에 대한 가공 및 분석 이론을 시각적으로 습득할 수 있는 장점이 있다. 본 교육 사례 연구의 결과물로서, 세가지 예측 가설 검증 사례들을 제시하고 분석하였다. 첫 번째로, 양적 공공데이터를 수집하여 모집단의 그룹별 평균값 차이 예측 가설을 검증하였다. 두 번째로, 질적 공공데이터를 수집하여 모집단의 질적 데이터 내 연관성 예측 가설을 검증하였다. 세 번째로, 양적 공공데이터를 수집하여 모집단의 양적 데이터 내 상관성 예측 가설 검증에 따른 회귀 예측 모델을 검증하였다. 그리고 본 연구에서 제안한 교육 사례의 효과성을 검증하기 위해, 예비교사와 현장교사의 만족도분석을 실시하였다.

• 한국정보시스템학회지:정보시스템연구
• /
• 제20권1호
• /
• pp.107-126
• /
• 2011

Model-based decision support system (DSS) has acted as a crucial role in strengthening the business competitiveness by providing a way of modeling and solving real-world decision problems in a quantitative and scientific manner. It is even more important for trading OTC derivatives, which requires extensive financial-engineering expertise while actively reacting to the continuously changing financial market. This paper proposes a flexible model-based DSS architecture that can support user-friendly interface for executing and analyzing the models and can adapt to the changes of financial market seamlessly. For user-friendliness, we implement the user-interfaces (UIs) using Microsoft Excel, a very widely used spreadsheet program for its great generality and extensibility. Users can utilize the analysis results of DSS or reprocess them for their special needs through the UIs in the form of familiar spreadsheets easily. For adaptiveness to the markets, the proposed architecture is constructed based on the object-oriented concepts, which enables such changes as release of a new financial product can be updated into the system without any delay at the lowest cost. We investigate the practical benefits and limitations of the proposed architecture by a case study on the construction of Model-based Trading Support System (MTSS), performed by a commercial bank in Korea.

• 한국정보시스템학회지:정보시스템연구
• /
• 제5권
• /
• pp.21-41
• /
• 1996

Linear programming has become an important tool in decision-making of modern business management. This remarkable growth can be traced to the pioneering efforts of many individuals and research organizations. The popular using of personal computers make it very easy to process those complicated linear programming models. Furthermore advanced linear programming software packages assist us to solve L.P. models without any difficult process. Even though the advanced L.P. professional packages, the needs of more detailed deterministic elements for business decisions have forced us to apply dynamic approaches for more resonable solutions. For the purpose of these problems applying to the "Mathematica" packages which is composed of mathematic tools, the simplex processes show us the flexible and dynamic decision elements included to any other professional linear programming tools. Especially we need proper dynamic variables to analyze the shadow prices step by step. And applying SAS(Statistical Analysis System) packages to the L.P. problems, it is also one of the best way to get good solution. On the way trying to the other L.P. packages which are prepared for Spreadsheets i.e., MS-Excel, Lotus-123, Quatro etc. can be applied to linear programming models. But they are not so much useful for the problems. Calculating simplex tableau is an important method to interpret L.P. format for the optimal solution. In this paper we find out that the more detailed and efficient techniques to interpret useful software of mathematica and SAS for business decision making of linear programming. So it needs to apply more dynamic technique of using of Mathematica and SAS multiple software to get more efficient deterministic factors for the sophiscated L.P. solutions.

• Journal of Information Technology Applications and Management
• /
• 제17권1호
• /
• pp.11-33
• /
• 2010

The majority of graphs and visuals made publicly available by Thai listed companies tend to be disjointed and minimal. Only a little over fifty percent of the total 478 companies included graphic representations of their business operations and performance in the form of two or three dimensional spreadsheet based graphs in their annual reports, investor relations documents, websites and so on. For novice users, these visual representations are unlikely to give the big picture of what is the company's financial position and performance. Neither will they tell where the company stands in its own operating environment. The existing graphics and visuals, in very rare cases, can provide a sense of the company's future outlook. For boundary users such as audit committees whose duty is to promote good governance through transparency and disclosure, preliminary interview results show that there is some doubt as to whether the inclusion of big-picture visuals can really be of use to minority shareholders. These boundary users expect to see more insightful visuals beyond those produced by traditional spreadsheets which will enable them to learn to cope with the on-going turbulence in today's business environment more quickly. However, the debate is still going on as to where to draw the line between internal or external reporting visuals.

• 한국컴퓨터산업학회논문지
• /
• 제3권8호
• /
• pp.1007-1018
• /
• 2002

평가결과에 대한 과학적이고 다차원적인 분석은 학습자, 교수자에게 중요한 정보를 제공해 주는 역할을 한다. 기존의 평가관련 연구들이 평가도구 개발에 치우친 경향이 있고, 평가결과에 대한 분석은 단편적이고 일차원적인 분석이 대부분이었다. 본 연구에서는 평가결과를 다차원적으로 분석함으로써, 질 높은 교수학습이 이루어질 수 있도록 학습자 및 교수자에게 다양한 정보를 제공해 주는 데 목적을 두고 개발되었다. 차원은 기간, 학생, 평가영역, 난이도, 점수의 5차원으로 분류하였다. 분석결과는 Dcube. 그래프, 스프레드시트 등의 다양한 형태로 제공된다.