{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2024,5,8]],"date-time":"2024-05-08T00:20:53Z","timestamp":1715127653972},"reference-count":6,"publisher":"Institute for Operations Research and the Management Sciences (INFORMS)","issue":"3","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["INFORMS Transactions on Education"],"published-print":{"date-parts":[[2024,5]]},"abstract":" The COVID-19 pandemic has forced the rapid adoption of remote teaching modalities including \u201chyflex\u201d 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\u2019s new \u201cdynamic array\u201d 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. <\/jats:p>","DOI":"10.1287\/ited.2023.0287","type":"journal-article","created":{"date-parts":[[2023,4,21]],"date-time":"2023-04-21T11:18:27Z","timestamp":1682075907000},"page":"201-219","source":"Crossref","is-referenced-by-count":0,"title":["Managing the Hyflex Scheduling Activity Using Excel Dynamic Arrays"],"prefix":"10.1287","volume":"24","author":[{"given":"Larry J.","family":"LeBlanc","sequence":"first","affiliation":[{"name":"Owen Graduate School of Management, Vanderbilt University, Nashville, Tennessee 37203;"}]},{"given":"Thomas A.","family":"Grossman","sequence":"additional","affiliation":[{"name":"Business Analytics & Information Systems, University of San Francisco, San Francisco, California 94611;"}]},{"ORCID":"http:\/\/orcid.org\/0000-0002-0817-4270","authenticated-orcid":false,"given":"Michael R.","family":"Bartolacci","sequence":"additional","affiliation":[{"name":"Berks, Information Sciences & Technology, Pennsylvania State University, Reading, Pennsylvania 19610"}]}],"member":"109","reference":[{"issue":"3","key":"B1","doi-asserted-by":"crossref","first-page":"85","DOI":"10.1287\/ited.2016.0157","volume":"16","author":"Bordoloi S","year":"2016","journal-title":"INFORMS Trans. Edu."},{"key":"B2","doi-asserted-by":"publisher","DOI":"10.1016\/j.ejor.2010.01.044"},{"key":"B3","doi-asserted-by":"publisher","DOI":"10.1016\/j.dss.2021.113697"},{"issue":"3","key":"B11","doi-asserted-by":"crossref","first-page":"109","DOI":"10.1287\/ited.2013.0124","volume":"14","author":"Isken M","year":"2014","journal-title":"INFORMS Trans. Edu."},{"key":"B18","doi-asserted-by":"publisher","DOI":"10.1371\/journal.pone.0243345"},{"key":"B21","doi-asserted-by":"publisher","DOI":"10.1287\/ited.1110.0063"}],"container-title":["INFORMS Transactions on Education"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/pubsonline.informs.org\/doi\/pdf\/10.1287\/ited.2023.0287","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2024,5,7]],"date-time":"2024-05-07T19:19:00Z","timestamp":1715109540000},"score":1,"resource":{"primary":{"URL":"https:\/\/pubsonline.informs.org\/doi\/10.1287\/ited.2023.0287"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2024,5]]},"references-count":6,"journal-issue":{"issue":"3","published-print":{"date-parts":[[2024,5]]}},"alternative-id":["10.1287\/ited.2023.0287"],"URL":"https:\/\/doi.org\/10.1287\/ited.2023.0287","relation":{},"ISSN":["1532-0545","1532-0545"],"issn-type":[{"value":"1532-0545","type":"print"},{"value":"1532-0545","type":"electronic"}],"subject":[],"published":{"date-parts":[[2024,5]]}}}