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 Excel 2007 Basic (256)
2. Microsoft Excel 2007 Intermediate (257)
3. Microsoft Excel 2007 Advanced (258)
Location: Various approved locations throughout the United States.
Length: Course 1. 20 hours (2.5 weeks); Course 2. 20 hours (2.5 weeks); Course 3. 20 hours (2.5 weeks).
Dates: 1., 2., or 3.: December 2009 - Present.
Objectives: Course 1: Identify Excel spreadsheet components; recognize the main components of an Excel window; utilize the Excel Help feature; open and navigate Excel workbooks; enter text values in an Excel spreadsheet; edit formulas in an Excel spreadsheet; insert and work with pictures; update and save a workbook; move and copy data and formulas in a worksheet; use absolute formulas in a worksheet; insert and delete worksheet ranges, rows, and columns; enter functions in Excel; insert SUM and AutoSum functions; explain additional functions available in Excel; format text to create different fonts, sizes, and styles; adjust columns, rows, and alignment; format values as currency, percentages, or numbers; apply conditional formats; copy formats, use styles and table styles to apply formats; format a worksheet for printing; preview how a worksheet will look when printed; control print options such as page orientation; print Excel worksheets; create charts based on worksheet data; move charts within a workbook; change chart types and format chart elements; move and resize embedded charts; print charts; manage large Excel workbooks; split a worksheet; use the Freeze Pane command; set print titles and page breaks; manage and print multiple worksheets. Course 2: Switch between workbooks; copy a sheet from one workbook to another; create and manage linked workbooks; create a workspace; apply built-in and custom number formats; use functions to modify text; create, apply, and modify styles; apply and modify themes; merge and change cells; create outlines; group and organize data; consolidate data from different worksheets; create automatic subtotals to summarize data in a worksheet; use names to make formulas easier to understand; utilize the Name Manager; manage 3-D names; organize data using lists; sort and filter lists; use the Custom AutoFilter and Advanced Filter dialog boxes; create and format tables; save a workbook as a Web Page; add and remove hyperlinks in a worksheet; save a workbook as a PDF file; send a workbook via e-mail; work with and adjust the scale of a chart; format data points; create combination charts; add and format graphic elements to a chart; add a picture to a worksheet; utilize auditing features; add and edit comments; protect a workbook; share workbooks; merge workbooks and track changes; change default application settings; create invoices using built-in templates; create and manage custom templates. Course 3: Use logical functions to calculate values; apply math and statistical functions; calculate periodic payments; display and print formulas; use Excel functions to find values in a worksheet list; utilize the MATCH and INDEX functions to find values; create data tables; validate cell data; summarize list values; create a PivotTable; analyze and compare large amounts of data; apply styles and change PivotTable settings; create a PivotChart; export data from Excel to a text file; import data from a text file into an Excel workbook; import XML data into a workbook; export data from a workbook to an XML data file; use query features to import data from external databases; utilize the Goal Seek and Solver utilities; install and use the Analysis ToolPak; create scenarios to save input values; create views to save worksheet settings; create and run macros; edit a macro using the Visual Basic Editor; create custom functions; apply conditional formatting; insert and modify SmartArt.
Instruction: Course 1: Basic spreadsheet calculation knowledge and skills; excel spreadsheet components; Excel workbook navigation; calculating formulas in a worksheet; inserting and deleting worksheet ranges, rows, and columns; formatting values as currency, percentages, or numbers; applying conditional formats; creating charts based on worksheet data; managing large Excel workbooks; managing and printing multiple worksheets. Course 2: Switching between Excel workbooks; creating and managing linked workbooks; applying built-in and custom number formats; using functions to modify text; merging and changing cells; grouping and organizing data; consolidating data from different worksheets; creating automatic subtotals to summarize data in a worksheet; using names to make formulas easier to understand; organizing data using lists; creating and format tables; saving a workbook as a Web Page; adding and removing hyperlinks in a worksheet; saving a workbook as a PDF file; formatting data points; utilizing auditing features; protecting a workbook; sharing workbooks; merging workbooks and track changes; creating and manage custom templates. Course 3: Logical functions; statistical functions; periodic payments; Excel advanced formulas; Excel functions; data tables; cell data; list values; PivotTables and PivotCharts; analyzing and comparing large amounts of data; applying styles and changing PivotTable settings; importing and exporting data; using query features to import data from external databases; installing and using the Analysis ToolPak; create scenarios to save input values; creating, editing and running macros; custom functions; conditional formatting; inserting and modifying SmartArt; XML schema systems .
Credit recommendation: Courses 1, 2, and 3: In the lower division baccalaureate/associate degree category, 2 semester hours as Computer Software Applications (12/09). 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. 

Microsoft Office Trilogy (052)*
Location: Various approved locations throughout the United States.
Length: 40 hours (5 weeks).
Dates: October 2008 - Present.
Objectives: Create and save new documents in Word; format documents in Word; create worksheets in Excel; add charts and calculate formulas in Excel; create slide shows in PowerPoint; present overhead presentations in PowerPoint.
Instruction: Word processing concepts and skills; spreadsheet terminology, concepts, and skills; presentation applications and slide shows.
Credit recommendation: In the lower division baccalaureate/associate degree category, 1 semester hour as Computer Software Applications (10/08) (12/09). NOTE: Microsoft Office Trilogy (052), Microsoft Office Trilogy - Intermediate (247), and Microsoft Office Trilogy - Advanced (248) are sequential and when taken consecutively are comparable to a 3 semester hour course in Computer Software Applications. *NOTE: Course numbers on transcripts may reflect different prefixes depending upon where a course is offered.

Microsoft Office Trilogy - Intermediate (247)*
Location: Various approved locations throughout the United States.
Length: 40 hours (5 weeks).
Dates: December 2008 - Present.
Objectives: Word: Explain text formatting; utilize the Revel Formatting task pane; modify, override, and export styles; format a document outline; view documents using the Document Map and thumbnails; create and format sections of text; insert section breaks, headers and footers, and page numbers; format text into multiple columns; align text in a table; merge and split table cells; change text orientation and resize rows; change table borders and apply shading to cells; sort data in a table, split a table, and enter a formula in a table; repeat a header row on multiple pages; apply and modify table styles; prepare and print labels and envelops; create a document from a template; save a template and store a custom template; utilize the Building Block Organizer; use the Restrict Formatting and Editing pane; create and modify a graphic; insert text boxes; insert and modify shapes; format text using WordArt, drop caps and pull quotes; track changes while editing; review and accept revisions; view changes by different reviewers; merge revisions and insert, print, and delete comments; preview and save a document as a Web page; open an HTML document in a browser; edit an HTML document in Word; insert a hyperlink in a document; navigate using hyperlinks. Excel: Switch between workbooks; copy a sheet from one workbook to another; create and manage linked workbooks; create a workspace; apply built-in and custom number formats; use functions to modify text; create, apply, and modify styles; apply and modify themes; merge and change cells; create outlines; group and organize data; consolidate data from different worksheets; create automatic subtotals to summarize data in a worksheet; use names to make formulas easier to understand; utilize the Name Manager; manage 3-D names; organize data using lists; sort and filter lists; use the Custom AutoFilter and Advanced Filter dialog boxes; create and format tables; save a workbook as a Web Page; add and remove hyperlinks in a worksheet; save a workbook as a PDF file; send a workbook via e-mail; work with and adjust the scale of a chart; format data points; create combination charts; add and format graphic elements to a chart; add a picture to a worksheet; utilize auditing features; add and edit comments; protect a workbook; share workbooks; merge workbooks and track changes; change default application settings; create invoices using built-in templates; create and manage custom templates. PowerPoint: Use the Slide Master to build a custom presentation; insert slides from other presentations; rearrange and delete slides; crop and modify images; add sound and movie clips; add narration to a presentation; format SmartArt graphics; create a custom table; create a photo album using digital photographs; add animation to a presentation; create a custom slide show; use the Presenter View feature; publish a presentation as a webpage; share a presentation.
Instruction: Word: Styles; sections and columns; formatting tables; printing labels and envelopes; templates and building blocks; graphics; managing document revisions; web features. Excel: Multiple worksheets and workbooks; advanced formatting; outling and subtotals; cell and range names; lists and tables; web and Internet features; advanced charting; documenting and auditing; templates and settings. PowerPoint: Customizing presentations; graphics, movies, and sound effects; customizing graphics and tables; photo albums and animation; delivery options.
Credit recommendation: In the lower division baccalaureate/associate degree category, 1 semester hour as Computer Software Applications (12/08). NOTE: Microsoft Office Trilogy (052), Microsoft Office Trilogy - Intermediate (247), and Microsoft Office Trilogy - Advanced (248) are sequential and when taken consecutively are comparable to a 3 semester hour course in Computer Software Applications. *NOTE: Course numbers on transcripts may reflect different prefixes depending upon where a course is offered.

Microsoft Office Trilogy - Advanced (248)*
Location: Various approved locations throughout the United States.
Length: 40 hours (5 weeks).
Dates: December 2008 - Present.
Objectives: Word: Create form letters using the mailing tab; create a recipient list; sort and filter records; use a recipient list to create mailing labels and envelopes; insert and modify new objects; apply background colors, fill effects, watermarks, and themes; protect document formatting; create forms by adding labels and content controls; protect forms; utilize the Compatibility Checker and Document Inspector; use digital signatures to share and secure documents; record and run macros to automate tasks; modify, copy, and delete macros; customize the Quick Access toolbar; customize keyboard shortcuts; create a master document; add cover pages; create, modify, and update a table of contents; create indexes, bibliographies, table of authorities, and footnotes; describe bookmarks and cross-references; add frames to Web page documents; create an XML document; attach an XML schema; use XML options and create a transform. Excel: Use logical functions to calculate values; apply math and statistical functions; calculate periodic payments; display and print formulas; use Excel functions to find values in a worksheet list; utilize the MATCH and INDEX functions to find values; create data tables; validate cell data; summarize list values; create a PivotTable; analyze and compare large amounts of data; apply styles and change PivotTable settings; create a PivotChart; export data from Excel to a text file; import data from a text file into an Excel workbook; import XML data into a workbook; export data from a workbook to an XML data file; use query features to import data from external databases; utilize the Goal Seek and Solver utilities; install and use the Analysis ToolPak; create scenarios to save input values; create views to save worksheet settings; create and run macros; edit a macro using the Visual Basic Editor; create custom functions; apply conditional formatting; insert and modify SmartArt. PowerPoint: Add, remove, and rearrange buttons on the Quick Access toolbar; create and apply a custom design theme; apply a custom template; modify presentations; modify images; add sound and movie clips; apply animation effects; create a photo album; format SmartArt graphics; make changes to objects; create and format a custom table; add interactive elements to a slide; add and modify actions buttons; create a custom slide show; review a presentation using comments; share a presentation; publish a presentation; create a presentation using a Word document; add content to slides by embedding or linking from Word or Excel; create a hyperlink to a Word document or Excel spreadsheet.
Instruction: Word: Mail merge; objects and backgrounds; forms; macros; toolbar and keyboard customization; long documents; XML features. Excel: Advanced functions; lookups and data tables; advanced table management; pivot tables and pivot chart; exporting and importing; analytical options; macros and custom functions; conditional formatting and SmartArt. PowerPoint: custom presentation options; graphic and multimedia content; customizing SmartArt; action buttons; custom slide shows; distributing a presentation; integrating Microsoft Office files.
Credit recommendation: In the lower division baccalaureate/associate degree category, 1 semester hour as Computer Software Applications (12/08). NOTE: Microsoft Office Trilogy (052), Microsoft Office Trilogy - Intermediate (247), and Microsoft Office Trilogy - Advanced (248) are sequential and when taken consecutively are comparable to a 3 semester hour course in Computer Software Applications. *NOTE: Course numbers on transcripts may reflect different prefixes depending upon where a course is offered.

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 PowerPoint 2007 Basic (259)
2. Microsoft PowerPoint 2007 Advanced (260)
Location: Various approved locations throughout the United States.
Length: Course 1: 20 hours (2.5 weeks); Course 2: 20 hours (2.5 weeks).
Dates: December 2009 - Present.
Objectives: Course 1: Identify and describe the PowerPoint environment; use the PowerPoint Help feature; open, create, and save a new presentation; add new slides and insert text; rearrange and delete slides; insert slides from other presentations; apply formatting to text and bulleted lists; utilize the Mini toolbar; describe the find, replace, cut, copy & paste commands; change the alignment of text; use tools to draw objects; modify objects using groups on the Drawing Tools Format tab; add text to drawn objects and text boxes; use WordArt to create text objects; add and modify slide images; insert and modify Clip Art images; add tables to presentations; enter and format text in tables; create and modify charts and objects; modify a presentation using a template; use the Master Slide to make global changes; add visual appeal to slides with transition and timing; add speaker notes to a presentation; set up and prepare a slide show; use spell check and auto correct to proof a presentation; customize and preview a presentation; utilize the print dialog box for printing options. Course 2: Add, remove, and rearrange buttons on the Quick Access toolbar; create and apply a custom design theme; apply a custom template; modify presentations; modify images; add sound and movie clips; apply animation effects; create a photo album; format SmartArt graphics; make changes to objects; create and format a custom table; add interactive elements to a slide; add and modify actions buttons; create a custom slide show; review a presentation using comments; share a presentation; publish a presentation; create a presentation using a Word document; add content to slides by embedding or linking from Word or Excel; create a hyperlink to a Word document or Excel spreadsheet.
Instruction: Course 1: Basic components of the 2007 PowerPoint environment; details on how to open, create, and save a new presentation; inserting slides from other presentations; applying formatting to text and bulleted lists; utilizing the Mini toolbar; text alignment; using tools to draw objects; modifying objects using groups on the Drawing Tools Format tab; using WordArt to create text objects; adding and modifying slide images; adding tables to presentations; entering and formatting text in tables; creating and modifying charts and objects; using templates; using the Master Slide to make global changes; adding visual appeal to slides with transition and timing; adding speaker notes to a presentation; preparing a slide show. Course 2: Adding, removing, and rearranging buttons on the Quick Access toolbar; creating and applying custom design themes; applying a custom template; modifying presentations and images; adding sound, movie clips, and animation effects; creating photo albums; formatting SmartArt graphics; making changes to objects; creating and formatting custom tables; adding interactive elements to a slide; adding and modifying actions buttons; creating custom slide shows, reviewing presentations, using comments; sharing and publishing presentations; creating presentations using a Word document; adding content to slides by embedding or linking from Word or Excel; creating hyperlinks to Word documents and/or Excel spreadsheets.
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.

1. Microsoft Word 2007 Basic (261)
2. Microsoft Word 2007 Intermediate (262)
3. Microsoft Word 2007 Advanced (263)
Location: Various approved locations throughout the United States.
Length: Course 1: 20 hours (2.5 weeks); Course 2: 20 hours (2.5 weeks); Course 3: 20 hours (2.5 weeks).
Dates: 1, 2, or 3: December 2009 - Present.
Objectives: Course 1: Explain and utilize the elements of the Word window; create and save documents in Word; describe how to use AutoRecover; work with new folders; access and use the Word help feature; navigate within a Word document using the scrollbars and the keyboard; switch document views; insert and delete text; insert date, time, symbols, and special characters; describe the Undo and Redo commands; demonstrate how to cut, copy, and paste text; apply character formatting to change the appearance of text; use tabs to align text; format paragraphs; align text, add borders, apply bullets and numbering; utilize AutoFormat; create a table and convert text to tables and tables to text; apply formatting in a table; add and delete table rows and columns; align tables and adjust column width; create headers and footers and insert page numbers; set and change the margins of a Word document; work with page breaks; proof a Word document; use the Word thesaurus; utilize AutoCorrect; use the Find and Replace Dialog box; preview Word documents; print Word documents; insert graphics and clip art in a Word document; crop, rotate and resize graphics; adjust graphic contrast and brightness. Course 2: Explain text formatting; utilize the Revel Formatting task pane; modify, override, and export styles; format a document outline; view documents using the Document Map and thumbnails; create and format sections of text; insert section breaks, headers and footers, and page numbers; format text into multiple columns; align text in a table; merge and split table cells; change text orientation and resize rows; change table borders and apply shading to cells; sort data in a table, split a table, and enter a formula in a table; repeat a header row on multiple pages; apply and modify table styles; prepare and print labels and envelops; create a document from a template; save a template and store a custom template; utilize the Building Block Organizer; use the Restrict Formatting and Editing pane; create and modify a graphic; insert text boxes; insert and modify shapes; format text using WordArt, drop caps and pull quotes; track changes while editing; review and accept revisions; view changes by different reviewers; merge revisions and insert, print, and delete comments; preview and save a document as a Web page; open an HTML document in a browser; edit an HTML document in Word; insert a hyperlink in a document; navigate using hyperlinks. Course 3: Create form letters using the mailing tab; create a recipient list; sort and filter records; use a recipient list to create mailing labels and envelopes; insert and modify new objects; apply background colors, fill effects, watermarks, and themes; protect document formatting; create forms by adding labels and content controls; protect forms; utilize the Compatibility Checker and Document Inspector; use digital signatures to share and secure documents; record and run macros to automate tasks; modify, copy, and delete macros; customize the Quick Access toolbar Customize keyboard shortcuts; create a master document; add cover pages; create, modify, and update a table of contents; create indexes, bibliographies, table of authorities, and footnotes; describe bookmarks and cross-references; add frames to Web page documents; create an XML document; attach an XML schema; use XML options and create a transform.
Instruction: Course 1: Basic word processing knowledge and skills; how to create and save new documents in Word; formatting documents in Word; utilizing the elements of the Word window; accessing and using the Word help feature; navigating within a Word document using the scrollbars and the keyboard; switching document views; inserting and deleting text; applying character formatting to change the appearance of text; creating headers and footers and inserting page numbers. Course 2: Word text formatting; modifying, overriding, and exporting styles Formatting a document outline; inserting section breaks, headers and footers, and page numbers; formatting text into multiple columns; creating a document from a template; saving and storing custom templates; utilizing the Building Block Organizer; using the Restrict Formatting and Editing pane features; creating and modifying graphics; tracking changes while editing; previewing and saving documents as Web pages; editing HTML documents in Word; navigating using hyperlinks.Course 3: Creating form letters using the mailing tab; using a recipient list to create mailing labels and envelopes; inserting and modifying new objects; applying background colors, fill effects, watermarks, and themes; protecting document formatting; creating forms by adding labels and content controls; using digital signatures to share and secure documents; recording and running macros to automate tasks; creating master documents; creating indexes, bibliographies, table of authorities, and footnotes; bookmarks and cross-references; adding frames to Web page documents; creating an XML document and attaching an XML schema; using XML options and creating transforms.
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 1/11/10

Return to all CCR Online  listings