Logo image
Back
Learning Management System-Integrated Spreadsheet Exercises for Facility Location Modeling
Encyclopedia entry   Peer reviewed

Learning Management System-Integrated Spreadsheet Exercises for Facility Location Modeling

Joshua K. Strakos and Vitaly Brazhkin
Decision sciences journal of innovative education, Vol.20(1), pp.29-42
Wiley
01/2022
DOI: https://doi.org/10.1111/dsji.12252
Web of Science ID: WOS:000675661700001

Metrics

71 Record Views
6 Times Cited - Web of Science

Abstract

Supply chain management students are introduced to a variety of modeling concepts. Yet learning facility location and capacity allocation modeling to the level of application and mastery proves difficult for the typical undergraduate business student. Spreadsheets facilitate the teaching of optimization modeling; however, providing feedback to students on spreadsheet assignments is an onerous and time-consuming task for instructors. In this teaching brief, a set of learning management system (LMS)-integrated spreadsheet exercises is presented which helps students learn spreadsheet modeling for the capacitated plant location problem. These exercises are also designed to reduce the instructor's grading burden while providing timely feedback and assessment of student performance. The effectiveness of the exercises is demonstrated by assessment data gathered from the LMS as well as postmodule student survey results.

Details

Logo image