Managing the Hyflex Scheduling Activity Using Excel Dynamic Arrays

References

• Bordoloi S (2016) Optimal mix of operations management contents for a blended course for teaching healthcare MBA students. INFORMS Trans. Edu. 16(3):85–111.Google Scholar
• Burke E, Eckersley A, McCollum B, Petrovic S, Qua R (2010) Hybrid variable neighbourhood approaches to university exam timetabling. Eur. J. Oper. Res. 206(1):46–53.Crossref, Google Scholar
• Cardonha C, Bergman D, Day R (2022) Maximizing student opportunities for in-person classes under pandemic capacity reductions. Decision Support Systems 154:113697.Crossref, Google Scholar
• Cheusheva S (2021a) Excel dynamic arrays, functions and formulas. Accessed April 28, 2021, https://www.ablebits.com/office-addins-blog/2020/07/08/excel-dynamic-arrays-functions-formulas/.Google Scholar
• Cheusheva S (2021b) Excel FILTER function with formula examples. Accessed May 10, 2022, https://www.ablebits.com/office-addins-blog/2020/06/17/excel-filter-function/.Google Scholar
• Cheusheva S (2021c) XLOOKUP function in Excel: Powerful successor of VLOOKUP. Accessed April 30, 2021, https://www.ablebits.com/office-addins-blog/excel-xlookup-function/.Google Scholar
• Cheusheva S (2022) Excel table: End-to-end tutorial with examples. Accessed May 20, 2022, https://www.ablebits.com/office-addins-blog/excel-table-tutorial/.Google Scholar
• Exceljet (2021a) Dynamic array formulas in Excel. Accessed April 28, 2021, https://exceljet.net/dynamic-array-formulas-in-excel.Google Scholar
• Exceljet (2021b) Excel tables. Accessed May 10, 2021, https://exceljet.net/excel-tables.Google Scholar
• Exceljet (2021c) Excel XLOOKUP function. Accessed April 30, 2021, https://exceljet.net/excel-functions/excel-xlookup-function.Google Scholar
• Isken M (2014) Translating a laboratory based spreadsheet modeling course to an online format: Experience from a natural experiment. INFORMS Trans. Edu. 14(3):109–142.Google Scholar
• Lederman D (2020) The hyflex option for instruction if campuses open this fall. Accessed July 4, 2021, https://www.insidehighered.com/digital-learning/article/2020/05/13/one-option-delivering-instruction-if-campuses-open-fall-hyflex.Google Scholar
• Microsoft (2021a) Filter function. Accessed July 4, 2021, https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759.Google Scholar
• Microsoft (2021b) Mod function. Accessed June 30, 2021, https://support.microsoft.com/en-us/office/mod-function-9b6cd169-b6ee-406a-a97b-edf2a9dc24f3.Google Scholar
• Microsoft (2022a) Filter data in a range or table. Accessed May 19, 2022, https://support.microsoft.com/en-us/office/filter-data-in-a-range-or-table-01832226-31b5-4568-8806-38c37dcc180e.Google Scholar
• Microsoft (2022b) INDEX function. Accessed May 25, 2022, https://support.microsoft.com/en-gb/office/index-function-a5dcf0dd-996d-40a4-a822-b56b061328bd.Google Scholar
• Microsoft (2022c) XLOOKUP function. Accessed May 23, 2022, https://support.microsoft.com/en-us/office/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929.Google Scholar
• Murray A (2020) Planning for classroom physical distancing to minimize the threat of COVID-19 disease spread. PLoS One. 15(12):e0243345.Crossref, Google Scholar
• PowerUser (2021) XLOOKUP just killed VLOOKUP: Everything to know about this major new excel function. Accessed July 3, 2021, https://www.powerusersoftwares.com/post/xlookup-just-killed-vlookup-everything-to-know-about-this-major-new-excel-function.Google Scholar
• Provost (2020) From the provost: Classroom safety, university of northern Iowa response to COVID-19. Accessed May 5, 2021, https://scholarworks.uni.edu/covid19/44/.Google Scholar
• Scherer C (2011) Comparison of an introductory level undergraduate statistics course taught with traditional, hybrid, and online delivery methods. INFORMS Trans. Edu. 11(3):106–110.Link, Google Scholar