HVA, in partnership with O-Regen, will run several ICT sessions to promote the use of computers and IT in the voluntary sector to increase efficiency and effectiveness. For direct support and information on ICT developments click here
Find below a list of some ICT courses we will be running
1. Getting Started with Computers and the Internet
2. Getting To Grips with Windows, Microsoft Office and E-Mail
3. Mastering the Internet - Advanced Search Techniques
4. Microsoft Word (Introduction)
5. Microsoft Word (Intermediate)
6. Microsoft Word (Advanced)
7. Microsoft Excel (Introduction)
8. Microsoft Excel (Intermediate)
9. Microsoft Excel (Advanced)
10. Making Presentations with Microsoft PowerPoint
11. Microsoft PowerPoint (Introduction)
12. Microsoft PowerPoint (Intermediate)
13. Microsoft PowerPoint (Advanced)
14. Microsoft Publisher (Introduction)
15. Microsoft Access (Introduction)
________________________________________________________________
Getting Started with Computers and the Internet
Outline: Learn in a relaxed atmosphere - this course is for people starting out on computers. Assuming no prior knowledge, the trainer guides delegates through the basics of using a personal computer.
Who should attend? Anyone new to using personal computers
Course Objectives: Learn what the jargon means and how to use it if you are buying a PC. You will get a complete understanding of starting and stopping programs, creating and storing files and more importantly, finding them afterwards. Find out about the 'other' mouse button. You will also learn how to use the Internet to 'Surf' in a fun, easygoing way.
Course Overview:
Overview of the PC
Windows - understanding the desktop
Using the START Button and task bar
The Recycle and My Computer functions
Dialog boxes, text boxes, check boxes and radio buttons
Using mouse buttons and the keyboard
Starting programs & working with two applications concurrently
Getting help
Creating, storing, finding and deleting files
Copying files and printing
Understanding the Internet, browsing sites and searching
Back to the Top
Getting To Grips with Windows, Microsoft Office and E-Mail
Outline: This course is ideal for people looking to gain an understanding about how Microsoft Windows works. You will learn how to utilise the Windows desktop effectively and add shortcuts for frequent tasks. Discover the hidden secrets of the mouse using left click, right click, double click and click and drag. Create a personalised filing system for sorting all your work and discover how to find 'lost' files. Learn how to create a letter in Word and a spreadsheet in Excel. Find out how to send and receive emails including attaching files.
Who should attend? Anyone wishing to expand their knowledge of Microsoft Windows and intend to use Email and Microsoft Office.
Course Objectives: Understand what the Word and Excel programs are used for how to create letters, and a profit and loss spreadsheet which can be used in the home (financial planning) or business, How to send and receive email and use attachments to send files.
Course Overview:
Windows - Understanding the desktop
Using the Start button and the Taskbar
Using mouse buttons and Keyboard shortcuts
Starting programs and working with two concurrently
Creating, Sorting, Finding, Copying and Deleting files
Adding folders and filing
Introduction to Word
Utilising the menu bar and toolbar icons
Creating a letter
The Excel Window
Inserting Text, figures and formulae
Fundamentals of email
Sending, receiving and replying to mail
Attaching files to email
Deleting mail
Back to the Top
Mastering the Internet - Advanced Search Techniques
Outline: In this course you will learn the 5 Top Tips for search success, using your own examples carry out on-line searches and find exactly what you are looking for, instantly. You will also learn how to make effective use of Newsgroups. Learn how to send and receive email with attachments and many time saving tips for dealing with the ever-increasing problem of spam mail.
Who should attend? Individuals who recognise the importance of this business tool and want to harness it's potential. Those who may be familiar with the Internet but struggle to find what they need fast. The course is also ideal for those who wish to master email.
Course Overview:
What the Internet is and the role of Internet Service Providers (ISP), URLs and Domain names
Review of main Internet applications, World-Wide-Web, email, Newsgroups
Creating Bookmark lists of favourite sites
Deleting temporary files and clearing a history folder
Saving pages and images
Using Net Directories and Search Engines
The 5 Top tips for search success
Methods of dealing with spam
Searching the Newsgroups
Utilising email and adding attachments
Email a web page or hyperlink
Back to the Top
Microsoft Word (Introduction)
Outline: This course will provide you the necessary skills to type, save, and print letters, memos etc. No previous word processing experience is necessary. The course focuses on quick ways to select, edit and format text. You will learn how to give your work a professional finish. The course is full of 'time saving tips' including how to find files - and never lose them again!
Who should attend? No previous word processing experience is necessary.
Course Objectives: How to select, edit and format text, Learn how to give your work a professional finish, Learn 'time saving tips', including how to find files - and never lose them again
Course Overview:
Understanding the Microsoft Word Window, Using Help effectively
Opening and navigating through a document
Typing, saving and printing documents
Using drag and drop features
Using the dictionary to spell check using Autocorrect
Paragraph Indents
Using tabs
Creating tables
Altering the page layout
Back to the Top
Microsoft Word (Intermediate)
Outline: On this course you will learn how to teach Word your repetitive typing so that you never have to type it again.
Who should attend? This course is excellent for people who use Word frequently. An understanding of Word basics is required.
Course Objectives: Learn how to get Word to automatically number your paragraphs, create bullet points, bookmarks and tab stops, How to give IMPACT to your documents by adding colour and other great time saving tips like utilising Mail shots, How to organise your long documents using headers and footers
Course Overview:
Document navigation with bookmarks
Inserting and formatting tabs
Creating standard paragraphs
File management
Handling envelopes & labels
Using borders and shading
Paragraph numbering
Handling Bullet Points
Inserting headers and footers
Using Word Mail shot (Mail merge) features
Back to the Top
Microsoft Word (Advanced)
Outline: his course will enable you to use style sheets to apply formatting to longer documents, learn how to apply different page layouts or headers & footers in the same document.
Who should attend? Anyone wishing to maximise the benefit of Word features to automate tasks and enhance personal time management.
Course Objectives: How to get Word to automatically generate a table of contents, use Word fields, captions and footnotes, Gain an understanding of document outlining for major rewrites, How to create templates for telephone messages, faxes and memos, Learn how to apply document security and use Macros to automate repetitive or tedious tasks
Course Overview:
Creating templates
Using document styles to automate formatting
Outlining documents
Managing large documents with breaks
Handling different page layouts and headers and footers
Newspaper columns and news letters
Creating an automatic table of contents
Revision markers
Creating forms
Using OLE to link with other applications
Handling pictures with captions
Cross reference writing macros to automate tasks
Back to the Top
Microsoft Excel (Introduction)
Outline: This course focuses on quick ways to get started with Microsoft Excel. Packed with shortcuts and useful exercises the trainer guides delegates from a standing start through formulas and functions.
Who should attend? This course is suitable to complete beginners to Excel and also, because of the 'quick tips', for anyone who is self-taught.
Course Objectives: An appreciation of the layout and structure of the Microsoft Excel screen, A complete understanding of 'quick' editing techniques for data entry and filling formulas, How to create worksheets to compile sales figures, create purchase orders, bank statements and petty cash analysis, How to enhance those worksheets giving them a professional finish
Course Overview:
Microsoft Excel & Microsoft Office
Understanding the Excel Window
Calling on Help
Opening & navigating through a worksheet
Creating, saving and printing worksheets
Editing a worksheet
Changing the look of a worksheet
Formatting and manipulating data
Performing calculations with functions and formulas.
Quick data entry techniques
Introduction to graphs
Back to the Top
Microsoft Excel (Intermediate)
Outline: Building on your existing knowledge of Excel this course includes formulas that link worksheets together and linking workbooks.
Who should attend? This course is suitable for people who have attended the Introduction course or have sufficient knowledge and understanding of the basics of Excel.
Course Objectives: Getting Excel to make decisions using the 'If' function and conditional formatting, How to create templates for commonly used worksheets and protect data using the security features, Gain an insight into data tables and using Excel look up features to automate worksheets, How to create, build and customise graphs including plotting trend lines
Course Overview:
Review of Excel fundamentals
Building Three-dimensional worksheets
Worksheet templates
Protection and security
Grouping Worksheets
Data tables and lookup functions
Introduction to the 'If' function
Group and outline functions
Building graphs and using trend lines
Back to the Top
Microsoft Excel (Advanced)
Outline: This course focuses on advanced methods of data management using Microsoft Excel.
Who should attend? This course is suitable for people who have attended the Intermediate course or have good knowledge and understanding of Excel.
Course Objectives: How to summarise large workbooks, use analysis tools to forecast figures based on a range of scenarios and use consolidation to bring together information, Gain a better understanding of the database features, Learn how to apply filters and sort data into key elements, Find out how you can utilise advanced 'If' statements and macros to automate repetitive or tedious tasks
Course Overview:
Advanced 'If' statements
Count Functions
Data consolidation & Goal seeking
Data projection using 'What-if' scenarios
Data tables
Using the worksheet as a database
Data summarising with pivot tables
Using outlining to handle large worksheets
Using macros
Back to the Top
Making Presentations with Microsoft PowerPoint
Outline: Good presentation skills have always been important in organisations. Effective uses of the latest computer technology make your presentations dynamic and up to date. Microsoft PowerPoint is an excellent package capable of producing high quality presentations suitable for clients and colleagues. This course covers both how to create a PowerPoint presentation and how to deliver it effectively.
Who should attend? All those who need to prepare and deliver their own presentations in a variety of environments, from one-to-one demonstrations to conference sessions. A working knowledge of the Microsoft Windows environment is essential. During the course each delegate will have the opportunity to present a PowerPoint slide show to the group and have feedback on their performance.
Course Objectives: Setting objectives for the presentation , Planning and structuring , Getting and keeping attention , Designing professional presentations , Creating speaker notes and handouts, Running a slide show , Evaluating your own performance
Course Overview:
Setting the scene: Analysing the invited audience. Agreeing objectives. Logistics.
Preparation: Features and benefits. Structuring information. Sourcing information.
Getting and keeping attention: Strong beginnings. Writing demonstration files. Prompts and aids.
Utilising graphics software: Using graphics and logos. Text effects and fonts. Data charts and graphs.
Designing professional presentations: Slide options. Layout. Slide sorter. Transition effects. Speaker notes and handouts.
Presenting the show: Voice control. Working with the audience. Handling nerves.
Nobody is perfect: Handling objections. Recovering from disaster.
How did it go? Evaluating performance.
Putting it into practice: Each delegate presents to the group. Critique discussion.
Back to the Top
Microsoft PowerPoint (Introduction)
Outline:
Effective presentations are essential to get your message across. PowerPoint allows you to create professional, high quality presentations suitable for clients and colleagues with the minimum of time and effort.
Who should attend?
All individuals who prepare or oversee the preparation of presentations using Microsoft PowerPoint. A working knowledge of the Windows environment is essential.
Course Objectives: Create a presentation from scratch, Add a variety of slide types,
Print notes and handouts, Know how to present a slide show
Course Overview:
Creating presentations: Starting from scratch, using different slide layouts, creating and formatting text slides, text effects.
Using graphics and pictures: Creating and formatting drawing, inserting clip art objects, inserting other pictures, formatting graphics.
Organising the presentation: Slide sorter view, producing speaker notes and audience handouts, printing.
Running the slide show: Transition and animation effects
Back to the Top
Microsoft PowerPoint (Intermediate)
Outline:
This workshop is designed for delegates who have had some experience of using Microsoft PowerPoint to create or edit presentations, and who now wish to consolidate and build on their existing knowledge.
Who should attend?
All individuals who prepare or give presentations using Microsoft PowerPoint, and who have some experience of using it, but who may have been self-taught or attended the Introduction to PowerPoint course.
Course Objectives:
Creating and amending slides with a variety of styles and layout ,Adding further objects to slides ,Creating more sophisticated and impressive slide shows,
Course Overview:
Review basic PowerPoint features
Slide masters and slide designs
Creating a new template
Working in Outline view
Inserting and editing graphs
Creating and editing organisation charts
Creating and editing tables and spreadsheets
Creating flow diagrams
Manipulating objects - grouping, aligning, replicating
Adding animations for maximum impact
Running a slide show
Using slide show controls
Back to the Top
Microsoft PowerPoint (Advanced)
Outline: This workshop is designed for delegates to discover the more advanced features of PowerPoint. Delegates must have attended the Introduction to PowerPoint course or have a good working knowledge of PowerPoint.
Who should attend? All individuals who prepare or oversee the preparation of presentations using Microsoft PowerPoint and who wish to enhance their knowledge.
Course Objectives:
To understand and use the advanced features which MS PowerPoint allows access to
Course Overview:
Review basic PowerPoint features
Principles of good slide design
Creating high impact slides
Communicating the message effectively
Creating and customising templates, masters and backgrounds
Using tables to display data
Adding sounds, movies and graphics to slides
Importing and linking data from Excel to charts
Using hyperlinks
Creating action buttons
Importing and exporting slides to other software
Slide show features and controls
Back to the Top
Microsoft Publisher (Introduction)
Outline: This intensive course is designed to provide delegates with the basics of using Publisher. The features of Publisher enable the user to combine text with pictures and drawings on the screen to create a range of publications. There is ample opportunity to learn through practical experience by working on the specially prepared examples designed to help the delegate become confident and competent in using Publisher.
Who should attend? This course would benefit anyone new to desktop publishing with no or little experience of Microsoft Publisher.
Course Objectives: Produce professional publications including, flyers, newsletters and leaflets.
Course Overview:
Creating a new publication
Working with publication pages
Working with objects
Working with text
Working with tables
Working with graphics
Applying styles to pages
Background page elements
Create publications using wizards
Prepare publications for printing
Back to the Top
Microsoft Access (Introduction)
Outline: To become well-equipped with the necessary understanding and 'hands-on' skills to build a relational database, using Microsoft Access.
Who should attend? This course is for beginners who want to gain a basic understanding of Microsoft Access. Each delegate would need to do some reading on the database concepts and preparatory work which will be sent out. The course would be supported by follow-up visits to facilitate easy implementation.
Course Objectives:
Database concepts
Access basics
Creating databases
Working with fields and records
Querying tables
Creating and using forms
Creating and using reports
Importing and exporting objects
Creating Relational Databases
Working with Related Tables
Defining Data Entry Rules
Course Overview:
Database concepts and terminology
Starting with Access and the Access environment
Planning and designing databases
Getting Help
Closing a database and exiting Access
Exploring tables and forms
Exploring queries and reports
Creating a database
Using the Table Wizard and working in Design view
Changing the design of a table
Adding and deleting records
Finding and editing records
Sorting and filtering records
Viewing specific fields
Modifying query results and queries
Creating forms by using Auto Form
Using Form Wizard and working in Design view
Using the Report Wizard
Importing & Exporting Access objects
Relating Tables
Using the Lookup Wizard
Working with Input Masks
Setting Required Properties, Validation Rules and Lookup Fields
Back to the Top
Microsoft Access (Intermediate)
Outline: This course will provide you with the understanding and 'hands-on' ability to create advanced queries, forms and reports using Microsoft Access.
Who should attend? This course is suitable for people who have attended the Introduction course or have sufficient knowledge and understanding of the basic Access
Course Objectives:
Using Advanced Query Features
Creating Advanced Queries
Enhancing Forms
Using Advanced Report Features
Creating Charts
Advanced forms
Course Overview:
Joining Tables in Queries
Creating Calculated Fields
Using Action Queries
Summarising and Grouping Values
Creating Crosstab Queries
Using Parameter Queries
Using Indexes
Adding Graphics to a Form
Adding Calculations to a Form
Adding Combo Boxes to a Form
Adding Unbound Controls
Creating Customised Headers and Footers
Combining Values From Multiple Fields
Adding Calculated Values
Working with Subreports
Creating Charts in Forms
Creating Charts in Reports
Building a form based on joined tables
Automating data entry
Using grouped controls
Enhancing the user interface
Subforms
Back to the Top
Microsoft Access (Advanced)
Outline: This one-day course provides you with an understanding of macros, Access SQL and internet/security considerations with using Microsoft Access.
Who should attend? This course is suitable for people who have attended the Intermediate course or who have a strong knowledge and understanding of Excel.
Course Objectives:
Macros
Advanced Macros
Exploring Access SQL
Internet integration
Security fundamentals
Course Overview:
Creating and running macros
Attaching macros to events of database objects
Creating macros to provide user interaction
Creating macros that require user decision
Using AutoKeys and AutoExec macros
Identifying different clauses in an SQL statement
Writing SQL statements
Attaching an SQL statement to a database object
Working with Hyperlink fields
Working with data access pages
Securing databases
User-level security
Back to the Top
