Microsoft Office 2010 Applications specifically target workplace demands for 2010 Office application and system skills. Companies can validate and maximise the value of their 2010 Microsoft Office upgrade by hiring certified individuals and getting their existing workforce certified. When you become Microsoft certified you are qualified to use the full features of the 2010 Office system, making you valuable to companies who want to reinforce their technology investment with accelerated productivity and improved organisational performance.
Programme Aims and Objectives
The aim of this programme is to increase productivity through the utilisation of Microsoft Office applications such as Word, Excel, PowerPoint and Outlook, with greater efficiency. The Microsoft Qualification is the official certification of Microsoft Office desktop applications. The Office 2010 consists of four modules which constitute the main software tools used in business today.
Programme Structure
The programme will be delivered through lecture and demonstration. The latest version of Office 2010 will be used along with GMetrixs – the practice exam software, before students sit their final online exam per module, where they will receive the results immediately after sitting the exam.
Programme Content
MS Word (7 weeks)This module is suited to existing users of MS Word. Good keyboarding skills are required. The programme starts by refreshing users on the fundamental features of Word such as the following to include
Creating and Customising Documents – Create and format documents, Layout documents, Make documents and content easier to find, Personalise Office Word 2010.
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 & merge document versions, Manage tracked changes, Insert, modify & delete comments.
Sharing and Securing Content – Prepare documents for sharing, Control document access, Attach digital signatures.
MS Excel (7 weeks)This module is suited to existing users of MS Excel. The programme starts by refreshing users on the fundamental features of Excel such as the following to include
Creating and Manipulating Data – Insert data by using AutoFill, Ensure data integrity, Modify cell contents and formats, Change Worksheet Views, Manage worksheets. 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, Display and print formulas.
Presenting Data Visually – Create and format charts, Modify charts, Apply conditional formatting, Insert and modify illustrations, Outline data, Sort and filter data.
Collaborating and Securing Data – Manage changes to workbooks, Protect and share workbooks, Prepare workbooks for distribution, Save workbooks, Set print options for printing data, worksheets, and workbooks.
MS PowerPoint (5 weeks)This module is suited to users of applications like Word or Excel who wish to learn presentation skills using the features of PowerPoint to create and deliver effective professional presentations. The programme starts by refreshing users on the fundamental features of PowerPoint but advances quickly to include detailed coverage of features of MS PowerPoint such as:
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 and 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.
MS Outlook (5 weeks)This module will provide you with the skills you need to start sending and responding to email, as well as maintaining your Calendar, scheduling meetings, and working with tasks and notes. In this module, you will cover the following areas:
Managing Messaging – Create and send an e-mail message, Create and manage your signature and automated messages, Manage e-mail message attachments, Configure e-mail message sensitivity and importance settings, Configure e-mail message security settings, Configure e-mail message delivery options, 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, modify, and mark tasks as complete, Accept, decline, assign, update, and respond to tasks.
Managing Contacts and Personal Contact Information – Create and modify contacts, Edit and use an electronic business card, Create and modify distribution lists, Create a secondary address book.
Organising Information – Categorise Office Outlook 2010 items by colour, Create and manage Office Outlook 2010 data files, Organise mail folders, Locate Office Outlook 2010 items by using the search feature, Create, modify and remove rules to manage e-mail messages, Customise your Office Outlook 2010.
Assessment
To be awarded the Diploma in Microsoft Office 2010 Applications, students will be required to complete all four module exams (Word, Excel, PowerPoint and Outlook). Each module will be examined on completion. Participants will recieve a DBS certificate when they complete 4 modules.
Career Progression Opportunities
As a Microsoft Office 2010 Certified professional, you’ll have more than a working familiarity with Office programmes – you’ll have the technical skills to efficiently use the breadth of the programmes’ features.
Further Study Options
On successful completion of the Diploma in Microsoft Office 2010 Applications students who wish to complete an IT teaching qualification can progress onto the EDI/JEB Teacher’s Diploma in Information Technology at DBS.
Student Profile
Typically, participants on this programme come from a variety of backgrounds, from business environments, training/teaching environments as well as individuals completing for their own personal development.
“This course is ideal to enhance your existing Microsoft Office skills and introduces students to all current updates in the applications. Classes are hands-on and fast moving. I thoroughly enjoyed the course which has significantly improved my IT skills.”
Ursula Jurado