UCS Self Taught Training 2014-15

The skills and knowledge covered in this publication are sufficient to create real-world presentations for sales, budgets, clubs, and more. In this course you will learn how to create a presentation, add animations, run a slide show, and print and publish presentations. This publication is primarily designed for people who need to know how to use Microsoft PowerPoint 2007 to create computer presentations. It is ideal for people who work in areas where presenting information is important.

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

The skills and knowledge covered in this publication are sufficient to build and enhance powerful, real-world presentations for sales, budgets, clubs, and more. In this course you will learn how to enhance text in a presentation, add a range of objects such as pictures and SmartArt drawings, and how to automate slide show presentations. This course is designed for people who need to enhance their current knowledge and skills in Microsoft PowerPoint 2007. It is ideal for people who work in areas where effective presenting of information is important.

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

Microsoft PowerPoint 2010 Level 1 is designed for users who are keen to learn how to use this application to present information.

The skills and knowledge acquired in Microsoft PowerPoint 2010 Level 1 are sufficient to be able to create real-world presentations. You will learn how to run a slide show, print and publish presentations. Files for the exercises are provided on CDs.

Microsoft PowerPoint 2010 Level 2 is designed for users who are keen to broaden their understanding and knowledge of the software. It is ideal for people who work in areas where effective presenting of information is important.

The skills and knowledge acquired in Microsoft PowerPoint 2010 Level 2 are sufficient to be able to build and enhance powerful, real-world presentations for sales, budgets, clubs, and more. In this course you will learn how to enhance text in a presentation, add media features, setup a slide show, and more.

The skills and knowledge covered in this publication will enable you to create macros, user defined functions, understand the VBA environment and use a range of programming techniques to develop automated solutions in Excel. This course is designed for proficient Excel users who wish to learn how to automate standard features and to develop programs in VBA.

This course is particularly designed for users who wish to learn how to use the inbuilt VBA programming language in Excel to enhance their worksheets and automate processes.

The skills and knowledge covered in this publication will enable you to create macros, user defined functions, understand the VBA environment and use a range of programming techniques to develop automated solutions in Excel. This course is designed for proficient Excel users who wish to learn how to automate standard features and to develop programs in VBA.

The skills and knowledge acquired in Project 2007 Module 1 take you from a complete beginner to good proficiency in using the software, sufficent for you to create a project plan to include creating tasks, their durations and relationships with other tasks; the assignment of resources and materials to tasks; entering costs, constraints and deadlines for tasks; monitoring the project and managing slippage.

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

The skills and knowledge acquired in Microsoft Project 2007 Part 2 follow on from the first course to consolidate your skills and then take you to a greater proficiency using the software. The format of the learning material and case study remains the same using Watsonia workbook tutorials. Files for the exercises are provided on CD.

This course is designed for people who need to know how to use Microsoft Project 2010 to manage projects and all elements such as tasks, resources, and costs, associated with projects.

The skills and knowledge acquired in this course are sufficient for the learner to be able to use Microsoft Project 2010 to create a new project, enter and work with tasks and resources, schedule and track a project, manage and monitor project costs, and print effective project information. Files for the exercises are provided on CD.

The skills and knowledge covered in this publication are sufficient to confidence in create real-world documents, including letters, memos, faxes, basic flyers, basic newsletters, calendars, envelopes and labels.

For those who are keen to learn how to create a range of business-based documents such as fliers, newsletters and labels.

The skills and knowledge acquired in Microsoft Publisher 2010 Level 1 are sufficient to be able to create real-world documents such as fliers, newsletters and labels.

The RDN (Resource Discovery Network) Virtual Training Suite is a JISC national initiative designed to offer free online training in Internet information skills to the higher and further education communities in the UK. It comprises a set of 1-hour tutorials delivered over the Web, each of which offers Internet skills training in a particular academic subject.

The tutorials, which include quizzes and interactive exercises, can be used by individuals as a "teach yourself" tool, or by lecturers, librarians or IT trainers wanting to teach Internet information skills to their students. The tutorials offer a subject-based approach to Internet skills training, enabling the user to tour key Internet resources and improve search skills, as well as need for critical evaluation of information on the Internet, and reflect on practical ways to use the Internet to support learning, teaching and research.

The Computing Service only runs courses on EndNote, not Reference Manager. However for people wishing to use the latter there are some online resources available.

Statistics for the Terrified is a common-sense basic guide to statistics, written in plain english with a minimum of mathematics (very little!). It makes statistics open to common sense. See online site Statistics for the Terrified

Access to the course contents is available on all MCS machines by following this pathway:

• Start:
• All Programs
• Speadsheets Maths and Statistics
• Statistics for the Terrified

This self-taught hands-on course gives a quick introduction to the Vi text editor, a widely available text editor for Unix (and other) systems.

This external Online Netskills Interactive Course (TONIC) is a web-based learning course on using the Internet. TONIC is an easy-to-understand, structured course, offering step-by-step, practical guidance on main Internet topics. The course is intended for beginners to networking who have some familiarity with computers. The course provides an introduction to the Internet and computer networks in general.

The skills and knowledge acquired in Microsoft Visio 2007 Module 1 are sufficient to be able to use and operate the software at an efficient level. Users will be taught to create organisational charts, draw Gantt charts and flowcharts. Many other chart types are available in Visio and the user will have gained sufficient skills to be able to create these.

Microsoft Visio 2010 Module 1 is designed for users who are keen to create a range of diagrams and drawings such as flowcharts, business diagrams, office floor plans, organisation charts, and the like.

The skills and knowledge acquired in Microsoft Visio 2010 Module 1 are sufficient to create real-world drawings using shapes, stencil connectors, pages, formatting options, grids, styles, and the printing features of Visio.

Particularly for users who are keen to extend their understanding and knowledge of the operating system software Microsoft Windows 7.

The skills and knowledge acquired in Microsoft Windows 7 Module 1 are sufficient to be able to use and operate the software to perform tasks that include starting applications, creating folders, copying and moving files, creating and using Libraries, perform searches and personalise Windows.

The skills and knowledge acquired in Microsoft Word 2007 Level 1 are sufficient to be able to use and operate the software at an efficient level.

Microsoft Word 2007 Level 1 focuses on basic document production using Microsoft Word 2007 and is designed to give the learner a sound understanding of how documents are created, formatted and printed.

The skills and knowledge acquired in Microsoft Word 2007 Level 2 are sufficient to be able to use and operate the software at an efficient level. Microsoft Word 2007 Level 2 extends the learners basic skills and knowledge of Microsoft Word 2007 and helps them create more intricate and varied documents. Existing skills and knowledge are enhanced by covering more advanced aspects of key topics such as formatting, tables, and lists, and new features such as merging, envelopes, sections, clip art and graphics are introduced.

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

This publication focuses on producing longer documents and includes key aspects such as creating a table of contents, indexing, creating cover pages, and more. This publication also focuses on document automation through the use of fields, forms and macros, and also deals with document change tracking and protection. Microsoft Word 2007 Level 3 is designed to provide the learner with advanced skills and knowledge in using Microsoft Word. This publication is ideal for people where there is a requirement to produce more intricate documents.

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

This course is designed for users new to Microsoft Word 2010 specifically and word processing in general.

This course aims to give a very good basic grounding in the use of Microsoft Word 2010 to create everyday documents required either at work or at home. The course begins by showing the user how to navigate around Microsoft Word 2010. It quickly gets the user to create a new document before getting into features such as formatting, printing and even creating tables.

Microsoft Word 2010 Level 2 is designed for Microsoft Word users who are keen to extend their understanding and knowledge of the software beyond basic document creation.

This course aims to enhance existing Microsoft Word skills by covering more specific documentation creation aspects such as working with multiple documents, formatting in tables, tab, lists, merging, section breaks, templates, and working with pictures and illustrations. Watsonia files for the exercises are provided on CDs.

Microsoft Word 2010 Level 3 is designed for users who are keen to extend their understanding and knowledge of Word beyond creating basic documents.

The skills and knowledge acquired in this course are sufficient to be able to use and operate the software at an advanced level especially as it relates to creating more complex documents and also automating document procedures.

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