City & Guilds Courses
INFOCLUB Ltd has been a partner of City & Guilds for over 27 years training over 10000 Students in Mauritius. The City & Guilds courses lead to Awards, Certificates and Diploma for IT Users.
View More Details

INTRODUCTION

INFOCLUB Ltd has been a partner of City & Guilds for over 27 years training over 10000 Students in Mauritius.

The City & Guilds courses lead to Awards, Certificates and Diploma for IT Users.

You can choose from a wide array of IT subjects and topics to build up your Diploma. City & Guilds helped numerous of our students start a Career in Web Development, IT Officers, Graphic Designer, Customer Support and much more.

The City & Guilds Qualification is suitable for anybody who uses IT whether at home or work. The flexible structure and assessment methods of the ITQ mean that it can be adapted for a variety of courses in the classroom or almost any workplace or job role as part of an intended career.

Infoclub offers City & Guilds modules that meet local demand for IT and employer needs, from courses for office automation to web development for businesses to keeping in touch using internet and email for the individuals.

COURSE LEVELS

Here is a breakdown of the different course levels available.

Level 1

A Level 1 user can make use of predefined or commonly used IT tools for activities that are straightforward or routine, identifying and using automated methods or alternative ways of working to improve productivity. Any aspect that is unfamiliar will require support and advice from other people.

Level 2

A Level 2 user can make use of predefined or commonly used IT tools for activities that are at times non-routine or unfamiliar, they will be able to devise solutions to use IT tools to improve productivity. Any aspect that is unfamiliar will require support and advice from other people.

Level 3

A Level 3 user can make use of predefined or commonly used IT tools for activities most of which are complex and non-routine, they will be able to devise solutions in the use of IT tools in order to improve productivity. They will take considerable responsibility and autonomy.

COURSES FROM CITY & GUILDS

Here is a breakdown of the courses provided by City & Guilds

This course is offered at Levels 1, 2 and 3 with typing speed ranging from 24 wpm to 50 wpm.

The course contents below will correspond to the level which you are studying.

Module 1: Text Basics

  • Typing the text, Alignment of text
  • Editing Text: Cut, Copy, Paste, Select All, Clear
  • Find & Replace

Module 2: Text Formatting and saving file

  • New, Open, Close, Save, Save As
  • Formatting Text: Font Size, Font Style
  • Font Color, Use the Bold, Italic, and Underline
  • Change the Text Case
  • Line spacing, Paragraph spacing
  • Shading text and paragraph
  • Working with Tabs and Indents

Module 3: Working with Objects

  • Shapes, Clipart and Picture, Word Art, Smart Art
  • Columns and Orderings – To Add Columns to a Document
  • Change the Order of Objects
  • Page Number, Date & Time
  • Inserting Text boxes
  • Inserting Word art
  • Inserting symbols
  • Inserting Chart

Module 4: Header & Footers

  • Inserting custom Header and Footer
  • Inserting objects in the header and footer
  • Add section break to a document

Module 5: Working with bullets and numbered lists

  • Multilevel numbering and Bulleting
    Creating List
  • Customizing List style
  • Page bordering
  • Page background

Module 6: Tables

  • Working with Tables, Table Formatting
  • Table Styles
  • Alignment option
  • Merge and split option

Module 7: Styles and Content

  • Using Build- in Styles, Modifying Styles
  • Creating Styles, Creating a list style
  • Table of contents and references
  • Adding internal references
  • Adding a Footnote
  • Adding Endnote

Module 8: Merging Documents

  • Typing new address list
  • Importing address list from Excel file
  • Write and insert field
  • Merging with outlook contact
  • Preview Result
  • Merging to envelopes
  • Merging to label
  • Setting rules for merges
  • Finish & Merge options

Module 9: Sharing and Maintaining Document

  • Changing Word Options
  • Changing the Proofing Tools
  • Managing Templates
  • Restricting Document Access
  • Using Protected View
  • Working with Templates
  • Managing Templates
  • Understanding building blocks

Module 10: Proofing the document

  • Check Spelling As You Type.
  • Mark Grammar Errors As You Type.
  • Setting AutoCorrect Options

Module 11: Printing

  • Page Setup, Setting margins
  • Print Preview, Print
  • Start-up with MS Excel, Quick review on MS Excel Customize Ribbon, Quick Access Toolbar, Mini Toolbar.
  • Introduction of Excel shortcut keys
  • Introduction to Excel Worksheet, Row, Column, Cells etc.
  • Use of Basic Operators Like: + – / * ^ %.
  • Introduction to the Data and Data Formats.
  • Copy, Cut, Paste, Hide, Unhide, Link the Data in Rows, Columns and Sheet.
  • Inserting, Deleting, Moving, and linking the data in between the multiple sheets.
  • Protection of Cells, Rows, Columns and Sheets.
  • Printer Properties and Page Setup (Page, Margin, Header/Footer and Sheet) for Printing.
  • Text Functions: Concatenate, Left, Mid, Right, Lower, Upper.
  • Date and Time Functions: Date, Datevalue, Day.
  • If, If with OR, If with AND, If with AND & OR, If with OR&AND.
  • Nested If (For Multiple Conditions), If condition used more than one time in the same formula.
  • Preparation of the TAX Calculation Sheet by Nested if
  • Use of Name Manager: Creating, Editing, and Deleting of Names.
  • Statistical Functions: Average, AverageA, Averageif, Averageifs, Count
  • Use of Sumif, Sumifs, Count if, Countifs.
  • Conditional formats, Data validation.
  • Lookup Functions: Discussion on Lookup Functions, Use of Lookup, Vlookup, Hlookup, Index, Indirect Match, Offset. Choose.
  • Use of Sorting to arrange the data in ascending and descending order. Addition and deletion of levels to sort the data on multiple parameters.
  • Use of Filter to extract the unique and desired data.
  • Import the data from the multiple applications to Excel.
  • Remove Duplicates from Data.
  • Use of Data Validation and Consolidation.
  • What if Analysis. Analysis of Data by using Scenario Manager and Data Table and Goad Seek.
  • Working With Charts: Detailed discussion on graphically presentation of Data by using Charts.
  • Presentation with different kind to Basic charts like Column Charts, Line Charts, Pie Charts, Bar Charts, Scatter Charts
  • Use of Sparkline to your Sheet, Interactive Sparklines
  • Pivot Table, Do the Multiple Field Setting in Pivot Table.
  • Start-up with Pivot charts.
  • Insert slicer in Pivot Table and Pivot charts.

Lesson 1: Getting Started with PowerPoint
Topic A: Navigate the PowerPoint Environment
Topic B: View and Navigate a Presentation
Topic C: Create and Save a PowerPoint Presentation
Topic D: Use PowerPoint Help

Lesson 2: Developing a PowerPoint Presentation
Topic A: Select a Presentation Type
Topic B: Edit Text
Topic C: Build a Presentation

Lesson 3: Performing Advanced Text Editing Operations
Topic A: Format Characters
Topic B: Format Paragraphs
Topic C: Format Text Boxes

Lesson 4: Adding Graphical Elements to Your Presentation
Topic A: Insert Images
Topic B: Insert Shapes

Lesson 5: Modifying Objects in Your Presentation
Topic A: Edit Objects
Topic B: Format Objects
Topic C: Group Objects
Topic D: Arrange Objects
Topic E: Animate Objects

Lesson 6: Adding Tables to Your Presentation
Topic A: Create a Table
Topic B: Format a Table
Topic C: Insert a Table from Other Microsoft Office Applications

Lesson 7: Adding Charts to Your Presentation
Topic A: Create a Chart
Topic B: Format a Chart
Topic C: Insert a Chart from Microsoft Excel

Lesson 8: Preparing to Deliver Your Presentation
Topic A: Review Your Presentation
Topic B: Apply Transitions
Topic C: Print Your Presentation
Topic D: Deliver Your Presentation

Course Content

Lesson 1: Getting Started with Access
Topic A: Orientation to Microsoft Access
Topic B: Create a Simple Access Database
Topic C: Get Help and Configure Options in Microsoft Access

Lesson 2: Working with Table Data
Topic A: Modify Table Data
Topic B: Sort and Filter Records

Lesson 3: Querying a Database
Topic A: Create Basic Queries
Topic B: Sort and Filter Data in a Query
Topic C: Perform Calculations in a Query

Lesson 4: Using Forms
Topic A: Create Basic Access Forms
Topic B: Work with Data on Access Forms

Lesson 5: Generating Reports
Topic A: Create a Report
Topic B: Add Controls to a Report
Topic C: Enhance the Appearance of a Report
Topic D: Prepare a Report for Print
Topic E: Organize Report Information
Topic F: Format Reports

Lesson 6 Designing a Relational Database
Topic A: Relational Database Design
Topic B: Create a Table
Topic C: Create Table Relationships

Lesson 7: Sharing Data Across Applications
Topic A: Import Data into Access
Topic B: Export Data to Text File Formats
Topic C: Export Access Data to Excel

Course Objectives
In this course, you will create, format, edit, and share publications.
You will:
Perform basic tasks in the Microsoft Publisher interface.
Add content to a publication.
Format text and paragraphs in a publication.
Manage text in a publication.
Work with graphics in a publication.
Prepare a publication for printing and sharing.

Target Student
This course is intended for persons in a variety of job roles such as publishing specialists, layout specialists, graphic designers, or any other knowledge workers who need to use Microsoft Office Publisher to create, lay out, edit, and share publications.

Prerequisites
To ensure your success in this course, you should have experience with basic Microsoft® Windows® 10 tasks and be comfortable in the Windows 10 environment.

Course Content

Lesson 1: Getting Started with Microsoft Publisher
Topic A: Navigate the Interface
Topic B: Customize the Publisher Interface
Topic C: Create a Publication

Lesson 2: Adding Content to a Publication
Topic A: Add Text to a Publication
Topic B: Add Pages and Picture Placeholders to a Publication
Topic C: Control the Display of Content in Text Boxes
Topic D: Apply Building Blocks to a Publication

Lesson 3: Formatting Text and Paragraphs in a Publication
Topic A: Format Text
Topic B: Format Paragraphs
Topic C: Apply Schemes

Lesson 4: Managing Text in a Publication
Topic A: Edit Text in a Publication
Topic B: Work with Tables
Topic C: Insert Symbols and Special Characters

Lesson 5: Working with Graphics in a Publication
Topic A: Insert Graphics in a Publication
Topic B: Customize the Appearance of Pictures

Lesson 6: Preparing a Publication for Sharing and Printing
Topic A: Check the Design of a Publication
Topic B: Save a Publication in Different Formats
Topic C: Print a Publication
Topic D: Share a Publication

This is a COMPULSORY module to complete a DIPLOMA for IT USERS from City & Guilds. The main topics will be:

  • Computer Components (hardware and software)
  • Operating Systems functions and operations
  • IT Security
  • Productivity tools in Windows OS
  • Productivity tools in Word
  • Productivity tools in Excel

 

The other modules available for you to complete your DIPLOMA for IT USERS are as follows (The syllabus for each module is provided on separate web pages) :

  1. IT Users Fundamentals
  2. Setting Up IT Systems
  3. Optimise IT System
  4. Security for IT Users
  5. Internet
  6. Email
  7. Communication Fundamentals
  8. Graphics Design
  9. Imaging
  10. Desktop Publishing
  11. Databases
  12. Multimedia
  13. IT Software Fundamentals
  14. CAD 2D
  15. CAD 3D
  16. Web Design
  17. Computerised Accounting
  18. Payroll Software
  19. Mobile Devices
  20. Others

COURSE ORGANISATION & TIMING

Our unique methodology includes in-class lectures, practical sessions, online coaching, past-papers and state of the art testing tools ensure that students get the best preparation for the examinations, which are set and marked by the City & Guilds UK three times per year. Locally, the exams are organized under the supervision of the MES.

Pre-requisite: None

Duration: From 3 months to 2 years, depending on exit route – Certificate, Award or Diploma.