Pre Degree Foundation Studies in ICT + English Language

If you already have a sound knowledge of computing and want to improve your ICT skills for real life business and office environments, then this course is suitable for you. Advanced features such as the integration of applications and advanced database development will enable you to maintain customer records and correspondence with ease. This course may lead you to degree level course.

This course is designed for 15 to 21 hours study per week for 12 months. However alterations may be made to the weekly study hours, which may alter the overall number of weeks for the course. You will by studying Computing and English language.

G.C.S.E or equivalent qualification is essential. Students are expected to have a sound knowledge of computing or have taken City & Guilds Diploma. You should have a good understanding of basic mathematical operations and of English. A positive attitude and high degree of self-motivation are required to complete the course.All the documents should be verified by the Foreign Office.

The course is assessed by the use of practical assignments and multiple-choice questions. You will obtain the City & Guilds 7262 scheme Advance Diploma for IT Users. A copy of the full syllabus can be obtained on request.

This course is equivalent to NVQ level 3 or 2 A levels. You can either study to the next NVQ level or do a degree course (B.Sc) at a university. Please note that to go to university you will need to have passed G.C.S.E in Maths and English.

Application can be made online or by calling into the office and completing an application form. You will be contacted before the commencement of the course, either by phone or by letter to finalise your enrolment. You can apply 2 months before our intake of September, October, January and April.

£2995.00, Per Year

IT Principles:

• Plan and cost hardware acquisition
• Plan and cost software acquisition
• Plan, use and maintain files and directory structures on network
• Use networks to gather, collate and distribute information
• Describe health and safety regulations

Word processing - MS WORD:

• Design and plan new documents and templates
• Produce new documents and templates
• Edit existing documents, recording changes made
• Check produced documents
• Page set-up (margin settings etc.)
• Insert logo, image, text file etc.
• Use parallel columns
• Create a blank order form
• Create a blank invoice
• Use autotext
• Use macros
• Use mail merge
• Use sections

Spreadsheet - MS Excel

• Analyse user requirements and design multi-page spreadsheets to meet them
• Use standard tools in problem solving
• Import, parse and process data supplied in text files
• Use the range of functions provided in spreadsheets
• Use macros in spreadsheet applications
• Use Chart Wizard
• Create a report
• Use dollar ($) function
• Record a macro
• Look-up functions
• Create a break-even chart
• Use = Sum ( : ), = Average ( : ), and =VARP ( : ) functions
• Set print area
• Use IF statement
• Create a template for an invoice
• Use hide and unhide commands
• Use PMT, Rate and FV financial functions
• Use circular references

Relational Database - Ms Access

• Identify client requirements for a database
• Undertake analysis and design
• Implement the database design to create tables and forms for data entry
• Undertake information retrieval
• Create reports for output
• Undertake testing and produce documentation
• Understand forms and controls
• Create relationships between tables
• Create macros
• Create queries
• Use calculated fields in queries
• Create and write queries using SQL

Web design:

• Explain the fundamentals of advanced web page development
• Undertake formal analyses of user requirements
• Use appropriate development tools to implement and test interactive web pages
• Incorporate advanced design and information presentation techniques
• Use appropriate graphics software to create and manipulate images
• Maintain and evaluate web sites