All University Information Services - Digital Literacy Skills courses

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.

University Information Services (UIS) facilitate a mentoring scheme across UIS and the IT Community, providing career development support for individuals and organisations. This session is for mentees to understand how to approach your mentor, plan your objectives and general guidelines to gain the most helpful and relevant advice from your mentor. You'll also have the opportunity to meet with other mentees enrolled on the scheme.

UIS staff will share what worked well and what could have been done better or differently to deliver work within the programme. Topics will range from system testing to user engagement.

The IT Community Development Project is hosting two seminars at the end of June. The presentation will discuss UIS initiatives as well as a primary focus on the implementation of the EU General Data Protection Regulation.

The IT Community Development Project invites IT professionals across the Collegiate University to attend a seminar presentation on career development, highlighting the further stages with using an IT skills database, future plans for community development and an update on the Cyber Security Programme.

This lunchtime talk is to advise new joiners of Darwin College on the security aspects of IT assets, and social engineering practices, used to exploit machines and extract research data and phishing campaigns against the University of Cambridge.

This instructor-led fee based course has been commissioned by the UIS through a third party company.

ITIL is Best Practice IT Service Management which is used by many organisations around the world. A whole ITIL philosophy has grown up around the guidance contained within the ITIL books and the supporting certification and qualification scheme.

The ethos behind the development of ITIL is the recognition that organisations are becoming increasingly dependent on IT in order to satisfy their corporate aims and meet their business needs. This leads to an increased requirement for reliable, high-quality IT services.

The ITIL Foundation course provides IT managers, practitioners, support staff and staff interfacing with the information systems function with a practical understanding of the key concepts, principles, processes and functions that enables successful IT service management provision. It also prepares delegates for the ITIL Foundation Certificate Examination. The course is based on the ITIL best practice service lifecycle approach featured in the latest 2011 guidelines.

ITIL Foundation is the entry level qualification of the ITIL Qualifications scheme.

A full day course for Computer Officers on the UIS password application and the skills they will need to use it. Major topics covered include:

• Computing Service policies regarding UIS accounts
• Privacy briefing covering the legal status of UIS accounts and your obligations to users
• Assertiveness training to assist you in dealing with problematic requests
• Demonstration of the new password application
• Online test

This course includes descriptions of the circumstances under which you may, and more importantly, may not give out account details (including password reset tokens). The examples and scenarios used are based on actual requests and incidents, and includes some content that could be distressing. This material is specifically included to ensure that Computer Officers are aware of the social engineering techniques that have been used in attempts to gain access to accounts, often under difficult and stressful circumstances. This is intended to assist you in developing the skills to deal appropriately with such situations if they occur within your own institution and forms an essential part of the course.

Successful completion of this course and the online exam is mandatory for Computer Officers wishing to have password resetting authority using the UIS password application for a range of University wide services including Hermes, Raven and the MCS.

LaTeX is a powerful document description language built on top of TeX. It is available on Unix, Windows and Macintoshes. It can be used for the presentation of plain text (including accented characters and letters outside the English alphabet), the typesetting of mathematics, the generation of tables, and producing simple diagrams. It is particularly suited for the writing of theses, papers and technical documents.

• University Information Services (UIS) invites all University IT staff to celebrate the launch of LinkedIn Learning for the IT Community. View a whistle stop tour of the product, discover the benefits, hear user stories from the IT community and indulge in a celebratory cake.

• LinkedIn Learning is an online eLearning resource which provides expert led courses developed by industry experts using Lynda.com content, topics include:

A recommended course by the Digital Literacy Skills Programme as part of the University of Cambridge's subscription to LinkedIn Learning.

The course can be accessed here.

A recommended course by the Digital Literacy Skills Programme as part of the University of Cambridge's subscription to LinkedIn Learning.

The course can be accessed here.

A recommended course by the Digital Literacy Skills Programme as part of the University of Cambridge's subscription to LinkedIn Learning.

The course can be accessed here.

A recommended course by the Digital Literacy Skills Programme as part of the University of Cambridge's subscription to LinkedIn Learning.

The course can be accessed here.

A recommended course by the Digital Literacy Skills Programme as part of the University of Cambridge's subscription to LinkedIn Learning.

The course can be accessed here.

A curated course by the Digital Literacy Skills programme as part of the University of Cambridge's subscription to LinkedIn Learning.

This course can be acccessed here.

A recommended course by the Digital Literacy Skills Programme as part of the University of Cambridge's subscription to LinkedIn Learning.

The course can be accessed here.

A recommended course by the Digital Literacy Skills Programme as part of the University of Cambridge's subscription to LinkedIn Learning.

The course can be accessed here.

A recommended course by the Digital Literacy Skills Programme as part of the University of Cambridge's subscription to LinkedIn Learning.

The course can be accessed here.

A recommended course by the Digital Literacy Skills Programme as part of the University of Cambridge's subscription to LinkedIn Learning.

The course can be accessed here.

A recommended course by the Digital Literacy Skills Programme as part of the University of Cambridge's subscription to LinkedIn Learning.

The course can be accessed here.

A recommended course by the Digital Literacy Skills Programme as part of the University of Cambridge's subscription to LinkedIn Learning.

The course can be accessed here.

A recommended course by the Digital Literacy Skills Programme as part of the University of Cambridge's subscription to LinkedIn Learning.

The course can be accessed here.

A recommended course by the Digital Literacy Skills Programme as part of the University of Cambridge's subscription to LinkedIn Learning.

The course can be accessed here.

A recommended course by the Digital Literacy Skills Programme as part of the University of Cambridge's subscription to LinkedIn Learning.

The course can be accessed here.

A recommended course by the Digital Literacy Skills Programme as part of the University of Cambridge's subscription to LinkedIn Learning.

The course can be accessed here.

A recommended course by the Digital Literacy Skills Programme as part of the University of Cambridge's subscription to LinkedIn Learning.

The course can be accessed here.