Training 2

Research at St George’s investigates and develops new, pioneering methods and treatments to improve health at a local, national and international level with a growing portfolio of collaborations in Asia, Europe, Africa and the Americas.

We face-to-face training in Microsoft Office applications such as Word, Excel, Powerpoint and Outlook with an experienced IT Trainer.

 

Where do the Microsoft Office workshops take place?

Most courses take place in the Library Training room 1st floor Hunter wing. All course confirmation will come with the date, time and place of the workshop.

You don't offer the training I need, what should I do?

Contact This email address is being protected from spambots. You need JavaScript enabled to view it. and we will discuss your training needs.

 


Access and eligibility

Who are the workshops for?

All workshops are for University staff and students.

What should I do if I have to cancel my booking?

Send an email to This email address is being protected from spambots. You need JavaScript enabled to view it. to cancel and let us know if you wish to be booked on another date or course.

 


Making a booking

How do I make a booking?

Send an email to This email address is being protected from spambots. You need JavaScript enabled to view it.

What if the course I want is fully booked?

Depending on your urgency to learn a manual can be sent for you to work through or you can arrange a 1-2-1 for 1 hour depending on your needs and knowledge of the application.

What if I can't make any of the available dates?

We will book you on the next date available or depending on your urgency to learn, a manual can be sent for you to work through or you can arrange a 1-2-1 for 1 hour depending on your needs and knowledge of the application.

 


Other information

What happens if IT Training have to cancel a course?

You will be sent an email of the cancellation and will be given an alternative date and time.

I still haven't had my question answered, how do I contact you?

We are based in the library 1st floor Hunter wing, you can also contact us by phone on extension 5662.

Do you provide 1-2-1 support?

Yes. Face to face, email or over the telephone.

MS-Office-Drop-inlogo

IT support is offered to assist in the use of Microsoft Office 2013 on a drop in basis in the library foyer:

Monday 11am - 1pm
Friday    11am - 1pm

 

Do you provide tailored IT training session for departments and individuals?

Yes. Contact us by email This email address is being protected from spambots. You need JavaScript enabled to view it. or phone extension 5662 to discuss your requirements.

*ECDL training at St George's Library will be discontinued from the end of July 2017*

 

ECDL image

 

 The European Computer Driving Licence (ECDL) is an internationally recognised IT qualification  in over  135 countries by employers. It is designed to improve your confidence and knowledge in using desktop applications in Microsoft Windows and Office 2013. It is certified in the UK by the British Computer Society (BCS).

St George's, University of London, is an accredited Test Centre for the European Computer Driving Licence (ECDL) and it is available to all staff and students.

 


Download ECDL Registration Form


New Flexible ECDL Level 2 Certificate (available for Office 2013)

Flexible ECDL allows you to combine modules to create an ECDL qualification to suit your needs across levels 1, 2 and 3 to create an ECDL qualification around your needs. ECDL has introduced some new modules to give you more choice. The table below provides you with the module choices at each level.

Credit values

Module

Level 1

Level 2

Improving Productivity using IT

3

4

IT user fundamentals

3

 

IT security for users

1

 

Using the internet and email

5

 

Using collaborative technologies

3

 

Database software

3

4

Presentation software

3

4

Project management software

 

4

Spreadsheet software

3

4

Word processing software

3

4

 

When completing the ECDL Flexible certificate the Improving Productivity Using IT module is mandatory* at both levels which gives 3 credits at level 1 and 4 credits at level 2 .

ECDL Flexible Certificate

Level 2

Minimum Credit Value

16

Maximum Credit Value

20

Mandatory Module*

L2 Improving Productivity Using IT (4 credits)

See ECDL Level 2 Module Information

To find out more about the course, contact This email address is being protected from spambots. You need JavaScript enabled to view it.

 

Back to the top  


ECDL Core seven modules Level 2 Certificate (available for Office 2013)

ECDL can be studied by a beginner or by confident computer users wishing to improve and prove their computing skills for personal use and in employment.

See ECDL Level 2 Module Information

ECDL Core

IT User Fundamentals

Word Processing

Security for IT Users

Spreadsheet

Using Email and the Internet

Presentation

Access database

 

Back to the top
 


Learning materials & support available

You can attend workshops to gain the knowledge that is required but as an approved test centre, you can also sit each of the assessments using our online testing system. The training material assumes no prior expertise and offers a flexible way to study for the qualification.

  • Online training materials
  • One-to-One Support from a qualified trainer.
  • Group workshops every two weeks
  • Hands on drop in workshops with time for Q&A.

Back to the top  


How much will it cost?

Free to all SGUL staff and can be used as part of their personal development.

Below are the costs for: NHS Staff, Faculty Staff and all students.

Qualification

Registration Price

Tests

On-line Training
Modules

Total

ECDL Core

£25.00

7 x £8.50 = £59.50

7 x £6.50 = £45.50

£130.00

Flexible ECDL Certificate

£37.00

5 x £8.50 = £42.50

(May vary)

5 x £6.50 = £32.50

(May vary)

£112.00 

Test re-takes

£8.50 per unit

     

Back to the top  


Requirements

There are no formal entry requirements. You must be very self-motivated and committed to attending regularly. Acces to the internet and the ability to work independently is also essential.

At the end of each module you will be assessed to guage what you have learnt and if you are ready to take the test. You are given 45 minutes to take each test and the pass mark is 75% for each module.

More testing information:

To gain the qualification you will need to pass each module test.

You are given 45 minutes for each test

Back to the top 


Level 2 Module Information

Flexible ECDL - Level 2 units

Word processing

Develops the learner’s ability to create word-processed documents: entering text, editing and formatting work, using graphs, tables and pictures for a professional finish, and effectively using tools such as the spell-checker and mail merge.

Spreadsheet software

Helps the learner develop a working knowledge of spreadsheets, from entering data and formatting worksheets, to creating charts and producing high-quality documents.

Presentation software

Shows the learner how to produce high-quality presentations using a variety of tools including charts, graphs and drawn objects.

Database software

Looks at creating and modifying tables, queries, forms and reports, and preparing outputs ready for distribution, as well as learning to relate tables and retrieve and manipulate information using query and sort tools.

Improving productivity using IT

Enables the learner to work more effectively with IT. This unit looks at using tools to save time and effort when producing word processed documents, presentations and spreadsheets.

Project management software

Shows learners how to use a wide range of project management software tools and techniques to input and edit information to support the planning and management of projects.

Using collaborative technologies

 

IT user fundamentals

 

IT security for users

 

Back to the top

We provide free downloadable Microsoft Office training manuals with exercises and flexible web based learning.

 

New Microsoft Office Training manuals

Please note, these files are password-protected. You will be redirected to the Portal pages where you will be required to log in with your SGUL credentials.

Word - Adding page numbers to landscape pages

Word – Reports quick sheet

Word - Building Blocks - zipped folder

Excel – Add or subtract time

Excel - Gantt Chart

Excel - Sharing and Protecting Data - zipped folder

Excel - Functions

Excel - Referencing

Intro PowerPoint quick sheet

 

How to unzip folders to access documents.

  1. Save the zipped folder.
  2. Right click when hovering over the folder and select 'Extract all' or 'Extract files' to begin process.

 

If what you want to learn is not available please let us know.

Free downloadable Microsoft Office 2010 training materials

Please note, these files are password-protected. You will be redirected to the Portal pages where you will be required to log in with your SGUL credentials.

Microsoft Access 2010

Microsoft Excel 2010

Master Documents

SmartArt

Tracking Changes

Outlook 2010 Colour Categories - Learn how to assign a colour category to a group of interrelated items − such as messages, contacts, notes, appointments, so that you can easily access or organise them.

Free flexible web-based learning

You can get flexible web based-learning on: Management, Office 2010 and Office 2013 (details of what you can learn below).

To access the web based learning materials, send an email to This email address is being protected from spambots. You need JavaScript enabled to view it. requesting what you wish to learn.

You get 3 months access to each set of learning materials, which can be extended if needed.

 

Management Training

management training image

Management Training will assist you in developing some essential skills, or prepare you for the profession. It covers 5 subjects.

  • Business Strategy
  • Motivation and Teamwork
  • Performance Management
  • Planning and Organising
  • The Five Principe of Business Leadership

 

MS Word 2010

Basic - Create a new document, insert and edit & formatting text, copy and move data, insert images within a document. Use the spell check, printing preview and saving a file.

Intermediate – Insert and format a Table, add headers and footers, insert sections, symbols, hyperlinks, Smart Art, Track changes, Create address labels, using the Go to function, Find & replace tool.

Advanced - Mail merge and forms, add a water mark, Footnotes, insert an Excel worksheet, Digital signatures, updating the table of contents, insert a cover page

 

MS Word 2013

Basic - Create a new document, enter, amend & formatting text, copy and move data, Navigation & selection techniques. Page Layout, Use the spell check, printing preview and saving a file, Bullets & numbering lists, Insert and format a Table.

Intermediate – Quick Parts, Section Breaks, Insert Headers & Footers, Styles, table of Contents, Cover page, Inserting Images, SmartArt, Style set & Themes, Inserting symbols, Borders 7 Shading, Tables & Columns

Advanced - Mail merge and creating forms, add a water mark, Track Changes & Comments, Protect a document, Create forms, Macros, user Accounts , Footnotes & Endnotes

 

MS Excel 2010

Introduction - Create a spreadsheet and input data. Create simple calculations, Summing cells, change page orientation, insert an Image, edit, delete, move, copy and manipulate data, format spreadsheet and printing, insert a pivot table

 

MS Excel 2013

Intermediate – Create a Sparkline, filtering data, name a range, AutoSize columns, Editing Formulae, Formula Auditing, calculate the average, Sorting, Freeze Panes, Create a chart, Scenarios, Changing Chart type, Merge & Centre

Advanced – VLOOKUP function, Paste special (Transpose Values) Working with XML Data, Import test, Delete Duplicate Data, Conditional formatting, Password protect a Workbook.

 

Back to the top

A selection of online tutorials and e-learning packages.

Medical and health related

Armando Hasudungan Biology and Medicine Videos
Extensive series of sketch note style Biology and Medicine videos created by Amando Hasudungan who started the series as a medical student.

Cell Signalling Biology
Describes the biology of cell signalling. The emerging information on cell signalling pathways is integrated and presented within the context of specific cell types and processes.

Clinical Skills Online
Online videos demonstrating core clinical skills common to a wide range of medical and health-based courses. From the e-Learning Unit at SGUL. A CSO Youtube channel is also available.

Cochrane Library
There are three Cochrane Library modules, scroll down to 'Online self-paced tutorials'.

Drug Calculations & Numeracy testing
Drug calculations quiz designed to assist in learning the principles of metric conversions, fluid dosage calculations, tablet dosage calculations and Intravenous drop rate calculations.

Medical Masterclass
Interactive Mock MRCP Part 1 and 2 Exams website
Ask at the Library helpdesk for a username and password. *Only available to medical trainees*

NEJM - Videos in Clinical Medicine - onsite access
Peer reviewed educational videos that demonstrate clinical procedures and physical examinations
For offsite access select "Log in via your institution" option. *Offsite access only available to SGUL staff and students*

PathCal onsite access
PathCAL is a series of online tutorials covering a wide range of pathology and pathophysiology subjects produced and published by the College of Medicne and Veterinary Medicine at the University of Edinburgh.

PathCal offsite access: select St George's, University of London from the drop down box. *Offsite access only available to SGUL staff and students*

PubMed
The PubMed Tutorial is a Web-based learning program that will show you how to search PubMed, the National Library of Medicine's (NLM) journal literature search system.

St George's, University of London MOOCs
Check for online courses created by St George's University of London on the FutureLearn platform

 

Statistics

Rice Virtual Lab in Statistics
Provides demonstrations for statistical concepts, case studies, basic statistical analysis tools and an online statistics book.
Developed by David Lane - Associate Professor of Psychology,
Statistics,and Management at Rice University, USA.

Khan Academy
A collection of video tutorials on statistics developed by Khan Academy.

 

More Articles ...

  1. Training