Our staff specialise in different areas from software development to business and IT, cyber security to data science.  As an SQA accredited learning centre we can offer individual SQA units or embed a combination of different units to create bespoke courses to suit your organisation.  These can be made to your company requirements and those of your client base as well as offering your employees accredited courses that can enhance their own CPD.  Courses can be delivered in a number of different ways; classroom based, online through our virtual learning environment or blended with a combination of both.  These can be timetabled flexibly and we can liaise with you regarding days, times and duration. 

As a not for profit organisation once we pay staff costs and expenses any additional money generated from our industry courses are used to run our courses in the community, for the third sector and in schools.  There are additional costs in the administration, assessing and verifying of SQA units if you would prefer non assessed courses then we can provide quotes for one day, three day and five day courses.  

HN units are specifically designed to meet the needs of the employers. Each unit provides both the theoretical knowledge as well as developing practical skills on a particular topic. A normal SQA unit (1 credit) would be delivered in approximately 35 hours.

 

Overview:  Designed to allow learners to develop an understanding of spreadsheet design and how to use spreadsheet features and functions for practical and effective use in a business environment. 

Course Content: Spreadsheet design, functions, formulas, referencing, formatting, macros, security for data protection, data filtering, data sorting, data validation, measures of central tendency, summarised data, frequency distribution, standard deviation, graphical representation of data, evaluating data and information.

SQA Unit: IT in business: Spreadsheets  (HH83 34) – Level 7

Assessment: Project based on a given scenario.

Duration: 36 – 40 Hours

 

Overview: To understand fundamental principles of database design and using MS Access to aid information management and decision-making in business.  

Course Content: Overview of RDBMS, data control, Access objects, creating databases, data dictionaries, normalising data, relating tables, Access types, adding data, data queries, parameter queries, joins, SQL, built in functions, reporting.

SQA Unit: IT in business: Databases (F84X 34) – Level 7

Assessment: e-portfolio of python scripts

Duration: 36 – 40 Hours

 

Overview: To understand fundamental principles of CRM software and the different benefits it can provide for a business.   

Course Content: Business requirements, elements of CRM, analytics, business reporting, customer care, HR management, marketing, workflow automation,  types of CRM, customer relationship, CRM resources. CRM implementation.

SQA Unit: Application Development (D76N 34) – Level 7, 2 Credits.

Assessment: Project based on given scenario.

Duration: 72 – 80 Hours

 

Overview: Introduces the fundamental principles of Python programming. 

Course Content: Overview of Python, environment, object oriented languages, identifiers, lines and indentation, syntax.  

Variables, standard data types, python numbers, strings, converting data types,  python operators,  if else, loops, lists, tuples, dictionaries, functions, parameter passing, modules, sorting with python, I/O, exceptions  

SQA Unit: Programming Foundations (H17X 34) – Level 7

Assessment: e-portfolio of python scripts

Duration: 36 – 40 Hours

 

Overview: To understand the principles of testing, the benefits of JUnit testing and test driven development. 

Course Content: Overview of Testing, verification and validation, quality assurance, quality control, audit and inspection, testing strategies, software testing tools, black box, white box, grey box, functional testing, integration testing, beta testing, JUnit testing, test driven development,  evaluating tests.  

SQA Unit: Testing Software (H181 34) – Level 7

Assessment: Plan, implement and evaluate a series of tests, test report.

Duration: 36 – 40 Hours

 

Overview: To enable students to develop knowledge of the concepts, principles, and techniques of object oriented software development. To develop problem-solving and OO technical skills and demonstrate their proficiency in these skills through the creation of object oriented software solutions to problems. 

Course Content: Objects and classes, attributes and operations,  abstraction, encapsulation and data hiding, inheritance, polymorphism, interfaces, coupling, cohesion, static and dynamic modelling and system life cycle. 

Java variables (local, global, static), data types, handling string, converting between types, boolean expressions, if/else constructs, switch statements,  for and while loops, break and continue, arrays, arraylists, data structures, searching and sorting algorithms.

Constructors, overloading methods, overriding methods, importing classes and packages, String class, Math class, static methods, parameter passing, exception handling, user defined  exceptions, lambda expressions, JUnit testing. black, white and grey box testing, evaluating test results.

SQA Unit: Object Oriented Programming (H171 35) – Level 8

Assessment: Java project taken from a given brief.

Duration: 72 – 80 Hours