Learning Management System-Integrated Spreadsheet Exercises for Facility Location Modeling
- Resource Type
- Journal Articles
Guides - Classroom - Teacher
Tests/Questionnaires
- Authors
- Strakos, Joshua K. (ORCID 0000-0002-2643-0258); Brazhkin, Vitaly (ORCID 0000-0002-0716-9293)
- Source
- Decision Sciences Journal of Innovative Education. Jan 2022 20(1):29-42.
- Subject
- Spreadsheets
Integrated Learning Systems
Business Administration Education
Models
Undergraduate Students
Facility Planning
Geographic Location
Instructional Effectiveness
- Language
- English
- ISSN
- 1540-4595
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.