Central Arizona College Back
CBA 133A 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: Create, format and print both structured and "what-if" spreadsheets using formulas and functions, charting and analysis. Skills learned will cover the Core Level skills for Microsoft Certified Application Specialist (MCAS): Microsoft Office Excel 2007.

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 a workbook.
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. (Analysis 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. (Application 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
Successful completion of a (MCAS): Microsoft Office Excel 2007 Exam or the following with 80% competency:

1. Correctly work with files to save, open an existing workbook, create folders, preview and print worksheets.
2. Use ribbon bar commands, shortcut keystroke commands and dialog box commands appropriately.
3. Correctly use scroll bars, cursor arrows, tab key and mouse to navigate through a worksheet.
4. Work with cells by entering text, dates and numbers; and Edit cell contents, use undo and redo, clear cell content, insert and delete selected cells, columns, or rows; cut, copy, paste and move selected cells; use find and replace; clear cell formats; and work with series correctly.
5. To achieve a given result, apply font styles, cell styles, themes and number formats; modify size and alignment of cells; and apply autoformats.
6. For a given business problem, correctly work with formulas and functions to enter, copy, and revise a formula, use relative and absolute cell references, use AutoSum and basic functions.
7. Demonstrate how to correctly use subtotals, lookup functions, and conditional logic (If function) in data tables.
8. Correctly use the Chart Wizard to create chart, modify charts, preview and print charts.
9. Use Chart Ribbons to modify legend information, set margins, add chart options, change page orientation, change chart types, styles, and locations to produce a professional quality chart.
10. Export given spreadsheet files into word processing documents and Web pages.
11. Import specified data from a databases and a text files.