7919 Object courses

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.

Develop more advanced training skills such as expert presentation, facilitation and coaching skills. Course overview Duration: 2 days (13 hours) This workshop is for people who want to take their personal skills as a trainer to the next level. It builds on the Underscore Level 1 Train the Trainer course.  In this Level 2 course delegates will develop more advanced training skills such as expert presentation, facilitation and coaching skills. In the modern world learning is often delivered in blended learning formats and this course will introduce delegates to the challenges of blended learning and how to introduce a range of delivery methods into programmes. Attendees will learn how to write more complex learning plans and integrate different methods and media into their plans. Objectives  By the end of the course you will be able to: Describe your Personal Training Style Explain how personality affects communication styles Use techniques to read delegates and adapt communications for greater impact Recognise the ‘games people play’ and how to deal with difficult behaviour Use techniques to establish credibility and enhance your reputation Identify the right approach to take when faced with a range of challenges Use advanced Presentation Skills Use facilitation and coaching skills for experiential workshops Use modern Training Methods and Media Deliver memorable training Note: Delegates attending this programme will be asked to complete an online psychometric in advance of attending the programme in order to help understand personal training styles Content Understanding your Personal Training Style Receive feedback from online Psychometric Understand personal training styles Understand personal communication and working style Understand the impact this has on audience Learn how to adapt your style for greater impact Growing your reputation as a trainer Your Training Persona Training Confidence Training Reputation Trainer Brand Understand the ‘Games People Play’ An introduction to Transactional Analysis (TA) for Trainers Using TA to:Contract for learningUnderstand Trainee AudienceUnderstand interpersonal stylesUnderstand working and thinking stylesWorking in groupsCreativity and innovation Developing deeper Trainer Skills Presentation Magic – making your presentations more effective Facilitation skills for workshops Coaching skills for classrooms and virtual training Delivering experiential workshops Modern Training Methods and Media Incorporating blended learning into your programmes Using Social Learning Using Videos Using Virtual Tools Using CBT and e-learning Pre-course work 1: Complete and online Psychometric Pre-course work 2: Deliver and record a 5-10-minute training session in your workplace on your phone and bring it with you Note: there is an option to have addition 1 hour coaching for delegates to support workplace learning after the course.

Learn how create and structure enterprise projects and programmes. Course overview Duration: 2 days (13 hours) Our P6 Project Planning and Controls Fundamentals course is an intensive two day course aimed at experienced planners and project controllers who need to use Primavera to create and manage detailed plans. It includes creating EPS levels, projects, WBS levels and detailed activity and resource planning. Experience of project planning and scheduling techniques is essential. Objectives  By the end of the course you will be able to: Create a programme structure Create projects and set project properties Create programme milestones Create a Work Breakdown Structure (WBS) Create detailed plans including activities, links and resources Progress the schedule Manage actuals Customise layouts Use the reporting tools in Primavera Content Programme Management Creating EPS elements Defining the programme structure Navigating the EPS structure Finding programmes Project Management and WBS Creating projects Setting project properties Validating projects Assigning project codes Building a work breakdown structure Creating a WBS structure Creating WBS elements Work package management Top Down budgets Allocating top down budgets Budget change Programming milestones and activity planning Creating programme milestones Setting constraints Linking milestones Scheduling Using the schedule function Detailed activity planning Creating activities Relationship types Creating relationships Adding milestones Assigning activity codes Resourcing, workloads and baselining Resource types Creating resources Resource attributes Assigning resources Switching resources Split load resource assignment Reduced hours resource assignment Checking workload Reviewing workload Dealing with resource conflicts Assignments view Baselining Creating baselines Assigning baselines Working with layouts Creating layouts Customising columns Setting filters Sorting and grouping Changing the timescale Customising the Gantt Creating activity code breakdown structures Progressing the schedules Updating task status and remaining duration Setting the data date Monitoring and reporting Exporting and importing information Primavera standard reports Creating custom reports Creating portfolios Printing Printing your schedule Printing to other packages

Learn how to work with and connect multiple data sets to effectively analyse and report on data. Course overview Duration: 1 day (6.5 hours) Within Excel you have some powerful features to enable you to connect and analyse multiple data sources. Power Query enables you to import and manipulate your data, Power Pivot enables you to connect multiple data sources and create pivot tables and pivot charts from them. This course is an introduction to Power Query and Power Pivot in Excel to get you started on creating a powerful reporting capability. Knowledge of working with Excel workbooks and relational databases would be an advantage. Objectives By the end of the course you will be able to: Import data from multiple data sources Edit and transform data before importing Add extra columns of data Append data Merge data from other tables Create data models Build data relationships Build Pivot Tables Build Pivot Charts Use Slicers and Timeline Filters Content Importing data Data sources Importing data Transforming data Editing your data Setting data types Removing columns/rows Choosing columns to keep Setting header rows Splitting columns Appending queries Appending data from other tables Adding text Columns from example Custom columns Conditional columns Merge queries Setting up and using merge queries Merging in columns of data Creating a data model The data model Multiple data tables Connecting tables Building relationships Relationship types Building visuals from multiple tables Analysing information using pivot tables Creating and modifying a Pivot Table Recalculating the Pivot Table Filtering the Pivot Table Searching the Pivot Table Drilling down to underlying data Customising field names Changing field formatting Pivot charts, slices and timelines Creating Pivot Charts Adding and using Slicers

Ideal for those already using Excel but who really want to get to grips with formulas and functions. Course overview Duration: 1 day (6.5 hours) Our Excel Mastering Formulas and Functions course looks at how to confidently use formulas and functions within Excel. It looks at how to correctly construct formulas and explains how to build common formulas such as working with percentages. It investigates a range of built in Excel functions and shows you how to use the formula auditing tools to help when things go wrong.  This course is aimed at existing users of Excel who want to further their skills. Participants should be able to confidently create and amend worksheets. Objectives By the end of the course you will be able to: Construct Formulas Use a range of common Functions Work with absolute and relative references in formulas Create percentage calculations Use named ranges in formulas Use the XLOOKUP command Create formulas with date and use date functions Use formulas in conditional formatting Use a range of Count functions Use the formula auditing tools Content Formulas vs Functions Constructing formulas Using functions Common Excel functions Using the function wizard vs the formula bar Formulas in tables Absolute vs relative references in formulas Using absolute references in formulas Using partial absolute referencing Range Naming Naming ranges Using range names in formulas Single and multi-cell ranges Working with percentages Creating formulas with percentages Percentage breakdowns Percentage increases Formatting as a percentage Using Lookups Using XLOOKUP to insert information from other spreadsheets Calculating with dates Calculating with dates Using date functions Using formulas in conditional formatting Using conditional formulas Using functions in conditional formatting Count functions COUNT COUNTA COUNTBLANK Formula auditing Using the auditing facility Tracing how formulas are made up Tracing precedents and dependants Evaluating formulas Error checking Showing formulas on a sheet

Discover the amazing features this tool has to offer in combining, collating and editing documents and the forms, markups and redaction techniques available. Duration 1 day (6.5 hours) Overview This Adobe Acrobat course looks at the powerful features of the tool quite often overlooked.  The course requires the use of either the Standard or Professional versions of Acrobat as the free Acrobat Reader only has limited functionality. Learn how to combine documents into a single file, edit and mark up PDFs, compare documents, redact data from documents and create fillable forms. Objectives  By the end of the course you will be able to: Create PDFs from other tools Set security Collate and combine files into a single PDF Edit PDF files Complete and sign documents Create fillable forms Mark up PDF documents Compare files Redact data Content Creating PDFs Building PDF documents from Word, Excel and PowerPoint Setting PDF options for print, image quality and security Working in Acrobat Home, Tools and Document Views Using the Navigation Panel and Pane Floating toolbar and Contextual menus Collating and Combining Files Combining multiple files into a single PDF Adding extra files Deleting pages and reorganising pages Editing Files Editing text and graphics Adding text and images Adding headers and footers, watermarks and backgrounds Adding Links Adding manual links Automatic links Completing and signing documents Using fill and sign to complete forms Adding signatures Creating Fillable and Signable Forms Prepare a form Autodetect fillable fields Add manual fillable fields Adding drop downs, check boxes, etc. Naming fields Setting field properties Previewing the form Marking Up Documents Marking up changes Using sticky notes Using the highlighter pen Adding stamps Attaching documents and audio Replying to comments Comparing Files Selecting settings Comparison report Reviewing differences Using the changes pane Redacting Data (Acrobat Professional only) Setting redaction options Redacting chosen text Searching and redacting words, phrases or patterns Redacting whole pages Applying redaction

Understand what Emotional Intelligence is and how it impacts you and others around you. Course overview Duration: 1 day (6.5 hours) Emotional intelligence (EI) is increasingly being regarded as a major key to personal success. IQ measures our ability to problem solve and is pretty difficult if not impossible to change. Our emotional intelligence is our ability to problem solve about emotions and like any other skill can be developed and honed. Some of the most successful people in life today are those who are regarded as having a high level of emotional intelligence whatever their level of IQ. Being able to manage themselves and others successfully is often a crucial factor in their success. With a growing emphasis on ‘soft skills’, leaders and managers need to be able to sensitively handle other people, both within and outside the organisation. Emotions are important in work life. They drive motivation and commitment; they are an inherent part of what we do whatever our job role. Effective individuals are proficient at recognising, using, understanding, and managing emotions in themselves and others. This one day course will help participants improve their understanding and skill in these areas. Objectives  By the end of the course you will be able to: Identify the aspects of your role where emotions are important Recognise the four key elements of Emotional Intelligence Use a range of skills to build and maintain key relationships Develop an emotionally intelligent ‘culture’ in your part of the organisation Create a personal action plan to continue to enhance and monitor your Emotional Intelligence Content Emotional Intelligence (EI) What is Emotional Intelligence? Where does it sit in the “whole person model” IQ, Personality Traits, Skills and Knowledge and EI Dispelling the myths and legends about EI The RUUM Model of EI Recognising emotions in self and others Using emotions Understanding emotions Managing emotions Developing Skills in each of the 4 areas of EI Short and long-term strategies to develop EI Developing compensating strategies where needed Practical application of EI Leveraging EI strengths Practice using RUUM Model Case studies and scenarios Video analysis Examples in the public eye we can all relate to Incorporating EI into your day to day role Practical steps Peer coaching Action planning Optional Follow-up After completing this course, you have an opportunity to complete a psychometric to understand more about emotional motional drivers and derailers. If you would like to do this, you will be invited to complete a psychometric questionnaire called Lumina Emotion.It can be done online and takes between 30-60 minutes. The results are compiled into a report which one of our trained and accredited coaches will go through with the participant individually to work up an action plan to leverage their EI strengths and develop strength where needed.This can be very powerful in building EI into your people and your organisation.

Learn all the quick tips and tricks you didn’t know about in Word and how to properly setup new documents. Course overview Duration: 1 day (6.5 hours) Our Word Document Production (Part 1) course shows you how Word was designed to be used and demonstrates the powerful tools available. This course will enable you to originate professional documents with ease, ensuring that modifications are quick and uncomplicated. It looks at some of the common frustrations and how to avoid them. This course is aimed at existing Word users who want to get the best out of the package Objectives  By the end of the course you will be able to: Customise Word Use different Word views Use line, paragraph and page breaks correctly Set indents and tabs Use styles for easy formatting Work with section breaks Work with automatic correction features Insert and modify tables Content Word setup Using different views Customising the status bar Customising the Quick Access bar and Ribbon Document setup Using the Navigation Pane Using Show / Hide Line vs paragraph breaks Using page break Using the ruler Setting indents and tabs The different types of indent Using dot leader tab Bullets and numbering Working with simple numbered and bulleted lists Sorting lists Working with multi level lists Styles The importance of styles Creating, amending and applying Character Styles Amending and applying Paragraph Styles Setting bullet point styles Using the Style Inspector Reorganising a document Using Outline View Promoting and demoting headings Displaying Styles names in Draft and Outline views Page and number fomatting Section vs page breaks Setting page orientation Setting page margins Displaying page border Automatic corrections Working with Quick Parts Setting autocorrect options Autoformat while typing Creating simple tables Inserting or drawing a table Modifying table formatting Adding rows and columns Changing row heights and column widths

Learn how to create fully relational databases and how to input, extract and report on data. Course overview Duration: 2 days (13 hours) Our Access Database Design and reporting course looks at the key elements to building fully relational databases and entering and extracting information from them. This course is designed for new users who need to build relational database systems. Objectives  By the end of the course you will be able to: Create a new database Create data tables Set field validation and properties Enter data and manage data Create forms Use queries to extract data Create parameter queries Create calculations in queries Build relational databases Use sub datasheets Build multi table queries Use advanced form and report design techniques Content Creating a database Creating a new database Database elements Creating a data table Setting field properties Using input masks Using input masks Validation rules Default values Setting a primary key Creating lookup fields Data entry Adding data Deleting data Quick keys for data entry Working with data Sorting data Filtering data Finding information Navigation Creating data form Creating quick forms The form wizard Amending forms Formatting Setting the tab order Entering data using forms Creating queries Creating a query Setting criteria Using the expression builder Creating parameter queries Using wildcards Using more than one parameter Using calculations in queries Adding a totals row Formatting results Adding calculations Printing and reporting Printing tables and queries Creating reports Building and amending reports Adding headers and footers Working with relational databases Relational database principles Importing data from other sources Linking information between tables One-to-one and one-to-many links Defining referential integrity Amending links Deleting links Sub datasheets Viewing a subdatasheet Removing a subdatasheet Connecting a subdatasheet Multiple table queries Deciding which tables to use Adding tables to the query Creating links between tables Setting join properties Advanced form design Field properties Creating lookup fields Adding calculated fields Applying conditional formatting Advanced report design Field properties Report properties Alternate colour bandings Concatenating fields Adding calculated fields Sorting and grouping Grouping settings Adding headers and footers Adding dates, times, page numbers

Discover the powerful schedule and cost risk analysis features of PRA. Course overview Duration: 2 days (13 hours) Our Primavera Risk Analysis course gives a detailed introduction to the schedule and risk analysis features of Primavera Risk Analysis. It shows the powerful features of the tool and give hands on practice throughout the course to ensure you can confidentially put your new skills into practice back in the workplace. This course is designed for new users of Primavera Risk Analysis, and no previous experience is required. You should however be familiar with risk management processes and terminology. Objectives  By the end of the course you will be able to: Import schedules into PRA Add three point estimates onto plans Perform schedule and cost analysis Use templated quick risk Run risk analysis Interpret results from the Risk Histogram and Tornado graph Add task percentiles to a Gantt chart Set up a risk register Add qualitative and quantitative risks Link risk to activities in the plan Create reports Use the Distribution Analyser Content Importing schedules Importing MSP and Primavera Schedules Running import checks Checking schedule integrity Schedule risk analysis 3 point estimating Entering uncertainly Different distributions Using quick risk Updating plan Importing plans with 3 point estimates Cost/Resource uncertainty Resource loadings Creating 3 point cost estimates Resource distributions and escalations Simple cost estimates Templated quick risk Setting up and applying templated quick risk Assessing risk at WBS level Running risk analysis Running risk analysis Interpreting results on the Risk Histogram Setting analysis options Task percentiles Setting task percentile options Including task percentiles on the Gantt chart Tornado graph Creating a Tornado graph Viewing sensitivity Analysing sensitivity against activities Setting up the risk register Setting Schema levels Defining criteria and tolerances Setting up a Risk Breakdown Structure (RBS) Working with manageability and proximity Saving scoring matrices Adding custom fields Exporting data Exporting to Excel, Word and PowerPoint Qualitive risks Setting risk IDs Adding risk cause, description and effect Setting up risk details Entering mitigation actions Quantitative risks Linking risks to activities Adding schedule and cost impacts Defining how multiple risks impact Correlation Migrating your plan Adding mitigation actions to your plan as tasks Linking tasks to mitigation actions Actioning your risk register Progressing risks Importing progressed plans Linking register to progressed plans Risk history The Waterfall chart Saving and reporting Exporting the risk register Running reports Creating new reports Building and comparing risk plans Using the distribution analyser Comparing dates and cost