IT Courses

European Computer Driving Licence | Word | Excel | Access | Powerpoint | Internet & e-mail | Beginner's basic course | Website construction | Linux Training, Information and Services | Special Courses, one to one training and bespoke training also available.

All IT courses conducted in Powys Training IT suites are small groups - no more than eight learners per group - to ensure high quality tuition.

To book on to any Powys Training IT course Please Phone: 0800 3280881 or click the contact details link for contact information.

All prices shown are for group courses at a Powys Training centre. One to one, one to two or training on the clients own premises POA.

Discounts may be available for large groups or block bookings, please contact the Powys Training Centre concerned.

The Microsoft Office Suite

Word - course content

Module 1 - full day - £90

Requirements: Able to use a mouse and have a basic working knowledge of the keyboard and Windows.

• Screen Views
• Font, Paragraph and Page formatting
• Paragraph Indents and spacing
• Document proofing and editing
• Margins, page breaks, headers and footers
• Format Painter
• Spelling, Grammar checking / set up and Thesaurus
• Auto Correct - switch off, add text and graphics
• Find and Replace
• Keyboard Shortcuts

Module 2 - full day - £90

Requirements: Some experience necessary (it is preferable to have taken Word Module 1).

• Creating and using Tabs
• Creating and using Tables
• Creating Customised Forms
• Creating and setting up Mailmerge (Form Letters & Labels)
• Envelope labeling (new)
• Graphics - inserting pictures, locking

Module 3 - full day - £90

Requirements: Experienced user (it is preferable to have taken Word Module 1)

• Creating Styles
• Dividing pages into Columns
• Using Outlining
• Section Breaks
• Columns
• Templates
• Charts
• Customisation Word – Toolbars, Menus

Module 4 - half day - £45

Requirements: Some experience necessary (it is preferable to have taken Word Module 1).

• Mail Merge
• Form Letters
• Envelopes & Labels

Excel - course content

Module 1 - full day - £90

Requirements: Able to use a mouse and have a basic working knowledge of Spreadsheets.

• Spreadsheet concept, Advantages of XL
• Screen layout, Toolbars, Moving around
• Cell References
• Data – Types, Entering, Selecting, Editing, and Deleting, Enter sequences
• Keyboard shortcuts
• Formulae - creating, using and replicating
• Functions - Using Autosum, statistical, Wizard
• Absolute references
• Presentation
• Printing documents

Module 2 - full day - £90

Requirements: Some experience necessary (it is preferable to have taken Excel Module 1).

• Recap Absolute References
• Naming and using named cells
• Commenting in cells
• Conditional Logic
• Creating embedded charts
• Linking and copying between worksheets
• Creating 3D formulae
• Using templates
• Toolbars – Intro Customising

Module 3 - full day - £90

Requirements: Experienced user (it is preferable to have taken Excel Modules 1 & 2).

• Overview of lists
• Custom sorting
• Filtering and advanced filtering
• Complex criteria
• Sorting filtered lists
• VLOOKUP
• HLOOKUP
• MATCH and INDEX
• Subtotals –and multiple column subtotals
• Sorting subtotal lists
• Nested subtotals
• Outlines
• Showing and hiding detail and outline symbols
• Creating a structure with groups of detail
  
  

  ---

Access - course content

Module 1 - full day - £90

Requirements: Able to use a mouse and have a basic working knowledge of Microsoft programs.

• What is a database?
• Data, Information and Computers
• Database Design
• Microsoft Access Commands
• Creating a New Database
• Creating a New Table Structure
• Opening and Closing Saved Tables and Databases
• Adding and deleting Fields in a Table
• Formatting the Fields in a Table
• Adjusting Column Widths and Row Heights
• Changing the Order of the Fields
• What is Query?
• Search Criteria
• Creating and Sorting Query
• Sorting Query
• Saving a Dynaset
• Selecting Data Using a Logical Operator
• Including Calculated Values and Fields
• Creating and Formatting New Report
• Headers and Footers
• Saving, Opening and Printing a Report
• Mailing Labels

Module 2 - full day - £90

Requirements: Refer to Module 1 - If you have knowledge of those areas then Module 2 may be appropriate (however it is preferable to have taken Access Module 1).

• Introduction
• Some Definitions
• Database Relationships
• Creating a New table Structure
• Adding, Formatting and Deleting Fields in a Table
• Adjusting Column Widths and Row Heights
• Changing the Order of Fields
• Setting and Deleting Relationships Between Tables
• Search Criteria and Creating a New Query
• Sorting Data – Creating a Sort Query
• Saving Queries and Dynasets
• Selecting Data Using a Relational Operator
• Selecting Data Using a Logical Operator
• Creating New Reports and Forms
• Adding and Saving New Records
• Changing Form Design
• Selecting, Resizing and Moving Controls
• Adding a Header and a Label
• Improving Its Looks
• Adding Command Buttons
  

  ---

PowerPoint - course content

Module 1 - Full day - £90

Requirements - basic keyboard skills and a working knowledge of windows

• An overview of Presentation Graphics and their use
• Using text functions
• Using Word Art
• Using drawing tools
• Importing and creating graphs and spreadsheets
• Importing and working with graphics and clip art
• Creating organisational charts
• Using templates
• Editing the slide master
• Setting up and running the slide show

  ---

  Internet & e-Mail - course content

  Module 1 -full day - £90

  Internet or e-Mail separate half day courses £45

  Requirements: basic keyboard and mouse skills + a working knowledge of Windows.

  Section One Internet

  • Brief history
  • Access to the Internet
  • Web addresses
  • Searching for a site
  • Understanding Hyperlinks
  • Hierarchical Directories & Search Engines
  • Speeding things up
  • File Transfer Protocol
  • Viruses

  Section Two E-Mail

  • e-Mail
  • Sending messages
  • Attaching files
  • Receiving your mail
  • Organising mail
  • Filtering mail
  • setting up the Address book
  • Using the Address book
    

  ---

  One day beginner's basic course Full day - £90 - course content

  • Hardware vs Software
  • Intro to Windows, Bootup and Desktop
  • Mouse Mastery and Essential keyboard keys
  • Starting up and Shutting down
  • Creating documents, Word Wrap, Paragraphs Saving a document
  • Editing – Replacing, Adding, Moving, Saving
  • Explorer Views, Tree Structure and Filing.
  • File icons and extensions and opening files
  • Creating Folders, Naming Files and Folders
  • Moving, Copying, Deleting, Restoring Files
  • Using Status Bar Statistics
    

    ---

    Website design and construction - Full day - £90

    Requirements: basic keyboard and mouse skills + a working knowledge of Windows.

    • http & html, basic explanation
    • Website design and layout
    • Web page basics
    • Understanding Web graphic formats
    • Importing graphics
    • Removing gif backgrounds
    • Text creation and fundamentals
    • Using Tables
    • Using Frames
    • Setting internal tags
    • Setting remote tags
    • Using mailto: and other control commands
    • Creating a Form
    • Accessing CGI commands from the cgi-bin
    • Using FTP to upload your site

    ---

    Special Courses, one to one training and bespoke training also available

    File Management - half day - £45

    This course is designed specifically to give the user a thorough knowledge of file management, how to sort your records effectively, where to, and where not to, save your work and how to automate filing systems.

    Document Presentation - full day - £90

    Using Word and Excel to produce documents. Including the linking of Excel charts and worksheets into a report in Word, inserting clipart and images, outlining and laying out the report in a professional manner

    Custom Courses

    Powys Training can provide courses customised to suit your needs in all of the above programmes and several others besides. For details contact your nearest Powys Training Centre.

    European Computer Driving License (ECDL)

    The European Computer Driving Licence is the European-wide qualification which enables people to demonstrate their competence in computer skills. Its aims are:

    • to raise the general level of competency in IT
    • to improve productivity at work
    • to enable employers to invest more efficiently in IT
    • and to ensure that best practice and quality issues are understood and implemented

How does it work?

The ECDL syllabus is designed to cover the key concepts of computing, its practical applications and their use in the workplace and society in general. It is broken down into seven modules, each of which must be passed before the European Computer Driving Licence certificate is awarded. European Computer Driving Licence is open to anyone - regardless of age, education, experience or background.

The Modules are:

Module 1: IT user Fundamentals
Module 2: Security for IT users
Module 3: Using e-mail and Internet
Module 4: Database software
Module 5: Presentation software
Module 6: Spreadsheet software
Module 7: word Processing software

Candidates will purchase a logbook listing all the modules. As they pass each module, the accredited testing body will sign the logbook. The modules may be taken in any order and over any period of time - even all at once - offering maximum flexibility. When all the modules have been successfully completed, the logbook is exchanged for a certificate. Users may, if they wish, just walk in off the street and take the tests. More likely, they will opt for courses based on the ECDL syllabus.

What are the benefits?

For the individual?

ECDL is designed to help people at work and at home. It will confirm to potential employers that the person has a professionally recognised, relevant and up-to-date qualification and it will assist in raising familiarity with the technology and its uses.

For the employer?

ECDL helps provide proof of competency in the computer skills of potential employees. Similarly, a company looking to train up its work force will want to ensure that the money they spend on courses is going to be well spent. The proliferation of different courses making varying claims, often without any objective evidence makes a daunting choice for employers and individuals alike.

How are people tested?

Testing can be carried out at any audited testing centre.

Why is ECDL so effective?

ECDL is not like any other qualification - although it utilises the positive aspects of the best. It is set to become the most widely recognised qualification in the field of work-related computer use, partly because it is targeted at the full spectrum of the population, and partly because of the support and monitoring of the organisations behind it

The Syllabus

The syllabus is designed by a panel of European experts. It will be regularly updated to ensure its relevance to the working world and the advances in technologies and practices.

Accreditation

Accreditation of testing centres is strictly controlled. Regular, rigorous audits of the centres will be carried out to ensure compliance with the syllabus and the appropriateness of the testing regimes. Whichever centre the individual uses to take their tests, standards and conformance will be guaranteed.

Conformance

Conformance with NVQs - ECDL has been designed to provide conformance with existing qualifications, including NVQs and other established keyboard tests.

The organisations behind ECDL represent the full spectrum of industry and academia. Moreover, it is fully supported by the European Union, thereby ensuring standards and levels of quality throughout Europe. The implementation of European Computer Driving Licence in the UK is being managed by the British Computer Society.

Powys Training are a registered centre for the delivery of the new European Computer Driving Licence qualification. for more information contact your nearest Powys Training Centre.

Linux Training, Information and Services

Linux is a Unix type Operating System with graphical interface similar to Windows or Mac OS.

In the last five years Linux has grown from a niche system, used mainly by computer boffins and enthusiasts, to a viable commercial computing environment, both on the server and, more recently, on the desktop. In fact, more than 80% of Web servers and 60% of production servers use some form of Linux as their operating system.

There are many applications available for the Linux platform, including Office type programmes and most other business tools. The Office tools on Linux are highly compatible with Microsoft Office tools with programmes like OpenOffice.org able to save and read Microsoft Office formats.

The biggest advantage of Linux and Linux based programmes, whether on the server or the desktop, is that they are released under the Gnu Public Licence (GPL) a system which means that the majority of these programmes are free or only incur a single payment (no multi-user licences).

To find out more about Linux and what it can do for your business contact Powys Training's Llandrindod Centre or ring Free-Phone: 0800 3280881

IT TRAINING FOR COMPANIES AND INDIVIDUALS.