|
Microsoft
Office 97
Word
Processing:
Course
Title:
Course
Code:
Word 97 Introduction
S71001
The
Word screen, help facilities, creating a new document, moving around
in a document, selecting/deleting text, inserting the date and time,
using the toolbars, undo/redo, saving/opening/closing a document,
previewing/printing, hard spaces/hyphens, formatting/indenting paragraphs,
line spacing, tabs, numbering/bullets, format painter, page layout
(margins, paper size/orientation, numbering, view), cut/copy/paste,
drag & drop editing, using multiple windows, finding/replacing
text, introduction to tables, labels, spell checking, autocorrect,
autoformat, changing fonts and text size, changing the appearance
of text, headers/footers, shortcut menus.
Word 97 Intermediate
S71002
Tables (entering text, inserting/deleting/moving/copying
rows and columns, performing calculations, entering/editing formula
and functions, changing column width and row height, table alignment,
borders and shading, autoformat, converting table to text and text
to table), creating and formatting newspaper style columns and converting
existing text, document sorting, mailmerge (creating main document
and datasources, toolbars, mergefields) thesaurus, grammar checker,
paragraph formatting (text flow, drop capitals, borders and shading,
lines), sections (margins, paper size, page layout, headers and footers
page numbering), pictures, clipart.
Word 97 Advanced S71003
Outlining (headings, body text, sub text, applying
styles, promoting/demoting, reorganising a document, compiling a table
of contents, printing an outline), master documents (creating master/sub
documents, re-arranging, splitting, merging, removing), DDE linking,
embedding, graphs, macros (recording, running, assigning to key combinations/toolbar
buttons), forms (text fields, check boxes, drop down lists, running
macros from forms), fillin command.
Spreadsheets:
Excel
97 Introduction S71004
The Excel screen, help facilities, toolbars, formula
bar, saving/opening/closing files, wizards, moving around worksheets,
selecting cells/ranges/sheets, rows/columns, undo/redo, renaming cells/sheets,
inserting, deleting, moving, copying, drag and drop, in cell editing,
numbers/text, formulae and functions, autosum, series, adjusting column
widths/row heights, formatting cells (number formats, custom number
formats, alignment of entries, fonts, borders and patterns) format
painter, drawing tools, text boxes, page layout, previewing/printing,
spell checker, views, auditing, finding/replacing, creating embedded
charts, chart sheets, formatting chart items and changing chart data.
Excel 97 Intermediate S71005
Logical and lookup functions (if, hlookup, vlookup),
outlining (automatic and manual) linking (using names in linking formula,
redirecting/ viewing/ opening/ updating links, linking to other applications)
embedding data and graphic objects, data consolidation, protection
(password, preventing files from being opened and changes from being
saved, hiding/unhiding), customisation of workspace settings and toolbars,
templates, lists (dataforms, sorting, filtering subtotals).
Excel 97 Advanced S71006
Creating & using styles (by definition, redefining),
Error handling and Auditing features (iserror function, tracer arrows
precedents, dependants) Pivot tables (creating, adding fields, subtotal
summary, refreshing, viewing, grouping, ungrouping) moving sheets
between workbooks, data analysis tools (goal seek, solver), scenarios,
notes, view manager, macros (creating, assigning, running, editing),
Additional functions (Transpose, Convert, Randbetween, Networkdays).
Graphics:
Powerpoint
97 Introduction S71007
Screen, toolbars, views (slide view, outline, slide
sorter view, notes view, slide show), working with slides, editing
slide masters, changing defaults for all presentations, creating a
custom template, slide layout, templates, working with text, title
text and body text, using the text tool, typing text into shapes,
making text word-wrap, text ruler, spell-check OLE objects, drawing
tools, terminology, boxes, ellipses & other autoshapes, resizing
objects, moving objects, connecting objects, rotate/flip, rotate or
flip a clip art object, inverting text objects, lines & arcs,
freeform tool, fills & shadows, changing object defaults, working
with objects.
Powerpoint 97 Intermediate S71008
Moving & aligning objects, stacking objects, cutting,
copying, pasting & duplicating objects, using clipart, inserting
clipart, replacing a clipart picture, re-sizing clipart, recolour
picture, creating graphs, inserting a graph, edit a graph, insert
a graph from excel, insert an excel worksheet, insert a word table,
organisation charts, formatting the organisation chart, wordart, create
animated slides, animate text and objects, animate the elements of
a chart, change the order in which animated objects appear on a slide,
add an effect to an animated object after it appears.
Powerpoint 97 Advanced S71009
Insert a video on a slide, insert music or sound on
a slide, insert a cd audio track on a slide, inserting a black slide
at the close of your presentation, running a presentation on screen,
transitions, bullet builds setting slide timings while rehersing,
custom shows, save as powerpoint show, tips for presentations, printing
a presentation, printing slides, shortcut keys, tips & hints,
design tips & hints, action buttons and hyperlinks, publishing
presentations on a Web Site.
Microsoft Office 2000, 2002 &
2003
Word
Processing:
Course
Title: Course
Code:
Word 2000/XP Introduction S01010
The Word screen, help facilities, creating a new document,
moving around in a document, selecting/deleting text, inserting the
date and time, using the toolbars, undo/redo, saving/opening/closing
a document, previewing/printing, hard spaces/hyphens, formatting/indenting
paragraphs, line spacing, tabs, numbering/bullets, format painter,
page layout (margins, paper size/orientation, numbering, view), cut/copy/paste,
drag & drop editing, using multiple windows, finding/replacing
text, introduction to tables, labels, spell checking, autocorrect,
autoformat, changing fonts and text size, changing the appearance
of text, headers/footers, shortcut menus.
Word 2000/XP Intermediate S01011
The Word screen, help facilities, creating a new document,
moving around in a document, selecting/deleting text, inserting the
date and time, using the toolbars, undo/redo, saving/opening/closing
a document, previewing/printing, hard spaces/hyphens, formatting/indenting
paragraphs, line spacing, tabs, numbering/bullets, format painter,
page layout (margins, paper size/orientation, numbering, view), cut/copy/paste,
drag & drop editing, using multiple windows, finding/replacing
text, introduction to tables, labels, spell checking, autocorrect,
autoformat, changing fonts and text size, changing the appearance
of text, headers/footers, shortcut menus.
Word 2000/XP Advanced S01012
Outlining (headings, body text, sub text, applying
styles, promoting/demoting, reorganising a document, compiling a table
of contents, printing an outline), master documents (creating master/sub
documents, re-arranging, splitting, merging, removing), DDE linking,
embedding, graphs, macros (recording, running, assigning to key combinations/toolbar
buttons), forms (text fields, check boxes, drop down lists, running
macros from forms), fillin command.
Spreadsheets:
Excel
2000/XP Introduction S01013
The Excel screen, help facilities, toolbars, formula
bar, saving/opening/closing files, wizards, moving around worksheets,
selecting cells/ranges/sheets, rows/columns, undo/redo, renaming cells/sheets,
inserting, deleting, moving, copying, drag and drop, in cell editing,
numbers/text, formulae and functions, autosum, series, adjusting column
widths/row heights, formatting cells (number formats, custom number
formats, alignment of entries, fonts, borders and patterns) format
painter, drawing tools, text boxes, page layout, previewing/printing,
spell checker, views, auditing, finding/replacing, creating embedded
charts, chart sheets, formatting chart items and changing chart data.
Excel 2000/XP Intermediate S01014
Logical and lookup functions (if, hlookup, vlookup),
outlining (automatic and manual) linking (using names in linking formula,
redirecting/ viewing/ opening/ updating links, linking to other applications)
embedding data and graphic objects, data consolidation, protection
(password, preventing files from being opened and changes from being
saved, hiding/unhiding), customisation of workspace settings and toolbars,
templates, lists (dataforms, sorting, filtering subtotals).
Excel 2000 Advanced S01015
Creating & using styles (by definition, redefining),
Error handling and Auditing features (iserror function, tracer arrows
precedents, dependants) Pivot tables (creating, adding fields, subtotal
summary, refreshing, viewing, grouping, ungrouping) moving sheets
between workbooks, data analysis tools (goal seek, solver), scenarios,
notes, view manager, macros (creating, assigning, running, editing),
Additional functions (Transpose, Convert, Randbetween, Networkdays).
Databases:
Access
97/2000/XP Introduction S01016
Database design, Access screen, creating/saving/opening/closing
databases, help facilities and cue cards, toolbars, wizards, creating
tables, adding fields/names/data-types/descriptions, inserting/deleting/rearranging
fields, primary key, field properties, saving table design, entering
data into datasheets, adding/editing/saving records, selecting data/rows/columns,
moving/copying/deleting data, datasheet view (moving columns, changing
column width, hiding/showing and freezing columns, changing font/row
height) saving table layout, finding/replacing data, filtering records,
creating queries (select, crosstab and parameter queries, renaming
fields, calculated fields, totals, combining text fields), relationships,
creating and using forms and reports.
Access
97/2000/XP Intermediate S01017
Advanced form design (adding controls, combo/list boxes,
subforms, expressions and functions), graphs, action queries, union
queries, advanced reporting (grouping data, running sum, percentages,
headers/footers, page numbering, sub reports, templates).
Access 2000/XP Advanced S01018
Macros (event properties, groups, actions and arguments,
referring to forms and reports, conditions, autokeys, autoexec) introduction
to Access Basic, customising menus/toolbars, database security, object
linking and embedding, mailmerge with Word.
Graphics:
Powerpoint
2000/XP Introduction
S01019
Screen, toolbars, views (slide view, outline, slide
sorter view, notes view, slide show), working with slides, editing
slide masters, changing defaults for all presentations, creating a
custom template, slide layout, templates, working with text, title
text and body text, using the text tool, typing text into shapes,
making text word-wrap, text ruler, spell-check OLE objects, drawing
tools, terminology, boxes, ellipses & other autoshapes, resizing
objects, moving objects, connecting objects, rotate/flip, rotate or
flip a clip art object, inverting text objects, lines & arcs,
freeform tool, fills & shadows, changing object defaults, working
with objects.
Powerpoint 2000/XP Intermediate
S01020
Moving & aligning objects, stacking objects, cutting,
copying, pasting & duplicating objects, using clipart, inserting
clipart, replacing a clipart picture, re-sizing clipart, recolour
picture, creating graphs, inserting a graph, edit a graph, insert
a graph from excel, insert an excel worksheet, insert a word table,
organisation charts, formatting the organisation chart, wordart, create
animated slides, animate text and objects, animate the elements of
a chart, change the order in which animated objects appear on a slide,
add an effect to an animated object after it appears.
Powerpoint 2000/XP Advanced S01021
Insert a video on a slide, insert music or sound on
a slide, insert a cd audio track on a slide, inserting a black slide
at the close of your presentation, running a presentation on screen,
transitions, bullet builds setting slide timings while rehersing,
custom shows, save as powerpoint show, tips for presentations, printing
a presentation, printing slides, shortcut keys, tips & hints,
design tips & hints, action buttons and hyperlinks, publishing
presentations on a Web Site.
Personal
Computers, Microsoft Windows 98, 2000, XP & 2003
Personal
Computers:
Course
Title: Course
Code:
Introduction to Personal Computers S11022
½ Day
History of personal computers, introduction to the
hardware (disk drives, monitor, keyboard, mouse), printers, the operating
system, the concept of files, directories, diskettes (handling, formatting),
types of storage media, care of p/c's, backups/restore, overview of
word processing, spreadsheet and database software packages, data
protection.
Microsoft Windows:
Introduction to Windows 98
S81023
½ Day
The environment, (screen, mouse, start button, taskbar),
working with windows (moving, sizing, minimise/maximise, restore,
close, scrollbars, cascading), the toolbar, menus and right clicks,
working with groups (programs, my documents, settings, control panel,
printers), the desktop, help facilities, wordpad, explorer, organising
files and folders (creating, deleting, copying & moving).
Introduction to Windows
2000/XP/2003 S01024
½ Day
The environment, (screen, mouse, start button, taskbar),
working with windows (moving, sizing, minimise/maximise, restore,
close, scrollbars, cascading), the toolbar, menus and right clicks,
working with groups (programs, my documents, settings, control panel,
printers), the desktop (my computer, the briefcase, network neighbourhood,
recycle bin), help facilities, wordpad, explorer, organising files
and folders (creating, deleting, copying & moving), formatting
disks, find, shortcut methods, changing the start button, data integrity
(scandisk, defrag), exiting Windows.
Desktop
Publishing
Microsoft
Publisher:
Course
Title: Course
Code:
Publisher 98/2000/2002/2003 Introduction
S01025
Overview, the Publisher screen, help facilities, starting
a new publication, saving, closing, opening, design considerations
and steps, margins, grids, column grids, horizontal grids, page set-up,
adding/editing text, fonts, spacing, formatting text picture overview,
characters, drawing tools, tabs, tables overview, creating/adding
text to a table, printing.
Publisher 98/2000/2002/2003
Intermediate S01026
Text flow, picture revisited, picture frames revisited,
adding/editing/positioning pictures, special characters, more drawing
tools, more tables,changing/enhancingtables, wordart, bulleted lists,
styles, backgrounds, spell checking, find and replace.
Publisher 98/2000/2002/2003
Advanced S01027
Graphic & typographic design techniuques, the psychology
of visual comunication, how people perceive and evaluate what they
see, getting your message across, reprduction considerations, liasing
with your printing company, the design gallery, links with other applications,Publisher
and the Web.
General Computing Courses
Microsoft
Outlook:
Course
Title: Course
Code:
Outlook 97 Introduction S71028
Overview of Outlook 97, Composing and Sending messages,
Working with messages, Message Options, Working with address books,
Recalling and printing, Message handling options, Inserting text into
a message, Creating Signatures, Scheduling appointments, Assigning
categories, Editing appointments,Adding and editing contacts, Working
with File Attachments.
Outlook 98 Introduction S81029
Overview of Outlook 98, Overview of Outlook Today,
Creating and sending messages, Acting on messages, Working with address
books, Recalling and printing, Message handling options, Inserting
text into a message, Creating Signatures, Creating and using personal
folders, Using the Organise Page, Scheduling appointments, Assigning
categories, Editing appointments, Inserting events, Creating and sending
meeting requests, Working with meeting requests, Managing meeting
responses, Managing tasks, Adding and editing contacts, More about
File Attachments.
Outlook 2000/XP Introduction S01030
Overview of Outlook 2000, Composing and Sending messages,
Working with messages, Working with Message Options, Working with
address books, Recalling and printing, Message handling options, Inserting
text into a message, Scheduling appointments, Editing appointments,Adding
and editing contacts.
Outlook 2000/XP Intermediate S01031
Refreshing Introductory skills, Overview of the Outlook
2000 expanded functions, Working with Categories, More about contacts,
Using the Organise Page, Scheduling appointments, Assigning categories,
Editing appointments, Inserting events, Creating and sending meeting
requests, Working with the Task List.
Outlook 2000/XP Advanced S01031
Refreshing Intermediate skills, Creating and sending
meeting requests, Working with meeting requests, Managing meeting
responses, Managing tasks, Microsoft Exchange Server Options, Out
of Office Rules, Out of Office Rules Wizard, Working with the Journal,
Working with Notes, Working with Personal and Public Folders, Attaching
and Inserting Outlook Objects
General
Computing Courses
Microsoft
Project 98:
Course
Title: Course
Code:
Project 98 Introduction S81033
Fundamentals of project management & the Project
'Life-cycle', examining MS Project, overview of the planning process,
defining project tasks & information, linking tasks and observing
the critical path, modifying task relationships, constraints, organising
the task list into an outline, viewing levels of detail, creating/assigning
a base calendar, entering and assigning resources, working with project
costs, resolving time restrictions/resource conflicts, exploring views,
generating project reports, sorting/filtering project data, creating
custom filters.
Project 98 Intermediate/Advanced
S81034
Reviewing the project management process, creating
a baseline plan, previewing a baseline report, modifying the environment
for tracking, entering data for completed tasks, entering actual data
for tasks in progress, adjusting the schedule of future tasks, setting/displaying
an interim plan, working-hour considerations, customising resource
reports, adding a sub project to a master project, working with multiple
projects that share the same resource pool, importing/exporting data,
working with views/toolbars and global settings.
Microsoft
Project 2000:
Course
Title: Course
Code:
Project 2000/2002 Introduction S01035
Fundamentals of project management & the Project
'Life-cycle', examining MS Project, overview of the planning process,
defining project tasks & information, linking tasks and observing
the critical path, modifying task relationships, constraints, organising
the task list into an outline, viewing levels of detail, creating/assigning
a base calendar, entering and assigning resources, working with project
costs, resolving time restrictions/resource conflicts, exploring views,
generating project reports, sorting/filtering project data, creating
custom filters.
Project 2000/2002 Intermediate/Advanced
S01036
Reviewing the project management process, creating
a baseline plan, previewing a baseline report, modifying the environment
for tracking, entering data for completed tasks, entering actual data
for tasks in progress, adjusting the schedule of future tasks, setting/displaying
an interim plan, working-hour considerations, customising resource
reports, adding a sub project to a master project, working with multiple
projects that share the same resource pool, importing/exporting data,
working with views/toolbars and global settings.
General
Computing Courses
Adobe
Acrobat v4.00 v5.00 & v600:
Course
Title: Course
Code:
Adobe Acrobat: Portable Document Files S11037
What is Adobe Acrobat? Which version does what? What
is a pdf file? Why are they used? Versions how is a file converted
to the pdf format? The adobe acrobat create dialog box, pdf distiller
and writer, preparing word and excel files for conversion, avoiding
the need to scroll in a pdf file, orientation of the original file,
if the file still requires scrolling, inserting hyperlinks into an
original file that still work in the pdf version, hyperlink "pros"
and "cons", inserting hyperlinks into original files prior
to conversion to the pdf format, differences in word and excel files,
managing pdf documents, printing pdf documents, amending pdf documents,
annotating pdf documents, inserting, extracting and deleting document
pages.
Paint
Shop Pro: Manipulating and Managing Images:
Course
Title: Course
Code:
Paint Shop Pro v6.0 & v7.0 S11038
What is Paint Shop Pro and what does it do? Tool Palettes
and options, colours, palettes, colour specifications for RGB/HSL
and hexadecimal Web Page use, colour depth and resolution, pixels
and screen settings, changing image contrast, brightness and colours,
special visual effects, image layers, cutting, copying and pasting
images and layers, graphic file types, graphic file types and Web
Page considerations, GIFs and JPGs, animating images and Web Sites,
text and buttons, "vector" image, special effects, selecting
parts of an image, rotating and "flipping" images.
Graphic
Design:
Course
Title: Course
Code:
Graphic Design in Information Technology
S11039
What is Graphic Design? Differences between Graphic
Design on Paper and on the screen, the psychology of vision and perception,
"I'm no designer, but I know what I like!", what factors
influence Graphic Design? PC software packages that permit Graphic
Design, am I likely to have those pages? Types of Graphic Design software
packages, terminology, acquiring images, what are digital cameras
and scanners? Colour depth and resolution, graphic file types, space
and performance considerations for files containing graphics, reproducing
your designs, Graphic Design and Internet Web Sites.
Digital
Information Technology Equipment:
Course
Title: Course
Code:
Introduction to Digital Cameras and Scanners
S11040
What do I use Digital Cameras and Scanners for? How
do Digital Cameras differ from regular Cameras? How good are the ones
I got with my computer, basic photographic techniques and skills,
how do I decide which equipment suits my needs? Digital cameras, Web
Camera and videophone hardware and software, Scanner hardware and
software, how do I install my equipment? How do I install my software?
Do I always get everything I need when I buy my equipment, terminology,
what is a USB port? What does TWAIN mean? Types of digital image files,
colour depth and resolution, what are pixels? Converting images from
one type to another, setting your scanner options, differences between
B&W, colour and line drawings when setting scanner options, what
does "dots per inch" mean? How do I select which "dots
per inch" setting to use? How do I get my equipment to work with
my software? Care and maintenance of your equipment.
Internet,
Web Site Design and Email
Introduction
to the Internet and Email including World Wide Web (WWW) Essentials
Course
Title: Course
Code:
Introduction to the Internet and Email S11041/S11043
What is the Internet? A history of the Internet. What
do I need to access the internet? Specification for PCs accessing
the internet. How do I obtain the software package I need for Internet
access. Terminology. What is a Web Browser? What is a Web Site? What
is a Home Page? What is an Internet address? What does http:// mean?
What is a domain and what does .co.uk and .com mean? What is email
and how can I access that as well as a Web Site? What do organisations
such as AOL do? How does my PC access the Internet and run my email?
Who is handling my email messages? Deaning with incoming messages,
message folders & organising your messages, deleting and moving
your messages, composing & sending messages, attaching files to
messages, saving files attahed to incoming message, sending messages
with pictures.
Web
Site Design:
Course
Title: Course
Code:
Introduction to Web Site Design S11043
Web Site structure and pre-requisites, why do I need
a Web Site? Web Sites for commercial use, your Web Site as a part
of your marketing strategy. What can I include in my Web Site? Overview
to Text, Images, Tables and Files. What does a Web Site consist of?
Terminology. What is HTML? What does http:// mean? What are Links?
The five types of Links explained. What are Web Pages? The Web Site
as an electronic book, deciding on the number of Web Pages in your
Web Site, Web Site navigation and Links, inserting Web Page, background
images, inserting images within Web Pages, manipulating images, choosing
the appropriate image type, Web Page "anatomy", positioning
Text and Images on Web Pages, using Tables to control the layout of
your Web Pages, what is and is not possible on a Web Page, Web Page
Graphic Design considerations, designing your Web Pages so as to present
a coherent Web Site, using Web Page content to capture your visitor's
interest, writing your own Web Page HTML code, using software to write
code for you. Which package do I need to write HTML? Am I likely to
already have that package? How do I view my pages when I design them?
Which packages that I may already have can help me when designing
my Web Pages? Are special Web Site design packages available? What
are they and can I afford them and do I really need them? Testing
my site, selecting an ISP, deciding on a domain name and type, checking
already registered domain names, using a File Transfer Protocol package
to publish your site and domain on your ISP's system, publicising
your new site, maintaining your site, costs. What is a search engine
and do I need to register with one?
Internet, Web Site Design and Email
Third
Party Web Site Design Application Courses:
Course
Title:
Course Code:
FrontPage 98 Introduction S11044
What is possible & what is not, Viewing a completed
Web Site, Using the FrontPage Explorer Using the FrontPage Editor,
Web Page anatomy, Web Page Elements, Creating a Web Page, Applying
a Theme, Formatting Text, Inserting Images, Overview of Page Navigation
& Links, Types of Links, Creating Internal Links, Overview of
Web Site Publishing.
FrontPage
98 Intermediate S11045
More about Image, Background Images, page images, background
colours, text attributes, Links revisited, testing & revising
links, Text Link colours, using images as Link Objects, Image Maps,
Creating a Navigation Bar, Adding Web Extras, Text Animations, Scrolling
Text, Creating Tables, using Tables to control page text, Tables,
Table Tag Attributes, Modifying the HTML code yourself.
FrontPage
98 Advanced S11046
Tables Revisted, Drawing Tables, Working with Page
Frames, Creating & Modifying Frames, Working with Forms, Forms,
Search Forms, Assigning Web Tasks, Importing Data Working with Databases,
Static & Dynamic Web Pages, Publishing your Web Site, Image Types,
Colour Depth & Resolution, Hyperlink Images, Hotspots, Hover Functions,
Rollover Images, Page Transition.
Proprietary Web Site Design Application Courses
FrontPage 2000 Introduction S11047
What is possible & what is not, Viewing a completed
Web Site, Using the FrontPage Explorer Using the FrontPage Editor,
Web Page anatomy, Web Page Elements, Creating a Web Page, Applying
a Theme, Formatting Text, Inserting Images, Overview of Page Navigation
& Links, Types of Links, Creating Internal Links, Overview of
Web Site Publishing.
FrontPage
2000 Intermediate S11048
More about Image, Background Images, page images, background
colours, text attributes, Links revisited, testing & revising
links, Text Link colours, using images as Link Objects, Image Maps,
Creating a Navigation Bar, Adding Web Extras, Text Animations, Scrolling
Text, Creating Tables, using Tables to control page text, Tables,
Table Tag Attributes, Modifying the HTML code yourself.
FrontPage
2000 Advanced S11049
Tables Revisted, Drawing Tables, Working with Page
Frames, Creating & Modifying Frames, Working with Forms, Forms,
Search Forms, Assigning Web Tasks, Importing Data Working with Databases,
Static & Dynamic Web Pages, Publishing your Web Site, Image Types,
Colour Depth & Resolution, Hyperlink Images, Hotspots, Hover Functions,
Rollover Images, Page Transition.
|