• Journal of Practical Engineering Education
• /
• v.12 no.2
• /
• pp.265-273
• /
• 2020

In this paper, to design a basic data science practice curriculum as a liberal arts subject for non-majors, we proposed an educational method using an Excel(spreadsheet) data analysis tool. Tools for data collection, data processing, and data analysis include Excel, R, Python, and Structured Query Language (SQL). When it comes to practicing data science, R, Python and SQL need to understand programming languages and data structures together. On the other hand, the Excel tool is a data analysis tool familiar to the general public, and it does not have the burden of learning a programming language. And if you practice basic data science practice with Excel, you have the advantage of being able to concentrate on acquiring data science content. In this paper, a basic data science practice curriculum for one semester and weekly Excel practice contents were proposed. And, to demonstrate the substance of the educational content, examples of Linear Regression Analysis were presented using Excel data analysis tools.

• Journal of Educational Research in Mathematics
• /
• v.23 no.2
• /
• pp.213-235
• /
• 2013

The purpose of this study is to analyze how the teaching activities which used EXCEL influence the specialized high school underachieved students. They have difficulties in making use of various representations for better understanding of function. EXCEL is helpful for learning function because it enables the students to use real life materials in math learning as well as formulates Tabular, Algebraic and Graphical which represent function. Furthermore, the students in specialized high school also have the experience of using EXCEL while studying other subjects. For that reason they have no burdens and fears on using EXCEL in learning activities. Utilizing EXCEL in the classroom gives an expectation that it helps to have interests on studying function and prepare for the next learning in the end. Research classes were conducted in a group of five students who have different hopes of career and a variety of mathematical interests. Though the students couldn't transfer Algebraic to Graphical in the diagnostic evaluation, they could resolve the problem of connections between Graphical, Tabular and Algebraic in the process perspectives, and could also express graphical representation by linking object perspectives with process perspectives. Therefore, they solved the connection problem of Tabular, Algebraic and Graphical in the object perspectives. As a result, the students could make transitions between Algebraic and Graphical in object perspectives through the classes applying EXCEL. Consequently, teaching the students with underachievement utilizing EXCEL enables them to recover their interests on math and it helps them to complete their following curriculum.

• Journal of Technologic Dentistry
• /
• v.23 no.1
• /
• pp.85-93
• /
• 2001

The purpose of this study was to evaluate the effects of commercial home-tooth bleaching agents on the color of tooth. Twenty five sound extracted teeth were randomly divided into five groups. The color differences between before and after treatment with five types of tooth bleaching agents (7.5% hydrogen peroxide Nite White $Excel^{(R)}$, 10% carbamide peroxide Nite White $Excel^{(R)}$, 16% carbamide peroxide Nite White $Excel^{(R)}$, 10% carbamide peroxide Insta-BriteTM, 20% carbamide peroxide Insta-$Brite^{TM}$) were evaluated. The results were as follows: 1. By 2 week home tooth bleaching agent applications, the values ($L^*$) of bovine teeth increased as high as 4.38 $\sim$ 8.80 when comparing to those of the samples before treatment, and the color difference (${\Delta}E^*$) showed as high as 10.16 $\sim$ 15.04. 2. 16% carbamide peroxide Nite White Excel induced significantly greater ${\Delta}L^*$ than other test edgroups except for 7.5% hydrogen peroxide Day White Excel, and significantly greater ${\Delta}E^*$ than other tested groups by 2 week bleaching agent treatments (p<0.01). 3. 16% carbamide peroxide Nite White Excel(${\Delta}L^*$=8.80, ${\Delta}E^*$=15.04) induced significantly greater ${\Delta}L^*$ and ${\Delta}E^*$ than 10% carbamide peroxide Nite White Excel(${\Delta}L^*$=5.01, ${\Delta}E^*$=10.16)(p<0.01), but significant difference between 10% carbamide peroxide Insta-Brite(${\Delta}L^*$=4.38, ${\Delta}E^*$=10.51) and 20% carbamide peroxide Insta-Brite(${\Delta}L^*$=5.63, ${\Delta}E^*$=11.23) was not shown in ${\Delta}L^*$ and ${\Delta}E^*$(p>0.01). 4. 16% carbamide peroxide Nite White Excel(${\Delta}L^*$=8.80, ${\Delta}E^*$=15.04) which were applied in night time induced significantly greater ${\Delta}L^*$ and ${\Delta}E^*$ than 7.5% hydrogen peroxide Day White Excel(${\Delta}L^*$=8.47, ${\Delta}E^*$=12.75) which were applied in day time. Conclusions: These results demonstrate that all the commercial home-tooth bleaching agents have appreciable bleaching effect on teeth, and the effects of home-tooth bleaching agents which are used during night time are affected by content of carbamide peroxide. Especially the whitening effect of home tooth bleaching agents that are used through night time is greater than that of short time-applying tooth bleaching agent.

• Proceedings of the Korean Institute of Information and Commucation Sciences Conference
• /
• 2012.05a
• /
• pp.123-126
• /
• 2012

Increasing number of elderly's active participation in society, it is arisen the needs of senior information for training. Most of the senior's experiences in the digital device are low and because they do not get the information in formal education, they are vulnerable to the business office of utilizing the documents. For activities of society, it needs the excel education on enterprise document management training. According to this study, it is designed and implemented the 'Happyseniorcel' which is Excel application system for seniors. As a result of survey, it improves menu-use convenience, screen-color organization satisfaction and screen magnification efficiency compared to current excel. By using 'Happyseniorcel', it is expected to improve excel utilization and to encourage the social activities.

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

• Proceedings of the Korean Operations and Management Science Society Conference
• /
• 2003.05a
• /
• pp.580-585
• /
• 2003

정보화 수준을 검정하는 다양한 영역 중 실기시험은 채점 강의 문제로 많은 비용과 시간이 소요되고 있다. 본 연구에서는 컴퓨터활용능력을 검정하는 Excel 실기시험을 자동으로 채점하는 웹 기반 채점엔진을 개발하고자 한다. 출제자의 출제의도를 반영한 채점항목 및 채점기준을 유연하게 등록할 수 있게 하고, 틀리거나 감점된 문항에 대해 오답의 이유를 정확하게 제공하는 데에 개발의 초점을 맞추었다. 엑셀 자동채점 엔진을 활용하면 Excel 실기시험의 출제방향에 크게 위배되지 않으면서 사람이 채점타는 경우보다 객관성, 정확성 비용 소요시간의 면에서 기대효과를 꾀할 수 있다.

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

• Proceedings of the Korean Geotechical Society Conference
• /
• 2008.10a
• /
• pp.375-394
• /
• 2008

This paper discusses two user-friendly reliability techniques that could be implemented easily using the ubiquitous EXCEL. The techniques are First-Order Reliability Method with non-Gaussian random variables expressed using Hermite polynomials and collocation-based stochastic response surface method. It is believed that ease of implementation would popularize use of reliability-based design in practice.

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

• The Korean Journal of Applied Statistics
• /
• v.21 no.2
• /
• pp.355-359
• /
• 2008

In order to make students more interesting in statistics class, a small visual basic program is introduced. This program, which can be executed through the Excel Macro, can immediately collect many individual questionnaire files that were filled up by participatory students and consolidate into one Excel worksheet.