TEACHING SIMULATION WITH SPREADSHEETS
TEACHING SIMULATION WITH SPREADSHEETS
复制标题
使用电子表格进行模拟教学
DOI：
--
复制
发表时间：
2005
期刊：
影响因子：
--
通讯作者：
Y. Merkuryev
中科院分区：
文献类型：
--
作者：
J. Pecherska;Y. Merkuryev
本文重点介绍了一种基于电子表格的教学模拟方法。我们的目标是介绍电子表格作为一个强大的模拟工具，用于教育目的。电子表格模拟有助于熟悉模拟软件之外的基本模拟概念。本文论述了适用于电子表格的仿真模型的基本类型。通过一个提前期需求分布评价的实例模型，介绍了静态随机或蒙特卡罗仿真模型。并对两种主要的动态仿真电子表格模型进行了综述。介绍了离散事件系统仿真的基本概念，并通过对一个两服务台的单队列系统的仿真来说明离散事件系统仿真的基本方法。种群动力学模拟模型体现了系统动力学的概念。电子表格上提供的基本模拟模型类型使研究模拟概念，方法和技术以及使用电子表格进行商业游戏，案例研究，工程等方面的模拟。概述了使用电子表格进行教学模拟的经验，结果表明电子表格作为替代模拟软件。
This paper focuses on a spreadsheet-based approach to teaching simulation. The objective is to introduce spreadsheets as a powerful simulation tool for educational purposes. The spreadsheet simulation facilitates the familiarisation with basic simulation concepts apart from simulation software. The paper deals with basic types of simulation models suitable for spreadsheets. The static stochastic or Monte Carlo simulation models are introduced through a sample model for lead-time demand distribution evaluation. The two main types of dynamic simulation spreadsheets models are overviewed as well. The discrete-event system simulation basic concepts are introduced by simulating a two-server system with a single queue. A population dynamics simulation model presents the System Dynamics concepts. The basic simulation model types that are available on spreadsheets make it possible to study simulation concepts, methodology, and techniques as well as to use spreadsheets for on-hand simulation in business games, case studies, engineering, etc. The overviewed experiences in using spreadsheets for teaching simulation result in indication of spreadsheets as an alternative simulation software.