University Certificate in Office Professional

University Certificate in Office Professional

Course ID:
PC90205

Academy:
Maths, Science & IT

Introduction:
This programme is designed for adults returning to education after a career break, or as a progression route to a foundation or honours degree. It is suitable for people who use IT as part of their job, but who have no formal IT qualification. As the programme is franchised from the University of Central Lancashire (UCLan) you will enrol at both Preston College and UCLan, and have access to both Preston College and UCLan`s facilities, including UCLan`s library and student union.

The module on this programme is studied via distance learning, with all study materials available online. Tutorial sessions will be held at Preston College`s Fulwood Campus for thosse wishing to access tutor support.

Study Mode & Location:
This course(studied flexibly by distance learning) should be completed within an academic year or less.

Course Content:
You will study:

Extended Excel

• Use of Macros
• Look up tables
• Advanced Functions
• Dynamic Linking
• Filter Worksheet Data

Rational Databases

• Creating and Editing Tables
• Query Design
• Creating Relationships between Tables
• Input Masks
• Report Design
• Exporting to other applications

Assessment:
This module has three pieces of assessed coursework and a portfolio.

Careers & Progression Opportunities:
The programme will develop your skills so that you will be better equipped to use IT in the workplace or home. Once you have completed this University Certificate, you may wish to continue your studies to achieve an Advanced University Certificate in ICT. Alternatively the module is part of a Foundation Degree in ICT and you may wish to use this module to gain credit towards this qualification or study a number of the modules part-time.

How To Apply

Full-time Students
You will need to complete a UCAS application form. The majority of applications are now completed using `UCAS apply`, a web-based on-line application system.You will need to include the following information on your application form:

• 
  
  Institution code name:
  CLANC
• 
  
  Institution code:
  C30
• 
  
  Campus code:
  P

'

Help, Advice & Further Information
If you know of someone who would like to study a course at Preston College but their first language is not English, please contact the Advice Centre on their behalf to discuss the options available.

Opening Hours:

Mon-Thur 9am-7:30pm (9am-5pm during College holidays)
Fri 9:30am-4.30pm

The information contained in this leaflet was correct at the time of production. Preston College however, reserves the right to alter or amend the details contained in this leaflet. This course will run subject to sufficient student numbers.