• Journal of Korean Society on Water Environment
• /
• v.34 no.4
• /
• pp.382-390
• /
• 2018

In this study, the LIDMOD3 was developed to design and evaluate low impact development (LIDMOD). In the same fashion, the LIDMOD3 employs a curve number (NRCS-CN) method to estimate the surface runoff, infiltration and event mean concentration as applicable to pollutant loads which are based on a daily time step. In these terms, the LIDMOD3 can consider a hydrologic soil group for each land use type LID-BMP, and the applied removal efficiency of the surface runoff and pollutant loads by virtue of the stored capacity, which was calculated by analyzing the recorded water balance. As a result of Model development, the LIDMOD3 is based on an Excel spread sheet and consists of 8 sheets of information data, including: General information, Annual precipitation, Land use, Drainage area, LID-BMPs, Cals-cap, Parameters, and the Results. In addition, the LIDMOD3 can estimate the annual hydrology and annual pollutant loads including surface runoff and infiltration, the LID efficiency of the estimated surface runoff for a design rainfall event, and an analysis of the peak flow and time to peak using a unit hydrolograph for pre-development, post-development without LID, and as calculated with LID. As a result of the model application as applied to an apartment, the LIDMOD3 can estimate LID-BMPs considering a well spatical distributed hydroloic soil group as realized on land use and with the LID-BMPs. Essentially, the LIDMOD3 is a screen level and simple model which is easy to use because it is an Excel based model, as are most parameters in the database. This system can be expected to be widely used at the LID site to collect data within various programmable model parameters for the processing of a detail LID model simulation.

• Journal of Korean Society of Rural Planning
• /
• v.16 no.3
• /
• pp.117-129
• /
• 2010

The purpose of this paper is to develop a web-based information system for rural settlement environment diagnosis which is useful to apply the village based evaluation for new rural development projects. To achieve this purpose, this study performed : 1) analyzing the business process in the field of rural settlement environment diagnosis, 2) designing the data flow diagram and the database based on settlement environment diagnostic indices(SEDI), and 3) developing the system using APM (Apache, PHP, and MySQL) of web-system development environment. The developed system was applied to the study rural villages for testing of efficient and logical working. Users of the system, such as, researchers, decision makers, and rural residents, can input directly the village data to diagnose through a file format of Excel in MS Office. Futhermore, they can analyze the visual results with graphic and graph types, simultaneously. From the results of this study, it showed that the developed system enables decision-makers not only to assist the planning process of the rural village development project, but also to improve the level of information technology in the research and planning field concerning with rural development.

• Journal of Korean Society on Water Environment
• /
• v.26 no.2
• /
• pp.297-302
• /
• 2010

It is very important to know mean and confidence interval of water-quality constituents such as BOD for water-quality control and management of rivers and reservoirs effectively. The mean and confidence interval of BOD at Anseong2 and Hwangguji3 sampling stations which are located at the border of local governments in Anseong Stream were estimated and analyzed in this paper using Bootstrap technique which is one of non-parametric statistics. The results of Bootstrap were compared with arithmetic mean, geometric mean, Biweight method mean as a point estimator and distribution mean came from the appropriate probability distribution of Log-normal. In Bootstrap technique 12 data set was randomly selected in each year and 1000 samples was produced to get parameter of population. Visual Basic for Applications (VBA) of Microsoft Excel was utilized in Bootstrap. It was revealed that the Bootstrap technique can be used to explain more rigorously and robustly the achievement or violation of BOD target concentration in Total Maximum Daily Load (TMDL).

• Journal of the Korean Society of Marine Environment & Safety
• /
• v.25 no.3
• /
• pp.395-403
• /
• 2019

This paper compares the marine engineering courses of two maritime institutions: Mokpo National Maritime University of Korea in the East Asia region and Philippine Merchant Marine Academy in the Southeast Asia region. It shows examines educational marine engineering programs, along with the different divisions and courses at each college. It demonstrates a divergence in methodologies and course offerings to cultivate competitive graduates. The comparative assessment completed is intended to offer broader knowledge on how each institution tackles the requirements of the STCW, and to meet the present and future demands of the maritime industry. Different course offerings are compared along with the units and hours allocated to each subject, and the differences in marine engineering academic and training requirements to graduate. Students must satisfactorily earn 150 units to complete their choice of major. Statistical procedures were used in this assessment and analysis from Excel programs.

• Journal of the Korean Dietetic Association
• /
• v.21 no.1
• /
• pp.72-82
• /
• 2015

The purpose of this study was to provide preliminary data for competitive dominance in an institutional foodservice environment. Data were collected from 85 experts and practitioners on customer-oriented service contact elements and contact fields in the foodservice industry. PASW Statistics ver.18 and MS Excel were used for data analysis. From the pilot study, 67 service contact-elements were derived. Contribution rate analysis and frequency analysis in each contact field were performed in order to categorize four factors, including environment-oriented contact, product-oriented contact, service-oriented contact, and image-oriented contact fields. Thirty three contact elements were derived, and environment-oriented contact consisted of eight contact-elements (cleanliness of restaurant/kitchen, etc.), product-oriented contact consisted of twelve contact-elements (food taste, etc.), service-oriented contact consisted of seven contact-elements (service quality, etc.), and image-oriented contact consisted of six contact-elements (image/reputation, etc.). The results of study will be useful to develop an effective marketing program for competitive dominance in an competitive foodservice industry environment.

• Journal of the Korea Institute of Military Science and Technology
• /
• v.14 no.3
• /
• pp.345-352
• /
• 2011

This paper focuses on the properties analysis of 9mm bullet dual structure core to substitute current lead core by environment-friendly combination of W-Cu-Ni system high density composite materials. So the four combination samples were made of dual core with the different center of gravity location backward or forward compare to that of lead type bullet, and we experimented about the performance of 9mm bullet dual structure core. In the experimental results, the outer shape of core of four environment friendly samples on the target maintain marginally, while the current lead core bullets are completely crushed after hitting the target. The penetration depth of environment friendly samples excel seven times to lead type bullet and the three out of four samples with forward adjusted center of gravity penetrate deep as twice as ones backward. The impact tolerance of all four samples satisfies military specification, however, more firing tests are required to improve reliability of scattering distribution.

• Journal of Korean Academy of Nursing Administration
• /
• v.20 no.1
• /
• pp.69-81
• /
• 2014

Purpose: The aim of this study was to investigate and identify work environment, job embeddedness, and burnout among general hospital nurses in Korea. Methods: The participants were 563 clinical nurses working in 13 general hospitals across the country. Data were analyzed using SPSS and Microsoft Excel programs. Results: Mean scores were 2.62 for nurses' work environment, 2.97 for job embeddedness, and 3.61 for burnout. Nurses' work environment showed a positive correlation with job embeddedness (r=.70, p<.001), but a negative correlation with burnout (r=-.49, p<.001). Subcategories of nurses' work environment that predicted job embeddedness included satisfaction and happiness, hospital support for the work environment, patient care environment, satisfaction with work schedule, manager leadership, supportive environment for nurses' work, and computer problems. Subcategories of nurses' work environment that predicted burnout included satisfaction and happiness, violence within ward, hospital support for work environment, and patient care environment. Conclusion: Findings from this study indicate the need to evaluate and improve the work environment for nurses to increase job embeddedness and control burnout. Future studies should explore ways in which turnover intention can be decreased by changing nurses' work environment.

• Journal of Korean Society for Atmospheric Environment
• /
• v.28 no.5
• /
• pp.556-570
• /
• 2012

The Low Carbon Path Calculator is an excel-based model to project greenhouse gas emissions from 2009 to 2050, which is based on the 2050 Pathways Calculator developed by the UK Department of Energy and Climate Change (DECC). Scenarios are developed to reduce GHG emissions in Korea at 50% based on 2005 levels by 2050 using a Low Carbon Path Calculator. They were classified in four different cases, which are high renewable, high nuclear, high CCS and mixed option scenarios. The objectives of this study are to compare scenarios in terms of GHG emissions, final energy, primary energy and electricity generation and examine the usefulness of that model in terms of identifying pathways towards a low carbon emission society. This model will enhance the understanding of the pathways toward a low carbon society and the level of the climate change policy for policy makers, stakeholders, and the public. This study can be considered as a reference for developing strategies in reducing GHG emissions in the long term.

• International Journal of Advanced Culture Technology
• /
• v.3 no.2
• /
• pp.118-123
• /
• 2015

IT environment gets more complicated in terms of open platform, network standards, device design and hardware, etc. Smart network and application are in the fields of corporate as well as national competition for future fusion technology. In development environment focused on computers, the ideas of authoring tool have been presented in terms of improved software productivity. In smart environment where subdividing works are consecutively done, current authoring tool should be effectively updated for effective development of programs and easier access to business works. The basic concept of a new conceptual App development tool, Smart App Authoring Tool, which has been designed in this study and enables to apply on-site requirements to smart phones, is to develop Apps on the level using easy-to-learn Word or Excel in a computer. Therefore, this study is intended to design a conceptual Smart App Authoring Tool to optimize the cost and time for developing and maintaining new application services under various smart phone platform environments. Based on the performance of smart app authoring tool herein, every people can develop a smart app program at moderate level. So this paper have designed a conceptual smart app authoring tool. This study presented educational efficiency of the authoring tool by developing business Apps under various business environments and applying them under university and high school environments.

• Journal of Soil and Groundwater Environment
• /
• v.24 no.1
• /
• pp.10-16
• /
• 2019

Alkalinity is an essential parameter for understanding geochemical processes and calculating partial pressure of $CO_2$, dissolved inorganic carbon, and mineral saturation indices. The Gran Titration Method (GTM) is one of the most accurate methods for measuring the alkalinity in water samples. However, this method has not been widely employed in measuring groundwater alkalinity in Korea, probably due to inadequate and insufficient understanding of the method. In this regard, this article was prepared to introduce GTM and related know-hows learned from the authors' experiences in measuring alkalinity. This paper also introduces a MS Excel-based alkalinity calculator as a handy tool for GTM.