• Proceedings of the KIEE Conference
• /
• 대한전기학회 2006년도 제37회 하계학술대회 논문집 D
• /
• pp.1947-1948
• /
• 2006

본 논문에서는 컴퓨터로 정밀 계측기기들을 자동 제어하고 데이터를 측정하기 위하여 기존의 상용 프로그램을 사용하지 않고 Excel VBA(Visual Basic for Applications)를 이용하는 방법에 대하여 연구하였다. 이는 반복측정 및 통계적 수치계산 등에서 많은 장점을 지니고 있어 수많은 국가교정기관 및 일반 산업체에서 유용하게 사용될 수 있으리라 사료된다.

• Proceedings of the Korea Water Resources Association Conference
• /
• 한국수자원학회 2007년도 학술발표회 논문집
• /
• pp.820-824
• /
• 2007

간선도로의 유입부 설계에는 도로 표면에 떨어진 강우만을 고려하여 빗물받이 간격, 형태 등을 결정하고 있으나, 현실적으로는 간선도로와 연결된 급경사 국지도로에서 횡방향 빗물받이 유입부로 유입되지 않는 유량이 간선도로의 침수를 가중시키고 있는 실정이다. 이러한 점들을 고려할 때, 침수피해에 의한 시민들의 재산을 보호하고, 불편을 덜어주기 위해 급경사 국지도로의 합리적인 배수시설이 필요하다. 그러므로 국지도로 조건에 따른 횡유입부의 설치간격, 적정크기 및 관리 방안을 마련하여 빗물 배제 능력을 향상시킴으로써 도시 홍수피해의 경감대책을 수립하여야 한다. 따라서 본 연구에서는 합리식을 이용하여 우수유출량을 계산하고, 횡유입부의 차집효율 실험을 통하여 산정된 국지도로의 단위 폭(1m)당 차집유량을 이용하여 횡유입부의 설계 방법을 제시하였으며, Excel을 이용하여 간략하게 프로그램화 하였다. 제시된 설계방법은 실무에서 국지도로 경사의 변화를 고려한 횡방향부의 설계에 사용가능하리라 판단된다.

• Journal of the Korean Data and Information Science Society
• /
• 제22권4호
• /
• pp.643-650
• /
• 2011

Recently the needs for education on Statistics is growing bigger, but a mathematics-oriented education makes college students loose interest in Statistics. On the hypothesis that motivating interest is the key factor for learning, we need to develop an education tool for Statistics that makes learners to study independently but throughly. By using Excel Macro, we develop and introduce add-in program, called PETS, which supplies not only results but also process to get them.

• Journal of the Korean School Mathematics Society
• /
• 제10권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.

• School Mathematics
• /
• 제8권3호
• /
• pp.265-290
• /
• 2006

The purpose of this study is to search an effective teaching & learning program by examining how much does Excel affect on problem solving of linear function. This study was based on qualitative case study. Teaching experiment was performed for seven periods with five students in 8th graders. Pre and posts tests were attempted to analyze the changes of student's ability on problem solving of linear function. The analysis of tests were performed in category with correct process-object perspective, near process-object perspective, incorrect process-object perspective. According to this study, the subjects showed an improvement on problem solving perspective of linear function. This meant that lessons using Excel had influenced on the problem solving of linear function. We noticed that exploring the learning environment with Excel could supplement paper-and-pencil environment. We believed that Excel with an intuitive dynamic and explorative skills can play a role in scaffolding to support problem solving of linear function.

• Proceedings of the KSR Conference
• /
• 한국철도학회 2010년도 춘계학술대회 논문집
• /
• pp.1630-1641
• /
• 2010

LCC can be defined as "the sum of present values of investment costs, capital costs, installation costs, energy costs, operating costs, maintenance costs, and disposal costs over the life-time of the project, product, or measure." LCCA involves estimating the costs and timing associated with each alternative over a selected analysis period and conversion of those costs to economically comparable values considering the time-value of money. The several Excel-Based LCC tools found on the internet are described in this paper. Also, This paper performed an analysis of the existing LCC commercial tools, assessing various aspects of each program. The goal was to evaluate the best features of each tool and to identify the requirements for LCC evaluation of Urban Transit Vehicle. The LCC tools are developed to address problems in many different areas and a tool developed and structured for one area cannot generally be used in another area. No general LCC tool exists and if one is needed for Urban Transit Vehicle it has to be developed by the project. Since a full LCC can be very complex it is likely that this Excel-Based LCC tool should be a small and simple tool for quick cost estimates. This paper presents a LCC tool consisting of eight excel sheets, which are "Project", "CBS", "PBS", "PM", "CM", "Others", "LCC Result" and "Diagram".

• 한국데이터정보과학회:학술대회논문집
• /
• 한국데이터정보과학회 2006년도 PROCEEDINGS OF JOINT CONFERENCEOF KDISS AND KDAS
• /
• pp.155-161
• /
• 2006

To enhance the interest and comprehension of learners studying Statistics. The program which learners can use is needed. With the help of this program, the interest and concentration of the learners can be enhanced, and the effects of the study of Statistics can be maximized, through the convenience of calculation to the theoretical contents of Statistics, various graphs, the, simulation.

• Journal of the Korean School Mathematics Society
• /
• 제8권2호
• /
• pp.167-181
• /
• 2005

Statistics is based on a data, therefore a practical use of suitable data is important in teaching statistics. But, most teachers feel always that there is seldom data that students can understand easily. In this study, we presented a teaching method of statistics education that can elevate student's participation and interest in their statistics class using a web-based data collection program and MS Excel software. Also, the presented teaching method may apply extending to various part of statistics education.

• Transactions of the Korean Society of Mechanical Engineers A
• /
• 제37권3호
• /
• pp.419-427
• /
• 2013

The catalytic converters for automobile exhaust systems are manufactured by inserting a mat-wrapped substrate into a stainless steel can. A residual pressure that is too high will initiate a fracture in the substrate. In contrast, a residual pressure that is too low will fail to hold the substrate in the acceleration or deceleration phase. Both the process capability and mat pressure on the substrate are predicted while considering the effect of the statistical variation in the dimensions of the parts. The validity of the solutions is then confirmed. A program using EXCEL combines a finite element analysis and process capability analysis in one program.

• Journal of the Korean Data and Information Science Society
• /
• 제15권3호
• /
• pp.543-554
• /
• 2004

In teaching statistics, the part which is very important but difficult to understand to the students is estimation and hypothesis testing. This paper introduces the developed program about estimation and hypothesis testing by using Excel Macro. This program will help learners to study and use a statistical inference conveniently, and to get a good learning effect.