Staff IT Training

This introductory hands-on course will cover how to use Moodle. The training will include:

• An overview of Moodle DC
• Labels to display information
• Adding Files and Folders to share documents
• Adding URL's to link to online content
• Creating Moodle Pages and Books to share content
• Setting up Zoom Meetings through Moodle

You do not need any prior knowledge of Moodle to join this course.

This introductory course will cover how to create a Moodle Quiz. The training will include:

• Creating quiz parameters DC
• Creating quiz questions
• Setting up quiz feedback
• Extracting a page from a PDF document
• Creating and using question banks
• Reviewing quiz scores

You do not need any prior knowledge of Moodle to join this course.

This introductory course will cover how to use H5P to create interactive content within Moodle. The training will include:

• An introduction to H5P
• Creating a Fill in the Blanks activity
• Creating a simple Branching Scenario
• Creating an Image Juxtaposition

You do not need any prior knowledge of Moodle or H5P to join this course.

This course will cover the functionality of Padlet which is a virtual bulletin/post-it-note board:

• Logging into Padlet
• Navigating around Padlet
• Searching for Padlets
• Creating a Padlet
• Changing the appearance of a Padlet
• Deleting a Padlet
• Adding Contacts
• Sharing a Padlet
• Embedding a Padlet into Moodle
• Padlet Housekeeping
• Security Settings

You do not need any prior knowledge of Padlet to join this course.

This course is suitable for anyone who has not used or has very limited knowledge of Microsoft Excel. The training will include:

• An overview and explanation of the main areas on an Excel spreadsheet
• Creating a new Excel workbook
• Entering, editing and deleting data in a Excel workbook
• Formatting text and numerical data
• Creating basic formulas to add, subtract, divide and multiply numeric data
• Using basic functions such as sum, min and max to perform calculations

The IT Training Team offer several different MS Excel courses. If you would like advice on your suitability for this course please contact ittraining@port.ac.uk.

**Please note this course is being retired at the end on May 2023.  It will be replaced with Microsoft Excel Core Skills

This course will introduce core MS Excel functionality such as creating formulas, creating and formatting charts and filtering data. The training will include:

• A review of basic formulas and functions
• Using relative and absolute cell references in formulas
• Using the order of precedence in formulas (BODMAS)
• Applying conditional formatting to enhance the appearance of data
• Creating and formatting charts
• Filtering data to create a subset of data
• Integrating MS Excel with MS Word

The IT Training Team offer several different MS Excel courses. If you would like advice on your suitability for this course please contact ittraining@port.ac.uk.

This course will introduce core MS Excel functionality such as creating formulas, creating and formatting charts and filtering data. T

The training will include:

• Overview of MS Excel
• Techniques to enter data
• Creating basic formulas and functions
• Absolute and Relative cell references
• IF statements
• Creating charts
• Using subtotals 
• Sorting and Filtering data

The IT Training Team offer several different MS Excel courses. If you would like advice on your suitability for this course please contact ittraining@port.ac.uk.

**Please note this course is being retired at the end on May 2023.  It will be replaced with Microsoft Excel Further Skills

This course will build on the functionality covered in the MS Excel Intermediate course by introducing techniques such as Lookup functions, IF Statements and Pivot Tables to analyse data. The training will include:

• Linking Excel Worksheets and Workbooks
• Creating IF statements to return values if a condition is met or not
• Using V Lookup functions to retrieve values
• Using Subtotals to return an aggregate result
• Creating Pivot tables to summarise and analyse data
• Creating a simple macro
• Methods for protecting a worksheet

The IT Training Team offer several different MS Excel courses. If you would like advice on your suitability for this course please contact ittraining@port.ac.uk.

This course will build on the functionality covered in the MS Excel Core Skills course by introducing techniques such as Lookup functions, IF Statements, Power Query and Pivot Tables to analyse data. The training will include:

• Formulas and Functions
  • Creating and using Formulas and Functions in Excel
  • Nested IF Statements
  • COUNT IF, COUNT IFS
  • SUM IF, AVERAGE IF, SUMIFS, AVERAGE IFS 
  • V Lookup
• Creating Pivot tables to summarise and analyse data
• Power Query to clean data

The IT Training Team offer several different MS Excel courses. If you would like advice on your suitability for this course please contact ittraining@port.ac.uk.

This course will cover how to create and customise a Pivot Table in MS Excel. Pivot Tables are used to summarise, sort, group and perform calculations on data stored in a MS Excel workbook. The training will include:

• An overview of Pivot Tables and why they are useful
• Creation of basic Pivot Tables
• Filtering and Grouping data
• Adding Slicers and Timelines
• Grouping and summarising data
• Enhancing the appearance of a Pivot Table
• Creating a Pivot Chart
• Updating data in a Pivot Table

We recommend that basic knowledge of MS Excel before booking onto this course. Please email IT Training if you would like more information

This course will will get you quickly up to speed with the basics of creating and delivering a presentation. The training will include:

• Navigating the PowerPoint interface
• Working with slides
• Adding content (text, images, tables, charts, smart art diagrams)
• Adding slide transitions
• Printing a presentation
• Presenting a PowerPoint presentation

This course will introduce some of the functionality that will make your PowerPoint presentation even more engaging. The contents includes

• Adding Videos to a presentation
• Using Zoom to create a summary slide
• Setting up master slides
• Turning your presentation into a video
• Creating a screen recording
• Adding animation
• 3D models

This course will explore techniques and functionality in MS PowerPoint to enable the creation of accessible presentations. The training will include:

• An exploration of the term Accessibility
• A brief overview of legislation relating to accessibility
• Explanations and demonstrations of the following techniques:
  • Selecting and using default layouts for slides
  • Ensuring each slide has a title placeholder
  • Use of numbered and bulleted lists
  • Adding Alternative Text to images
  • Creating meaningful hyperlinks
  • Inserting accessible tables
  • Checking reading order
  • Checking Colour Contrast
  • Using the Microsoft Office Accessibility Checker

This course will cover how to use MS Visio to easily create Flowcharts, Timelines and Organisational Charts. The training will include:

• An overview of Microsoft Visio and typical uses
• Locating and opening existing diagram templates
• Creating a Flowchart
• Creating a Timeline
• Creating an Organisational Chart
• Formatting and printing charts

You do not need any prior knowledge of MS Visio to join this course.

This course will explore techniques and functionality in MS Word to enable the creation of accessible documents. The training will include:

• An exploration of the term Accessibility
• A brief overview of legislation relating to Accessibility
• Explanations and demonstrations of the following techniques:
  • Use of styles to add structure to a document
  • Use of numbered and bulleted lists
  • Adding Alternative Text to images
  • Creating meaningful hyperlinks
  • Inserting accessible tables
  • Using the Microsoft Office Accessibility checker
• Saving a Word document as a PDF
• Checking a PDF for accessibility

If you need to create a project or thesis this is the course for you. The course will cover techniques you can use to organise your content and create a long document using MS Word. The training will cover:

Using Google Keep

• Setting up a note
• Creating a list
• Adding people to collaborate with
• Sync with Keep on a smart-phone

Setting Pinned tabs in Chrome

• Set up Group tabs in Chrome
• Colour coded tabs and moved them around

Features in MS Word

• Tour of the MS Word Ribbon
• Selection techniques
• Show/hide button
• Set up a document in Outline View and defined a master page
• Open and use the Navigation Pane
• Add and customise Heading styles
• Insert captions
• Apply bookmarks and cross-references to text
• Add footnotes and endnotes
• Discuss techniques for adding citations
• Creating an index, table of images and a table of contents
• Adding headers, footers, and page numbering using page and section breaks

This course will be shown how to use Grackle to ensure all your Google suite documents meet accessibility standards. The training will cover:

• Defining the term (digital) accessibility
• Create/edit accessible documents/sheets/slides using Grackle in Google Workspace
• Understanding general accessibility guidelines
• Using the Accessibility Checker
• Saving Google Suite files as PDFs and checking their accessibility in Adobe Acrobat

In this course will you discover a range of functionality which will enable you to manage your Google Calendar. The training will cover:

• Screen layout and customisation options
• Creating an event and displaying event details
• Managing an Event
• Sharing a Calendar
• Setting notification on calendars
• Creating an event on behalf of someone else
• Create new calendars
• Configuring settings
• Making bookable appointment slots

You do not need any prior knowledge of Google Calendar to join this course.

In this course you will discover the functionality available in Google Docs to create documents. The training will include:

• Creating and setting up a Google Doc
• Formatting the contents of a Google Doc
• Working with a multipage document
• Inserting a table into a Google Doc
• Insert an image into Google Doc
• Create a drawing using the canvas tool
• Inserting a chart into a Google Doc
• Inserting equations using the Equation Editor
• Checking the accessibility of the Google Doc using Grackle
• Sharing and Collaborating a Google Doc

You do not need any prior knowledge of Google Docs to join this course.

This course will cover the functionality in Google Mail. As well as email basics you will discover how to organise your inbox using labels and how to create filters. The training will include:

• Screen layout
• Managing your inbox using labels
• Searching for an email
• Creating Filters to organise emails
• Using Conversation View
• Composing Emails
• Adding Contacts
• Using Groups to send emails
• Using Canned Reponses
• Configuring Settings
• Using Chat

You do not need any prior knowledge of Google Mail to join this course.

If you are new to Google Drive this course is for you. In this course you will be introduced to Google Docs, Google Sheets, Google Slides and Google Forms. The training will include:

• Accessing Google Drive
• Creating online documents, sheets and forms in Google Drive
• Organising files in your Google Drive
• Creating a Shared Drive

You do not need any prior knowledge of Google Apps to join this course.

• Creating a Google Form
• Adding the following question types to a Google Form
  • Multiple Choice
  • Short Answer
  • Paragraph
  • Checkboxes
  • Drop-down
  • Linear Scale
  • Multiple Choice grid
  • Tick box grid
  • Date
  • Time
• Formatting the appearance of a Google Form
• Sharing a Google Form
• Viewing form responses

You do not need any prior knowledge of Google Forms to join this course.

This course will cover the core skills needed to create a Google Sheet. The training includes:

• Creating Google Sheets
• Inserting and formatting data
• Using Conditional formatting to enhance the appearance of data
• Creating basic formulas to calculate results
• Use basic functions to analyse data (sum, min, max, average, count, If)
• Using relative and absolute cell references in formulas
• Techniques to enforce data validation on a Sheet

You do not need any prior knowledge of Google Sheets to join this course.

This introductory course will cover how to use Adobe Acrobat DC to edit and combine PDF documents. The training will include:

• An overview of Adobe Acrobat DC
• Familiarisation of the Adobe Acrobat interface
• Combining multiple documents to create one PDF
• Extracting a page from a PDF document
• Inserting a page into a PDF document
• Editing an existing PDF document
• Adding headers and footers into a PDF
• Adding and customising bookmarks in a PDF document

You do not need any prior knowledge of Adobe to join this course.

This introductory course will cover how to participate in, host and schedule a Zoom meeting. The session will include demonstrations of functionality such as breakout rooms and polls as well as configuring meeting settings in the web portal and desktop client. The training will include:

• Using the features available as a host in a Zoom meeting
• Using the features available as a participant in a Zoom meeting
• Accessing the Zoom web portal to:
  • Configure key settings
  • Schedule meetings
  • Run and view reports
• Accessing the Zoom desktop client to:
  • Review settings
  • Check for updates

This course will cover the functionality of the Healix Travel App. The Healix Travel app allows authorised members of staff to monitor the whereabouts of staff and students who are overseas:

• Introduction to Web Interface which authorised staff will use to monitor the location of staff and students who are overseas.
• Logging in to the Healix Travel App
• Viewing locations of staff and students who are overseas
• Viewing Alerts and Notifications that have been reported in countries
• Viewing Risk Intelligence generated by the system
• Viewing Itineraries
• Uploading travel details into an itinerary
• Introduction to the App that staff and students will download and use when overseas

Please note: this course is only for staff authorised to use Healix Sentinel as part of their role. Please get your manager's approval before enrolling.