UIS Self Taught Training 2016-17

Excel is a powerful spreadsheet and data analysis application, but to use it most effectively, you first have to understand the basics. This tutorial introduces some of the tasks and features that you can use in all workbooks.

PowerPoint for Mac 2011 helps you build and share rich and professional presentations, with engaging new features like narration and presentation broadcast. Then save, edit, and coauthor online.

« Description not available »

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 Programming In VBA - Using Microsoft Word 2013 are sufficient to be able to create VBA applications in Microsoft Word 2013.

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.

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.

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.