Browser does not support script.

Digital resources

Digital Training Courses

Hands-on, one hour, practical courses

OF2: Collaborative working with Office 365 including Teams

Prior knowledge: None

Office 365 offers many ways to work collaboratively.  Files stored in OneDrive can be accessed from anywhere online and can be shared and simultaneously worked on. Microsoft Teams provides an easy way to work collaboratively with other staff and students. This course can be customised for different teams or delivered to student groups.

This course includes:

  • Getting into Office 365
  • Using Office online apps
  • Working with OneDrive to store documents
  • Sharing personal documents and collaborative editing
  • Creating and managing Microsoft Teams
  • Managing Team files in OneDrive
  • Key apps for Team based collaborative working including Planner and OneNote

Book via Eventbrite Digital Training Collaborative Working Courses. These courses are for students and staff only. If there are no suitable dates for the course that you want then email digitaltraining@yorksj.ac.uk.

Data and Survey courses including Excel

A range of courses covering different aspects of using Excel to anter, manage and analyse your data.

EX1: Essentials

Prior knowledge: None

Open Badge Available - Excel Essentials

This course will introduce the concepts and basic tools of Excel providing a sound basis to begin making and using Excel sheets.

This course includes:

  • Storing data and formatting numbers
  • Changing the appearance of cells and copying formats  
  • Copying formats and formulae
  • Performing calculations
  • Using sum and average
  • Freezing titles
  • Defining a print area
  • Sorting and filtering data.
  • Moving cells
  • Saving work
  • Undo
  • Help
  • Modifying clip art, smart art and images

Book via Eventbrite Digital Training Data & Survey Courses. These courses are for students, staff and alumni only. If there are no suitable dates for the course that you want then email digitaltraining@yorksj.ac.uk

EX1 Excel Essentials course sample file

EX2: Making sense of Excel data

Prior knowledge: Basic Excel skills equivalent to Excel1

Open badge available - Excel: Making sense of data

This course builds on Excel1 to make spreadsheets that are more robust for data entry and that help to analyse the data that they hold.

This course includes:

  • Using conditional formatting to highlight data
  • Validating entries using lists
  • Using Sparklines to show trends
  • Using tables to display data
  • Managing sheets, columns and windows
  • Using custom cell formats

Book via Eventbrite Digital Training Data & Survey Courses. These courses are for students, staff and alumni only. If there are no suitable dates for the course that you want then email digitaltraining@yorksj.ac.uk

Excel 2 example file (XLSX, 0.2MB)

EX3: Manipulating data using formulae 

Prior knowledge: A good knowledge of common Excel features

This course will help you understand and build more complex formulae to create active worksheets.

Open Badge Available - Excel: Manipulating data using formulae

This course includes:

  • Understanding different cell references
  • Using named ranges
  • Order of evaluation for formulae
  • Using IF and CountIf formulae
  • Using concatenate (&)
  • String manipulation using Left, right, mid, len
  • Different types of pasting

Book via Eventbrite Digital Training Data & Survey Courses. These courses are for students, staff and alumni only. If there are no suitable dates for the course that you want then email digitaltraining@yorksj.ac.uk

Excel3 example file.xlsx (28.6 kb)

EX4: Excel pivot tables

Prior knowledge: A good knowledge of common Excel features

Pivot tables can be used to summarise large tables of data in Excel#

This course includes:

  • Formatting data for Pivot tables
  • Creating Pivot tables
  • Basic Pivot controls
  • Adding calculated fields
  • Sorting and sifting
  • Highlighting cells using conditional formatting
  • Pivot charts
  • Printing a Pivot table

Book via Eventbrite Digital Training Data & Survey Courses. These courses are for students, staff and alumni only. If there are no suitable dates for the course that you want then email digitaltraining@yorksj.ac.uk

Excel 4 Pivot example

Document Creation Courses 

Making great looking, accessible documents using the features of Word or InDesign.

When writing a dissertaion or PhD, use Word features to make page breaks, numbering and tables of contents easy.

Use mail merge to create personal letters, e-mails and labels in bulk. 

AD1: Making accessible documents

Digital Training Document Creation Courses

We are happy to lay on additional courses at times to suit. Email digitaltraining@yorksj.ac.uk.

Prior knowledge: none

Making documents accessible is important for everyone, not just those with visual impairments, hearing impairments and mobility limitations. As well as being best practise, new regulations are coming into force for all websites. Learn how to make Word documents, PowerPoint presentations, Excel Spreadsheets and PDFs accessible in a few easy steps. This course can be customised for different teams or delivered to student groups.

This course includes:

  • Using the built-in accessibility checkers
  • Using heading styles for structure
  • Making images accessible
  • Creating accessible tables
  • Creating accessible hyperlinks
  • Other aspects of accessibility
  • PowerPoint and Excel Accessibility
  • Brief discussion of other YSJ systems

Book via Eventbrite Digital Training Document Creation Courses . These courses are for students and staff only. If there are no suitable dates for the course that you want then email digitaltraining@yorksj.ac.uk.

Learn more with LinkedIn Learning: Creating Accessible Documents in Microsoft Office   Creating accessible PDF

Moodle course Digital Accessibility Moodle Training

Useful resource on writing ALT text for images called Poet Training Tool

 

Sample Files

Non-accessible Word document

Non-accessible PowerPoint presentation

Non-accessible Excel

 

Sample marking grids and tables.docx (DOCX, 34.1 kB)

 

WO1: Word Essentials

Prior knowledge: None

Open Badge Available - Word Essentials

This course will introduce the basic features of Word to give a good grounding in how to manage documents easily.

This course includes:

  • Changing the appearance of text 
  • Copying styles using the format painter 
  • Using spell check 
  • Controlling page breaks 
  • Using cut, copy and paste effectively 
  • Adding and manipulating pictures 
  • Saving and version control 
  • Zooming and changing the document views 
  • Using a coloured background  
  • Setting up pages and margins 
  • Adding basic page numbering  
  • Setting tabs on the ruler

Book via Eventbrite Digital Training Document Creation Courses. These courses are for students, staff and alumni only. If there are no suitable dates for the course that you want then email digitaltraining@yorksj.ac.uk

WO2: Essay & dissertation skills

Prior knowledge: Basic Word skills equivalent to Word1

Open Badge Available - Word: Essay and Dissertation Skills

This course focuses on writing academic essays in Word. Making the most of Word features to control page breaks, numbering and automatic table of contents.

This course includes:

  • Applying and amending heading styles 
  • Automatic table of contents 
  • Showing hidden formatting marks 
  • Making sections start on a new page 
  • Adding headers and footers 
  • Using section breaks to change page number styles 
  • Using languages, spelling and grammar check 
  • Checking word count 
  • Using the navigation pane 
  • Search and replace 
  • Controlling line spacing 
  • Adding captions

Book via Eventbrite Digital Training Document Creation Courses. These courses are for students, staff and alumni only. If there are no suitable dates for the course that you want then email digitaltraining@yorksj.ac.uk

Sample Word file

WO3: Layout in Word

Prior knowledge: A good knowledge of common Word features  

Open Badge Available: Word Professional Layout 

This course focuses on techniques to create professional looking documents quickly as well as understanding the tools needed to provide visually appealing work. 

This course includes:  

  • Text boxes, smart art and shapes 
  • More about language settings and spell check 
  • Formatting tables 
  • Adding hyperlinks 
  • Creating PDFs 
  • Aligning items using complex tabs on the ruler 
  • Working with themes 

Book via Eventbrite Digital Training Document Creation Courses. These courses are for students, staff and alumni only. If there are no suitable dates for the course that you want then email digitaltraining@yorksj.ac.uk

MM1: Mail Merge Essentials in Word

Prior knowledge: Reasonable day to day experience using Word

Rather than addressing multiple letters by manually editing names and addresses, it is quicker to let these details to be filled automatically into a template. Create bulk letters, e-mails and labels easily.

The course includes:

  • Creating a recipient list in Excel
  • Starting a merge
  • Using merge fields
  • Previewing the merge
  • Saving and re-using the mail merge
  • Merging to e-mail
  • Creating labels

Book via Eventbrite Digital Training Document Creation Courses. These courses are for students, staff and alumni only. If there are no suitable dates for the course that you want then email digitaltraining@yorksj.ac.uk

WO4: Research & PHD writing

Prior knowledge: Reasonable day to day experience using Word.

Writing very long documents and working collaboratively is made easier using some of the tools in Word. It is beneficial to begin using these tools at the start of writing to gain the greatest benefit. This course can be tailored to your individual requirements.

The course includes:

  • Applying and amending heading styles 
  • Automatic table of contents 
  • Showing hidden formatting marks 
  • Making sections start on a new page 
  • Adding headers and footers 
  • Using section breaks to change page number styles 
  • Using languages, spelling and grammar check 
  • Checking word count 
  • Using the navigation pane 
  • Search and replace 
  • Controlling line spacing 
  • Adding captions
  • Controlling comments and tracking changes
  • Using auto-correct and quick parts to add text
  • Paragraph options and line numbers
  • Master documents - pros and cons

Book via Eventbrite Digital Training Document Creation Courses. These courses are for students, staff and alumni only. If there are no suitable dates for the course that you want then email digitaltraining@yorksj.ac.uk

ID1: InDesign Essentials

Prior knowledge: None

This course provides an introduction to InDesign to produce leaflets.

This course includes:

  • Understanding the workspace
  • Adding text and images
  • Wrapping text around images
  • Managing colours
  • Managing styles
  • Type on a path
  • Embedding images
  • Flowing longer texts
  • Saving and exporting

Book via Eventbrite Digital Training Document Creation Courses. These courses are for students and staff only. If there are no suitable dates for the course that you want then email digitaltraining@yorksj.ac.uk

ID2: Speeding up InDesign production

Prior knowledge: Basic skills with InDesign equivalent to Indesign1

This course adds features aimed at handling more documents in InDesign. We will look at setting up styles to maintain consistency, using master pages to provide constant backgrounds and libraries to gain quick access to to commonly used objects.

This course includes:

  • Using master pages
  • Headers and footers
  • Using layers
  • Guides, rulers and tabs
  • Using a library
  • Page numbers and references

Book via Eventbrite Digital Training Document Creation Courses. These courses are for students, staff and alumni only. If there are no suitable dates for the course that you want then email digitaltraining@yorksj.ac.uk

Video, Audio, image & screen-casting courses

 Creating and manipulating still images, video and audio

PS1: Photoshop Essentials

Prior knowledge: None

Adobe Photoshop is excellent at manipulating bitmap images. It can be used to scale and prepare existing images for web and print use as well as having the tools to create from scratch. This introductory course will suit people getting started with Photoshop and preparing images for uses such as the York St John website.

This course is made up of two halves which together form an introduction to Photoshop.

If you want to cover the minimum requirements for editing the university website, the first half hour covers.

  • Understanding the workspace
  • Cropping existing images
  • Resizing images
  • Saving for the Web
  • Understanding image formats

The second half hour extends this to cover

  • Using filters and corrections
  • Using the text tool
  • Handling difficult shaped images
  • Compositing multiple images
  • Saving for different uses
  • Adding a background

Book via Eventbrite Digital Training Video, Audio, Image & Screen-casting Courses. These courses are for students, staff and alumni only. If there are no suitable dates for the course that you want then email digitaltraining@yorksj.ac.uk

If you prefer self-paced online learning then our Lynda.com online course may suit you. Photoshop CS6 Essential Training Note for those wanting to edit the University website the hands-on course is required.

PS2: Photoshop Layers and cutting out

Prior knowledge: Basic skills with Photoshop

This course covers more skills in Photoshop to amend existing images by cutting objects out from the background or creating from scratch.

This course includes:

  • Using masking to cut out images
  • Magic wand tool
  • Working with layers
  • Clone brush
  • Using brushes
  • Using colours and gradients
  • Orientation of other tool

Book via Eventbrite Digital Training Video, Audio, Image & Screen-casting Courses. These courses are for students, staff and alumni only. If there are no suitable dates for the course that you want then email digitaltraining@yorksj.ac.uk

Alternative online learning: Lynda.com online courses Photoshop CS6 Selections and Layer Masking Workshop

SC1: Screen-casting essentials

Prior knowledge: None

Create videos at your desktop using our screencasting software Screencast-o-matic

This course includes:

  • Recording desktop and/or webcam video
  • Make edits
  • Re-recording
  • Add annotations, overlays and more
  • Producing and uploading finished videos
  • Managing Screencast-o-matic files

Book via Eventbrite Digital Training Video, Audio, Image & Screen-casting Courses. These courses are for students and staff only. If there are no suitable dates for the course that you want then email digitaltraining@yorksj.ac.uk

Staff courses (requiring pre-approval)

WPM Online store courses

For staff wishing to gain access to edit or see data from the online store, you must apply to finance for an account using the form on the Intranet 

Fill in the Online Store User Access Application

You will require training which can be arranged by contacting digitaltraining@yorksj.ac.uk

For users who have an account and have had training edit the online store

LA1: Learning Analytics (Ascend) Introduction

Ascend is the Learning Analytics system at York St John to support the tutorial process. It takes data from various systems and produces an engagement rating. It allows records from tutorial interactions to be kept and referrals to other university services to be made. Tutors can receive notifications of sustained high or low engagement.

FAQ

Is this course open to anyone?

Book via Eventbrite Digital Training Staff only Courses. These courses are for staff only. If there are no suitable dates for the course that you want then email digitaltraining@yorksj.ac.uk.

Staff courses (open to all staff)

These courses are only available to staff of York St John.

Learning Analystics and Office 365 Bookings are open to all staff

 

WPM2: WPM online store listing products

Prior knowledge: None

Pre-requisites: York St John staff only

The WPM online store is the web store attached to the university website. This course covers the key skills to add products.

This course includes:

  • Adding a product
  • Adding questionnaires
  • Amending e-mail templates
  • Getting product reports

For staff wishing to gain access to edit or see data from the online store, you must apply to finance for an account using the form on the Miscellaneous tab on the Finance Forms page. You will require training which can be arranged by contacting digitaltraining@yorksj.ac.uk

For users who have an account to edit the online store

WPM3: WPM online store listing conferences and events

If you are using the conference portion of WPM you need to get approval from finance as above

WPM4: WPM online store reporting only

If you are just accessing data from WPM online store you need to get approval from finance as above.

Cookie Settings