MentorIT Academy > Home > Courses

COURSES: (Click Course Titles for More Information)

BCS: ECDL LEVEL 1
BCS: ECDL LEVEL 2
MICROSOFT OFFICE SPECIALIST LEVEL 2
OCN: MENTORING CERTIFICATE LEVEL 2

BASIC SKILLS Entry Level:

  • Numeracy
  • Lit eracy
  • IT Literacy

EMPLOYMENT TRAINING LEVEL 1

  • Curriculum Vitae
  • Interview Skills
  • Job Search
  • Letter Writing
dots ESOL TRAINING Pre-entry & Entry Level 1  
   
Require an Information Sheet Regarding Our Courses or Prospectus, with prices please click on the appropriate title listed below:
Prospectus (All & Prices)  
ECDL Level 1 and Level 2  
Microsoft Office Specialist Level 2 and Level 3  
Mentoring Level 2  
Basic Skills Entry Level  
   
BACK  
BCS: ECDL LEVEL 1

The European Computer Driving Licence® (ECDL) is the internationally recognized qualification which enables people to demonstrate their competence in computer skills.

The record breaking ECDL is the fastest growing IT user qualification in over 125 countries.

ECDL is designed specifically for those who wish to gain a benchmark qualification in computing to enable them to develop their IT skills and enhance their career prospects.

No prior knowledge of IT or computer skills is needed to study ECDL.

 

The First Part of our ECDL course.

1. Basic concepts of IT
2. Using the computer and managing files
3. Word processing

 

Back To Top

BCS: ECDL LEVEL 2

The European Computer Driving Licence® (ECDL) is the internationally recognized qualification which enables people to demonstrate their competence in computer skills.

The record breaking ECDL is the fastest growing IT user qualification in over 125 countries.

ECDL is designed specifically for those who wish to gain a benchmark qualification in computing to enable them to develop their IT skills and enhance their career prospects.

No prior knowledge of IT or computer skills is needed to study ECDL.

 

The Second Part of our ECDL course.

4. Spreadsheets
5. Database
6. Presentation
7. Information and Communication

 

Back To Top

OCN: MENTORING CERTIFICATE LEVEL 2

Our OCN Mentoring Certificate, is a Mentoring qualifiation aim at beginners to mentoring building up to a strong level 2 in Mentoring. This course is the initial step for those who want to progress onto Level 3 and Level 4 Mentoring.
 
Advantage
You will be able to understand and use the basic concepts of mentoring, immediately in your real-life and build on your experience through the techniques gained from the course.
 

Back To Top

MICROSOFT OFFICE SPECIALIST LEVEL 2

Microsoft Word 2003 | Microsoft Excel 2003 | Microsoft Access 2003 | Microsoft PowerPoint 2003
(Quick Menu)

Microsoft Word 2003

Word processing is the use of computers to create, revise, and save documents for printing and future retrieval. It will provide you with the basic concepts required to produce simple documents.

You will create, edit, and enhance standard documents using Microsoft® Office Word 2003.

Persons with a basic understanding of Microsoft Windows who need to learn how to use Microsoft® Word 2003 to create, edit, format, lay out, and print standard business documents complete with tables and graphics. This course is intended for persons interested in pursuing Microsoft Office Specialist certification in Microsoft® Word 2003.

Advantage:
You should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders.

Upon successful completion of this course, students will be able to: · Create a basic document, Edit documents by locating and modifying text, Format text, Format paragraphs, Use Word tools to make your documents more accurate, Add tables, to a document, Add graphic elements to a document. Control a document's page setup and its overall appearance.

Lesson Structure:
Lesson 1: Creating a Basic Document :
Topic 1A: The Word Environment,
Topic 1B: Get Help Using Word,
Topic 1C: Enter Text,
Topic 1D: Save a New Document,
Topic 1E: Preview a Document,
Topic 1F: Print a Document

Lesson 2: Editing a Document :
Topic 2A: Navigate in a Document,
Topic 2B: Insert Text,
Topic 2C: Select Text,
Topic 2D: Create an AutoText Entry,
Topic 2E: Move and Copy Text,
Topic 2F: Delete Blocks of Text,
Topic 2G: Undo Changes,
Topic 2H: Find and Replace Text

Lesson 3: Formatting Text :
Topic 3A: Change Font and Size,
Topic 3B: Apply Font Styles and Effects ,
Topic 3C: Change Text Color,
Topic 3D: Highlight Text,
Topic 3E: Copy Formats,
Topic 3F: Clear Formatting,
Topic 3G: Find and Replace Text Formatting

Lesson 4: Formatting Paragraphs :
Topic 4A: Set Tabs,
Topic 4B: Change Paragraph Alignment ,
Topic 4C: Indent Paragraphs,
Topic 4D: Add Borders and Shading,
Topic 4E: Apply Styles,
Topic 4F: Create Lists,
Topic 4G: Change Spacing Between Paragraphs and Lines

Lesson 5: Proofing a Document :
Topic 5A: Use the Thesaurus,
Topic 5B: Check Spelling and Grammar ,
Topic 5C: Create a New Default Dictionary,
Topic 5D: Check Word Count,
Topic 5E: Modify a Document in Print Preview

Lesson 6: Adding Tables:
Topic 6A: Create a Table,
Topic 6B: Enter Data in a Table,
Topic 6C: AutoFormat a Table,
Topic 6D: Convert Text into a Table

Lesson 7: Inserting Graphic Elements,
Topic 7A: Insert Symbols and Special Characters,
Topic 7B: Insert a Clip Art Picture ,
Topic 7C: Add a Watermark

Lesson 8: Controlling Page Appearance:
Topic 8A: Set Page Orientation,
Topic 8B: Change Page Margins,
Topic 8C: Apply a Page Border,
Topic 8D: Add Headers and Footers,
Topic 8E: Insert a Page Break

 
BACK
 

Microsoft Excel 2003

You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format. In this course, you will use Microsoft® Office Excel 2003 to manage, edit, and print data.

You will create and edit basic Microsoft® Office Excel 2003 worksheets and workbooks.

Upon successful completion of this course, students will be able to:

  • create a basic worksheet.
  • modify a worksheet.
  • perform calculations.
  • format a worksheet.
  • develop a workbook.
  • print the contents of a workbook.
  • customize the layout of the Excel window.

Advantage:
To ensure your success, we recommend you first take the following course or have equivalent knowledge: Microsoft Office Windows XP: Introduction

If you have taken an introductory course for an earlier version of the Windows operating system, this will also be an advantage.

   
  • Training Course Overview/Content:
    Getting Started
    Enter data in a worksheet
    Edit data
    Change the appearance of data
    Save a workbook
  • Editing Your Worksheet
    Moving data to other cells
    Copy data to other cells
    Fill cells with a series of data
    Insert and delete rows and columns
    Undo and Redo an entry
    Find and replace numbers
    Enter data in a range
    Verify data in a range
  • Performing Calculations
    Sum a Range of Data
    Use a Built-in Function
    Copy a Formula
    Create an Absolute Reference
  • Formatting
    Number Formats
    Custom number formats
    Font Size and Type
    Styles
    Borders and Colours to cells
    Column Width and Height
    Align Cell Contents
    Merge and Center Cells
    AutoFormat
  • Working with multiple worksheets
    Format worksheets Tabs
    Reposition Worksheets in a workbook
    Copy Worksheets
  • Customising layout
    Split a worksheet
    Arrange worksheets
    Freeze and unfreeze rows and columns
    Hide & Unhide worksheets
  • Page Display & Printing Options
    Freeze rows and columns
    Print Title
    Set Page Margins
    Headers and Footers
    Page Orientation
    Insert and remove page breaks
    Print a range
 
   
BACK  
   

Microsoft Access 2003

Most organizations maintain and manage large amounts of information. One of the most efficient and powerful information management, computer based applications, is the relational database. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will be introduced to the concept of the relational database and the Microsoft ® Office Access 2003 relational database application and its information management tools.

You will be introduced to the features of the Microsoft ® Office Access 2003 application.

This course is designed for students who wish to learn the basic operations of the Microsoft Access Database program to perform their day to day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes. The Level 1 course is for the individual whose job responsibilities include working with tables to create and maintain records, locate records, and produce reports based on the information in the database. It also provides the fundamental knowledge and techniques needed to advance to more technical Access responsibilities, such as creating and maintaining new databases and using programming techniques that enhance Access applications.

   
  • An Overview of Access 2003
    Relational Databases
    Access Environment
    The Database Environment
    Examine an Access Table
  • Establishing Table Relationships
    Identify Table Relationships
    Identify Primary and Foreign Keys in the Relationships Window
    Working with Subdatasheets
  • Querying the Database
    The Select Query
    Add Criteria to a Query
    Add a Calculated Field to a Query
    Perform a Calculation on a Record Grouping
  • Managing Data
    Examine an Access Form
    Add and Delete Records
    Sort Records
    Display Record Sets
    Update Records
    Run a Report
  • Designing Forms
    Form Design Guidelines
    Create AutoForms
    Create a Form Using the Form Wizard
    Modify the Design of a Form
  • Producing Reports
    Create an AutoReport
    Create a Report by Using the Wizard
    Examine a Report in Design View
    Add a Calculated Field to a Report
    Modify the Format Properties of a Control
    AutoFormat a Report
    Adjust the Width of a Repor
 
BACK

Back To Top

 
Microsoft PowerPoint 2003
 
You will create effective basic Microsoft® Office PowerPoint® 2003 presentations for delivery in front of an audience.

Advantage:
To ensure your success, we recommend you first have equivalent knowledge Windows XP.


Lesson 1: An Orientation to PowerPoint :
Topic 1A: The PowerPoint Environment,
Topic 1B: Orientation to Views,
Topic 1C: Navigate Through a Presentation,
Topic 1D: Edit Slide Text,
Topic 1E: Save the Presentation,
Topic 1F: Run a Slide Show

Lesson 2: Beginning a Presentation:
Topic 2A: Create a New Presentation,
Topic 2B: Change Background Color,
Topic 2C: Add Slides to a Presentation,
Topic 2D: Enter Text,
Topic 2E: Create a Presentation from a Microsoft Word Outline

Lesson 3: Formatting Text Slides:
Topic 3A: Apply Character Formats,
Topic 3B: Align Text,
Topic 3C: Change Line Spacing,
Topic 3D: Change Indents

Lesson 4: Adding Tables to a Presentation:
Topic 4A: Create a Table,
Topic 4B: Format Tables,
Topic 4C: Insert a Table from Microsoft Word

Lesson 5: Charting Data :
Topic 5A: Create a Column Chart,
Topic 5B: Edit Chart Data,
Topic 5C: Change Chart Type,
Topic 5D: Insert a Chart from Microsoft Excel

Lesson 6: Modifying Objects:
Topic 6A: Resize Objects,
Topic 6B: Copy and Duplicate Objects,
Topic 6C: Move Objects,
Topic 6D: Changing Object Orientation,
Topic 6E: Format Objects,
Topic 6F: Group and Ungroup Objects,
Topic 6G: Change the Order of Objects

Lesson 7: Adding Images to a Presentation:
Topic 7A: Add Clip Art,
Topic 7B: Add a Picture from a File,
Topic 7C: Draw Lines and Shapes,
Topic 7D: Insert WordArt

Lesson 8: Preparing to Deliver a Presentation:
Topic 8A: Spell Check,
Topic 8B: Arrange Slides,
Topic 8C: Add Transitions,
Topic 8D: Create Speaker Notes,
Topic 8E: Send a Presentation to Microsoft Word,
Topic 8F: Print the Presentation,
Topic 8G: Package a Presentation for CD

Upon successful completion of this course, students will be able to: · Manipulate an existing PowerPoint presentation. Begin creating a presentation. Format text slides. Add tables to a presentation. Chart data in a presentation. · Modify objects on slides, Add images to a presentation. Prepare to deliver a presentation.

 
BACK

Back To Top

 

BASIC SKILLS:

  • Numeracy
  • Lit eracy
  • IT Literacy

Back To Top

EMPLOYMENT TRAINING LEVEL 1

  • Curriculum Vitae
  • Interview Skills
  • Job Search
  • Letter Writing

Back To Top

 
HOME| BACK