Excel在规划论教学中的应用  

The Application of Excel in the Teaching of Programming Theory

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

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

出　　处：《内江师范学院学报》2012年第10期82-85,共4页Journal of Neijiang Normal University

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

摘　　要：首先介绍了Excel求解规划问题的使用方法和技巧,分析了应用Excel计算规划问题时所得结果的区别;其次,对教学中学生在应用Excel计算规划问题时常见的错误进行了分析,并提出相应的解决措施;最后,讨论了教学中引入Excel的重要意义.Introduced first in the paper were methods and skills concerning the use of Excel for solving programming problems and the differences of the results thus obtained were also investigated. Next, common errors in the application of Excel for solving programming problems were also examined and possible countermeasures are put forth for students to avoid repeating similar mistakes. Finally, the importance for incorporating Excel into the teaching of the programming theory is put under examination.

关 键 词：线性规划 唯一解 sumproduct函数 

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