Introducing Prescriptive and Predictive Analytics to MBA Students with Microsoft Excel

References

• Aghaei S, Gomez A, Vayanos P (2020) Learning optimal classification trees: Strong max-flow formulations. Preprint, submitted May 13, https://arxiv.org/abs/2002.09142.Google Scholar
• Agrawal VK (2006) Why, when, and what to outsource, Chapter 11. Schniederjans A, Schniederjans D, Schniederjans M, eds. Outsourcing Management Information Systems (Idea Group Publishing, Hershey, PA).Google Scholar
• Akçayir G, Akçayir M (2018) The flipped classroom: A review of its advantages and challenges. Comput. Ed. 126:334–345.Crossref, Google Scholar
• Ammirato S, Felicetti AM, Linzalone R, Volpentesta AP, Schiuma G (2020) A systematic literature review of revenue management in passenger transportation. Meas. Bus. Excell.Crossref, Google Scholar
• Anand R, Sabeenian R, Gurang D, Kirthika R, Rubeena S (2021) AI based music recommendation system using deep learning algorithms. Proc. IOP Conf. Series Earth Environment Sci., vol. 785, 012013. https://iopscience.iop.org/article/10.1088/1755-1315/785/1/012013/pdf.Crossref, Google Scholar
• Babier A, Mahmood R, McNiven AL, Diamant A, Chan TC (2020) Knowledge-based automated planning with three-dimensional generative adversarial networks. Medical Phys. 47(2):297–306.Crossref, Google Scholar
• Bertsimas D, Dunn J (2017) Optimal classification trees. Machine Learn. 106(7):1039–1082.Crossref, Google Scholar
• Bertsimas D, Dunn J (2019) Machine Learning Under a Modern Optimization Lens (Dynamic Ideas, Charlestown, MA).Google Scholar
• Bertsimas D, King A (2016) OR forum—An algorithmic approach to linear regression. Oper. Res. 64(1):2–16.Link, Google Scholar
• Bertsimas D, Wiberg H (2020) Machine learning in oncology: methods, applications, and challenges. JCO Clinical Cancer Inform. 4:885–894.Crossref, Google Scholar
• Bertsimas D, Allison K, Pulleyblank WR (2016) The Analytics Edge (Dynamic Ideas, Charlestown, MA).Google Scholar
• Bertsimas D, Orfanoudaki A, Wiberg H (2021) Interpretable clustering: An optimization approach. Machine Learn. 110(1):89–138.Crossref, Google Scholar
• Bertsimas D, Copenhaver M, Wang Y, Pawlowski C (2019) Machine learning under a modern optimization lens. Accessed April 5, 2023, https://bit.ly/3XRFjbO.Google Scholar
• Bishop J, Verleger MA (2013) The flipped classroom: A survey of the research. Proc. ASEE Annual Conf. & Exposition, 23–1200. https://peer.asee.org/the-flipped-classroom-a-survey-of-the-research.Google Scholar
• Boutilier JJ, Chan TC (2023) Introducing and integrating machine learning in an operations research curriculum: An application-driven course. INFORMS Trans. Ed. 23(2):64–83.Google Scholar
• Braun V, Clarke V (2006) Using thematic analysis in psychology. Qual. Res. Psych. 3(2):77–101.Crossref, Google Scholar
• Brown CL, Kosovich SM (2015) The impact of professor reputation and section attributes on student course selection. Res. Higher Edu. 56(5):496–509.Crossref, Google Scholar
• Brusco M (2022) Logistic regression via excel spreadsheets: Mechanics, model selection, and relative predictor importance. INFORMS Trans. Ed. 23(1):1–11.Google Scholar
• Carillo KDA (2017) Let’s stop trying to be “sexy”: Preparing managers for the (big) data-driven business era. Bus. Processing Management J. 23(3):598–622.Crossref, Google Scholar
• Carrier E, Fiig T (2018) Future of airline revenue management. J. Revenue Pricing Management 17:45–47.Google Scholar
• Corbett-Davies S, Goel S (2018) The measure and mismeasure of fairness: A critical review of fair machine learning. Preprint, submitted August 14, https://arxiv.org/abs/1808.00023.Google Scholar
• Cortez P, Silva AMG (2008) Using data mining to predict secondary school student performance. Accessed April 5, 2023, http://www3.dsi.uminho.pt/pcortez/student.pdf.Google Scholar
• Cousineau M, Verter V, Murphy SA, Pineau J (2023) Estimating causal effects with optimization-based methods: A review and empirical comparison. Eur. J. Oper. Res. 304(2):367–380.Crossref, Google Scholar
• Dean MD (2020) Using the learning assistant model in an undergraduate business analytics course. INFORMS Trans. Ed. 20(3):125–133.Link, Google Scholar
• Deng J, Dong W, Socher R, Li LJ, Li K, Fei-Fei L (2009) Imagenet: A large-scale hierarchical image database. Proc. IEEE Conf. on Comput. Vision and Pattern Recognition (IEEE, Piscataway, NJ), 248–255.Crossref, Google Scholar
• Dunn JW (2018) Optimal trees for prediction and prescription. PhD thesis, Massachusetts Institute of Technology, Cambridge, MA.Google Scholar
• Ellegood WA, Solomon S, North J, Campbell JF (2020) School bus routing problem: Contemporary trends and research directions. Omega 95:102056.Crossref, Google Scholar
• Fishbane A, Ouss A, Shah AK (2020) Behavioral nudges reduce failure to appear for court. Science 370(6517):eabb6591.Crossref, Google Scholar
• Fitzgerald S (2012) MBA in business analytics: Big data are a big deal. Accessed April 5, 2023, https://bit.ly/3PRb7ZL.Google Scholar
• Formby SK, Medlin D, Ellington VB (2017) Microsoft Excel®: Is it an important job skill for college graduates? Inform. Systems Ed. J. 15(3):55.Google Scholar
• Fry MJ (2008) Teaching problem solving techniques to MBA students through supply chain management. INFORMS Trans. Ed. 8(2):65–74.Link, Google Scholar
• Gambella C, Ghaddar B, Naoum-Sawaya J (2021) Optimization problems for machine learning: A survey. Eur. J. Oper. Res. 290(3):807–828.Crossref, Google Scholar
• Gomolin A, Netchiporouk E, Gniadecki R, Litvinov IV (2020) Artificial intelligence applications in dermatology: Where do we stand? Frontiers Medicine 7:100.Crossref, Google Scholar
• Gurobi Optimization LLC (2022) Gurobi optimizer reference manual. Accessed April 5, 2023, https://www.gurobi.com.Google Scholar
• Hager PJ, Scheiber HJ, Corbin NC (1997) Designing & Delivering: Scientific, Technical, and Managerial Presentations (John Wiley & Sons, Hoboken, NJ).Google Scholar
• Hasan I, Rizvi SAM (2022) AI-driven fraud detection and mitigation in e-commerce transactions. Proc. Data Analytics and Management: ICDAM 2021, vol. 1 (Springer, Berlin), 403–414.Crossref, Google Scholar
• Herrington JD (2010) MBA: Past, present and future. Acad. Ed. Leadership J. 14(1):63.Google Scholar
• Holland C, Levis J, Nuggehalli R, Santilli B, Winters J (2017) Ups optimizes delivery routes. Interfaces 47(1):8–23.Link, Google Scholar
• Holzmen S, Gooch S (2016) Learning to code at a business school. Accessed April 5, 2023, https://bit.ly/3oKwAYw.Google Scholar
• Hornstein HA (2017) Student evaluations of teaching are an inadequate assessment tool for evaluating faculty performance. Cogent Ed. 4(1):1304016.Crossref, Google Scholar
• Huggins E, Bailey M, Guardiola I (2020) Case article—Converting nfl point spreads into probabilities: A case study for teaching business analytics. INFORMS Trans. Ed. 21(1):45–48.Abstract, Google Scholar
• Jurney R (2017) Agile Data Science 2.0: Building Full-Stack Data Analytics Applications with Spark (O’Reilly Media, Newton, MA).Google Scholar
• Kaushal A, Altman R, Langlotz C (2020) Healthcare AI systems are biased. Sci. Amer. 11:17.Google Scholar
• Kelly J (2022) Data analytics is a hot, sexy sector for career growth. Accessed April 5, 2023, https://bit.ly/3bqV1ar.Google Scholar
• Kirkpatrick L (2020) Is an MBA degree really worth it? Accessed April 5, 2023, https://bit.ly/3cXlNHQ.Google Scholar
• Kopcso D, Pachamanova D (2018) Case article—Business value in integrating predictive and prescriptive analytics models INFORMS Trans. Ed. 19(1):36–42.Google Scholar
• Kraft MA, Rogers T (2015) The underutilized potential of teacher-to-parent communication: Evidence from a field experiment. Econom. Ed. Rev. 47:49–63.Crossref, Google Scholar
• Kurczy S (2018) MBAs who code. Accessed April 5, 2023, https://bit.ly/3d1djj3.Google Scholar
• Langley P (2019) An integrative framework for artificial intelligence education. Proc. Conf. AAAI Artificial Intelligence (AAAI Press, Palo Alto, CA), vol. 33, 9670–9677.Google Scholar
• Larson J, Mattu S, Kirchner L, Angwin J (2016) How we analyzed the compas recidivism algorithm. ProPublica 9(1):3.Google Scholar
• Laursen GH, Thorlund J (2016) Business Analytics for Managers: Taking Business Intelligence Beyond Reporting (John Wiley & Sons, Hoboken, NJ).Crossref, Google Scholar
• LeClair D (2018) Integrating business analytics in the marketing curriculum: Eight recommendations. Marketing Ed. Rev. 28(1):6–13.Crossref, Google Scholar
• Lee DK, Zenios SA (2012) An evidence-based incentive system for Medicare’s end-stage renal disease program. Management Sci. 58(6):1092–1105.Link, Google Scholar
• Leong TY, Cheong ML (2008) Teaching business modeling using spreadsheets. INFORMS Trans. Ed. 9(1):20–34.Link, Google Scholar
• Liberatore MJ, Nydick RL (1999) The teachers’ forum: Breaking the mold—A new approach to teaching the first mba course in management science. Interfaces 29(4):99–116.Link, Google Scholar
• Lin-Siegler X, Ahn JN, Chen J, Fang FFA, Luna-Lucero M (2016) Even Einstein struggled: Effects of learning about great scientists’ struggles on high school students’ motivation to learn science. J. Ed. Psych. 108(3):314.Crossref, Google Scholar
• Longwood University (2021) What can I do with an MBA in data analytics? Accessed April 5, 2023, https://bit.ly/3QdSKOs.Google Scholar
• Luigi (2019) The ultimate guide to model retraining. Accessed April 5, 2023, https://mlinproduction.com/model-retraining/.Google Scholar
• Manyika J, Silberg J, Presten B (2019) What do we do about the biases in AI? Accessed April 5, 2023, https://bit.ly/3oK0KLF.Google Scholar
• Manyika J, Chui M, Brown B, Bughin J, Dobbs R, Roxburgh C, Byers AH (2011) Big data: The next frontier for innovation, competition, and productivity. Accessed April 5, 2023, https://mck.co/3vxARlU.Google Scholar
• Mark D (2021) What is a typical MBA program curriculum? Accessed April 5, 2023, https://bit.ly/3Sl6Tv6.Google Scholar
• Marr B, Ward M (2019) Artificial Intelligence in Practice (Wiley, New York).Google Scholar
• Martinez de Albeniz Margalef V (2011) Linear programming basics. Case study, Harvard Bus. Rev. https://store.hbr.org/product/linear-programming-basics/IES442.Google Scholar
• Mason AJ (2012) Opensolver-an open source add-in to solve linear and integer programmes in excel. Klatte D, Lüthi H-J, Schmedders K, eds. Selected Papers Internat. Conf. Oper. Res. (OR 2011) (Springer-Verlag, Berlin), 401–406.Google Scholar
• Mike K, Hazan T, Hazzan O (2020) Equalizing data science curriculum for computer science pupils. Proc. 20th Koli Calling Internat. Conf. on Comput. Ed. Res. (ACM, New York), 1–5.Google Scholar
• Miller S, Hughes D (2017) The Quant Crunch: How the Demand for Data Science Skills Is Disrupting the Job Market (Burning Glass Technologies, Boston).Google Scholar
• Mitra S, Goldstein Z, Kapoor BL (2021) Predictors of choosing business analytics concentration and consequent academic performance. INFORMS Trans. Ed. 21(3):130–144.Link, Google Scholar
• Möhlmann M (2021) Algorithmic nudges don’t have to be unethical. Accessed April 5, 2023, https://bit.ly/3oPRky9.Google Scholar
• Molnar C (2020) Interpretable machine learning. Leanpub Publishing, https://books.google.ca/books?hl=en&lr=&id=jBm3DwAAQBAJ&oi=fnd&pg=PP1&dq=Molnar+C+(2020)+Interpretable+machine+learning.&ots=EgzP0kIJS5&sig=WEB5YhdpOkRUCLFDyvwLzWjppvI&redir_esc=y#v=onepage&q=Molnar%20C%20(2020)%20Interpretable%20machine%20learning.&f=false.Google Scholar
• Montoya M (2022) MS Excel as a modern data analysis tool? Accessed April 5, 2023, https://bit.ly/3oKpDqm.Google Scholar
• Murray S (2014) Why MBA students are learning to code. Accessed April 5, 2023, https://bit.ly/3BATJnU.Google Scholar
• Naderi B, Roshanaei V, Baron O (2022) An interactive spreadsheet model for teaching classification using logistic regression. Working paper. Accessed April 5, 2023, https://bit.ly/3KenIoq.Google Scholar
• Nagpal A, Gabrani G (2019) Python for data analytics, scientific and technical applications. 2019 Amity Internat. Conf. Artificial Intelligence (AICAI) (IEEE, Piscataway, NJ), 140–145.Google Scholar
• Naumov M, Mudigere D, Shi HJM, Huang J, Sundaraman N, Park J, Wang X, et al. (2019) Deep learning recommendation model for personalization and recommendation systems. Preprint, submitted May 31, https://arxiv.org/abs/1906.00091.Google Scholar
• Ngowtanasuwan G (2012) An application of mathematical model for decision in building plan design. Procedia Soc. Behav. Sci. 68:537–548.Crossref, Google Scholar
• Olsen-Phillips P (2022) What to look for in a business analytics curriculum. Accessed April 5, 2023, https://bit.ly/3BzLVTj.Google Scholar
• O’Neil C (2016) Weapons of Math Destruction: How Big Data Increases Inequality and Threatens Democracy (Broadway Books, New York).Google Scholar
• Pachamanova D, Tilson V, Dwyer-Matzky K (2022) Case article—Machine learning, ethics, and change management: A data-driven approach to improving hospital observation unit operations. INFORMS Trans. Ed. 22(3):178–187.Link, Google Scholar
• Patrick J, Montazeri A, Michalowski W, Banerjee D (2019) Automated pathologist scheduling at the ottawa hospital. INFORMS J. Appl. Analytics 49(2):93–103.Link, Google Scholar
• Paul JA, MacDonald L (2020) Analytics curriculum for undergraduate and graduate students. Decision Sci. J. Innovative Ed. 18(1):22–58.Crossref, Google Scholar
• Press G (2013) A very short history of data science. Accessed April 5, 2023, https://bit.ly/3SjkyTG.Google Scholar
• Questrom School of Business (2022) Preparation for the online MBA. Accessed April 5, 2023, https://bit.ly/3zn1NWx.Google Scholar
• Regan PJ (2005) Professional decision modeling: Details of a short MBA practice course. INFORMS Trans. Ed. 6(1):35–52.Link, Google Scholar
• Roth WS, Matherne BP (2021) Using moneyball to introduce students to data analytics: Illustrating the data analytics life cycle. INFORMS Trans. Ed., ePub ahead of print July 13, https://doi.org/10.1287/ited.2021.0252ca.Link, Google Scholar
• Rotman School of Management (2022) Rsm2408h: Modelling and optimization for decision making. Accessed April 5, 2023, https://bit.ly/3PPPuJr.Google Scholar
• Rudin C, Wang C, Coker B (2018) The age of secrecy and unfairness in recidivism prediction. Preprint, submitted November 2, https://arxiv.org/abs/1811.00731.Google Scholar
• Schroeder B (2021) The data analytics profession and employment is exploding—Three trends that matter. Accessed April 5, 2023, https://bit.ly/3SlBOY8.Google Scholar
• Seal KC, Leon LA, Przasnyski ZH, Lontok G (2020) Delivering business analytics competencies and skills: A supply side assessment. INFORMS J. Appl. Analytics 50(4):239–254.Link, Google Scholar
• Shah R (2019) Stand up for best practices: Misuse of deep learning in nature’s earthquake aftershock paper. Accessed April 5, 2023, https://bit.ly/3OLMbBG.Google Scholar
• Shepperd M (2021) CS5702 modern data book. Accessed April 5, 2023, https://bit.ly/3BzXQ3q.Google Scholar
• Sommer SC, Loch CH (2009) Incentive contracts in projects with unforeseeable uncertainty. Production Oper. Management 18(2):185–196.Crossref, Google Scholar
• Stern School of Business (2021) Syllabus for decisions models and analytics (Fall 2021, MBA Program). Accessed April 5, 2023, https://bit.ly/3JqVkOS.Google Scholar
• Soviany C (2018) The benefits of using artificial intelligence in payment fraud detection: A case study. J. Payments Strategy Systems 12(2):102–110.Google Scholar
• Stine J, Trumbore A, Woll T, Sambucetti H (2019) Implications of Artificial Intelligence on Business Schools and Lifelong Learning (Academic Leadership Group, Cambridge, MA).Google Scholar
• Telenti A, Jiang X (2020) Treating medical data as a durable asset. Nature Genetics 52(10):1005–1010.Crossref, Google Scholar
• Terwiesch C, Cachon G (2019) Matching Supply with Demand: An Introduction to Operations Management, 4th ed. (McGraw-Hill Education, New York).Google Scholar
• Thaler RH (2018) From cashews to nudges: The evolution of behavioral economics. Amer. Econom. Rev. 108(6):1265–1287.Crossref, Google Scholar
• Thomas P (2022) MBA applications at some of the country’s best colleges fell this year. Accessed April 5, 2023, https://on.wsj.com/3zMvbXN.Google Scholar
• Visengeriyeva L, Kammer A, Bär I, Kniesz A, Plöd M (2020) Why you might want to use machine learning. Accessed April 5, 2023, https://ml-ops.org/content/motivation.Google Scholar
• Wachtel HK (1998) Student evaluation of college teaching effectiveness: A brief review. Assessment Evaluation Higher Ed. 23(2):191–212.Crossref, Google Scholar
• Warner J (2013) Business analytics in the MBA curriculum. Proc. Northeast Bus. Econom. Assoc. https://web.p.ebscohost.com/ehost/pdfviewer/pdfviewer?vid=0&sid=e6e875a2-6e06-4800-8bd8-aa5eb949737b%40redis.Google Scholar
• Way T, Papalaskari MA, Cassel L, Matuszek P, Weiss C, Tella YP (2017) Machine learning modules for all disciplines. Proc. 2017 ACM Conf. Innovation Tech. Comput. Sci. Ed., 84–85. https://dl.acm.org/doi/pdf/10.1145/3059009.3072979.Google Scholar
• Weathers D, Aragón O (2019) Integrating analytics into marketing curricula: Challenges and effective practices for developing six critical competencies. Marketing Ed. Rev. 29(4):266–282.Crossref, Google Scholar
• Wilder C, Li S (2019) Case—You can’t take it with you. INFORMS Trans. Ed. 20(1):37–40.Link, Google Scholar
• Wilder C, Ozgur C (2015a) Business analytics for business analysts in manufacturing. Handbook of Research on Organizational Transformations Through Big Data Analytics (IGI Global, Pennsylvania), 97–105.Crossref, Google Scholar
• Wilder CR, Ozgur CO (2015b) Business analytics curriculum for undergraduate majors. INFORMS Trans. Ed. 15(2):180–187.Link, Google Scholar
• Xu JJ, Babaian T (2021) Artificial intelligence in business curriculum: The pedagogy and learning outcomes. Internat. J. Management Ed. 19(3):100550.Google Scholar
• York BN, Loeb S, Doss C (2019) One step at a time the effects of an early literacy text-messaging program for parents of preschoolers. J. Human Resources 54(3):537–566.Crossref, Google Scholar
• York University (2022a) Fostering the future of artificial intelligence: Report from the York University task force on AI & society. Accessed April 5, 2023, https://bit.ly/3vyc80S.Google Scholar
• York University (2022b) York university strategic research plan (2018-202): Toward new heights. Accessed April 5, 2023, https://bit.ly/3vwMJok.Google Scholar
• Yu KW, Mincieli L, Zipser N (2021) How student evaluations of teaching affect course enrollment. Assessment Evaluation Higher Ed. 46(5):779–792.Crossref, Google Scholar
• Zhan J, Her YW, Hu T, Du C (2018) Integrating data analytics into the undergraduate accounting curriculum. Bus. Ed. Innovation J. 10(2).Google Scholar