Managing the Hyflex Scheduling Activity Using Excel Dynamic Arrays

Abstract

The COVID-19 pandemic has forced the rapid adoption of remote teaching modalities including “hyflex” where students attend some class sessions in person and some online. Managing the hyflex course requires faculty to quickly generate several reports and to update these reports rapidly when the authorities adjust the rules, students add/drop, or the number of course sessions is changed. The creation of these reports is tedious and error-prone, so they need to be automated. However, the nature of the task precludes traditional Excel programming approaches. We use Excel's new “dynamic array” capabilities (which are available only in Excel 365) to automate the creation and updating of the reports needed to manage the hyflex course. We show how to program the reports, and we discuss the importance of taking an iterative approach to creating effective, error-free cell formulas. To help the reader acquire genuine access to the dynamic array functions, we provide a practical tutorial on the principles and new concepts of dynamic arrays, explain how they relate to legacy array functions, and present selected dynamic array functions including SEQUENCE, FILTER, and XLOOKUP.