Cochise College

CATALOG 2014-15

BUS 217 Administrative Assistant Skills IV (4)

Prerequisite(s): BUS 216 or permission of instructor.

This course covers advanced applications including word processing, spreadsheet, database, presentation, and integration of the applications. Word processing topics include creating an index, a table of contents, online forms, merging e-mail form letters using a database, and using VBA with word processing. Spreadsheet topics include macros, Visual Basic for Applications (VBA), Solver, data validation, password protection, Scenario Manager, PivotCharts, PivotTables, PivotTable lists, importing data, tracking changes, Send To command, and Data Maps. Database topics include creating a report using design view, customizing forms using VBA, working with charts and PivotTable objects, administering a database, SQL, and database data in other applications. Presentation topics include creating a self-running presentation using animation effects; using VBA with presentations; and distributing presentations to remote audiences. A capstone course electronic employment portfolio will be completed.

3 hours lecture, 2 hours laboratory.

Contents