PrintPrint FirstPreviousNextLast
Computer Technology - Microsoft Office Specialist Certificate
Code
C080 
Title Microsoft Office Specialist Certificate 
Department Computer Technology 

Program Requirements:

MICROSOFT OFFICE SPECIALIST CERTIFICATE

COMP 1109  Introduction to Operating Systems (3 cr)
COMP 1131  Microsoft Word Comprehensive (4 cr)
COMP 1132  Microsoft Access Comprehensive (4 cr)
COMP 1133  Microsoft PowerPoint Comprehensive (3 cr)
COMP 1134  Microsoft Outlook Comprehensive  (1 cr)
COMP 1135  Microsoft Excel Comprehensive (4 cr)

GRADUATION REQUIREMENT - 19 CREDITS

Click here to download Microsoft Office Specialist Certificate Program Planning Form (PDF)

Gainful Employment Information

Career Description: This program is designed to teach students to become proficient and expert users in the Microsoft Office Suite of application programs including Word, Access, Excel, PowerPoint and Outlook. The skills learned are designed to help office managers, technicians, administrative support personnel, and organization users of the Microsoft Office Suite become application specialists using the above software packages. Students will learn desktop application operating skills to meet globally recognized standards. Students will learn advanced skills using Word, Access, Excel, PowerPoint and Outlook. A synopsis of skills learned in this program include the following: Word 2010 - Creating, Formatting, and Editing Word Documents; Research Papers with Citations and References; Business Letters with a Letterhead and Tables; Documents with a Title Page, Table, and Watermark; Using Templates to Create a Resume and Sharing the Finished Documents; Generating Form Letters, Mailing Labels, and a Directory for a Cover Letter; Creating a Newsletter with a Pull-Quote and Graphics; Using Document Collaboration and Integration Tools; Creating a Master Document with a Table of Contents and an Index; Creating a Template for an Online Form; Enhancing an Online Form and Working with Macros, Document Security, and XML; Using Project Planning Guidelines; Publishing Office 2010 Web Pages Online; Saving to the Web Using Windows Live SkyDrive; and Creating APA Research Papers. Access 2010 - Creating Databases and Database Objects - An Introduction to table structure; Querying a Database; Maintaining a Database; Creating Reports and Forms; Creating Multiple Table Forms; Advanced Report Techniques; Using SQL; Advanced Form Techniques; Macros, Navigation Forms, PivotTables, and PivotCharts; Administering a Database System; and Database Design. PowerPoint 2010 - Create and Edit a Basic Presentation; Enhance a Presentation with Pictures and Shapes; Reuse a Presentation and Add Multimedia; Work with Information Graphics; Deliver and Collaborate on Presentations; Add Emphasis with Text Boxes; Create a Self-Running Presentation Containing Animation; Enhance Presentations with Hyperlinks and Action Buttons; Develop a Presentation from an Outline; Create a Photo Album Presentation with Shapes; Customize a Template and Handouts Using Masters; Use Project Planning Guidelines; Publishing Office 2010 Web Pages Online; and Save to the Web Using Windows Live SkyDrive. Outlook 2010 - Student will format message content by using character and paragraph formatting, use graphic elements such as charts and tables, and create contact records, tasks, and appointments from incoming messages. Students will create contact groups, schedule meetings, and share schedules to facilitate communication with other Outlook users. Excel 2010 - Create charts, create analytical, financial, etc. reports, optimize data entry, create a family budget, format numerical (financial, statistical, etc.) reports, create forms, create graphing, process data using what-if analyses, design reports, provide technical support, and creating trending data. Students will learn expert-level Microsoft Office Excel 2010 skills to efficiently and confidently use Excel 2010 software at the feature and functionality levels. Students will learn to be proficient with advanced formulas, functions, and data analysis tools. Students will also learn to manipulate data for analysis, presentation, and collaboration. In addition, will learn to manipulate Excel options to customize their environment to meet varying needs and enhance their productivity.

Program Information: This program is designed to teach students to become proficient and expert users in the Microsoft Office Suite of application programs including Word, Access, Excel, PowerPoint and Outlook. The skills learned are designed to help office managers, technicians, administrative support personnel, and organization users of the Microsoft Office Suite become application specialists using the above software packages. Students will learn desktop application operating skills to meet globally recognized standards. Students will learn advanced skills using Word, Access, Excel, PowerPoint and Outlook. A synopsis of skills learned in this program include the following: Word 2010 - Creating, Formatting, and Editing Word Documents; Research Papers with Citations and References; Business Letters with a Letterhead and Tables; Documents with a Title Page, Table, and Watermark; Using Templates to Create a Resume and Sharing the Finished Documents; Generating Form Letters, Mailing Labels, and a Directory for a Cover Letter; Creating a Newsletter with a Pull-Quote and Graphics; Using Document Collaboration and Integration Tools; Creating a Master Document with a Table of Contents and an Index; Creating a Template for an Online Form; Enhancing an Online Form and Working with Macros, Document Security, and XML; Using Project Planning Guidelines; Publishing Office 2010 Web Pages Online; Saving to the Web Using Windows Live SkyDrive; and Creating APA Research Papers. Access 2010 - Creating Databases and Database Objects - An Introduction to table structure; Querying a Database; Maintaining a Database; Creating Reports and Forms; Creating Multiple Table Forms; Advanced Report Techniques; Using SQL; Advanced Form Techniques; Macros, Navigation Forms, PivotTables, and PivotCharts; Administering a Database System; and Database Design. PowerPoint 2010 - Create and Edit a Basic Presentation; Enhance a Presentation with Pictures and Shapes; Reuse a Presentation and Add Multimedia; Work with Information Graphics; Deliver and Collaborate on Presentations; Add Emphasis with Text Boxes; Create a Self-Running Presentation Containing Animation; Enhance Presentations with Hyperlinks and Action Buttons; Develop a Presentation from an Outline; Create a Photo Album Presentation with Shapes; Customize a Template and Handouts Using Masters; Use Project Planning Guidelines; Publishing Office 2010 Web Pages Online; and Save to the Web Using Windows Live SkyDrive. Outlook 2010 - Student will format message content by using character and paragraph formatting, use graphic elements such as charts and tables, and create contact records, tasks, and appointments from incoming messages. Students will create contact groups, schedule meetings, and share schedules to facilitate communication with other Outlook users. Excel 2010 - Create charts, create analytical, financial, etc. reports, optimize data entry, create a family budget, format numerical (financial, statistical, etc.) reports, create forms, create graphing, process data using what-if analyses, design reports, provide technical support, and creating trending data. Students will learn expert-level Microsoft Office Excel 2010 skills to efficiently and confidently use Excel 2010 software at the feature and functionality levels. Students will learn to be proficient with advanced formulas, functions, and data analysis tools. Students will also learn to manipulate data for analysis, presentation, and collaboration. In addition, will learn to manipulate Excel options to customize their environment to meet varying needs and enhance their productivity.

Program Outcomes:
Graduates will be able to:

  • Use the Microsoft Word 2010 software application to effectively create documents, newsletters, research papers, and create mail merge functions;
  • Use the Microsoft Access 2010 software application to effectively create databases, database objects, reports, queries, forms, and macros;
  • Use the Microsoft PowerPoint 2010 software application to effectively create advanced graphic presentations and handouts;
  • Use the Microsoft Office 2010 software application to effectively create and format message content by using character and paragraph formatting, use graphic elements such as charts and tables, and create contact records, tasks, create appointments from incoming messages, create contact groups, schedule meetings, and share schedules to facilitate communication with other Outlook users;
  • Use the Microsoft Excel 2010 software application to effectively create advanced spreadsheets, charts, graphs, and analyses using multiple advanced formulas and functions.

Special Program Requirements: Students entering this program must also take the prerequisite course COMP1109 – Introduction to Operating Systems.

Certification: MOS – Microsoft Office Specialist