IDEAS home Printed from https://ideas.repec.org/a/inm/orited/v24y2024i3p201-219.html
   My bibliography  Save this article

Managing the Hyflex Scheduling Activity Using Excel Dynamic Arrays

Author

Listed:
  • Larry J. LeBlanc

    (Owen Graduate School of Management, Vanderbilt University, Nashville, Tennessee 37203)

  • Thomas A. Grossman

    (Business Analytics & Information Systems, University of San Francisco, San Francisco, California 94611)

  • Michael R. Bartolacci

    (Berks, Information Sciences & Technology, Pennsylvania State University, Reading, Pennsylvania 19610)

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.

Suggested Citation

  • Larry J. LeBlanc & Thomas A. Grossman & Michael R. Bartolacci, 2024. "Managing the Hyflex Scheduling Activity Using Excel Dynamic Arrays," INFORMS Transactions on Education, INFORMS, vol. 24(3), pages 201-219, May.
    • Handle: RePEc:inm:orited:v:24:y:2024:i:3:p:201-219
    DOI: 10.1287/ited.2023.0287
    as

    Download full text from publisher

    File URL: http://dx.doi.org/10.1287/ited.2023.0287
    Download Restriction: no
    File URL: https://libkey.io/10.1287/ited.2023.0287?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    References listed on IDEAS

    as
    1. Sanjeev K Bordoloi, 2016. "Optimal Mix of Operations Management Contents for a Blended Course for Teaching Healthcare MBA Students," INFORMS Transactions on Education, INFORMS, vol. 16(3), pages 87-92, May.
    2. Alan T Murray, 2020. "Planning for classroom physical distancing to minimize the threat of COVID-19 disease spread," PLOS ONE, Public Library of Science, vol. 15(12), pages 1-15, December.
    3. Burke, E.K. & Eckersley, A.J. & McCollum, B. & Petrovic, S. & Qu, R., 2010. "Hybrid variable neighbourhood approaches to university exam timetabling," European Journal of Operational Research, Elsevier, vol. 206(1), pages 46-53, October.
    Full references (including those not matched with items on IDEAS)

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Wilson, Duncan T. & Hawe, Glenn I. & Coates, Graham & Crouch, Roger S., 2013. "A multi-objective combinatorial model of casualty processing in major incident response," European Journal of Operational Research, Elsevier, vol. 230(3), pages 643-655.
    2. Syariza Abdul-Rahman & Edmund Burke & Andrzej Bargiela & Barry McCollum & Ender Özcan, 2014. "A constructive approach to examination timetabling based on adaptive decomposition and ordering," Annals of Operations Research, Springer, vol. 218(1), pages 3-21, July.
    3. Alan T. Murray & Susan Burtner, 2023. "Physical distancing as an integral component of pandemic response," Letters in Spatial and Resource Sciences, Springer, vol. 16(1), pages 1-17, December.
    4. Mohammed Al-Betar & Ahamad Khader & Iyad Doush, 2014. "Memetic techniques for examination timetabling," Annals of Operations Research, Springer, vol. 218(1), pages 23-50, July.
    5. Efstratios Rappos & Eric Thiémard & Stephan Robert & Jean-François Hêche, 2022. "A mixed-integer programming approach for solving university course timetabling problems," Journal of Scheduling, Springer, vol. 25(4), pages 391-404, August.
    6. Alejandro Cataldo & Juan-Carlos Ferrer & Jaime Miranda & Pablo A. Rey & Antoine Sauré, 2017. "An integer programming approach to curriculum-based examination timetabling," Annals of Operations Research, Springer, vol. 258(2), pages 369-393, November.
    7. Abdul Rahman, Syariza & Bargiela, Andrzej & Burke, Edmund K. & Özcan, Ender & McCollum, Barry & McMullan, Paul, 2014. "Adaptive linear combination of heuristic orderings in constructing examination timetables," European Journal of Operational Research, Elsevier, vol. 232(2), pages 287-297.
    8. Sabar, Nasser R. & Ayob, Masri & Kendall, Graham & Qu, Rong, 2012. "A honey-bee mating optimization algorithm for educational timetabling problems," European Journal of Operational Research, Elsevier, vol. 216(3), pages 533-543.
    9. Fonseca, George H.G. & Santos, Haroldo G. & Carrano, Eduardo G. & Stidsen, Thomas J.R., 2017. "Integer programming techniques for educational timetabling," European Journal of Operational Research, Elsevier, vol. 262(1), pages 28-39.
    10. Eng, KaiLun & Muhammed, Abdullah & Mohamed, Mohamad Afendee & Hasan, Sazlinah, 2020. "A hybrid heuristic of Variable Neighbourhood Descent and Great Deluge algorithm for efficient task scheduling in Grid computing," European Journal of Operational Research, Elsevier, vol. 284(1), pages 75-86.
    11. R. A. Oude Vrielink & E. A. Jansen & E. W. Hans & J. Hillegersberg, 2019. "Practices in timetabling in higher education institutions: a systematic review," Annals of Operations Research, Springer, vol. 275(1), pages 145-160, April.
    12. Johnes, Jill, 2015. "Operational Research in education," European Journal of Operational Research, Elsevier, vol. 243(3), pages 683-696.
    13. De Boeck, Liesje & Beliën, Jeroen & Creemers, Stefan, 2016. "A column generation approach for solving the examination-timetabling problemAuthor-Name: Woumans, Gert," European Journal of Operational Research, Elsevier, vol. 253(1), pages 178-194.
    14. Barry McCollum & Paul McMullan & Andrew Parkes & Edmund Burke & Rong Qu, 2012. "A new model for automated examination timetabling," Annals of Operations Research, Springer, vol. 194(1), pages 291-315, April.
    15. Edmund Burke & Nam Pham & Rong Qu & Jay Yellen, 2012. "Linear combinations of heuristics for examination timetabling," Annals of Operations Research, Springer, vol. 194(1), pages 89-109, April.
    16. Álvaro García-Sánchez & Araceli Hernández & Eduardo Caro & Gonzalo Jiménez, 2019. "Universidad Politécnica de Madrid Uses Integer Programming for Scheduling Weekly Assessment Activities," Interfaces, INFORMS, vol. 49(2), pages 104-116, March.
    17. Moritz Mühlenthaler & Rolf Wanka, 2016. "Fairness in academic course timetabling," Annals of Operations Research, Springer, vol. 239(1), pages 171-188, April.
    18. Tortorella, Guilherme Luz & Narayanamurthy, Gopalakrishnan & Sunder M, Vijaya & Cauchick-Miguel, Paulo A, 2021. "Operations Management teaching practices and information technologies adoption in emerging economies during COVID-19 outbreak," Technological Forecasting and Social Change, Elsevier, vol. 171(C).
    19. Edmund Burke & Rong Qu & Amr Soghier, 2014. "Adaptive selection of heuristics for improving exam timetables," Annals of Operations Research, Springer, vol. 218(1), pages 129-145, July.
    20. Mohammad Reza Bazargan-Lari & Sharareh Taghipour & Arash Zaretalab & Mani Sharifi, 2022. "Production scheduling optimization for parallel machines subject to physical distancing due to COVID-19 pandemic," Operations Management Research, Springer, vol. 15(1), pages 503-527, June.

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:inm:orited:v:24:y:2024:i:3:p:201-219. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Chris Asher (email available below). General contact details of provider: https://edirc.repec.org/data/inforea.html .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.