Location:
Various approved locations throughout the United States.
Dates:
January 2004 - February 2013.
Instructional delivery format:
Traditional classroom model
Learner Outcomes:
Use advanced functions and applications associated with Microsoft Office XP Suite products, including Word 2002, Excel 2002, Access 2002, PowerPoint 2002, and Outlook 2002.
Instruction:
Microsoft Office 2002 advanced applications; Word 2002: Creating a document with a table, chart, and watermark; generating form letters, mailing labels, and envelopes; creating a professional newsletter; merging form letters to e-mail addresses using an Access table; Excel 2002: Financial functions, data tables, amortization schedules, and hyperlinks; creating, sorting, and querying a worksheet database; creating templates and working with multiple worksheets and workbooks; linking an Excel worksheet to a Word document; Access 2002: Enhancing forms with OLE fields, hyperlinks, and subforms; creating an application system using macros, wizards, and the switchboard manager; integrating Excel worksheet data into an Access database; PowerPoint 2002: Using embedded visuals to enhance a slide show; creating a presentation containing interactive OLE documents; importing clips from the Microsoft clip gallery live web site. Course participants complete projects within each of the applications areas and also undergo a final written examination and a final performance assessment involving one project from each of the applications areas: Word, Excel, Access, and Power Point. (Prerequisite: Introduction to Microsoft Office XP Suite or other appropriate prior learning and/or experience.)
Credit recommendation:
In the lower division baccalaureate/associate degree category, 3 semester hours as Computer Software Applications (5/04). *NOTE: Course numbers on transcripts may reflect different prefixes depending upon where a course is offered.
