Course Name
Asset Management System Awareness
Course Description
Delegates must have completed Introduction to Asset Management (eLearning) prior to attending this course. Upon completion of this training course, delegates will understand the concepts of asset management, and how an asset management system helps in the delivery of Network Rail's organisational objectives.
Audience
Those who are involved in asset management activities within Network Rail as per the IAM Anatomy of Asset Management scope and whose role is categorised as 'AM Leaders/Key Supporters.' Those individuals whose development plan also includes asset management learning should also attend.
Duration:
1 Day(s)
Class size:
15
Competence Name Awarded:
N/A
Competence Awarded:
N/A
Course Code:
PD/AM/AMSA
Prerequisite Name:
Introduction to Asset Management (eLearning)
Prerequisite Short Code:
N/A
Skills Assessment Scheme Regime:
N/A
Course Type:
How to Book
Course Name
AST (Advanced Signalling Technology)
Course Description
Develops knowledge of signalling principles, and in particular in relation to complex signalling problems. It is recommended that before attending this course delegates should already be familiar with basic signalling principles including: (1) Non-stopping headway calculations (2) signalling plan symbols (3) classes of route (4) the basic specifications of signals, warning and protection systems (5) points and train dectection on the signalling plan (6) interlocking principles and (7) route and points control tables. If you are not familiar with these you may wish to attend the 'Signalling Layout' or 'Signalling Control Tables' courses first.
Audience
For Signalling Designers or Testers who have a need to design or test complex signalling arrangements. Also for candidates for Modules 2 and 3 of the IRSE exam.
Duration:
10 Day(s)
Class size:
10
Competence Name Awarded:
N/A
Competence Awarded:
N/A
Course Code:
PD/IE/AST
Prerequisite Name:
N/A
Prerequisite Short Code:
N/A
Skills Assessment Scheme Regime:
N/A
Course Type:
How to Book
Course Name
Basic MicroStation for Project Engineers
Course Description
General Introduction to Microstation V8 for Project Engineers covering 2D draughting tools, NRG Acceptance criteria, Tools/Processes and Quality Assurance checklists for Goods Inwards Checking, and a brief introduction to Westinghouse and BBRL Plans Software.
There will be a short assessment to check that delegates can successfully check a drawing against an NRG acceptance checklist.
Audience
The course is aimed at project engineers with responsibilities for goods inwards checking of CAD records who feel they would benefit from an improved understanding of both Microstation and the correct acceptance criteria.
Duration:
1.5 Days Day(s)
Class size:
9-12
Competence Name Awarded:
N/A
Competence Awarded:
N/A
Course Code:
PD/IE/BMPE
Prerequisite Name:
N/A
Prerequisite Short Code:
N/A
Skills Assessment Scheme Regime:
N/A
Course Type:
How to Book
Course Name
Basic Microstation for Signalling Design
Course Description
General Introduction to Microstation V8 for Signalling Design covering general 2D draughting tools and best practices for producing standards-compliant circuit design that meets Records Group acceptance criteria.
There are no pre-requisites for the course although familiarity with Microstation would be beneficial.
There will not be a formal assessment but drawings produced during the course will be checked to verify delegates’ understanding of the modules.
Audience
The course is aimed at signalling engineering personnel and trainees who are either new to Microstation V8 or who feel they would benefit from formal training to improve their detailed design skillset.
Duration:
1.5 Days Day(s)
Class size:
9-12
Competence Name Awarded:
N/A
Competence Awarded:
Course Code:
PD/IE/BMSD
Prerequisite Name:
N/A
Prerequisite Short Code:
N/A
Skills Assessment Scheme Regime:
N/A
Course Type:
How to Book
Course Name
Basic Signalling Technology
Course Description
An introduction to signal engineering principles, signalling equipment and design covering signal engineering principles, signalling equipment and design, how to develop railway signalling that is up to current practice standards, principles relating to relays, interlockings, Control Centres, train detection points and signals, train protection system signalling circuits, signalling design, scheme plans, control tables and aspect sequence charts.
Audience
For Trainee Signalling Design Engineers
Duration:
10 Day(s)
Class size:
10
Competence Name Awarded:
N/A
Competence Awarded:
N/A
Course Code:
PD/IE/BASIC SIG TECH
Prerequisite Name:
N/A
Prerequisite Short Code:
N/A
Skills Assessment Scheme Regime:
N/A
Course Type:
How to Book
Course Name
Being Assertive
Course Description
When people can communicate as equals, harmony and understanding ensues.
This half day workshop is for anyone who wants to have a positive impact on their interactions with others and develop personal effectiveness in the way they communicate. Choosing to be assertive gives you more control over yourself and the situation leading to more productive relationships.
The workshop introduces assertive techniques to enable you to reduce unnecessary conflict, manage useful conflict and clarify your own and other’s needs in a positive way.
You will develop your skills to create a more open conversation building on methods and techniques for assertive behaviour.
Audience
This course for anyone who wants to learn new strategies and techniques to improve their assertive communication skills.
Duration:
0.5 Day(s)
Class size:
16
Competence Name Awarded:
N/A
Competence Awarded:
N/A
Course Code:
M&L/M&LC/DAB
Prerequisite Name:
N/A
Prerequisite Short Code:
N/A
Skills Assessment Scheme Regime:
N/A
Course Type:
How to Book
Course Name
Better Decisions Together de-brief workshop
Course Description
High performing teams have a strong team culture which allows everyone to maximise their potential in a supportive and open environment.
The better decisions together questionnaire tool generates a report to show where your team culture is now and where you collectively want to get to in the future.
This session is a de-brief of the better decisions together report findings for you and your team/group to review and discuss
Audience
All colleagues
Duration:
1 Day(s)
Class size:
12
Competence Name Awarded:
Competence Awarded:
Course Code:
BDTDW
Prerequisite Name:
Prerequisite Short Code:
Skills Assessment Scheme Regime:
Course Type:
How to Book
Course Name
Better Decisions Together Questionnaire
Course Description
High performing teams have a strong team culture which allows everyone to maximise their potential in a supportive and open environment.
You and your team will complete two short questionnaires which then generates a report to show where your team culture is now and where you collectively want to get to in the future.
The report is then reviewed and discussed as a team within the Better Decisions Together De-brief session
Audience
All colleagues
Duration:
1 Day(s)
Class size:
Competence Name Awarded:
Competence Awarded:
Course Code:
BDTQ
Prerequisite Name:
Prerequisite Short Code:
Skills Assessment Scheme Regime:
Course Type:
How to Book
Course Name
CITB Site Management Safety Training Scheme
Course Description
Provides the knowledge, skills and understanding to enable site management and supervisory personnel to manage health and safety on site in accordance with current legal provisions.
Audience
Managers and Supervisors who have to control and monitor constuctions site activities.
Duration:
5 Day(s)
Class size:
15
Competence Name Awarded:
N/A
Competence Awarded:
N/A
Course Code:
S&SD/OH&S/CITBSMSTS
Prerequisite Name:
N/A
Prerequisite Short Code:
N/A
Skills Assessment Scheme Regime:
N/A
Course Type:
How to Book
Course Name
CITB Site Management Safety Training Scheme Refresher
Course Description
This is a two-day refresher of the full Site Management Safety Training Scheme (SMSTS) course. It updates your knowledge of your responsibilities for site safety, health, welfare and the environment.
Audience
This is for anyone who currently holds a valid SMSTS certificate gained in the last five years. This course must be taken before your certificate expires. You must complete this refresher before your certificate expires or you will need to re-take the full course. You must renew this qualification every five years by attending the SMSTS
Duration:
2 Day(s)
Class size:
16
Competence Name Awarded:
N/A
Competence Awarded:
N/A
Course Code:
S&SD/OH&S/CITBSMSTS_R
Prerequisite Name:
N/A
Prerequisite Short Code:
N/A
Skills Assessment Scheme Regime:
N/A
Course Type:
How to Book
Course Name
CITB Site Supervisors Safety Training Scheme
Course Description
Course programme – the content includes: Legal responsibilities and health and safety management, Fire and emergencies, Health issues, Noise and vibration, dermatitis, asbestos, drugs and alcohol, Risk assessment, Hazardous substances, Construction (Design and Management) Regulations, Work at height, Manual handling, Accident prevention and reporting, Group delivery of tool box talks / daily task briefings.
This qualification may require renewal every five years by attending the SSSTS Refresher course. This is so delegates are aware of changes within legislation.
Audience
This course is intended to inform and inspire first line managers (including Gangers / General Foreman / Supervisors) and those who have, or are about to, acquire supervisory responsibilities on how to perform their tasks more effectively.
Duration:
2 Day(s)
Class size:
16
Competence Name Awarded:
N/A
Competence Awarded:
N/A
Course Code:
S&SD/OH&S/CITB SSSTS
Prerequisite Name:
N/A
Prerequisite Short Code:
N/A
Skills Assessment Scheme Regime:
N/A
Course Type:
How to Book
Course Name
Coaching Skills
Course Description
This highly practical course builds both your skills and confidence to have effective coaching conversations with others. Centred around experiential coaching laboratories this two-day workshop allows you to practice and develop your skills in a wide range of live situations. Using a mix of theory, practice and feedback you will gradually build your skills and confidence by coaching and being coached throughout the two days.
You will leave the workshop with the skills to help others find their own answers to problems and be able to delegate more easily.
Audience
All line managers and for those who want to develop their coaching skills.
Duration:
2 Day(s)
Class size:
16
Competence Name Awarded:
N/A
Competence Awarded:
N/A
Course Code:
NRLP/FL/CS
Prerequisite Name:
N/A
Prerequisite Short Code:
N/A
Skills Assessment Scheme Regime:
N/A
Course Type:
How to Book
Course Name
Communication, Presence and Impact
Course Description
This programme is designed for senior managers throughout Network Rail who wish to improve their verbal and written communication skills.
Day 1 - Written communication - We look at all aspects of your writing - documents, emails, papers or proposals for senior managers and other stakeholders. Focusing on the railways, by definition, need to report on difficult, complex and detailed subjects.
Day 2 - Verbal communication – how do we consistently come across as the best version of ourselves, irrespective of how we feel or our perception of the audience’s engagement levels.
Extra Course Material
Audience
Typically Band 3 or above. Delegates attending the Rail Industry Leadership or Senior Leadership Programmes will attend this module as part of their programme. The course ensures delegates feel utterly in control when talking to people, irrespective of the size of the audience and makes sure that when you write emails or reports, they get read and acted on.
Duration:
2 Day(s)
Class size:
15
Competence Name Awarded:
N/A
Competence Awarded:
N/A
Course Code:
NRSLP Com1
Prerequisite Name:
N/A
Prerequisite Short Code:
N/A
Skills Assessment Scheme Regime:
N/A
Course Type:
How to Book
Course Name
Design Route Horizontal & Vertical
Course Description
DesignRoute NR is a software tool to aid horizontal and vertical track design. The 1.5 day combined course covers all options from the entry of survey data to the plotting of completed designs. The course offers the following benefits:
• Training in all options, from the entry of survey data through to the plotting of completed designs
• Learning through hands on experience
• Frequent exercises to consolidate learning
• Time allowed, with support, to practice new skills
• Comprehansive course notes to take away
• Certificates awarded to verify attendance and participation
The vertical and horizontal courses can be taken separately with course duration of 1 day each or combined as a 1.day course.
Delegates should have a working knowledge of design principles.
There is no formal assessment for this course.
This course requires you to:
- Be competent using a PC
- Have a good knowledge of railway terminology
- Have railway design experience, including an understanding of Hallade rules
Audience
Track Design Engineers.
Duration:
1.5 Days Day(s)
Class size:
1-4
Competence Name Awarded:
N/A
Competence Awarded:
N/A
Course Code:
PD/IE/DRH&V
Prerequisite Name:
N/A
Prerequisite Short Code:
N/A
Skills Assessment Scheme Regime:
N/A
Course Type:
How to Book
Course Name
Gauging with ClearRoute 2
Course Description
A 3 day course to provide instruction in all aspects of ClearRoute LT NR. The course includes both practical and theory-based elements and covers how to use ClearRoute for the input of survey data using a variety of input methods; profile check, passing clearance and stepping distance assessments and testing a proposed track design. Delegates may also bring along some of their own data to practice on real-life examples. Formal Assessment is included and successful delegates receive a certificate to certify that they have achieved a specified level of achievement.
The course requires you to:
- Be competent in using a PC
- Have a good knowledge of railway terminology
Audience
For Gauging Engineers, Track Engineers, Technical Officers and anyone with responsibility for assessing clearances
Duration:
3 Day(s)
Class size:
4
Competence Name Awarded:
N/A
Competence Awarded:
N/A
Course Code:
PD/IE/BCR
Prerequisite Name:
N/A
Prerequisite Short Code:
N/A
Skills Assessment Scheme Regime:
N/A
Course Type:
How to Book
Course Name
Gauging with ClearRoute 2 Refresher
Course Description
This course is to refresh knowledge of Creating Local Databases and add various infrastructure to those databases using the Input and Import functionality in ClearRoute™ 2.
To refresh knowledge of Creating Projects and conducting various clearance runs and analyse the results and creating Designs to improve results. Prior to attending, you may select any two topics from the Basic ClearRoute course and the two most popular choices from those attending will be covered as well as other course basics in less detail. The course finishes with the Basic ClearRoute assessments required to renew certification.
Audience
For anyone who requires refresher training on Basic ClearRoute prior to recertification.
Duration:
1 Day(s)
Class size:
4
Competence Name Awarded:
N/A
Competence Awarded:
N/A
Course Code:
PD/IE/BCR_R
Prerequisite Name:
N/A
Prerequisite Short Code:
N/A
Skills Assessment Scheme Regime:
N/A
Course Type:
How to Book
Course Name
Great Together - team behaviours delivery day
Course Description
A Great Together delivery day is designed with you and your team. Covering all kinds of development experiences for teams and/or groups, together with your line managers.
You tell us what the problems are, and we will work with you to create a solution for you and your team/group
Audience
All colleagues
Duration:
1 Day(s)
Class size:
16
Competence Name Awarded:
Competence Awarded:
Course Code:
GTTBDD
Prerequisite Name:
Prerequisite Short Code:
Skills Assessment Scheme Regime:
Course Type:
How to Book
Course Name
Great Together - team behaviours delivery day - Double Facilitation
Course Description
A Great Together delivery day is designed with you and your team.
Covering all kinds of development experiences for teams and/or groups.
You tell us what the problems are, and we will work with you to create a solution for you and your team/group
Audience
All colleagues
Duration:
1 Day(s)
Class size:
16
Competence Name Awarded:
Competence Awarded:
Course Code:
GTTBDDDF
Prerequisite Name:
Prerequisite Short Code:
Skills Assessment Scheme Regime:
Course Type:
How to Book
Course Name
IEMA Environmental Sustainability Skills for Managers
Course Description
The aim of this two-day course is to support people in managerial and / or supervisory roles to understand the strategic and operational implications environmental sustainability has on them, their team and department, enabling them to contribute to the improved environmental sustainability of Network Rail.
The course covers the following learning outcomes:
1. Risks and Opportunities from Environmental Sustainability
2. Laws and Other Compliance Obligations
3. Key Environmental Sustainability Issues
4. Improving Environmental Sustainability Performance
5. Drivers for Change and Barriers
6. Using Data for Performance Improvement
7. Environmental Sustainability Across the Value Chain
8. Improving Resource Efficiency
9. Employees and Sustainability Performance
Audience
This is typically aimed at any role within Network Rail that is a band 4 or above but the following roles would specifically benefit from attending this course: Project Managers, Scheme Project Managers, Project / Programme Directors, Programme Managers, Senior Programme Managers, Route Delivery Directors, Construction Managers, Principal Construction Managers, Site Managers, Development Managers, Project Engineers, Senior Project Engineers, Programme / Project Engineering Managers, Principal Engineers, Senior Design Engineers, Design Engineers, Heads of Engineering, Chief Design Engineers, Heads of Design, Principal Design Engineers, Principal Programme Sponsors, Lead Development Managers, Senior Sponsors, Senior Development Managers, Programme Development Managers, Sponsors, Project Sponsors, Scheme Sponsors, Programme Commercial Managers, Senior Commercial Managers, Works Delivery Managers, Section Managers, Section Supervisors, Strategic Planners, Senior Strategic Planners, Requirements Managers, Requirements Engineers, Asset Managers, functional engineers (i.e. Track Maintenance Engineers), Local Operations Managers, Operations managers, Mobile Operations Managers, Maintenance Protection Coordinators, Station Managers (& deputies), Project Planners, Lead Planners, Quality Managers, Senior Quality Managers, Business Improvement Managers, Assurance Managers, Heads of Quality & Systems, Financial Controllers, Cost Planning Managers, Senior Cost Planning Managers, Procurement Managers, Senior Procurement Managers and similarly titled roles.
Duration:
2 Day(s)
Class size:
14
Competence Name Awarded:
Competence Awarded:
Course Code:
ESSFM
Prerequisite Name:
Prerequisite Short Code:
Skills Assessment Scheme Regime:
Course Type:
How to Book
Course Name
IEMA Environmental Sustainability Skills for the Workforce
Course Description
The aim of this one-day course is to provide the learner with a practical introduction to environmental sustainability so they are equipped with the knowledge, understanding and motivation to make a positive difference within Network Rail.
The course covers the following learning outcomes:
1. Risks and Opportunities from Environmental Sustainability
2. Laws and Other Compliance Obligations
3. Key Environmental Sustainability Issues
4. Improving Environmental Sustainability Performance
Audience
This is typically aimed at any role within Network Rail that is a band 5 or below but the following roles would specifically benefit from attending this course: Project Management Assistants, Assistant Project Engineers, Assistant Design Engineers, Assistant Sponsors, Assistant Commercial Managers, Operatives, Assistant Planners, Section Planners, Signallers, Incident Officers, Cost Planning Assistants, Assistant Procurement Managers and similarly titled roles.
Duration:
1 Day(s)
Class size:
14
Competence Name Awarded:
Competence Awarded:
Course Code:
ESSFTW
Prerequisite Name:
Prerequisite Short Code:
Skills Assessment Scheme Regime:
Course Type:
How to Book
Course Name
IEMA Foundation Certificate in Environmental Management
Course Description
A week long Foundation Certificate in Environmental Management accredited by IEMA (Institute of Environmental Management and Assessment). The week long course is followed up by a 1 hour open-book online multiple-choice exam taken the month following the course.
Following successful completion of the course delegates will be eligible to apply for Associate IEMA membership, giving them the AIEMA suffix and the benefits of IEMA membership
Gives learners a solid foundation in environment and sustainability with which to build their knowledge on. Covers a wide range of environment and sustainability principles.
Once completed, a learner on this course will be able to:
- Outline the implications of global trends for the environment, for society, for the economy and for organisations
- Outline sustainable business/governance principles and their relationship with organisations, products and services
- Outline environmental principles and their relationship with organisations, products and services
- Outline major policy and legislation and their implications for organisations, products and services
- Outline major tools, techniques, systems and practices used to improve sustainability performance
- Outline the role of innovation and other leading practices in developing sustainable products and services and providing sustainable solutions
- Collect data, perform analysis, and evaluate information
- Research and plan to provide sustainable solutions
- Deliver effective communication and capture feedback
- Engage with stakeholders
- Outline tools and techniques that identify opportunities and risks
- Identify and propose ways to improve performance
- Support change and transformation to improve sustainability
Audience
Environmental professionals (e.g. managers, supervisors and employee representatives) whose Job Description mandates this qualification.
If you are already an IEMA member, please bring your membership number with you to the training event.
Duration:
5 Day(s)
Class size:
12
Competence Name Awarded:
N/A
Competence Awarded:
N/A
Course Code:
ENV04
Prerequisite Name:
N/A
Prerequisite Short Code:
N/A
Skills Assessment Scheme Regime:
N/A
Course Type:
How to Book
Course Name
Inclusive Leaders Programme
Course Description
A 1-day workshop that provides understanding on the benefits of a more open, diverse and inclusive organisational and leadership culture.
The course content covers the various ‘drivers’ of diversity & inclusion including the business case, the legislative underpinnings and, at the heart of the course, unconscious bias and its impact on leadership and management decision making. We also look at recognising bias, and how it affects decision making, in yourself and others as well as how to challenge biased thinking.
Audience
All line Managers.
Duration:
1 Day(s)
Class size:
30
Competence Name Awarded:
N/A
Competence Awarded:
N/A
Course Code:
D&I/IL NR
Prerequisite Name:
N/A
Prerequisite Short Code:
N/A
Skills Assessment Scheme Regime:
N/A
Course Type:
How to Book
Course Name
IOSH - Managing Safely
Course Description
Provides the understanding, skills and knowledge of the practical application of health and safety principles, covering issues that could affect working safely, including risks and hazards, health and safety legislation, accident and incident investigation and risk assessments. A multi format assessment take place at the end of the course.
Audience
The course is recommended for operational managers and supervisors with accountability for health and safety in their unit/area
Duration:
3 Day(s)
Class size:
10
Competence Name Awarded:
N/A
Competence Awarded:
N/A
Course Code:
S&SD/OH&S/IOSH MS
Prerequisite Name:
N/A
Prerequisite Short Code:
N/A
Skills Assessment Scheme Regime:
N/A
Course Type:
How to Book
Course Name
IST (Intermediate Signalling Technology)
Course Description
This 10 day course will give participants the background knowledge and understanding and skills required for a signalling engineering designer. Delegates will be instructed in the process of preparing scheme plans, aspect sequence charts and control tables to meet the knowledge and understanding required for The IRSE licence category 1.1.110 Designer (S). Practice plans and control table preparation will be used to reinforce the learning process. Delegates will be introduced to all relevant standards.
Topics covered:
•Development of railway signalling up to current practice
•Simple headway calculations
•Signalling the layout
•Aspect Sequence charts
•Preparation of control tables for automatic signals, routes and points (no swinging overlaps)
Delegates should have previously attended Basic Signalling Technology (or have equivalent experience) or have IRSE Licence Category 1.1.100 Assistant Designer (s). The delegate should also have relevant railway experinece in signalling design or extended experience in a signalling faulting and maintenance role.
Audience
Anyone who is in a signalling engineering assistant designer role and is aspiring to a designer role or to IRSE Licence Category 1.1.110 Designer (S).
Duration:
10 Days Day(s)
Class size:
10
Competence Name Awarded:
N/A
Competence Awarded:
N/A
Course Code:
PD/IE/IST
Prerequisite Name:
N/A
Prerequisite Short Code:
N/A
Skills Assessment Scheme Regime:
N/A
Course Type:
How to Book
Course Name
Leading Change
Course Description
A two day programme aimed at those tasked with leading change in the organisation. Rewiring the thinking of change leaders from reactive to proactive and from defensive to opportunistic, this programme will blend change theory and models, experiential learning, reflection and strategy creation. This highly practical programme offers the opportunity to test and apply learning in the safe classroom environment in readiness for application back in the workplace.
- Practical tools and a structure to support change strategy's.
- Opportunity to apply learning in a safe environment.
Audience
Delegates on Senior Leaders Programme and Senior Managers requiring Leading Change development.
Duration:
2 Days Day(s)
Class size:
12-16
Competence Name Awarded:
N/A
Competence Awarded:
N/A
Course Code:
NRSLP OM LC
Prerequisite Name:
N/A
Prerequisite Short Code:
N/A
Skills Assessment Scheme Regime:
N/A
Course Type:
How to Book
Course Name
Microsoft Excel 2016 VBA Advanced
Course Description
Using Intrinsic Functions, Variables and Expressions
- Defining Expressions and Statements
- How to Declare Variables
- Determining Data Types
- Programming with Variable Scope
- Harnessing Intrinsic Functions
- Defining Constants and Using Intrinsic Constants
Creating User Defined Functions
- Creating a Function Procedure
- Calling a UDF
- Using a function within an Excel Workbook
Message Boxes and Input Boxes
- Adding Message Boxes
- Using Input Boxes
- How to Declare and Use Object Variables
Handling Errors
- Defining VBA's Error Trapping Options
- Capturing Errors with the On Error Statement
- Determining the Err Object
- Coding an Error-Handling Routine
- Using Inline Error Handling
Creating Forms and Controls
- Defining User Forms
- Utilising the Toolbox
- Using UserForm Properties, Events And Methods
- Understanding Controls
- Setting Control Properties in the Properties Window
- Using the Label Control
- Using the Text Box Control
- Using the Command Button Control
- Using the Combo Box Control
- Using the Frame Control
- Using Option Button Controls
- Using Control Appearance
- Setting the Tab Order
- Filling a Control
- Adding Code to Controls
- How to Launch a Form in Code
Working with Procedures
- Procedure Arguments
- Passing Arguments
- Optional Arguments
- Default Values
- Passing arguments by value and reference
Working with Ranges
- What is a Range?
- Range Property of the Application
- Cells Property
- The Special Cells Method
- Naming Ranges
Events
- Workbook Events
- Worksheet Events
Working with Arrays
- What is an Array
- Array Sizes
- One Dimensional Arrays
- Arrays with Multiple Dimensions
- A word about index numbers
- Ubound and Lbound
Charts
- Creating charts from worksheet data
- Key Properties and methods of the chart object
- Manipulating Chart Data from cells
Active X Data Objects
- Key Objects
- The Connection Object
- The Record Set Object
- A word about the connection string
Appendix: Using the PivotTable Object
- Understanding PivotTables
- Creating A PivotTable
- 2010 Pivot Wizard Procedure
- Coding the manipulation, Pivoting the Table
- Using PivotFields
Excel VBA – Quick Reference Guide
Programming Techniques
- Best Practice for Excel Programming
- Using Worksheet Functions
- A Word about VB functions
Ascii Codes
- Inserting non- printable characters into literal strings
- Controlling data entry into text boxes and other form controls.
- A complete list of all standard ASCII codes is given below
If time:-
- Coding the File System object
- Coding Word or PowerPoint from Excel
- Coding to control Excel Application Events
Audience
•Delegates should have attended MS Excel VBA Introduction course.
•Experience of recording and writing simple macros
•Please note this course is not suitable for Excel 2010 users who have no VBA knowledge
Duration:
2 Days Day(s)
Class size:
1-12
Competence Name Awarded:
N/A
Competence Awarded:
N/A
Course Code:
EX10VBAA
Prerequisite Name:
N/A
Prerequisite Short Code:
N/A
Skills Assessment Scheme Regime:
NA
Course Type:
How to Book
Course Name
Microsoft Excel VBA 2016 - Office Introduction
Course Description
At the end of this course you will be able to:
•Record and edit a Macro recorded within Excel/Word
•Use different techniques in order to run any macros available such as keyboard commands, the use of the Quick Access Toolbars or Buttons
•Use VBA and examine the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures
•Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope
•Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks
•Create an error handling routine in case things go wrong with VBA code
Subject Areas
Lesson 1: Getting started
•Introducing Visual Basic for Applications
•Recording a Macro
•Running a Macro
•Absolute or Relative Cell Referencing
•Saving and Opening Files with Macros
•Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, and Buttons
•Editing a Macro in the Visual Basic Editor
•Understanding the Development Environment
•Tips for General Typing in VBA
•Using Visual Basic Help
Lesson 2: Working with Procedures
•Program Design
•Understanding Modules
•Creating a Module
•Understanding Procedures
•Programming Macro Concepts
•Creating a Subroutine
•Creating a Function
•Understanding Arguments
•Exiting Procedures
•Calling Procedures
Lesson 3: Understanding Objects, Properties, Methods, and Events
•Understanding Objects Properties, Methods, and Events
•Navigating the Object Hierarchy
•Understanding Collections
•Using the Object Browser
•Using the With Statement
•Working with Properties
•Working with Methods
•Creating an Event Procedure
Lesson 4: Using Expressions, Variables and Intrinsic Functions
•Naming Rules
•Understanding Expressions and Statements
•Declaring Variables
•Understanding Data Types
•Determining the Value of Variables
•Working with Variable Scope
•Using Built-in VBA Functions
•Understanding Constants
•Using Built-in VBA Constants
•Using Message Boxes
•Controlling the Answer to a Message Box
•Using Input Boxes
•Declaring and Using Object Variables
Lesson 5: Controlling Program Execution
•Understanding Control-of-Flow Structures
•Using the If...End If Decision Structures
•Using the Select Case ... End Select Structure
•Using the Do ... Loop Structure
•Using the For ... Next Structure
•Using the For Each ... Next Structure
•Guidelines for Use of Control-of-Flow Structures
Lesson 6: Working with Forms and Controls
•Understanding UserForms
•Using the Toolbox
•Working with a Form's Properties, Methods, and Events
•Working with Form and Control Properties, Methods and Event
•Working with Form Controls
•Setting the Tab Order
•Populating a Control
•Adding Code to Controls
Lesson 7: Debugging and Handling Errors
•Understanding Errors
•Using Debugging Tools
•Setting Breakpoints and Using Break Mode
•Stepping Through Code
•Trapping Errors with the On Error Statement
•Understanding the Err Object
•Working with Inline Error Handling
•Writing an Error-Handling Routine
Please can you ensure that you take your laptop for this trainptops are not provided as standard.
Audience
•Navigate, edit and manage Excel workbooks.
•Format worksheets and workbooks.
•Understand the difference between absolute and relative references.
•Understand the basics of Excel formulas and functions, e.g. Sum, text functions.
•Understand the concepts of a Macro and its capabilities.
Duration:
2 Days Day(s)
Class size:
4-8
Competence Name Awarded:
N/A
Competence Awarded:
N/A
Course Code:
QAVBA10INT
Prerequisite Name:
N/A
Prerequisite Short Code:
N/A
Skills Assessment Scheme Regime:
N/A
Course Type:
How to Book
Course Name
Microsoft Power BI Intermediate
Course Description
With Power BI Desktop, you get a report authoring tool that enables you to connect to and query data from different sources using the Query Editor. From the datasets you build with Query Editor you can create Reports and Visualizations or dashboards within Power BI Desktop. Reports can then be published. This 'intermediate' course has been tailored to include specific functionality required within Network Rail.
Implementing Row Based security
. Using the Power BI service
. Creating workspaces / Apps / content packs
. The difference between a workspace and app and when to use
. Managing permissions
. Scheduling auto refresh
. Conditional Formatting (text & numbers)
. Drill downs (single visual / cross page)
. Creating dynamic themes / titles
. Using JSON files & Dax / slicers to create dynamic titles)
. Using bookmarks
. Import & Direct query and when to use
. Time intelligence (4 week calendar)
. Comparing historical periodical data using Sales data focussing on trends & forecasts
. Creating effective tooltips
. Data modelling
. Setting up a Schema
. Getting around common problems (e.g. creating a dataset of single values)
. DAX aggregates
. DAX logics
. Measures & new columns
. Emphasise on when to use a measure / calculated column
. Creating variables within measures & using Return / return if
. Working with untidy data
. Key influencers / decomposition tree analytics tools
Note: this course is not targeted at end-users of the software with limited experience.
Audience
It is recommended that you have completed either the Excel Intermediate or Excel Advanced level workshops as well as Power Bi Fundamentals, or have equivalent experience. It is expected that you have a good understanding of Excel functions such as IF and VLOOKUP functions, as well as Defined Names, Importing Data and a basic understanding of PivotTables.
Please Note: When requesting this course you MUST have Power BI downloaded and installed on your computer. If you do not have Power BI installed you will not be able to partake in the course.
Duration:
2 Day(s)
Class size:
8
Competence Name Awarded:
Competence Awarded:
Course Code:
IT/APPS/PBI I
Prerequisite Name:
Prerequisite Short Code:
Skills Assessment Scheme Regime:
Course Type:
How to Book
Course Name
Mindfulness
Course Description
This workshop explores the impact of mental ill health in the UK and why Mindfulness should be encouraged as a daily activity by all employees.
It aims to dispel any myths around the concept of Mindfulness and encourage employees to see it as a skill to develop and become an integral part of their day.
The course offers some practical practice with music along with some very useful takeaways for employees to adopt as part of their daily life.
Audience
Anyone who wants to learn more about what Mindfulness is and how it can help them.
Duration:
1 Day Day(s)
Class size:
16
Competence Name Awarded:
N/A
Competence Awarded:
Course Code:
PD/SBS/MND
Prerequisite Name:
N/A
Prerequisite Short Code:
N/A
Skills Assessment Scheme Regime:
Course Type:
How to Book
Course Name
NEBOSH Accredited National Diploma in Occupational Safety & Health
Course Description
The (New) NEBOSH National Diploma, is a unique professional qualification in health & safety, which aims to provide the knowledge and understanding that underpins competent performance as an Occupational Health & Safety Professional. It is a structured route to progress your career in health & safety comprised of 4 units. On successful completion of the National Diploma and registration for the Initial Professional Development (IPD) the designatory letters GradIOSH can be used. CMIOSH which is chartered status is gained after successful completion of 2 years Initial Professional Development skills based portfolio and undertake a professional review interview.
Duration – 6 block-release weeks over 11 months divided into 4 units starting with a core skills element plus 3 days for exams.
Pre-requisites - NEBOSH General Certificate in Occupational Health and Safety or equivalent Level 3 qualification.
Audience
The National Diploma is designed for individuals who want to progress their career in health & safety & develop more in-depth knowledge & skills aiming to become health & safety practitioners.
To be accepted on to the course the National Certificate must be MANDATED on the applicant’s Job Description. If it is not mandated then the Function will be required to pay for the course.
Duration:
33 Day(s)
Class size:
12
Competence Name Awarded:
N/A
Competence Awarded:
N/A
Course Code:
S&SD/OH&S/NEBOSH DIP
Prerequisite Name:
N/A
Prerequisite Short Code:
N/A
Skills Assessment Scheme Regime:
N/A
Course Type:
How to Book
Course Name
NEBOSH Accredited National General Cert in Occupational Safety & Health
Course Description
A professional qualification in Health and Safety for Occupational Health and Safety professionals wishing to progress their career and develop further knowledge and skills.
Audience
Safety specialists, managers, supervisors, non-safety specialists with health and safety responsibilities who are required to hold a recognised qualification in occupational safety & health.
Duration:
12 Day(s)
Class size:
25
Competence Name Awarded:
N/A
Competence Awarded:
N/A
Course Code:
S&SD/OH&S/NEBOSH CERT
Prerequisite Name:
N/A
Prerequisite Short Code:
N/A
Skills Assessment Scheme Regime:
N/A
Course Type:
How to Book
Course Name
ORACLE - Projects for Project Team Members
Course Description
The Oracle Projects for Team Members curriculum is designed to take the end user through the Oracle Projects application in the Oracle E-Business Suite and to promote a wider understanding of how it interfaces with other Oracle applications such as iProcurement, Purchasing, Accounts Payable, General Ledger, HRMS, and OTL.
It is aimed at anyone in Network Rail who will need to use Oracle Projects as part of their role. Though the course touches on the planning tools P3e and OPIS, it does not cover either in detail. The course will give the user an overview of Oracle Projects from a systems perspective and does not go into detail in relation to local business process.
The Oracle Projects for Team Members course replaces the following historical courses:
•Oracle Projects for Project Managers (OP03)
•Oracle Projects for Commercial Assistants (OP02)
•Oracle Projects for Information Management (OPIM)
•Oracle Projects for Property.
Audience
Intended Audience :
•Project Managers / Scheme Project Managers
•Commercial Assistants or other members of a Commercial Team
•Though not aimed at Planners, the course may be beneficial to Planners wishing to learn more about Oracle in relation to Projects
•Anyone who wishes to learn more about Oracle Projects
Duration:
2 Day(s)
Class size:
2-8
Competence Name Awarded:
N/A
Competence Awarded:
N/A
Course Code:
PD/IT/ORACLE PPTM
Prerequisite Name:
N/A
Prerequisite Short Code:
N/A
Skills Assessment Scheme Regime:
N/A
Course Type:
How to Book
Course Name
Preliminary Accident Investigation
Course Description
This course is designed to provide delegates with the foundation for conducting effective accident/incident investigations.
At the end of the course, delegates will be able to:
•Identify the difference between an accident and an incident
•Explain the reasons for investigating an accident/incident
•Risk rank an operational close call
•Identify the immediate cause
•Identify the behavioural cause
•Explain the process for identifying the underlying cause(s)
•Complete a Level 1 investigation report
Audience
Local Operations Managers, Team Leaders and Section Managers who require the basic knowledge to undertake accident investigations.
Duration:
0.5 Day(s)
Class size:
12
Competence Name Awarded:
N/A
Competence Awarded:
N/A
Course Code:
S&SD/OH&S/PAI
Prerequisite Name:
N/A
Prerequisite Short Code:
N/A
Skills Assessment Scheme Regime:
Course Type:
How to Book
Course Name
Rail Industry Leaders Programme
Course Description
The programme is made up of 9 classroom based modules, 3 virtual classroom sessions and will also require some self-directed learning. The Senior Leadership Programme will require a significant time commitment. The Rail Industry Leadership Programme consists of classroom based modules (9 days in total), virtual classroom sessions and self-directed learning. The Programme focuses on the following key leadership areas for the business: 1) Safety Leadership, Personal Leadership Capability, Performance Conversations, Leading Communication, A Customer Driven approach and all under pinned by the Network Rail behaviours. 2) The final part of the course is an optional 2 day module. Virtual Classroom - These compulsory WebEx sessions contain the theory and models which support the programme. It is important that all delegates attend all WebEx sessions.
Audience
This programme is designed for leaders at or very near the top of their organisations. RILP aims to bridge the gap between ‘knowing’ and ‘doing’ and covers all aspects of leadership. All elements are under pinned by the Network Rail behaviours. Typically bands 1 and 2.
Duration:
9 Day(s)
Class size:
15
Competence Name Awarded:
N/A
Competence Awarded:
N/A
Course Code:
NR RLP
Prerequisite Name:
N/A
Prerequisite Short Code:
N/A
Skills Assessment Scheme Regime:
N/A
Course Type:
How to Book
Course Name
Route Relay Interlocking Design
Course Description
This course is designed to give a detailed understanding of the system principles and circuit design. It will provide development for the individual working towards a principles designer role:
- Push Button Interlocking
- Route Interlocking
- Points
- Sectional Route Locking
- Aspect Controls
- Route Normalisation
- lndications
- Understanding how the circuits relate to signalling principles and control tables
- Common design pitfalls and their avoidance
- Relay and Circuit Design Exercises
- This course is assessed through a theory assessment Location of Training - Derby Training Centre.
Audience
Signal Designers intending to progress towards principle designer level.
Duration:
10 Days Day(s)
Class size:
2-8
Competence Name Awarded:
N/A
Competence Awarded:
N/A
Course Code:
PD/IE/RRID
Prerequisite Name:
N/A
Prerequisite Short Code:
N/A
Skills Assessment Scheme Regime:
N/A
Course Type:
How to Book
Course Name
Structural Eurocodes - Bridges
Course Description
This is a 3 day course covering the detailed application of the suite of Structural Eurocodes and of their supporting Execution EuroNorms and Product EuroNorms to the design and construction of Bridges. The codes cover the design of all Structural and Civil Engineering works in Europe.
•The Eurocodes form part of a much wider suite of standards published by CEN that are applicable to construction.
•Eurocodes cover design
•Product Standards – give requirements for construction products and provide the basis for CE marking
•Execution Standards – are concerned with specifications for construction
Audience
Engineers/Surveyors etc within the Civils Discipline and Asset Management who’s role is influenced and/or effected by the introduction of the Structural Eurocodes.
Duration:
3 Days Day(s)
Class size:
16
Competence Name Awarded:
N/A
Competence Awarded:
N/A
Course Code:
PD/IE/SE BRIDGE
Prerequisite Name:
N/A
Prerequisite Short Code:
N/A
Skills Assessment Scheme Regime:
N/A
Course Type:
How to Book
Course Name
Structural Eurocodes - Buildings
Course Description
This is a 3 day course covering the detailed application of the suite of Structural Eurocodes and of their supporting Execution EuroNorms and Product EuroNorms to the design and construction of General Structures & Buildings.
The codes cover the design of all Structural and Civil Engineering works in Europe.
The Eurocodes form part of a much wider suite of standards published by CEN that are applicable to construction.
Eurocodes cover design
Product Standards – give requirements for construction products and provide the basis for CE marking
Execution Standards – are concerned with specifications for construction
Audience
Engineers/Surveyors etc within the Civils Discipline and Asset Management who’s role is influenced and/or effected by the introduction of the Structural Eurocodes
Duration:
3 Days Day(s)
Class size:
16
Competence Name Awarded:
N/A
Competence Awarded:
N/A
Course Code:
PD/IE/SE BUILD
Prerequisite Name:
N/A
Prerequisite Short Code:
N/A
Skills Assessment Scheme Regime:
N/A
Course Type:
How to Book
Course Name
Structural Eurocodes - Geotech
Course Description
This is a 3 day course covering the detailed application of the suite of Structural Eurocodes and of their supporting Execution EuroNorms and Product EuroNorms to the design and construction of Geotechnics.
The codes cover the design of all Structural and Civil Engineering works in Europe.
•The Eurocodes form part of a much wider suite of standards published by CEN that are applicable to construction.
•Eurocodes cover design
•Product Standards – give requirements for construction products and provide the basis for CE marking
•Execution Standards – are concerned with specifications for construction
Audience
Engineers/Surveyors etc within the Civils Discipline and Asset Management who’s role is influenced and/or effected by the introduction of the Structural Eurocodes
Duration:
3 Days Day(s)
Class size:
16
Competence Name Awarded:
N/A
Competence Awarded:
N/A
Course Code:
PD/IE/SE GEO
Prerequisite Name:
N/A
Prerequisite Short Code:
N/A
Skills Assessment Scheme Regime:
N/A
Course Type:
How to Book
Course Name
Supporting Mental Wellbeing
Course Description
An internally developed course for line managers and those who assist line managers to support the mental wellbeing of themselves and others, and create mentally healthy working environments.
Course aims:
- Understand what mental wellbeing is and why it is important
- Be aware of potential signs and symptoms of someone with reduced mental wellbeing
- Hold sensitive conversations relating to mental health and wellbeing
- Understand what support services are available and how to access them
- Understand the support and tools available to line managers
Audience
Line managers and those who support line managers
Duration:
0.75 Day(s)
Class size:
12
Competence Name Awarded:
Supporting Mental Wellbeing
Competence Awarded:
MW1
Course Code:
MW1
Prerequisite Name:
Prerequisite Short Code:
Skills Assessment Scheme Regime:
Course Type:
How to Book
Course Name
Time Management
Course Description
In a post-Covid world and when teams often work remotely or without direct daily contact, time management is more
important than other. Leaders and managers face multiple challenges from managing their own workloads and those of their teams to ensuring productivity whilst minimising stress and anxiety levels.
This workshop will provide the tools and techniques that leaders can use to effectively minimise time traps and
organise, prioritise, and manage workloads, making the best use of working hours and maintaining a culture where time is a valuable asset.
Audience
This course is or anyone that needs hints and tips to manage their time better.
Duration:
1 Day(s)
Class size:
16
Competence Name Awarded:
N/A
Competence Awarded:
N/A
Course Code:
M&L/M&LC/TM
Prerequisite Name:
N/A
Prerequisite Short Code:
N/A
Skills Assessment Scheme Regime:
N/A
Course Type:
How to Book
Course Name
Using Tilting Trains with ClearRoute™ 2
Course Description
The Using Tilting Trains with ClearRoute course covers both the theory of Tilting Trains, as well as how to use current ClearRoute Tilting Train models.
- The one-day Using Tilting Trains with ClearRoute™2 Course provides an understanding of how tilting trains behave differently from conventional trains and how this should be taken into account when gauging.
- The course also covers how to use current ClearRoute™2 tilting train models.
- The course consists of explanations and demonstration of the software.
- There are also exercises throughout the course so that delegates get “hands on” experience of using ClearRoute™2.
- Formal assessment is included and successful delegates receive a certificate to certify that they have achieved a specified level of achievement.
This course requires you to have:
- Previously obtained Gauging with ClearRoute™ 2 certification
- To be a frequent and confident user of ClearRoute™ 2 since last certification
Audience
The event is designed for ClearRoute™ 2 users who need to use tilting trains in tilt active mode
Duration:
1 Day Day(s)
Class size:
1-4
Competence Name Awarded:
N/A
Competence Awarded:
N/A
Course Code:
PD/IE/TT CR
Prerequisite Name:
Gauging with ClearRoute 2
Prerequisite Short Code:
PD/IE/BCR
Skills Assessment Scheme Regime:
Course Type:
How to Book