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

• Journal of The Korean Society of Agricultural Engineers
• /
• v.53 no.4
• /
• pp.11-19
• /
• 2011

PADDIMOD2 was deloped to estimate nonpoint source pollution from paddy rice fields. The PADDIMOD2 was enhanced to estimate runoff and pollutant load during non-growing as well as growing season and to be easily used for public by development of Excel based system. Nutrient concentration and hydrology were based on Dirac delta function and continuous source function, and tank model for growing season and Event Mean Concentrations (EMCs) and SCS-Curve Number method for non-growing season. The PADDIMOD2 consists of three main component (input data, parameters data, and output data) by including eight Excel spread sheets. As a result of model application, total precipitation and irrigation were 1,051.7 mm and 439.2 mm, respectivley and surface runoff and water loss including infiltration and evapotranspiration were 463.0 mm and 947.9 mm, respectively. Annual nutrient loadings of T-N and T-P from study area were 6.7 kg/$km^2$/day and 0.5 kg/$km^2$/day, respectively. Development of PADDIMOD2 was focused on minimizing input data and maximizing user friendly system and is expected to be useful tool to evaluate various non-structure BMPs and estimate unit load from paddy rice fields for application at Korean TMDL.

• Korean Journal of Agricultural and Forest Meteorology
• /
• v.20 no.2
• /
• pp.228-232
• /
• 2018

Process-based crop models have been used to assess the impact of climate change on crop production. These models are implemented in procedural or object oriented computer programming languages including FORTRAN, C++, Delphi, Java, which have a stiff learning curve. The requirement for a high level of computer programming is one of barriers for efforts to develop and improve crop models based on biophysical process. In this study, we attempted to develop a Chinese cabbage model using Microsoft Excel with Visual Basic for Application (VBA), which would be easy enough for most agricultural scientists to develop a simple model for crop growth simulation. Results from Soil-Plant-Atmosphere-Research (SPAR) experiments under six temperature conditions were used to determine parameters of the Chinese cabbage model. During a plant growing season in SPAR chambers, numbers of leaves, leaf areas, growth rate of plants were measured six times. Leaf photosynthesis was also measured using LI-6400 Potable Photosynthesis System. Farquhar, von Caemmerer, and Berry (FvCB) model was used to simulate a leaf-level photosynthesis process. A sun/shade model was used to scale up to canopy-level photosynthesis. An Excel add-in, which is a small VBA program to assist crop modeling, was used to implement a Chinese cabbage model under the environment of Excel organizing all of equations into a single set of crop model. The model was able to simulate hourly changes in photosynthesis, growth rate, and other physiological variables using meteorological input data. Estimates and measurements of dry weight obtained from six SPAR chambers were linearly related ($R^2=0.985$). This result indicated that the Excel/VBA can be widely used for many crop scientists to develop crop models.

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

• The Journal of Korean Association of Computer Education
• /
• v.23 no.2
• /
• pp.41-51
• /
• 2020

The goal of this study is to test the hypothesis that the practicality of EXCEL VBA will be beneficial for SW education for SW non-majors. To this end, we planned the education for non-majors using the EXCEL VBA and conducted 15 weeks of education. According to a follow-up survey conducted after the 15-week education period, 72.21% of the survey respondents said EXCEL was practical. Also, learners who were aware of the necessity of SW education and the importance of SW competence recognized that the computational thinking education using EXCEL VBA had a positive effect on the improvement of computer-related knowledge and experience. Also, learners recognized that learning with EXCEL was easy, while learning with VBA was difficult. The learning process using VBA needs to be composed of project-oriented educational contents that can give a sense of achievement to learners rather than programming-oriented education. And continuous research on project-based learning is needed.

• Journal of Korean Society of Water and Wastewater
• /
• v.28 no.6
• /
• pp.735-745
• /
• 2014

This paper presents PKES(PuKyung -Excel based Simulator) for WWTPs(wastewater treatment plants) by using MS Excel and VBA(Visual Basic for Application). PKES is a user-friendly simulator for the design and optimization of the whole plant including biological and physico-chemical processes for the wastewater and sludge treatment. PKES calculates the performance under steady or dynamic state and allows changing the mathematical model by the user. Mathematical model implemented in PKES is a improved integration model based on ASM2d and ADM1 for simulation of AS(activated sludge) and AD(anaerobic digestion). Gaseous components of $N_2$, $N_2O$, $CO_2$ and $CH_4$ are added for estimation of GHGs(greenhouse gases) emission. The simulation results for comparison between PKES and Aquasim(EAWAG) showed about the same effluent concentrations. As a result of verification using by measured data of BOD, TSS, TN and TP for 2 years of operation, calculated effluent concentrations were similar to measured effluent concentrations. The values of average RMSE(root mean square error) were 1.9, 0.8, 1.6 and 0.2 mg/L for BOD, TSS, TN and TP, respectively. Total GHGs emission of WWTP calculated by PKES was 138.5 ton-$CO_2$/day and GHGs emissions of $N_2O$, $CO_2$ and $CH_4$ were calculated at 21.7, 28.9 and 87.9 ton-$CO_2$/day, respectively. GHGs emission of activated sludge was 32.5 % and that of anaerobic digestion was 67.5 %.

• Journal of the Korea Academia-Industrial cooperation Society
• /
• v.16 no.4
• /
• pp.2338-2343
• /
• 2015

An analytical model was developed in this study and then implemented into a tool for automation of FEA (Finite Element Analysis) of a spindle system for natural frequencies and modes in the universal FEA software, ANSYS. VBA of EXCEL was used for the implementation. It allowed graphic user interfaces (GUIs) to be developed for a user to interact with the tool and, in addition, an EXCEL spreadsheet to be used for data arrangement. A code was developed in the language of ANSYS to generate the geometric model of the spindle system, sequentially to construct the analytical model based on the information in the GUIs, and finally to perform computation for the FEA. Its automation of the model generation and analysis can help to identify a near optimal design of the spindle system under design in minimum time and efforts.

• Journal of The Korean Association of Information Education
• /
• v.13 no.3
• /
• pp.325-339
• /
• 2009

Many current researches are limited in the statistics field, which is a part of mathematics class in the secondary school. Moreover, it's hard to apply to the elementary school since they are written in English. To overcome this limitations, the objectives from the unit that is suitable for using EXCEL in the elementary mathematics lessons are selected in this research. And a problem-based learning model for these lessons would be introduced that it can help students to focus on solving substances of the problems by reducing the time for arithmetic calculation.

• Journal of the Korea Society for Simulation
• /
• v.23 no.4
• /
• pp.21-29
• /
• 2014

In general, a simulation project requires much time and money since we should develop a model that works similarly to the system at a level consistent with the project purposes. Therefore, more active research studies are required to reduce the time needed for the modeling process. This is achievable by minimizing the possible trial and error during the model development process through the appropriate conceptual model design and the automated generation of the simulation model. This paper presents a tool automatically generating an Arena model after developing a conceptual simulation model. Because our proposed tool is based on the popular Microsoft Excel and Visio, it is expected to be practically used at many industrial sites. Finally, we showed the effectiveness of the newly suggested tool by applying it to an imaginary simulation project.

• Journal of KIBIM
• /
• v.12 no.4
• /
• pp.19-31
• /
• 2022

With the development of 3D-based CAD (Computer Aided Design), attempts at freeform building design have expanded to small and medium-sized buildings in Korea. However, a standardized system for continuous utilization of shape data and BIM conversion process implemented with 3D-based NURBS is still immature. Without accurate review and management throughout the Freeform building project, interference between members occurs and the cost of the project increases. This is very detrimental to the project. To solve this problem, we proposed a continuous utilization process of 3D shape information based on BIM parameters. Our process includes algorithms such as Auto Split, Panel Optimization, Excel extraction based on shape information, BIM modeling through Adaptive Component, and BIM model utilization method using ID Code. The optimal cutting reference point was calculated and the optimal material specification was derived using the Panel Optimization algorithm. With the Adaptive Component design methodology, a BIM model conforming to the standard cross-section details and specifications was uniformly established. The automatic BIM conversion algorithm of shape data through Excel extraction created a BIM model without omission of data based on the optimized panel cutting reference point and cutting line. Finally, we analyzed how to use the BIM model built for automatic conversion. As a result of the analysis, in addition to the BIM utilization plan in the general construction stage such as visualization, interference review, quantity calculation, and construction simulation, an individual management plan for the unit panel was derived through ID data input. This study suggested an improvement process by linking the existing research on atypical panel optimization and the study of parameter-based BIM information management method. And it showed that it can solve the problems of existing Freeform building project.