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

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

• School Mathematics
• /
• v.10 no.1
• /
• pp.1-22
• /
• 2008

The purpose of this study is to search the effective teaching-learning program by considering how affect on formation of linear function using Excel. This study was based on qualitative case study. The teaching experiment using Excel executed with five 8th graders' students for second research content. Teaching experiment was performed for two classes. Collecting the data was conducted via observations and interviews with students. The data include audio and video recording of the students' work, students' worksheets and detailed field notes. The conclusions drawn from teaching experiment are as follows: First, when students explored relevancy content of function in Excel environment, formation of concept of function was facilitated by experiencing operation of algebraic formulas, tables and graphs. We could infer that formation of concept was effected by conjecture activity and iterative process of feedback through Excel environment. Second, the students explored the changes very interestingly making algebraic formulas and presenting tables and graphs. The students were familiarized with observation on algebraic formulas, graphs and tables concurrently. Also, they tried to look for general rules through inductive observation. According to this study, we noticed that exploration teaming environment using Excel could supplement paper-and-pencil environment.

• Journal of the Korean School Mathematics Society
• /
• v.10 no.2
• /
• pp.263-288
• /
• 2007

The purpose of this study is to search the effective teaching-learning program by considering how affect on formation of the process-object perspective of linear function using Excel. In this study we analyzed function units in textbook and examined how Excel affect on the formation of the process-object perspective of linear function. Teaching experiment was based on qualitative case study and performed for five classes with five 8th graders. Data were gathered through observations, audio-taped interviews, video recording of the students 'work, students' worksheets, and detailed field notes. Findings indicate that exploration learning environment using Excel could supplement paper-and-pencil environment. We found that intuitive, dynamic, explorative, feedback skills via Excel can play the role of scaffolding supporting formation of process perspective object perspective of linear function.

• Journal of Korean Medicine Rehabilitation
• /
• v.28 no.1
• /
• pp.85-96
• /
• 2018

Objectives This study was performed to compare the electrical methods of motor points mapping using surface EMG and electric probe (Pointer Excel II). Methods 32 healthy adults (male 16, female 16) were selected. and classified into two groups; surface EMG group, electric probe (Pointer Excel II) group. In surface EMG group, motor points were searched by recoding the compound muscle potentials. In electric probe (Pointer Excel II) group, motor points were searched by scanning the skin with Pointer Excel II at low level stimulation. The locations of the motor points were expressed as X and Y values in relation to the reference line. The horizontal reference line was set as elbow crease and the vertical reference line was set as the line connecting coracoid process to the center of the horizontal reference line. The data was analyzed by 'Independent T-test' and 'equivalence test'. Results 1. The motor points of short head and long head of biceps brachii muscle were located at about 2/3 length of the vertical reference line from coracoid process and about 1/5~1/4 length of the half of the horizontal reference line from the vertical reference line in both group. 2. The motor points of the short head were located more distally and close to the vertical reference line (p<0.001). 3. In surface EMG group, the motor points of the long head were located more laterally in the female than male. And the motor points of the long head were located more distally in the left side than right side (p<0.05). In electric probe (Pointer Excel II) group, similar tendency was observed but there was no statistically significant difference (p>0.05). 4. As a result of the equivalence test between surface EMG group and electric probe (Pointer Excel II) group, the confidence intervals of the difference were within the equivalence limit. Therefore, the locations of the motor points searched by two ways are equa l (p>0.05, equivalence interval=3%). Conclusions The results indicate that electric probe (Pointer Excel II) can be used to search the motor points instead of surface EMG. This might improve the clinical efficiency when using the motor points to treat muscle dysfunction.

• Journal of Korean Society for Quality Management
• /
• v.49 no.4
• /
• pp.551-567
• /
• 2021

Purpose: The purpose of this paper is to present implications by analyzing research trends on smart factories by text analysis and visual analysis(Comprehensive/ Fields / Years-based) which are big data analyses, by collecting data based on previous studies on smart factories. Methods: For the collection of analysis data, deep learning was used in the integrated search on the Academic Research Information Service (www.riss.kr) to search for "SMART FACTORY" and "Smart Factory" as search terms, and the titles and Korean abstracts were scrapped out of the extracted paper and they are organize into EXCEL. For the final step, 739 papers derived were analyzed using the Rx64 4.0.2 program and Rstudio using text mining, one of the big data analysis techniques, and Word Cloud for visualization. Results: The results of this study are as follows; Smart factory research slowed down from 2005 to 2014, but until 2019, research increased rapidly. According to the analysis by fields, smart factories were studied in the order of engineering, social science, and complex science. There were many 'engineering' fields in the early stages of smart factories, and research was expanded to 'social science'. In particular, since 2015, it has been studied in various disciplines such as 'complex studies'. Overall, in keyword analysis, the keywords such as 'technology', 'data', and 'analysis' are most likely to appear, and it was analyzed that there were some differences by fields and years. Conclusion: Government support and expert support for smart factories should be activated, and researches on technology-based strategies are needed. In the future, it is necessary to take various approaches to smart factories. If researches are conducted in consideration of the environment or energy, it is judged that bigger implications can be presented.

• The Journal of the Korea Contents Association
• /
• v.9 no.12
• /
• pp.332-338
• /
• 2009

The statistics of traditional korean medicine is essential aspects for the information based policy establishment and the evidence based traditional korean medicine research. But because the integrated statistics service of traditional korean medicine is not provided, people are hard to find out suitable statistics. Thus we analyzed the produced statistics from many ministries, classified it into 7 categories and extracted common fields from it. We designed the database schema by summary table dynamic production method from the analysis of statistics and designed the system composed of excel import, statistics analysis, chart creation and search engine. Finally we implemented the statistics system of traditional korean medicine which users are capable of modifying the statistics data freely. We hope that the implemented system will provide pliability in searching and finding statistical information.

• Journal of Korean Society for Quality Management
• /
• v.50 no.4
• /
• pp.751-776
• /
• 2022

Purpose: The purpose of this paper is to present implications by analyzing research trends on CSR, CSV and ESG by text analysis and visual analysis(Comprehensive/ Fields / Years-based) which are big data analyses, by collecting data based on previous studies on CSR, CSV and ESG. Methods: For the collection of analysis data, deep learning was used in the integrated search on the Academic Research Information Service (www.riss.kr) to search for "CSR", "CSV" and "ESG" as search terms, and the Korean abstracts and keyword were scrapped out of the extracted paper and they are organize into EXCEL. For the final step, CSR 2,847 papers, CSV 395 papers, ESG 555 papers derived were analyzed using the Rx64 4.0.2 program and Rstudio using text mining, one of the big data analysis techniques, and Word Cloud for visualization. Results: The results of this study are as follows; CSR, CSV, and ESG studies showed that research slowed down somewhat before 2010, but research increased rapidly until recently in 2019. Research have been found to be heavily researched in the fields of social science, art and physical education, and engineering. As a result of the study, there were many keyword of 'corporate', 'social', and 'responsibility', which were similar in the word cloud analysis. Looking at the frequent keyword and word cloud analysis by field and year, overall keyword were derived similar to all keyword by year. However, some differences appeared in each field. Conclusion: Government support and expert support for CSR, CSV and ESG should be activated, and researches on technology-based strategies are needed. In the future, it is necessary to take various approaches to them. If researches are conducted in consideration of the environment or energy, it is judged that bigger implications can be presented.

• Journal of Korean Society of Rural Planning
• /
• v.19 no.4
• /
• pp.47-54
• /
• 2013

Climate change is the most direct threatening factors in sustaining agricultural productivity. It is necessary to reduce the damages from the natural hazards such as flood, drought, typhoons, and snowstorms caused by climate change. Through the vulnerability assessment to adapt the climate change, it is possible to analyze the priority, feasibility, effect of the reduction policy. For the vulnerability assessment, broad amount of weather data for each meterological station are required. Making the database management system for the meteorologic data could troubleshoot of the difficulties lie in handling and processing the weather data. In this study, we generated the meteorologic data retrieval system (MetSystem) for climate change vulnerability assessment. The user interface of MetSystem was implemented in the web-browser so as to access to a database server at any time and place, and it provides different query executions according to the criteria of meteorologic stations, temporal range, meteorologic items, statistics, and range of values, as well as the function of exporting to Excel format (*.xls). The developed system is expected that it will make it easier to try different analyses of vulnerability to natural hazards by the simple access to meteorologic database and the extensive search functions.

• Asian Pacific Journal of Cancer Prevention
• /
• v.16 no.11
• /
• pp.4733-4739
• /
• 2015

Background: Oral cancer is the most common cancer among men and second only to breast cancer among women in Pakistan. For the effective control and prevention of oral cancer, Pakistan needs to recognize the importance of research and generation of the evidence-base which can inform policy making and planning and implementation of intervention programs. The objective of this review was to quantify oral cancer research output in Pakistan. Materials and Methods: A systematic electronic search in "Medline", "ISI-Web of Science" and "Pakmedinet", supplemented by a Google search, was carried out in January and February, 2014, to identify literature from Pakistan relevant to oral cancer. The selection of publications for the review was carried out according to preset criteria. Data were recorded and analyzed using Microsoft Excel. Results: A total of 166 publications comprising 62 case series, 36 cross sectional, 31 case control, 10 basic laboratory research, eleven reviews and two trials, were included in this review. Some 35 % of the publications focused on risk factors for oral cancer. COMSATS Institute of Information Technology was the institution with the highest contribution. Conclusions: There is a lack of research in the field of oral cancer research in Pakistan. Focused efforts should be put in place to improve both quality and quantity of oral cancer research in the country.