| |
Nov 23, 2024
|
|
|
|
|
CIS 1173 - Spreadsheets I 3 Credits
This course is designed to instruct students in the use of spreadsheet software to model, analyze, and support common business decisions. Instruction will include using the software as a decision support tool and as a list management tool. Concepts and features presented include: scenario and regression analysis, data scrubbing, chart building and analysis, Pivot tables and Pivot charts, filtering, troubleshooting formulas, tracing errors, and using advanced functions. An introduction into Visual Basic for Applications (VBA) is included and used in creating custom forms, custom functions, recording and editing macros, using variables and ranges and controlling code execution. Instruction is also given in importing, linking, and using VBA to share spreadsheet data with databases and the Web.
Lab Fee.
Prerequisite: CIS 1013 - Information Systems with a grade of “C” or better
Course Level Objectives
Upon successful completion of this course the student will be able to:
1. Demonstrate fundamental Excel skills (PLO 1, 2)
2. Use statistical analysis tools to solve problems (PLO 1, 2, 4)
3. Illustrate effective data display with charts (PLO 1, 2, 3, 4, 5)
4. Demonstrate the application of logic structures in decision making (PLO 1, 2, 3 4)
5. Perform data retrieval for computation, analysis, and reference (PLO 1, 2)
6. Calculate the financial impact of loans and investments (PLO 1, 2, 6)
7. Explain how to organize data for effective analysis (PLO 1, 3, 4, 5)
8. Identify techniques to troubleshoot workbooks (PLO 1, 2, 3, 4)
9. Design an automated Excel application (PLO 1, 2)
Add to Portfolio (opens a new window)
|
|
