• KIISE Transactions on Computing Practices
• /
• v.22 no.11
• /
• pp.559-566
• /
• 2016

Excel is a commercially available computer program that is used worldwide. Excel is widely utilized; it is helpful in household ledgers, corporate tax calculations, management of academic grades or reports, etc. However from the beginning, inaccuracies and errors in calculations have constantly been identified, so the program is updated regularly. Decimal-to-binary conversion is a simple and repetitive task. So, use of a computer program to do this calculation is suitable. Errors in decimal-to-binary conversion are surprising and are not easily understood. Therefore, it is important to identify the flaws in Excel, which unfortunately still exist today. It is necessary to determine the cause of this type of error, and I hope for a fix to be implemented quickly.

• Proceedings of the Korean Institute of Building Construction Conference
• /
• 2021.05a
• /
• pp.325-326
• /
• 2021

Design changes are inevitable areas of work for construction engineers as they occur frequently in the construction site, and are becoming a technical measure of the technical person to the design change. In this study, the purpose is to analyze by comparing the availability of excel and the enscised program during design changes through the case, and to present the efficiency of the the Cost-of-construction Program.

• Korean Journal of Mathematics
• /
• v.19 no.4
• /
• pp.453-464
• /
• 2011

We used SAS program in statistics class as a plan to increase effect of class. Because lease cost of SAS program is high and low-level students felt difficulty of the syntax of SAS program, I planned to introduce other instruction-software. We observe whether it's O.K. to use Excel instead of SAS program and Excel is helpful in having positive attitudes. We try to compare and analyze the merits of two programs. The purpose of this study is to apply Excel to statistics class, cut down the cost of instruction-software, and make students understand statistics more conveniently and easily.

• Journal of the Korean Data and Information Science Society
• /
• v.16 no.2
• /
• pp.359-369
• /
• 2005

Central limit theorem is known as one of the most important limit theorem in statistics and probability. This paper provides a dynamic MS Excel program that demonstrates computer simulation of various types of central limit theorems. Our result will be of great use for better understanding of central limit theorems.

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

• Korean Management Science Review
• /
• v.19 no.2
• /
• pp.41-58
• /
• 2002

New attempt has been made on Management Science (MS) education since the end of 1990s. The most distinctive feature of the new attempt is using spreadsheet program like Excel as a teaching tool for MS course. The spreadsheet program gives an excellent tool for modeling and solvina MS problems. In order to improve the pedagogical effect through using the spreadsheet program for MS course, new teaching model based on spreadsheet encompassing new course contents, effective instruction method, and examination method is needed. For this purpose, professors teaching MS should share their own teaching experiences and methods. So this paper explains remarkable functions of Excel and how to use them for the MS tools. This paper also stresses the importance of team project and case study to improve the effect of MS education through the use of Excel and presents some tips on MS education.

• Proceedings of the Korean Geotechical Society Conference
• /
• 2009.03a
• /
• pp.1113-1124
• /
• 2009

The limit equilibrium method and finite element method have been commonly used to assess the stability of anchored slope. However, the existing limit equilibrium methods do not consider the load transfer of anchor and, if the potential failure surface crosses the bonded zone of anchors, the anchor loads are not included in computing the factor of safety. In this paper, simplified bishop method, one among several methods based on the limit equilibrium is used to develope the Excel Sheet program and the working load of anchor along the failure surface is calculated by Flamant's formula, proposed by Morlier and Tenier(1982). Additionally, the finite element analysis of anchored slope considering the load transfer is performed in order to compare with the result from the limit equilibrium analysis and analyze the reinforced effect of anchor. From this study, new modelling method that limits the reinforcing range and considers the load transfer is proposed and Excel Sheet program is developed. The factor of safety for several cases between PC STABL and Excel Sheet program is also compared for verification of the program.

• Journal of Forest and Environmental Science
• /
• v.29 no.4
• /
• pp.307-313
• /
• 2013

Forest Survey consists of road survey, topographic survey, tree mapping survey, stream survey and also ridge survey. Information from forest survey is important and become essential in preparing base map to be used for forest harvesting planning and control. With the current technologies technique of data processing and mapping from traditionally hand drawn method had shifted to a computer system particularly the use of Computer Aided Design (CAD). This gives great advantages to the forest managers and logging operators. However data processing and mapping duration could be further reduced by integrating CAD with other established software such as Microsoft Excel. This time study to show that there is significance difference in term of duration for data processing and efficiency using AutoCAD in combination with Microsoft Excel program as compare to the use of AutoCAD program alone. From the study, it shows that the integration of AutoCAD and Microsoft Excel is able to reduce 70% of duration for data processing and mapping as compared to the use of AutoCAD program alone.

• Communications of Mathematical Education
• /
• v.35 no.1
• /
• pp.119-136
• /
• 2021

We performed the research and education programs using engineering tools such as Mathematica, Microsoft Excel and GeoGebra for the students in mathematics mentorship program of the institute of science education for the gifted. We used the engineering tools to solve the problems and found the rules by observing the solutions. Then we generalized the rules to theorems by proving the rules. Mathematica, the professional mathematical computation program, was used to calculate and find the length of the repeating portion of the repeating decimal. Microsoft Excel, the spreadsheet software, was used to investigate the Beatty sequences. Also GeoGebra, the dynamic geometric software, was used to investigate the Voronoi diagram and develop the Voronoi game. Using GeoGebra, we designed the Voronoi game plate for the game. In this program, using engineering tools improved the mathematical creativity and the logical thinking of the gifted students in mathematics mentorship program.

• Journal of Korean Ophthalmic Optics Society
• /
• v.16 no.1
• /
• pp.107-116
• /
• 2011

Purpose: The review article was written to establish an excel program that could calculate minimal Dk of contact lens without $O^2$ deficiency and actual $O^2$ concentration on cornea when contact lens were being fitted by changing lens-related factors. Methods: An excel program was formulated to calculate the thickness of post-lens lacrimal layer, Dk of contact lens and $O^2$ concentration on cornea. Results: With the excel program established, minimal $O^2$ concentration needed on cornea could be calculated when the thickness of post-lens lacrimal layer was changed by varying lens-related factors. A different route in the excel program was needed to choose based on the shape of lacrimal layer. The thickness of lacrimal layer was determined by the shape of meniscus made of tear between lens edge and cornea with flat fit. Thus, the $O^2$ concentration showing negative number in calculation decreased on peripheral cornea with flatter fitting and actual $O^2$ concentration would be zero on cornea. With tight fitting, the thickness of post-lens lacrimal layer is much thicker than lens itself thus negative number in calculation by the excel program is shown indicating zero oxygen on cornea. It can cause $O^2$ deficiency regardless of Dk of contact lens. Conclusions: The calculation of thickness of post-lens lacrimal layer and $O^2$ concentration on cornea by the established excel program is suggested to avoid $O^2$ deficiency when fitting state is varied by changing lens-related factors.