Practice Summary: A Multiobjective Assignment Model for Optimal Socially Distanced Classrooms for the Spears School of Business at Oklahoma State University

Abstract

In response to Oklahoma State University’s goal to provide safe face-to-face course options for as many students as possible in fall 2020, the Spears School of Business leadership developed a strategy based on data analytics and multiobjective optimization that allowed the implementation of a smooth transition plan for classes in fall 2020. OpenSolver was used (within Excel) to create an effective and efficient tool that successfully implemented classroom assignments that maximized face-to-face offerings while minimizing disruptions to the schedule, faculty, and registrar’s office.