• The Journal of Information Technology
• /
• v.5 no.2
• /
• pp.95-106
• /
• 2002

This study attempts to construct and manage the distance learning system by focusing on education institutins. However, they lack not only web-based courseware for information literacy but also the contents for the management technology. This study tried to design and implement the web-based courseware by using OCP(Oracle Certified Profession) based on the initial Oracle in distance learning. Learners' individual variations were considered based on problem solving learning. Also, the practical contents that could be applied in the educational field were selected. The learning type web-based courseware, using the technology of ASP, DHTML, JAVAscript, VBA, was designed and implemented into the framework that could be updated easily. The result of the study shows: first of all, this courseware induced a greater understanding of the Oracle language and the student's interests. Secondly, the student's had more control over the process of individual learning and achieved the goal more effectively through immediate feedback, finally, the students could learn wherever they have on-line connections to the web server.

• Journal of Korea Technology Innovation Society
• /
• v.15 no.1
• /
• pp.105-128
• /
• 2012

This paper proposes the technological level assessment which improved reliability and the efficient noise elimination methods in the process of establishing patent map analysis data. In order to eliminate efficiently noise (removed by the manual process in the past), the paper applies the Logical Operator 'AND', makes it a program in excel VBA(Visual Basic Application), and obtains the valid data. For the improved reliability technological level assessment of the patents, the study calculates average number of claims, Patent Family Size(PFS), Cites Per Patent (CPP), Triad Patent Families, Standardization Patent Diversification Index (stdPCPI), and haF-index(Hirsch a Family index). The result which applied noise exclusion work showed less than 10% of acquired patent data ratio and confirmed high reliability. The result that apply proposed technological level assessment index makes sure that balanced technological level assessment which improved reliability by producing synthetic technological level assessment.

• Journal of Internet of Things and Convergence
• /
• v.9 no.6
• /
• pp.1-9
• /
• 2023

Malware files containing concealed malicious scripts have recently been identified within MS Office documents frequently. In response, this paper describes the design and implementation of a system that automatically detects malicious digital files using machine learning techniques. The system is proficient in identifying malicious scripts within MS Office files that exploit the OLE VBA macro functionality, detecting malicious scripts embedded within the CDH/LFH/ECDR internal field values through OOXML structure analysis, and recognizing abnormal CDH/LFH information introduced within the OOXML structure, which is not conventionally referenced. Furthermore, this paper presents a mechanism for utilizing the VirusTotal malicious script detection feature to autonomously determine instances of malicious tampering within MS Office files. This leads to the design and implementation of a machine learning-based integrated software. Experimental results confirm the software's capacity to autonomously assess MS Office file's integrity and provide enhanced detection performance for arbitrary MS Office files when employing the optimal machine learning model.

• Proceedings of the Korean Geotechical Society Conference
• /
• 2003.03a
• /
• pp.233-240
• /
• 2003

A GIS-based tunnelling risk management system (GIS-TURIMS) has been developed in this study The developed system uses ArcView 8.2 as a basic platform and the built-in interface(VBA) has been used to perform first-order simplified analyses for prediction of tunnelling-induced ground movements and building damage assessment. The main emphasis in this study was to develop a working framework that can be used in the perspective of tunnelling risk management. The developed system is capable of carrying out computationally intensive first-order analyses for ground movement prediction as well as building/utilities damage assessment with fully taking advantage of the GIS technologies. This paper describes the concept and details of the GIS-TURIMS development and implementation.

• 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 KIBIM
• /
• v.4 no.1
• /
• pp.1-7
• /
• 2014

The construction method using PC(Precast Concrete) has been widely used because the method can shorten the construction period and improve construction quality. In this paper, through the analysis of present design process for PC railway platform, design parameters on the geometry and properties were extracted and 3D information models for PC railway platform were constructed by the parametric modeling technique. Furthermore, the interface module was developed to link 3D models to the structural analysis/design sheet and database program using VBA(Visual Basic Application). This information model could be used in various areas including structural analysis and design, 2D drawing, quantity estimation and 4D simulation including clash detection.

• Proceedings of the Korean Geotechical Society Conference
• /
• 1991.10a
• /
• pp.152-165
• /
• 1991

Elasto-plastic and Visco-elastic sytress analyses were conducted for standard cross-section of subway tunnel in Seoul . Considering the procedure of excavation and reinforcement, excavated region was divided to multiple elements. And the progress of tunnel is simulated to be the removal of a series of layerd elements by means of diminishing the stiffness of the portion progressively. Another method is to be free of stress due to excavation instead of stiffness. In the analysis multiple element method was conducted with ADINA program, the stiffness removal method was adopted . For the same model, stress release method was carried out with Visco-Elastic Analysis program developed in Rock mechanics laboratory, Seoul National University(SNU-VBA) . When upper tunnel excavated, displacements in roof were same for two results, but when bottom tunnel removed completely , displacement changes of rock in the stress release method exhibited very small amount compared with stiffness removal method.

• IE interfaces
• /
• v.21 no.4
• /
• pp.378-384
• /
• 2008

Small sized companies have not been successful in systematically applying statistical process control because of insufficient human resources. In this paper we present a case study of automatic checking system for a small sized company which produces various types of gears. A systematic way of automatically measuring gears is proposed and statistical analysis methods are presented. To reduce variation in the measurement data, a standard operating procedure is also proposed. This case study can be helpful to quality assurance practitioners of small sized companies who are willing to develop checking or inspection systems for their products.

• Transactions of Materials Processing
• /
• v.15 no.7 s.88
• /
• pp.496-503
• /
• 2006

The inner and outer car panels for bonnet, door, and trunk lid are assembled by hemming rather than welding. To achieve successful fabrication of these panels, the complicated timing chart of hemming units for pre-and main hemming stages should be made to optimal one. In this study, a design system for automatic timing chart generation is developed. Using AutoCAD VBA and EXCEL data chart, hemming die design parameters and guidelines were put into the program to give hemming unit drawings and consequent timing charts. Then the prepared timing charts were checked and modified. The effectiveness of the system is verified by applying it successfully to hemming unit design for bonnet panel joining.

• Proceedings of the KIEE Conference
• /
• 2009.07a
• /
• pp.1581_1582
• /
• 2009

본 논문에서는 T형 분기 도파관 내 Septum의 최적설계를 위하여 상용 전자파해석 소프트웨어의 API(Application Program Interface) 기능을 활용하는 VBA(Visual Basic Application) 기반 설계 인터페이스를 개발 하였다. 최적설계의 설계 변수는 도파관 내에서 Septum의 위치와 크기로 하였고, 목적 함수는 도파관의 반사계수($S_{11}$)를 가장 작게 하면서 T형 분기 도파관에서 출력되는 에너지를 2:1로 분배하도록 설정하였다. 목적함수는 본 논문에서 정한 함수이며 설계 목표에 따라 인터페이스 내에서 변경이 가능하다. 설계 인터페이스는 마이크로소프트사의 엑셀을 이용하였고 인터페이스 내에서는 사용자가 원하는 T형 분기 도파관의 크기 설계가 가능하며, 입력 port의 입력 모드를 설정하고, 해석 주파수를 선택하여 사용자가 정한 목적 함수에 맞는 최적화된 Septum의 크기와 도파관 내에서의 위치를 찾을 수 있게 하였다. 또한 사용자가 원하는 위치에서의 E Field, H Field, 전류 밀도를 크기 또는 복소수 형태의 수치 데이터로 획득할 수 있도록 설계하였다.