Mar 28, 2024  
2012-2013 Official General Catalog 
    
2012-2013 Official General Catalog [Archived Catalog]

CST 158 - Spreadsheets With Financial Applications


A comprehensive course in spreadsheet development and design with a focus on financial applications using software such as Excel.  Advanced topics include object linking and embedding, goal seeking, look up tables, data tables, multiple worksheets, managing scenarios, rational databases web application and application development with Macros and Visual Basic.  Financial applications include basic financial statements, loan payments, cash flow analysis, capital budgeting, break-even analysis, and inventory management.

Prerequisite- Corequisite
Prerequisite:  MAT 096 Elementary Algebra and Trigonometry, and CST 105 Introduction to Computers

Credits: 3
Hours
2 Class Hours, 2 Laboratory Hours
Course Profile
Learning Outcomes of the Course:

Upon successful completion of this course the student will be able to:

1.  Effectively use and create a spreadsheet to handle commonly encountered financial and business applications.
2.  Use a business case approach and apply it to a practical solution using a spreadsheet such as Excel.
3.  Be proficient at planning building, testing and documenting a worksheet.
4.  Demonstrate and use advanced techniques involved in creating spreadsheets, such as data management, integration with other Windows programs and the Internet.
5.  Use data tables, scenario management, application development with macros.
6.  Write Visual Basic applications using Solver for complex problems.