2725 Courses in Haydock

REFERENCE CODE 603/7248/5 COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview The aim of this qualification is to confirm that the candidate has the skills and knowledge to install Curtain Wall systems on site. It is not expected that all curtain wall installers will carry out identical tasks as there are many variations in system types and installation environments, so the qualification had been developed to allow as wide an uptake as possible. All of the work needs to be completed in accordance with relevant legislation, regulations and health and safety guidelines

REFERENCE CODE 610/0134/X COURSE LEVEL NVQ Level 3 THIS COURSE IS AVAILABLE IN Course Overview Who is this qualification for? This qualification is aimed at those who are involved in either site carpentry including first and second fixing, those who are involved in shopfitting site work or those who carry out shopfitting bench work. The qualification is at level 3 although there may be some units at different levels. Level 3 qualifications are primarily aimed at those who are fully trained and experienced in a wide range of work activities, It is not expected that candidates working in this industry all do the same activities or use the same equipment and machinery so the qualification has been developed to make it as widely available as possible. All work completed must be carried out in accordance with Building Regulations and Industry recognised safe working practices, including the disposal of waste. The qualification is structured to ensure that there is a high degree of flexibility within the pathways and units available and will allow employees from companies of all sizes and specialisms equal opportunity to complete. The qualification consists of 3 pathways. What is required from candidates? Qualifications are also required to indicate the number of hours of teaching someone would normally need to receive in order to achieve the qualification. These are referred to as Guided Learning Hours (GLH). The GLH for this qualification is 404. Pathway 1 Site Joinery, Pathway mandatory units Level Credits Installing bespoke first fixing components in the workplace Installing bespoke second fixing components in the workplace Setting up and using transportable cutting and shaping machines in the workplace Erecting roof structure carcassing components in the workplace Confirming work activities and resources for an occupational work area in the workplace Developing and maintaining good occupational working relationships in the workplace Confirming the occupational method of work in the workplace Conforming to general health, safety and welfare in the workplace Pathway 1 Site joinery – Optional units minimum of 1 unit must be achieved Erecting structural carcassing components in the workplace Maintaining non-structural and structural components in the workplace Pathway 2-Shopfitting site work-Pathway mandatory units Marking out from setting out details for routine shopfitting products in the Summary of the: GQA LEVEL 3 NVQ DIPLOMA IN WOOD OCCUPATIONS (CONSTRUCTION) Installing shopfitting frames and finishings in the workplace Installing shopfitting fitments in the workplace Installing shopfronts and finishings in the workplace Setting up and using transportable cutting and shaping machines in the workplace Confirming work activities and resources for an occupational work area in the workplace Developing and maintaining good occupational working relationships in the workplace Confirming the occupational method of work in the workplace Conforming to general health, safety and welfare in the workplace Pathway 3 – Shopfitting-Bench Work – Pathway mandatory units Producing setting out details for routine shopfitting products in the workplace Marking out from setting out details for routine shopfitting products in the workplace Manufacturing routine shopfitting products in the workplace Confirming work activities and resources for an occupational work area in the workplace Developing and maintaining good occupational working relationships in the workplace Confirming the occupational method of work in the workplace Manufacturing bespoke shopfitting products in the workplace Setting up and using fixed machinery in the workplace Conforming to general health, safety and welfare in the workplace Pathway 3 – Shopfitting – Bench work – Pathway optional units a minimum of 1 unit must be achieved Producing CAD setting out details in the workplace Producing wood and wood-based products using computer numerically controlled/numerically controlled (CNC/NC) machinery in the workplace Producing setting out details for bespoke shopfitting products in the workplace Assessment Guidance: Evidence should show that you can complete all of the learning outcomes for each unit being taken. Types of evidence: Evidence of performance and knowledge is required. Evidence of performance should be demonstrated by activities and outcomes, and should be generated in the workplace only, unless indicated under potential sources of evidence (see below). Evidence of knowledge can be demonstrated though performance or by responding to questions. Quantity of evidence: Evidence should show that you can meet the requirements of the units in a way that demonstrates that the standards can be achieved consistently over an appropriate period of time. Potential sources of evidence: The main source of evidence for each unit will be observation of the candidate’s performance and knowledge demonstrated during the completion of the unit. This can be supplemented by the following types of physical or documentary evidence: Accident book/reporting systems Photo/video evidence Safety records Work diaries Training records Timesheets Audio records Telephone Logs Job specifications and documentation Meeting records Delivery Records Records of toolbox talks Witness testimonies Equipment Correspondence with customers Prepared materials and sites Notes and memos Completed work Please Note that photocopied or downloaded documents such as manufacturers or industry guidance, H&S policies, Risk Assessments etc, are not normally acceptable evidence for GQA qualifications unless accompanied by a record of a professional discussion or Assessor statement confirming candidate knowledge of the subject. If you are in any doubt about the validity of evidence, contact Oscar Onsite Academy

REFERENCE CODE 610/0054/0 COURSE LEVEL NVQ Level 3 THIS COURSE IS AVAILABLE IN Course Overview Who is this qualification for? This qualification is aimed at those who are involved in setting out and erecting masonry structures onsite working from drawings and specifications. The structures could be brick and blockwork or local materials. It is not expected that candidates working in this industry all do the same activities, so the qualification is structured to ensure that there is a high degree of flexibility within the units available and will allow employees from companies of all sizes and specialisms equal opportunity to complete. To provide this opportunity in addition to the mandatory units’ candidates will also be able to select optional units recognising specific skills What is required from candidates? Qualifications are now required to indicate the total qualification time (TQT), this is to show the typical time it will take someone to attain the required skills and knowledge to meet the qualification criteria, this qualification has a TQT of 610 hours. Qualifications are also required to indicate the number of hours of teaching someone would normally need to receive in order to achieve the qualification. These are referred to as Guided Learning Hours (GLH). The GLH for this qualification is 334. Group A MANDATORY UNITS Level Credit Confirming Work Activities and Resources for an Occupational Work Area in the Workplace Developing and Maintaining Good Occupational Working Relationships in the Workplace Confirming the Occupational Method of Work in the Workplace Conforming to General Health, Safety and Welfare in the Workplace Erecting and Dismantling Access/Working Platforms in the Workplace Preparing surfaces for painting and/or decorating in the workplace Applying surface coatings by brush and roller in the workplace Optional units Group A – Minimum of 1 unit must be achieved from this group Hang wallcoverings (standard and foundation papers) in the workplace Hanging non-standard width wallcoverings in the workplace 3 20 Optional units Group B-Minimum of 1 unit must be achieved from this group Applying coatings by the airless spray method in the workplace Summary of the: LEVEL 3 NVQ DIPLOMA IN DECORATIVE FINISHING-PAINTING AND DECORATING (CONSTRUCTION) Producing and applying complex stencils in the workplace 3 21 Hanging wallcoverings to complex surfaces in the workplace 3 32 Hanging wallcoverings (specialised paper) in the workplace 4 30 Assessment Guidance: Evidence should show that you can complete all of the learning outcomes for each unit being taken. Types of evidence: Evidence of performance and knowledge is required. Evidence of performance should be demonstrated by activities and outcomes, and should be generated in the workplace only, unless indicated under potential sources of evidence (see below). Evidence of knowledge can be demonstrated though performance or by responding to questions. Quantity of evidence: Evidence should show that you can meet the requirements of the units in a way that demonstrates that the standards can be achieved consistently over an appropriate period of time. Potential sources of evidence: The main source of evidence for each unit will be observation of the candidate’s performance and knowledge demonstrated during the completion of the unit. This can be supplemented by the following types of physical or documentary evidence: Accident book/reporting systems Photo/video evidence Safety records Work diaries Training records Timesheets Audio records Telephone Logs Job specifications and documentation Meeting records Delivery Records Records of toolbox talks Witness testimonies Equipment Correspondence with customers Prepared materials and sites Notes and memos Completed work Please Note that photocopied or downloaded documents such as manufacturers or industry guidance, H&S policies, Risk Assessments etc, are not normally acceptable evidence for these qualifications unless accompanied by a record of a professional discussion or Assessor statement confirming candidate knowledge of the subject. If you are in any doubt about the validity of evidence, please contact Oscar Onsite Academy

REFERENCE CODE 600/6515/1 COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview This qualification is at Level 2, although some units may be at different levels and should be taken by those who are fully trained to deal with routine assignments. Candidates should require minimum supervision in undertaking the job. The qualification has been developed in a way to allow employees from companies of all sizes and specialisms equal opportunity to complete. This qualification is specifically aimed at those carrying out general construction operations work; there is a Level 2 qualification for those involved in maintenance along with a suite of specific qualifications in a wide range of construction occupations available.

REFERENCE CODE 610/0075/3 COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview This qualification is aimed at individuals wishing to prove they have the level and range of knowledge and skills required to install Interior Systems in the Construction working environment. It is not expected that all workers will complete the same tasks, there are 3 mandatory units common to all pathways. The Pathways will allow employees with specific skills and from companies of all sizes equal opportunity to complete. All work must be completed following Industry recognised Safe Working Practices and in accordance with relevant legislation. This qualification is at Level 2, although some units may be at different levels and should be taken by those who are fully trained to deal with a range of tasks and situations. There is also a Level 2 Certificate and a Level 3 Diploma in Interior Systems available.

One-2 one training in Aesthetics -Anti Wrinkle and Dermal fillers . Choose your own dates

One -2- One Body Piercing Training Course . 1 or 2 days depending on the level of mentorship you require. Blackpool based

There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 Getting Started The Power BI ecosystem Opening Power BI Desktop Power BI's four views Introduction to Dashboards 2 Importing Files Importing data sources Importing an Excel file Importing a CSV file Importing a database Connect to an SQL Server Database Import vs. Direct Query Importing from the web Importing a folder of files Managing file connections 3 Shape Data in the Query Editor The process of shaping data Managing data types Keeping and removing rows Add a custom column Appending tables together Hiding queries in reports Fixing error issues Basic maths operations 4 The Data Model Table relationships Relationship properties 5 Merge Queries Table join kinds Merging tables 6 Inserting Dashboard Visuals Things to keep in mind Inserting maps Formatting Maps Inserting charts Formatting Charts Inserting a tree map Inserting a table, matrix, and card Controlling number formats About report themes Highlighting key points Filter reports with slicers Sync slicers across dashboards Custom web visuals 7 Publish and share Reports Publishing to Power BI service Editing online reports Pinning visuals to a dashboard What is Q&A? Sharing dashboards Exporting reports to PowerPoint Exporting reports as PDF files 8 The Power Query Editor Fill data up and down Split column by delimiter Add a conditional column More custom columns Merging columns 9 The M Functions Inserting text functions Insert an IF function Create a query group 10 Pivoting Tables Pivot a table Pivot and append tables Pivot but don't aggregate Unpivot tables Append mismatched headers 11 Data Modelling Expanded Understanding relationships Mark a date table 12 DAX New Columns New columns and measures New column calculations Insert a SWITCH function 13 Introduction to DAX Measures Common measure functions Insert a SUM function Insert a COUNTROWS function Insert a DISTINCTCOUNT function Insert a DIVIDE function DAX rules 14 The CALCULATE Measure The syntax of CALCULATE Insert a CALCULATE function Control field summarisation Things of note 15 The SUMX measure X iterator functions Anatomy of SUMX Insert a SUMX function When to use X functions 16 Time Intelligence Measures Importance of a calendar table Insert a TOTALYTD function Change financial year end date Comparing historical data Insert a DATEADD function 17 Hierarchies and Groups Mine data using hierarchies Compare data in groups

This training day will help managers explore what they need to do to create a motivating environment at work and learn some theory, tools and ideas to inspire motivation at individual and team level. Motivation is a key factor in effective people management and successful team performance. It involves engaging and inspiring your people and developing them in such ways as to improve their effectiveness and thus have a greater benefit to customers. It can also involve having tough conversations with those who do not seem to be motivated. By the end of the workshop participants will be able to: Identify key motivating factors at work and learn and create ideas to better engage staff Learn a conversation tool to use for challenging discussions Explain their role in motivating staff and understand a range of techniques and approaches to use in the workplace Review learning and have an action plan to take back and implement at work 1 Welcome, housekeeping, objectives Breaking the ice Setting personal objectives 2 Group work: identifying personal motivators and where they come from 3 Defining motivation The characteristics of a motivated team Input and group discussion 4 Factors impacting on motivation at work Using pre-work to identify challenges, hotspots and obstacles Feedback in plenary Exploring the benefits of motivation that address current challenges and agreeing outcomes for change 5 Commitment vs. compliance - organisational engagement and the manager's approach to buy in 6 Team challenge task using a theory about motivation Trainer input and review in plenary 7 Group task - complete a plan for individuals identified in pre-workshop task 8 Skill / will - a motivation tool: trainer input, followed by tasks that are assessed and discussed in peer groups 1-2-1 feedback task on approaches and plans to be taken back and used at work Feedback and plenary review 9 DEAL - a conversation tool: how to construct a conversation plan about motivation with an individual Peer professional 1-2-1s to practice the discussion planned and gain feedback 10 Review, evaluation and action planning

Any successful business manager will tell you that you never get the deal you deserve - you always get the deal you negotiate! This two-day workshop includes recent research and practical techniques from the Harvard Business School Negotiation Project and provides a unique opportunity to learn and practice these skills in a safe environment using up to date materials and life-like practice negotiation case studies. This course will help participants to: Understand the basics of negotiation Develop negotiating skills Increase their business acumen Develop their communication skills Learn the models, techniques and tools for an effective negotiation Identify the barriers to agreements Close the deal 1 What is negotiation? Key skills for negotiation Types of negotiation Win-lose negotiations versus Win-win negotiations Wise agreements and Principled Negotiation 2 Four key negotiating concepts BATNA - Best alternative to negotiated agreement Setting your reservation price ZOPA - Zone of possible agreement Creating and trading value 3 Business acumen Understanding pricing, gross margins and profit Knowing the key points on which to negotiate 4 A Four Phase Model for negotiation Nine steps to successful planning Discussing a deal - creating and claiming value Making and framing proposals Bargaining for the winning deal 5 Effective communication Effective questioning Active listening skills Understanding and interpreting body language Barriers to effective communication 6 Understanding influence and persuasion Influencing strategies Ten proven ways to influence people Six universal methods of persuasion Understanding why people do business with other people 7 Negotiating tactics Tactics for win-lose negotiations Tactics for win-win negotiations Effective team negotiating Understanding and using powerv What do you do when the other side has more power? 8 Barriers to agreement Common barriers to agreement The Negotiators Dilemma Dealing with die-hard negotiators Dealing with lack of trust 9 Potential barriers to cross-border agreements Understanding business methods and practice in other cultures Figuring out who has the power and who makes decisions Recognising and dealing with cultural differences What's OK here might not be OK there 10 Closing the deal Four steps to closing the winning deal