page-template-default,page,page-id-25553,page-child,parent-pageid-25538,stockholm-core-2.4,tribe-no-js,select-child-theme-ver-1.1.2,select-theme-ver-9.10,ajax_fade,page_not_loaded,,qode_menu_,wpb-js-composer js-comp-ver-7.7.1,vc_responsive

Compare existing knowledge and skills within standards, HR documentation and/or curriculum to identify gaps 


The toolkit has a series of mapping documents that can be used to compare the identified knowledge and skills contained within the matrix; against existing knowledge and skills within the stakeholder’s documentation / resources. This gap analysis will provide the stakeholder with a comparative analysis of the present skills and knowledge contained within their documentation / resources and identify topics that may be outdated or missing within the three core skill areas.


The mapping documents are developed in MS Excel which will allow the end user to filter results and manipulate the data presentation in a way that is the most useful to meet their mapping need.


The most useful mapping methodology is to produce two-way mapping results. A two-way mapping result is achieved by using the mapping spreadsheet to show where the knowledge and skills items are met within the existing documentation /resources by recording in the mapping spreadsheet where that knowledge or skills item can be found (e.g. if it was a qualification it may be in Unit 1, learning outcome 2) and by also recording on the existing documentation /resources the matrix reference code.  By using the two-way mapping process, your result will be:


  • A spreadsheet that will clearly show where knowledge and skills are already covered and the skills and knowledge items that are not presently covered.
  • Your existing documentation /resources showing where knowledge and skills are included in the matrix, and contents within your existing documentation / resources that are not included within the matrix.  Of course, many of these may fall outside of the green, digital and social context.

Use the gap analysis to develop and/or adapt standards, curriculum and HR documents


Once the gap analysis has been produced (preferably having used the two-way process) this can now be used to decide what extra content is to be included in the documentation / resources.  By reviewing the spreadsheet each gap can be reviewed and a decision made as to its inclusion or not.  The mapping spreadsheet can also be used to plot where the missing items that are to be included would best fit into the existing documentation / resources.


If a two-way mapping process has been used, the existing documentation / resources can also be reviewed to see if there are any items in the existing documentation / resources that are no longer required and/or have now been superseded by the inclusion of the new knowledge and/or skills identified by the gap analysis exercise.



Individuals may refer to the mapping document to help them identify the green, social and digital competencies required at each level within the different sub-sectors. The mapping documents have been created from the competencies within the matrix but have the advantage that the user is able to indicate on the spreadsheet where they already have the competency, and/or feel that it would be beneficial to gain competency in that area.  This then enables the user to use the filter button to produce lists of competencies they have and / or a wish list of competencies they would like to gain.



There are eight excel mapping documents, one per EQF level (1 – 8), each with three worksheets.   In each mapping document there is a mapping worksheet for green competencies, a mapping worksheet for digital competencies and a mapping worksheet for social competencies.


List of resources:


Level 1 D, S, G Mapping Document

Level 2 D, S, G Mapping Document

Level 3 D, S, G Mapping Document

Level 4 D, S, G Mapping Document

Level 5 D, S, G Mapping Document

Level 6 D, S, G Mapping Document

Level 7 D, S, G Mapping Document

Level 8 D, S, G Mapping Document

Read the next section ‘Developing Curriculum’ to learn more.