BUS-222 - Business Decision Tools

3 credits

Students will create and format worksheets primarily using MS Excel; other spreadsheet tools will be introduced. Basic worksheet concepts such as applying font styles, setting margins, modifying cell contents, inputting formulas/functions, and creating various charts will be covered. Advanced topics to be introduced include functions (financial, text, statistical, logical), lookup tables, pivot tables, what-if analysis, macros, templates, and managing workbooks. Business decision products will be introduced, including Microsoft Excel Add-ins, MS Access, data analytics, data mining, business intelligence, and dashboards. Emphasis will be placed on reading data and on assessing the story that is being told by the data.

Corequisite(s): OIT-100 OIT-101 OIT-110