• 지식경영연구
• /
• 제13권2호
• /
• pp.37-52
• /
• 2012

A spreadsheet is a office automation software which has been widely used in almost all areas in business. A spreadsheet is used for calculation, data analysis, model building and so on. As a result, spreadsheet is a very important tool for generating knowlege in a firm. Errors in a spreadsheet model can cause a serious financial damage in a corporation. However in Korea few researches for reducing errors have been performed. Neither serious efforts to reduce errors have been executed by corporations. In this research we provided summarized the results from a survey for spreadsheet usage, summarized researches on errors in spreadsheet up to now, and suggested a rules and structured development method for reducing errors in a spreadsheet. Errors in spreadsheets are prevalent. To solve this serious problem, we need much more attention on this problem in research area. Corporations must put more efforts on setting policies and rules. And also we need the government's concern and support.

• 경영과학
• /
• 제19권2호
• /
• pp.41-58
• /
• 2002

New attempt has been made on Management Science (MS) education since the end of 1990s. The most distinctive feature of the new attempt is using spreadsheet program like Excel as a teaching tool for MS course. The spreadsheet program gives an excellent tool for modeling and solvina MS problems. In order to improve the pedagogical effect through using the spreadsheet program for MS course, new teaching model based on spreadsheet encompassing new course contents, effective instruction method, and examination method is needed. For this purpose, professors teaching MS should share their own teaching experiences and methods. So this paper explains remarkable functions of Excel and how to use them for the MS tools. This paper also stresses the importance of team project and case study to improve the effect of MS education through the use of Excel and presents some tips on MS education.

• 경영과학
• /
• 제22권2호
• /
• pp.1-12
• /
• 2005

New method has been widely used for teaching Management Science since the mid of 1990s. The new teaching method is distinguished from traditional method in several aspects. The mowt distintion of the new method is that Excel based approach is used in order to model and analyze quantitative problems. Due to the introduction of Excel based teaching method model formulation and interpretation is more emphasized than algorithms. By using this new method students are expected to be more interested in Management Science class and easily use several Management Science techniques in real world problems. Though Excel based teaching method has become more prevalent, there exist no empirical research to analyze the effectiveness of Excel based teaching method. This paper will empirically analyze how effective Excel based teaching method is. For this purpose survey data are collected fro professors teaching Management Science and analyzed by using t-test.

• 한국산학기술학회논문지
• /
• 제16권4호
• /
• pp.2338-2343
• /
• 2015

본 연구에서는 범용 유한요소해석 소프트웨어인 ANSYS를 사용하여 공작기계 스핀들 시스템의 유한요소 해석 자동화를 위해서 해석 모델을 개발하고, 그것을 툴로 구현하였다. 그 구현을 위해 EXCEL의 VBA를 사용하였으며, 이로 인해서 사용자가 툴과 상호교류할 수 있도록 그래픽 인터페이스를 개발할 수 있었고, 데이터 정렬을 위해서 EXCEL의 spreadsheet를 사용할 수 있었다. ANSYS 언어를 사용하여 코드를 개발하였으며, 이는 인터페이스에 입력된 정보를 사용하여 형상 모델을 만들고, 순차적으로 해석 모델을 만들며, 마지막으로 유한요소해석 연산을 수행한다. 모델 생성과 해석의 자동화는 최소한의 시간과 노력으로 설계 중인 스핀들 시스템의 근사 최적 설계를 발견하도록 도울 수 있을 것이다.

• 한국농공학회논문집
• /
• 제51권2호
• /
• pp.43-49
• /
• 2009

Many researcher uses simulation techniques for understanding the phenomenon and expecting the response. Simulation techniques have many advantages which is less time-consuming, easy to control constraints, and cheaper than experimental study. However Researches usually are not good at programming the model, it's hard to implement simulation model using computer language. They use spreadsheet program like Microsoft $excel^{TM}$ Although a spreadsheet program is good for modeling, it's cumbersome to describe expressions which consist of not variable name but location indicator. This study suggests the program which helps researcher developing model using graphical interface and variable name. For verifying usability, the model which is implemented by developed modeler were compared with by spreadsheet program.

• 한국산업보건학회지
• /
• 제24권2호
• /
• pp.219-228
• /
• 2014

Objectives: The major objective of this study was to develop a tier 2 exposure model combining tier 1 exposure model estimates and worker monitoring data and suggesting narrower exposure ranges than tier 1 results. Methods: Bayesian statistics were used to develop a tier 2 exposure model as was done for the European Union (EU) tier 2 exposure models, for example Advanced REACH Tools (ART) and Stoffenmanager. Bayesian statistics required a prior and data to calculate the posterior results. In this model, tier 1 estimated serving as a prior and worker exposure monitoring data at the worksite of interest were entered as data. The calculation of Bayesian statistics requires integration over a range, which were performed using a Riemann sum algorithm. From the calculated exposure estimates, 95% range was extracted. These algorithm have been realized on Excel spreadsheet for convenience and easy access. Some fail-proof features such as locking the spreadsheet were added in order to prevent errors or miscalculations derived from careless usage of the file. Results: The tier 2 exposure model was successfully built on a separate Excel spreadsheet in the same file containing tier 1 exposure model. To utilize the model, exposure range needs to be estimated from tier 1 model and worker monitoring data, at least one input are required. Conclusions: The developed tier 2 exposure model can help industrial hygienists obtain a narrow range of worker exposure level to a chemical by reflecting a certain set of job characteristics.

• 산업공학
• /
• 제15권3호
• /
• pp.279-285
• /
• 2002

A break-even analysis is a method used widely for profit planning or decisions in most companies. It is useful tool in financial studies because it is simple and offers useful insights from a modest amount of data. Although it is widely used, it has some weaknesses. It is limited in particular to the analysis for a short term time horizon or one period. We suggest a new break-even procedure to analyze projects with a long term time horizon as keeping the simplicity of a conventional break-even analysis. We will make efforts doing to include actual data for a cost or an income as much as possible rather than developing a mathematical model to improve unreality of a traditional break-even analysis. Also, we will use the spreadsheet software to solve problems.

• 산업경영시스템학회지
• /
• 제35권1호
• /
• pp.124-131
• /
• 2012

This paper presents a spreadsheet-based reliability prediction simulation framework for the conceptual product design stage to acquire system reliability information in timely manner. During early stage, reliability performance deals with both known and unknown failure rates and component-level and subsystem-level failure estimate to predict system reliability. A technique for performing life testing simulation using Excel spreadsheet has been developed under the such circumstances. This paper also discuss the results obtainable from this method such as reliability estimate, mean and variance of failures and confidence intervals. The resultant of this reliability prediction system is mainly benefitting small and medium-sized enterprise's field engineers.

• 통상정보연구
• /
• 제12권1호
• /
• pp.99-121
• /
• 2010

This paper reviews the categories and properties of risk measures, analyzes the classes and structural equations of volatility forecasting models, and presents the practical methodologies and their expansion methods of estimating and forecasting the volatilities of exchange rates using Excel spreadsheet modeling. We apply the GARCH(1,1) model to the Korean won(KRW) denominated daily and monthly exchange rates of USD, JPY, EUR, GBP, CAD and CNY during the periods from January 4, 1998 to December 31, 2009, make the estimates of long-run variances in the returns of exchange rate calculated as the step-by-step change rate, and test the adequacy of estimated GARCH(1,1) model using the Box-Pierce-Ljung statistics Q and chi-square test-statistics. We demonstrate the adequacy of GARCH(1,1) model in estimating and forecasting the volatility of exchange rates in the monthly series except the semi-variance GARCH(1,1) applied to KRW/JPY100 rate. But we reject the adequacy of GARCH(1,1) model in estimating and forecasting the volatility of exchange rates in the daily series because of the very high Box-Pierce-Ljung statistics in the respective time lags resulting to the self-autocorrelation. In conclusion, the GARCH(1,1) model provides for the easy and helpful tools to forecast the exchange rate volatilities and may become the powerful methodology to overcome the application difficulties with the spreadsheet modeling.

• 정보교육학회논문지
• /
• 제13권3호
• /
• pp.325-339
• /
• 2009

ICT는 교육의 효과를 증대시킬 수 있는 강력한 도구라는 이유로 교육에서의 활용이 중시되어 왔다. 그 중 Excel은 뛰어난 수식 계산과 논리 판단 기능을 갖추고 있고 다양한 종류의 계산을 할 수 있다는 점에서 수학과에서 그 가능성이 제시되어 왔다. 그러나 기존의 연구는 대부분 중 고등학교 수학과 통계단원에 중점을 두어 이루어 졌다. 그러나 함수의 사용이나 영어로 된 명령어는 초등학교에서 활용하기에는 무리가 있었다. 이에 본 연구에서는 초등학교에서 Excel을 활용하여 수학문제를 해결하는데 있어 단순 계산보다는 문제해결을 위한 사고에 중점을 둔 문제해결수업모형을 개발하여 적용하고 결과를 알아보았다. 연구 결과 문제를 해결하는데 있어 엑셀을 이용하였을 때가 필기보다 문제를 해결하는 성공률이 더 높고, 문제해결 시간이 더 단축된 것을 알 수 있었다.