Spreadsheet教学法在重心法选址中的教学研究与应用

Teaching Study and Application on the Location Selection by Gravity Approach Based on Spreadsheet Teaching Method

  • 摘要: 在物流类专业的本科教学中,为了使学生更有效率地应用重心法进行配送中心选址,采纳Spreadsheet教学法快速有效解决问题的思想,将软件应用作为教学的核心,而非单纯强调理论推导及复杂运算。文中应用并比较了Excel、Lingo、Logware-cog三种软件,并从迭代次数、选址直观性及学生学习难易度三方面进行比较,分析各自的优缺点,并提出进一步的研究方向。

     

    Abstract: In the logistics professional teaching for undergraduates, to strengthen their ability to locate selection by gravity approach more efficiently, this paper adopts the Spreadsheet teaching method, which focuses on solving problem with high speed, rather than theoretical derivation and complicated calculating, and software application becomes the key. Then, this paper tries to use three kinds of software to solve the gravity problem, that is excel, lingo, logware-cog, and make a further compare of them from three aspects: iterative time, visibility and the difficulty level for bachelor student to learn. Finally, this paper put forward the further research directionon software development.

     

/

返回文章
返回