Central Arizona College Back
CBA 133B Advanced Spreadsheet Applications in Excel
Credit Hours:  3
Effective Term: Fall 2010
SUN#: None
Credit Breakdown: 2 Lectures, 3 Labs
Times for Credit: 1
Grading Option: A/F

Description: Use of advanced features of MS Excel to import and export data, use templates, generate reports, use macros, audit a worksheet and use analysis tools.

Prerequisites: CBA133A

Corequisites: None

Recommendations: None

Measurable Student Learning Outcomes
1. (Application Level) Apply custom styles, and advanced conditional and logical functions to data in the workbook.
2. (Application Level) Use Text functions to manipulate data.
3. (Application Level) Implement data collaboration and security techniques to Share, Distribute and Secure workbooks using Three-dimensional formulas, linking and data entry validation.
4. (Application Level) Use Analytical options such as Goal Seek, Solver, and Scenario Manager to perform “What If” Analysis.
5. (Synthesis Level) Create One- and Two- variable Data Tables to perform “What If” Analysis.
6. (Synthesis Level) Create Templates, WebPages and Web Queries.
7. (Synthesis Level) Create PivotTables and Publish on the web.
8. (Synthesis Level) Create macros - Record, edit, and run macros.
9. (Knowledge Level) Duplicate - Visual Basic for Applications (VBA) code in Excel applications.
Internal/External Standards Accreditation
Successful completion of a (MCAS) Microsoft Excel Expert Exam or the following with 80% competency:

1. Apply, edit and create a template for a given business situation.
2. Setup a One-variable and a Two-variable data table with appropriate formulas to solve a “What If” problem.
3. Properly use a workspace; link specified workbooks.
4. Relate data ranges in multiple worksheets, print and preview multiple worksheets.
5. For a given repetitive task, record, run and edit a macro, and assign the macro to a command button.
6. Correctly audit a worksheet by tracing errors, precedents and dependents relating to cells and formulas.
7. Use Goal Seek, Scenario Manager, and Solver to work a specific business problem backwards to get the desired result.
8. Use PivotTables to show supplied data in a different view.