Search Our Site

Become a Program Member!

THE SAGE GROUP, LLC

Computer Software Applications Courses

• Organization description
  (titles of all evaluated learning experiences, organization description, and source of official student records)

• Titles of all evaluated learning experiences in the Computer Software Applications area

• Descriptions and credit recommendations

Descriptions and credit recommendations

Advanced Microsoft Office 2000 (202)*
Location: Various approved locations throughout the United States.
Length: 60 hours (10 weeks).
Dates: February 2004 - December 2004.
Objectives: Use advanced functions and applications associated with Microsoft Office 2000 Suite products, including Word 2000, Excel 2000, Access 2000, PowerPoint 2000, and Outlook 2000.
Instruction: Microsoft Office 2000 advanced applications; Word 2000: 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 2000: 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 2000: 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 2000: 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 2000 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.

Advanced Microsoft Office XP Suite (212)*
Location: Various approved locations throughout the United States.
Length: 60 hours (10 weeks).
Dates: January 2004 - Present.
Objectives: 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.

Introduction to Microsoft Application Suite (201)*
Location: Various approved locations throughout the United States.
Length: 60 hours (10 weeks).
Dates: August 2003 - July 2007.
Objectives: Discuss the basic concepts and components of a PC; operate Microsoft Windows 98; use the basic functions and applications associated with Microsoft Office Suite products, including Word, Excel, Access, PowerPoint, and Outlook.
Instruction: Components of a computer, including input devices, the central processing unit; memory, output devices, and auxiliary storage; Microsoft Windows 98 graphical user interface; Microsoft Office 2000 applications; Word 2000: creating and editing a Word document; creating a research paper; using a Wizard to create a resume and a cover letter with a table; creating Web pages; Excel 2000: creating a worksheet and embedded chart; formulas, functions, formatting, and Web queries; what-if analysis; charting; working with large worksheets; creating static and dynamic Web pages; Access 2000: creating a database using design and datasheet views; querying a database using the select query window; maintaining a database using the design and update features; publishing to the Internet using data access pages; PowerPoint 2000: using a design template and auto layouts to create a presentation; using outline view and clip art to create a slide show; creating a presentation on the Web; Outlook 2000: desktop information management using Outlook; Integration: integrating Office 2000 applications and the World Wide Web. 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, PowerPoint, and Outlook. Course participants also complete an integration project.
Credit recommendation: In the lower division baccalaureate/associate degree category, 3 semester hours as Computer Software Applications (5/03). *NOTE: Course numbers on transcripts may reflect different prefixes depending upon where a course is offered.

Introduction to Microsoft Office XP Suite (211)*
Location: Various approved locations throughout the United States.
Length: 60 hours (10 weeks).
Dates: January 2004 - Present
Objectives: Discuss the basic concepts and components of a PC; operate Microsoft Windows 200; use the basic functions and applications associated with Microsoft Office XP Suite products, including Word 2002, Excel 2002, Access 2002, PowerPoint 2002, and Outlook 2002.
Instruction: Components of a computer, including input devices, the central processing unit; memory, output devices, and auxiliary storage; Microsoft Windows 2000 graphical user interface; Microsoft Office XP applications; Word 2002: Creating and editing a Word document; creating a research paper; using a Wizard to create a resume and a cover letter with a table; creating Web pages; Excel 2002: Creating a worksheet and embedded chart; formulas, functions, formatting, and Web queries; what-if analysis; charting; working with large worksheets; creating static and dynamic Web pages; Access 2002: Creating a database using design and datasheet views; querying a database using the select query window; maintaining a database using the design and update features; publishing to the Internet using data access pages; PowerPoint 2002: Using a design template and auto layouts to create a presentation; using outline view and clip art to create a slide show; creating a presentation on the Web; Outlook 2002: Desktop information management using Outlook; Integration: Integrating Office XP applications and the World Wide Web. 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, PowerPoint, and Outlook. Course participants also complete an integration project.
Credit recommendation: In the lower division baccalaureate/associate degree category, 3 semester hours as Computer Software Applications (5/04) (12/05 revalidation). NOTE: Course numbers on transcripts may reflect different prefixes depending upon where a course is offered.

1. Microsoft Excel 2002 Basic
2. Microsoft Excel 2002 Intermediate
3. Microsoft Excel 2002 Advanced
Location: Various approved locations throughout the United States.
Length: Course 1. 21 hours (7 weeks); Course 2. 24 hours (8 weeks); Course 3. 24 hours (8 weeks).
Dates: 1., 2., or 3.: April 2005 - December 2005.
Objectives: Course 1: Define spreadsheet software; start and exit Excel 2002; view the Excel window; open, save, and close a workbook; enter labels and values in a worksheet; name and move a sheet; preview and print a worksheet; get Help; plan and design a worksheet; edit, copy and move cell entries; enter formulas and create complex formulas; identify and use frequently used functions; copy formulas with relative and absolute cell references; format values; use fonts, font sizes, and change attributes and alignments; adjust column widths; insert and delete rows and columns; apply colors, patterns, and borders; use conditional formatting; check spelling; plan, design, and create a chart; move and resize a chart; edit, format, and enhance a chart; annotate and draw on a chart; preview and print a chart; create a formula with several operators; use names in a formula and dates in calculations; generate multiple totals with AutoSum; use statistical functions; calculate payments with the PMT function; display and print formula contents. Course 2: Freeze columns and rows; insert and delete worksheets; consolidate data with 3-D references; hide and protect worksheet areas; save custom views of a worksheet; control page breaks and page numbering; create a hyperlink between Excel files; save an Excel file as a web page; plan, record, edit and run a macro; use shortcut keys with macros, add a macro as a menu item, and create a toolbar for macros; use the Personal Macro Workbook; plan and create a list; add records with the data form; find and delete records; sort a list on one field or multiple fields; print a list; use AutoFilter to retrieve records; create a custom filter, filter a list with Advanced Filter, extract list data; create subtotals using grouping and outlines; look up values in a list; summarize list data; use data validation for list entries; select a custom chart type; customize a data series; format a chart axis; add a data table to a chart; rotate charts and text; enhance a chart with WordArt; add a picture to a chart; set up a shared workbook for multiple users and track revisions; apply and modify workbook passwords; create an interactive worksheet and a PivotTable list for the Web; add Web hyperlinks to an Excel file; and run Web queries to retrieve external data. Course 3:  Define what-if analysis; track a what-if analysis with Scenario Manager and generate a scenario summary; project figures using a data table; create a two-input data table; use the Goal Seek feature to solve a what-if analysis; set up a complex what-if analysis with Solver; run Solver and generate an Answer Report; plan, design, create, and update a PivotTable report; change the summary function, the structure and format of a PivotTable report; analyze three-dimensional data; create a PivotChart report; use the GETPIVOTDATA function; plan a data exchange; import a text file and database table into Excel; insert a graphic file in a worksheet; embed a worksheet; link a worksheet to another program; embed an Excel chart into a PowerPoint slide; import a list into an Access table; find files using Excel search tools; use Excel auditing feature to track errors and check worksheet logic; use Excel Outline command; control worksheet calculations; create custom AutoFill lists; customize Excel; add a comment to a cell; save a workbook as a template; view, analyze, and write VBA code; add a conditional statement to a procedure; prompt the user for data while a macro is running; debug a macro; create and run several macros into one main procedure.
Instruction: Course 1: Navigating Excel 2002; building and editing worksheets; formatting a worksheet; working with charts; working with formulas and functions. Course 2: Managing workbooks and preparing them for the Web; Automating worksheet tasks; using lists; analyzing list data; enhancing charts and worksheets; sharing Excel files and incorporating Web information. Course 3: Using what-if analysis; analyzing data with PivotTables; exchanging data with other programs; customizing and advanced worksheet management; programming with Excel.
Credit recommendation: Courses 1, 2, and 3: In the lower division baccalaureate/associate degree category, 2 semester hours as Computer Software Applications (4/05). NOTE: Courses 1, 2, and 3 must all be completed to receive credit. NOTE: These courses are also components of the Introductory or Advanced Microsoft courses listed in this section and, thus, there is overlap in content. Care should be taken, therefore, in the awarding of credit for these courses, if the Introductory or Advanced Microsoft courses have also been completed. Further, a total of 6 semester hours of credit is recommended for the Introductory or Advanced courses or any combination of its component courses. 

1. Microsoft Excel 2003 Basic
2. Microsoft Excel 2003 Intermediate
3. Microsoft Excel 2003 Advanced
Location: Various approved locations throughout the United States.
Length: Course 1. 21 hours (7 weeks); Course 2. 24 hours (8 weeks); Course 3. 24 hours (8 weeks).
Dates: 1., 2., or 3.: November 2005 - Present.
Objectives: Course 1: Define spreadsheet software; start and exit Excel 2003; view the Excel window; open, save, and close a workbook; enter labels and values in a worksheet; name and move a sheet; preview and print a worksheet; and get Help; plan and design a worksheet; edit, copy and move cell entries; enter formulas and create complex formulas; identify and use frequently used functions; copy formulas with relative and absolute cell references; format values; use fonts, font sizes, and change attributes and alignments; adjust column widths; insert and delete rows and columns; apply colors, patterns, and borders; use conditional formatting; and check spelling; plan, design, and create a chart; move and resize a chart; edit, format, and enhance a chart; annotate and draw on a chart; preview and print a chart; create a formula with several operators; use names in a formula and dates in calculations; generate multiple totals with AutoSum; use statistical functions; calculate payments with the PMT function; display and print formula contents. Course 2: Freeze columns and rows; insert and delete worksheets; consolidate data with 3-D references; hide and protect worksheet areas; save custom views of a worksheet; control page breaks and page numbering; create a hyperlink between Excel files; and save an Excel file as a web page; plan, record, edit and run a macro; use shortcut keys with macros, add a macro as a menu item, and create a toolbar for macros; use the Personal Macro Workbook; plan and create a list; add records with the data form; find and delete records; sort a list on one field or multiple fields; and print a list; use AutoFilter to retrieve records; create a custom filter, filter a list with Advanced Filter, and extract list data; create subtotals using grouping and outlines; look up values in a list; summarize list data; and use data validation for list entries; select a custom chart type; customize a data series; format a chart axis; add a data table to a chart; rotate charts and text; enhance a chart with WordArt; and add a picture to a chart; set up a shared workbook for multiple users and track revisions; apply and modify workbook passwords; create an interactive worksheet and a PivotTable list for the Web; add Web hyperlinks to an Excel file; work with XML data; and run Web queries to retrieve external data. Course 3:  Define what-if analysis; track a what-if analysis with Scenario Manager and generate a scenario summary; project figures using a data table; create a two-input data table; use the Goal Seek feature to solve a what-if analysis; set up a complex what-if analysis with Solver; and run Solver and generate an Answer Report; plan, design, create, and update a PivotTable report; change the summary function, the structure and format of a PivotTable report; analyze three-dimensional data; create a PivotChart report; use the GETPIVOTDATA function; plan a data exchange; import a text file and database table into Excel; insert a graphic file in a worksheet; embed a worksheet; link a worksheet to another program; embed an Excel chart into a PowerPoint slide; import a list into an Access table; find files using Excel search tools; use Excel auditing feature to track errors and check worksheet logic; use Excel Outline command; control worksheet calculations; create custom AutoFill lists; customize Excel; add a comment to a cell; save a workbook as a template; view, analyze, and write VBA code; add a conditional statement to a procedure; prompt the user for data while a macro is running; debug a macro; create and run several macros into one main procedure.
Instruction: Course 1: Navigating Excel 2003; building and editing worksheets; formatting a worksheet; working with charts; working with formulas and functions. Course 2: Managing workbooks and preparing them for the Web; Automating worksheet tasks; using lists; analyzing list data; enhancing charts and worksheets; sharing Excel files and incorporating Web information. Course 3: Using what-if analysis; analyzing data with PivotTables; exchanging data with other programs; customizing and advanced worksheet management; programming with Excel.
Credit recommendation: Courses 1, 2, and 3: In the lower division baccalaureate/associate degree category, 2 semester hours as Computer Software Applications (11/05). NOTE: Courses 1, 2, and 3 must all be completed to receive credit. NOTE: These courses are also components of the Introductory or Advanced Microsoft courses listed in this section and, thus, there is overlap in content. Care should be taken, therefore, in the awarding of credit for these courses, if the Introductory or Advanced Microsoft courses have also been completed. Further, a total of 6 semester hours of credit is recommended for the Introductory or Advanced courses or any combination of its component courses. 

1. Microsoft PowerPoint 2002 Basic
2. Microsoft PowerPoint 2002 Advanced
Location: Various approved locations throughout the United States.
Length: Course 1: 21 hours (7 weeks); Course 2: 21 hours (7 weeks).
Dates: April 2005 - December 2005.
Objectives: Course 1:Define presentation software; start and exit PowerPoint 2002; view the PowerPoint window; use the AutoContent Wizard; view, save, print and close the presentation file; use the Help system; plan a presentation; enter slide text and create a new slide; enter text in the Outline tab; add slide headers and footers; choose a look for a presentation; check spelling in a presentation; evaluate a presentation; open an existing presentation; use drawing tools to draw, modify, and edit an object; align and group objects; add, arrange, and format text; import text from Microsoft Word; customize the color scheme and background; insert clip art to enhance a presentation; insert, crop, and scale a picture; embed and format a chart; enter and edit data in the datasheet; create tables in PowerPoint; set slide show timings, transitions, animation effects; understand and use PowerPoint masters; format master text and change master text indents; adjust text objects; use advanced drawing and formatting tools; use the Style Checker; and create a template. Course 2: Import data from a file into a datasheet and format a datasheet with Microsoft Graph; change chart type and display; work with chart elements; animate charts and sounds; embed and modify an organizational chart; embed a picture and an Excel chart; insert a Word table, an animated GIF file, a sound, and a hyperlink; link and update an Excel worksheet; send a presentation for review and combine reviewed presentations; set up a slide show and create a custom show; use the Meeting Minder; rehearse slide timings; publish a presentation on the Web and broadcast a presentation; use the Pack and Go Wizard.
Instruction: Course 1: Navigating PowerPoint 2002; creating a presentation; modifying a presentation; enhancing a presentation; customizing a presentation. Course 2: Enhancing charts; working with embedded and linked objects and hyperlinks; using advanced features.
Credit recommendation: Courses 1and 2: In the lower division baccalaureate/associate degree category, 1 semester hour as Computer Software Applications (4/05). NOTE: Courses 1 and 2 must both be completed to receive credit. NOTE: These courses are also components of the Introductory or Advanced Microsoft courses listed in this section and, thus, there is overlap in content. Care should be taken, therefore, in the awarding of credit for these courses, if the Introductory or Advanced Microsoft courses have also been completed. Further, a total of 6 semester hours of credit is recommended for the Introductory or Advanced courses or any combination of its component courses. 

1. Microsoft PowerPoint 2003 Basic
2. Microsoft PowerPoint 2003 Advanced
Location: Various approved locations throughout the United States.
Length: Course 1: 21 hours (7 weeks); Course 2: 21 hours (7 weeks).
Dates: November  2005 - Present.
Objectives: Course 1:Define presentation software; start and exit PowerPoint 2003; view the PowerPoint window; use the AutoContent Wizard; view, save, print and close the presentation file; use the Help system; plan a presentation; enter slide text and create a new slide; enter text in the Outline tab; add slide headers and footers; choose a look for a presentation; check spelling in a presentation; and evaluate a presentation; open an existing presentation; use drawing tools to draw, modify, and edit an object; align and group objects; add, arrange, and format text; import text from Microsoft Word; customize the color scheme and background; insert clip art to enhance a presentation; insert, crop, and scale a picture; embed and format a chart; enter and edit data in the datasheet; create tables in PowerPoint; set slide show timings, transitions, and animation effects; understand and use PowerPoint masters; format master text and change master text indents; adjust text objects; use advanced drawing and formatting tools; use the Style Checker; and create a template. Course 2: Import data from a file into a datasheet and format a datasheet with Microsoft Graph; change a chart's type and display; work with chart elements; animate charts and add sounds; embed a picture and an Excel chart; link an Excel worksheet and update a linked Excel worksheet; insert an animated GIF file, a sound, and a hyperlink; and create a photo album; send a presentation for review and combine reviewed presentations; set up a slide show and create a custom show; rehearse slide timings; publish a presentation on the Web; package a presentation; and broadcast a presentation.
Instruction: Course 1: Navigating PowerPoint 2003; creating a presentation; modifying a presentation; enhancing a presentation; customizing a presentation. Course 2: Enhancing charts; working with embedded and linked objects and hyperlinks; using advanced features.
Credit recommendation: Courses 1and 2: In the lower division baccalaureate/associate degree category, 1 semester hour as Computer Software Applications (11/05). NOTE: Courses 1 and 2 must both be completed to receive credit. NOTE: These courses are also components of the Introductory or Advanced Microsoft courses listed in this section and, thus, there is overlap in content. Care should be taken, therefore, in the awarding of credit for these courses, if the Introductory or Advanced Microsoft courses have also been completed. Further, a total of 6 semester hours of credit is recommended for the Introductory or Advanced courses or any combination of its component courses. 

1. Microsoft Word 2002 Basic
2. Microsoft Word 2002 Intermediate
3. Microsoft Word 2002 Advanced
Location: Various approved locations throughout the United States.
Length: Course 1: 21 hours (7 weeks); Course 2: 24 hours (8 weeks); Course 3: 27 hours (9 weeks).
Dates: 1, 2, or 3: April 2005 - December 2005.
Objectives: Course 1: Understand word processing software; start and exit Word 2002 and explore the Word program window; start, save, print, and close a document; use the Help system; open a document; select, cut, copy, and paste text; use the office clipboard; use the spelling and grammar checking and Thesaurus; find and replace text; use wizards and templates; format with fonts; change font styles and effects; change line and paragraph spacing and align paragraphs; work with tabs and indents; add bullets, numbering, borders and shading; set document margins; divide a document into sections and add page breaks and page numbers; insert and edit headers and footers; format columns; and insert clip art; insert a table and insert, delete, and modify table rows and columns; sort table data; split and merge table cells; perform calculations in tables; use Table AutoFormat and create a custom format for a table. Course 2:  Add, resize, and position graphics; create text boxes and AutoShapes; use the drawing canvas; create WordArt and charts; plan and create Web pages; format and illustrate a Web page with themes and graphics; save a document as a Web page; add and modify hyperlinks; and preview a Web page in a browser; create a main document and add merge fields; design a data source and enter, edit, sort, and filter records; merge data and create labels; create and modify paragraph and character styles; create list and table styles; rename, delete, and copy styles; create, revise, attach a template; build a multi-page document in Outline view and work in Outline view; modify pages in multiple sections; add footnotes and endnotes; use document map and cross-references to navigate through a multi-page document; generate a table of contents and index; work with master documents. Course 3: Embed an Excel worksheet and link an Excel chart; embed a PowerPoint slide; insert a Word file; import a table from Access; manage document links; merge with an Access Data Source; insert drop caps and edit clip art; align, distribute, and rotate graphics; use advanced positioning options; adjust shadow and 3-D settings; insert a watermark and a page border; construct a form template; add and modify text, drop-down, and check box form fields; use calculations in a form; add help to a form and insert form controls; format and protect a form; fill in a form as a user; define charts and diagrams; create and edit a column chart and pie chart; import spreadsheet data into a chart; create a diagram; create and modify an organization chart; include comments in a document created by someone else; track, accept, and reject changes when working on a document with two or more people; create document versions; compare documents and merge changes; use Find and Replace options; protect documents from changes and comments; plan, create, and run a macro; edit a macro in Visual Basic; rename, delete, and copy macros; create a custom toolbar; and customize menus and modify default settings.
Instruction: Course 1: Navigating Word 2002; editing documents; formatting text and paragraphs; formatting documents; creating and formatting tables. Course 2: Illustrating documents with graphics; creating a Web site; merging Word documents; working with styles and templates; developing multi-page documents. Course 3: Integrating Word with other programs; exploring advanced graphics; building forms; working with charts and diagrams collaborating with workgroups; customizing Word.
Credit recommendation: Courses 1, 2, and 3: In the lower division baccalaureate/associate degree category, 2 semester hours as Computer Software Applications (4/05). NOTE: Courses 1, 2, and 3 must all be completed to receive credit. NOTE: These courses are also components of the Introductory or Advanced Microsoft courses listed in this section and, thus, there is overlap in content. Care should be taken, therefore, in the awarding of credit for these courses, if the Introductory or Advanced Microsoft courses have also been completed. Further, a total of 6 semester hours of credit is recommended for the Introductory or Advanced courses or any combination of its component courses. 

1. Microsoft Word 2003 Basic
2. Microsoft Word 2003 Intermediate
3. Microsoft Word 2003 Advanced
Location: Various approved locations throughout the United States.
Length: Course 1: 21 hours (7 weeks); Course 2: 24 hours (8 weeks); Course 3: 27 hours (9 weeks).
Dates: 1, 2, or 3: November 2005 - Present.
Objectives: Course 1: Understand word processing software; start and exit Word 2003 and explore the Word program window; start, save, print, and close a document; use the Help system; open a document; select, cut, copy, and paste text; use the office clipboard; use the spelling and grammar checking and Thesaurus; find and replace text; and use wizards and templates; format with fonts; change font styles and effects; change line and paragraph spacing and align paragraphs; work with tabs and indents; add bullets, numbering, borders and shading; set document margins; divide a document into sections and add page breaks and page numbers; insert and edit headers and footers; format columns; and insert WordArt and clip art; insert a table and insert, delete, and modify table rows and columns; sort table data; split and merge table cells; perform calculations in tables; use Table AutoFormat and create a custom format for a table. Course 2:  Add, resize, and position graphics; create text boxes and AutoShapes; use the drawing canvas; format WordArt and create charts; plan and create Web pages; format and illustrate a Web page with themes and graphics; save a document as a Web page; add and modify hyperlinks; and preview a Web page in a browser; create a main document and add merge fields; design a data source and enter, edit, sort, and filter records; merge data and create labels; create and modify paragraph and character styles; create list and table styles; rename, delete, and copy styles; create, revise, attach a template; build a multi-page document in Outline view and work in Outline view; modify pages in multiple sections; add footnotes and endnotes; use document map and cross-references to navigate through a multi-page document; generate a table of contents and index; work with master documents. Course 3: Embed an Excel worksheet and link an Excel chart; embed a PowerPoint slide; insert a Word file; import a table from Access; manage document links; merge with an Access Data Source; insert drop caps and edit clip art; align, distribute, and rotate graphics; use advanced positioning options; adjust shadow and 3-D settings; insert a watermark and a page border; construct a form template; add and modify text, drop-down, and check box form fields; use calculations in a form; add help to a form and insert form controls; format and protect a form; fill in a form as a user; define charts and diagrams; create and edit a column chart and pie chart; import spreadsheet data into a chart; create a diagram; create and modify an organization chart; include comments in a document created by someone else; track, accept, and reject changes when working on a document with two or more people; create document versions; compare documents and merge changes; use Find and Replace options; protect documents from changes and comments; plan, create, and run a macro; edit a macro in Visual Basic; rename, delete, and copy macros; create a custom toolbar; and customize menus and modify default settings.
Instruction: Course 1: Navigating Word 2003; editing documents; formatting text and paragraphs; formatting documents; creating and formatting tables. Course 2: Illustrating documents with graphics; creating a Web site; merging Word documents; working with styles and templates; developing multi-page documents. Course 3: Integrating Word with other programs; exploring advanced graphics; building forms; working with charts and diagrams collaborating with workgroups; customizing Word.
Credit recommendation: Courses 1, 2, and 3: In the lower division baccalaureate/associate degree category, 2 semester hours as Computer Software Applications (11/05). NOTE: Courses 1, 2, and 3 must all be completed to receive credit. NOTE: These courses are also components of the Introductory or Advanced Microsoft courses listed in this section and, thus, there is overlap in content. Care should be taken, therefore, in the awarding of credit for these courses, if the Introductory or Advanced Microsoft courses have also been completed. Further, a total of 6 semester hours of credit is recommended for the Introductory or Advanced courses or any combination of its component courses. 

Updated 5/13/08

Return to all CCR Online  listings