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.

Full Text
Published version (Free)

Talk to us

Join us for a 30 min session where you can share your feedback and ask us any queries you have

Schedule a call