University Information Services course timetable

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 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.

The UIS are hosting this 3rd party delivered course.

This course covers the fundamentals of building IT infrastructure on the AWS platform. Students learn how to optimize the AWS Cloud by understanding how AWS services fit into cloud-based solutions. In addition, students explore AWS Cloud best practices and design patterns for architecting optimal IT solutions on AWS, and build a variety of infrastructures in guided, hands-on activities. The course also covers how to create fledgling architectures and build them into robust and adaptive solutions.

More information can be found online

Please see the fee section below before booking on the course.

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.

The UIS are hosting this 3rd party delivered course.

This course covers the fundamentals of building IT infrastructure on the AWS platform. Students learn how to optimize the AWS Cloud by understanding how AWS services fit into cloud-based solutions. In addition, students explore AWS Cloud best practices and design patterns for architecting optimal IT solutions on AWS, and build a variety of infrastructures in guided, hands-on activities. The course also covers how to create fledgling architectures and build them into robust and adaptive solutions.

More information can be found online

Please see the fee section below before booking on the course.

This course is part of the Scientific Computing series.

No previous experience of shell scripting is required for this course; however some knowledge of the interactive use of the bash shell is a prerequisite (see Simple Shell Scripting for Scientists: Prerequisites for details).

This course introduces shell scripting in bash for scientific computing tasks. Day one introduces very basic shell scripts in bash which process the command line in a simple fashion. Day two covers how to write more advanced shell scripts in bash. Day three covers how to make one's shell scripts more robust.

At the end of each day one or more exercises are set. It is VERY IMPORTANT that attendees attempt these exercises before the next day of the course. Attendees should make sure that they have allowed themselves sufficient study time for these exercises between each day of the course.

The UIS are hosting this 3rd party delivered course.

This course covers the fundamentals of building IT infrastructure on the AWS platform. Students learn how to optimize the AWS Cloud by understanding how AWS services fit into cloud-based solutions. In addition, students explore AWS Cloud best practices and design patterns for architecting optimal IT solutions on AWS, and build a variety of infrastructures in guided, hands-on activities. The course also covers how to create fledgling architectures and build them into robust and adaptive solutions.

More information can be found online

Please see the fee section below before booking on the course.

This course is designed for users new to the software who need to create various types of chart including Organisational charts, Gantt charts and Flow charts. The skills and knowledge acquired in this course are sufficient to be able to use and operate the software at an efficient level and covers from beginners to intermediate skills. It is fast paced.

This course will show you basic principles and processes for creating accessible documents in Microsoft Word and PowerPoint and PDFs.

The UIS are hosting this 3rd party delivered course.

This course covers the fundamentals of building IT infrastructure on the AWS platform. Students learn how to optimize the AWS Cloud by understanding how AWS services fit into cloud-based solutions. In addition, students explore AWS Cloud best practices and design patterns for architecting optimal IT solutions on AWS, and build a variety of infrastructures in guided, hands-on activities. The course also covers how to create fledgling architectures and build them into robust and adaptive solutions.

More information can be found online

Please see the fee section below before booking on the course.

Mendeley is a free reference management program. It was originally primarily intended as a way to manage collections of PDF documents and this is still its main strength in comparison with other tools such as EndNote and Zotero.

Mendeley can be used to insert reference citations and a bibliography of cited references into Word and Open Office documents and may be of interest to anyone wanting a free reference management program which will create BibTeX citation keys and paste them into a LaTeX document.

This is a basic introductory course and probably will not be very useful to those who are already using the program and who have specific queries about the way it works.

Users who need help with more advanced features can request individual help via the UIS service desk email: servicedesk@uis.cam.ac.uk

The UIS are hosting this 3rd party delivered course.

This course covers the fundamentals of building IT infrastructure on the AWS platform. Students learn how to optimize the AWS Cloud by understanding how AWS services fit into cloud-based solutions. In addition, students explore AWS Cloud best practices and design patterns for architecting optimal IT solutions on AWS, and build a variety of infrastructures in guided, hands-on activities. The course also covers how to create fledgling architectures and build them into robust and adaptive solutions.

More information can be found online

Please see the fee section below before booking on the course.

Microsoft Excel is the chosen spreadsheet package as it is a popular choice, both on Apple Mac and PC. This is an instructor-led course for absolute beginners. There is a self-paced Excel Beginners course for those who prefer to learn at their own pace.

Unconscious Bias happens automatically, without conscious control, when our brains make quick judgements or assessments about people and situations. Combatting unconscious bias isn’t about blame. It’s about accountability.

This session will provide an introduction to implicit or unconscious bias and will help you start to understand how our biases influence the decisions we make.

The UIS are hosting this 3rd party delivered course.

This course covers the fundamentals of building IT infrastructure on the AWS platform. Students learn how to optimize the AWS Cloud by understanding how AWS services fit into cloud-based solutions. In addition, students explore AWS Cloud best practices and design patterns for architecting optimal IT solutions on AWS, and build a variety of infrastructures in guided, hands-on activities. The course also covers how to create fledgling architectures and build them into robust and adaptive solutions.

More information can be found online

Please see the fee section below before booking on the course.

This course is part of the Scientific Computing series.

No previous experience of shell scripting is required for this course; however some knowledge of the interactive use of the bash shell is a prerequisite (see Simple Shell Scripting for Scientists: Prerequisites for details).

This course introduces shell scripting in bash for scientific computing tasks. Day one introduces very basic shell scripts in bash which process the command line in a simple fashion. Day two covers how to write more advanced shell scripts in bash. Day three covers how to make one's shell scripts more robust.

At the end of each day one or more exercises are set. It is VERY IMPORTANT that attendees attempt these exercises before the next day of the course. Attendees should make sure that they have allowed themselves sufficient study time for these exercises between each day of the course.

• This hands-on course is a follow up from the Excel: Introduction course.

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 beginners course equips you with the skills to implement a relational database design entity relationship diagram (ERD) into a MySQL database. Please be prepared for a fast paced course, but the materials provided can be used for consolidation after the course.

• A presentation and workshop-style session introducing how IT works in the University of Cambridge. Covering what is expected of an IT professional working within a college, department or University institution, this session will explain what resources are available for them, including IT-specific material.
• This induction is useful for any new (or relatively new) IT staff, or as a refresher for those who may have missed the opportunity to attend at the start of their IT role within the University.
• The session will provide the opportunity to network with IT professionals across the University, and to meet UIS staff and Relationship Managers who are key contacts for supporting IT staff.

This beginners course equips you with the skills to implement a relational database design entity relationship diagram (ERD) into a MySQL database. Please be prepared for a fast paced course, but the materials provided can be used for consolidation after the course.

This course is part of the Scientific Computing series.

No previous experience of shell scripting is required for this course; however some knowledge of the interactive use of the bash shell is a prerequisite (see Simple Shell Scripting for Scientists: Prerequisites for details).

This course introduces shell scripting in bash for scientific computing tasks. Day one introduces very basic shell scripts in bash which process the command line in a simple fashion. Day two covers how to write more advanced shell scripts in bash. Day three covers how to make one's shell scripts more robust.

At the end of each day one or more exercises are set. It is VERY IMPORTANT that attendees attempt these exercises before the next day of the course. Attendees should make sure that they have allowed themselves sufficient study time for these exercises between each day of the course.