Development of process-oriented education tool for Statistics with Excel Macro

엑셀 매크로를 이용한 절차 중심 통계교육도구 개발

  • Received : 2011.05.08
  • Accepted : 2011.06.15
  • Published : 2011.08.01

Abstract

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.

References

  1. 신성도, 최명복 (1998). <내마음대로 활용하는 엑셀 매크로>, 기전연구사, 서울.
  2. 이정용 (2008). 엑셀 매크로(MACRO) 기능을 이용한 통계학 참여수업의 예. <응용통계연구>, 21, 355-359.
  3. 우덕관, 오창혁 (2010). 굽힌 동전의 확률. <한국데이터정보과학회지>, 21, 147-153.
  4. 조신섭, 송문섭, 이윤모, 성병찬, 윤영주, 이현부 (1998). 기초통계교육을 위한 통계패키지의 비교 연구 및 엑셀을이용한 한글 통계패키지의 구현. <한국통계학회 춘계학술발표회 논문집>.
  5. 조신섭, 송문섭, 이윤모, 성병찬, 윤영주, 이현부 (1999). 기초통계교육을 위한 통계소프트웨어의 개발 -Excel에 기초한-. <품질경영학회지>, 27, 277-290.
  6. 최현석 (2010). 엑셀매크로를 이용한 통계교육. <한국통계학회 추계학술발표회 논문집>.
  7. Choi, H. S. (2006). A program for teaching type 1 and type 2 errors. Journal of the Korean Data & Information Science Society, 17, 19-30.
  8. Choi, H. S. and Kim, T. Y. (2010). A study on sampling using the function of excel. Journal of the Korean Data & Information Science Society, 21, 481-491.
  9. Choi, H. S. and Kim, T. Y. (2008). Various central limit theorem simulators with microsoft excel. Far East Journal of Theoretical Statistics, 24, 61-71.
  10. Jacobson, R. (2002). Microsoft excel 2002 visual basic step by step, Microsoft Press, Washington.
  11. Oh, C., Lee, S. and Lee, H. J. (2006). A web-based SAS system for lab statistics. Journal of the Korean Data & Information Science Society, 17, 395-400.
  12. Walkenbach, J. (2004). Excel 2003 power programming with VBA, Wiley Publishing, New York.