Catalogue 2012 - 2013

BIS 102 Problem Solving with Business Tools


3 cr.


College of Business students only or permission of department chair.

Course Description

This is a hands-on course on business problem solving. The tools used are a spreadsheet and a database software. Objective of the first part of the course is to practice creating spreadsheet models. Course starts with navigation, cell addressing, workbook and worksheet concepts. Applications are designed using built-in functions with special emphasis on financial functions. Charting concepts are introduced as presentation tools. Other skills include: working with Pivot tables, goal-seeking and what-if modeling. The second part of the course is introduction to DBMS with emphasis on using and developing database applications for a business context. Topics include: Table design, Query design, Reports and Forms design.


This course is a prerequisite.