16436 Disc courses delivered On Demand

Introduction to American Smocking textiles technique, lead by NICKY SIMPSON.

Description Microsoft Excel has hundreds, if not thousands, of functions and features. This course aims to cover some of the best – that is the ones I find most useful. In “Adventures in Excel”, I cover the simple-to-use but powerful functions that I use most often: Basic features including products and powers Key date functions including the calculation of due dates and days past due Generating random numbers and random dates The new IFS functions (new to Office365) Text functions The most useful logical functions and IS functions How to create a drop-down list The new XLOOKUP function Pivot tables   These functions are easy to use, and, unless your role is extremely specialised, they are probably the ones you’ll use 90% of the time. I hope you find the course helpful.   Learning Outcomes Participants in this course will learn: Basic Excel functions including SUM, AVERAGE, MIN, MAX, PRODUCT, POWER and SQRT Useful date functions including TODAY, EOMONTH, EDATE, and DAYS Generating random numbers using RAND and RANDBETWEEN; generating random dates; and randomly picking an item from a list or table The new RANDARRAY function in Office365 The new IFS functions in Office365 including AVERAGEIFS, MAXIFS, MINIFS, COUNTIFS, and SUMIFS Text functions including TRIM, LOWER, UPPER, PROPER, LEFT, MID, RIGHT, FIND, TEXTJOIN and CONCATENATE Logical functions AND, OR, and NOT and IS functions ISTEXT, ISNUMBER, ISBLANK and ISERROR How to create a drop-down list The new SORT and FILTER functions in Office365 VLOOKUP and the new XLOOKUP function How to create a Pivot table and analyse data with one     Course Requirements There are no pre-course requirements.   Additional Resources Course Spreadsheet with the examples covered.     About Ross Ross Maynard is a Fellow of the Chartered Institute of Management Accountants in the UK. He is director of Ideas2Action Process Excellence Ltd and has 30 years’ experience as a process improvement consultant and facilitator. Ross is also a professional author of online training courses for accountants. Ross lives in Scotland with his wife, daughter and Cocker Spaniel

Developmental stages of children and developing activities for 0-12 year olds   Do you want to know more about how children learn and play at different ages to inform how you create family activities in your museum?    About this training   This training webinar will be led by cultural heritage learning consultant Anna Salaman. She has thirty years’ experience immersed in the arts, heritage and cultural sectors, specialising in learning and participation, creativity and play. Anna has worked with organisations around the world including ArtScience Museum (Singapore), Discover Children’s Story Centre, the Science Museum, the Natural History Museum, and the V&A.   The session will help delegates to: learn about the developmental stages of children, ages 0-12, gain an understanding of different facilitation styles to build confidence when interacting with children of different age groups, explore the five types of play and facilitating play, make plans to put the training into practice in their organisation.   Take a look at the full schedule.   Please note: this is a recording of the session which took place on 6th June 2024.   Who should attend? This training is aimed at staff who work in museums, art galleries and heritage sites and are interested in developing your knowledge and understanding of the developmental ages and stages of children to inform how you create activities for families. 

Develop a Zombie Survivor FPS game from the beginning. Learn to create the zombie game step-by-step and set up your personally designed characters, weapons, animations, effects, and more. Create game modes with a complete game scenario with all the assets to build the game included in this course.

Creating family friendly exhibitions Please Note: this is a recording of a session which took place 3 July 2024. The purchase includes access to the recording until February 2025 to view as many times as you like, as well as resources used during the training.   Do you want to create a family friendly exhibition in your museum, but aren’t sure where to start?   About this training   During this session, we will be exploring the process of developing and delivering a family exhibition with practical tips and ideas.   This training webinar will be led by Sarah Shaw, former National Family Interpretation Manager for English Heritage. Her work included collaboratively designing family friendly experiences with families at the UNESCO World Heritage Site Birdoswald Roman Fort, which won the Best Family Day Out UK Heritage Award in 2020. She was also the project manager for the Marvellous and Mischievous: Literature’s Young Rebels exhibition at York Art Gallery in 2023.   The session will help delegates to:   discuss how to plan for families in exhibitions find out how to use learning and play styles for interpretation and resources learn top tips for developing family friendly exhibitions think about how you consult with families to develop your provision hear ideas for wider improvements to your family visitor experience.   Take a look at the full schedule.     Who should attend? This training is aimed at staff who work in museums, art galleries and heritage sites who are interested in developing successful family friendly exhibitions.

Fraud Prevention: A Guide for Small and Medium Sized Enterprises   Course Description   Copyright Ross Maynard 2021   Course Description Business fraud is a significant, and growing problem. Hardly a day goes by without news reports of organisations being hacked or having their data hijacked. Phishing scams and ID theft are also serious threats to businesses. According to data produced by Accenture, 43% of cyber attacks are aimed at small or medium sized organisations, but only 14% of those organisations are well protected. Around 60% of successful internet fraud cases are the result of phishing emails, and  30% of cases result from ID theft. These two approaches are increasingly being combined in business internet fraud. The aim of this course is to help managers in small or medium sized organisations understand the fraud risk that they face, and to take action to mitigate the risk. The course covers frauds risks, creating an anti-fraud culture and developing an fraud risk management strategy. The course comes with a fraud risk mini-audit and sample anti-fraud policies, and related policy documents. The best way to prevent fraud is to have clear anti-fraud policies and procedures which all staff understand, and which are rigorously enforced; coupled with an open, communicative environment, where staff feel safe and supported to question actions and raise concerns. To help your organisation put these elements in place, this course has five parts: Part 1: What is Fraud and Who Commits it? Part 2: Creating an Anti-Fraud Culture Part 3: Fraud Risk Management Part 4: Managing Bribery Risk Part 5: Appendices with sample anti-fraud policies, fraud response plans, a whistleblowing policy and anti-bribery policy.   I hope you find the course helpful.     Key Learning Points  On completion of the course, delegates will be able to: Define meaning and nature of business fraud Appreciate the variable nature of people’s honesty and how that can tip into fraud Understand the personality types of people who commit business fraud Identify the elements of an anti-fraud culture Explain the steps required to guard against internet fraud Understand the elements of a fraud risk management strategy Outline the sanctions available for those committing fraud Develop an Anti-Fraud Policy, Fraud Response Plan, Whistleblowing Policy and Anti-Bribery Policy for their organisation Begin to audit the level of fraud risk and bribery risk in their organisation     Curriculum Part 1: What is Fraud and Who Commits it? L1: What is Fraud? L2: The Variable Nature of Honesty Part 2: Creating an Anti-Fraud Culture L3: Creating an Anti-Fraud Culture L4: Internet Fraud and Cybercrime  Part 3: Fraud Risk Management L5: The Fraud Risk Management Strategy Part 1 L6: The Fraud Risk Management Strategy Part 2 L7: Sanctions for Fraud  L8: Tips to Help Prevent Fraud L9: The Fraud Risk Mini-Audit L10: Fraud Prevention Exercises Part 4: Managing Bribery Risk L11: The Bribery Act 2010 L12: The Bribery Risk Mini-Audit Part 5: Appendices Sample Anti-Fraud Policy 1 Sample Anti-Fraud Policy 2 Sample Fraud Response Plan 1 Sample Fraud Response Plan 2 Sample Whistleblowing Policy Sample Anti-Bribery Policy     Pre-Course Requirements There are no pre-course requirements     Additional Resources PDF copies of the following documents are provided with the course: Sample Anti-Fraud Policy 1 Sample Anti-Fraud Policy 2 Sample Fraud Response Plan 1 Sample Fraud Response Plan 2 Sample Whistleblowing Policy Sample Anti-Bribery Policy Sample Code of Ethics CIMA Fraud Risk Management Guide 2016 The Honesty Questionnaire The Fraud Risk Mini-Audit The Bribery Risk Mini Audit     Course Tutor Your tutor is Ross Maynard. Ross is a Fellow of the Chartered Institute of Management Accountants in the UK and has 30 years’ experience as a process improvement consultant specialising in business processes and organisation development. Ross is also a professional author of online training courses. Ross lives in Scotland with his wife, daughter and Cocker Spaniel

New Excel Functions   Course Description   Ross Maynard     Description In the second half of 2020 Microsoft released a significant upgrade to the most used spreadsheet programme in the world. Microsoft Excel now offers the ability to handle dynamic arrays – functions that return a range of results that update as the source data changes. In this course, we discuss the power of dynamic arrays and introduce the new functions. The functions I am going to cover are: RANDARRAY- creating a table of random numbers or random dates UNIQUE – identifying the distinct items in a list SEQUENCE – listing numbers with a set interval SORT and SORTBY – new ways of dynamically sorting data FILTER – building the ability to filter data into formulae XLOOKUP – replacing VLOOKUP with greater flexibility IFS and SWITCH making it easier to construct IF statements The new CONCAT, and TEXTJOIN text functions   If you have an earlier version of Microsoft Excel then these functions will not be available to you and this course might not be for you. But if you do have a subscription to Office365 – either personally or through your work – I think you will find this course extremely useful.         Learning Outcomes Participants in this course will learn: What the new dynamic arrays feature in Microsoft Excel means How the new RANDARRAY function works How the new UNIQUE function works How the new SEQUENCE function works How the new SORT and SORTBY functions work How the new FILTER function works How the new XLOOKUP function can replace VLOOKUP How to build IF statements with the new IFS function How the new SWITCH function works How the new TEXTJOIN function can replace CONCATENATE and CONCAT How the new functions can be used in management reporting     Course Requirements There are no pre-course requirements.   Additional Resources Course Spreadsheet with the examples covered.       About Ross Ross Maynard is a Fellow of the Chartered Institute of Management Accountants in the UK. He is director of Ideas2Action Process Excellence Ltd and has 30 years’ experience as a process improvement consultant and facilitator. Ross is also a professional author of online training courses for accountants. Ross lives in Scotland with his wife, daughter and Cocker Spaniel

This recording package is for individuals who did not attend the Rethinking Museums live event. If you attended online on 5 February and would like to upgrade your ticket to include a recording, please click here. Since the end of the pandemic, children, young people and families have faced a barrage of challenges to their standard of living, wellbeing, family life and place within society. Our conference will focus on how museums can become welcoming and accessible spaces that enable all children, young people and families to socialise, relax, play, work and learn. The three key themes of the conference are: Family Against the background of a slow post-Covid recovery and ingrained inequalities of access amongst museum audiences, we will share examples of museum programmes that have successfully welcomed children, young people and families who have historically been excluded. Often these new audiences have found a sense of safety and belonging in their local museums and become less isolated. Society In an increasingly polarised world where online disinformation proliferates, museums have a vital role in enabling people to build empathy and explore social justice issues. Work in this space helps museums remain relevant to younger audiences and helps them feel more optimistic about the future. Careers As the number of museum traineeships and apprenticeships are shrinking, so are the routes into a career in heritage. We’ll explore programmes that are opening up the museum workforce and enabling a wider group of young people to find meaningful work and build skills and confidence for future employment. You can read all about the conference and see the schedule on our website. About the recording The recording will include all of the conference sessions. You will receive the recordings approximately six weeks after the conference. You will be able to watch the recordings for six months from the date of the conference. All of the sessions will be captioned.

Working with young volunteers    Would you like to work with young volunteers in your organisation?   About this event   During this training session, we will be exploring all aspects of how to work with young volunteers, from recruitment and logistics to safeguarding.   This webinar will be led by Eleanor Moore the Sustainable Volunteering Officer with the Museum Development South West Programme. Her background is in social and community history curatorship and advisory work within the museums sector, with experience of managing volunteer teams.   She will be joined by Sebastian Amos, Chair of Trustees and Adam Marsden, Young Volunteer at Transport Museum Wythall and Rania Nur, former Young Volunteer, now Trustee at the Museum of the Home. They will be sharing case studies about the young volunteer programmes in their organisations.    The session will help delegates to: understand the importance of this work think about how to develop young volunteer roles gain inspiration from case studies to take your own work forward understand good practice around safeguarding and young volunteers.   Take a look at the full schedule.   Please note: This is a recording of the session which took place 18th June 2024.    Who should attend?   This training is aimed at staff who work in museums, art galleries and heritage sites who are interested in developing or improving their provision for young volunteers. Voluntary volunteer co-ordinators, whose main role is to lead day-to-day on the involvement of volunteers and/or young people, would also benefit from this session.  

Explore the Fundamentals of Networking with the Perfect Introduction to Networking Course. Understand the benefits of networking, spot networking opportunities, prepare for an event, and the following up process. Overcome your fears, enrol Today, and take control of your networking!