All University Information Services - Digital Literacy Skills courses

Haven't had the time to fully explore all that Excel, Word and PowerPoint has to offer? If so, now's your chance to pick up a few handy tips that you may not have discovered yet. You can save a lot of time and effort working with Excel, Word and PowerPoint if you know a few tricks and shortcuts.

Do you keep hearing the term collaborating online and are wondering if you and your co-workers should be doing it, or if you are doing it correctly? If so, this one-hour instructor-led course is for you. The session will blast through the jargon of OneDrive and SharePoint to explain how working online together can improve productivity, and it will give you hands on practice collaborating in real time using Word and Excel. By the end of the session your questions will be answered and you'll be working online with confidence.

• This is the In Person Face to Face version of the Live Online Office 365: Collaborating Online Top Tips - Bitesize Learning course.

Please Note: It is important that when you book on this course, on your booking confirmation page, click on Add to Calendar to start the process to import the course appointment into your calendar.

• See Related Courses below to take your skills further

Do you keep hearing the term collaborating online and are wondering if you and your co-workers should be doing it, or if you are doing it correctly? If so, this one-hour instructor-led course is for you. The session will blast through the jargon of OneDrive and SharePoint to explain how working online together can improve productivity, and it will give you hands on practice collaborating in real time using Word and Excel. By the end of the session your questions will be answered and you'll be working online with confidence.

The link to join the course is sent in the booking and reminder emails.

Confused between Office 365 and OneDrive and Office Online? Want a clear explanation of these and help getting started? Then this course is for you.

After a short presentation there will be the opportunity to set up your Office 365 account and use Office Online. You can try the new online applications such as Sway, Yammer or Forms and collaborate with others using online documents. Also bring your own device if you would like to get support installing the applications or working online away from your desk.

To participate in the course activities, if you have not already done so, you will need enable your account by synchronising your UIS Password with your University Microsoft account. Please do this at least one day before the class.

This 90 hour online course introduces you to the techniques and tools required to develop database driven web applications. The course teaches you how to design, develop and deploy beautiful, responsive, database-driven web applications using Oracle Application Express. Leveraging project-based learning techniques, you will create and work with projects which challenge them to design, implement, and demonstrate a database-driven web application solution for a business or organisation.

This course should be taken after Database Programming with PL/SQL

This 40 hour course of study builds on the skills gained by students in Java Foundations and Java Programming. Students are introduced to Machine Learning concepts within Artificial Intelligence and will learn terminology, syntax, and the steps required to create a Machine Learning solution in Java using hands-on, engaging activities. There is no external exam associated with this course.

This 180 hour online course engages you to analyse complex business scenarios and create a data model—a conceptual representation of an organisation’s information. It comprises two equally sized halves, DB design, and DB programming using SQL.

You will implement your database design by creating a physical database using SQL. Basic SQL syntax and the rules for constructing valid SQL statements are reviewed. This course culminates with a project that challenges you to design, implement, and demonstrate a database solution for a business or organisation.

Exam Information

Through Oracle's Certification paths, you demonstrate a professional level of technical skills recognised throughout the information technology industry, this gives you a competitive edge in your career.

Completion of Database Design and Programming with SQL course prepares you close to being ready to sit the optional external exam Oracle Database SQL | 1Z0-071. Read more about this exam.

If you have no or little database experience and want to learn database design techniques using a modelling tool and to begin programming using SQL to implement and query databases using hands-on, engaging activities, this 90 hour course is for you. This course should be taken before Database Design and Database Programming with SQL .

The course teaches you relational database terminology, as well as data modelling concepts, building Entity Relationship Diagrams (ERDs), and mapping ERDs. Oracle SQL Developer Data Modeller is utilised to build ERDs and Structured Query Language (SQL) is used to interact with a relational database and manipulate date within the database. Leveraging project-based learning techniques, you will create and work with projects which challenge you to design, implement, and demonstrate a database solution for a business or organisation.

Exam Information

Through Oracle's Certification paths, you demonstrate a professional level of technical skills recognised throughout the information technology industry, this gives you a competitive edge in your career.

Completion of Database Design and Programming with SQL course prepares you close to being ready to sit the optional external exam Oracle Database Foundations | 1Z0-006. Read more about this exam.

This 180 hour course introduces you to PL/SQL, Oracle’s procedural extension language for SQL and the Oracle relational database. Participants explore the differences between SQL and PL/SQL. You also examine the characteristics of PL/SQL and how it is used to extend and automate SQL to administer the Oracle database. This course culminates with a project that challenges you to program, implement, and demonstrate a database solution for a business or organisation.

Exam Information

Through Oracle's Certification paths, you demonstrate a professional level of technical skills recognised throughout the information technology industry, this gives you a competitive edge in your career.

This online course prepares you toward the external exam (please note that this exam retires on 31-October-2020): Oracle Database 11g: Program with PL/SQL Exam Number: 1Z0-144 Read more about this exam and its associated fee.

This is an official Oracle online course for Java Foundations. It is an alternative to the Java Fundamentals course, however if you have not studied Java Fundamentals then you must work through the Alice and Greenfoot workshops (access can be provided on request). Java Foundations is a recommended pre-requisite for the Java Programming course.

Overview

This 90 hour online course engages students with little programming experience. Students are introduced to object-oriented concepts, terminology, and syntax, and the steps required to create basic Java programs using hands-on, engaging activities. Students will learn the concepts of Java programming, design object-oriented applications with Java and create Java programs using hands-on, engaging activities.

Exam Information Through Oracle's Certification paths, you demonstrate a professional level of technical skills recognised throughout the information technology industry, this gives you a competitive edge in your career. The Java Foundations OR Java Fundamentals courses prepare you to take the optional external exam Java Foundations | 1Z0-811.

This is an official Oracle online course for Java Fundamentals. It is an alternative to the Java Foundations course. If you are completely new to programming concepts then this is a good course to start your learning path, followed by Java Foundation, then Java Programming.

Overview This 90 hour online course engages students with little or no programming experience to create Java programs. Participants are introduced to object-oriented programming concepts, terminology, and syntax, and the steps required to create basic Java programs using the Alice, Greenfoot, and Eclipse interactive development environments. Hands-on practices figure prominently throughout this course so you can experience firsthand the power of computer programming. This is a recommended pre-requisite for the Java Programming course.

Exam Information Through Oracle's Certification paths, you demonstrate a professional level of technical skills recognised throughout the information technology industry, this gives you a competitive edge in your career. The Java Foundations OR Java Fundamentals courses prepare you to take the optional external exam Java Foundations | 1Z0-811.

The Java Programming course builds on the skills gained in either the Java Fundamentals OR Java Foundations courses to help advance Java programming skills. You will design object-oriented applications with Java and will create Java programs using hands-on, engaging activities.

Exam Information

Through Oracle's Certification paths, you demonstrate a professional level of technical skills recognised throughout the information technology industry, this gives you a competitive edge in your career. The Java Programming course prepares you to take the optional external exam Java SE 8 Programmer I | 1Z0-808.

Join us in this friendly, introductory session to learn how to get up and running with Outlook 365 Email and Calendar using the Desktop application for Windows, where we will take you through the basics of the Outlook 365 and more. If you are already familiar with the basics, this course will provide you with tips to speed things up and also get to know what is possible in Outlook.

• This is the Live online version of the In Person Face to Face classroom based instructor led course.

Please note that the course is taught using Microsoft Teams and you must have Teams installed on your computer to participate. See System requirements below for more information

Please Note: It is important that when you book on this course, on your booking confirmation page, click on Add to Calendar to start the process to import the course appointment into your calendar. This contains the link to the MS Teams course meeting under Joining Instructions that you will use to join on the day of the course.

• See Related Courses below to take your skills further

Panopto is a lecture capture system with the ability to record any combination of video sources, in any configuration, in classrooms of any size. It can be used to record Video Presentations, Screen Recording, Multi-Camera Recording, Live Webcasting and Scheduled Recording. This session will be delivered by Panopto.

Panopto is an online platform for creating, managing and publishing videos.

A recommended series of courses have been collated and can be found here on Moodle.

This PHP introduction course explores the basic elements of PHP script programming. PHP allows web developers to write dynamic web pages, for instance by simplifying ways to collect data through a web form, and to process and include data, by placing small scripts directly into HTML files.

Session 1 will provide background, tools and exercises for writing and editing PHP in HTML files, uploading them to a web server, and making them available online. There will also be an introduction to programming in PHP, to help enable you to later adapt the examples to address your more advanced examples and projects.

Session 2 will extend the simpler exercises in Session 1, adding more options and capabilities, as well as providing new and more advanced examples. Using the tools and techniques from Session 1, there will be opportunities to adjust and partly customise the examples, and if time permits potentially begin a small exercise of your own.

• This is a follow-on course from the PowerPoint 2016: Introduction (Self-paced) course and will look at the more advanced features of PowerPoint

• This course gives a "quick start" introduction to Microsoft PowerPoint which is a widely used software application for preparing presentations

This self-paced hands-on course gives a "quick start" introduction to Microsoft PowerPoint which is a widely used software application for preparing presentations

This course is part of the Scientific Computing series.

This course is aimed at those new to programming, or who have never been formally taught the principles and basic concepts of programming. It provides an introduction to the basic concepts common to most high level languages (including Python, Java, Fortran, C, C++, Visual Basic). The aim of the course is to equip attendees with the background knowledge and confidence necessary to tackle many on-line and printed programming tutorials. It may also help attendees in deciding which programming language is suitable for their programming task.

Knowledge of the concepts presented in this course is a pre-requisite for many of the other courses in the Scientific Computing series of courses (although not for the "Python for Absolute Beginners" course).

Do you want to create more professional publications by having a deeper appreciation of what Publisher can do for you? Through a series of graded exercises this course focuses on practical work giving you ample opportunity to use your PC skills to produce various publications. Please note that this course is largely about learning the software rather than design.

This course is part of the Scientific Computing series and is suitable for people who have Python experience equivalent to either of the introductory courses: Introduction for Absolute Beginners or Introduction for Programmers

These sessions consist of a selection of self-paced mini-courses, each taking at most a half-day. Python expert(s) from the UCS will be present to answer questions or address difficulties with these. Attendees can select from the available topics to most closely meet their individual needs. Attendees are welcome to attend more than one session to work through multiple topics. If an attendee finishes a topic with time to spare they may select another, and so on.

This course is part of the Scientific Computing series.

This course is aimed at those new to programming and provides an introduction to programming using Python, focussing on scientific programming. This course is probably unsuitable for those with programming experience, even if it is just in shell scripting or Matlab-like programs. By the end of this course, attendees should be able to write simple Python programs and to understand more complex Python programs written by others.

As this course is part of the Scientific Computing series, the examples chosen are of most relevance to scientific programming.

This course is part of the Scientific Computing series.

This full-day course introduces the Python programming language to those who are already familiar with another high level programing language such as C/C++, Fortran, Java, Perl or Visual Basic. The aim of this course is to give such programmers sufficient familiarity with Python that they can attend any of the more advanced Python courses organised by the Computing service and easily follow any of the widely available Python tutorials on the more complex aspects of the language.

This course covers all the material contained in the "Programming: Python for Absolute Beginners" course, but in a more abbreviated fashion suitable for those who already have significant programming experience. This course does NOT cover the more complex aspects of the language (for such topics see the other Computing Service Python courses), nor is there much explicit discussion of the object oriented features of Python.

If you are an accomplished and experienced programmer you may find this course too slow, you may prefer to self-teach the course rather than attend in person, the full set of notes can be downloaded.

This course is for those who are new to the Recruitment Administration System (RAS) or those who wish to have a refresher.

• This is the In Person Face to Face version of the Live Online RAS course.

Please Note: It is important that when you book on this course, on your booking confirmation page, click on Add to Calendar to start the process to import the course appointment into your calendar.

• See Related Courses below to take your skills further