112 ETC courses in Coventry

REFERENCE CODE 603/5204/8 COURSE LEVEL NVQ Level 3 THIS COURSE IS AVAILABLE IN Course Overview Who is this Qualification for? This qualification is aimed those who carry out supervisory activities in a specific trade in the Construction Industry. The qualification certificate will carry an endorsement to show what trades the candidate was supervising during completion of this qualification. The qualification has a core group of 5 mandatory units that cover areas including Health and Safety, confirming work requirements and coordinating work operations. The qualification also has a group of optional units to allow flexibility to suit individual needs and responsibilities and completion of mandatory units and a minimum of 2 units from the optional group will give access to the relevant CSCS card. This qualification replaces version 1 of the GQA Level 3 NVQ Diploma in Occupational Work Supervision (Construction) QAN 601/3469/0 for anyone starting the qualification from 01/11/2019. What is required from candidates? This qualification consists of 5 mandatory units, which have a total of 57 credits and a group of optional units. Candidates must complete all 5 mandatory units and a minimum of 2 units from the optional group. GQA qualifications are made up of units that have a credit value or credits. These credits must be achieved in the correct combination of mandatory and optional units. 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. The units of assessment set out learning outcomes which describe what learners need to be able to do and understand. The learning outcomes are defined by assessment criteria which are used to assess competence, expressed as skills achieved and learned knowledge and understanding, to achieve the units. Achievement of the mandatory units and chosen optional units will mean the qualification has been completed and will be subject to approval of a claim for certification. GQA Qualifications will issue a certificate complete with the learner’s name, the qualification and unit titles and the credits achieved. 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 Implementing and maintaining health, safety and welfare in the workplace Coordinating and organising work operations in the workplace Optional Units – Minimum of 2 units (19 credits must be achieved) Allocating and monitoring the use of plant, machinery, equipment or vehicles in the workplace Monitoring progress of work against schedules in the workplace Confirming work meets contractual, industry and manufacturers’ standards in the workplace Implementing procedures to support the team performance in the workplace 3 13 Co-ordinating and confirming the dimensional control requirements of the work in the workplace Entry requirements There are no formal entry requirements for learners undertaking this qualification. However, centres must ensure that learners have the potential and opportunity to gain the qualification successfully. Qualification support This qualification has been designed and developed by CITB and GQA Qualifications have authorised Oscar Onsite Academy to deliver this qualification in the Construction Sector. 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 Oscar Onsite 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

This workshop will help you create, develop and close business opportunities using a consultative approach and a value-based (not price-led) proposition. Value-based selling means working the way your customer wants to buy, not how you want to sell. It also means: In a transactional sale the customer knows the answer without help from a salesperson (or cannot see why they should choose you), or is prepared to stay with what they have. Customer decision criteria are price and convenience and customers resent time spent with (new) salespeople, mainly because the salesperson adds little or nothing to what the customer already has and just wastes time. In a consultative or value-based sale, by contrast, the customer doesn't know the answer already. The salesperson must take the role of an advisor, not just a 'product promoter'. Customers demand expertise, advice and customisation during the sales process. Often customers insist on multiple meetings with salespeople and others to develop advantages that you can bring and reduce the perceived risk of changing. In this way the salesperson often adds more value than the product or service alone. This very practical workshop will help you use proven strategies and tactics to build, manage and successfully close sustainable business opportunities using a consultative approach and a value-based (not price-led) proposition. This includes: Increased impact of your new sales conversations, presentations and proposals - leading to faster decisions and increased conversion Greater confidence, consistency and professionalism throughout the business development process Enhanced sales questioning skills and techniques, leading to better, faster and more accurate development of customer needs, problems, value and expectations Improve your people, communication, influence and persuasion skills when approaching, consulting or presenting your services and solutions How to build value at all points in the customer's buying process through your knowledge, skills and structured approach Proven ways to gain additional business and referrals from existing customers and contacts, through direct approach and lead generation Being better able differentiate your firm, your solutions, track-record and expertise clearly and accurately with tailored value statements for each stage and for each opportunity Overcome and avoid price-based objections, buying criteria and negotiation 1 Introduction and key principles of value-based selling Introduction and review of pre-course questionnaires - KPIs, personal learning objectives and key principles The main principles of value-based selling and how they benefit you and the customer How value-based selling differs from 'transactional' or 'price-based' selling The stages of the customer's buying cycle - how to identify and work through strategies for each stage The concept of structured and set-piece selling and proposing Presentation by participants: Personal sales improvement goals 2 Value-based selling strategies and skills What is value? How can one move away from a price-led agenda? How to survive and resist price pressure - six techniques A review of key competencies and skills needed for a value-based approach Strategies, case studies and examples with discussion and review Defining your initial value proposition and comparative advantage How best to established the right level of trust, rapport and credibility Planning and practice session: Strategy - mapping a value-based sales process. 3 Connecting skills Research before the meeting and the first few minutes - ways to gain instant rapport and setting the foundation for a successful outcome in a first sales call How to structure an effective first time sales call or meeting - the subtle differences that are important to master How best to differentiate your solutions and build credibility and enthusiasm early or at the start of the buying process Overcoming initial buying resistance and relaxing the prospect; gaining rapport, opening the meeting: PBC (purpose-benefit-check) and gaining agreement to proceed Planning and practice session: Connecting - first meeting with a new contact 4 Consulting - building, developing and influencing client needs Understanding the power of high-impact and third-level questions to influence people based around specific needs and solutions The importance of body language and other personal communication dynamics when asking questions; empathic listening, run-on questions, drawing out skills, summarising, etc Creating a 'disturb' approach to creating needs and opportunities and positioning your solutions Using proven advanced sales questioning techniques with greater skill: Outcome, SPIN and qualification questions 'Decision-making criteria' - tools to help you develop the relevant criteria with the customer and in doing so progress your sales opportunities more effectively Planning and practice session: Questioning skills 5 Convincing - presentation and persuading skills practice Substance and style - selecting the right tone and content to engage and enthuse your prospect Compelling benefits and reducing perceived risk - key messages to deliver Helping the customer choose your proposition - by being convincing, compelling and credible when you present Professional and effective presentation skills - with personal coaching and practice sessions The keys of influence and persuasion and the keys to convincing a new customer to choose you for the first time Planning and practice session: Role-play in presenting your solution 6 Commitment Knowing when and how to close for commitment to the next stage in your sales process, plus ways to ask for commitment professionally and effectively How to isolate, prioritise and answer objections and concerns more openly and accurately, using a consultative not a confrontational approach Deal more effectively and profitably with price objections and reduce buyer's remorse (which can lead to an 'I want to think about it' reaction and cause delay and inertia) Key negotiation skills around the closing process - getting to 'yes' Planning and practice session: Role-play in closing and negotiation skills 7 Assessed role-play - Final practice session Live role-plays There is an option for external participants to be brought in to the live training workshop to take-part in the final assessed role-play or assist with other sessions run during the course. Performance assessment - 'Dragon's Pitch' The final afternoon of the course is an assessed role-play using a prepared scenario and external 'CEO'. The assessment criteria will be agreed prior to the workshop. 8 Workshop summary and close Personal action plan and learning summary

Everyone shares responsibility for safeguarding and promoting the welfare of children and young people, irrespective of individual roles. This course is for those who have already completed a Level 1 course and need to gain an advanced knowledge of Child Protection, including working towards becoming a Designated Safeguarding Lead (DSL), manager or policy writer. This course is designed for individuals who work with children in either a paid or voluntary capacity. It relates to the issues surrounding safeguarding children by exploring the concepts of "child vulnerability", "child protection" and "significant harm"; coupled with the individual and organisational responsibilities of protecting children from abuse.

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

Key Objectives for the Training provision Effective listening to a client's needs and requirements during various stages of the sales process. Engage in meaningful communication with clients, learn to identify challenges and opportunities that relate to the prospects. Overcome the identified challenge. Build long term rapport and establish trust with the prospect throughout the sales process, Ensure continued customer satisfaction that can turn into repeat business. Be able to build rapport with customers or clients. Know the right questions to ask to fully understand the customer or client’s needs without putting on any pressure. Be able to check you have the right information from the customer or client. Be able to match products and services to the customer or client using the information you have gathered. Be able to influence effectively. Know how to stand out from your competitors. Stage 1 – Research the Company’s ‘Value Propositions’ and USP Analysis  Conducting 30 min confidential interviews with a cross-section of the eligible Attendees & the Stakeholders, in order to gain an objective understanding of the various scenarios and clients that the Participants work with. the Company’s ‘Value Propositions’ Unique Selling Points The Customers’ journey(s) The Competition’s offers for analysis and comparisons. From these findings, a carefully calibrated bespoke Programme will be designed and delivered.  Stage 2 - Design the Bespoke 2 x day Course  nd Stage 3 - Delivery of the Course Programme This Programme can be delivered in 2 x consecutive days, or split between 2 – 3 weeks, to make it more ‘work-friendly’ – if required. It is very practical and commercially focussed in approach, with lots of interactive exercises designed to draw out the learning applications via the debriefings. The ‘Real Play’ scenarios on day 2 will be based on specific case studies drawn from the Research findings so that they are authentic to optimise the learning. Individual Action Plans will be captured at the end of each day to be debriefed by the Participants’ respective Line Managers.  Template Programme Day One – Foundation – Strategic Approach Section One – The Principles of Consultative Selling Defining ‘Consultative Selling’ The Company’s ‘Unique Selling Points’ & Value Proposition The Consultative Selling model – the five stages Avoiding appearing ‘pushy’, ‘pressurising’ or ‘talking through the sale’ Section Two –Strategy & Preparation  ‘Buy-Class’ Matrix Strategic plan Template – matching services/products to identified needs & opportunities. Preparing a range of objectives Constants and variables – USP’s Researching key Client/Decision Makers’ priorities, profile & background (LinkedIn etc.) Preparing for potential & likely Objections Section Three – Email etiquette & ‘influencing’ email correspondence.  Email etiquette A.B.S.U.R.D model Clarity and tone – discovery of clients’ needs & motivational factors. Techniques to influence and ‘nudge’. Ensuring the data and content have a ‘gentle’ motivational & appealing message. Top Tips Day Two – Practical Application Section Four – Rapport Building & Effective Communication skills ‘Behaviour Labelling’ techniques – setting a positive tone. Asking Open Questions – gaining a full understanding of the clients’ priorities & expectations. EQ - Inviting opinions; perspectives; experiences – winning confidence. Active Listening – focus and commitment to understand. ‘Reading the room’ – adapting to responses and reactions. Maintaining focus on relevant topics that the Client cares about; carefully consider the opportunities to influence. But NO PRESSURE! Building a ‘bond of trust’ with commitments and authentic, shared values. Section Five – Explaining the Benefits – aligned to the Customers’ Priorities Understanding ‘Why do People Buy?’ Research data analysis. Open questions that lead to understanding the key issues and Clients’ priorities. Avoiding the danger of ‘pressurising’ the Client. Responding to objections effectively, with confidence and sensitivity. Explaining the benefits that are aligned to the Clients’ stated requirements. Making the Data ‘sing’ – memorable takeaways for the Client. Augmented benefits – Brand confidence; Case studies; Warranty; Service; Range; Flexibility etc. in alignment with their stated preferences/requirements Differentials compared to Competitors Section Six – Winning Commitment Inviting commitment – with confidence Consultative Selling Closing techniques (e.g. Alternative Close/Assumptive Close et al) Avoiding ‘talking through the sale’ – knowing when to ‘Shut UP!’ Confirming agreement – ensuring Clients’ motivation for repeat business Section Seven – Practical Application ‘Real Play’ From the Research findings, carefully devised scenarios can be generated to provide the most valuable learning opportunities to underpin all the skills & techniques covered in the Programme.  Potential Real Play scenarios: A well-established customer has indicated that they are soon to be opening up additional new offices – this presents an opportunity to arrange for the Company to support them with their upcoming needs. After some very positive feedback and with the upcoming contract renewal imminent – how can the Company give the Customer more high-quality support in other areas of their business? A Competitor has been to see the client and they have prompted some concerns about ‘value for money’ & ‘quality of service’. How Real Play works… The group is split the group into 2 sub-groups, one with our Professional Actor (option available); the other with the Trainer or a willing Participant. Each group has a brief and has to instruct their Trainer/Actor/Participant on how to approach the scenario supplied. The Actor and Trainer (or willing Participant) perform the role play(s) as instructed by their respective teams; however, during the action they can be paused for further recommendations or direction. The outcome is the responsibility of the team(s) – not the performers. Debrief the full Programme Individual Action Plans - to be followed through. ‘Best Practices’ for application into the business Options for Exercises within the Programme  Sample Exercise – Red & White  There is a specific time managed agenda and itinerary, which puts the group under pressure.  The key challenge is for the sub-groups to maximise the commercial value from the task, however there is always a great danger that the individuals attempt to gain financial progress at the expense of the other group! Debriefing points: Persuasive communication and influence across barriers Gaining buy-in when others are sceptical Strategic planning accounting for others’ behaviours Sample Exercise – Communication Challenge Each Participant has different pieces of information, but are not allowed to share it visually. They are only allowed to communicate to work out the solution hidden among the large amount of data. Debrief: Structured approach Maintaining focus through distractions/interference Active Listening Controlled communication Sample Exercise – Persuasive emails Sample emails are shared to be critiqued and improved upon to be debriefed: Tone & impact Making the Data ‘sing’ Influential & motivational language Customer centric message. Sample Exercise –Juggling   Each Participant has to pass the ‘Customers’ (Juggling balls) carefully through the system with all the other Participants to reach a profitable conclusion  Debrief: EQ to read the room and effectively communicate, when the pressure is on Customer focus and adapting to challenges Devising a plan that wins buy-in Overcoming competing ideas to get to ‘best practice’ Consistent commitment, communication and motivational drivers that influenced performance. Sample Exercise –Critical Path  The group are provided with 30 x discs and some ‘post-it’ notes. (no pens or pencils are allowed) Their brief is to create a grid shape with the 30 x discs, which will act as ‘stepping stones’ for the ‘Critical Path’ But they have to follow the correct order through the grid from the start to finish, which they will have to work out through ‘trial & error’ All of the team must pass through the ‘Critical Path’ worked out on the grid, observing the constraints, within the time limit. No talking is permitted once they start using the materials Debrief: - Clear communication focussing on the ‘client’s journey’ Planning for challenges Identifying risks and mitigating them Role allocations & support Quality control and disciplines  Sample Exercise –Back to Back  Each Participant is positioned back-to-back with a partner. They have to work out precisely what the ‘statement’ given to the other person is without looking around. Each person has a different brief. Debrief: - Asking Open Questions Active Listening Accuracy in identifying the objective.

REFERENCE CODE 601/4322/8 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 Plastering activities in the workplace. It is not expected that candidates working in this industry all do the same activities so the qualification has been developed to allow opportunities for those carrying out work in either solid or fibrous Plastering. Those taking the qualification must also prove knowledge and competence in working at heights, calculating quantities and wastage and the use of powered and hand tools and equipment. All work completed must be done 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 units available and will allow employees from companies of all sizes and specialisms equal opportunity to complete. See the qualification Rules of Combination for more details on the specific skills required. In addition to this qualification there is a Level 2 qualification in Plastering and a number of other Construction and Construction related qualifications available through Oscar Onsite Academy. What is required from candidates? GQA qualifications are made up of a number of units that have a credit value or credits. This qualification consists of 4 mandatory units and 2 pathways, Solid and Fibrous. The qualification mandatory units have a total credit value of 31 credits-in addition the Solid plastering pathway requires achievement of 54 credits from the pathway mandatory units and a minimum of 14 credits required from the pathway optional group, giving a total of 99 credits. The fibrous plastering pathway requires achievement of all of the qualification mandatory units (31 credits) 45 credits from the pathway mandatory units and a minimum of 16 credits required from the pathway optional group a total of 92 credits for this pathway. The units are made up of the things those working in these job roles need to know to be able to do to carry out the work safely and correctly. These are called Learning Outcomes, and all must be met to achieve the unit. 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 Additional units A/600/7882 Producing Granolithic Paving Work in the Workplace Producing Specialised Plasterer’s Surfaces in the Workplace 3 29 Pathway C – Solid – Pathway C1 – Solid Mandatory Units (54 credits) Producing Complex Internal Solid Plastering Finishes in the Workplace 3 27 Producing Complex External Rendering Finishes in the Workplace 3 27 Pathway C2 – Solid Optional Units – candidates must achieve a minimum of 14 credits Installing Direct Bond Dry Linings in the Workplace Installing Mechanically Fixed Plasterboard in the Workplace Running In-situ Mouldings in the Workplace Pathway D – Fibrous – Pathway D1 – Fibrous Mandatory Units (45 credits) Producing Complex Plasterwork Moulds in the Workplace Summary of the: GQA LEVEL 3 NVQ DIPLOMA IN PLASTERING (CONSTRUCTION) Installing Complex Fibrous Plaster Components in the Workplace 3 18 Pathway D2 – Fibrous Optional Units – candidates must achieve a minimum of 16 credits Running In-situ Mouldings in the Workplace 3 25 Repairing Complex Fibrous Plaster Components in the Workplace 3 16 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: Suggested sources of evidence are shown above, these can be supplemented by physical or documentary evidence, e.g. Accident book/reporting system Notes and memos Safety record Telephone/e-mail records Training record Customer and colleague feedback Audio evidence Records of equipment and materials Witness testimonies Work records Photographic/ video evidence 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 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

This Tableau Desktop Training course is a jumpstart to getting report writers and analysts with little or no previous knowledge to being productive. It covers everything from connecting to data, through to creating interactive dashboards with a range of visualisations in two days of your time. For Private options, online or in-person, please send us details of your requirements: This Tableau Desktop Training course is a jumpstart to getting report writers and analysts with little or no previous knowledge to being productive. It covers everything from connecting to data, through to creating interactive dashboards with a range of visualisations in two days of your time. Having a quick turnaround from starting to use Tableau, to getting real, actionable insights means that you get a swift return on your investment of time and money. This accelerated approach is key to getting engagement from within your organisation so everyone can immediately see and feel the impact of the data and insights you create. This course is aimed at someone who has not used Tableau in earnest and may be in a functional role, eg. in sales, marketing, finance, operations, business intelligence etc. The course is split into 3 phases and 9 modules: PHASE 1: GET READY MODULE 1: LAUNCH TABLEAU Check Install & Setup Why is Visual Analytics Important MODULE 2: GET FAMILIAR What is possible How does Tableau deal with data Know your way around How do we format charts Dashboard Basics – My First Dashboard MODULE 3: DATA DISCOVERY Connecting to and setting up data in Tableau How Do I Explore my Data – Filters & Sorting How Do I Structure my Data – Groups & Hierarchies, Visual Groups How Tableau Deals with Dates – Using Discrete and Continuous Dates, Custom Dates Phase 2: GET SET MODULE 4: MAKE CALCULATIONS How Do I Create Calculated Fields & Why MODULE 5: MAKE CHARTS Charts that Compare Multiple Measures – Measure Names and Measure Values, Shared Axis Charts, Dual Axis Charts, Scatter Plots Showing Relational & Proportional Data – Pie Charts, Donut Charts, Tree Maps MODULE 6: MAKE TABLES Creating Tables – Creating Tables, Highlight Tables, Heat Maps Phase 3: GO MODULE 7: ADD CONTEXT Reference Lines and Bands MODULE 8: MAKE MAPS Answering Spatial Questions – Mapping, Creating a Choropleth (Filled) Map MODULE 9: MAKE DASHBOARDS Using the Dashboard Interface Dashboard Actions This training course includes over 25 hands-on exercises and quizzes to help participants “learn by doing” and to assist group discussions around real-life use cases. Each attendee receives a login to our extensive training portal which covers the theory, practical applications and use cases, exercises, solutions and quizzes in both written and video format. Students must use their own laptop with an active version of Tableau Desktop 2018.2 (or later) pre-installed. What People Are Saying About This Course “Excellent Trainer – knows his stuff, has done it all in the real world, not just the class room.”Richard L., Intelliflo “Tableau is a complicated and powerful tool. After taking this course, I am confident in what I can do, and how it can help improve my work.”Trevor B., Morrison Utility Services “I would highly recommend this course for Tableau beginners, really easy to follow and keep up with as you are hands on during the course. Trainer really helpful too.”Chelsey H., QVC “He is a natural trainer, patient and very good at explaining in simple terms. He has an excellent knowledge base of the system and an obvious enthusiasm for Tableau, data analysis and the best way to convey results. We had been having difficulties in the business in building financial reports from a data cube and he had solutions for these which have proved to be very useful.”Matthew H., ISS Group

REFERENCE CODE 603/4678/4 COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview This is a work-based learning qualification for those involved in cavity wall surveys/inspections and/or clearance. The qualification has been developed at the request of and in partnership with OSCAR OSNITE https://oscaronsite.co.uk The OSCAR and this qualification are recognised by a number of UKAS Certification bodies, industry bodies, Local Authorities and industry stakeholders. Prior to registering on this qualification, individuals must be registered with OSCAR. The clearance pathway enables individuals to carry out the extraction of cavity wall insulation to create a clear cavity that can be reinsulated or insulated if the system has been used to remove debris only. Candidates must also prove knowledge and competence to create a clear cavity to be able to facilitate External Rendering and External Wall Insulation complying with current Building Regulations. All work must be completed following safe working practices, relevant legislation, and comply with contract information and the allocated timescales. The surveyor/inspection pathway requires candidates to demonstrate the skills and knowledge required to interpret information to be able to carry out a Cavity Clearance survey in accordance with the job specifications, following safe working practices and within the allocated time. The Surveyor must also understand how to communicate with others to ensure work is carried out effectively. This pathway includes identifying and selecting the correct quality of equipment, additionally candidates must understand how to calculate quantity, area and wastage. To achieve this pathway unit the survey work must be carried out in ways that will minimise the risk of damage to the work and surrounding area and using and maintaining equipment effectively. This qualification is made up of 3 mandatory units and 2 pathways. Candidates must complete the mandatory units and one or both of the pathways. The minimum credit value of this qualification is 24 credits. There is also an entirely optional additional unit, if achieved this will appear on the qualification certificate but does not count towards the minimum credit value of the qualification. 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 240 hours. Qualifications are also required to indicate the number of hours of teaching someone would normally need to gain the skills and knowledge to achieve the qualification. These are referred to as Guided Learning Hours (GLH). The GLH for this qualification is 84. Mandatory Units Level Credit Conforming to General Health, Safety and Welfare in the Workplace Conforming to Productive Working Practices in the Workplace Handling and Storing Resources in the Workplace 2 5 Pathway 1 Cavity Wall Clearance Cavity wall clearance in the workplace CWC1 Pathway 2 – Cavity Extraction Specialist Surveyor/Inspector Surveying/Inspection of Cavity wall clearance in the workplace Summary of the: GQA NVQ LEVEL 2 CERTIFICATE IN CAVITY WALL EXTRACTION OCCUPATIONS SICW1 Additional Unit Erecting and Dismantling Access/Working Platforms in the Workplace Achieving the combination of Mandatory units and the correct choice of Optional credits will mean the qualification has been completed and GQA will provide the qualification title. Where a candidate has completed additional credits, the qualification will list these as “additional credits”, in cases where the candidate has not completed the full qualification and will not go on to do so, a Certificate of credit can be issued for the credits achieved. 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, please contact Oscar Onsite Academy

REFERENCE CODE 601/3040/4 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 carrying out insulation or associated treatments to buildings; the qualification is at Level 3 and should be by those who are experienced and capable of dealing with a wide range of problems and situations and working with installations that have complex requirements. Candidates may take a technical or supervisory role, particularly in relation to less-experienced colleagues. They will also work closely with customers/clients and have well-developed customer service skills. The qualification is designed to ensure that there is a high degree of flexibility to complete by having pathways for a wide range of occupational roles and specialisms. All work must be carried out in accordance with Building Regulations and Industry recognised safe working practices, including the disposal of waste. What is required from candidates? GQA qualifications are made up of a number of units that have a credit value or credits. This qualification consists of 5 mandatory units and 6 pathways to cover occupational roles in External Wall Insulation, Cavity Wall Insulation, Loft insulation, Draught Proofing, Internal insulation and insulation to Framed Sections of Buildings. Candidates must complete all 5 mandatory units which have a total credit value of 23 credits and the required credits from the selected pathway. Dependent on the pathway selected the qualification has a total credit value ranging from 59 credits to 91 credits The units are made up of the things those working in these job roles need to know to be able to do to carry out the work safely and correctly. These are called Learning Outcomes, and all must be met to achieve the unit. Mandatory units Level Credit Maintain, promote and monitor Health and Safety in the Insulation and Building Treatments working environment Environmental Issues in the Insulation and Building Treatments working environment Identify and confirm requirements, resources and methods of work to carry out workplace activity Communication and teamwork in Insulation and Building Treatment activities Understanding Building Regulations and Legislation that apply to the Insulation and Building Treatments working environment Pathway 1 External Wall Insulation D/503/3042 Applying Surface Finishes to External Wall Insulation in the Workplace 2 19 Installing External Wall Insulation in the Workplace 2 19 Setting Out and Installing External Wall Insulation and Applying Surface Finishes to Buildings with Non-Routine or Complex Features Pathway 2 Cavity Wall Insulation Installing Cavity Wall Insulation in the Workplace 2 18 Setting Out and Installing Cavity Wall Insulation to Buildings with Non-Routine or Complex Features 3 24 Pathway 3 Loft Insulation Installing Loft Insulation in the Workplace Setting Out and Installing Loft Insulation to Buildings with Non-Routine or Complex Features Pathway 4 Draught Proofing Installing Draught-proofing to Openings in the Workplace 2 12 Setting Out and Installing Draught-Proofing to Openings with Non-Routine or Complex Features 3 30 Pathway 5 Internal Insulation to Walls, Floors or Ceilings Installing Internal Insulation to Walls, Floors or Ceilings in the Workplace Setting Out and Installing Internal Insulations to Walls, Floors or Ceilings to Buildings with Non-Routine or Complex Features Pathway 6 Insulation to Framed Sections of Buildings Installing Insulation to Framed Sections of Buildings in the Workplace 2 19 Setting Out and Installing Insulation to Framed Sections of Buildings with Complex or Non-Routine Features 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 system Photo/video evidence Safety records Work diaries Training records Timesheets Audio evidence Telephone logs Job specifications and documentations Delivery records Witness testimonies Equipment Correspondence with customers Prepared sites and structures Notes and memos Completed sites and structures 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, please contact Oscar Onsite Academy

A flexible, modular-based, programme to heighten participants' awareness of ways in which their operations can affect the environment, the principles of environmental management and the practical steps they need to take as individuals and as an organisation to improve environmental performance. Depending on the course modules selected, this programme will give participants: Increased awareness of relevant environmental issues A greater understanding of, and commitment to, the organisation's environmental management programme Preparation for any responsibilities they may have under an Environmental Management System Further benefits according to options chosen 1 Environmental awareness Definition of 'the environment' Key environmental issuesGlobal warmingOzone depletionAcid rainAir qualityWater pollutionContaminated landLand take and green belt shrinkageResource usageHabitat destruction and species extinctions. Option: This module can be used to explain the key environmental issues related to the activities of your own organisation. Diagrams, photos, pictures, examples and statistics relevant to your own organisation are used where possible to illustrate the points being made. 2 Environmental legislation Key elements of environmental legislation affecting the activities of your organisation - including international, European and UK legislation. Legislation of particular relevance to your organisation - how it affects the operations of your organisation Option: Legislation can be dealt with according to which aspect of the environment it protects (eg, air, water, waste) or which part of your organisation's activities it affects Consequences of breaching legislation 3 Environmental management systems Overview of what an environmental management system isHow is an Environmental Management System (EMS) designed and put together?Key elements (emphasising Plan - Do - Check - Review cycle)The need to continually improve Pros and consReasons for having an EMSBenefits of an EMSConsequences of not managing the environmentCosts of installing an EMS Explanation of ISO 14001 and EMAS standards and guidance as applicable to the EMSs of your organisationOverview of your organisation's EMSHow it was set up / is being developed / operatesWho is responsible for itKey parts of system (eg, environmental policy, objectives and targets) identified and discussedEMS documentation - what and where it is. Workshop option: Brainstorm 'Pros and cons' with the participants, come up with all their ideas for good and bad things about EMS and demonstrate that the 'good' list is longer than the 'bad' 4 Environmental consequences Define what an environmental impact is and discuss how they are determined, with reference to the EMS Identify why we want to determine the environmental consequences of operations and activities; how they are used in the EMS for planning, and reducing the impact on the environment Establish key environmental consequences of construction and operational activities on the site; discuss significance ranking and the control measures in place in your organisation. Workshop option: In small groups, participants are asked to identify the impact on the environment of your organisation's activities or a part of their activities. They are then asked to rank these impacts in terms of their significance, using guidelines provided to help them be aware of the contributing factors (eg, frequency, severity). For a selected number of the impacts, the participants are asked to identify what control measures there are and which of these they play a part in. All stages can be discussed with trainers as a whole group at various stages during the workshop. 5 Protected species, nature conservation and invasive weeds Nature conservation, landscape and visual issues in the planning process - overview of key nature UK wildlife legislation, EIA, appropriate timing of surveys, Hedgerow regulations and landscape and visual impact issues Ecological issues - ecological legislation, significant species, hedgerows Archaeology in the development process - why archaeology is important, organisation in the UK, legislation and planning guidance Construction phase issues and consents - major environmental issues during construction, including water resources and land drainage consents, discharges to land or water, water abstraction, public rights of way, tree protection, waste management, Special waste, noise, good practice pollution control and Environmental Audits Identification and management of invasive weeds - including legal position regarding management 6 Chemicals and fuels handling and storage How health and safety management is closely linked to environmental management of materials Planning - what mechanisms are in place for planning materials use; legislation, guidance and policies which define how to manage materials Materials storage - what are the considerations for storing materials, covering:Labels: what are the different types and what do they tell us?Storage facilities: what are the requirements for safe storage of materials (eg, signs, secondary containment, access, segregation, lids/covers)Handling: safe handling for protecting the environment, organisational procedures, high risk situations (eg, decanting, deliveries), how to reduce the risks (eg, use of funnels, proper supervision, training)COSHH and MSDS: brief explanation of legislation and its role in environmental control of hazardous materials, how to use the information provided by COSHH assessments Option: These sessions can be illustrated with photographs/pictures and examples of good and bad storage and handling practices Workshop Options: Labelling Quiz - quick-fire quiz on what different labels tell us; Build a Storage Facility - participants are asked to consider all the environmental requirements for building a safe storage facility for their organisation 7 On-site control measures Overview of the legislation associated with nuisance issues on site and mitigating problems when they arise Examples of bad practice, including fuel storage tanks and mobile equipment - costs involved with prosecution of fuel spills, remediation costs, management costs, legal fees, bad PR coverage Identification and management of contaminated land and relevant legislation Workshop option: Participants are provided with a site plan containing information on site features, environmental conditions and indications of potential issues 8 Waste management Why worry about waste? - a look at how waste disposal can impact on the environment, illustrated by examples of waste-related incidents, statistics on waste production on national, industry-wide and organisational levels, landfill site space, etc Legislation - overview of the relevant legislation, what the main requirements of the regulations are, what penalties there are, and the associated documentation (waste transfer notes) Waste classification - a more in-depth look at how waste is classified under legislation according to hazardous properties, referring to Environment Agency guidance Handling and storage requirements - what are the requirements of the applicable waste legislation and how are they covered by organisational procedures? Examples of good and bad environmental practice associated with handling and storing waste. Workshop option: 'Brown bag' exercise - participants pass round a bag containing tags each with a different waste printed on. They are asked to pick out a tag and identify the classification and the handling, storage and disposal requirements for the waste they select Waste minimisation - overview of the waste minimisation 'ladder' and its different options (elimination, reduction, reuse and recycling), benefits of waste minimisation, examples of waste minimisation techniques Workshop option: Participants are asked to identify opportunities that actually exist within the organisation for minimising production of waste that are not currently being taken advantage of 9 Auditing Requirements for environmental auditing of operations Auditing the EMS Types of internal and external audits Requirements EMS standards (ISO 14001 and EMAS) Carrying out internal audits and being prepared for external audits Workshop options:Mock audit 'Brown Bag' - can be used either for trainers to test participants as if they were in an audit situation, or for the participants to test each other and practice their auditing technique. The bag contains tags each with a different topic printed on (eg, waste skips); participants pass the bag round and select a tag; they are then questioned by the trainer or another participant about that topic as if they were in an audit situation. If the participants are auditing each other, they will be provided with a set of guidelines to keep in mind during the workshop.Virtual auditing - a more practical workshop where participants review photographs of situations/activities relevant to the organisation's operations. They are asked to identify all the good and bad environmental practices that are occurring in the situations. 10 Incident response What should you do when an incident does happen? What should be in a spill kit? When should you call in the experts? When should you inform the Environment Agency or Environmental Health Officer? Workshop option: The participants are provided with some incident scenarios and asked to develop a response to the incident 11 Monitoring and reporting Environmental monitoring programmes and procedures Monitoring and reporting as control measures for environmental consequences Monitoring and environmental 'STOP' card systems - personal and behavioural monitoring and reporting