The catalyst for partnership in learning and skills

Data Space Course Outlines

IT for Administrators - 1 day

Using MS-Outlook:

Creating e-mail
Organising e-mail
Dealing with attachments in e-mail
The Journal
Address books
Arranging meeting/appointments
Booking resources
Task lists

Using WORD

Collaborative documents
Versions and security
Using e-mail from Word
Using shared folders & Intranet

Getting the most out of MS-Office for course delivery - 1 day

Learn how to use Word, Publisher, PowerPoint and Excel to help with producing dynamic and effective course materials and with their delivery. Once you know the tricks, you can easily prepare PowerPoint presentations from your Word documents, as well as Intranet pages. Your forms and assessment questions can be prepared so that they can be used on-line as well as in printed form.

Producing handouts and information sheets using Word and Publisher
Designing and using multiple choice question forms with Word and Excel (both printed and on-screen)
Producing Intranet pages for information and question/answer
Producing effective presentations using PowerPoint (presenter controlled and autonomous/kiosk style)
Effective Intranet presentations using PowerPoint

Making your presentations exciting using PowerPoint - 1 day

PowerPoint is capable of much more than just simple 'slides'. Learn how to keep your audience awake and paying attention by using all the multi-media features in PowerPoint. Also, learn how to produce Web based presentations and get the best from printed output in PowerPoint.

Using good design to capture attention
Effective use of pictures and graphics
The rights and wrongs of inserting from Word and Excel
How to use slide transitions to best effect
When and how to use movies and sounds
Creating self-running presentations
How to create presentations for the Intranet

Word, merging and forms - 1 day

Making Word merging easy
Merging from Excel, Access and SQL server
Using your Outlook Contacts in for letters
How to design and use Word labels
The ways to avoid merge problems
Using headed paper and continuation sheets for form letters
Mass e-mailing and faxing with mail merge

Administering PCs for Training and Teaching for IT teachers and support staff - 2 days

If you don't have the IT support staff available then help yourself by learning some of the tricks to maintain your student PCs in a useable state. You will learn how to save and reinstall a 'standard' PC setup, and how you can make it more difficult for students to alter any settings.

How to ensure and maintain a consistent setup for users
How to save and restore configurations
How to prevent users from tinkering with settings
Dual booting to support 2 versions of Windows
Users and Domains, how they work and how to control
Software installation from a central source and how to setup
Using free remote control and support tools to help (eg VNC, NetMeeting)
Saving and restoring complete PC hard drive images using free tools
Saving and restoring PC images using Norton Ghost & PowerQuest Drive Image

Using Word for Intranet and Internet Page production - 1 day

If you want to produce a web page quickly, then Word can save you having to learn a new program. Building on your experience with Word, you will learn how to produce good looking web pages for your Intranet or the Internet in a day!

Fundamentals of good design
Simple quick pages using built-in templates
Dealing with pictures
Adding navigation features
Uploading options

Introduction to Programming MS-Office Applications with Visual Basic for Applications (VBA) - 2 days

You have all the power of Visual Basic with MS-Office free! Now learn how to use this to get the best from Word, Excel etc, and how to automate those boring and repetitive tasks in your Office application by using macros and programs.

Automate mail-merges, data processing, report production and other repetitive tasks.
Design and implement your own 'front ends' for Excel and Word use.
Produce 'intelligent' on-line forms in Word and Excel.
Go from data to graphs, charts and neat output automatically in Excel

Integrating your Documents, Data, Presentations and Spreadsheets using MS-Office - 1 day

Microsoft Office has lots of integration features, but they can be tricky to use. Learn how to get those spreadsheets into Word, how to produce PowerPoint slides from Word or Excel and all the copy and paste options - vital to prevent document ‘bloat’. Also, see how you can produce automated documents so that reports in Word can be linked actively to Excel spreadsheets and more.

You’ve got the office software – now get the best out of it!
Moving information between MS-Office applications
The perils of cut and paste
Using hyperlinks effectively
Using MS-Query to get information into Word and Excel
Converting Word and Excel information into PowerPoint presentations
Using File Properties to help you keep track
Finding your MS-Office documents (using Find in MS-Office)
Moving files to and from the Intranet

Managing Reports, Books and Documents with Word - 1 day

If you want to produce large documents in a corporate style, automatically generate tables of contents and glossaries, and effectively manage the creation and on-going version control of large Word documents, this event is for you.

Using styles and templates effectively
Customising Word for efficient document management
Using the Outline view
How to use document sections
Sophisticated headers and footers
Inserting tables of contents (TOC)
Using bookmarks and inserting indexes
Document map view
Boiler-plating documents

Creating Newsletters and Flyers using Publisher - 1 day

Using Microsoft Publisher with the built-in templates and resources makes producing flyers and newsletters quick and easy. If you need to make your information sheets eye-catching as well as informative, then this one-day course will give you a head start.

Basic design
How to make a newsletter interesting and readable
Dealing with text from Word and other programs
Importing, and using graphics, pictures etc.
Using Publishers templates
Advanced printing, eg folded publications
Making the output suitable for commercial printing

More IT for Administrators - 1 day

Outlook

‘Advanced’ features how they can help organise your mail, calendar and contacts
Setting up Outlook vies so you see what you want

Word

How styles and templates can save you work
More on reviewing and mailing lists, so paper copies of documents don’t need to be circulated

Scanners

How to get the best out of them and use them to save paper

Images and Pictures

How to e-mail and store

Sharing

How shared folders and resources can save paper

Visual Basic v6 - An Introduction - 3 days

This course is designed for delegates who are new to programming or Visual Basic and wish to gain an insight into producing simple applications.

Introduction

Microsoft Visual Basic features and editions
Event-driven programming
Reference materials

Fundamentals

Introduction to objects, properties methods and events
Working with forms

Working with Code and Forms

Understanding modules
Using the code editor window
Code documentation and formatting
Setting environment and code formatting options
Automatic code completion features
Interacting with the user; using the InputBox function