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

• IE interfaces
• /
• v.22 no.4
• /
• pp.302-311
• /
• 2009

It's very important to make an effective and optimized production schedule for the small-to-medium-sized factory which have high-variety low-volume manufacturing properties. And now people say that MES is very useful to make scheduling more effectively. But for small-to-medium-sized factory, it is very difficult to build MES system because of fewer infrastructures in the factory, and more to keep it's continuous maintenance and improvement. Therefore it is more important to systematize the production scheduling generation using simpler and easier tools like EXCEL sheet. And it will be needed a new method to make simple MES construction for more efficient production scheduling. This paper proposes the method which can build simple MES easily using a tool of EXCEL VBA for a small-to-medium-sized factory, and introduces an applied case by the proposed method and EXCEL VBA.

• Journal of the Korea Institute of Information and Communication Engineering
• /
• v.18 no.1
• /
• pp.217-222
• /
• 2014

In this paper, I propose an efficient data search system using data partitioning algorithm in Microsoft Excel. I propose searching algorithm to retrieve data quickly using VBA functioning in the Excel. This algorithm is to specify the sheet you are looking for. Once the sheet is specified, the algorithm searches the beginning and the end of the data in the sheet. The algorithm compares intermediate values and key words, from the starting position of the cell. In this way, it will search data to the end. This proposed algorithm was implemented and tested in the Excel system using VBA program. The experimental results showed that the performance was better than that of the conventional sequential search method.

• Journal of the Korea Institute of Information and Communication Engineering
• /
• v.23 no.9
• /
• pp.1173-1178
• /
• 2019

In this paper, we design a security management application module for an Excel VBA password file. You will set a password for the important VBA program file. If this password is lost, you set a new password. If you forgot the password after setting the password in the Excel VBA file, you will not be able to change the VBA source code. In this paper, we design a function to modify VBA file passwords conveniently. The VBA password modification module extracts VBA files from Excel files. The password can be modified by modifying specific field information in the extracted VBA program file. This allows you to modify the password for the VBA program file. The experiments were performed by implementing the contents proposed in this paper. As a result of the experiment, we can confirm that the password can be used by modifying the VBA file password.

• Proceedings of the Korean Statistical Society Conference
• /
• 2002.11a
• /
• pp.311-314
• /
• 2002

자료행렬에서 개체와 변수간의 관계성을 시각적으로 표현하기 위한 방법 중의 하나가 행렬도이다. 본 논문에서는 전문적인 통계 패키지를 이용한 행렬도 구현이 아니라, 가장 널리 사용되는 응용프로그램 중의 하나인 Excel 에서 VBA를 이용하여 행렬도 시스템을 구현하였다.

• Journal of the Korean Data and Information Science Society
• /
• v.17 no.3
• /
• pp.811-820
• /
• 2006

We introduce a program that enhances the interest and understanding of students in Statistics. This program explains various statistical concepts and procedures by showing detailed steps of calculations with graphs and simulations. This program utilizes a readily accessible Excel VBA.

• Journal of the Korea Academia-Industrial cooperation Society
• /
• v.5 no.1
• /
• pp.29-33
• /
• 2004

In this paper, I'm tying to define the connection of the Device Characteristics and the Error Terms, and yield maximum estimated value of the mismatching errors by modeling the individual devices with signal-flow graph, and by seeking the transfer function of the system with the mismatching error in the combination of the devices using the Signal-flow Graph Gain Formula.

• Journal of the Korea Safety Management & Science
• /
• v.14 no.2
• /
• pp.167-176
• /
• 2012

This research studies the present status of utilization of IT in SMB, Small & Medium Business, logistics companies, and analyzes the examples of utilizing Excel VBA for building and operating IT system in SMB logistics companies. Through the study, this research suggests main issues of building and operating logistic systems and the effective way of utilizing the systems in SMB logistics companies.

• Proceedings of the Safety Management and Science Conference
• /
• 2011.11a
• /
• pp.181-189
• /
• 2011

This research studies the present status of utilization of IT in SMB, Small & Medium Business, logistics companies, and analyzes the examples of utilizing Excel VBA for building and operating IT system in SMB logistics companies. Through this study, this research suggests main issues of building and operating logistic systems and the effective way of utilizing the systems in SMB logistics companies.

• Proceedings of the Korean Institute of Information and Commucation Sciences Conference
• /
• 2013.10a
• /
• pp.671-674
• /
• 2013

In this paper, we propose an efficient data search system using data partitioning algorithm in Microsoft Excel. We propose to retrieve the data quickly using VBA functioning Excel. This algorithm is to specify the sheet you are looking for. Once the sheet is specified, it searches the beginning and the end of the data in the sheet. It compares desired key words and intermediate values, starting from the position of the cell. In this way, it will search data to the end. This proposed algorithm was implemented and tested using actual VBA program. The experimental results showed that the performance was more excellent than that of the conventional search method.