Effectiveness of Excel-based Teaching Method for Management Science

엑셀을 활용한 경영과학 강의방식의 효과에 관한 연구

  • 정기호 (경성대학교 디지털비즈니스학부)
  • Published : 2005.11.01

Abstract

New method has been widely used for teaching Management Science since the mid of 1990s. The new teaching method is distinguished from traditional method in several aspects. The mowt distintion of the new method is that Excel based approach is used in order to model and analyze quantitative problems. Due to the introduction of Excel based teaching method model formulation and interpretation is more emphasized than algorithms. By using this new method students are expected to be more interested in Management Science class and easily use several Management Science techniques in real world problems. Though Excel based teaching method has become more prevalent, there exist no empirical research to analyze the effectiveness of Excel based teaching method. This paper will empirically analyze how effective Excel based teaching method is. For this purpose survey data are collected fro professors teaching Management Science and analyzed by using t-test.

Keywords

References

  1. 정기호, 경영과학 교과목의 새로운 강의방식, 2001년 한국경영과학회 추계학술대회 튜토리알 II, 서울 KAIST, 2001
  2. 정기호, '스프레드시트를 기반으로 한 새로운 경영과학 강의방식', 경영과학, 제19권, 제2호(2002), pp.41-58
  3. Albright, S.C. and W.L. Winston, Spreadsheet Modeling and Applications : Essentials of Practical Management Science, Thomson Brooks/Cole, Belmont, CA, 2005
  4. Caine, D.J. and A.J. Robson, 'Spreadsheet Modelling : Guidelines for Model Development,' Management Decision, Vol.31, No.1 (1993), pp.38-44
  5. Cole, S. and J. Rowley, 'Spreadsheet Modelling for Management Decision Making,' Industrial Management & Data Systems, Vol.96, No.7(1996), pp.17-23
  6. Conway, D.G. and C.T. Ragsdale, 'Modeling Optimization Problems in the Unstructured World of Spreadsheets,' Omega International Journal of Management Science, Vol.25, No.3(1997), pp.313-322 https://doi.org/10.1016/S0305-0483(97)00004-2
  7. Grossman, T.A. Jr., 'Causes of Decline of the Business School Management Science Course,' INFORMS Transactions on Education, Vol.1, No.2(2001), pp.51-61
  8. Grossman, T.A., 'Spreadsheet Add-Ins for OR/MS,' OR/MS Today, Vol.29, No.4(2002)
  9. Grossman, T.A., 'Spreadsheet Add-Ins for OR/MS Software Survey,' OR/MS Today, Vol.29, No.4(2002)
  10. Grossman, T.A., 'Getting Down to Business,' OR/MS Today, Vol.30, No.4(2003)
  11. Jones, J.M., 'Decision Analysis Using S-preadsheets,' European Journal of Operational Research, Vol.26, No.3(1986), pp.385-400 https://doi.org/10.1016/0377-2217(86)90141-4
  12. Kharab, A, 'An Advanced Macro Spreadsheet Program for the Simplex Method,' Computers & Operations Research, Vol. 27, No.3(2000), pp.233-243 https://doi.org/10.1016/S0305-0548(99)00032-5
  13. Leon, L., Z. Przasnyski, and K.C. Seal, 'Spreadsheets and OR/MS Models : An End-User Perspective,' Interfaces, Vol.26, No.2(1996), pp.92-104 https://doi.org/10.1287/inte.26.2.92
  14. Pemberton, J.D. and A.J. Robson, 'Spreadsheet in Business,' Industrial Management and Data Systems, Vol.100, No.8(2000), pp.379-388 https://doi.org/10.1108/02635570010353938
  15. Plane, D.R., Management Science : A Spreadsheet Approach, Scientific Press, Danvers, MA, 1994
  16. Powell, S.G., 'Teaching Modeling in Management Science,' INFORMS Transactions on Education, Vol.1, No.2(2001), pp.62-67
  17. Ragsdale, C.T., Spreadsheet Modeling and Decision Analysis, South-Western College Publishing, Cincinnati, OH, 1997
  18. Ragsdale, C.T., 'Teaching Management Science with Spreadsheets: From Decision Models to Decision Support,' INFORMS Transactions on Education, Vol.1, No.2 (2001), pp.68-74
  19. Robson, A.J., 'The Spreadsheet : How It Has Developed into a Sophisticated Modelling Tool,' Logistics Information Management, Vol.7, No.1(1994), pp.17-23 https://doi.org/10.1108/09576059410052340
  20. Thiriez, H., 'Improved OR Education through the Use of Spreadsheet Models,' European Journal of Operational Research, Vol.135, No.3(2001), pp.461-476 https://doi.org/10.1016/S0377-2217(01)00099-6
  21. Winston, W.L., 'The Teachers' Forum : Management Science with Spreadsheets for MBAs at Indiana University,' Interfaces, Vol.26, No.2(1996), pp.105-111
  22. Winston, W.L. and S.C. Albright, Practical Management Science : Spreadsheet Modeling and Applications, Duxbury Press, Belmont. CA. 1997