• Title/Summary/Keyword: excel

Search Result 832, Processing Time 0.025 seconds

Technology Keyword Network and Cognitive Map Analysis: to prospect promising technology of UAV(Unmanned Aerial Vehicle) airframe industry (기술 키워드 네트워크와 인지지도 분석을 통한 무인항공기 비행체산업의 유망기술 도출 연구)

  • Joo, Seong-Hyeon;Ha, Sung-Ho;Park, Sang-Hyeon
    • Journal of Korea Society of Industrial Information Systems
    • /
    • v.21 no.5
    • /
    • pp.55-72
    • /
    • 2016
  • This study aims at providing a methodology for retaining international technology competitiveness, marketable industry, and sustainable promising technology in a field of new growth engine industry such as national unmanned aerial vehicle industry. We draw a result by analysing with tools such as KrKwic, Excel, NetMiner, presenting methods of a Social Network Analysis, sub-group analysis, and cognitive map analysis based on patent data in a field of unmanned aerial vehicle industry. As a result, some future promising technologies are prospected as what worths concentrated investment, such as 'pilot control tech', 'identification of friend or foe tech'.

A Study on the Building & Application of Basin Environmental Information Management System (유역환경정보관리시스템구축 및 활용에 관한 연구)

  • 성동권;김태근;조기성
    • Journal of the Korean Society of Surveying, Geodesy, Photogrammetry and Cartography
    • /
    • v.17 no.1
    • /
    • pp.69-78
    • /
    • 1999
  • Recently, with a rapid industry development, the recognition of environmental pollution is being increased. And the technique of pollution-prevention is also being studied. In the past, management direction for environmental pollution was limited only to concentration reduction and technique for treatment. But ,in these day, its direction is moved to a high level study such as a management and estimation of pollution material. In this study we establish a conception about EIS(Environmental Information System) building and present its building method. And we present a method for a database building, searching, analysis and printing. Also we produced the landuse map processing LANDSAT TM image. Using DDE(Dynamic Data Exchange) between Excel and ArcView on PC platform, we are enable to write and/or update a Report - waste discharge facility approval management leader - and to recover weakness about the report management of exsiting GSIS program.

  • PDF

The Design and Implementation of a Spread Sheet WBI for improving Teacher's Information Literacy (교원 정보소양능력 함양을 위한 스프레드시트 WBI 설계 및 구현)

  • Kim, Ko-il;Kim, Myeong-Ryeol
    • The Journal of Korean Association of Computer Education
    • /
    • v.3 no.2
    • /
    • pp.59-66
    • /
    • 2000
  • This study is to design and implement Excel 2000 WBI applying the Cognitive Apprentice Model. Excel 2000 is the most used Spread Sheet program and indispensable for increasing teachers' information literacy. The Cognitive Apprentice Model is one of Constructivism learning models. Constructivism is a new educational paradigm and mainly applied in education fields. This WBI is designed and implemented according to the Cognitive Apprentice Model and composed of practical contents according to Constructivism learning principle which insists learning is occurred in real situation. For more effective interaction the teacher(computer) guides the learners individually and uses a bulletin board, E-mail and chatting room.

  • PDF

Development of Optimal Design User Interface for Waveguide tee Junction using PSO Algorithm and VBA (PSO 알고리즘과 VBA를 이용한 Waveguide tee Junction의 최적설계 인터페이스 개발)

  • Park, Hyun-Soo;Byun, Jin-Kyu;Lee, Dal-Ho;Lee, Hyang-Beom
    • 한국정보통신설비학회:학술대회논문집
    • /
    • 2009.08a
    • /
    • pp.36-39
    • /
    • 2009
  • We developed an optimal design interface based on VBA(Visual Basic Application) that takes advantage of API(Application Program Interface) function of commonly used EM analysis software. The developed interface is adopted for an optimal design of a septum in a waveguide tee junction using PSO(Particle Swarm Optimization) algorithm. The objective function of the optimal design is defined by $S_{11}$-parameter of the waveguide tee junction Design variables are established as position of the septum, that are changed to satisfy the design goal Using the developed design interface and PSO algorithm, the objective function converged to the smallest value, showing the validity of the proposed method. The design interface was developed using Microsoft Excel software, enabling easy control of design parameters for user. Also, various analysis parameters can be set in the Excel interface, including waveguide input mode and frequency. After completion of the design, field solutions at user-specified positrons can be extracted to the output files in complex number form.

  • PDF

A Study on the Automated Generation of Arena Simulation Models Using Conceptual Models (개념 모델을 이용한 Arena 시뮬레이션 모델 자동 생성에 관한 연구)

  • Ra, Hyun-Woo;Choi, Seong-Hoon
    • Journal of the Korea Society for Simulation
    • /
    • v.23 no.4
    • /
    • pp.21-29
    • /
    • 2014
  • In general, a simulation project requires much time and money since we should develop a model that works similarly to the system at a level consistent with the project purposes. Therefore, more active research studies are required to reduce the time needed for the modeling process. This is achievable by minimizing the possible trial and error during the model development process through the appropriate conceptual model design and the automated generation of the simulation model. This paper presents a tool automatically generating an Arena model after developing a conceptual simulation model. Because our proposed tool is based on the popular Microsoft Excel and Visio, it is expected to be practically used at many industrial sites. Finally, we showed the effectiveness of the newly suggested tool by applying it to an imaginary simulation project.

Trend and Prospect on Using Technology in Mathematics Education in Korea (우리나라 수학교육에서 공학 활용의 역사와 현황)

  • Son, Hong-Chan
    • School Mathematics
    • /
    • v.13 no.3
    • /
    • pp.525-542
    • /
    • 2011
  • As teachers need to understand how to select and use technology in mathematics education, analysis on history, characteristics, and effects of various technology used in school mathematics will facilitate effective use of technology. This thesis aims to analyze through literary studies the history, characteristics, and effects of using spreadsheets Excel, dynamic geometry softwares GSP, Cabri and CAS, the most commonly used technology in teaching and learning mathematics in Korea. And we also study the current trends on using technology in mathematics education in Korea by investigating research trend, secondary mathematics curriculums past and present in Korea, mathematics textbooks, and classroom environments.

  • PDF

Replicating the chemical composition of the binder for restoration of historic mortars as an optimization problem

  • Miriello, D.;Lezzerini, M.;Chiaravalloti, F.;Bloise, A.;Apollaro, C.;Crisci, G.M.
    • Computers and Concrete
    • /
    • v.12 no.4
    • /
    • pp.553-563
    • /
    • 2013
  • The present study aims to show how the problem of reproducing, as closely as possible, binders of historic mortars by mixing raw materials which are commercially available, can be formulated as a linear optimization problem. The study points out that by mixing five standard raw materials (end-members) it is possible to obtain mortar binders with the almost same chemical compositions of those determined on the historic and archaeological mortar samples studied in some recent scientific papers. An advanced function of the Microsoft Excel spreadsheet, the Solver add-in, was used for the calculation of the right amount of each raw material to be mixed for producing the new binders. This approach could be useful to provide an optimal solution in the process of restoration of ancient monuments, where it is necessary to replace the historic mortars with new highly compatible repair mortars.

A Real Problem-based Teaching Method in Statistics Education with a Web-based Data Collection Program (웹 기반 자료수집 프로그램을 활용한 실제 문제중심의 통계교육 수업방안)

  • Han, Beom-Soo;Han, Kyung-Soo;Ahn, Jeong-Yong
    • Journal of the Korean School Mathematics Society
    • /
    • v.8 no.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.

  • PDF

Development of Program for Predicting GBD to Improve Canning Process Capability for Catalytic Converter (촉매변환기의 캐닝 공정능력 향상을 위한 GBD 예측 프로그램의 개발)

  • Lee, Young Dae;Chu, Seok Jae
    • Transactions of the Korean Society of Mechanical Engineers A
    • /
    • v.37 no.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.

Information Literacy Education and the Impact of Self Awareness on Information Literacy and Libraries (정보활용 교육이 도서관과 정보활용능력 자가인식에 미치는 영향)

  • Jung, Young-Mi
    • Journal of the Korean Society for Library and Information Science
    • /
    • v.43 no.4
    • /
    • pp.265-280
    • /
    • 2009
  • This study investigated whether information literacy education contributes to change and improvement in university students' self awareness of information literacy and libraries. The pre-test and the post-test which comprised the same questions on information literacy and libraries were executed on 47 students in an information literacy-related regular course at D University. The information literacy-related questions in the questionnaire were based on ACRL Information Literacy Competency Standards for Higher Education. The collected data were analyzed using Excel and SPSS.