All University Information Services - Digital Literacy Skills courses

This is course will help you get to grips with spreadsheet basics using Microsoft Excel. It will be taught in a small group and no previous knowledge is assumed, however those that use Excel at a basic level will also learn new tricks and tips which will serve them well in saving time day to day and increasing knowledge.

• This is the In Person Face to Face version of the Live Online 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

This course will help you get to grips with spreadsheet basics using Microsoft Excel. It will be taught in a small group and no previous knowledge is assumed. Following on, we offer further online instructor-led courses that build on these fundamentals to extend your skills (see Related courses below).

• 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 and also to see what other alternative self study options there are to this course.

This course covers some of the more challenging functions such as IF, SUMIFS and VLOOKUP. Not all chapters will be taught in full due to time constraints but are included for self-study.

• This is the In Person Face to Face version of our Live Online Excel: Functions 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

This course covers some of the more challenging functions such as IF, SUMIFS and VLOOKUP. Not all chapters will be taught in full due to time constraints but are included for self-study.

• This is the Live Online version of the In Person Face to Face 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. 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.

To fully participate in this course you will need to have the Microsoft Excel 365 for Windows desktop application installed on your computer. Participants using Microsoft Excel 365 for Mac or the online version via a web browser will find some of the functionality missing.

• See Related Courses below to take your skills further

Want to make it easier and more efficient when working with data in Excel? You'll e surprised how much you can do with Excel when managing your data. You will learn tips and tricks that will save you time over the course of your studies/career which can be transferred to home live too.

• This is the In Person Face to Face version of the Live Online Excel: Data & Lists 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

Want to make it easier and more efficient when working with data in Excel? You'll e surprised how much you can do with Excel when managing your data. You will learn tips and tricks that will save you time over the course of your studies/career which can be transferred to home live too.

• 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

This course offers an introduction to the power and time-saving value of PivotTables and will appeal to anyone who analyses data in Excel, come and explore their magic. People who get Pivot Table under their belt cannot imagine the usage of Excel without them. If pivot tables and their capacity are a mystery to you, this course is for you.

• This is the In Person Face to Face version of the Live Online Excel: Pivot Tables 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

This course offers an introduction to the power and time-saving value of PivotTables and will appeal to anyone who analyses data in Excel, come and explore their magic. People who get Pivot Table under their belt cannot imagine the usage of Excel without them. If pivot tables and their capacity are a mystery to you, this course is for you.

• 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

This instructor-led course is for people who want to keep up to date with newer or the lesser-known features of Microsoft Excel. It is a quick fire succession of topics at a fast pace and aimed at those who are comfortable using computers.

• This is the In Person Face to Face version of the Live Online Excel: Top Tips

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

This instructor-led course is for people who want to keep up to date with newer or the lesser-known features of Microsoft Excel. It is a quick fire succession of topics at a fast pace and aimed at those who are comfortable using computers.

• This is the Live online version of the In Person Face to Face classroom based instructor led Excel: Top Tips 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

This course will cover the use of Falcon Content Management Service by content and site managers.

This course will cover the use of Falcon Content Management Service for site managers and is a follow on course from Falcon: An Introduction for Content and Site Managers (Part 1 and Part 2).

The clinic session for people to come to with any queries and they will receive hands-on advice. The instructor will email the participants before the course to collate your queries.

• A live online event covering our final project update about the migration of University websites and the future of content management systems.
• Dr Nick Mattin, Head of Service Development at UIS, will present a summary about the Falcon-on-Drupal migration project and the development roadmap for Drupal.
• Barney Brown will provide an update on the Digital Presence Programme and the future for University websites and resources for site owners and editors.

A presentation and Q&A session to discuss the migration of websites to Falcon-on-Drupal – a new version of the Falcon website content management system (CMS) service based on the Drupal platform.
Attendees will have the opportunity to ask questions about the development, service features and the migration of their own sites.

• A presentation and Q&A session to discuss the development of Falcon-on-Drupal – a new version of the Falcon website content management system (CMS) service based on the Drupal platform – and the migration of sites to the new service.
• The session will be led by Nick Mattin, Head of Service Development at UIS. We’ll be joined by Barney Brown, Head of Digital Communications in the OEAC, who will be able to explain how the migration sits in the context of the University’s Digital Presence Programme.
• Attendees will have the opportunity to ask questions about the development, service features and how the migration may affect their sites.

This is a one off refresher course and will cover some of the use of Falcon Content Management Service by content and site managers who have been using the system for some years.

This course is about revision control with "Git"

Initially there will be a talk and demonstration then there will be an opportunity to try out any techniques you have learned about. To this end, if you are interested in looking at analytics for your own site and you haven't yet obtained a code and installed it on your pages, you will need to do that before the course. If you are interested in interpreting data that is already being collected you won't have to worry about that. Bear in mind that there is a lag in data collection of 24 hours.

The course aims to give an introductory overview of High Performance Computing (HPC) in general, and of the facilities of the High Performance Computing Service (HPCS) in particular.

Practical examples of using the HPCS clusters will be used throughout, although it is hoped that much of the content will have applicability to systems elsewhere.

This course aims to provide a basic knowledge of GPU programming using OpenACC directives. The course is very hands-on oriented, aiming to give to you the opportunity to practice and experiment from the very beginning.

Introduction to using the open-source reference management program, Zotero.

Access the course by clicking here

This is a practical-based course for people new to writing Web pages. Only the basics of HTML (hypertext mark-up language) will be covered, and is suitable for those who have to edit a content management system (CMS) to update web pages. The course teaches how to write HTML from scratch using a basic Text Editor and focuses on content and structure as opposed to style. By the end of the course you will have created three personal linked web pages and had the opportunity to publish these using DS-Web.

The University needs to maintain records about the personal data we hold, how we use it, and how we keep it secure to meet the obligations of the General Data Protection Regulation (GDPR), which comes into force on 25 May this year. The Information Asset Register (IAR) is the University’s chosen method of meeting this obligation.

At this event, James Knapton and Sibel Allinson will provide a live demonstration on how to use the IAR and host a Q&A session.

• University Information Services (UIS) is facilitating a mentoring scheme across UIS and the IT Community, providing career development support for individuals and organisations. This workshop is intended for mentors who have enrolled in the scheme. The session will cover advice and helpful methods on how to be a confident and effective mentor and a chance to share ideas with other mentors enrolled in the scheme.