Page 165 of Cochise College 2005-2006 Catalog by Cochise College Arizona

164 COURSE DESCRIPTIONS BUS 214 ADVANCED WORD PROCESSING (3) Prerequisite(s): BUS 213 or permission of instructor. An advanced study of word processing concepts, software, equipment and required skills for career usage using special entry/editing techniques. Course not required for the professional administrative assistant associate of applied science. 3 hours lecture; 1 hour laboratory. BUS 215 ADVANCED MEDICAL TRANSCRIPTION/TERMINOLOGY (3) Prerequisite(s): BUS 212 A further study of medical terminology encountered in medical records and medical office machine transcription. Practice sets in medical records will be utilized. 3 hours lecture. BUS 216 ADMINISTRATIVE ASSISTANT SKILLS III (4) Prerequisite(s): CIS 116 or BUS 206. This course covers intermediate microcomputer applications including word processing, spreadsheets, databases, presentations, and integration of the applications. Topics include form letters, merging, desktop publishing, financial functions, amortization schedules, data tables, creating and querying a worksheet database, templates, creating customized database reports/forms and managing switchboards, embedded visuals, and importing clips into presentation software. Student electronic employment portfolios will be developed. 3 hours lecture; 2 hours laboratory. BUS 217 ADMINISTRATIVE ASSISTANT SKILLS IV (4) Prerequisite(s): BUS 216 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 Visual Basic for applications (VBA) with word processing. Spreadsheet topics include macros, VBA, solver, data validation, password protection, scenario manager, pivot charts, pivot tables, pivot tables 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 pivot table 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 hour laboratory. BUS 219 BUSINESS STATISTICS (3) Prerequisite(s): MAT 142 or MAT 151, with grade of C or better. Recommended: Knowledge of Excel spreadsheets or completion of CIS 181. Business applications of descriptive and inferential statistics, measurement of relationships, and statistical process management. 3 hours lecture. BUS 220 BUSINESS STATISTICS(3) Prerequisite(s): BUS 219 Testing and estimation, statistical inference, variance analysis, regression, correlation, time series, and index number application. 3 hours lecture. BUS 224 FIELD EXPERIENCE IN BUSINESS ADMINISTRATION (1-6) Prerequisite(s): A declared major in business administration and prior approval of cooperative education program coordinator. Recommended: Sophomore standing. A supervised cooperative education work experience involving the combined efforts of educators and employers to accomplish career objectives in business administration. Variable credit (1-6) is available by special arrangement. May be taken four times for a maximum of 16 credit hours, with no more than six credits in a given semester. * Indicates laboratory or studio fees Indicates course may be offered online

[close]