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.
Here is a breakdown of the different course levels available.
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
- 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
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
In this course, you will create, format, edit, and share publications.
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.
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.
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.
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) :
- IT Users Fundamentals
- Setting Up IT Systems
- Optimise IT System
- Security for IT Users
- Communication Fundamentals
- Graphics Design
- Desktop Publishing
- IT Software Fundamentals
- CAD 2D
- CAD 3D
- Web Design
- Computerised Accounting
- Payroll Software
- Mobile Devices
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.
Duration: From 3 months to 2 years, depending on exit route – Certificate, Award or Diploma.