基于电子表格和网络地图的重心法选址实验设计  

Study on the Improvement of Experiment Teaching of Gravity Center Location Based on Spreadsheet and Web Map

作　　者：祁玉青[1] 蒋南云[1] 倪卫红[1] QI Yuqing;JIANG Nanyun;NI Weihong(School of Economics and Management,Nanjing Technology University,Nanjing 211816,China)

机构地区：[1]南京工业大学经济与管理学院

出　　处：《实验科学与技术》2019年第5期120-124,共5页Experiment Science and Technology

基　　金：江苏省高校哲学社会科学基金(2014SJB082);江苏省社科基金青年项目(17GLC009);国家自然科学青年基金(71701092)

摘　　要：重心法选址实验是"物流系统设计"教学中的一个重点和难点。传统的教学过程由教师提供实验数据、安排实验步骤,不利于激发学生的探索热情和实验兴趣。该文将电子表格软件和网络地图工具结合起来,重新设计和安排重心法选址的实验教学过程;同时针对多数教材缺乏利用电子表格软件进行多设施重心法选址实验的现状,探讨利用电子表格软件进行多设施选址问题建模的可行性。通过建立多设施选址问题的数学模型,并用Excel电子表格软件进行示例分析,在满足一般实验环境要求的情况下,对传统重心法选址实验教学过程进行了改进和再设计,进一步激发了学生的学习兴趣和探索热情。The use of the center of gravity method to select the address experiment is a key and difficult point in the teaching of"logistics system design". The traditional teaching process is provided by teachers to provide experimental data and arrange experimental steps,which is not conducive to stimulating students’ exploration enthusiasm and experimental interest. This article combines spreadsheet software and web map tools to redesign and arrange the experimental teaching process for the location of the center of gravity. Because most textbooks lack the use of spreadsheet software for multi-facilities centering site selection experiments,this paper explores the feasibility of using spreadsheet software to model multi-facility location problems. By establishing a mathematical model of multi-facility siting problems and using Excel spreadsheet software for example analysis,the traditional gravity center location experiment teaching process was improved and redesigned,and the student’s learning interest and exploration enthusiasm were stimulated,while satisfying the requirements of the general experimental environment.

关 键 词：电子表格 重心法 实验 教学设计 

分 类 号：G642.0[文化科学—高等教育学] F224[文化科学—教育学]