• Title/Summary/Keyword: 엑셀

Search Result 266, Processing Time 0.022 seconds

A Case Study on Application of Linear Function using Excel (엑셀을 통한 일차함수의 활용에 대한 사례연구)

  • Lee, Kwang-Sang
    • School Mathematics
    • /
    • v.10 no.1
    • /
    • pp.1-22
    • /
    • 2008
  • The purpose of this study is to search the effective teaching-learning program by considering how affect on formation of linear function using Excel. This study was based on qualitative case study. The teaching experiment using Excel executed with five 8th graders' students for second research content. Teaching experiment was performed for two classes. Collecting the data was conducted via observations and interviews with students. The data include audio and video recording of the students' work, students' worksheets and detailed field notes. The conclusions drawn from teaching experiment are as follows: First, when students explored relevancy content of function in Excel environment, formation of concept of function was facilitated by experiencing operation of algebraic formulas, tables and graphs. We could infer that formation of concept was effected by conjecture activity and iterative process of feedback through Excel environment. Second, the students explored the changes very interestingly making algebraic formulas and presenting tables and graphs. The students were familiarized with observation on algebraic formulas, graphs and tables concurrently. Also, they tried to look for general rules through inductive observation. According to this study, we noticed that exploration teaming environment using Excel could supplement paper-and-pencil environment.

  • PDF

Application of MS Excel in Teaching Statics (엑셀 프로그램을 활용한 정역학 교육 사례)

  • Kim, Youngheub
    • Transactions of the KSME C: Technology and Education
    • /
    • v.2 no.1
    • /
    • pp.21-28
    • /
    • 2014
  • As one of the most famous spreadsheet programs that is widely applied to a variety of fields in business, MS Excel has also been used for educational purposes due to its feature of wide accessibility, enabling students to use the program through almost any kind of PC that now exists. The program is mainly used for numerical analysis and formulae applications in the fields of science and engineering. This paper shall provide the key to understanding the application of MS Excel to teaching Statics through the illustration of its essential functions for education. Also, the development process of the analysis program using macros and VBA(Visual Basic for Applications) is described for the deeper comprehension of advanced applications. Students were not only able to solve the Statics problems using basic features of MS Excel, but also discovered new systematic methods of approaching complex problems and developed application programs using macros and VBA.

Design of Efficient Data Search Function using the Excel VBA DAO (엑셀 VBA DAO 기능을 이용한 효율적인 데이타 검색 기능 설계)

  • Jang, Seung Ju;Ryu, Dae-Hyun
    • Journal of the Korea Institute of Information and Communication Engineering
    • /
    • v.18 no.1
    • /
    • pp.217-222
    • /
    • 2014
  • In this paper, I propose an efficient data search system using data partitioning algorithm in Microsoft Excel. I propose searching algorithm to retrieve data quickly using VBA functioning in the Excel. This algorithm is to specify the sheet you are looking for. Once the sheet is specified, the algorithm searches the beginning and the end of the data in the sheet. The algorithm compares intermediate values and key words, from the starting position of the cell. In this way, it will search data to the end. This proposed algorithm was implemented and tested in the Excel system using VBA program. The experimental results showed that the performance was better than that of the conventional sequential search method.

Design of Data Search Function using the Excel VBA (VBA를 이용한 엑셀 데이타 검색 기능 개발)

  • Janf, Seung Ju
    • 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.

  • PDF

파이겐바움 분기도를 그리는 과정에서 엑셀의 활용

  • An, Dae-Yeong
    • Communications of Mathematical Education
    • /
    • v.15
    • /
    • pp.255-260
    • /
    • 2003
  • 1980년을 전후하여 카오스연구가 물리학에서 왕성하게 이루어졌다. 미국의 물리학자 파이겐바움(M. J. Feigenbaum)이 보편상수를 발견한 것이(1978) 중요한 계기가 되었다. 파이겐바움의 보편상수는 카오스현상에서 공통적으로 발견할 수 있다. 보편상수를 탐구하기 위해서는 주기, 배가, 파이겐바움 분기도에 대한 이해가 필요하다. 프로그래밍을 통하여 일반적으로 소개하고 있으므로, 프로그래밍에 대한 깊은 이해없이는 분기도를 탐구하기 어렵다. 프로그래밍을 통해서는 나타나는 결과만을 이해할 수 있다. 이 논문에서는 학습자가 프로그래밍 이전에 엑셀의 기능을 이용하여 파이겐바움 분기도를 그릴 수 있는 방법을 제시하고, 파이겐바움의 주기에 대해 엑셀을 이용하여 시각적으로 이해할 수 있도록 한다.

  • PDF

A case study of MS Excel's powerful functions for statistical data analysis. (Focused on an Analysis of Variance menu) (자료 통계 분석을 위한 MS 엑셀의 유용한 기능들에 관한 사례연구 (지하철 이용객 자료 분석))

  • Kim, Sook-Young
    • Journal of the Korea Computer Industry Society
    • /
    • v.9 no.5
    • /
    • pp.223-228
    • /
    • 2008
  • A case study to show MS Excel's convenient and powerful functions was conducted to test hypotheses with subway data. Quantitative variables were described using descriptive menu, and qualitative variables were described using histogram menu of a MS Excel software. Relationships were tested using regression menu, differences were tested using t-test menu, and factors were tested using variance-layout menu of a Excel software. Data input, management, and statistical analysis were done successfully with only a MS Excel software.

  • PDF

Usage analysis of library's twitter and homepage by using NodeXL program (노드 엑셀 네트워크 분석을 통한 국내 도서관 홈페이지와 트위터 활용도 연구)

  • Kim, Soon
    • Proceedings of the Korean Society for Information Management Conference
    • /
    • 2013.08a
    • /
    • pp.171-174
    • /
    • 2013
  • 본 연구는 국내외 도서관의 소셜네트워크 서비스 현황을 살펴보고, 노드엑셀을 이용한 네트워크 분석 기법을 통해, 도서관 소셜미디어 활용도에 대해 조사하였다. 국내에서 소셜미디어 홍보를 제일 적극적으로 하고 있는 P대학의 트위터를 노드엑셀을 통해 매개중심성으로 분석해 본 결과 상위 파워트위터리안들을 알 수 있었으며, 추후 도서관 마켓팅에서 핵심이용자로 적극 관리할 필요성이 있음을 보여주고 있다. 홈페이지 이용도는 국내 의과대학 중 의학도서관 홈페이지상에 데이터베이스로 직접 URL 연동되어 있는 K대학 홈페이지를 보손(Voson)과 노드엑셀 네트워크 분석방법을 이용하여 분석해 본 결과, 상업출판사외에 NDSL이 가장 상위로 랭크되어 홈페이지의 활용도가 높음을 알 수 있었다.

  • PDF

Curriculum of Basic Data Science Practices for Non-majors (비전공자 대상 기초 데이터과학 실습 커리큘럼)

  • Hur, Kyeong
    • 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.

A Comparative Study of the Accelerator and Venture Capital through Investment Behavior (투자 행태를 통한 엑셀러레이터와 벤처캐피탈의 비교 연구)

  • Choi, Yunsoo;Kim, Dohyeon
    • Asia-Pacific Journal of Business Venturing and Entrepreneurship
    • /
    • v.11 no.4
    • /
    • pp.27-36
    • /
    • 2016
  • Venture companies, which can commercialize various kinds of new ideas and creating added value, are amid of great attention. Since most of venture companies in initial development stages cannot finance its capital sufficiently all by their own, investments from outside investors are key factor to their survival. However, they have lots of difficulties in financing from outside investors because of their typical uncertain but favorable investment characteristics. Moreover, even though they had successfully financed from outsiders, problems related to their stakeholders, such as interrupting in management and types of investments, cause contrary results to firms. Therefore there are various kinds of systems for startups like angels, venture capitals and governmental supports. Even so, investments and supports for venture companies are still not sufficient. 'Accelerator', which is a brand-new investment type started from Silicon Valley in United States during the mid 2000, is growing attention these-days. It mainly supports startups financially in the initial development stages, however, it also supports the firms by providing mentoring, education and networking services. On the other hand, difference between existing investment types and performance of the investment is still in controversy. Therefore this study compared investment behavior between accelerator and venture capital. As a result, we found that the difference in investment behavior of accelerators and venture capital.

  • PDF