Teaching Spreadsheet Software in Business School

Presented by

Dr. Lei LiDr. Philip Bryant

Introduction

• Spreadsheet Software – MS Excel• Applications in Business• Courses Use MS Excel as Main Tool

MISM 2115 – Technological Applications in Business Decision Making

BUSA 3115 – Quantitative Analysis for Business I

MISM 2115 - What are Taught

• Formulas & Functions• Charts• Data Tables• Pivot Tables & Pivot Charts• What-If Analysis• Workbook Management & Collaboration• Imports and Web Queries

MISM 2115 – My Experience

• Learn by Doing Pick a Good Textbook Use Live Examples, not PowerPoint

• Humanize Excel Fill Handle

• Make it Interesting Functions, Absolute Reference

BUSA 3115 (“Quant I”)

• Excel is used in class as an aid in problem solving

• Data sets are worked through in class and forwarded to the students to work through outside of class to reinforce the concepts.

BUSA 3115 -- Using Excel for Multiple Regression Analysis

• An Example– Gold (x1)

– Silver (x2)

– Dow (y)

Dow (y) Silver (x1) Gold (x2)

2002 8300 4 310

2003 9100 5 363

2004 10000 7 410

2005 10600 7 445

2006 11000 12 603

2007 13300 13 695

2008 12300 15 871

2009 8600 14 972

2010 10400 20 1225

2011 12200 35 1571

2012 13000 30 1641