生态环境规划课程的电子表格建模教育研究

Modeling Approach with Spreadsheets to the Teaching of Ecological Planning

针对课程中有关现代规划建模工具的薄弱教学环节,利用Excel可很好地结合具体案例,求解规划问题便利和灵活,增加学生对知识的直观了解等诸多优势,提出全面加强生态环境规划课程的电子表格建模教育。在进行了7年以上的教学实践后,发现Excel电子表格建模引入生态环境规划教学过程,于大量教学环节中加以实施和运用,将提高课程趣味,有效节约学生学习时间和巩固学习效果。Excel电子表格建模面向其他生态学领域的学习还具有拓展性,对学生后续教育和今后的职业发展促进帮助作用明显。

Spreadsheet modeling techniques are more efficient and mature transparent in solving various planning cases. Students find it more natural and comfortable to do their modeling directly in a spreadsheet. However, modern spreadsheet software, including Microsoft Excel was sel- dom used in the teaching of ecological planning. We broke out the old mold and presented new and innovative ways of teaching ecological plan- ning by using the spreadsheet modeling techniques. Students find it more natural and comfortable to do their modeling directly in Microsoft Excel. With the new teaching way for applying this full-fledged approach in ecological planning courses through over seven years, our experience was this approach would make the class more enjoyable and stimulating while also saving the time expense and enhancing the effectiveness of the lessons to be learned. Modeling approach with Microsoft Excel had supplementary advantages in other teaching of ecology science. In addition, students also improved upon helpful Excel skills to increase values of their further education and careers.