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

Case Article—You Can’t Take It with You

Author

Listed:
  • Coleen Wilder

    (Valparaiso University, College of Business, Valparaiso, Indiana 46383; b Pacific Lutheran University, School of Business, Tacoma, Washington 98477)

  • Sailu Li

    (Valparaiso University, College of Business, Valparaiso, Indiana 46383; b Pacific Lutheran University, School of Business, Tacoma, Washington 98477)

Abstract

The primary goal of the accompanying case study, “You Can’t Take It with You,” is to help business students develop better problem-solving skills. Teaching quantitative courses to students not in a STEM (science, technology, engineering, mathematics) discipline can be a challenging task. Using concrete examples with spreadsheets is an effective teaching strategy that appeals to many business students. This case study offers a concrete and relevant exercise using the base package of Excel. It is multidisciplinary and flexible in its delivery, allowing instructors to effectively integrate it into their course(s). Topics that may be covered include simulation, data analysis, and the time value of money. Advanced Excel functions that may be used include PMT, NORMINV, VLOOKUP, Scenario Manager, Data Table, and Goal Seek. Overall, students believed the case was challenging and that it was a valuable learning experience.

Suggested Citation

  • Coleen Wilder & Sailu Li, 2019. "Case Article—You Can’t Take It with You," INFORMS Transactions on Education, INFORMS, vol. 20(1), pages 33-36, September.
  • Handle: RePEc:inm:orited:v:20:y:2019:i:1:p:33-36
    DOI: 10.1287/ited.2019.0209ca
    as

    Download full text from publisher

    File URL: https://doi.org/10.1287/ited.2019.0209ca
    Download Restriction: no

    File URL: https://libkey.io/10.1287/ited.2019.0209ca?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. Ryan K. Orchard, 2019. "Using Homemade, Short, Fictional Cases for Teaching the Theory of Constraints," INFORMS Transactions on Education, INFORMS, vol. 19(2), pages 81-88, January.
    2. Robert A. Shumsky, 2009. "Case Article ---Introductory Integrative Cases on Airline Revenue Management," INFORMS Transactions on Education, INFORMS, vol. 9(3), pages 135-139, May.
    3. Brian Keller & Güzin Bayraksan, 2012. "Case Article ---Quantifying Operational Risk in Financial Institutions," INFORMS Transactions on Education, INFORMS, vol. 12(2), pages 100-105, January.
    4. Balaraman Rajan & N. Ravichandran, 2017. "Case—Tactical Decisions at Vastrapur Car Rental Services," INFORMS Transactions on Education, INFORMS, vol. 18(1), pages 52-55, September.
    5. Brian Keller & Güzin Bayraksan, 2012. "Case ---Quantifying Operational Risk in Financial Institutions," INFORMS Transactions on Education, INFORMS, vol. 12(2), pages 106-113, January.
    6. Balaraman Rajan & N. Ravichandran, 2017. "Case Article—Tactical Decisions at Vastrapur Car Rental Services," INFORMS Transactions on Education, INFORMS, vol. 18(1), pages 48-51, September.
    7. Thin-Yin Leong & Michelle L. F. Cheong, 2008. "Teaching Business Modeling Using Spreadsheets," INFORMS Transactions on Education, INFORMS, vol. 9(1), pages 20-34, September.
    8. Thomas A. Grossman & Vijay Mehrotra & Mouwafac Sidaoui, 2016. "A Student-Centered Approach to the Business School Management Science Course," INFORMS Transactions on Education, INFORMS, vol. 16(2), pages 42-53, January.
    Full references (including those not matched with items on IDEAS)

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Peña, Werner, 2020. "Population Aging and Public Finances: Evidence from El Salvador," The Journal of the Economics of Ageing, Elsevier, vol. 17(C).
    2. Philippa Sigl-Gloeckner & Max Krahé & Pola Schneemelcher & Florian Schuster & Viola Hilbert & Henrika Meyer, 2021. "Eine neue deutsche Finanzpolitik," Working Papers 2, Forum New Economy.
    3. Meghann Puloc’h, 2022. "Uganda: revising the growth model while preserving debt sustainability," Working Paper 1a139887-666a-4a53-8b6a-5, Agence française de développement.

    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. John Miltenburg, 2019. "Online Teaching in a Large, Required, Undergraduate Management Science Course," INFORMS Transactions on Education, INFORMS, vol. 19(2), pages 89-104, January.
    2. Mark W. Isken, 2014. "Translating a Lab Based Spreadsheet Modeling Course to an Online Format: Experience from a Natural Experiment," INFORMS Transactions on Education, INFORMS, vol. 14(3), pages 120-128, May.
    3. Mauricio Olivares Faúndez & Hanns de la Fuente-Mella, 2022. "Skills Measurement Strategic Leadership Based on Knowledge Analytics Management through the Design of an Instrument for Business Managers of Chilean Companies," Sustainability, MDPI, vol. 14(15), pages 1-14, July.
    4. Yan Feng & Jean-François Audy & Mikael Rönnqvist & Sophie D’Amours, 2020. "An Educational Game with Dragons’ Den Experiences for Supply Chain Management Training," INFORMS Transactions on Education, INFORMS, vol. 21(1), pages 13-29, September.
    5. Michael F. Gorman, 2023. "Case Article—Louisiana Branch Lines," INFORMS Transactions on Education, INFORMS, vol. 23(3), pages 139-143, May.
    6. Ryan K. Orchard, 2019. "Using Homemade, Short, Fictional Cases for Teaching the Theory of Constraints," INFORMS Transactions on Education, INFORMS, vol. 19(2), pages 81-88, January.
    7. Matthew J. Drake, 2024. "Case Article—Creating a Brick Empire Through Data Visualization and Analytics," INFORMS Transactions on Education, INFORMS, vol. 24(3), pages 271-277, May.
    8. repec:eur:ejfejr:25 is not listed on IDEAS
    9. LeBlanc, Larry J. & Grossman, Thomas A. & Bartolacci, Michael R., 2019. "Ensuring scalability and reusability of spreadsheet linear programming models," Omega, Elsevier, vol. 84(C), pages 55-69.
    10. Thomas A. Grossman & Vijay Mehrotra & Mouwafac Sidaoui, 2016. "A Student-Centered Approach to the Business School Management Science Course," INFORMS Transactions on Education, INFORMS, vol. 16(2), pages 42-53, January.
    11. Cheri Speier-Pero, 2018. "Leveraging Experiential Field Projects—Discovery Learning in a Masters in Analytics Program," INFORMS Transactions on Education, INFORMS, vol. 18(3), pages 162-173, May.
    12. Stacey Vaziri & Baback Vaziri & Luis J. Novoa & Elham Torabi, 2022. "Academic Motivation in Introductory Business Analytics Courses: A Bayesian Approach," INFORMS Transactions on Education, INFORMS, vol. 22(2), pages 121-129, January.
    13. Leong Thin-Yin & Leong Yonghui Jonathan, 2020. "Simpler Machine Learning Using Spreadsheets: Neural Network Predict," European Journal of Engineering and Formal Sciences Articles, European Center for Science Education and Research, vol. 4, January -.
    14. Michael Francis Gorman, 2023. "Case Article—Blending Statistics, Optimization, and Simulation in a Multiphase Case," INFORMS Transactions on Education, INFORMS, vol. 23(3), pages 173-176, May.
    15. Julie Ann Stuart Williams & Randall Reid & Kristine Gallamore & Maxwell Rankin, 2018. "Introducing Troubleshooting for Model Formulation, Spreadsheet Development, and Memo Communication with Feedforward," INFORMS Transactions on Education, INFORMS, vol. 18(2), pages 102-115, January.
    16. Vinay Ramani & Jyotirmoy Dalal & Swami Dayakarananda, 2023. "Case Article—GAP: A Humanitarian Initiative of Ramakrishna Mission for Underprivileged Children," INFORMS Transactions on Education, INFORMS, vol. 24(1), pages 70-75, September.

    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:20:y:2019:i:1:p:33-36. 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.