I S 320 - Spreadsheet Modeling for Business and Management

(3 units)

Prerequisites: STAT 118 with “C” or better or STAT 108 with “C” or better; and I S 233. IS majors, Pre-IS majors, and IS minors and Business Analytics Certificate only. Freshmen excluded.
Using spreadsheet to solve business and management problems. Complete coverage of spreadsheet topics including problem formulation, formula, functions, pivot table, macro, solver, spreadsheet forms and VBA, what-if analysis, dimensional analysis, optimization, and quantitative modeling. Data analysis and visualization using spreadsheet.

Letter grade only (A-F).