Creating Individualized Data Sets for Student Exercises Using Microsoft Excel and Visual Basic

INFORMS Transactions on Education

Don G. Wardell¹  Weiyu Tsai¹ 

[1] Management Department David Eccles School of Business, University of Utah, 1645 E. Campus Center Dr. #106, Salt Lake City, Utah 84112

关键词: Excel macros;    teaching OR/MS;    Data Generator;    data set generation;   

DOI  :  10.1287/ited.7.1.136

学科分类：社会科学、人文和艺术（综合）

来源: INFORMS

【 摘 要 】

In this paper we describe an approach that utilizes Excel macros to help OR/MS instructors to enhance and assess their students' learning. We begin by explaining a specific macro, Data Generator, which mainly helps statistics instructors to create assignment questions where numbers or data sets used in the questions are randomly generated according to the instructions specified by instructors. Because of the potentially narrow application range of our particular macro, we also describe an approach that can be used for more general questions. For the most part, this more general approach requires simply recording a macro and then pasting a few other instructions into the resulting code to make the recorded macro more user-friendly. We also provide a suggested procedure to help instructors to grade the students' answers automatically.

【 授权许可】

CC BY