EXAM OUTLINES




  Microsoft® WORD 2013

CORE Exam (77-418)

Exam Objectives as stated by Microsoft
Pass rate 70%: 20 tasks in 50 minutes

Skill Sets

Exam Skill Standards

Create a Document

            Creating New Blank Documents

            Creating New Documents Using Templates

            Opening Non-Native Files Directly In Word

            Opening A PDF In Word For Editing

Navigate through a Document

            Searching For Text Within Document

            Inserting Hyperlinks

            Creating Bookmarks

            Using Go To

Format a Document

            Modifying Page Setup

            Changing Document Themes

            Changing Document Style Sets

            Inserting Simple Headers And Footers

            Inserting Watermarks

            Inserting Page Numbers

Customize Options and Views for Documents

            Changing Document Views

            Using Zoom

            Customizing The Quick Access Toolbar

            Customizing The Ribbon

            Splitting The Window

            Adding Values To Document Properties

            Using Show/Hide

            Recording Simple Macros

            Assigning Shortcut Keys

            Managing Macro Security

Configure Documents to Print or Save

            Configuring Documents To Print

            Saving Documents In Alternate File Formats

            Printing Document Sections

            Saving Files To Remote Locations

            Protecting Documents With Passwords

            Setting Print Scaling

            Maintaining Backward Compatibility 

Insert Text and Paragraphs

            Adding Text To Documents

            Finding And Replacing Text

            Copying And Pasting Text

            Inserting Text Via Autocorrect

            Removing Blank Paragraphs

            Inserting Built-In Fields

            Inserting Special Characters (©,  ™, £)

Format Text and Paragraphs  changing font attributes

            Using Find And Replace To Format Text

            Using Format Painter

            Setting Paragraph Spacing

            Setting Line Spacing

            Clearing Existing Formatting

            Setting Indentation

            Highlighting Text Selections

            Adding Styles To Text

            Changing Text To Wordart

            Modifying Existing Style Attributes

Order and Group Text and Paragraphs

            Preventing Paragraph Orphans

            Inserting Breaks To Create Sections

            Using Multiple Columns To Organize Content

            Using Headings To Organize Content (Outline)

            Forcing Page Breaks

Create a Table

            Converting Text To Tables

            Converting Tables To Text

            Defining Table Dimensions

            Setting Autofit Options

            Using Quick Tables

            Using Headings For Table Rows And Columns

Modify a Table

            Applying Styles To Tables

            Modifying Fonts Within Tables

            Sorting Table Data

            Configuring Cell Margins

            Using Formulas

            Modifying Table Dimensions

            Merging Cells

Create and Modify a List

            Adding Numbering Or Bullets

            Creating Custom Bullets

            Modifying List Indentation

            Modifying Line Spacing

            Increasing And Decreasing List Levels

            Modifying Numbering

Apply References

            Create Endnotes

            Footnotes

            And Citations  Inserting Endnotes

            Managing Footnote Locations

            Configuring Endnote Formats

            Modifying Footnote Numbering

            Inserting Citation Placeholders

            Inserting Citations

            Inserting Bibliography

            Changing Citation Styles

Create Captions

            Adding Captions

            Setting Caption Positions

            Changing Caption Formats

            Changing Caption Labels

            Excluding Labels From Captions 

Insert And Format Building Blocks

            Inserting Quick Parts

            Inserting Textboxes

            Utilizing Building Blocks Organizer

            Customizing Building Blocks

Insert and Format Shapes and SmartArt

            Inserting Simple Shapes

            Inserting Smartart

            Modifying Smartart Properties (Color, Size & Shape)

            Wrapping Text Around Shapes

            Positioning Shapes

Insert and Format Images

            Inserting Images

            Applying Artistic Effects

            Applying Picture Effects

            Modifying Image Properties (Color, Size & Shape)

            Adding Quick Styles To Images

            Wrapping Text Around Images

            Positioning Images




  Microsoft® WORD 2013

EXPERT Exam PART 1 (77-425)

Exam Objectives as stated by Microsoft

Pass rate 70%: 27 tasks in 50 minutes

Skill Sets

Exam Skill Standards

Prepare Documents For Review

            Setting Tracking Options

            Limiting Authors

            Restricting Editing

            Deleting Document Draft Version

            Removing Document Metadata

            Marking As Final

            Protecting A Document With A Password

Apply Advanced Formatting

            Using Wildcards In Find And Replace Searches

            Creating Custom Field Formats

            Setting Advanced Layout Options

            Setting Character Space Options

            Setting Advanced Character Attributes

            Creating And Breaking Section Links

            Linking Textboxes 

Apply Advanced Styles

            Creating Custom Styles

            Customizing Settings For Existing Styles

            Creating Character-Specific Styles

            Assigning Keyboard Shortcuts To Styles

Manage Forms, Fields, And Mail Merge Operations

            Adding Custom Fields

            Modifying Field Properties

            Adding Controls

            Modifying Control Properties

            Performing Mail Merges

            Managing Recipient Lists

            Inserting Merged Fields

            Previewing Results

Create And Modify Building Blocks

            Creating Custom Building Blocks

            Saving Selections As Quick Parts

            Editing Building Block Properties

            Deleting Building Blocks

Create Custom Style Sets And Templates

            Creating Custom Color Themes

            Creating Custom Font Themes

            Creating Custom Templates

            Creating And Managing Style Sets



  Microsoft® WORD 2013

EXPERT Exam PART 2 (77-426)
Exam Objectives as stated by Microsoft
Pass rate 70%: 27 tasks in 50 minutes

Skill Sets

Exam Skill Standards

Manage Multiple Documents

            Modifying Existing Templates

            Merging Multiple Documents

            Managing Versions Of Documents

            Copying Styles From Template To Template

            Using The Style Organizer

            Copying Macros From Document To Document

            Linking To External Data

            Moving Building Blocks Between Documents

Manage Document Changes

            Tracking Changes

            Managing Comments

            Using Markup Options

            Resolving A Multi-Document Style Conflicts

            Displaying All Changes

Apply Advanced Ordering And Grouping

            Creating Outlines

            Promoting Sections In Outlines

            Creating Master Documents

            Inserting Subdocuments

            Linking Document Elements

Create And Manage Indexes

            Creating Indexes

            Updating Indexes

            Marking Index Entries

            Using Index Auto-Mark Files

Create And Manage Reference Tables

            Creating A Table Of Contents

            Creating A Table Of Figures

            A Formatting Table Of Contents

            Updating A Table Of Authorities

            Setting Advanced Reference Options (Captions, Footnotes, Citations)

Prepare A Document For Internationalization And Accessibility

            Configuring Language Options In Documents

            Adding Alt-Text To Document Elements

            Creating Documents For Use With Accessibility Tools

            Managing Multiple Options For +Body And +Heading Fonts

            Utilizing Global Content Standards

            Modifying Tab Order In Document Elements And Objects



  Microsoft® EXCEL 2013

CORE Exam (77-420)
Exam Objectives as stated by Microsoft
Pass rate 70%: 18 tasks in 50 minutes

Skill Sets

Exam Skill Standards

Create Worksheets And Workbooks 

            Creating New Blank Workbooks

            Creating New Workbooks Using Templates

            Importing Files

            Opening Non-Native Files Directly In Excel

            Adding Worksheets To Existing Workbooks

            Copying And Moving Worksheets

Navigate Through Worksheets And Workbooks

            Searching For Data Within A Workbook

            Inserting Hyperlinks

            Changing Worksheet Order

            Using Go To

            Using Name Box

Format Worksheets And Workbooks

            Changing Worksheet Tab Color

            Modifying Page Setup

            Inserting And Deleting Columns And Rows

            Changing Workbook Themes

            Adjusting Row Height And Column Width

            Inserting Watermarks

            Inserting Headers And Footers

            Setting Data Validation

Customize Options And Views For Worksheets And Workbooks

            Hiding Worksheets

            Hiding Columns And Rows

            Customizing The Quick Access Toolbar

            Customizing The Ribbon

            Managing Macro Security

            Changing Workbook Views

            Recording Simple Macros

            Adding Values To Workbook Properties

            Using Zoom

            Displaying Formulas

            Freezing Panes

            Assigning Shortcut Keys

            Splitting The Window

Configure Worksheets And Workbooks To Print Or Save 

            Setting A Print Area

            Saving Workbooks In Alternate File Formats

            Printing Individual Worksheets

            Setting Print Scaling

            Repeating Headers And Footers

            Maintaining Backward Compatibility

            Configuring Workbooks To Print

            Saving Files To Remote Locations 

Insert Data In Cells And Ranges

            Appending Data To Worksheets

            Finding And Replacing Data

            Copying And Pasting Data

            Using Autofill Tool

            Expanding Data Across Columns

            Inserting And Deleting Cells

Format Cells And Ranges

            Merging Cells

            Modifying Cell Alignment And Indentation

            Changing Font And Font Styles

            Using Format Painter

            Wrapping Text Within Cells

            Applying Number Formats

            Applying Highlighting and Cell Styles

            Changing Text To Wordart

Order And Group Cells And Ranges

            Applying Conditional Formatting

            Inserting Sparklines

            Transposing Columns And Rows

            Creating Named Ranges

            Creating Outlines

            Collapsing Groups Of Data In Outlines

            Inserting Subtotals

Create A Table

            Moving Between Tables And Ranges

            Adding And Removing Cells Within Tables

            Defining Titles

Modify A Table

            Applying Styles To Tables

            Banding Rows And Columns

            Inserting Total Rows

            Removing Styles From Tables

Filter And Sort A Table

            Filtering Records

            Sorting Data On Multiple Columns

            Changing Sort Order

            Removing Duplicates 

Utilize Cell Ranges And References In Formulas And Functions

            Utilizing References (Relative, Mixed, Absolute)

            Defining Order Of Operations

            Referencing Cell Ranges In Formulas

Summarize Data With Functions

            Utilizing The SUM Function

            Utilizing The MIN And MAX Functions

            Utilizing The COUNT Function

            Utilizing The AVERAGE Function

Utilize Conditional Logic In Functions

            Utilizing The SUMIF Function

            Utilizing The AVERAGEIF Function

            Utilizing The COUNTIF Function

Format And Modify Text With Functions

            Utilizing The RIGHT

            LEFT And MID Functions

            Utilizing The TRIM Function

            Utilizing The UPPER And LOWER Functions

            Utilizing The CONCATENATE Function 

            Create Charts And Objects 

Create A Chart

            Creating Charts And Graphs

            Adding Additional Data Series

            Switching Between Rows And Columns In Source Data

            Using Quick Analysis



  Microsoft® EXCEL 2013

EXPERT Exam Part 1 (77-427)

Exam Objectives as stated by Microsoft

Pass rate 70%: 29 tasks in 50 minutes

Skill Sets

Exam Skill Standards

Manage Workbook Changes

            Tracking Changes Managing Comments

            Identifying Errors

            Troubleshooting With Tracing

            Displaying All Changes

            Retaining All Changes 

Apply Advanced Conditional Formatting & Filtering

            Writing Custom Conditional Formats

            Using Functions To Format Cells

            Creating Advanced Filters

            Apply Advanced Conditional Formatting And Managing Conditional Formatting Rules

Prepare A Workbook For Internationalization And Accessibility

            Modifying Tab Order Among Workbook Elements And Objects

            Displaying Data In Multiple International Formats

            Modifying Worksheets For Use With Accessibility Tools

            Utilizing International Symbols

            Managing Multiple Options For +Body And +Heading Fonts 

Look Up Data With Functions 

            Utilizing The Lookup Function

            Utilizing The Vlookup Function

            Utilizing The Hlookup Function

            Utilizing The Transpose Function

Apply Advanced Date And Time Functions 

            Utilizing The NOW And TODAY Functions

            Using Functions To Serialize Dates And Times 

Create Advanced Chart Elements 

            Adding Trendlines To Charts

            Creating Dual Axis Charts

            Creating Custom Chart Templates

            Viewing Chart Animations

Create And Manage PivotTables 

            Creating New PivotTables

            Modifying Field Selections And Options

            Creating A Slicer

            Grouping Records

            Utilizing Calculated Fields

            Formatting Data

            Utilizing Powerpivot

            Managing Relationships 



  Microsoft® EXCEL 2013

EXPERT Exam Part 2 (77-428)
Exam Objectives as stated by Microsoft
Pass rate 70%: 29 tasks in 50 minutes

Skill Sets

Exam Skill Standards

Manage Multiple Workbooks 

            Modifying Existing Templates

            Merging Multiple Workbooks

            Managing Versions Of A Workbook

            Copying Styles From Template To Template

            Copying Macros From Workbook To Workbook

            Linking To External Data

Prepare A Workbook For Review 

            Setting Tracking Options

            Limiting Editors

            Opening Workspaces

            Restricting Editing

            Controlling Recalculation

            Protecting Worksheet Structure

            Marking As Final

            Removing Workbook Metadata

            Encrypting Workbooks With A Password

Apply Custom Data Formats 

            Creating Custom Formats (Number, Time, Date)

            Creating Custom Accounting Formats

            Using Advanced Fill Series Options

Apply Custom Styles And Templates 

            Creating Custom Color Formats

            Creating And Modifying Cell Styles

            Creating And Modifying Custom Templates

            Creating Form Fields

Apply Functions In Formulas 

            Utilizing The IF Function In Conjunction With Other Functions

            Utilizing AND/OR Functions

            Utilizing Nested Functions

            Utilizing SumIFs

            AverageIFs

            And CountIFs Functions

Create Scenarios  

            Utilizing The Watch Window

            Consolidating Data

            Enabling Iterative Calculations

            Utilizing What If Analysis Tools Including Goal Seek

            Utilizing The Scenario Manager

            Using Financial Functions

Create And Manage Pivot Charts 

            Creating New PivotCharts

            Manipulating Options In Existing PivotCharts

            Applying Styles To PivotCharts



  Microsoft® OUTLOOK 2013

Core Exam (77-423)

Exam Objectives as stated by Microsoft

Pass rate 70%: 38 tasks in 50 minutes

Skill Sets

Exam Skill Standards

Customize Outlook Settings

            Including Original Messages With All Reply Messages

            Changing Text Formats For All Outgoing Messages

            Customizing The Navigation Pane

            Blocking Specific Addresses

            Configuring Views

            Managing Multiple Accounts

            Setting Outlook Options

Automate Outlook

            Changing Quoted Text Colors

            Creating And Assigning Signatures

            Using Quick Steps

            Creating And Managing Rules

            Creating Auto-Replies

Print And Save Information In Outlook

            Printing Messages

            Printing Calendars

            Saving Message Attachments

            Previewing Attachments

            Printing Contacts

            Printing Tasks

            Saving Messages In Alternate Formats

            Creating Data Files

Search In Outlook

            Creating New Search Folders

            Searching For Messages

            Searching For Tasks

            Searching For Contacts

            Searching Calendars

            Using Advanced Find

            Using Search By Location 

Create A Message

            Creating Messages

            Forwarding Messages

            Deleting Messages

            Adding/Removing Message Attachments

            Adding Cc And Bcc To Messages

            Adding Voting Options To Messages

            Replying To All

            Replying To Sender Only

            Prioritizing Messages

            Marking As Private

            Requesting Delivery/Read Receipt

            Redirecting Replies

            Delegating Access

Format A Message

            Formatting Text

            Inserting Hyperlinks

            Applying Themes And Styles

            Inserting Images

            Adding A Signature To Specific Messages

            Formatting Signatures

            Creating And Using Quick Parts

Organize And Manage Messages

            Sorting Messages

            Moving Messages Between Folders

            Adding New Local Folders

            Applying Categories

            Configuring Junk E-Mail Settings

            Cleaning Up Messages

            Marking As Read/Unread

            Flagging Messages

            Ignoring Messages

            Sorting By Conversation

            Setting Attachment Reminder Options 

Create And Manage Calendars

            Adjusting Viewing Details For Calendars

            Modifying Calendar Time Zones

            Deleting Calendars

            Setting Calendar Work Times

            Using Multiple Calendars

            Managing Calendar Groups

            Overlaying Calendars

            Sharing Calendars

Create Appointments, Meetings And Events

            Creating Calendar Items

            Creating Recurring Calendar Items

            Cancelling Calendar Items

            Creating Calendar Items From Messages

            Setting Calendar Item Times

            Categorizing Calendar Items

            Using The Scheduling Assistant

            Changing Availability Status

            Scheduling Resources

            Utilizing Room Finder

Organize And Manage Appointments, Meetings, And Events

            Setting Calendar Item Importance

            Forwarding Calendar Items

            Configuring Reminders

            Adding Participants

            Responding To Invitations

            Updating Calendar Items

            Sharing Meeting Notes

Create And Manage Notes,  Tasks, And Journals 

            Creating And Managing Tasks

            Creating And Managing Notes

            Attaching Notes To Contacts

            Creating Journal Entries

            Updating Task Status

Create And Manage Contacts

            Creating New Contacts

            Deleting Contacts

            Importing Contacts From External Sources

            Editing Contact Information

            Attaching An Image To Contacts

            Adding Tags To Contacts

            Sharing Contacts

            Managing Multiple Address Books

Create And Manage Groups

            Creating New Contact Groups

            Adding Contacts To Existing Groups

            Adding Notes To A Group

            Updating Contacts Within Groups

            Deleting Groups & Group Members




  Microsoft® POWERPOINT 2013

Core Exam (77422)

Exam Objectives as stated by Microsoft

Pass rate 70%: 41 tasks in 50 minutes

Skill Sets

Exam Skill Standards

Creating A Presentation

            Creating Blank Presentations

            Creating Presentations Using Templates

            Importing Text Files Into Presentations

            Importing Word Document Outlines Into Presentations

Format A Presentation Using Slide Masters

            Applying A Slide Master

            Adding New Layouts

            Modifying Existing Layouts

            Adding Background Images

            Controlling Slide Numbers

            Inserting Headers And Footers

            Modifying Presentation Themes

Customize Presentation Options And Views

            Changing Page Setup Options

            Changing To View In Color/Grayscale

            Using Views To Navigate Through Presentations

            Modifying Presentation Properties

Configure Presentations To Print Or Save

            Setting Handout Print Options

            Printing Selections From Presentations

            Packaging Presentations For CD

            Saving Presentations As XML

            Printing Presentations In Grayscale

            Printing Speaker Notes

            Maintaining Backward Compatibility

Configure And Present Slideshows

            Creating Custom Slideshows

            Configuring Slideshow Options

            Rehearsing Timing

            Configuring Resolution

            Using Presenter View

            Navigating Within Slideshows

            Annotating Slideshows

Insert And Format Slides

            Adding Slides Layouts

            Duplicating Existing Slides

            Hiding Slides

            Deleting Slides

            Modifying Slide Backgrounds

            Applying Styles To Slides

Insert And Format Shapes

            Modifying Shape Backgrounds

            Applying Borders To Shapes

            Resizing Shapes

            Inserting Shapes

            Creating Custom Shapes

            Applying Styles To Shapes

Order And Group Shapes And Slides

            Inserting Section Headers

            Modifying Slide Order

            Aligning And Grouping Shapes

            Displaying Gridlines

Insert And Format Text

            Changing Text To Wordart

            Creating Multiple Columns In A Single Shape

            Inserting Hyperlinks

            Applying Formatting And Styles To Text

            Creating Bulleted And Numbered Lists

Insert And Format Tables

            Creating New Tables

            Modifying Number Of Rows And Columns

            Applying Table Styles

            Importing Tables From External Sources

Insert And Format Charts

            Creating And Modifying Chart Styles

            Inserting Charts

            Modifying Chart Type

            Adding Legends To Charts

            Modifying Chart Parameters

            Importing Charts From External Sources

Insert And Format Smartart

            Adding Shapes To Smartart

            Changing Color Of Smartart

            Moving Text Within Smartart Shapes

            Reversing Direction

            Converting Lists To Smartart

Insert And Format Images

            Resizing Images

            Cropping Images

            Applying Effects

            Applying Styles

Insert And Format Media

            Adjusting Media Window Size

            Trimming Timing On Media Clips

            Setting Start/Stop Times

            Setting Media Options

            Linking To External Media

Apply Transitions Between Slides

            Inserting Transitions Between Slides

            Managing Multiple Transitions

            Modifying Transition Effect Options

Animate Slide Content

            Applying Animations To Shapes

            Applying Animations To Text Strings

            Adding Paths To Animations

            Modifying Animation Options

Set Timing For Transitions And Animations

            Modifying Duration Of Effects

            Configuring Start And Finish Options

            Reordering Animations

            Using The Animation Pane

Merge Content From Multiple Presentations

            Merging Multiple Presentations

            Reusing Slides From Other Presentations

            Viewing Multiple Presentations

Review Changes

            Using The Reviewing Pane

            Comparing Revisions

            Managing Changes

            Managing Comments

Protect And Share Presentations

            Encrypting Presentations With A Password

            Proofing Presentations

            Marking As Final

            Compressing Media

            Embedding Fonts

            Restricting Permissions

            Removing Presentation Metadata

            Checking For Accessibility Issues

            Checking For Compatibility Issues




  Microsoft® ACCESS 2013

Core Exam (77-424)
Exam Objectives as stated by Microsoft
Pass rate 70%: 34 tasks in 50 minutes

Skill Sets

Exam Skill Standards

Create A New Database

            Creating New Databases

            Creating Databases Using Templates

            Saving Databases In Older Formats

            Creating Databases Using Wizards

Manage Relationships And Keys

            Editing References Between Tables

            Creating And Modifying Relationships

            Setting Primary Key Fields

            Enforcing Referential Integrity

            Setting Foreign Keys

            Viewing Relationships

Navigate Through A Database

            Navigating To Specific Records

            Setting A Form As The Startup Option

            Using Navigation Forms

            Setting Navigation Options

            Changing Views

Protect And Maintain A Database

            Compacting Databases

            Repairing Databases

            Backing Up Databases

            Splitting Databases

            Encrypting Databases With A Password

            Merging Databases

            Recovering Data From A Backups

Print And Export A Database

            Printing Reports

            Printing Records

            Maintaining Backward Compatibility

            Saving Databases As Templates

            Saving Databases To External Locations

            Exporting To Alternate Formats

Create A Table

            Creating New Tables

            Importing External Data Into Tables

            Creating Linked Tables From External Sources

            Importing Tables From Others Database

            Creating Tables From Templates And Application Parts

Format A Table

            Hiding Fields In Tables

            Changing Data Formats

            Adding Total Rows

            Adding Table Descriptions

            Renaming Tables

Manage Records

            Updating Records

            Adding New Records

            Deleting Records

            Appending Records From External Data

            Finding And Replacing Data

            Sorting Records

            Filtering Records

            Grouping Records

Create And Modify Fields

            Adding Fields To Tables

            Adding A Validation Rules To Fields

            Changing Field Captions

            Changing Field Sizes

            Changing Field Data Types

            Configuring Fields To Auto-Increment

            Setting Default Values

            Using Input Masks

            Deleting Fields

Create A Query

            Running Queries

            Creating Crosstab Queries

            Creating Parameter Queries

            Creating Action Queries

            Creating Multi-Table Queries

            Saving Queries & Deleting Queries

Modify A Query

            Renaming Queries

            Adding New Fields

            Removing Fields

            Hiding Fields

            Sorting Data Within Queries

            Formatting Fields Within Queries

Utilize Calculated Fields And Grouping Within A Query

            Adding Calculated Fields

            Adding Conditional Logic

            Grouping And Summarizing Data

            Using Comparison Operators

            Using Basic Operators

Create a Form

            Creating New Forms

            Creating Forms With Application Parts

            Saving Forms

            Deleting Forms

Set Form Controls

            Moving Form Controls

            Adding Form Controls

            Modifying Data Sources

            Removing Form Controls

            Setting Form Control Properties

            Managing Labels

Format a Form

            Modifying Tab Order In Forms

            Formatting Print Layouts

            Sorting Records

            Applying Themes

            Changing Margins

            Inserting Backgrounds

            Auto-Ordering Forms

            Inserting Headers And Footers

            Inserting Images

            Modifying Existing Forms

Create a Report

            Creating New Reports

            Creating Reports With Application Parts

            Deleting Reports

Set Report Controls

            Grouping Data By Fields

            Sorting Data

            Adding Sub-Reports

            Modifying Data Sources

            Adding Report Controls

            Managing Labels

Format a Report

            Formatting Reports Into Multiple Columns

            Adding Calculated Fields

            Setting Margins

            Adding Backgrounds

            Changing Report Orientation

            Changing Sort Order

            Inserting Headers And Footers

            Inserting Images

            Inserting Page Numbers

            Applying Themes

            Modifying Exiting Reports




  Microsoft® OneNote 2013

Core Exam (77-421)
Exam Objectives as stated by Microsoft
Pass rate 70%: 34 tasks in 50 minutes

Skill Sets

Exam Skill Standards

Manage Page Layout

            Combine And Rearrange Containers

            Collapse And Expand Paragraphs And Lists

            Insert Background Images

            Work With Templates

            Set Page Layout Options

Configure Onenote Backstage

            Configure Notebook Settings And Properties

            Pin Notebooks To Lists

Create A Onenote Notebook

            Create New Notebooks

            Create Notebooks On Skydrive

            Create Notebooks On A Network

            Create Local Notebooks

Personalize Onenote

            Set Default Fonts And Sizes

            Change Display Settings

            Manage Proofing And Language Settings

            Set Research And Translation Options

            Set Page Format Options

            Customize Workspaces

            Customize The Ribbon

            Expand/Collapse Panels

Share Onenote Notebooks

            Share Notebooks On Skydrive

            Share Notebooks On Sharepoint

            Share Notebooks On A Network

            Synchronize Shared Notebooks Across Devices

Share Onenote Content Via Email

            Send Notebooks Via Email

            Configure Onenote Email Options

            Invite Others To View Notebooks

            Send Pages Via Email In Shareable Formats

            Send To A Blog

Collaborate With Other Users In Onenote

            Mark Coauthor Edits As Read

            View Recent Edits

            Find Notes By Author

            Hide Author Initials

            Mark Notes As Read Or Unread

Organize Notebooks

            Merge Sections

            Create New Section Groups

            Use Color To Group Notebooks And Sections

            Protect With Passwords

            Group And Display Sub-Pages

            Use Quick Notes

            Add New Pages

Search For Content In Onenote

            Search For Content Across Notebooks

            Sections

            And Pages; Display Search Results Panes

            Search Indexed Recordings

Save And Manage Onenote History And Backups

            Manage Page Versions

            Manage Notebook Recycle Bins

            Manage Backups

            Save Notebooks

            Save Current Pages

            Save Pages As Alternate File Types

            Convert For Backward Compatibility

Configure Quick Filing

            Send Email Messages

            Insert Notes From Outlook (Messages, Meetings, Contacts, And Tasks)

            Insert Webpages

            Insert Screenshots

            Print To Onenote

            Insert Media

            Set Default Locations

Create And Manage Tags

            Apply Tags

            Create New Tags

            Modify Existing Tags

            Create Tag Summary Pages

            Configure Tag Options

            Find Tags

Apply Links And Linked Notes

            Link Quick Notes To Pages

            Sections

            Notebooks

            And Wiki Links; Create New Docked Windows; Link Quick Notes To Web Browsers; Link Quick Notes To Office Applications; Copy Links

Insert Files In Onenote

            Insert Links To Files

            Embed Files

            Embed A Spreadsheet Or Visio Document

Edit Text In Onenote

            Use The Format Painter

            Use Styles

            Manage Paste Options

            Use Format Options

            Insert Tables

Insert And Modify Visual Elements

            Insert Images

            Insert Symbols

            Work With The Drawing Tools

            Manage The Pen Options



  Microsoft® SHAREPOINT 2013

Core Exam (77-419)

Exam Objectives as stated by Microsoft

Pass rate 70%: 34 tasks in 50 minutes

Skill Sets

Exam Skill Standards

Navigate The Sharepoint Hierarchy

            Use Quick Launch

            Use All Site Content

            Use Breadcrumb Trails

            Add Content To Quick Launch

            Use Content And Structure For Navigation

Manage Lists And Libraries

            Create Lists Or Libraries

            Edit Properties For New Items

            Enable Email Notifications On Lists Or Libraries

            Provide Shortcuts To A Mobile Site URL

            Manage Document Templates

            Manage List Views

            Create Alerts On Lists Or Libraries

            Use Ratings

            Add Columns

            Add Content Validation

            Manage Column Properties

Manage List Items

            Create New List Items

            Edit Content

            Delete List Items Or Documents

            Version List Items

            Publish Assets

            Manage Existing Workflows

            Upload Documents

            Create And Manage Announcements

            Collaborate With Microsoft Office Assets (Calendars , Spreadsheets ,Web Apps)

Manage Document Sets

            Add Documents To Document Sets

            Create Document Sets

            Activate And Deactivate Document Sets

Manage Pages

            Create New Site Pages

            Use Templates

            Edit And Delete Existing Site Pages

Perform Administrative Tasks On Sites And Workspaces

            Create New Sites Or Workspaces Using Templates

            Configure Site Or Workspace Structures

            Configure The Content Organizer

            Display A List Of All User Alerts

            Modify Look And Feel

            Recover Assets (Lists, Libraries, Documents, List Items)

            Use Document And Meeting Workspaces

            View Site Web Analytics

            View Detailed Reports

Manage Web Parts On A Page

            Add Web Parts

            Configure Web Parts

            Hide Or Remove Web Parts

            Export Or Import Web Parts

Manage Content Types

            Associate Content Types To Lists

            Extend The Columns Of Content Types

            Create Custom Content Types

Manage Users And Groups

            Create Groups

            Manage Groups

            Manage User Access

            Manage Group Permissions

Configure My Site

            Add Keywords

            Add Colleagues

            Select Themes

            Configure The Colleague Tracker Web Part

            Configure Rss Feeds

            Configure My Profile

Collaborate Through My Site

            Update Profile Status

            Share Pictures In My Site

            Manage Personal Documents

            Share Documents In My Site

            Browse The Organization Hierarchy

            Add Web Parts To My Site

Add Tags And Notes To Content

            Add Notes To The Note Board For Lists Or Libraries

            Add Tags For Lists Or Libraries

            Rate Items

            Use Tag Clouds

            Review Tags On My Site

Perform Search Administration At The Site Level

            Configure Searchable Columns

            Configure List Searches

            Configure Site Search Visibility

View Search Results

            Browse Search Results

            Use Best Bet Results

            Use The Refinement Panel

            Use Alerts And RSS Feeds With Search Results

            Preview Documents

Perform Advanced Searches

            Use Boolean Operators In Searches

            Use Wild Cards In Searches

            Use Property Searches

            Use Phonetic Searches

            Use People Search

            Use Advanced Searches





  .


Microsoft® ONENOTE 2010 Exam


Exam Objectives as stated by Microsoft


Skill Sets

 

Exam Skill Standards

 

Managing the OneNote Environment

*Manage Page Layout. 

combine containers, Collapse and expand paragraphs, Set an image as a background, Save current page as template

*Configure OneNote Notebook Backstage. 

Configure Notebook settings and properties, Pin recently opened notebook to list

*Create New OneNote Notebook. 

Create a new notebook on SkyDrive, Create a new notebook on a network, Create a new notebook on My Computer

*Personalize OneNote. 

Default font and size, Display settings, Proofing settings, Language settings, Research and translation options

*Personalize Page Setup. 

Page colour, Rule lines, Grid lines, Page title, Paper size, Full page view, Dock to desktop

Sharing and Collaborating

*Share OneNote Notebooks. 

Share notebook on: SkyDrive, SharePoint document library, Network drive

*Share OneNote Content via E-mail. 

E-mail others about the notebook and configure e-mail options, Invite others to view a notebook, E-mail page in shareable formats

*Collaborate in OneNote. 

Mark co-authors edits as read, View recent edits, Find notes by author, Hide author initials

Organizing and Finding Notes

*Use OneNote Notebook Organization Tools. 

Merge sections, Create new section group, Colour code notebooks and sections, Protect with password, Group and collapse sub-pages, Use Side Notes

*Search OneNote. 

Search for content across Notebooks, Sections or Pages, Display search results pane

*Use History and Backups in OneNote. 

Page versions, Notebook recycle bin, Open backup notebook

*Save Notebook As. 

Save current page, Save as alternate file types

*Use Quick Filing. 

Send to E-mail messages, Meetings notes, Contact notes, Tasks, Web pages, Screenshots, Print to OneNote

*Use and Manage Tags. 

Apply tags to paragraphs, Create new tags, Modify existing tags, Create Tag Summary page, Configure tag options, Find tags

Editing and Linking Content in OneNote

*Use Links and Linked Notes. 

Link to other OneNote pages; Link notes to Pages, Sections, Notebooks, Wikilinks; Create new Docked Window or Side Note; Link notes to other applications such as Microsoft Office Word 2010 documents, Microsoft Office PowerPoint 2010 presentations and Internet Explorer web pages

*Insert Files. 

Insert link to files, Embed file, File print (Print to OneNote)

*Edit Text in OneNote. 

Format painter, Styles, Paste options, Clear formatting, Tables, Research

*Insert and Modify Visual Elements. 

Images, Symbols, Drawing tools, Pen options



   

Microsoft® SHAREPOINT 2010 Exam


Exam Objectives as stated by Microsoft


Skill Sets

 

Exam Skill Standards

 

Creating and Formatting Content

*Navigate the SharePoint hierarchy.

*using Quick Launch, All Site Content, and breadcrumb trails, adding content to Quick Launch, and using content and structure for navigation

*Manage lists and libraries.

*creating lists or libraries, editing properties for new items, enabling email notifications on a library or list, providing a shortcut to a mobile site URL, managing document templates, managing list views, creating an alert on a list or library, enabling rating, adding a column, adding content validation, managing column properties for various column types, and managing workflows

*Manage list items.

*creating a new item, editing content, deleting a list item or a document, versioning items, publishing assets, managing workflows, and uploading documents

*Manage document sets.

*creating a document set and adding a document to a document set


Managing SharePoint Sites

*Manage pages.

*creating, editing, and deleting pages

*Administer a site.

*creating a new site, configuring the site structure, configuring the Content Organizer, displaying a list of all user alerts, modifying the Look and Feel of a site, and recovering a list, library, document or list item

*Manage Web Parts on a page.

*adding a Web Part, configuring a Web Part, hiding or removing a Web Part, and exporting or importing a Web Part

*Manage content types.

*associating a content type to a list and extending the columns of a content type

*Manage users and groups.

*managing user access, groups, and group permissions

*Create SharePoint workspace sites.

*using document and meeting workspaces

*Analyze site activity.

*viewing site web analytics and viewing detailed reports


Participating in User Communities

*Configure My Site.

*adding keywords, adding colleagues, selecting a theme, configuring the Colleague *Tracker Web Part, configuring RSS feeds, and configuring profiles

*Collaborate through My Site.

*updating profile status, sharing pictures in My Site, managing personal documents, sharing documents in My Site, browsing the organization hierarchy, and adding Web Parts to My Site

*Tag and note content.

*adding notes on the Note Board for a list or a library, adding tags for a list or a library, rating an item, using tag clouds, and reviewing tags on My Site


Configuring and Consuming Site Search Results

*Administer search at the site level.

*configuring searchable columns, configuring list search, and configuring site search visibility

Search SharePoint for content.

*performing search by using Windows Internet Explorer, Windows Explorer, Office Word 2010 Research Pane, or SharePoint Workspace 2010

*View search results.

*browsing search results, using best bet results, using the refinement panel, using alerts and RSS feeds, and viewing document previews

Perform advanced searches.

*using boolean operators in searches, using wild cards in searches, running property searches, and running phonetic searches

*Search for people.

*using People Search, refining people searches, and using advanced searches      


Integrating SharePoint 2010 Services and Microsoft Office 2010 applications

*Configure SharePoint 2010 Services.

*using Form Services, Excel Services, Access Services, and Visio Services

*Run Microsoft Office 2010 applications with SharePoint 2010 services.

*integrating with Microsoft Outlook, accessing content with SharePoint Workspace 2010, and integrating with Office Web applications

*Create dashboards.

*creating a dashboard page, adding and configuring the Key Performance Indicators (KPI) Web Part, KPI Details Web Part, Chart Web Part, Current User Filter Web Part, and Excel Web Access Web Part, displaying business data actions, and creating KPI lists




  .


Microsoft® WORD 2010 EXPERT Exam

 

Exam Objectives as stated by Microsoft


Skill Sets

 

Exam Skill Standards

 

Sharing and Maintaining Documents


*Configure Word options.

*changing default program, spelling, and grammar checking options

*Apply protection to a document.

*restricting editing and applying controls or restrictions to document access

*Apply a template to a document.

*modifying an existing template, creating a new template, applying a template to an existing document, and managing templates by using the Organizer


Formatting Content


*Apply advanced font and paragraph attributes.

*using character attributes and character-specific styles

*Create tables and charts.

*inserting tables by using Microsoft Excel data in tables, applying formulas or calculations on a table, modifying chart data, saving a chart as a template, and using the chart Layout tab

*Construct reusable content in a document.

*creating customized building blocks, saving a selection as a quick part, saving quick parts after a document is saved, inserting text as a quick part, and adding content to a header or footer

*Link sections.

*linking text boxes, breaking links between text boxes, and linking different sections


Tracking and Referencing Documents


*Review, compare, and combine documents.

*applying tracking, merging different versions of a document, tracking changes in a combined document, and reviewing comments in a combined document

*Create a reference page.

*adding citations, managing sources, compiling a bibliography, and applying cross references

*Create a Table of Authorities in a document.

*applying default formats, adjusting alignment, applying a tab leader, modifying styles, marking citations, and using passim (short form)

*Create an index in a document.

*specifying index type, columns, and language, modifying an index, and marking index entries


Performing Mail Merge Operations


*Execute Mail Merge.

*merging rules and sending personalized email messages to multiple recipients

*Create a Mail Merge by using other data sources.

*using Microsoft Outlook, Access, Excel, or Word tables as data source for a mail merge operation

*Create labels and forms.

*preparing data and creating mailing labels, envelope forms, and label forms


Managing Macros and Forms


*Apply and manipulate macros.

*recording a macro, running a macro, and applying macro security

*Apply and manipulate macro options.

*running macros when a document is opened, running macros when a button is clicked, assigning a macro to a command button, and creating a custom macro button on the Quick Access Toolbar

*Create forms.

*using the Controls group, adding Help content to form fields, linking a form to a database, and locking a form

*Manipulate forms.

*unlocking a form, adding fields to a form, and removing fields from a form



  .


Microsoft® EXCEL 2010 EXPERT Exam

 

Exam Objectives as stated by Microsoft


Skill Sets

 

Exam Skill Standards

 

Sharing and Maintaining Workbooks


*Apply workbook settings, properties, and data options.

*setting advanced properties, saving a workbook as a template, and importing and exporting XML data

*Apply protection and sharing properties to workbooks and worksheets.

*protecting the current sheet, protecting the workbook structure, restricting permissions, and requiring a password to open a workbook

*Maintain shared workbooks.

*merging workbooks and setting Track Changes options


Applying Formulas and Functions


*Audit formulas.

*tracing formula precedents, dependents, and errors, locating invalid data or formulas, and correcting errors in formulas

*Manipulate formula options.

*setting iterative calculation options and enabling or disabling automatic workbook calculation

*Perform data summary tasks.

*using an array formula and using a SUMIFS function

*Apply functions in formulas.

*finding and correcting errors in functions, applying arrays to functions, and using Statistical, Date and Time, Financial, Text, and Cube functions


Presenting Data Visually


*Apply advanced chart features.

*This objective may include but is not limited to: using Trend lines, Dual axes, chart templates, and Sparklines

*Apply data analysis.

*This objective may include but is not limited to: using automated analysis tools and performing What-If analysis

*Apply and manipulate PivotTables.

*manipulating PivotTable data and using the slicer to filter and segment your PivotTable data in multiple layers

*Apply and manipulate PivotCharts.

*This objective may include but is not limited to: creating, manipulating, and analyzing PivotChart data

*Demonstrate how to use the slicer.

*choosing data sets from external data connections


Working with Macros and Forms


*Create and manipulate macros.

*running a macro, running a macro when a workbook is opened, running a macro when a button is clicked, recording an action macro, assigning a macro to a command button, creating a custom macro button on the Quick Access *Toolbar, and applying modifications to a macro

*Insert and manipulate form controls.

*inserting form controls and setting form properties        


  .

Microsoft® WORD 2010 Core Exam

 

Exam Objectives as stated by Microsoft


Skill Sets

 

Exam Skill Standards

 

Working with Microsoft Word 2010


*Apply different views to a document

*Apply protection to a document

*Demonstrate how to use the Manage Versions tool in Backstage

*Demonstrate how to Share documents by using Backstage

*Apply saving by using the Save/Save As dialogs in Backstage

*Demonstrate knowledge of working with templates

Text and Paragraph Formatting


*Apply font attributes

*Demonstrate how to use Find features

*Apply indentation and tab settings to paragraphs

*Apply spacing settings to text and paragraphs

*Demonstrate how to insert tables

*Manipulate tables in a Microsoft Word 2010 document

*Demonstrate how to work with bullets in a *Microsoft Word 2010 document

Page Layout and Quick Parts


*Apply and manipulate page setup settings in a Microsoft Word 2010 document

*Apply themes to a Microsoft Word 2010 document

*Construct content in a Microsoft Word 2010 document by using the Quick Parts tool

*Create and manipulate page backgrounds in Microsoft Word 2010

*Demonstrate how to work with headers and footers

Illustrations and Graphics


*Demonstrate knowledge of working with Pictures in a Microsoft Word 2010 document

*Demonstrate knowledge of working with Shapes

*Demonstrate knowledge of working with Clip Art

*Apply and manipulate text boxes

Proofing


*Demonstrate the use of various spelling and grammar checking options in Word 2010

*Demonstrate how to modify AutoCorrect settings

*Demonstrate how to use comments in a Microsoft Word 2010 document

References and Hyperlinks


*Apply a hyperlink to text in a Microsoft Word 2010 document

*Create Endnotes and Footnotes in a Microsoft Word 2010 document

*Demonstrate knowledge of Table of Contents in a Microsoft Word 2010 document

Mail Merge

 

*Perform a mail merge operations

*Demonstrate how to Print and Print Preview a mail merge


  .

Microsoft® EXCEL 2010 Core Exam

 

Exam Objectives as stated by Microsoft


Skill Sets

 

Exam Skill Standards

 

Working with Excel 2010


*Identify specific cell content through navigation tools

*Construct cell data

*Apply AutoFill

*Demonstrate how to print

*Demonstrate how to use Backstage

*Apply and manipulate hyperlinks

Formatting Cells and Worksheets


*Apply and modify cell formats

*Apply merging to cells

*Create row and column titles

*Demonstrate how to hide and unhide rows and columns

*Manipulate Page Setup options for worksheets

*Demonstrate knowledge of working with cell and table styles

Worksheet and Workbook Management and Organization


*Demonstrate how to work with worksheets

*Manipulate window views

*Manipulate workbook views

Working with Formulas and Functions


* Create formulas

*Demonstrate understanding of the order of operations (precedence)

*Apply cell references in formulas

*Apply conditional logic in a formula (<,>,=)

*Apply named ranges in formulas

*Apply cell ranges in formulas

Present Data Visually


*Create charts based on worksheet data

*Apply and manipulate illustrations

*Perform tasks using the in-application image editor

*Apply Sparklines

Data Security and Collaboration


*Demonstrate how to use Backstage to share spreadsheets

*Demonstrate management of comments

Data Analysis and Organization


*Apply filtering to data

*Apply sorting to data

*Apply conditional formatting


  .

Microsoft® POWERPOINT 2010 Exam

 

Exam Objectives as stated by Microsoft


Skill Sets

 

Exam Skill Standards

 

Managing the PowerPoint Environment


 

 

*Adjust views. 

*adjusting views by using ribbon or status bar commands

*Manipulate the PowerPoint window.

*working with multiple presentation windows simultaneously

*Configure the Quick Access Toolbar.

*This objective may include but is not limited to: showing the Quick Access Toolbar (QAT) below the ribbon

*Configure PowerPoint file options.

*using PowerPoint, Proofing, and Save options

Creating a Slide Presentation


 

 

*Construct and edit photo albums.

*adding captions to pictures, inserting text, inserting images in black and white, reordering pictures in an album, and adjusting image rotation, brightness, and contrast

*Apply slide size and orientation settings.

*setting up a custom size and changing the orientation

*Add and remove slides.

*inserting an outline, reusing slides from a saved presentation, reusing slides from a slide library, duplicating selected slides, deleting multiple slides simultaneously, and including non-contiguous slides in a presentation

*Format slides.

*formatting sections, modifying themes, switching to a different slide layout, applying a fill color, gradient, picture, texture, or pattern to a slide, and setting up slide footers

*Enter and format text.

*using text effects, changing the indentation, alignment, line spacing, and direction of text, changing the formatting of bulleted and numbered lists, entering text in a placeholder text box, converting text to SmartArt, copying and pasting text, using Paste Special, and using Format Painter

*Format text boxes.

*applying a fill color, gradient, picture, texture, or pattern to a text box, changing the outline color, weight, or style, changing the shape of the text box, applying effects, setting the alignment, creating columns in a text box, setting internal margins, setting the current text box formatting as the default for new text boxes, adjusting text wrapping, sizing and positioning a text box, and using AutoFit

Working with Graphical and Multimedia Elements


*Manipulate graphical elements.

*arranging, positioning, and resizing graphical elements, applying effects, applying styles, applying borders, and adding hyperlinks

*Manipulate images.

*applying color adjustments, applying image corrections (sharpen, soften, brightness, contrast), adding artistic effects to an image, removing a background, cropping a picture, compressing selected pictures or all pictures, changing a picture, and resetting a picture

*Modify WordArt and shapes.

*setting the formatting of the current shape as the default for future shapes, changing the fill color or texture, changing the  WordArt, converting to SmartArt

*Manipulate SmartArt.

*adding and removing shapes, changing SmartArt styles, changing the SmartArt layout, reordering shapes, converting a SmartArt graphic to text, converting SmartArt to shapes, making shapes larger or smaller, and promoting or demoting bullet levels

*Edit video and audio content.

*applying a style to video or audio content, adjusting, arranging, and sizing video or audio content, and adjusting playback options

Creating Charts and Tables


*Construct and modify tables.

*drawing a table, inserting a Microsoft Excel spreadsheet, setting table style options, adding shading, borders, and effects, changing the alignment, resizing, merging or splitting columns and rows, distributing columns and rows, arranging columns and rows

*Insert and modify charts.

*selecting a chart type, entering chart data, changing the chart type, changing the chart layout, switching row and column, selecting data, editing data

*Apply chart elements.  

*using chart labels, axes, gridlines, and backgrounds

*Manipulate chart layouts.

*selecting chart elements and formatting selections

*Manipulate chart elements.

*arranging chart elements, specifying a precise position, applying effects, resizing chart elements, applying Quick Styles, applying a border, and adding hyperlinks

Applying Transitions and Animations


*Apply built-in and custom animations.

*using More Entrance, More Emphasis, and More Exit effects, and using More Motion paths

*Apply effect and path options.

*setting timing and start options

*Manipulate animations.

*changing the direction of an animation, attaching a sound to an animation, using Animation Painter, reordering animations, and selecting text options

*Apply and modify transitions between slides.

*modifying a transition effect, adding a sound to a transition, modifying transition duration, and setting up manual or automatically timed advance options

Collaborating on Presentations


*Manage comments in presentations.

*This objective may include but is not limited to: inserting and editing comments, showing or hiding markup, moving to the previous or next comment, and deleting comments

*Apply proofing tools.

*This objective may include but is not limited to: using Spelling and Thesaurus features, comparing and combining presentations

Preparing Presentations for Delivery


*Save presentations.

*saving the presentation as a picture presentation, PDF, XPS, outline, or OpenDocument presentation, saving a slide or object as a picture file, and saving a presentation as a show (.ppsx)

*Share presentations.

*packaging a presentation for CD delivery, creating video, creating handouts (send to Microsoft Word),  and compressing media

*Print presentations.

*This objective may include but is not limited to: adjusting print settings

*Protect presentations.

*setting a password, changing a password, and marking a presentation as final

Delivering Presentations


*Apply presentation tools.

*adding pen and highlighter annotations, changing the ink color, erasing an annotation, and discarding or retaining annotations upon closing

*Set up slide shows.

*setting up Slide Show, playing narrations, setting up Presenter view, using timings, showing media controls, broadcasting presentations, and creating a Custom Slide Show

*Set presentation timing.

*rehearsing and keeping timings, adjusting a slide's timing

*Record presentations.

*starting recording from the beginning of a slide show and starting recording from the current slide of the slide show


  .

Microsoft® OUTLOOK 2010 Exam

 

Exam Objectives as stated by Microsoft


Skill Sets

 

Exam Skill Standards

 

Managing the Outlook Environment


*Apply and manipulate Outlook program options.

setting General, Mail, Calendar, Tasks, Notes and Journal, Advanced, and Language options

*Manipulate item tags.

categorizing items, setting flags, setting sensitivity level, marking items as read or unread, and viewing message properties

*Arrange the Content Pane.

showing or hiding fields in a list view, changing the reading view, and using the Reminders Window and People Pane

*Apply search and filter tools.

using built-in Search folders

*Print an Outlook item.

printing attachments, calendars, multiple messages, multiple contact records, tasks, and multiple notes


Creating and Formatting Item Content

 

*Create and send email messages.

specifying a message theme, specifying plain text, rich text, or HTML message content format, showing or hiding the From and Bcc fields, setting a reminder for message recipients, specifying the sending account, specifying the sent item folder, configuring message delivery options, configuring voting and tracking options, and sending a message to a contact group

*Create and manage Quick Steps.

performing, creating, editing, deleting, and duplicating Quick Steps, resetting Quick Steps to default settings

*Create item content.

inserting graphical elements and inserting a hyperlink

*Format item content.

using formatting tools, applying styles, creating styles and themes, using Paste Special, and formatting graphical elements

*Attach content to email messages.

attaching an Outlook item and attaching external files


Managing Email Messages


*Clean up the mailbox.

viewing mailbox size, saving message attachments, saving a message in an external format, ignoring a conversation, and using clean-up tools

*Create and manage rules.

*creating, modifying, and deleting rules

*Manage junk mail.

allowing a specific message (Not junk), and filtering junk mail with Never Block Sender, Never Block Sender’s Domain, Never Block this Group or Mailing List, and Block Sender

*Manage automatic message content.

managing signatures, specifying the font for new HTML messages, plain-text messages, specifying options for replies and forwards, and setting a default theme for all HTML messages, stationery, and fonts


Managing Contacts


*Create and manipulate contacts.

modifying a default business card, forwarding a contact, and updating a contact in the address book

*Create and manipulate contact groups.

creating a contact group, managing contact group membership, showing notes about a contact group, forwarding a contact group, deleting a contact group, and sending a meeting to a contact group


Managing Calendar Objects


*Create and manipulate appointments and events.

setting appointment options, printing appointment details, forwarding an appointment, and scheduling a meeting with a message sender

*Create and manipulate meeting requests.

setting response options, updating a meeting request, canceling a meeting or invitation, and proposing a new time for a meeting

*Manipulate the Calendar pane.

arranging the calendar view, changing the calendar color, displaying or hiding calendars, and creating a calendar group


Working with Tasks, Notes, and Journal Entries


*Create and manipulate tasks.

creating a task, managing task details, sending a status report, marking a task as complete, moving or copying a task to another folder, assigning a task to another Outlook user, accepting or declining a task assignment, updating an assigned task, and using Current view

*Create and manipulate notes.

creating a note, changing the current view, and categorizing notes

*Create and manipulate Journal entries.

automatically record Outlook items, automatically record files, and editing a Journal entry



  .


Microsoft® ACCESS 2010 Exam

 

Exam Objectives as stated by Microsoft


Skill Sets

 

Exam Skill Standards

 

Managing the Access Environment


*Create and manage a database.

using Save Object As, Open, Save and Publish, Compact & Repair Database, and Encrypt with Password commands, creating a database from a template, and setting Access options

*Configure the Navigation Pane.

renaming objects, deleting objects, and setting Navigation options

*Apply Application Parts.

using Blank Forms, Quick Start, and user templates


Building Tables


*Create tables.

creating tables in Design View

*Create and modify fields.

inserting a field, deleting a field, renaming a field, Hide or Unhide fields, Freeze or Unfreeze fields, modifying data types, modifying the field description, and modifying field properties

*Sort and filter records.

using Find, Sort, and Filter commands

*Set relationships. defining Primary Keys, using Primary Keys to create Relationships, and editing Relationships

*Import data from a single data file.

importing source data into a new table, appending records to an existing table, and importing data as a linked table


Building Forms


*Create forms.

using the Form Wizard, creating a Blank Form, using Form Design Tools, and creating Navigation forms

*Apply Form Design Tab options.

Using the Themes, Controls, Header/Footer, and Tools groups

*Apply Form Arrange Tab options.

using the Table, Move, and Position groups

*Apply Form Format Tab options.

using the Background and Control Formatting groups


Creating and Managing Queries


*Construct queries.

using Select, Make Table, Append, and Crosstab query types

*Manage source tables and relationships.

using the Show Table and Remove Table commands, and creating ad hoc relationships

*Manipulate fields.

adding, removing, and rearranging fields, and using Sort and Show options

*Calculate totals.

using the Total row and using Group By

*Generate calculated fields.

performing calculations, using the Zoom box, and using Expression Builder


Designing Reports


*Create reports.

creating a Blank Report, using Report Design Tools, and using the Report Wizard

*Apply Report Design Tab options.

using the Themes, Grouping & Totals, Controls, Header/Footer, and Tools groups

*Apply Report Arrange Tab options.

using the Table, Move, Position, and Sizing & Ordering groups

*Apply Report Format Tab options.

adding color, background images, and conditional formatting

*Apply Report Page Setup Tab options. using the Page Size andPage Layout groups

*Sort and filter records for reporting.

using the Find, Sort, and Filter commands, and using view types





  .


Microsoft® WORD 2007 EXPERT Exam

 

Exam Objectives as stated by Microsoft


Skill Sets

 

Exam Skill Standards

 

Creating and Modifying

Advanced

Document Types

 

*Create a mail merge document.

creating a new recipient list, selecting recipients from Outlook contacts, and conditional mail merge

*Create and manage master documents.

converting a document to a master document, converting an outline to a master document, importing subdocuments, and managing subdocuments

*Create forms.

creating forms using fields, creating forms using content controls, and protecting forms


Customizing Word 2007


*Customize the Quick Access toolbar.

adding commands not in the ribbon, adding separators, and reorganizing commands

*Change default save options.

file formats and file locations

*Assign keyboard shortcuts.

assigning keyboard shortcuts to an existing macro, a style, a symbol, or autotext

*Manage building blocks.

distributing building blocks for reuse and creating a custom building block


Managing Styles

and Templates


*Manage styles.

updating style based on selected text, copying styles from one document or template to another, and setting outline levels for styles

*Manage style sets.

creating a custom style set, saving a custom style set, and modifying an existing style set

*Manage multilevel lists.

creating a multilevel list, linking styles to a multilevel list, modifying an existing multilevel list, and defining a new number format

*Manage templates.

attaching a global template, attaching a local template, automatically updating styles using an attached template, saving style changes to the attached template, and saving gallery changes to the attached template


Managing Data Objects and Automation


*Manage objects.

creating an object, embedding an existing object, linking to an existing object, and display as icon

*Manage XML.

viewing XML tags, moving text with XML tags, validating a document against an XML schema, and attaching a custom XML schema

*Record and edit a macro.

recording a macro in a document, recording a macro in a template, inserting a breakpoint, stepping through a macro, and changing actions in a macro

*Manage an existing macro.

moving macros between documents (copy a macro, rename a copied macro, import a macro, export a macro) and configuring macro security (digitally sign a macro, macro security levels)


Managing Fields

and References


*Create a custom TOC.

including or excluding specific levels, including or excluding specific styles, and modifying the TOC properties

*Insert cross-references within a document.

inserting reference to a document element, inserting a specific type of reference, and inserting above/below reference

*Manage fields.

updating all fields in a document, converting all fields of a document to text, creating a custom field by using modifiers and switches, changing the display format of a data field (switches), associating properties in the Document Information Panel, and creating a custom document property field

*Create object captioning.

autocaptioning different object types (numbering, position) and creating a custom label (numbering, position)


Managing

Content


*Manage visual content.

creating a custom watermark and inserting and modifying a SmartArt graphic (modify a SmartArt graphic layout, convert a list to a SmartArt graphic)

*Manage table properties.

repeating a header row on subsequent pages, allowing a row to break across pages, and wrapping text around a table

*Apply paste options.

setting default paste options and applying paste options for text, tables, graphics, and lists

*Find and replace content.

finding and replacing content by format, using special characters, and using wildcards


Managing Documents


*Embed fonts.

embedding fonts on the current document, all new documents, all characters, or characters in use

*Apply variable formatting by using sections.

restarting page numbering with a different number format, linking and unlinking headers and footers, changing page orientation, changing page size and margins, and applying advanced page setup options (automatically align content vertically on a page, add line numbering)

*Restrict formatting and editing.

restricting editing to selected parts of a document, limiting formatting to specific styles, allowing only specific types of editing, and allowing per-user document permissions

*Recover documents.

Open and Repair, recovering text from any file, and locating the autorecover file (.asd file)

*Combine multiple documents. This objective may include but is not limited to: Insert file option and Insert objects



  .


Microsoft® EXCEL 2007 EXPERT Exam

 

Exam Objectives as stated by Microsoft


Skill Sets

 

Exam Skill Standards

 

Capturing Data


*Restrict data entry by using data validation.

referencing external data in drop-down lists, validating data by using formulas, and encircling invalid data

Link form controls to cells.

scroll bars, check box, label, and drop-down

*Import data from an external source.

importing data from a text file, importing data by using a Web query, using the Microsoft Query Wizard to edit an existing query, and referencing data in a database

*Link to data in an external source.

referencing data in another workbook, refreshing and editing workbook links, and changing data refresh options to optimize file size


Calculating Data by Using Advanced Formulas


*Create formulas that combine Lookup & Reference and Statistical functions.

using common Lookup & Reference functions (HLOOKUP, VLOOKUP, TRANSPOSE, INDIRECT, MATCH, INDEX, CHOOSE) and using common Statistical functions (COUNTIF, COUNTIFS, COUNTBLANK, AVERAGEIF, AVERAGEIFS, FREQUENCY)

*Create formulas that combine Date & Time, Text, and Logical functions.

using Date & Time functions, using Text functions, and using common Logical functions (IFERROR, Nested IF, OR, and AND)

*Manage and reference defined names.

creating a dynamic named range, creating and referencing a named formula, modifying named ranges by using Names Manager, and navigating across worksheets by using named ranges

Audit formulas.

trace dependents, trace precedents, and adding a watch to the Watch Window


Managing Data Ranges


*Consolidate data ranges.

consolidating data ranges by position, by category, or with links to a source

*Select and manipulate similar cells and objects.

blanks, comments, objects, conditional formats, formulas, visible cells only, and find and replace by format

*Apply advanced filtering.

using multiple conditionals on the same column, using the OR condition across multiple columns, and applying filtering to unique records only

*Protect data in a worksheet.

locking and unlocking cells, locking and unlocking objects, and hiding formulas


Summarizing and Analyzing Data


*Create PivotTables and PivotCharts.

consolidating multiple data ranges by using PivotTables, creating a PivotTable from an existing worksheet, creating a PivotTable linked to an external database, and creating a PivotChart from an existing worksheet

*Modify PivotTable content.

grouping (group by dates, group by numbers, group by text), inserting a calculated field, and showing report filter pages

*Perform what-if analysis. using Scenario Manager (create scenarios, compare scenarios), using a data table, using Goal Seek, and using the Solver add-in


Formatting Worksheet and Chart Content


*Create custom number formats.

number formats, date and time formats, and conditional number formats

*Define advanced conditional formatting rules by using formulas.

creating rules based on dates, creating rules based on numbers, and creating rules based on text

*Add visual elements to a chart.

adding a Z axis, adding a second Y axis, and adding analysis indicators

(Trendlines, R-squared value, Series lines, High-Low lines)


Managing Macros and User-Defined Functions


*Record and edit a macro.

recording a macro and editing a macro in Visual Basic for Applications (VBA)

*Manage existing macros.

moving macros between workbooks, assigning a shortcut key to an existing macro, assigning a macro to a button in a worksheet, and configuring macro security levels

*Create a user-defined function (UDF).





  .

Microsoft® WORD 2007 Core Exam

 

Exam Objectives as stated by Microsoft


Skill Sets

 

Exam Skill Standards

 

Creating and Customising

Documents


*Create and format documents

*Layout documents

*Make documents and content easier to find

*Personalise Office Word 2007


Formatting Content


*Format text and paragraphs     

*Manipulate text

*Control pagination


Working with Visual Content


*Insert illustrations

*Format illustrations

*Format text graphically

*Insert and modify text boxes


Organising Content


*Structure content by using Quick Parts

*Use tables and lists to organise content

*Modify tables

*Insert and format references and captions

*Merge documents and data sources


Reviewing Documents


*Navigate documents

*Compare and merge document versions

*Manage tracked changes

*Insert, modify, and delete comments


Sharing and Securing Content


*Prepare documents for sharing

*Control document access

*Attach digital signatures




  .

Microsoft® EXCEL 2007 Core Exam

 

Exam Objectives as stated by Microsoft


Skill Sets

 

Exam Skill Standards

 

Creating and Manipulating Data


*Insert data by using AutoFill

*Ensure data integrity

*Modify cell contents and formats

*Change Worksheet Views


Formatting Data and Content


*Format worksheets

*Insert and modify rows and columns

*Format cells and cell content

*Format data as a table


Creating and Modifying Formulas


*Reference data in formulas

*Summarise data using a formula.

*Summarise data using subtotals.

*Conditionally summarise data by using a formula 

*Look up data by using a formula. 

*Use conditional logic in a formula. 

*Format or modify text by using formulas.


Presenting Data Visually


*Create and format charts

*Modify charts

*Apply conditional formatting

*Insert and modify illustrations

*Outline data


Collaborating and Securing Data


*Manage changes to workbooks

*Protect and share workbooks

*Prepare workbooks for distribution

*Set print options for printing data, worksheets, and workbooks

*Filter data by using AutoFilter

*Filter and sort data by using conditional formatting

*Filter and sort data by using cell attributes



                         

  .

Microsoft® POWERPOINT 2007 Exam

 

Exam Objectives as stated by Microsoft


Skill Sets

 

Exam Skill Standards

 

Creating and Formatting Presentations

 

*Create new presentations

*Customise slide masters.

*Add elements to slide masters

*Create and change presentation elements

*Arrange slides

Creating and Formatting Slide Content


*Insert and format text boxes.

*Manipulate text.

*Add and link existing content to presentations

*Apply, customise, modify, and remove animations

Working with Visual Content


*Create SmartArt diagrams

*Modify SmartArt diagrams.

*Insert illustrations and shapes.

*Modify illustrations

*Arrange illustrations and other content

*Insert and modify charts

*Insert and modify tables

Collaborating on and Delivering

Presentations


*Review presentations

*Protect presentations.

*Secure and Share Presentations

*Prepare printed materials

*Prepare for and rehearse presentation delivery


  .

Microsoft® ACCESS 2007 Exam

 

Exam Objectives as stated by Microsoft


Skill Sets

 

Exam Skill Standards

 

Structuring a Database

 

*Define data needs and types

*Define and print table relationships

*Add, set, change, or remove primary keys

*Split databases

Creating and Formatting

Database Elements


*Create Databases

*Create and modify tables

*Create reports and forms

*Modify the design of reports and forms

*Enter and modify data

*Enter, edit, delete and navigate among records

*Find, replace and import data

*Attach documents to and detach from records

Queries


*Create and modify queries

*Present and share data

*Sort and filter data

*Export data

Database


*Save database objects as other file types

*Print database objects

*Manage and maintain databases

*Perform routine database operations

*Manage databases


  .

Microsoft® OUTLOOK 2007 Exam

 

Exam Objectives as stated by Microsoft


Skill Sets

 

Exam Skill Standards

 

Managing Messaging


*Create and send e-mail message

*Create and manage your signature and automated messages

*Managed e-mail message attachments

*Configure e-mail message sensitivity and

importance settings

*Configure e-mail message security settings

*Configure e-mail message delivery reports

*View e-mail messages

Managing Scheduling


*Create appointments, meetings and events

*Send meeting requests

*Update, cancel, and respond to meeting requests

*Customise calendar settings

*Share your calendar with others

*View other calendars

Managing Tasks


*Create and modify contacts

*Accept, decline, assign, update, and respond to tasks

Managing Contacts and

Personal Contacts Information


*Create and modify contacts

*Edit and use electronic business cards

*Create and modify distribution lists

*Create a secondary address book

Organising Information


*Categorise items by colour

*Create and manage data files

*Organise mail folders

*Locate items by using the search feature

*Create, modify, and remove rules to manage e-mail messages.


  .

Microsoft® VISTA 2007 Exam

 

Exam Objectives as stated by Microsoft


Skill Sets

 

Exam Skill Standards

 

Protecting Your Computer


*Managing Windows Firewall

*Manage Malicious software (malware) Protection

*Configure Windows Update Settings

*Lock a Computer

*Manage Windows Internet Explorer Security

*Configure Local User Accounts

Managing Mobile & 

Remote Computing


*Manage the Computer Power State

*Manage Network Connections

*Manage Remote Access to your Computer

*Connect to another Computer

*Access files stored in shared network folders when your computer is offline

Managing Software, Disks and Devices


*Manage Software

*Manage Disks

*Manage Devices and Drivers

*Manage Display Settings

*Configure Multiple Monitors

*Install and Configure a Printer

Managing Files & Folders 

*Manage Windows Explorer Settings

*Manage and Secure Folders

*Share Folders

*Back up and Restore Files and Folders

Collaborating with Other People


*Collaborate in Real Time Present information to an audience

Customising Your Windows Vista Experience


*Customise and Modify the Start Menu

*Customise the taskbar

*Personalise the Appearance and Sound of a Computer

*Manage the Windows Sidebar

Optimising and Troubleshooting Your Computer


*Increase Processing speed

*Locate Trouble shooting and system information

*Repair a Network Connection

*Recover from Software Errors

*Troubleshooting Printing Errors

*Recover the Operating System from a problem

*Request and Mange Remote Assistance


  .

Microsoft® WORD 2007 EXPERT Exam

 

Exam Objectives as stated by Microsoft


Skill Sets

Exam Skill Standards

Creating and Modifying Advanced Document Types

*Create a mail merge document.

creating a new recipient list, selecting recipients from Outlook contacts, and conditional mail merge

*Create and manage master documents.

converting a document to a master document, converting an outline to a master document, importing subdocuments, and managing subdocuments

*Create forms.

creating forms using fields, creating forms using content controls, and protecting forms

Customizing Word 2007

*Customize the Quick Access toolbar.

adding commands not in the ribbon, adding separators, and reorganizing commands

*Change default save options.

file formats and file locations

*Assign keyboard shortcuts.

assigning keyboard shortcuts to an existing macro, a style, a symbol, or autotext

*Manage building blocks.

distributing building blocks for reuse and creating a custom building block

Managing Styles and Templates

*Manage styles.

updating style based on selected text, copying styles from one document or template to another, and setting outline levels for styles

*Manage style sets.

creating a custom style set, saving a custom style set, and modifying an existing style set

*Manage multilevel lists.

creating a multilevel list, linking styles to a multilevel list, modifying an existing multilevel list, and defining a new number format

*Manage templates.

attaching a global template, attaching a local template, automatically updating styles using an attached template, saving style changes to the attached template, and saving gallery changes to the attached template

Managing Data Objects and Automation

*Manage objects.

creating an object, embedding an existing object, linking to an existing object, and display as icon

*Manage XML.

viewing XML tags, moving text with XML tags, validating a document against an XML schema, and attaching a custom XML schema

*Record and edit a macro.

recording a macro in a document, recording a macro in a template, inserting a breakpoint, stepping through a macro, and changing actions in a macro

*Manage an existing macro.

moving macros between documents (copy a macro, rename a copied macro, import a macro, export a macro) and configuring macro security (digitally sign a macro, macro security levels)

Managing Fields and References

*Create a custom TOC.

including or excluding specific levels, including or excluding specific styles, and modifying the TOC properties

*Insert cross-references within a document.

inserting reference to a document element, inserting a specific type of reference, and inserting above/below reference

*Manage fields.

updating all fields in a document, converting all fields of a document to text, creating a custom field by using modifiers and switches, changing the display format of a data field (switches), associating properties in the Document Information Panel, and creating a custom document property field

*Create object captioning.

autocaptioning different object types (numbering, position) and creating a custom label (numbering, position)

Managing Content

*Manage visual content.

creating a custom watermark and inserting and modifying a SmartArt graphic (modify a SmartArt graphic layout, convert a list to a SmartArt graphic)

*Manage table properties.

repeating a header row on subsequent pages, allowing a row to break across pages, and wrapping text around a table

*Apply paste options.

setting default paste options and applying paste options for text, tables, graphics, and lists

*Find and replace content.

finding and replacing content by format, using special characters, and using wildcards

Managing Documents

*Embed fonts.

embedding fonts on the current document, all new documents, all characters, or characters in use

*Apply variable formatting by using sections.

restarting page numbering with a different number format, linking and unlinking headers and footers, changing page orientation, changing page size and margins, and applying advanced page setup options (automatically align content vertically on a page, add line numbering)

*Restrict formatting and editing.

restricting editing to selected parts of a document, limiting formatting to specific styles, allowing only specific types of editing, and allowing per-user document permissions

*Recover documents.

Open and Repair, recovering text from any file, and locating the autorecover file (.asd file)

*Combine multiple documents.

Insert file option and Insert objects


  .

Microsoft® EXCEL 2007 EXPERT Exam

 

Exam Objectives as stated by Microsoft


Skill Sets

Exam Skill Standards

Capturing Data

*Restrict data entry by using data validation.

referencing external data in drop-down lists, validating data by using formulas, and encircling invalid data

*Link form controls to cells. This objective may include but is not limited to: scroll bars, check box, label, and drop-down

*Import data from an external source.

importing data from a text file, importing data by using a Web query, using the Microsoft Query Wizard to edit an existing query, and referencing data in a database

*Link to data in an external source.

referencing data in another workbook, refreshing and editing workbook links, and changing data refresh options to optimize file size

Calculating Data by Using Advanced Formulas

*Create formulas that combine Lookup & Reference and Statistical functions.

using common Lookup & Reference functions (HLOOKUP, VLOOKUP, TRANSPOSE, INDIRECT, MATCH, INDEX, CHOOSE) and using common Statistical functions (COUNTIF, COUNTIFS, COUNTBLANK, AVERAGEIF, AVERAGEIFS, FREQUENCY)

*Create formulas that combine Date & Time, Text, and Logical functions. using Date & Time functions, using Text functions, and using common Logical functions (IFERROR, Nested IF, OR, and AND)

*Manage and reference defined names.

creating a dynamic named range, creating and referencing a named formula, modifying named ranges by using Names Manager, and navigating across worksheets by using named ranges

*Audit formulas.

trace dependents, trace precedents, and adding a watch to the Watch Window

Managing Data Ranges

*Consolidate data ranges.

consolidating data ranges by position, by category, or with links to a source

*Select and manipulate similar cells and objects.

blanks, comments, objects, conditional formats, formulas, visible cells only, and find and replace by format

*Apply advanced filtering.

using multiple conditionals on the same column, using the OR condition across multiple columns, and applying filtering to unique records only

*Protect data in a worksheet.

locking and unlocking cells, locking and unlocking objects, and hiding formulas

Summarizing and Analyzing Data

*Create PivotTables and PivotCharts.

consolidating multiple data ranges by using PivotTables, creating a PivotTable from an existing worksheet, creating a PivotTable linked to an external database, and creating a PivotChart from an existing worksheet

*Modify PivotTable content.

grouping (group by dates, group by numbers, group by text), inserting a calculated field, and showing report filter pages

*Perform what-if analysis.

using Scenario Manager (create scenarios, compare scenarios), using a data table, using Goal Seek, and using the Solver add-in

Formatting Worksheet and Chart Content

*Create custom number formats.

number formats, date and time formats, and conditional number formats

*Define advanced conditional formatting rules by using formulas.

creating rules based on dates, creating rules based on numbers, and creating rules based on text

*Add visual elements to a chart.

adding a Z axis, adding a second Y axis, and adding analysis indicators (Trendlines, R-squared value, Series lines, High-Low lines)

Managing Macros and User-Defined Functions

*Record and edit a macro.

recording a macro and editing a macro in Visual Basic for Applications (VBA)

*Manage existing macros.

moving macros between workbooks, assigning a shortcut key to an existing macro, assigning a macro to a button in a worksheet, and configuring macro security levels

*Create a user-defined function (UDF).


Adobe Web Communication using Dreamweaver CS5


Exam Objectives as stated by Adobe


Skill Sets

 

Exam Skill Standards

 

Setting Project Requirements

* Identify the purpose, audience, and audience needs for a website.

* Demonstrate knowledge of standard copyright rules (related terms, obtaining permission, and citing copyrighted material).

* Demonstrate knowledge of website accessibility standards that address the needs of people with visual and motor impairments.

* Make website development decisions based on your analysis and interpretation of design specifications.

* Understand project management tasks and responsibilities.

Planning Site Design and Page Layout

* Demonstrate general and Dreamweaver-specific knowledge of best practices for designing a website, such as maintaining consistency, separating content from design, using standard fonts, and utilizing visual hierarchy.

* Produce website designs that work equally well on various operating systems and browser versions/configurations.

* Demonstrate knowledge of page layout design concepts and principles.

* Identify basic principles of website usability, readability, and accessibility.

* Demonstrate knowledge of flowcharts, storyboards, and wireframes to create web pages and a site map (site index) that maintain the planned website hierarchy.

* Communicate with others (such as peers and clients) about design and content plans.

Understanding the Adobe Dreamweaver CS5 Interface

* Identify elements of the Adobe Dreamweaver interface.

* Use the Insert bar.

* Use the Property inspector.

* Use the Assets panel.

* Use the Files panel.

* Customize the workspace

Adding Content by Using Adobe Dreamweaver CS5

* Define a Dreamweaver site.

* Create, title, name, and save a web page.

* Add text to a web page.

* Insert images and apply alternative text on a web page.

* Link web content, using hyperlinks, e-mail links, and named anchors.

* Insert rich media, such as video, sound, and animation in Flash format.

* Insert navigation bars, rollover images, and buttons created in Fireworks on a web page.

* Build image maps.

* Import tabular data to a web page.

* Import and display a Microsoft Word or Microsoft Excel document to a web page.

* Create forms.

Organizing Content by Using Adobe Dreamweaver CS5

* Set and modify document properties.

* Organize web page layout with relative and absolutely-positioned div tags and CSS styles.

* Modify text and text properties.

* Modify images and image properties.

* Create web page templates.

* Use basic HTML tags to set up an HTML document, format text, add links, create tables, and build ordered and unordered lists.

* Add head content to make a web page visible to search engines.

* Use Adobe Creative Suite to implement a reusable design.

Evaluating and Maintaining a Site by Using Adobe Dreamweaver CS5

* Conduct technical tests.

* Identify techniques for basic usability tests.

* Identify methods for collecting site feedback.

* Present web pages to others (such as team members and clients) for feedback and evaluation.

* Manage assets, links, and files for a site.

* Publish and update site files to a remote server.



  .

Adobe Rich Media Communication using Flash Professional CS5


Exam Objectives as stated by Adobe


Skill Sets

 

Exam Skill Standards

 

Setting Project Requirements 

* Identify the purpose, audience, and audience needs for rich media content.

* Identify rich media content that is relevant to the purpose of the media in which it will be used (websites, mobile devices, and so on).

* Understand options for producing accessible rich media content.

* Demonstrate knowledge of standard copyright rules (related terms, obtaining permission, and citing copyrighted material).

* Understand project management tasks and responsibilities.

* Communicate with others (such as peers and clients) about design and content plans

Identifying Rich Media Design Elements

* Identify general and Flash-specific best practices for designing rich media content for a website.

* Demonstrate knowledge of design elements and principles.

* Identify general and Flash-specific techniques to create rich media elements that are accessible and readable.

* Use a storyboard to produce rich media elements.

* Organize a Flash document

Understanding Adobe Flash CS5 Interface

* Identify elements of the Adobe Flash interface.

* Use the Timeline.

* Adjust document properties.

* Use Adobe Flash guides and rulers.

* Use the Motion Editor.

* Understand Flash file types.

* Identify best practices for managing the file size of a published Adobe Flash document.

Building Rich Media Elements by Using Flash CS5

* Make rich media content development decisions based on your analysis and interpretation of design specifications.

* Use tools on the Tools panel to select, create, and manipulate graphics and text.

* Import and modify graphics.

* Create text.

* Adjust text properties.

* Create objects and convert them to symbols, including graphics, movie clips, and buttons.

* Understand symbols and the library.

* Edit symbols and instances

* Create masks.

* Create animations (changes in shape, position, size, color, and transparency).

* Add simple controls through ActionScript 3.0.

* Import and use sound.

* Add and export video.

* Publish and export Adobe Flash documents.

* Make a document accessible

Evaluating Rich Media Elements by Using Adobe Flash CS5

* Conduct basic technical tests.

* Identify techniques for basic usability tests.



  .

Adobe Visual Communication using Photoshop CS5


Exam Objectives as stated by Adobe


Skill Sets

 

Exam Skill Standards

 

Setting Project Requirements

* Identify the purpose, audience, and audience needs for preparing image(s).

* Demonstrate knowledge of standard copyright rules for images and image use.

* Demonstrate knowledge of project management tasks and responsibilities.

* Communicate with others (such as peers and clients) about design plans.

Setting Project Requirements 

* Identify the purpose, audience, and audience needs for preparing image(s).

* Demonstrate knowledge of standard copyright rules for images and image use.

* Demonstrate knowledge of project management tasks and responsibilities.

* Communicate with others (such as peers and clients) about design plans.

Understanding Adobe Photoshop CS5

* Identify elements of the Photoshop CS5 user interface and demonstrate knowledge of their functions.

* Demonstrate knowledge of layers and masks.

* Demonstrate knowledge of importing, exporting, organizing, and saving.

* Demonstrate knowledge of producing and reusing images.

* Demonstrate an understanding of and select the appropriate features and options required to implement a colour management workflow.

Manipulating Images using Adobe Photoshop CS5 

* Demonstrate knowledge of working with selections and measurement.

* Use Photoshop guides and rulers.

* Transform images.

* Adjust or correct the tonal range, color, or distortions of an image.

* Demonstrate knowledge of retouching and blending images.

* Demonstrate knowledge of drawing and painting.

* Demonstrate knowledge of type.

* Demonstrate knowledge of filters.

Publishing Digital Images using Adobe Photoshop CS5

* Demonstrate knowledge of preparing images for web, print, and video.





  .

IC3 Module A


Computing Fundamentals


Course Description 

This module includes the knowledge and skills required to identify different types of computers, the components of a personal computer (including internal components such as microprocessors) and how these components work together. The module also includes the knowledge and skills relating to computer storage as it applies to hardware components like floppy and hard disks and performance as it applies to processor speed and memory.



Exam Objectives as stated by Certiport


Skill Sets

Exam Skill Standards

Computer Hardware

* Identify different types of computers, how computers work (process information) and how individual computers fit into larger systems

*  Identify the function of computer hardware components and common problems associated with individual components

*  Identify issues relating to computer performance and how it is affected by different components of the computer

*  Identify the factors that go into a decision on how to purchase a computer or select a computer for work, school, or home

Computer Software

*  Identify how software works and how software and hardware work together to perform computing tasks

*  Identify different types of software, the tasks for which each type of software is most suited, and the popular programs in each software category

Using an Operating System

*  Identify what an operating system is and how it works

*  Be able to manipulate and control the Windows desktop, files and disks

*  Be able to change system settings and install software


  .

IC3 Module B


Key Applications


Course Description

This module includes the knowledge and skills required to perform functions common to all Microsoft Windows applications with an emphasis on the common functionality between the two Microsoft Office applications, Microsoft Word and Excel.  Elements include the ability to start and exit either the Word or Excel application, modify the display of toolbars and other on-screen elements, use online help, and perform file management, editing, formatting and printing functions common to Word, Excel and most Windows applications.



Exam Objectives as stated by Certiport


Skill Sets

Exam Skill Standards

Common Programme Functions

*  Be able to start and exit a Windows application and utilise sources of online help

*  Identify common on-screen elements of Windows applications, change application settings, and manage files within an application

*  Perform common editing (cut, copy, paste, spellcheck, etc.) and formatting (fonts, margins, tabs, etc.) functions

*  Perform common printing functions

Word Processing Functions

*  Be able to format text and documents including the ability to use automatic formatting tools

*  Be able to add tables and graphics to a document

Spreadsheet Functions

*  Be able to modify worksheet data and structure

*  Be able to sort data and manipulate data using formulas and functions

*  Be able to format a worksheet

*  Be able to add pictures and charts to a worksheet



  .

IC3 Module C


Living Online


Course Description 

This module includes the knowledge and skills required to identify common terminology associated with computer networks and the Internet, components and benefits of networked computers, the difference between different types of networks (LAN and WAN), and how computer networks fit into other communications networks (like the telephone network).

 


Exam Objectives as stated by Certiport


Skill Sets

Exam Skill Standards

Networks and the Internet

*  Identify network fundamentals and the benefits and risks of network computing

*  Identify the relationship between computer networks, other communications networks (like the telephone network) and the Internet

Electronic Mail

*  Identify how electronic mail works

*  Identify how to use an electronic mail application

*  Identify the appropriate use of e-mail and e-mail related "netiquette"

Using the Internet

*  Identify different types of information sources on the Internet

*  Be able to use a Web browsing application

*  Be able to search the Internet for information

The Impact of Computing and the Internet on Society

*  Identify how computers are used in different areas of work, school, and home

*  Identify the risks of using computer hardware and software

*  Identify how to use the Internet safely and legally