NQ
Units

This Unit is designed to provide learners with basic knowledge, understanding and practical problem-solving skills in using spreadsheet applications, through a range of practical and knowledge tasks. The Unit has a particular emphasis on using web applications, although this is not exclusive and desktop apps can be used. Learners will gain knowledge and skills in creating simple spreadsheets and implementing practical solutions using a range of basic features. Learners will be introduced to the sharing facilities provided by contemporary cloud services.

This Unit is designed to provide basic knowledge and skills in using presentation packages to create simple presentations. The Unit has a particular emphasis on using web applications, although this is not exclusive and desktop apps can be used. The Unit covers the creation of basic presentations including creating, editing, saving and sharing presentation documents. Learners will gain knowledge and skills in creating simple presentations. Learners will be introduced to the sharing facilities provided by contemporary cloud services. Learners will also learn about the selection and use of multimedia to enhance the presentation of information.

This Unit is designed for learners who want to acquire basic knowledge and skills in using word processor applications. Learners will learn to create, edit, save, share and retrieve simple documents using web and desktop word processing applications. Learners will also acquire basic skills in file management. This Unit is suitable for learners who have no previous experience of word processing. Although the Outcomes are practical, they each contain the necessary underpinning knowledge to permit learners to transfer their skills to new environments.

This unit is designed to introduce the concept of computer programming by identifying the various components needed to construct simple programs using a high level language. Identify software and hardware, identify different stages of the programming process, identify development paradigms, and identify differences between compiled and interpreted programming languages, input and output data, data types, sub routines, method and procedures, control structures, operators in programming. Identify structured techniques and implement a program design from a given brief.

This Unit is designed to enable learners to develop the necessary skills and techniques for using the routine features of word processor applications. Learners will gain practical experience in the use of routine features of the software, using web and desktop applications. The learners will be able to use routine word processing application features to format and present documents to a given brief. They will also be able to store, share and collaborate on a routine document online. The Unit has a particular emphasis on using web applications, although this is not exclusive and desktop apps can be used as long as learners can collaborate on documents within a cloud based service.

The purpose of this Unit is to enhance learners’ knowledge, understanding and practical problem-solving skills in using spreadsheet applications, through a range of practical and knowledge based tasks. Learners will gain knowledge and skills in creating routine spreadsheets and implementing practical solutions using a range of routine features and functions of spreadsheet applications. The Unit has a particular emphasis on using web applications, although this is not exclusive and desktop apps can be used as long as learners can collaborate on spreadsheets within a cloud based service.

This Unit is designed to provide knowledge and skills in using presentation packages to create routine presentations. The Unit has a particular emphasis on using web applications, although this is not exclusive and desktop apps can be used as long as learners can collaborate on presentations within a cloud based service. This Unit covers the creation of routine presentations, including creating, editing, saving, sharing and collaborating on, presentation documents. Learners will develop knowledge and skills in the use of routine application features and in how to make use of media elements in presentations. This Unit is suitable for learners who have no previous experience of using presentation packages or who wish to enhance their knowledge and further develop their skills in the use of presentation applications.

This Unit is designed to introduce routine features of spreadsheet and database software. The candidate will gain practical experience in the use of routine features in these types of software. The Unit will also provide candidates with information regarding the selection of appropriate software for specific tasks. It is appropriate for any candidate who wishes to enhance their IT skills by covering the routine features of spreadsheet and database application software.

 

This Unit is designed to introduce routine features of word processing, presentation and artwork and imaging software. The candidate will gain practical experience in the use of routine features in these types of software. The Unit will also provide candidates with information regarding the selection of appropriate software for specific tasks. It is appropriate for any candidate who wishes to enhance their IT skills by covering the routine features in word processing, presentation and artwork and imaging software.

This Unit is designed to enable candidates to make efficient and effective use of software application packages for personal and business use. The Unit will also offer practical experience in using complex features of the three main types of software application packages associated with office and personal use — word processing, databases and spreadsheets. Basic system software functions will also be covered to enable the candidate to properly load and terminate application software and to save files in a file management structure. The Unit will also provide candidates with information regarding the current legislation that affects the use of application packages. Candidates will also be introduced to the importance of data security, including backups and virus protection.

The general aim of this Unit is for the learner to develop knowledge, understanding and practical problem-solving skills in software design and development. Identify software and hardware, identify different stages of the programming process, identify development paradigms, and identify differences between compiled and interpreted programming languages. Select and use a combination of appropriate constructs, select and use appropriate data types, test digital solutions, provide internal commentary.

 

This Unit is designed to enable learners to develop complex word processing skills and use web applications to create, share and work collaboratively on documents. Learners will gain practical experience in the use of the complex features of web and desktop word processing applications. The learners will be able to use complex word processing application features to format and present documents for a given brief. They will also gain skills in using the collaborative and cloud features of contemporary word processing packages. The Unit has a particular emphasis on using web applications, although this is not exclusive and desktop apps can be used as long as learners can collaborate on documents within a cloud based service. This Unit is suitable for learners who wish to develop advanced skills in using word processing software to create complex documents for personal, educational or vocational purposes.

The purpose of this Unit is to enhance learners’ knowledge, understanding and practical problem-solving skills in using spreadsheet applications, through a range of complex practical and knowledge based tasks. The Unit has a particular emphasis on using web applications, although this is not exclusive and desktop apps can be used as long as learners can collaborate on spreadsheets within a cloud based service. Learners will gain knowledge and skills in creating complex spreadsheets and implementing practical solutions using a range of complex features and functions of spreadsheet applications. They will also develop an understanding on the collaboration in the production of a complex spreadsheet within an online environment.

This Unit is designed to provide knowledge and skills in using presentation application packages to create complex presentations. The Unit has a particular emphasis on using online web applications, although this is not exclusive and desktop apps should also be used as long as they can communicate with a cloud based service. This Unit covers the creation of complex presentations, including creating, editing, saving, sharing and collaborating on, presentation documents. Learners will develop knowledge and skills in the use of advanced application features and in how to make use of media elements in presentations. This Unit is suitable for learners who wish to enhance their knowledge and further develop their skills in the use of the advanced features of presentation applications.

This Unit is designed to introduce complex features of spreadsheet and database application software. The candidate will gain practical experience in the use of complex features in these types of software. The Unit will also provide candidates with information regarding the selection of appropriate software for specific tasks. The Unit is appropriate for any candidate who wishes to enhance their IT skills in spreadsheet and database application software.

This Unit is designed to introduce complex features of word processing and presentation application software. The candidate will gain practical experience in the use of complex features in these types of software. The Unit will also provide candidates with skills regarding the selection of appropriate software for specific tasks. The Unit is appropriate for any candidate who wishes to enhance their IT skills in word processing and presentation application software.

The purpose of this Unit is to enable learners to develop skills in applications development. Learners will learn how to design and create applications using their chosen development environment, before developing an application. Propose a suitable application for development, identify and justify the resources required. Create appropriate design instructions and diagrams, create an action plan with key tasks and milestones identified, including timescales. Create an application using the chosen development environment, rectify errors identified and track any changes, demonstrate the application.

HN Units:
Level 7

Designed to extend the candidate’s ability to use application software packages to develop user defined applications with efficient user interfaces. The application software package may relate to word processing, spreadsheet or database. The importance of an analytical approach to the requirements of the user will be encouraged. The development process will utilise the automated features provided by the package and scripting or programming language of the package will be used. The Unit is intended for candidates who may be asked to develop application packages for a particular purpose where the developed application will improve efficiency of data entry and required output.

This Unit is designed to provide the candidate with the skills required to create, maintain and interrogate a relational database management system using commercially available database software. The resultant skills will help prepare the candidate to enter commercially operated database environments and to administer the system to the requirements of the industry. The Unit is primarily aimed as an introduction to relational database management systems and will incorporate the skills to design a suitable structure to maintain and update real world systems. The Unit is written in generic terms enabling it to be completed using a commercially available relational database management.

This Unit is designed to introduce candidates to the software development life cycle by developing and testing a small application, eg mobile, web based or PC based. The Unit should expand on the skills learned in the mandatory HNC Computing HN Unit Developing Software: Introduction by introducing the software development life cycle, introducing user orientated design and prototyping, Introducing interactive GUI development, consolidating programming skills, expand programming skills by introducing data structures and using standard object libraries and consolidating and expanding application testing skills.

This Unit is designed to provide candidates with a knowledge and understanding of professional issues, including contemporary legislation, and ethical considerations for those fulfilling a computing related role within the workplace. This Unit is intended for candidates whose aim is to follow a career, or are currently following a career, as a computing professional to ensure work duties are carried out responsibly. On completion of the unit candidates should be able to: describe professional bodies, apply codes of conduct and ethical standards, describe contemporary legislation and evaluate ethical considerations in a relevant vocational context.

This Unit introduces candidates to generic fundamental programming constructs which are required as a base for software development. It will allow candidates to understand the importance of good design and good programming practices within programming. The candidates should consolidate basic programming skills and introduce more complex programming program structures. The candidates should be able demonstrate understanding of the concepts of modularity, parameter passing and objects. 

This Unit will provide candidates with the opportunity to develop effective skills for team working in the context of computing. Candidates will develop co-operative working skills which will include negotiation of goals, roles and responsibilities in the development of a team based ICT project. Candidates, both individually and as a team, will present the project outcomes within the timescale prescribed by the team. Progress will be tracked against a project plan and the team will develop skills in updating the plan to ensure that the project is delivered on time. Individual team members will contribute to any necessary research and to documentation of the group’s activities. Each candidate will develop skills in evaluation and will critically evaluate the contributions of themselves and fellow team members.

This Unit is designed to introduce candidates to the iterative nature of the user centred design process and how this can help ensure that a development meets the needs of the intended users. Candidates will be taught about the typical workflows undertaken in adopting a user centred design approach to a project development and about the methodologies that can be used to accomplish these workflows. They should also develop skills in designing, conducting and evaluating user centred design activities. This Unit is primarily intended to prepare candidates who expect to gain employment in an IT/Computing-related post at a trainee level in a software development role.

The purpose of this Unit is to introduce learners to web technologies used in the creation of web sites. The Unit is suitable for a wide range of learners who are interested in web development and the creation of websites. It may also be of interest to those who are involved in the development of mobile applications.
The Unit includes the development of practical skills in the use of Hypertext Markup Language (HTML) to structure web pages along with the application of Cascading Style Sheets (CSS) to enhance the design of the web pages. Learners will also develop an understanding of the implication of the diversity of screen sizes and apply appropriate techniques to make websites responsive. The importance of testing websites will be covered and learners will be taught how to carry out the essential testing of functionality and performance of the website on common devices and browsers. On completion of this Unit the learner will be able to use HTML and CSS to construct a basic responsive website containing common web page elements.

This Unit is designed to develop the knowledge and skills required of an
administrator to meet the requirements of the administrative function of an organisation. At then end of the unit the candidate should be able to:
Describe core activities within the administrative environment, evaluate current working practices. Evaluate the causes and strategies to deal with work related stress. Design and evaluate an office system and procedure to improve communication and service to customers. Explain current legal responsibilities of employers and employees in relation to the working environment and apply to workplace practice.

This Unit is designed to introduce learners to the design and production for web based apps for mobile devices. On successful completion the learner will be able to: Compare the features of mobile devices and industry structure that can affect the production of mobile web based applications. Design a solution including: analysing requirements, UX design user analysis, and develop a solution for a mobile web based application.

This unit is 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. Learners will develop knowledge and skills to allow them to create customised solutions to common business problems and scenarios. The unit is relevant to learners wishing to develop their competence in the use of spreadsheets in the workplace, or who wish to develop knowledge in skills in the application of spreadsheets more generally.

This Unit introduces the fundamental principles of database design and the use of database management software to aid decision-making in business. It is be relevant to candidates moving into positions which have a responsibility for information management with focus on analysis of and presentation of data.

This Unit is designed to provide candidates with knowledge and skills required to test programs to establish the presence of system defects. It will introduce the candidate to testing techniques and strategies that are designed to discover program faults. The use of test plans, test cases and methods of documentation will also be covered.  It is not intended that the candidate will require to use any specific programming language or testing techniques. However the testing techniques and strategies used must be considered current and valid.

The purpose of this unit is to introduce learners to the principles and practice of penetration testing. The units looks at authorised simulated attacks on computer systems, which explore security weaknesses that may potentially provide access to the systems’ features and data. It is a non-specialist unit, intended for a wide range of learners; it is particularly appropriate for learners with an interest in computing and its associated sub-disciplines, including cyber security.  The unit covers the underlying principles of penetration testing, identifying weaknesses and strengths within a given system. It examines how penetration tests interact with ethical hacking and legal issues. It stresses the importance of working with the client and using analysis techniques, such as flaw hypothesis methodology, to identify and prioritise potential flaws. Dependent on the system involved in the test, it covers use of appropriate testing tools and techniques, and designing tests on programs, servers, web applications, network infrastructure or mobile applications. It covers the documentation of these test results and evaluation of these as part of a security audit.

HN Units:
Level 8

This Unit is designed to enable candidates to develop a broad knowledge of the concepts, principles, and techniques of object oriented software development. Candidates will develop problem-solving and object oriented technical skills. Candidates will then be required to demonstrate their proficiency in these skills through the creation of object oriented software solutions to problems. The emphasis is on the development and testing of the class libraries required for the problem domain. These will be reinforced by developing the appropriate practical skills in implementing and testing object libraries. It is recommended that this Unit is delivered in tandem with the Unit H172 35 Systems Development: Object Oriented Analysis and Design to give candidates an insight into the full development lifecycle.

This Unit is designed to enable candidates to develop a knowledge of the theoretical concepts, underlying principles, scope and role of systems analysis and design undertaken within an object oriented environment. The Unit develops Candidates’ practical systems development skills and introduces Candidates to a variety of requirements gathering and modelling techniques used in object oriented systems analysis and design, using UML or similar modelling notation. The emphasis will be on static conceptual modelling (class diagrams) and evolving behavioral models (use case models and sequence diagram modelling). It is recommended that this Unit is delivered in tandem with the Unit [insert code here] Software Development: Object Oriented Programming to give candidates an insight into the full development life cycle.

This Unit is designed to enable candidates to become familiar with the data structures and collection classes in common use within current software development environments. This knowledge will be supplemented by the coding of collection and/or aggregation associations using appropriate standard generic collection classes.  The unit has been designed to enhance candidates’ programming and algorithm design skills. These skills should help prepare candidates for employment and/or further study in the field of software development.

This Unit is designed to introduce candidates to the design and creation of a Relational Database Management System (RDBMS). It also introduces candidates to the terminology and key concepts used in the designing and building of a RDBMS and the process of creating a relational database. The candidate needs to demonstrate understanding of these key concepts, and the need for good design. On completion of the Unit the candidate should be able to: Identify and use the processes and terminology, design an RDBMS from a given scenario, map the design model to the physical model and create and run SQL statements.

This Unit is designed to develop a broad knowledge of the concepts, principles, boundaries and scope of software development using client and server-side scripting languages for optimised website production. These will be reinforced by developing the practical skills required in using industry structures and the features of scripting languages in the creation of software solutions to interactive web based problems. The similarities between scripting and traditional/Object Oriented Programming (OOP) languages will be highlighted. This Unit forms part of an HN Computing Group Award, although it can also be used as a standalone Unit by candidates wishing to acquire software development skills using scripting languages required for a range of device usage.

This Unit is designed to develop a broad knowledge of the concepts, principles, boundaries and scope of software development in a database programming environment using PL/SQL. These will be reinforced by developing practical skills using the structures and features of PL/SQL in the creation of solutions to problems.  On completion of the Unit the candidate should be able to: Understand and implement Variables, Datatypes and Advanced Datatypes within PL/SQL program blocks. Understand Program Structure, Using Cursors and Exceptions Handling in PL/SQL. Create procedures and functions in PL/SQL. Create Packages and Triggers in PL/SQL. Apply and implement advanced data types and dependencies in PL/SQL programs.

This unit is designed to allow learners to develop and apply advanced word processing skills to assist in the production of business related documents. Learners will be required to solve problems and make decisions relevant to a working environment. The unit would be suitable for learners wishing to gain advanced skills in document management and processing. On successful completion of the unit the learner will be able to evaluate existing document processing procedures and explain the importance of an organisational house style. Create pro forma documents and macros to meet an organisational house style. Perform an advanced mail merge. Apply advanced word processing skills to produce business documents to an organisational house style.

This unit is designed to develop in-depth technical skills to facilitate a high level of competence in use of spreadsheet software to resolve business problems and facilitate business processes. Learners will develop spreadsheet skills to support the management, analysis and forecasting of data for decision-making. Learners will also develop critical, analytical and evaluative skills allowing them to create customised solutions to business problems. On successful completion of the unit the learner will be able to: Apply data management features using spreadsheet software. Use spreadsheet analysis tools to forecast statistical data. Use a range of spreadsheet functions to propose solutions to a business problem.

This unit is designed to develop learners’ knowledge and skills in identifying, evaluating, managing and presenting business information to facilitate and influence decision-making. The unit requires learners to consider the role of information in the decision-making process, evaluate data communications systems and ICT innovations, use planning and control tools for project management and use software application presentation tools to present findings and recommend actions. On successful completion of the unit the learner will be able to: Identify and evaluate the role of business information in decision-making. Describe and evaluate data communications system security and new ICT innovations. Plan project development work using project management software to meet client needs. Schedule project development work using project management software, to meet client needs.