Journal of Practical Engineering Education (실천공학교육논문지)

Korean Institute for Pratical Engineering Education (한국실천공학교육학회)
권호 표지
DOI QR코드

DOI QR Code

Curriculum of Basic Data Science Practices for Non-majors

비전공자 대상 기초 데이터과학 실습 커리큘럼

  • Hur, Kyeong (Department of Computer Education, Gyeong-In National University of Education)
  • 허경 (경인교육대학교 컴퓨터교육과)
  • Received : 2020.10.29
  • Accepted : 2020.11.30
  • Published : 2020.12.01
Download PDF
⟨ Previous Next ⟩

Abstract

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.

본 논문에서는 비전공자들을 위한 교양과목으로 적용할 수 있는 기초 데이터과학 실습 커리큘럼을 제안하고, 엑셀(스프레드시트) 데이터 분석 도구를 활용한 교육 방법을 제안하였다. 데이터 수집, 데이터 가공 및 데이터 분석을 위한 도구에는 엑셀, R, 파이썬, SQL(Structured Query Language) 등이 있다. R, 파이썬 및 SQL은 데이터 과학을 실습하는 데 있어, 프로그래밍 언어와 자료구조를 이해해야 한다. 반면에, 엑셀 도구는 비전공자들에게도 친숙한 데이터 분석도구로서, 프로그래밍 언어에 대한 학습 부담이 없다. 그리고 기초적인 데이터과학 실습을 엑셀로 진행하면, 데이터과학 이론을 습득하는 데 집중할 수 있는 장점이 있다. 본 논문에서는 한 학기 분량의 기초 데이터과학 실습 커리큘럼과 주별 엑셀 실습 내용을 제안하였다. 그리고, 교육 내용 실체를 실증하기위해, 엑셀 데이터분석 도구를 활용하여, 선형 회귀 분석(Linear Regression Analysis) 예제들을 제시하였다.

Keywords

References

  1. Ministry of Science and ICT, "The 4th industrial revolution in history," R & D KIOSK, No. 40, September 2017.
  2. Ministry of Science and ICT, "The various aspects of the fourth industrial revolution, The Realized Future," R & D KIOSK, No. 41, October 2017.
  3. J. Y. Kim, "Hello data science," Seoul : Hanbit Media, 2016.
  4. J. K. Kwon, "Learning data science," Seoul : Jpub, 2020.
  5. U. Ichiro, N. Hiroaki, A. Masami, and M. Eichi, "Learning data science with excel," Seoul : Hanbit Media, 2020.
  6. Ministry of Science and ICT, "Beyond an IT powerhouse to an AI powerhouse," Report Material, 2019.
  7. Joint Ministries, Artificial intelligence national strategy, Report Material, 2019.
  8. Y. J. Jang, "Searching for the direction of data science education in the era of the 4th industrial revolution," Integrated Humanities Research, vol. 9, no. 10, pp. 155-180, 2017.
  9. Y. S. Park and S. J. Lee, "Study on the direction of universal big data and big data education-based on the survey of big data experts," Journal of the Korean Association of Information Education, vol. 24, no. 2, pp. 201-214, April 2020. https://doi.org/10.14352/jkaie.2020.24.2.201
  10. Y. M. Kim and J. H. Kim, "Effect of data science education program using spreadsheet on improvement of elementary school computational thinking," Journal of The Korean Association of Information Education, vol. 21, no. 2, pp. 219-230, April 2017. https://doi.org/10.14352/jkaie.21.2.219
  11. J. S. Lee, "A study on visualization methods and expressions of information design for big data, basic formulation studies," vol. 14, no. 3, pp. 261-269, June 2013.
  12. ADDIE Model, Wikipedia, 2020, [Online]. Available: https://ko.wikipedia.org/wiki/ADDIE _%EB%AA%A8%ED%98%95.