UCS Self Taught Training Programme

SVI workbook tutorials on the database package Microsoft Access 2003. Files for the exercises are provied on CDs.

This set of 3 CDs by LearnKey takes you step-by-step through the functions and features of Microsoft Access 2003.

This VTC Training CD can be used under Windows or on the Macintosh.

This is a set of 3 tutorials by Mac Pro Video on Logic, Apple's audio editor. The DVDs can be used on Macs (although advertised as being usable under Windows, we have had no success in doing so).

« Description not available »

This VTC Training CD can be used under Windows or on the Macintosh. Dreamweaver provides facilities for Web site design and production. It is curently the only tool to offer Roundtrip HTML between visual and source editing for fast creation of great looking, cross browser Web sites. Features include advanced table editing, site management tools, Dream Templates, and extensibility.

In Module 1 the candidate will learn about some of the main concepts of IT at a general level. The candidate will learn about the general make-up of a personal computer in terms of hardware and software and about some of the concepts of Information Technology (IT) such as data storage and memory. The candidate will also learn some basic troubleshooting concepts and techniques and how to identify the setup and components of their computer. The candidate will gain an appreciation of health and safety issues as well as some of the environmental factors involved in using computers. The candidate will also learn about some of the important security and legal issues associated with using computers.

• Chapter 1: General Concepts

• Chapter 2: Hardware

• Chapter 3: Basic System Maintenance

• Chapter 4: System Interrogation

• Chapter 5: The Use Of IT In Everyday Life

• Chapter 6: Health and Safety and the Environment

• Chapter 7: Security

• Chapter 8: Copyright And The Law

In Module 2 the candidate will learn about some of the common functions of a personal computer and its operating system. The candidate will learn how to adjust main settings, use the built in help features and deal with a non-responding application. The candidate will learn how to operate effectively within the desktop environment and work with desktop icons and windows. The candidate will learn how to manage and organise files and folders, and how to duplicate, move and delete files and folders, and how to compress and extract files. The candidate will also learn what a computer virus is and how to use anti-virus software. The candidate will also learn how to use simple editing tools and the print management facilities available within the operating system.

• Chapter 1: Getting Started

• Chapter 2: Working With A Window

• Chapter 3: Desktop Icons

• Chapter 4: Using Applications

• Chapter 5: Data Storage In Windows

• Chapter 6: Windows Explorer

• Chapter 7: Working With Folders

• Chapter 8: Disks

• Chapter 9: Working With Files

In Module 3 the candidate will learn about word processing and will be able to demonstrate the ability to use a word processing application on a computer. The candidate will be able to accomplish everyday tasks associated with creating, formatting and finishing small sized word processing documents ready for distribution. He or she will also be able to duplicate and move text within and between documents, and demonstrate competence in using some of the features associated with word processing applications such as creating standard tables, using pictures and images within a document, and using mail merge tools.

In Module 4 the candidate will learn about the concepts of spreadsheets and will be able to demonstrate the ability to use a spreadsheet on a computer. The candidate will be able to develop, format, modify and use a spreadsheet of limited scope ready for distribution. This will involve creating formulas and using standard functions, and creating and formatting charts/graphs.

This publication is intended for people who wish to prepare for Module 5 - Database of the ECDL/ICDL Syllabus (Version 4.5) using Microsoft Access 2007. In Module 5 the candidate will learn about the main concepts of databases and be able to demonstrate the ability to use a database on a computer. The candidate will be able to create and modify tables, queries, forms and reports, and prepare outputs ready for distribution. The candidate will be able to relate tables and retrieve and manipulate database information using the query and sort tools available in the application.

In Module 6 the candidate will learn about presentation software and will be able to demonstrate the ability to use a presentation application on a computer. The candidate will be able to create and modify presentations complete with text, charts, and images, run slide shows, and prepare outputs ready for showing or the printer.

Module 7 is made up of two sections. In the first section, the candidate will learn about some of the concepts and terms associated with the Internet, especially those associated with security. The candidate will learn how to perform some common Web search tasks using a Web browsing application and available search engine tools. The candidate will learn how to bookmark sites, and to print Web pages and search outputs. The candidate will also learn how to navigate within a Web site and complete Web-based forms. In the second section, the candidate will learn about some of the concepts associated with e-mail and gain an appreciation of email and security. The candidate will learn how to use e-mail software to send and receive messages and to work with message attachments.

« Description not available »

This set of 3 CDs by LearnKey takes you step-by-step through the functions and features of Microsoft Excel 2003.

SVI workbook tutorials on the spreadsheet package Microsoft Excel 2003. Files for the exercises are provided on CDs.

A set of 2-hour tutorials on CD-ROMs on Excel 2004 for the Macintosh; Hands-on exercises are not provided with this courseware.

This tutorial uses a workbook and exercises provided on a disk to introduce Microsoft Excel 2007 for Windows. The course gives an introduction to spreadsheets, databases and charting.

The skills and knowledge covered in this book are sufficient for real-world applications such as budgeting, analysing sales, producing reports, creating charts and graphs and managing small lists. This book is primarily designed for people who need to know how to use Microsoft Excel 2007 is designed for people new to the Excel environment. It is ideal for people who work in offices, clubs or charities where there is a requirement to produce reports, budgets and lists, using formulae for automated calculations and the like.

Watsonia workbook tutorials. Files for the exercises are provided on CDs.

This course shows you how to work more efficiently with workbooks and worksheets, enhance the appearance of data and worksheets, perform analysis using functions, and to use the sorting and filtering features to manage and analyse data. This course is intended for current Microsoft Excel 2007 users who wish to extend their knowledge and skills beyond building simple workbooks.

Watsonia workbook tutorials. Files for the exercises are provided on CDs.

This course covers aspects of Microsoft Excel beyond building basic workbooks and deals with automation and productivity features. It includes areas such as conditional formatting, validation and consolidation methods, data analysis tools, such as data tables, summarising, goal seeking and PivotTables, and ways of annotating worksheets to help when sharing information with others. This course is intended for current Microsoft Excel users who wish to extend their knowledge and skills beyond building and formatting simple workbooks.

Watsonia workbook tutorials. Files for the exercises are provided on CDs.

A set of 8 tutorials on FileMaker 7.0 from Studio eWorks for both Macintosh & PC. It is not necessary to have FileMaker installed.

Macromedia Flash MX is a tool for creating animated and interactive web content that is optimised for delivery. This VTC Training CD can be used under Windows or on the Macintosh.

The Computing Services Department of the University of Liverpool now offer their popular Fortran 90 and High Performance Fortran Courses in a new interactive Web-based HTML format. Both courses have a similar structure. A topic can be selected from the contents page which will display an overview of the selected subject. The user can then either follow a hypertext link to a more detailed explanation or, choose to attempt a programming exercise instead. After the user has finished the exercise, a solution may be viewed. In many cases the user can retrieve a solution template to help get started. Use of these courses for commercial purposes may be available upon request. The traditional paper-based versions of these courses have been used by many UK academic and research institutions and have received good reports - any feedback on the interactive HTML-based versions is strongly welcomed. The paper-based version are still available.

« Description not available »