Apr 19, 2024  
2020-2021 Undergraduate and Graduate Catalog 
    
2020-2021 Undergraduate and Graduate Catalog [ARCHIVED CATALOG]

I S 320 - Spreadsheet Modeling for Business and Management


(3 units)

Prerequisites: I S 233  and STAT 118  or MATH 114 or STAT 108 . 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).