Courses by Topic

Please see ITS Training Courses by Date to see the list of courses in the current/next term by date order.

Training is available on the topics listed below. Note that Windows 7 and Microsoft Office 2010 is on the PCs where the training is taking place, and so Word, Excel, PowerPoint and Access will be taught using the 2010 versions.

Move to Office, Access, Excel, PowerPoint, Windows, Word, Email, Web, Graphics, or Statistics.

To find out more information about each session, click on the links provided by the session headings.

Numbers on each training session are limited and must be booked. Where five or fewer are booked on a session, IT Services reserves the right to cancel it.

Students can book through the course booking form (link on right), in person at an IT Services Help  Counter, via e-mail to ITS-help or phone x6262.

Staff should book through the Employee self-service or contact the Centre for Staff Training and Development by email.

Please note that any people that do not book the course beforehand may not be allowed onto the course on the day.

Notes:

Drop-In-And-Learn (Di&L) sessions are held throughout the year in Room 105, SaiL, First Floor, Whiteknights Library every Wednesday morning (10-12), and on Tuesday morning (10-12) and Thursday afternoon (2-4) during term time. A member of the IT Services Training staff will be on hand to get you started on any of the ITS training notes and help with any questions you may have.

All the taught courses listed below are held in S@il 108 on the first floor of the Main Library. 

 

Microsoft Office

This is the latest version of Microsoft Office being used on most of the campus and elsewhere. We run an introductory beginners session and also a more advanced hints & tips session:

• Introduction to Office  - Microsoft has completely redesigned the user interface for MS Office. Gone are the menus and toolbars, which are replaced by a tabbed ribbon. This one hour session introduces people to this new interface

• Microsoft Office - Hints & Tips is a 1-hour session and will focus on best practice, hints, tips, tools and techniques on how to save time and make the best use of MS Office

 

Microsoft Office - an Introduction (Level 1)

 

No sessions this term - come to drop-in for help

 

Microsoft Office - Hints and Tips (Level 2)

 

Fri 4 May

12:00-13:00

 

Microsoft Access

Microsoft Access is the supported database package at the University. We run 2 training sessions - one for beginners and the other for those who want to know more:

• Microsoft Access - A Beginners' Guide is split into two 2-hour sessions. These demonstrate what a relational database is, how it works, and how to set one up
• Microsoft Access - An Intermediate Guide is a 3-hour session covering more advanced features, including form design, macros and switchboards. Participants must be familiar with the contents of the Beginners' Guide

Microsoft Access - An Essential Guide (Level 1)

Essentials

Part 1: Part 2: Part 1: Part 2:

Fri 18 May Fri 25 May Thur 14 Jun Thur 21 Jun

10:00-12:00 10:00-12:00 10:00-12:00 10:00-12:00

Microsoft Access - An Intermediate Guide (Level 2) 

Thur 28 Jun

10:00-13:00

Microsoft Excel

Microsoft Excel is the supported spreadsheet package at the University. We run 3 training sessions - one to show what you need to know to use Excel, one for those with a good knowledge of spreadsheets already and the third for those who want to know even more.

• Microsoft Excel - An Essential Guide is a 2-hour session which introduces participants to Excel, developing a simple example and producing a chart with the data
• Microsoft Excel - An Intermediate Guide is a 2-hour session which uses a scientific dataset to show more complex graphs, sorting and selecting, and analysis tools, including a pivot table. Participants must be familiar with the contents of the Beginners' Guide
• Microsoft Excel - Hints & Tips is a 1-hour session and will focus on best practice, hints, tips, tools and techniques on how to save time and make the best use of MS Excel
• Microsoft Excel - Advanced Topics: Participants can come to a general workshop where they choose which topics they want to learn, and then work through these topics themselves with guidance. Advanced sessions on specific topics will be run during the Spring term. These cover a wide range of more specific and complex tasks, including splitting and freezing windows, extending a series, security (protecting all or parts of a worksheet), pivot tables, adding comments, writing macros, functions, animation and an introduction to visual basic programming.

Microsoft Excel - An Essential Guide (Level 1) 

Tues 8 May Thur 31 May Fri 15 Jun

14:00-16:00 10:00-12:00 10:00-12:00

Microsoft Excel - An Intermediate Guide (Level 2)

Tues 15 May Thur 7 Jun Fri 22 Jun

14:00-16:00 10:00-12:00 10:00-12:00

Microsoft Excel - Hints and Tips (Level 3)

Fri 25 May

12:00-13:00

Microsoft Excel 2010 - Advanced Guides (Level 3)  

Macros VBA Programming Workshop (All Topics)

Wed 23 May, 16:00-18:00 Wed 30 May, 16:00-18:00 Wed 13 Jun, 16:00-18:00

 

Microsoft PowerPoint

Microsoft PowerPoint is the supported presentation and graphics package. Hands-on training is given in a 2-hour session, which shows what you need to know to use PowerPoint. For those wishing to know more, there is a hints & Tips session and a series of notes on Advanced topics is available.

• Microsoft PowerPoint - An Essential Guide is a 2-hour session which introduces participants to PowerPoint, developing a simple example which includes using the drawing tools
• Microsoft PowerPoint- Hints & Tips is a 1-hour session and will focus on best practice, hints, tips, tools and techniques on how to save time and make the best use of MS PowerPoint
• Microsoft PowerPoint - Advanced Topics: Participants can come to a general workshop where they choose which topics they want to learn, and then work through these topics themselves with guidance. Advanced sessions on specific topics will be run during the Spring term. These cover a wide range of more specific and complex tasks, including animation of text and objects, colour schemes, templates and slide masters, linking presentations, action buttons, running and rehearsing presentations. 

Microsoft PowerPoint - An Essential Guide (Level 1-2)

Thur 17 May	10:00-12:00
Tues 12 Jun	14:00-16:00

 

Microsoft PowerPoint - Hints and Tips (Level 3)

Fri 18 May

12:00-13:00

Microsoft PowerPoint 2010 Advanced Guides (Level 3)

Workshop (All Topics)

Fri 8 Jun

10:00-12:00

 

Microsoft Windows

Microsoft Windows is the operating system on ITS lab computers (note that it is now Windows 7). Hands-on training is given in a 2-hour session.

• A Guide to Microsoft Windows is a 2-hour session which introduces participants to Windows and shows those already familiar with the system how to make the most of it

Microsoft Windows - an Introduction (Level 1)

No sessions this term - come to drop-in for help 

Microsoft Word

Microsoft Word is the supported wordprocessing package at the University. We run 5 training sessions - an essential for those starting out with Word or who haven't used it for some time; an intermediate one for those already familiar with wordprocessing; one on various hints and tips in Word; an advanced for those who want to know even more; and finally one for those who need guidelines on writing a thesis/dissertation (split into parts 1 and 2).

• Microsoft Word - An Essential Guide is a 2-hour session designed for those starting out with Word or who haven't used it for some time
• Microsoft Word - An Intermediate Guide is a 2-hour session and covers much more ground. It is targeted at those students who have done some wordprocessing before, but who want to learn how to use Word properly
• Microsoft Word - Hints & Tips is a 1-hour session and will focus on best practice, hints, tips, tools and techniques on how to save time and make the best use of MS Word
• Microsoft Word - Advanced Topics: Participants can come to a general workshop where they choose which topics they want to learn, and then work through these topics themselves with guidance. Advanced sessions on specific topics will be run in the Spring term. These cover a wide range of more specific and complex tasks, including Equations, Mail Merge, Tables, Graphics, Macros, Tracking Changes, Forms, and AutoText
• Microsoft Word - Writing a Thesis is split into two 2-hour sessions, the first part dealing with matters of importance when starting a thesis (e.g. creating a special thesis template, typing the content), and the second when finishing a thesis (e.g. controlling the layout, final steps such as a table of contents and title page). Both sessions look at how to make the best use of Microsoft Word when writing a thesis (or other long document)

Microsoft Word - An Essential Guide (Level 1)

Thur 3 May

10:00-12:00

Microsoft Word - An Intermediate Guide (Level 2)

Thur 10 May

10:00-12:00

Microsoft Word - Hints and Tips (Level 3)

Fri 11 May

12:00-13:00

Using Word for a Thesis (Level 3)

Starting Finishing Starting Starting Finishing

Fri 4 May Fri 11 May Thur 24 May Tues 19 Jun Tues 26 Jun

10:00-12:00 10:00-12:00 10:00-12:00 14:00-16:00 14:00-16:00

Microsoft Word 2010 Advanced Guides (Level 3)

Workshop (All Topics)

Fri 1 Jun, 10:00-12:00

Email and the World Wide Web

Within Internet Explorer, students can read their University email via the new readingLive system (most staff will use OWAmail - Outlook Web Access). Electronic mail (email) allows you to communicate quickly and easily with colleagues on campus and around the world. For more help on using the new email system, see Welcome to readingLive 

The World Wide Web is a rapidly-expanding source of up-to-the-minute, worldwide, on-line information.

• WWW - A Beginners' Guide is a 1-hour session designed for complete beginners. It introduces participants to the World Wide Web, showing them how to move around and search Web pages and save interesting sites as favourites

WWW - A Beginners Guide to Internet Explorer (Level 1)

No sessions this term - come to drop-in for help

 

Creating Web Pages

Any member of the University can publish a personal page on the WWW, providing it does not break the agreed rules.

We offer a training session (2 hours) that shows you how to create a simple Personal Home Page using Microsoft Word.

Creating Personal Web Pages Using Microsoft Word (Level 2)

Tues 29 May

14:00-16:00

Note: For training on the CMS (Content Management System) used for official University web pages, look at the Centre for Staff Training and Development web site (search for 'content' within the CSTD programme).

 

Graphics

Office contains drawing tools that are mostly used in either Word or PowerPoint. Hands-on training is given in a 2-hour session, which introduces participants to the drawing tools.

• Using the Office Drawing Tools is a 2-hour session which introduces participants to the drawing tools within Draw and how to use them. These include drawing basic shapes such as boxes, circles, lines and arrows and grouping them together, for example to create a flowchart

Using the Office Drawing Tools (Level 2)

Tues 22 May

14:00-16:00

 

Statistics

Expertise on statistical computing, including use, programming and application of statistics software is provided by the Department of Mathematics and Statistics.

They have produced getting started tutorials for staff and students at the University for Minitab, SPSS, Genstat and SAS. These can be downloaded from a Blackboard organisation and worked through in your own time.

For further information on accessing these tutorials, other computing tip sheets and if you require more detailed statistical advice, go to the Statistics Packages Tutorials page.

Note that there will be no more statistical computing packages booked sessions, and that Statistics advice is not given in the regular Drop-in-and-Learn sessions.