Our next full-time Computer Applications for the Workplace programme will be starting in the coming weeks.  There are still a few places left on the course so don’t leave it too late to avail of the opportunity to participate in our long-running programme.

Our course is fully accredited by QQI and offers a Level 5 Major Award in Information Processing.  In addition to learning the skills sought after by employers this Major Award can also be used to gain access to Third Level Education via the CAO.

Below is a list of the modules that we are including in this year’s course and a brief breakdown of each module:

• Communications
• Spreadsheets
• Bookkeeping: Manual & Computerised
• Databases
• Information Communication Systems
• Payroll: Manual & Computerised
• Web Design
• Work Experience

Communications 

This module will cover all the different forms of communication – including verbal and written – and will also cover such things as Online Work and Learning Platforms, Word Processing, Report Writing, Presentation Design and Delivery, Interview Preparation and Interview Skills and Teamwork

Spreadsheets 

This module will cover both the use of spreadsheets and the design of spreadsheet solutions that can be used in work or personal environments.  MS Excel will be the application used.

Bookkeeping Manual & Computerised

This module will cover both traditional manual bookkeeping and computerised bookkeeping using Sage 50.

For manual bookkeeping we will cover:

• Theory
• Source Documents
• Daybooks:

o          Sales/Returns Daybooks

o          Purchases/Returns Daybooks

o          Cash Receipts Daybook

o          Bank Payments Daybook

o          General Journal

o          Petty Cash Book

• Ledgers:

o          Debtors Ledger

o          Creditors Ledger

o          Nominal/General Ledger

• Trial Balance
• Bank Reconciliation
• VAT Return

For computerised bookkeeping we will cover the use of a Computerised Bookkeeping package (Sage 50) to complete all of the bookkeeping tasks previously covered in Manual Bookkeeping.  We have found that employers value those with knowledge/experience in this area.

Databases 

This module will cover both the use of database and the design of database solutions that can be used in work or personal environments.   MS Access will be the application used.  Some of the areas that will be covered include:

• Database Design
• Form Design
• Query Design
• Report Design

Information Communication Systems 

This module looks at the ways in which data and information are used by organisation, from data collection and data analysis through to data/information output.  From the practical side it looks at various different online tools – blogging, podcasts, the use of Cloud platforms and do on.

Payroll: Manual & Computerised 

This manual part of the Payroll module will cover:

• Processing payroll for employee(s) to include – gross pay, holidays, unpaid leave, cut-off points, credits, all statutory and non-statutory deductions
• Process the payroll for employee(s) without a PPSN number or for those that Revenue have not yet issued a Revenue Payroll Notification
• Demonstrate the changes in personal tax due to various factors – mid-year commencement and leaving of employment, changes in credits, refunds etc
• Demonstrate an understanding of the PAYE reporting requirements of an employer
• Demonstrate an understanding of the Revenue services myAccount and ROS
• Analyse the impact of changes in legislation on personal tax and take-home pay by comparing two tax years

In computurised payroll we will cover the use of a Computerised Payroll package (Sage Payroll) to complete all of the payroll tasks previously covered in Manual Payroll.  Again, we have found that employers value those with knowledge/experience in this area.

Web Design 

This module will cover the design of webpages and websites using the web design languages of:

• HTML
• CSS

It will also look at the uploading of website to a Web Server and the maintenance of websites.

Work Experience 

This final module will focus on prepare participants for seeking employment or higher QQI level courses.  It will focus on understanding an individual’s strengths and weaknesses, industry analysis, and applying for jobs.  The module also includes a practical work placement.