MOS: Word 2010

Exam 77-881

Who should take this exam?

The core-level Microsoft Office Word 2010 user should be able to navigate Microsoft Office Word 2010 software at the feature and functional level. They should be familiar with and know how to use at least 80 per cent of the features and capabilities of Microsoft Office Word 2010. The core-level user should be able to use Microsoft Office Word 2010 to create and edit professional-looking documents for a variety of purposes and situations. Users would include people from a wide variety of job roles from almost all areas of professional, student and personal life.

Topics Covered

• Sharing and maintaining document
• Formatting content
• Applying page layout and reusable content
• Including illustrations and graphics in a document
• Proofreading documents
• Applying references and hyperlinks
• Performing mail merge operations

MOS: Excel 2010

Exam 77-882

Who should take this exam?

The core-level Microsoft Office Excel 2010 user should be able to navigate Microsoft Office Excel 2010 software at the feature and functional level. They should be familiar with and know how to use at least 80 percent of the features and capabilities of Microsoft Office Excel 2010. The core-level user should be able to use Microsoft Office Excel 2010 to create and edit professional-looking spreadsheets for a variety of purposes and situations. Users would include people from a wide variety of job roles from almost all areas of professional, student and personal life.

Topics Covered

• Managing the worksheet environment
• Creating cell data
• Formatting cells and worksheets
• Managing worksheets and workbooks
• Applying formulas and functions
• Presenting data visually
• Sharing worksheet data with other users
• Analysing and organising data

MOS: PowerPoint 2010

Exam 77-883

Who should take this exam?

The typical candidate for the exam is a student, office worker or instructor who needs to navigate PowerPoint 2010 at the feature and functionality level.

The core PowerPoint 2010 user is proficient with productivity tools, frequently collaborates with others on projects and personalises his or her working environment for efficiency. Candidates should know and demonstrate how to create or produce effective, practical slide shows.

Topics Covered

• Manage the PowerPoint environment
• Create a slide presentation
• Work with graphical and multimedia elements
• Create charts and tables
• Apply transitions and animations
• Collaborate on presentations
• Prepare presentations for delivery
• Deliver presentations

MOS: Outlook 2010

Exam 77-884

Who should take this exam?

Candidates can format email message content by using character and paragraph formatting, create or insert graphic elements, such as charts, tables and SmartArt graphics, into messages. They can also send messages to private recipients by using the Bcc field. Candidates are able to create contact records, tasks and appointments from incoming messages, and they set up contact groups to facilitate communication with other Outlook users. They may share schedule information with other Outlook users, too. Candidates schedule meetings involving people and system resources, and they delegate tasks to others. Core users personalise the Outlook program window and the Quick Access Toolbar to maximise their efficiency. They organise messages and other Outlook items, and they display different views of mail folders and of the calendar, address book and task list. They may also display multiple calendars and share calendars with other Outlook users.

Topics Covered

• Manage the Outlook environment (15-20%)
• Create and format item content (25–30%)
• Manage email messages (25–30%)
• Manage contacts (15–20%)
• Manage calendar objects (15–20%)
• Work with tasks, notes and journal entries (5–10%)

MOS: Access 2010

Exam 77-885

Who should take this exam?

The typical candidate for the exam works as a user support professional, trainer, teacher, professor, database user or database creator who needs to create or maintain a basic Access database. Users can create, modify and extend functionality of basic database objects, including tables, queries, forms and reports. Users can also construct and modify basic relationships among database entities and can instruct others in basic Access functionality and usage. The Access 2010 user typically is effective in creating, modifying and personalising objects. This candidate is capable of working independently on database projects, and can often answer questions from others about databases. Candidates should know and demonstrate how to create or modify a simple Access database and use templates to create basic objects.

Topics Covered

• Manage the Access environment
• Build tables
• Build forms
• Create and manage queries
• Design reports

MOS: SharePoint 2010

Exam 77-886

Who should take this exam?

Candidates for this exam are users who provide structure for information, extend out-of-the-box site features, solve business problems through composite applications and facilitate collaboration with other site users. Users perform all site user tasks. They optimise Web Part pages for team use by adding and configuring Web Parts from the Web Part gallery, and they customise dashboards to target the information presented. Users focus on adapting SharePoint sites to their teams’ needs and on improving productivity.

Topics Covered

• Create and format content (25–30%)
• Manage SharePoint sites (15-20%)
• Participate in user communities (15–20%)
• Configure and consume site search results (20-25%)
• Integrate SharePoint 2010 services and Microsoft Office 2010 applications (15–20%)

MOS: OneNote 2010

Exam 77-853

Who should take this exam?

This exam is designed for students, office workers or instructors who need to navigate the Office software at the feature and functionality level. These users use OneNote as a digital notebook to facilitate their work and to integrate with other Office 2010 applications. They have the ability to use it for project management, organising research, and collaboration and to access information from multiple locations. They have the skills and knowledge to problem solve many issues that arise. They effectively use many of the common features and functions to organise and display digital information. The core OneNote 2010 user typically is accustomed to making decisions about his or her own work and is a competent user of Office 2010 applications. The user knows how to leverage his or her work for multiple purposes and how to use the major features and functions of OneNote to enhance project and task management. This user also understands how to collaborate via OneNote.

Topics Covered

• Manage the OneNote environment (25–30%)
• Share and collaborate (15–20%)
• Organise and find notes (30-35%)