Excel在规划论教学中的应用

The Application of Excel in the Teaching of Programming Theory

摘要

摘要:首先介绍了Excel求解规划问题的使用方法和技巧,分析了应用Excel计算规划问题时所得结果的区别;其次,对教学中学生在应用Excel计算规划问题时常见的错误进行了分析,并提出相应的解决措施;最后,讨论了教学中引入Excel的重要意义

Abstract: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.