Central Arizona College Back
CBA 133A Spreadsheet Applications in Excel
Credit Hours:  3
Effective Term: Fall 2015
SUN#: None
AGEC: None  
Credit Breakdown: 2 Lectures, 3 Labs
Times for Credit: 1
Grading Option: A, B, C, D, F
Cross-Listed:


Description: Create, format and print both structured and "what-if" spreadsheets using formulas and functions, charting, tables and analysis. Skills learned will cover the Core Level skills for Microsoft Office Specialist (MOS) Certification: Microsoft Office Excel 2013.

Prerequisites: Basic Windows and file management knowledge and BUS101 or MAT092.

Corequisites: None

Recommendations: None

Measurable Student Learning Outcomes
1. (Synthesis Level) Create and Manipulate Data in worksheets and workbooks.
2. (Application Level) Apply data and content formatting to: a) control the appearance, placement and format of numbers used in a spreadsheet, b) format data as a table, c) format columns, rows, cells and ranges.
3. (Application Level) Use pre-defined functions to summarize data.
4. (Synthesis Level) Calculate by creating user-designed mathematical formulas to summarize data.
5. (Application Level) Show data visually using Charts, Conditional formatting, Illustrations, Outline and sort and filter data.
6. (Synthesis Level) Use collaboration and data security techniques to manage workbook changes, protect & share workbooks and prepare workbooks for distribution.
7. (Application Level) Use the procedures necessary to store, retrieve and print data, worksheets and workbooks.
8. (Application Level) Use Import and export techniques to get data from or give data to other software applications or web pages.
Internal/External Standards Accreditation
External Standards for MOS Certification:
Microsoft Office Specialist(MOS) 2013 Excel Core Exam standards can be found at the following link:

Excel Exam 77-420
https://www.microsoft.com/learning/en-us/exam-77-420.aspx