ADVANCED SPREADSHEET APPLICATIONS

Catalog description

This course is both a concept and computer-applications course relying heavily on applying an understanding of the concepts with computer software. The course will employ lectures, projects, labs, and class discussion. Students work individually and in teams. Lectures emphasize not only the conceptual and managerial aspects of analysis, but the software aspects to solve problems and analyze data. The course is a much advanced continuation of CISA 1300 Business Computing. It examines, in detail, the spreadsheet tool of Pivot Tables and Pivot Charts, performing advanced calculations, and integrating spreadsheets with databases. Upon completion of the course, you will be able to build advanced pivot tables to analyze data using data mining techniques, analyze spreadsheet information using databases, and use Visual Basic (VBA) to maneuver data between spreadsheets and databases. During the semester, you will have the opportunity to work on a project of your own where you will be able to demonstrate your understanding of the course objectives. Lecture/discussion/lab. Prerequisite: CISA 1300.