UIS Self Taught Training 2018-19

• The Microsoft Office 365 Training Centre offers a range of introductory training videos and tutorials for Microsoft PowerPoint.

• Please note: The majority of the training available is also applicable to Microsoft PowerPoint 2016.

• The Microsoft Office 365 Training Centre offers a range of introductory training videos and tutorials for Microsoft SharePoint Online.

• The Microsoft Office 365 Training Centre offers a range of introductory training videos and tutorials for Microsoft Word.

• Please note: The majority of the training available is also applicable to Microsoft Word 2016.

• The Microsoft Office 365 Training Centre offers a range of introductory training videos and tutorials for Yammer.

The skills and knowledge acquired in Microsoft Office Online are sufficient to be able to use and operate the applications in the Microsoft Office Online suite effectively including how to access the applications, create and share files, use the applications in conjunction with other programs and services and much more.

The skills acquired by working through this publication will enable you to effectively use Microsoft OneNote 2013 to research, capture, organise and share information.

The skills acquired by working through this publication will enable you to effectively use Microsoft OneNote 2016 to research, capture, organise and share information.

The skills and knowledge acquired in Microsoft Outlook 2013 - Level 1 are sufficient to be able to send and receive emails, schedule appointments and maintain contact details information.

The skills and knowledge acquired in Microsoft Outlook 2013 - Level 2 are sufficient to be able to manage and organise your e-mail, schedule meetings with colleagues, manage your contact information, create task requests for others to perform and much more.

Microsoft Outlook 2016 - Level 1 enables users to be able to send and receive emails, schedule appointments and maintain contact details information.

Microsoft Outlook 2016 - Level 2 enables users to be able to manage and organise your e-mail, schedule meetings with colleagues, manage your contact information, create task requests for others to perform and much more.

The skills and knowledge acquired in Microsoft PowerPoint 2013 - Level 1 (with Challenge Exercises) are sufficient to be able to create real-world slide shows. You will learn how to create, print and publish presentations.

Microsoft PowerPoint 2013 - Level 2 (with Challenge Exercises) is designed for users who are keen to extend their understanding and knowledge of the software beyond creating basic presentations.

The skills and knowledge acquired in Microsoft PowerPoint 2016 - Level 1 (with Challenge Exercises) are sufficient to be able to create real-world slide.

Microsoft PowerPoint 2016 - Level 2 (with Challenge Exercises) is designed for users who are keen to extend their understanding and knowledge of the software beyond creating basic presentations.

The skills and knowledge acquired in this course are sufficient for the learner to be able to use Microsoft Project 2013 to create a new project, enter and work with tasks and resources, create a schedule, and print effective project information.

Microsoft Project 2013 - Level 2 is designed for existing users of Microsoft Project who wish to extend their skills and knowledge beyond the creation of simple projects.

Microsoft Project 2013 - Level 3 aims to take the learner to more advanced levels of Microsoft Project. It covers a diverse range of topics including working simultaneously on multiple projects, sharing resources between several projects, downsizing very large projects, using templates, and automating operations with VBA

The skills and knowledge acquired in this course are sufficient for the learner to be able to use Microsoft Project 2016 to create a new project, enter and work with tasks and resources, create a schedule, and print effective project information.

The skills and knowledge acquired in this course are sufficient for the learner to be able to use Microsoft Project 2016 to create a new project, enter and work with tasks and resources, create a schedule, and print effective project information.

The skills and knowledge acquired in this course are sufficient for the learner to be able to use Microsoft Project 2016 to create a new project, enter and work with tasks and resources, create a schedule, and print effective project information.

The skills and knowledge acquired in Microsoft Publisher 2013 (with Challenge Exercises) are sufficient to be able to create publications such as flyers, newsletters and labels.

The skills and knowledge acquired in Microsoft Publisher 2016 (with Challenge Exercises) are sufficient to be able to create publications such as flyers, newsletters and labels.

The skills and knowledge acquired in Microsoft Visio 2013 - (with Challenge Exercises) are sufficient to be able to create real-world drawings using the many shapes, stencils and templates provided with the software.

The skills and knowledge acquired in Microsoft Visio 2016 - (with Challenge Exercises) are sufficient to be able to create real-world drawings using the many shapes, stencils and templates provided with the software.

Microsoft Windows 10 is designed for users who are keen to learn how to operate the software to perform tasks that include: starting applications, creating folders, copying and moving files, creating and using libraries, performing searches, and personalising Windows.

Microsoft Windows 8.1 is designed for users who are keen to learn how to operate the software to perform tasks that include: starting applications, creating folders, copying and moving files, creating and using libraries, performing searches, and personalising Windows.

This hands-on beginner’s course aims to give the learner a sound grounding in the use of Microsoft Word 2013 to create everyday documents required either at work or at home. Particular emphasis is placed on developing accurate and well-designed documents. The course begins by showing the learner how to navigate around Microsoft Word 2013. It then quickly gets the learner to create a new document before moving onto features such as text manipulation and enhancement, creating and using tabs and tables, embellishing documents with clip art and pictures, creating multiple documents through merging and printing documents.

This course aims to enhance existing skills by covering more specific documentation creation aspects such as working with multiple documents, formatting tables, tabs, lists, merging, section breaks, templates and more.

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

This hands-on beginner’s course aims to give the learner a sound grounding in the use of Microsoft Word 2016 to create everyday documents required either at work or at home. Particular emphasis is placed on developing accurate and well-designed documents. The course begins by showing the learner how to navigate around Microsoft Word 2016. It then quickly gets the learner to create a new document before moving onto features such as text manipulation and enhancement, creating and using tabs and tables, embellishing documents with clip art and pictures, creating multiple documents through merging and printing documents.

This course aims to enhance existing skills learned in Microsoft Word 2016 Level 1 by covering more specific documentation creation aspects such as working with multiple documents, formatting tables.

Microsoft Word 2016 - Level 3 (with Challenge Exercises) is designed for Microsoft Word users who are keen to extend their understanding and knowledge of the software beyond basic document creation so that they can create and work with features such as SmartArt, indexes, master documents, interactive fields and much more.

This is a fee-based online course for Oracle: Database Design and SQL.

In the first half of Oracle’s Database Design and Programming with SQL course you will learn to analyse complex business scenarios and create a data model - a conceptual representation of an organization’s information. In the second section you will implement your database design by creating a physical database using SQL, an industry-standard database programming language.

Completion of this course prepares you close to being ready to sit the external exam Oracle Database 11g: SQL Fundamentals I 1Z0-051. Read more about this exam.

This is a fee-based online course for Oracle: Database Programming with PL/SQL. If you are unfamiliar with the Oracle online course environment it is strongly recommended that you attend the Oracle Academy: Database Design & SQL, and Database Programming in PL/SQL Induction to the Online Environment course.

This course covers Oracle's PL/SQL, a procedural language extension to SQL. You will learn procedural logic constructs such as variables, constraints, conditional statements and iterative controls.

This online course prepares you toward the external exams:

• Oracle Database 11g: Program with PL/SQL Exam Number: 1Z0-144 Read more about this exam and its associated fee.

• Program with PL/SQL Exam Number: 1Z0-147 Read more about this exam and its associated fee.

This is a fee-based online course for Java Fundamentals & Java Programming. Both courses will be available upon receiving a confirmed booking, the courses cannot be booked separately.

The Java Fundamentals course:

• Lays the foundation for those with little or no programming experience
• Introduces fundamental programming concepts and terminology in an easy, engaging manner
• Uses animations and games to introduce basic computer science concepts
• Incorporates integrated development environments: Alice 3, Greenfoot, and Eclipse

The Java Programming course:

• Builds upon the knowledge gained from Oracle Academy: Java Fundamentals
• Enables students to further develop Java programming knowledge using Java SE7
• Teaches the core APIs used to design object-oriented applications with Java
• Uses the GridWorld case study to enhance student knowledge of core Java concepts

Completion of this online Oracle Academy: Java Fundamentals course prepares you to take the optional external Oracle Certified Associate Java SE 7 Programmer 1 exam 1Z0-803. Information on the exam fee and details of the exam can be found online.

Completion of the Oracle Academy: Java Programming course prepares you to take the external Oracle Certified Associate Java SE 7 Programmer II exam 1Z0-804. Exam details including fee can be found online.

The skills and knowledge acquired in this course are sufficient to be able to create real life working VBA applications within Excel. The learner will be able to work with VBA within the Excel environment to program and automate worksheet operations.

The skills and knowledge acquired in this course are sufficient to be able to create real life working VBA applications within Excel. The learner will be able to work with VBA within the Excel environment to program and automate worksheet operations.

The skills and knowledge acquired in Programming In VBA - Using Microsoft Word 2013 are sufficient to be able to create VBA applications in Microsoft Word 2013.

The skills and knowledge acquired in this course are sufficient to be able to create real life working VBA applications within Word. The learner will be able to work with VBA within the Word environment to program and automate document operations.

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 > Concept Stew > Statistics for the Terrified