UIS Self Taught Training 2018-19

The skills and knowledge acquired in Adobe Acrobat DC are sufficient to be able to create and edit PDFs, use forms, collaborate with others and secure your documents.

The skills and knowledge acquired in Adobe Dreamweaver CC - Level 1 are sufficient to be able to use and operate the software effectively.

The skills and knowledge acquired in Adobe Dreamweaver CC - Level 2 are sufficient to be able to work with various advanced aspects of Dreamweaver CC including working with the Creative Cloud, CSS inheritance and specificity, responsive web design, Photoshop integration and much more.

The skills and knowledge acquired in Adobe Dreamweaver CC - Level 1 allow you to set up a new website, create and modify webpages, insert text and images, and much more.

The skills and knowledge acquired in Adobe Dreamweaver CC - Level 2 are sufficient to be able to work with various advanced aspects of Dreamweaver CC including working with the Creative Cloud, CSS inheritance and specificity, responsive web design, Photoshop integration and much more.

The skills and knowledge acquired in Adobe Dreamweaver CS6 are sufficient to be able create a website. This course gives particular attention to the initial creation of the website, incorporating text and images.

The skills and knowledge acquired in Adobe Illustrator CC - Level 1 are sufficient to be able to perform basic tasks in Illustrator such as setting up a document, creating basic shapes and working with text.

The skills and knowledge acquired in Adobe Illustrator CC - Level 2 are sufficient to be able to work with various advanced aspects of Illustrator CC including working with the Creative Cloud, colour guides, brushes and symbols, Live Paint, tracing and much more.

The skills and knowledge acquired in Adobe Illustrator CS6 are sufficient to be able create professional artwork and documents.

The skills and knowledge acquired in Adobe InDesign CC - Level 1 enable users to gain a thorough understanding of InDesign and how it can be used as well as the ability to create a variety of different kinds of documents, add text, colour, shapes and graphics, print documents and access help.

The skills and knowledge acquired in Adobe InDesign CC - Level 1 enable users to gain a thorough understanding of InDesign and how it can be used as well as the ability to create a variety of different kinds of documents, add text, colour, shapes and graphics, print documents and access help.

The skills and knowledge acquired in Adobe InDesign CC - Level 2 are sufficient to be able to work with various advanced aspects of InDesign CC including working with the Creative Cloud, creating and modifying interactive documents and much more.

The skills and knowledge acquired in this courseware will allow the learner to create a variety of documents, both print-based and digital. The learner will be able to create a variety of documents ranging from simple text documents through to complex brochures and flyers with detailed graphics and advanced formatting features.

The skills and knowledge acquired in Adobe Photoshop CC - Level 1 are sufficient to be able to use and operate the software effectively.

The skills and knowledge acquired in Adobe Photoshop CC - Level 2 are sufficient to be able to use and operate the software at an advanced level.

The skills and knowledge acquired in Adobe Photoshop CC - Level 1 are sufficient to be able to use and operate the software effectively.

The skills and knowledge acquired in Adobe Photoshop CC - Level 2 are sufficient to be able to work with various advanced aspects of Photoshop CC including working with the Creative Cloud, applying layer effects, creating and modifying 3D content and much more.

The skills and knowledge acquired in Adobe Photoshop CS6 are sufficient to be able to understand the Photoshop screen, the different palettes and use the Photoshop tools to modify and adjust images.

The fundamental-level course is intended for individuals who seek an overall understanding of the AWS Cloud, independent of specific technical roles. It provides a detailed overview of cloud concepts, AWS services, security, architecture, pricing, and support. This course also helps you prepare for the AWS Certified Cloud Practitioner exam.

This is a free course, register and sign in online

More information can be found online

The Cyber Security - Stay Safe Online course is an interactive tutorial relating the current cyber security threats and advice on how to avoid them.

Think you won’t get caught in a phishing scam? Think again, below is the same email address written twice, how quickly can you spot the one containing the error?

joe_bloggs@therealcompanywebsite.com

joe_bloggs@therealcompanywebslte.com

It is hard to see the difference, especially when you have a heavy schedule of work and many distractions. The scam address is the bottom one with an 'l' instead of an 'i'. Imagine if you had transferred money or sent some sensitive data to the wrong email address . . . This interactive tutorial aims to raise your awareness of the most common techniques, not only email, that criminals use to gain access to your personal data, University sensitive information and networks. It will take between 30 to 40 minutes to work through and is based on real life scenarios that you may encounter in your day to day work

The course can be accessed on Moodle

Introduction to Personal Computers - Using Windows 10 and Microsoft Office 2016 is designed for users who are keen to extend their understanding of how to use computers. The skills acquired are sufficient to use the software to perform tasks including starting applications, creating folders, copying and moving files, and personalising Windows.

Introduction to Personal Computers - Using Windows 8.1 and Microsoft Office 2013 is designed for users who are keen to extend their understanding of how to use computers. The skills acquired are sufficient to use the software to perform tasks including starting applications, creating folders, copying and moving files, and personalising Windows.

The skills and knowledge acquired in Microsoft Access 2013 - Level 1 (with Challenge Exercises) are sufficient to be able to create database systems, enter, edit and delete data in database files, produce information in forms and reports and generate queries on the data.

The aim of this course is to build on the introductory skills of Level 1. The student learns how to ensure that data is entered correctly, how to create more sophisticated and complex queries, and is introduced to some basic automation techniques involving macros.

The skills and knowledge acquired in Microsoft Access 2013 - Level 3 (with Challenge Exercises) are sufficient to design and create a multi-table database and automate operations using macros and have a general understanding of the programming environment in Microsoft Access 2013.

The skills and knowledge acquired in Microsoft Access 2016 - Level 1 (with Challenge Exercises) are sufficient to be able to create database systems, enter, edit and delete data in database files, produce information in forms and reports and generate queries on the data.

The aim of this course is to build on the introductory skills of Level 1. The student learns how to ensure that data is entered correctly, how to create more sophisticated and complex queries, and is introduced to some basic automation techniques involving macros.

The skills and knowledge acquired in Microsoft Access 2016 - Level 3 (with Challenge Exercises) are sufficient to design and create a multitable database and automate operations using macros and have a general understanding of the programming environment in Microsoft Access 2016.

This course aims to give the learner the skills and knowledge to be able to use and browse the internet using the Microsoft Edge browser

This is a beginner’s course and aims to give the new spreadsheet user a thorough grounding in the basics of creating and working with spreadsheets using Microsoft Excel 2013. Particular emphasis is placed on developing accurate and well-designed spreadsheets employing sound design and documentation principles.

The skills and knowledge acquired in Microsoft Excel 2013 - Level 2 (with Challenge Exercises) enable users to expand their knowledge and learn how to create more productive workbooks. It covers formulas and function techniques, advanced formatting and charting features and data manipulation tools like PivotTables and goal seeking.

The skills and knowledge acquired in Microsoft Excel 2013 - Level 3 (with Challenge Exercises) are sufficient to be able to protect worksheet data, perform advanced data operations using summarising, data consolidations, filters and advanced PivotTable techniques, macros, and much more.

Microsoft Excel 2016 - Data Analysis Add-Ins will show you how to use the data analyis add-ins of Microsoft Excel 2016, including using Power View to create interactive data visualisations, using Power Pivot to create a data model for use with Excel tools such as pivot tables and pivot charts, using Get & Transform to import and combine data from a variety of sources such as databases and web sites and using Power Map to visualise geographic data.

Microsoft Excel 2016 - Functions will show you how to use a variety of Excel functions, including logical functions, math functions, date and time and financial functions. It is a reference manual and is designed to be used by someone already familiar with how functions are used in Excel.

Microsoft Excel 2016 - Level 1 is a beginner’s course and aims to give the new spreadsheet user a thorough grounding in the basics of creating and working with spreadsheets using Microsoft Excel 2016. Particular emphasis is placed on developing accurate and well-designed spreadsheets employing sound design and documentation principles.

Microsoft Excel 2016 - Level 2 enables users to expand their knowledge and learn how to create more productive workbooks. It covers formulas and function techniques, advanced formatting and charting features and data manipulation tools like goal seeking.

Microsoft Excel 2016 - Level 3 enables users to protect worksheet data, perform advanced data operations using summarising, data consolidations, filters and PivotTables, macros, and much more.

The skills and knowledge acquired in Microsoft Lync Online are sufficient to be able to work with the basic elements of Lync including adding and working with contacts, sending and receiving calls and instant messages, using the presenting features and working with Lync settings.

Microsoft Office 2013 - Upgrading provides skills and knowledge in a wide range of new features, enhancements and changes found in Microsoft Office 2013.

The skills and knowledge acquired in Microsoft Office 365 - For Business - Level 1 are sufficient to be able to understand how Office 365 works and perform basic tasks.

The skills and knowledge acquired in Microsoft Office 365 - For Business - Level 2 are sufficient to be able to use and operate the software effectively.

• The Microsoft Office 365 Training Centre offers a range of introductory training videos and tutorials for the range of applications included in the Microsoft Office 365 package.

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

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

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

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

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

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

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

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

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

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

• 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