• 한국경영과학회:학술대회논문집
• /
• 한국경영과학회 2008년도 추계학술대회 및 정기총회
• /
• pp.304-307
• /
• 2008

A spreadsheet-based linear program (LP) software, so called, the LP-Tableau is developed to aid users to learn the simplex algorithm systematically and to understand the various conditions that make the problem unusual and, in some instances, impossible to solve. The LP-Tableau has several good features over other spreadsheet-based LP software programs available. First, the data input in the LP-Tableau is very convenient especially when small-sized problems are analyzed. Further, the LP-Tableau allows for two solution methods (i.e., Big-M and Two-Phase) and displays the whole iterations in tableau format. Thus users can easily understand the principle of the algorithm step by step. Finally, the LP-Tableau visually displays various conditions of the optimal solutions that might occur in solving the LP 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.

• 한국컴퓨터정보학회논문지
• /
• 제22권11호
• /
• pp.143-149
• /
• 2017

In this paper, we propose efficient management method of liberal education for improving computer literacy. We analyzed the actual conditions and factors affecting education and reflected the analysis results in education. The subject of the study is 'Practice Excel', and tested achievement based on computer literacy. In order to evaluate objectively, we conducted CBT(Computer Based Test) based on Computer Specialist in Spreadsheet & Database Level-2. Analysis of the questionnaire included the use of the popular statistical program, IBM SPSS 24 trial, and frequency, ANOVA, t-test, crossover analysis, and correlation. Evaluation results, An important factor influencing educational performance was active participation. It also proved to be very helpful for understanding excel functions & expression.

• Computers and Concrete
• /
• 제13권4호
• /
• pp.457-482
• /
• 2014

This paper summarizes available literature on the optimization of reinforced concrete (RC) beams. The objective of optimization (e.g. minimum cost or weight), the design variables and the constraints considered by different studies vary widely and therefore, different optimization methods have been employed to provide the optimal design of RC beams, whether as isolated structural components or as part of a structural frame. The review of literature suggests that nonlinear deterministic approaches can be efficiently employed to provide optimal design of RC beams, given the small number of variables. This paper also presents spreadsheet implementation of cost optimization of RC beams in the familiar MS Excel environment to illustrate the efficiency of the exhaustive enumeration method for such small discrete search spaces and to promote its use by engineers and researchers. Furthermore, a sensitivity analysis is performed on the contribution of various design parameters to the variability of the overall cost of RC beams.

• 한국산학경영학회:학술대회논문집
• /
• 한국산학경영학회 2006년도 추계학술발표대회 발표논문집
• /
• pp.15-36
• /
• 2006

• 한국산업보건학회지
• /
• 제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.

• 정보교육학회논문지
• /
• 제21권2호
• /
• pp.219-230
• /
• 2017

본 연구는 초등학생의 컴퓨팅 사고력 향상을 위한 교육 방법으로 스프레드시트를 활용한 데이터 과학 교육프로그램을 개발하여 적용한 후 그 효과를 검증하였다. 교육 프로그램은 Rossett의 요구 분석 모형을 적용하여 초등학생 205명과 컴퓨터교육 전공 현직 초등교사 20명을 대상으로 실시한 사전 요구분석 결과를 바탕으로, 교수설계의 대표 모형인 ADDIE 모형의 절차에 따라 개발하였다. 개발한 교육 프로그램의 효과를 검증하기 위해 ${\bigcirc}{\bigcirc}$대학교에서 실시한 교육기부 프로그램의 지원자 표집에 의한 지원자 표본 20명의 학생을 대상으로 총 6일 동안 42차시 수업을 진행하였고 사전 사후 검사 결과를 통해 교육적 효과를 분석하였다. 분석 결과, 본 연구에서 개발한 교육 프로그램이 초등학생의 컴퓨팅 사고력 향상에 효과적임을 알 수 있었다.

• 한국수학교육학회지시리즈E:수학교육논문집
• /
• 제26권2호
• /
• pp.205-220
• /
• 2012

이 연구에서는 수렴하는 자연 수 수열의 사례를 구성하는 것을 목표로 특별한 패턴의 자연수 수열을 찾아 연구하였다. 자연수 수열의 수렴과 관련하여 다음 두 가지를 조사 분석하였다. 첫째, 극한에 대한 일상의 언어지만 수학적 의미를 내포한 고등학교 직관적 정의를 자연수 수열의 수렴성에 대한 이해의 토대가 되는 상수 수열을 포함한 기본적인 수열들에 어떻게 적용하는지를 수학교육전공의 대학생을 중심으로 살펴보았다. 둘째, 자명하지 않으며 특수한 패턴을 가진 수렴하는 자연수 수열의 사례로 전자항의 각 자릿수의 제곱의 합이 후자항을 결정하는 자연수 수열들에서 찾았다. 이 수열들의 탐구를 위해 꼬리의 개념을 사용하였고, 지필의 환경에서 이 수열들의 극한과 관련된 속성들이 쉽게 관찰되지 않아 원활한 탐색을 위해 스프레드시트를 활용하였다. 여기서 스프레드시트는 실험과 관찰을 도모하고 수학적 패턴의 발견을 도울 뿐 아니라 추론과 증명을 뒷받침하는 자료 추출의 도구가 될 수 있다는 시사점올 준다.

• 한국정보교육학회:학술대회논문집
• /
• 한국정보교육학회 2021년도 학술논문집
• /
• pp.385-391
• /
• 2021

본 논문에서는 예비교사 및 현직교사를 대상으로 한 인공지능 소양교육을 위해, 딥러닝 인공신경망 교육 사례를 연구하였다. 또한, 제안한 교육 사례를 통해, 초중고 학생들이 경험할 수 있는 인공신경망 원리교육 콘텐츠를 탐색하고자 하였다. 이를 위해, 우선 2종 이미지를 인식하는 인공신경망의 동작 원리 교육 사례를 제시하였다. 그리고 인공신경망 확장 응용 교육 사례로, 3종 이미지를 인식하는 인공신경망 교육 사례를 제시하였다. 인공신경망에 인식시키고자 하는 이미지 개수에 따라 출력층의 개수를 변경하여 스프레드시트로 구현한 사례를 구분하여 설명하였다. 또한, 인공신경망 동작 결과를 체험하기 위해, 지도학습 방식의 인공신경망에 필요한 학습데이터를 직접 작성해보는 교육 내용을 제시하였다. 본 논문에서는 인공신경망의 구현과 인식 테스트 결과를 스프레드시트를 사용하여 시각적으로 나타내었다.

• 통상정보연구
• /
• 제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.