CONTRIBUTION OF A LINEAR PROGRAMMING VBA MODULE TO STUDENTS PEFORMANCE

Authors

  • Petr Kučera Czech University of Life Sciences Prague
  • Igor Krejčí Czech University of Life Sciences Prague
  • Hana Vydrová Czech University of Life Sciences Prague
  • Lenka Kučírková Czech University of Life Sciences Prague

Keywords:

Education, Linear programming, Traveling Salesman Problem, Paired t-Test, McNemar Test, Pearson Contingency Coefficient, Item Analysis

Abstract

This paper deals with the application of freeware modules as a teaching support of Operations Research methods at the Department of Systems Engineering, Czech university of Life Sciences (CULS) Prague. In particular, we concentrated on a linear programming module and measured the impact on student performance. The motivation for this evaluation is based on a current development of a new module that focuses on Traveling Salesman Problem. First, we explain the current situation both worldwide and in the Czech Republic and the CULS Prague. Subsequently, we describe the content of students’ exams and statistical methods applied to the evaluation. Finally, we analyze and generalize the obtained results. The students exams have show a positive impact of the modules. Further, our analysis has proven that this impact is statistically significant. The findings motivate us to made new modules for other methods.

References

Benešová, A., Skočdopolová, V., Kuncová, M. (2010) ‘MS Excel Add-in Applications in MCDM Education’, Proceedings of the 7th International Conference on ERIE 2010, pp. 33-41. 

de Champlain, A.F. (2010) ‘A Primer on Classical Test Theory and Item Response Theory for Assessments in Medical Education’, Medical Education, vol. 44, no. 1, pp. 109-117. 

de Mesquita, M.A., Hernandez, A.E. (2006) ‘Discrete-Event Simulation of Queues with Spreadsheets: A Teaching Case’, Proceedings - Winter Simulation Conference, Art. no. 4117880, pp. 2277-2283. 

Elizandro, D., Matson, J. (2005) ‘Discrete Event Simulation Using Excel/VBA’, ASEE Annual Conference and Exposition, Conference Proceedings, pp. 4673-4683.

Grossman Jr., T.A. (1999) ‘Teachers' Forum: Spreadsheet Modeling and Simulation Improves Understanding of Queues’, Interfaces, vol. 29, no. 3, pp. 88-103. 

Hall, J.A.J., McKinnon, K.I.M. (2004) ‘The Simplest Examples Where the Simplex Method Cycles and Conditions Where EXPAND Fails to Prevent Cycling’, Mathematical Programming, vol. 100, no. 1, pp. 133-150.    

Hendl, J. (2004) Přehled statistických metod zpracování dat – Analýza a metaanalýza dat, Prague: Portál.

Kučera, P., Krejčí, I., Vydrová, H., Kučírková, L. (2010) ‘Educational Impact of VBA Modules’, Proceedings of the 7th International Conference on ERIE 2010, pp. 196-202. 

Lagová, M., Kalčevová, J. (2008) ‘Automatic Testing Framework for Linear Optimization Problems’, Proceedings of the 26th International Conference on Mathematical Methods in Economics 2008, pp. 317-321.

Lagová, M., Kalčevová, J. (2006) ‘Computer Support of Courses of Linear Optimization Models’, Proceedings of the 24th International Conference on Mathematical Methods in Economics 2006, pp. 333-337. 

Lagová, M., Kalčevová, J. (2007) ‘Linear Programming by the Game - Computer Support of Courses’, Proceedings of the 25th International Conference on Mathematical Methods in Economics 2007, pp. 188-194. 

LeBlanc, L.J., Galbreth, M.R. (2007) ‘Implementing Large-Scale Optimization Models in Excel Using VBA’, Interfaces, vol. 37, no. 4, pp. 370-382. 

Lonn, S., Teasley, S.D. (2009) ‘Saving Time or Innovating Practice: Investigating Perceptions and Uses of Learning Management Systems’, Computers and Education, vol. 53, no. 3, pp 686-694.

Martin, A. (2000) ‘An Iintegrated Introduction to Spreadsheet and Programming Skills for Operational Research Students’, Journal of the Operational Research Society, vol. 51, no. 12, pp. 1399-1408. 

McNemar, Q. (1947) ‘Note on the Sampling Error of the Difference Between Correlated Proportions or Percentages’, Psychometrika, vol. 12, no. 2, pp. 153-157. 

Nassar, K. (2002) ‘Simulation Gaming in Construction: ER, the Equipment Replacement Game’, Journal of Construction Education, vol. 7, no. 1, pp. 16-30. 

Pataki, G. (2003) ‘Teaching Integer Programming Formulations Using the Traveling Salesman Problem’, SIAM Review, vol. 45, no. 1, pp. 116-123. 

Tehrani Nejad Moghaddam, A., Michelot, C. A (2009) ‘Contribution to the Linear Programming Approach to Joint Cost Allocation: Methodology and Application’, European Journal of Operational Research, vol. 197, no. 3, pp. 999-1011.

Zach, P., Holoubek, J., Kolman, P. (2010) ‘Animated Critical Path Method’, Proceedings of the 7th International Conference on ERIE 2010, pp. 183-291.

Zimmerman, D.W.A, (1997) ‘Note on Interpretation of the Paired-Samples t Test’, Journal of Educational and Behavioral Statistics, vol. 22, no. 3, pp. 349-360. 

Additional Files

Published

2010-12-31

How to Cite

Kučera, P., Krejčí, I., Vydrová, H. and Kučírková, L. (2010) ’CONTRIBUTION OF A LINEAR PROGRAMMING VBA MODULE TO STUDENTS PEFORMANCE’, Journal on Efficiency and Responsibility in Education and Science, vol. 3, no. 2, pp. 54–65. Retrieved from https://www.eriesjournal.com/index.php/eries/article/view/25

Issue

Vol. 3 No. 2 (2010)

Section

Research Paper

License

Authors declare with this manuscript intended for publication to ERIES Journal that:

  • all co-authors agree with the publication of the manuscript even after amendments arising from peer review;
  • all co-authors agree with the posting of the full text of this work on the web page of ERIES Journal and to the inclusion of references in databases accessible on the internet;
  • no results of other researchers were used in the submitted manuscript without their consent, proper citation, or acknowledgement of their cooperation or material provided;
  • the results (or any part of them) used in the manuscript have not been sent for publication to any other journal nor have they already been published (or if so, that the relevant works are cited in this manuscript);
  • submission of the manuscript for publication was completed in accordance with the publishing regulations pertaining to place of work;
  • experiments performed comply with current laws and written consent of the Scientific Ethics Committee / National Animal Care Authority (as is mentioned in the manuscript submitted);
  • grant holders confirm that they have been informed of the submitted manuscript and they agree to its publication.

Authors retain copyright and grant ERIES Journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the published work with an acknowledgement of its initial publication in ERIES Journal. Moreover, authors are able to post the published work in an institutional repository with an acknowledgement of its initial publication in ERIES Journal. In addition, authors are permitted and encouraged to post the published work online (e.g. institutional repositories or on their website) as it can lead to productive exchanges, as well as earlier and greater citation of published work.

Most read articles by the same author(s)