• Korean Management Science Review
• /
• v.19 no.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.

• Journal of the Korean Data and Information Science Society
• /
• v.16 no.2
• /
• pp.359-369
• /
• 2005

Central limit theorem is known as one of the most important limit theorem in statistics and probability. This paper provides a dynamic MS Excel program that demonstrates computer simulation of various types of central limit theorems. Our result will be of great use for better understanding of central limit theorems.

• Proceedings of the Korea Water Resources Association Conference
• /
• 2017.05a
• /
• pp.334-334
• /
• 2017

Representative particle sizes(RPS) are commonly used for particle size distribution of heterogeneous sediment such as bed material. RPS can provide not only information of mean characteristics of sediment, but also other properties like sorting, skewness, kurtosis. For sediment including sand and clay material, RPS is estimated through two steps. The first is experimental step for calculating weight of each size class, the next is interpolation step to get RPS by using the graph plot. At the second step, graph method known as direct reading of value along the interpolation line in the graph plot is commonly used. This method is often time-consuming job. In this study we developed a new program to get RPS by using MS Excel. Simple linear and semi-log interpolation are used. When compared with conventional graph method(direct reading), simple linear shows 5.31%, while semi-log 1.29% of relative difference. We developed MS Excel program for estimation of RPS automatically.

• Transactions of the KSME C: Technology and Education
• /
• v.2 no.1
• /
• pp.21-28
• /
• 2014

As one of the most famous spreadsheet programs that is widely applied to a variety of fields in business, MS Excel has also been used for educational purposes due to its feature of wide accessibility, enabling students to use the program through almost any kind of PC that now exists. The program is mainly used for numerical analysis and formulae applications in the fields of science and engineering. This paper shall provide the key to understanding the application of MS Excel to teaching Statics through the illustration of its essential functions for education. Also, the development process of the analysis program using macros and VBA(Visual Basic for Applications) is described for the deeper comprehension of advanced applications. Students were not only able to solve the Statics problems using basic features of MS Excel, but also discovered new systematic methods of approaching complex problems and developed application programs using macros and VBA.

• Journal of radiological science and technology
• /
• v.32 no.1
• /
• pp.39-43
• /
• 2009

The medical diagnostic examination using ionizing radiation has improved the patients' life and brought revolution in medical examination along with the mechanical development. However, the development of medical imaging systems has also been the reason to increase the patients' exposure for ionizing radiation. ICRP recommends that each country adopts diagnostic reference levels depending on regional and national situations. The Korea Food & Drug Administration suggested the dosimetry measurement guideline for patients in 2007. Nonetheless, in reality, it is hard to know the skin dose of the patients when applying a x-ray since there is no radiation dosimeter in most of clinical situation. Therefore, this study sets a program based on the bit system to figure out easily the skin dose of a patients using MS Excel program in the PC setting. The results showed 10% better outcome.

• Journal of the Korean School Mathematics Society
• /
• v.8 no.2
• /
• pp.167-181
• /
• 2005

Statistics is based on a data, therefore a practical use of suitable data is important in teaching statistics. But, most teachers feel always that there is seldom data that students can understand easily. In this study, we presented a teaching method of statistics education that can elevate student's participation and interest in their statistics class using a web-based data collection program and MS Excel software. Also, the presented teaching method may apply extending to various part of statistics education.

• Proceedings of the KSME Conference
• /
• 2000.11b
• /
• pp.674-679
• /
• 2000

An air handling unit(AHU) has been usually designed by manual calculations. Drawing works together with design calculations should be redone far every designing work, and also be needed to make some corrections of them. In order to design the AHU more efficiently, an AHU program has been developed. The developed program on the Windows environment is operated by the graphic user interface(GUI) realized using the Visual Basic Interpreter. The program provides calculation sheet of coils, weights and pressures in a MS-Excel file format as well as design drawing of the AHU in a Auto CAD file format idealized by AutoLISP. Those files of the commercial softwares make easier for a designer to transfer design results to the another company for bid via e-mail.

• Aerospace Engineering and Technology
• /
• v.6 no.2
• /
• pp.96-103
• /
• 2007

A program for LAE (liquid Apogee Engine) firing strategy calculation was developed. This program can be used as the first stage of transfer orbit analysis, which process receives input parameters as like initial orbit elements, ground TT&C stations positions, satellite performances and makes firing user-selectable strategies. The developed program is dedicated to GEO satellites which using LAE generally and it can calculate six back-up strategies and deals situation its maximum firing number is six. The MS-EXCEL software was used for the input and output process. And the numerical calculation part was embodied with MATLAB functions.

• Journal of Korean Society of Water and Wastewater
• /
• v.29 no.1
• /
• pp.123-131
• /
• 2015

A CCTV inspection method has been widely used to assess sewer condition and performance, but Korea lacks a proper decision support system for prioritizing sewer repair and rehabilitation (R&R). The objective of this paper is to introduce the results that we have developed in the Sewer Condition Assessment and Rehabilitation Decision-making (SCARD) Program using MS-EXCEL. The SCARD-Program is based on a standardized defect score for sewer structural and hydraulic assessment. Priorities are ranked based on risk scores, which are calculated by multiplying the sewer severity scores by the environmental impacts. This program is composed of three parts, which are decision-making for sewer condition and performance assessment, decision-making for sewer R&R priority assessment, and decision-making for optimal budget allocation. The SCARD-Program is useful for decision-makers, as it enables them to assess the sewer condition and to prioritize sewer R&R within the limited annual budget. In the future, this program logic will applied to the GIS-based sewer asset management system in local governments.

• The Journal of Korean Medicine
• /
• v.32 no.1
• /
• pp.56-66
• /
• 2011

Background: This was a study to analyze Sanghanron through network theory, as the first attempt to construct network models for systems biomedicine in traditional Korean medicine. For this purpose, we investigated the network structure with priority given to two-node connections between symptoms and herbs of Taeyangbyung compilation in Sanghanron. Purpose: We had three goals in carrying out this study. First, to establish the minimum clinical grouping data sets for symptoms and herbs of Taeyangbyung compilation in Sanghanron. Second, to make index files for the obtained data sets. Third, to generate a network structure for systems biomedicine in this part, and analyze its relationship. Methods: Using MS office Excel and Netminer software, we constructed the minimum clinical grouping data sets and the network for systems biomedicine about symptoms and herbs of Taeyangbyung compilation in Sanghanron, and analyzed its relationship. Results: We established the minimum clinical grouping data sets for symptoms and herbs of Taeyangbyung compilation in Sanghanron, using MS Excel. We constructed a network to structurize our database through two-node connections of Netminer program, and analyzed its relationships. Conclusions: Further research on network model for systems biomedicine between symptoms and herbs for three Yang and three Um(Taeyang, Soyang, Yangmyung, Taeum, Soum, Gualum) disease compilation is necessary.