1 / 30

Data, Digital & Impact - tales from the micro charity world…

Data, Digital & Impact - tales from the micro charity world…. Kate White. About Superhighways. Providing tech support to the sector for 20 years Training – current dates & brochure Support Consultancy Digital inclusion Impact Aloud

alittlefield
Download Presentation

Data, Digital & Impact - tales from the micro charity world…

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Data, Digital & Impact - tales from the micro charity world… Kate White

  2. About Superhighways Providing tech support to the sector for 20 years • Training – current dates & brochure • Support • Consultancy • Digital inclusion • Impact Aloud • E-news sign up https://superhighways.org.uk/e-news

  3. Top digital tools for capturing your impact • Top digital tools for presenting your impact • Excel for monitoring & evaluation • So you need a database? • Creating easy infographics for impact • Do the numbers add up? Understanding your data better • Putting your data on the map • Borough Data Hack Days

  4. From paper to online data collection “The google forms have been so useful! It is amazing to see the answers compiled into graphs and charts straight away.” “I no longer need to persuade the Team Leaders of the need for digitising our data collection - it is being automatically driven by GDPR!”

  5. Making the most of Excel.. • Sorting & Filtering • Conditional formatting • CountIf • Pivot tables “I believe very strongly that charities benefit from investing in upskilling their workforce around IT and Excel is a fantastic tool: • Easy for staff to learn how to use • Cheap to build • Fun to use! • Great for reporting! • Give us confidence we know our project • Easy to analyse trends”

  6. Interrogate, Shape, Fund, Grow, Report!

  7. Excel for Monitoring & Evaluation • I will be able to present data to staff and trustees in much more digestible ways. This will capture their interest and help them to understand what the data means. • I hope it will help ensure our service planning is based more on data rather than on what we think we know e.g. more easily see whether service use is representative across the borough or whether carers in some areas make more use of services than others.

  8. Outcomes from our data • From collecting postcodes we could see there was a demand in the North of the Borough so we have opened a satellite counselling service in Upper Norwood • Analysing presenting issues identifies areas for CPPD • There was an Increase in the number of young people presenting with Identity Issues therefore we held a Gender Identity Conference.

  9. Affordable off the shelf online databases

  10. Choosing the best fit? • Data audit – input from across organisation • System brief – driving factors, reporting needs, support, budget etc • Shortlist systems & options appraisal • Select system & provider / Tender process

  11. Feedback – CharityLog implementation • Efficiencies“Implementation of a new case and information management system has streamlined how we record our work on a daily basis and across all of our monitoring and evaluation activities” • Evaluation & Sustainability“We use this to inform how we are delivering our services and help us to secure the funding we need to meet the need for help from families” • Scaling up & collaboration “This has supported us through our transition from working in one to three boroughsand has now been adopted by 6 other equivalent London organisations. It will help us to deliver joint projects and apply for new funding opportunities working together”

  12. Improvements – Salesforce implementation • Organisation and IT = culture shift • Remote working = stable and consistent = travel time saver • Reimagining our programmes = process invites questions, critique of long standing structure • Team closer to targets, evaluations and seeing their results • Reporting - 1st completed report without asking team to complete additional Word template!

  13. Infographics for impact

  14. Simplest map creation… Paste data sets with postcodes & create a map!

  15. Google My Maps • Add multi-media • Add different layers (max 10) • Customise look and feel

  16. Data analysis / visualisation - next steps Carto– non profit application for the Builder application Tableau – non profit discount available via Tech Trust Flourish – free for public maps PowerBI – free desk top download or Office 365 app (free subscription for non profits)

  17. Southwark Data Hack 30 Jan 2019

  18. What’s next…. • Cornerstone proposal – 2nd stage just submitted (City Bridge Trust) • 2 year data literacy & digital skills support programme for London’s small local charities and community groups • 6 partners • London Plus • DataKind UK • Coalition for Efficiency • HEAR Network • Makerble • GLA • 25+ other stakeholders – please do join us!

  19. Q9: What assets could you offer to the programme • Answered: 29 Skipped: 0

  20. Thank you for listening! Kate White katewhite@superhighways.org.uk www.superhighways.org.uk @SuperhighwaysUK

More Related