HELPDESK- General information and booking conditions (please read carefully)
- IT Baseline Needs Analysis
Spreadsheets, Databases & Statistics
Taught Courses
Learn how to use spreadsheets and manipulate spreadsheet data, build and revise formulae, sort and print data and much more using Microsoft Excel 2010. A thorough familiarity of Windows environment required.
This course contains material relevant to ECDL module 4
Find out how to use data lists and Pivot tables to extract, manipulate and analyse information in Excel 2010. Familiarity with Windows and a working knowledge of Excel, as found in the Introduction to Excel course, is required.
This course contains material relevant to ECDL module 4
On successful completion of this course participants will be able to create and edit Graphs and Charts using Excel 2010. Basic knowledge of Windows required.
Add to your knowledge of Excel in this 2x2 hour course. Use search techniques, Goal seek and Scenarios, interpret spreadsheet charts, use a spreadsheet as a simple database. A working knowledge of Excel, as found in the Introduction to Excel course, is required.
This course contains material relevant to ECDL module 4
In this one day session delegates will find out about tables and table relationships in Access 2010, use forms and reports, Access Wizards and Query-By-Example to retrieve data. Familiarity with computing and the Windows environment required.
This course contains material relevant to ECDL module 5
This course includes many of the topics listed in the Introduction to Access course above, only condensed into 2 sessions of 2 hours instead of a full day. Familiarity with computing and the Windows environment required.
This course contains material relevant to ECDL module 5
Understand some of the key features in the Minitab statistics application, including data types and organisation, parametric and non-parametric hypothesis tests and graphical representation of data. Familiarity with computing and a knowledge of statistical procedures required.
SPSS is a statistical package particularly suited to social science and survey data. Delegates will learn about the variety of user interfaces, data and command files, graphical representation of data and the philosophy behind the package. A familiarity of computing and statistical procedures required.
Online courses
This guide to Excel 2010 will take you through the basics of entering and editing data, performing calculations on data, using functions and creating charts. It will also demonstrate the importance of cell reference when performing calculations and using functions.
Material most suited to Arts Faculty and Social Science students but can also be of benefit to students from other faculties: Functions, Charts, GoalSeek and Scenarios, Pivot tables, Data Handling.
On successful completion of this course participants will be able to use Excel formulae to create and edit graphs and charts.
This self-study course will enable you to use and understand a Microsoft Access database. The assumption is that you have data of your own that you want to analyse and the ultimate objective in using these notes is to create a database for that data.
This course is relevant to ECDL Module 5
These self-study notes will enhance the skills acquired through study of the "Extended Skills" notes "Introduction to Microsoft Access (ECDL 5)". These notes are also suitable for those who have considerable experience of Microsoft Access through day-to-day use.
These self-study notes will enhance the skills acquired through study of the "Extended Skills" notes "Introduction to Microsoft Access (ECDL 5)". These notes are also suitable for those who have considerable experience of Microsoft Access through day-to-day use.
These self-study notes will enhance the skills acquired through study of the "Extended Skills" notes "Introduction to Microsoft Access (ECDL 5)". These notes are also suitable for those who have considerable experience of Microsoft Access through day-to-day use.
A free interactive self paced course to develop skills needed for ECDL.
