运筹学教学中Excel的应用研究  

On Application of Excel in Teaching of Operational Research

作　　者：李如兵[1] 宗凤喜[1] 

机构地区：[1]曲靖师范学院数学与信息科学学院,云南曲靖655011

出　　处：《绵阳师范学院学报》2012年第8期148-152,共5页Journal of Mianyang Teachers＇ College

基　　金：曲靖师范学院科学研究青年基金(2009QN015)

摘　　要：论文首先讨论了运筹学教学中引入Excel的重要意义,其次,介绍了Excel在运筹学中的使用方法和技巧,分析了应用Excel计算规划问题时出现的四种结果的区别;最后,对教学中学生在应用Excel计算规划问题时常见的错误进行了分析,并提出了解决措施。This paper is first to introduce the usages of skills of Excel in Operational Research, analyze the differences among the four consequences from the use of Excel in calculating programming ; then, list the common mistakes made by students when they use Excel to calculate, and put forward the measures for solution; and in the end, focuse on the significance of introduction of Excel in teaching Operational Research.

关 键 词：线性规划 运筹学 唯一解 EXCEL应用 

分 类 号：O221.1[理学—运筹学与控制论]