Course Information

another search

Number:MS206
Name:Math for Management and Economics
Description:This course is an introduction to quantitative modeling in the context of business and economics. Students learn mathematical concepts, constructs and theory using the platform of spreadsheet modeling. Topics include principles of spreadsheet design, break even analysis, optimization as applied to curve fitting, cash flow analysis and time series analysis.
Credit(s):3
Offered (DAY schedule):Every semester
Instructor Permission Required:N
Pre-Requisite(s):

Course Objectives

How to design a spreadsheet in a manner that applies to model building in any context including those not covered in the course.
"How to organize given information in a consistent, easy to read manner including the use of text boxes, comment tags, color coding, and range name assignments.
How to use spreadsheet models to validate solutions (e.g. obtain the solution in two different ways)
"How to use approximation techniques such as ""goal seek"" and how to do ""what if"" analysis on models that have been completed.
How to use Excel to perform optimization whether or not constraints are present.
How to use Excel to understand and conduct cash flow analysis.
Solve equations and systems of equation
Create graphs and charts to represent solutions to problem
Use matrices to aid in decision making
Determine best options for various financial situations
Use probability to assess multiple solutions to various situations.

Books Previously Used in this Course

Term Year Title ISBN Author Edition Publisher
S 2013 No Text Required For This Course ZZDIRECT NONE MBS
F 2012 No Text Required For This Course ZZDIRECT NONE MBS
U 2012 NO TEXT REQUIRED TEXT
U 2012 NO TEXTBOOK REQUIRED 2-10-011111-6 NO TEXT
F 2011 NO TEXT REQUIRED TEXT
F 2011 NO TEXTBOOK REQUIRED 2-10-011111-6 NO TEXT
F 2011 SUCCEEDING IN BUSINESS WI 0-538-74580-0 GROSS COURSE TEC
S 2011 NO TEXTBOOK REQUIRED 2-10-011111-6 NO TEXT
F 2010 NO TEXTBOOK REQUIRED 2-10-011111-6 NO TEXT
F 2010 SUCCEEDING IN BUSINESS WI 0-538-74580-0 GROSS COURSE TEC
S 2010 MICROSOFT EXCEL DATA ANAL 0-7356-1901-8 WINSTON MICROSOFT
F 2009 NOT FOUND NOT FOUND NOT FOUND NO BARCHARTS INC
F 2009 NOT FOUND NOT FOUND NOT FOUND NOT FOUN NO NOT FOUND
S 2009 Excel 2007 Data Analysis and Business Modeling 0-7356-2396-1 Winston, Wayne L Microsoft Press
S 2009 MICROSOFT OFFICE EXCEL 20 0-7356-2396-1 WINSTON MICROSOFT PRESS
F 2008 BUNDLE SUC IN BIZ AND FIN 0-324-80624-8 GROSS CENGAGE LEARNING
S 2008 NO TEXT REQUIRED TEXT
U 2008 SUCCEEDING IN BUSINESS WI GROSS COURSE TEC
F 2007 FINITE MATHEMATICS WITH M PIASCIK B/C
F 2007 NO TEXT REQUIRED TEXT
S 2007 FINITE MATH FOR BUS, ECON, LIFE SCI & SOC SCI 0-13-113962-2 BARNETT 10 PEARSON EDUCATION
S 2007 FINITE MATHEMATICS WITH MICROSOFT EXCEL 0-534-37057-8 PIASCIK THOMSON LEARNING
S 2006 NO TEXT LISTED
S 2006 "FINITE MATH.F/BUS BARNETT ECON
S 2006 FINITE MATH.+ITS APPL.-TEXT GOLDSTEIN 8TH 04
F 2005 NO TEXT LISTED
S 2005 Finite Mathematics w/Spreadsheet Manual 0321243986 Young 3 Addison Wesley
F 2003 Excel Spreadsheet Turner
F 2003 Intro to Excel 0130081752 Kuncicky
S 2003 Introduction to Excel 2002, 3/E 0-13-008175-2 David Kuncicky 3 Prentice Hall
F 2002 COURSEPACK FOR MS206 TURNER THOMAS
S 2002 FINITE MATH.F/BUS,ECON,LIFE SCI,+SOC... 0-13-913179-5 BARNETT 8TH 99 PEARSON
Thomas College. Beyond Education.