• School Mathematics
• /
• v.6 no.4
• /
• pp.411-433
• /
• 2004

Many researchers have reported that 7th graders have severe difficulties in using letters and algebraic expressions. This study investigated the way Microsoft Excel contributes to student's understanding of letters and algebraic expressions. For six hours through two weeks, four 7th grade students experienced various activities with Excel after school and both before and after the experimentation, the interviews to check their understanding was conducted. The results were as follows; First, after the experimentation, students used various letters to express formulas and recognized that letters represent not only some objects but also changing objects. Also they accepted that same objects could be represented by different letters and different objects could be represented by the same letters. Second, Excel improved students' abilities to discriminate variables and invariables in the problem and to find mathematical relationships among variables. And with Excel students could divide the whole calculation procedure into several steps in order to handle it more easily. Also, Excel made immediate numerical feedback possible and it made students express the calculation in a more formalized way than a paper and pencil environment did.

• Journal of the Korean Association of Geographic Information Studies
• /
• v.4 no.4
• /
• pp.21-28
• /
• 2001

In this study, GNLP(GIS linked non-linear network analysis program) for pipeline system analysis has been developed. This GNLP gets the input data for pipeline analysis from existing GIS(geographic information system) data automatically, and has GUI(graphic user interface) for user. Non-Linear Method was used for hydraulic analysis of pipe network based on Hazen-Williams equation, and Microsoft Access of relational database management system(RDBMS) was used for the framework of database applied program. GNLP system environment program was improved so that a pipe network designer can input information data for hydraulic analysis of pipeline system more easily than that of existing models. Furthermore this model generate output such as pressure and water quantities in the form of a table and a chart, and also produces output data in Excel file. This model is also able to display data effectively for analysed data confirmation and query function which is the core of GIS program.

• Proceedings of the Korea Information Processing Society Conference
• /
• 2008.05a
• /
• pp.208-210
• /
• 2008

정형 정보를 저장하는 대표적인 수단인 Microsoft Excel과 Database 간 상호변환에 있어서 다양한 방법들 중 Web을 기반으로 하는 변환 기술은 활용도가 매우 높을 것이다. 특히 많은 자료가 엑셀로 관리되는 경우 데이터 중복의 문제가 발생하며 DB를 통한 통합관리는 사용자 편의성 측면에서 높은 필요성을 갖는다. 본 논문은 이런 문제를 해결하기 위한 방안으로 POI를 이용한 변환 기법을 소개한다.

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

• Journal of Korea Water Resources Association
• /
• v.37 no.9
• /
• pp.719-727
• /
• 2004

Water quality models can be applied to manage the regional water quality problems and to estimate the target and allowable pollution load in watershed effectively. The optimization of state variables in the given water quality model Is necessary to build up more effective model. The least-squares method is applied to fit field observations in QUAL2E developed by U.S. EPA, which is most widely used one in the world to simulate the stream water quality, and the optimization model with constraints is constructed to estimate the parameters. The objective function of the optimization model is solved by Solver in Microsoft Excel and Monte Carlo simulation is conducted to know the influence of parameter in conventional pollutants. It is found that this technique is easily implemented and rapidly convergent computational procedure to calibrate the parameters after appling this approach in Anyang stream located in Kyonggi province mainly.

• The Journal of the Korea Contents Association
• /
• v.16 no.10
• /
• pp.65-71
• /
• 2016

This study conducts an analysis on the relative significance and urgency of competence factors for jobs in the field of Social Welfare through a demand analysis on the vocational training of the K Human Resource Development Institute regarding the National Competency Standards (NCS) in the field of Social Welfare, which was developed in the year 2014. The aim is to derive competence factors with high demands in education and high necessity of curriculum development based on the analysis. The data of 1,227 persons: 583 public officials and 644 private employees, was analyzed by using SPSS 18.0 and Microsoft Excel 2013. Results of the demand assessment on vocational training are as follows: for public officials, 4 competences in social development jobs (social area analysis, needs assessment, community resource building, community network, social assessment, community organizing, and welfare planning), 2 competences in public welfare jobs (management of unusual complaints in welfare and civil cooperation in resource development), and 2 competences in social welfare administration jobs (financial management in social welfare organizations and welfare planning) had high urgency in competence development. Implications were suggested based on the results.

• Journal of Environmental Science International
• /
• v.24 no.11
• /
• pp.1393-1404
• /
• 2015

Ten empirical disinfection models for the plasma process were used to find an optimum model. The variation of model parameters in each model according to the operating conditions (first voltage, second voltage, air flow rate, pH, incubation water concentration) were investigated in order to explain the disinfection model. In this experiment, the DBD (dielectric barrier discharge) plasma reactor was used to inactivate Phytophthora capsici which cause wilt in tomato plantation. Optimum disinfection models were chosen among ten models by the application of statistical SSE (sum of squared error), RMSE (root mean sum of squared error), $r^2$ values on the experimental data using the GInaFiT software in Microsoft Excel. The optimum models were shown as Log-linear+Tail model, Double Weibull model and Biphasic model. Three models were applied to the experimental data according to the variation of the operating conditions. In Log-linear+Tail model, $Log_{10}(N_o)$, $Log_{10}(N_{res})$ and $k_{max}$ values were examined. In Double Weibull model, $Log_{10}(N_o)$, $Log_{10}(N_{res})$, ${\alpha}$, ${\delta}_1$, ${\delta}_2$, p values were calculated and examined. In Biphasic model, $Log_{10}(N_o)$, f, $k_{max1}$ and $k_{max2}$ values were used. The appropriate model parameters for the calculation of optimum operating conditions were $k_{max}$, ${\alpha}$, $k_{max1}$ at each model, respectively.

• Transactions of the Korean Society of Mechanical Engineers A
• /
• v.35 no.11
• /
• pp.1471-1476
• /
• 2011

The catalytic converter in the front part of an automobile's exhaust system converts toxic exhaust gas into nontoxic gas. The substrate in the central part of the converter has a circular or oval-shaped cross section and fine lattice-shaped walls. In the canning process, the substrate is wrapped in mats and inserted into a can. During this process, mat pressure is induced, which may cause brittle fracturing in the substrate. In this paper, a finite element program for determining the mat pressure distribution was developed to avoid these fractures. The program was created in Microsoft EXCEL, so the input and output procedures are relatively simple. It was assumed that the substrate is rigid, the mat is material nonlinear, and the can is linear elastic. The can is modeled as a beam element to resist both bending and uniform tension/compression. The number of elements is fixed to 35, and the number of iterations, to 20. The solutions are compared to ABAQUS solutions and found to be in good agreement.

• Journal of Digital Convergence
• /
• v.17 no.4
• /
• pp.211-217
• /
• 2019

As the widespread use of mobile health intervention among Korean patients with chronic disease, it is needed to identify research trends in mobile health intervention on chronic care using text mining technique. This secondary data analysis was conducted to investigate characteristics and main research topics in intervention studies from 2005 to 2018 with a total of 20 peer reviewed articles. Microsoft Excel and Text Analyzer were used for data analysis. Mobile health interventions were mainly applied to hypertension, diabetes, stroke, and coronary artery disease. The most common type of intervention was to develop mobile application. Lately, 'feasibility', 'mobile health', and 'outcome measure' were frequently presented. Future larger studies are needed to identify the relationships among key terms and the effectiveness of mobile health intervention using social network analysis.

• Journal of the Korea Institute of Information Security & Cryptology
• /
• v.20 no.6
• /
• pp.43-51
• /
• 2010

It is meaningful to investigate data in unallocated space because we can investigate the deleted data. Consecutively complete file recovery using the File Carving is possible in unallocated area, but noncontiguous or incomplete data recovery is impossible. Typically, the analysis of the data fragments are needed because they should contain large amounts of information. Microsoft Word, Excel, PowerPoint and PDF document file's text are stored using compression or specific document format. If the part of aforementioned document file was stored in unallocated data fragment, text extraction is possible using specific document format. In this paper, we suggest the method of extracting a particular document file text in unallocated data fragment.