University Advanced Certificate in IT

University Advanced Certificate in IT

Course ID:
PC80009

Academy:
Maths, Science & IT

Introduction:
This course builds upon the practical and knowledge based skills obtained in the University Certificate in IT. It allows you to develop your initiative and independence giving you long term learning skills in addition to the specific skills set out in each of the modules. This programme is designed for adults returning to education after a career break, or as a progression route to a foundation or honours degree and is suitable for people who use IT as part of their job. 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.

Study Mode & Location:
Under normal circumstances the course must be completed within 4 years, although we would expect the course to be complete within one academic year. The modules are studied via distance learning, with all study materials available on-line. Tutorial sessions will be held at Preston College`s Fulwood Campus for those wishing to access tutor support.

Course Content:
You will study:

IT2301 Advanced Word Processing and DTP

• A continuation of IT1701 Office Basics.
• Extends your document preparation skills through the use of templates and styles.
• Linked objects such as spreadsheets and charts.
• Use of Word as a DTP package.

IT2302 Advanced Spreadsheet Applications

• A continuation of IT1701 Office Basics.
• Conditional statements and formatting.
• Introduces some advanced facilities e.g. lookup tables, pivot tables.
• Introduction to the use of macros.

IT2303 Relational Databases

• Introduces you to database software, Microsoft Access.
• Set up tables, format fields and design attractive windows forms to input data into the data base.
• Generate queries using various criteria.
• Design, generation and printing of reports.

IT2390 Workplace-based Project

• To obtain an Advanced Certificate you are required to undertake a work-based project derived from the modules you have undertaken. The contents of the project is chosen in consultation with the module tutor and is based around a work related theme. The module will be assessed by the submission of an end of module report.

Assessment:
Except for IT2390, assessment in each module will be on the basis of three pieces of coursework. The final piece of coursework will be more open-ended to test your ability to work independently and apply the skills obtained in each module to a small project of your own choice.

Careers & Progression Opportunities:
The modules are designed so that the skills obtained will find wide application in your workplace. Once you have completed the Advanced Certificate, you may wish to continue your studies. All the modules above, apart from IT2390, are part of a Foundation Degree in ICT and you may wish to use these modules to gain credit towards this qualification.

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.