CIS 1013 - Information Systems

3 Credits

This course introduces spreadsheet, database, and visual basic application (VBA) software. Emphasis is given to hands-on practice reinforcing computer skills through the use of assignments and exams.

Lab Fee.

Prerequisite: CIS 1023 Introduction to Computing* with a grade of “C” or better, or competency test, or instructor permission.

Course Level Objectives
Upon successful completion of this course, the student will be able to:

1. Create and format spreadsheets and databases using Microsoft Excel and Access
software. (PLO 1, 2, 4, 5, 7)
2. Use formulas and functions in Microsoft Excel workbooks. (PLO 1, 2, 3, 4, 5, 6, 7)
3. Manage Excel tables, pivot tables, and multiple worksheets and workbooks. (PLO 1, 2,
3, 5, 6, 7)
4. Create database objects and advanced queries using Microsoft Access. (PLO 1, 2, 3, 4, 5, 7)
5. Create and modify basic functions using Microsoft Visual Basic for Applications (PLO 1, 2, 3, 4, 5, 7)