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): | |

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. |

Term | Year | Title | ISBN | Author | Edition | Publisher | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|

F | 2016 | ||||||||||||

F | 2016 | BUSINESS MATH USING EXCEL | BURTON | 2ND 11 | CENGAGE L | ||||||||

F | 2016 | FUND.OF BUSINESS MATHEMATICS | WILLIAMS | 7TH 96 | HAWKES LRN | ||||||||

F | 2015 | ||||||||||||

S | 2015 | ||||||||||||

S | 2015 | FUND.OF BUSINESS MATHEMATICS | WILLIAMS | 7TH 96 | HAWKES LRN | ||||||||

S | 2015 | SUCCEEDING IN BUS.W/MS.OFF.EXCEL 2013 | GROSS | 14 | CENGAGE L | ||||||||

F | 2014 | No Text Required | |||||||||||

F | 2014 | SUCCEEDING IN BUS.W/MS.OFF.EXCEL 2013 | GROSS | 14 | |||||||||

S | 2014 | MICROSOFT EXCEL 2010 DATA ANAL.+BUS... | WINSTON | 11 | |||||||||

S | 2014 | No Text Required | |||||||||||

U | 2014 | ||||||||||||

F | 2013 | No Text Required | |||||||||||

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 |