1807 Courses in Nottingham

Being a Mentor in the Early Years

REFERENCE CODE 603/2369/3 COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview This qualification is aimed at those who have responsibility for sorting, storing and removing non-hazardous wastes related to Construction work. Examples of the types of non-hazardous wastes covered by this qualification include rubble, timber, metal, cardboard or paper, plastics, fabrics and glass. All work must be completed following Industry recognized 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 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.

REFERENCE CODE 603/4460/X COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview The Level 2 NVQ Diploma in Specialist Concrete Occupations (Construction) -Concrete drilling and sawing qualification has been developed for achievement in a real workplace environment which means you need to be employed to undertake this qualification. This qualification enables you, the learner, to demonstrate and recognise your skills, knowledge and understanding and to demonstrate your competence in a real workplace environment so you can work in Specialist Concrete Occupations. Not all individuals will carry out exactly the same tasks so there are 3 pathways, these allow achievement in Concrete Drilling, Concrete Sawing and Concrete Drilling & Sawing. You will be assessed against a set of performance and knowledge statements which have been derived from National Occupational Standards for your occupational area. You will be assessed by an occupationally competent and qualified assessor whose job is to work with you and help you complete your qualification. The qualification consists of 4 mandatory units with a total credit value of 20 credits, in addition to these candidates must achieve the required credits from the chosen pathway.

Finance doesn't have to be a puzzle. And if you want to get anywhere with your career, it had better not be! Whatever your role, you have an impact on the financial wellbeing of the organisation you work for, whether you've got specific financial responsibilities or not. This thoroughly practical, fun and enjoyable one-day workshop will help unpuzzle finance for you. It's an ideal opportunity to master the terminology, get to grips with the concepts, learn how 'the finance department' works and understand the part you play. This course will help participants: Appreciate the role and importance of Finance within organisations Be able to recognise and describe some of the common items and jargon used Identify the elements of the Profit & Loss and the Balance Sheet Understand cashflow Make better decisions Manage budgets 1 Introduction Expectations Terminology Key financial principlesAccrualsConsistencyPrudenceGoing concern 2 The three main financial statements Profit & Loss accountIncomeCost of salesGross profitAdministrative expenses ('overheads')Net profit/(loss) for the financial year (the 'bottom line')P&L format Balance SheetTerminologyFixed AssetsCurrent AssetsCurrent LiabilitiesLong-term LiabilitiesCapitalB/S format Cashflow Statement Financial and management information systems 3 Budgets and forecasts Why budget? Types of budget - incremental or zero-based Budgeting for costs - fixed and variable Budgeting for income An eight point plan for budgeting for your department Case study: Small Brother Ltd Problems and solutions 4 Accruals Accruals - what and why? Prepayments 5 Open forum

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar

A thorough account of the UK and European legal framework and its requirements as regards managing environmental performance. This course will help staff to understand: The framework of UK and European legislation and its enforcement The principal features of the legislation as they apply to your organisation's activity/product/service The benefit of having an Environmental Management System such as ISO 14001 How their own actions and decisions can either expose or protect the organisation in relation to its legal obligations 1 Introduction and objectives 2 Introduction to environmental law and enforcement Sources of law (European and UK) Structure and enforcement Key legislation 3 Integrated Pollution Prevention and Control (IPPC) and Local Air Pollution and Control (LAPC) Pollution and Prevention Control Act 1999 EC Directives on PPC The meaning of BAT Transitional provisions Fit and proper persons Control of emissions to air National Air Quality Strategy 4 Packaging and producer responsibilities Who, what and how The Producer Responsibility Obligations (Packaging Waste) Regulations Obligations and exemptions Registration Recycling and recovery obligations Records Duties of the Environment Agency Offences Developments 5 Waste management National Waste Strategy Waste minimisation (re-use/recycling) Waste definition Disposal and recovery Controlled waste management Hazardous waste management 6 Proposed Legislation and EC Directives EU Commission's waste and resources strategies Implementation of ELV (End of Life Vehicles) Directive WEEE (Waste Electrical and Electronic Equipment) Directive transposition into UK legislation Other producer responsibility initiatives Other proposals from the EU 7 Conclusion Open forum Summary Close

You never know when fire, explosions or gas leaks are around the corner, but while you can’t control what happens tomorrow, you can control how ready you are to react, help and limit any damage – and that’s where fire marshal training comes in.

Are you a manager in Early Years? Do you need some new skills to help manage your teams and be the best you can be? Then have a look at what this course covers and get in touch to book. Week 1. Exploring the role of a Manager in Early Years. Characteristics of an effective manager. Exploring different Leadership Styles and identifying your own. Looking after your own wellbeing. Week 2. How to manage difficult Conversations Exploring different personality types. Developing resillience. 4 Step process for managing a difficult conversation. Week 3. Creating Connection & Belonging within your team The importance of Connecting with a Diverse team. How to create a culture of connection & belonging. An introduction to Leading with Emotional Intelligence. We deliver this session on a one to one virtual platform or face to face. We can deliver to small groups but please contact us separately for costings. This specific course is for training one person at a time.

REFERENCE CODE 601/2998/0 COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview This qualification is aimed at those who have responsibility for carrying out Building Maintenance work in the workplace. Because of the wide range of Construction related maintenance work it is not expected that all candidates will carry out the same activities; the qualification is structured to ensure that there is a high degree of flexibility within the units available. There are 6 pathways to cover a range of maintenance tasks that come under the following broad headings; Carpentry and Joinery, Painting and Decorating, , Tiling, Plastering, Roofing and Trowel Operations. Candidates must complete at least 2 of these pathways. 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 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.

REFERENCE CODE 610/0116/X COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN