Apricot | Data Management | Health and Human Services | Homelessness | Youth Services
Apricot | Data Management | Health and Human Services | Homelessness | Youth Services
Article originally posted in Nonprofit Technology News on August 30, 2021
John Tramel, Associate Director, Drumm Center for Children
The role of social workers is more demanding than ever before and the needs of human services continues to outpace the bandwidth of the most valued asset in driving social impact: our frontline workers. An average case load for a social worker is 300 people and there aren’t enough qualified workers to fulfill the skyrocketing human need. In simple terms, it is estimated that 38 out of 50 states across the US do not have enough social workers to support the humans in need today.
My name is John Tramel and I support the team of employees and volunteers at Drumm Center for Children, also known as Drumm Farm. For over 20 years we’ve provided much-needed housing and support services to children in foster care and young adults who are homeless in the community.
Our organization is focused on three main programs. The first program connects to our history as an orphanage, and we call it the HOME Program, which is a village of foster homes across 50 acres that creates a welcoming neighborhood feel for families to live full time on our campus. We transitioned to a residential group home model in the 80’s, and roughly 10 years ago we shifted into a family-centered neighborhood setting filled with full-time foster homes. This model has allowed us to significantly improve the outcomes for foster children. It eliminates the institution feeling of other models, allows us to keep siblings together, and lets these children experience what it truly feels like to be part of a family.
Our second program, the COMPASS Program, is a campus transitional program that offers an apartment-style home living environment that delivers intensive support services for youth and young adults ages 16 to 22. It also provides necessary services to help them become self-sustaining and emotionally healthy young people. This program’s core focus is to help young adults gain stability and make significant progress to becoming independent young adults. We do this by providing immediate services such as healthcare, food, transportation, and stable housing; clinical services to support mental health; and educational-support services with certified teachers across the state of Missouri to foster the ability to achieve sustainable employment and develop true independency. However long these children are with us–for a short time or an extended stay–we make sure they can learn in a safe, caring environment where they feel connected to and involved in family life.
Our third program is a Street Outreach Program where we provide case management support and therapeutic services for homeless youth and young adults ages 14 to 21 throughout the community who are not living at Drumm Farm. We find housing and support services for them through our local continuum of care, and our partnership with the Kansas City Work Readiness Center delivers that extra layer of support for those young adults looking for even more workforce development programs to foster long-term, independent sustainability.
Drumm Farm recognized the need to embrace technology and automation to better serve the youth across the community that relied on our services. We also realized that implementing case management technology would give us easier access to participant data and help us better understand individual needs, more efficiently manage the hundreds of applications in the metro-wide system, and track youth service requests for faster response delivery. We quickly realized the efficiencies associated with Social Solutions’ Apricot case management software, which has allowed us to serve more people and foster community collaboration.
Here are more details about our experience:
I joined Drumm Farm as Associate Director in 2016. We did not have a data system in place and the team was working predominantly from Excel spreadsheets while using manual pen and paper for all forms and files. I knew early on that we needed to move from this archaic way of tracking applications and managing services for each individual. For example, it took me four days to create a grant report that could have been done in 20 minutes with technology to automate the process.
Several social services organizations across the community, including dozens of school districts, had been using Social Solutions’ Apricot case management software to improve operations, go paperless, streamline workflows, track performance, and enable growth, and I had seen the difference it made firsthand. Even though our budget for technology was small at the time, it was a natural choice for us to make an investment and deploy Apricot at Drumm Farm knowing it would help increase efficiency, inform decisions about resource allocation, and foster community collaboration to better serve individuals.
Apricot was fully implemented at Drumm Farm in the summer of 2017 and it has been transformational for us. Having this data system in place has allowed us to streamline our processes and grow and serve an increasing number of children and youth in need. Our campus has grown from four foster homes to 11 foster homes. Additionally, we will soon have 31 housing units, up from four units in 2016. This growth is tied directly to the Apricot case management system, which accelerated our ability to monitor assessment tools, analyze the data we were collecting, and measure outcomes accurately. Our service-delivery model is multifaceted, and Apricot allows us to easily track–for each individual–educational outcomes, clinical outcomes, therapeutic outcomes, life skills outcomes, and case management status all in one place.
Prior to our technology integration project, Drumm received approximately $30,000 in grants a year. From 2016 to present, we’ve seen a 15X growth in annual grants and Apricot has made it increasingly efficient and easy to manage the grant process paperwork. We can assess daily and run outcome reports quickly at any given time. Paper applications and associated manual surveys are a process of the past. Technology has completely automated this process and made it simple to compare assessment periods, run reports based on data queries, and produce calculations. Outcome reporting that previously took several days is now a mere-minutes process. Importantly, this access to data has positively impacted our fundraising efforts as grantors can see how their donation is really helping children. It also gives us an opportunity to evaluate our mission, articulate where adjustments need to be made, and identify new services we potentially should be providing.
Apricot 360 has increased our ability to serve youth and we now know more about what interventions are helping them. Additionally, we’ve been able to form a true partnership with various program providers across multiple locations within the metro Kansas City community to provide transitional living for homeless youth. We now have a single, shared, and automated application process that simplifies applications for the agencies and youth seeking housing. For example, since we can all access Apricot Connect, I can create one report that allows partner agencies to view and add notes to an applicant’s record.
The software also allows me to put access permissions in place so documents remain confidential. As an example, a therapist has access to therapeutic documents only and a teacher has access to educational documents pertaining to the individual only. As the administrator, I can track data cross-functionally and quickly create reports that show a child’s progress over the year. I can analyze and accurately assess the data to see a child’s stability across all kinds of life domains over a period of time, see growth patterns, and calculate areas where more specific areas of service may be needed.
Currently, we manage more than 800 youth applications in the metro-wide system, all through Apricot Connect, track the youth requesting services at a regional level, and provide faster time-to-service to significantly improve the participant application process and overall experience. We’re truly collaborating as a community to best serve youth.
Whatever your nonprofit’s mission may be, leveraging technology and data is the fastest way to transform your operations and drive greater social impact. If Drumm Farm can do it, anyone can do it.
|_biz_flagsA||1 year||A Cloudflare cookie set to record users’ settings as well as for authentication and analytics.|
|_biz_pendingA||1 year||A Cloudflare cookie set to record users’ settings as well as for authentication and analytics.|
|_biz_sid||30 minutes||This cookie is set by Bizible, to store the user's session id.|
|ARRAffinity||session||ARRAffinity cookie is set by Azure app service, and allows the service to choose the right instance established by a user to deliver subsequent requests made by that user.|
|ARRAffinitySameSite||session||This cookie is set by Windows Azure cloud, and is used for load balancing to make sure the visitor page requests are routed to the same server in any browsing session.|
|BIGipServerab09web-nginx-app_https||session||This cookie is associated with a computer network load balancer by the website host to ensure requests are routed to the correct endpoint and required sessions are managed.|
|cookielawinfo-checbox-analytics||11 months||This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".|
|cookielawinfo-checbox-functional||11 months||The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".|
|cookielawinfo-checbox-others||11 months||This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.|
|cookielawinfo-checkbox-advertisement||1 year||Set by the GDPR Cookie Consent plugin, this cookie is used to record the user consent for the cookies in the "Advertisement" category .|
|cookielawinfo-checkbox-necessary||11 months||This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".|
|cookielawinfo-checkbox-performance||11 months||This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".|
|CookieLawInfoConsent||1 year||Records the default button state of the corresponding category & the status of CCPA. It works only in coordination with the primary cookie.|
|__atuvc||1 year 1 month||AddThis sets this cookie to ensure that the updated count is seen when one shares a page and returns to it, before the share count cache is updated.|
|__atuvs||30 minutes||AddThis sets this cookie to ensure that the updated count is seen when one shares a page and returns to it, before the share count cache is updated.|
|__cf_bm||30 minutes||This cookie, set by Cloudflare, is used to support Cloudflare Bot Management.|
|_biz_nA||1 year||This cookie, set by Bizible, is a sequence number that Bizible includes for all requests, for internal diagnostics purposes.|
|_biz_uid||1 year||This cookie is set by Bizible, to store user id on the current domain.|
|bcookie||1 year||LinkedIn sets this cookie from LinkedIn share buttons and ad tags to recognize browser ID.|
|lang||session||LinkedIn sets this cookie to remember a user's language setting.|
|lidc||1 day||LinkedIn sets the lidc cookie to facilitate data center selection.|
|UserMatchHistory||1 month||LinkedIn sets this cookie for LinkedIn Ads ID syncing.|
|_gaexp||2 months 10 days 10 hours||Google Analytics installs this cookie to determine a user's inclusion in an experiment and the expiry of experiments a user has been included in.|
|_uetsid||1 day||Bing Ads sets this cookie to engage with a user that has previously visited the website.|
|_uetvid||1 year 24 days||Bing Ads sets this cookie to engage with a user that has previously visited the website.|
|SRM_B||1 year 24 days||Used by Microsoft Advertising as a unique ID for visitors.|
|_BUID||1 year||This cookie, set by Bizible, is a universal user id to identify the same user across multiple clients’ domains.|
|_ga||2 years||The _ga cookie, installed by Google Analytics, calculates visitor, session and campaign data and also keeps track of site usage for the site's analytics report. The cookie stores information anonymously and assigns a randomly generated number to recognize unique visitors.|
|_ga_33YSH1JFFW||2 years||This cookie is installed by Google Analytics.|
|_gcl_au||3 months||Provided by Google Tag Manager to experiment advertisement efficiency of websites using their services.|
|_gd_session||4 hours||This cookie is used for collecting information on users visit to the website. It collects data such as total number of visits, average time spent on the website and the pages loaded.|
|_gd_visitor||2 years||This cookie is used for collecting information on the users visit such as number of visits, average time spent on the website and the pages loaded for displaying targeted ads.|
|_gid||1 day||Installed by Google Analytics, _gid cookie stores information on how visitors use a website, while also creating an analytics report of the website's performance. Some of the data that are collected include the number of visitors, their source, and the pages they visit anonymously.|
|_hjAbsoluteSessionInProgress||30 minutes||Hotjar sets this cookie to detect the first pageview session of a user. This is a True/False flag set by the cookie.|
|_hjFirstSeen||30 minutes||Hotjar sets this cookie to identify a new user’s first session. It stores a true/false value, indicating whether it was the first time Hotjar saw this user.|
|_hjIncludedInPageviewSample||2 minutes||Hotjar sets this cookie to know whether a user is included in the data sampling defined by the site's pageview limit.|
|_hjIncludedInSessionSample||2 minutes||Hotjar sets this cookie to know whether a user is included in the data sampling defined by the site's daily session limit.|
|_hjTLDTest||session||To determine the most generic cookie path that has to be used instead of the page hostname, Hotjar sets the _hjTLDTest cookie to store different URL substring alternatives until it fails.|
|at-rand||never||AddThis sets this cookie to track page visits, sources of traffic and share counts.|
|CONSENT||2 years||YouTube sets this cookie via embedded youtube-videos and registers anonymous statistical data.|
|undefined||never||Wistia sets this cookie to collect data on visitor interaction with the website's video-content, to make the website's video-content more relevant for the visitor.|
|uvc||1 year 1 month||Set by addthis.com to determine the usage of addthis.com service.|
|_fbp||3 months||This cookie is set by Facebook to display advertisements when either on Facebook or on a digital platform powered by Facebook advertising, after visiting the website.|
|_mkto_trk||2 years||This cookie, provided by Marketo, has information (such as a unique user ID) that is used to track the user's site usage. The cookies set by Marketo are readable only by Marketo.|
|ANONCHK||10 minutes||The ANONCHK cookie, set by Bing, is used to store a user's session ID and also verify the clicks from ads on the Bing search engine. The cookie helps in reporting and personalization as well.|
|fr||3 months||Facebook sets this cookie to show relevant advertisements to users by tracking user behaviour across the web, on sites that have Facebook pixel or Facebook social plugin.|
|loc||1 year 1 month||AddThis sets this geolocation cookie to help understand the location of users who share the information.|
|MUID||1 year 24 days||Bing sets this cookie to recognize unique web browsers visiting Microsoft sites. This cookie is used for advertising, site analytics, and other operations.|
|test_cookie||15 minutes||The test_cookie is set by doubleclick.net and is used to determine if the user's browser supports cookies.|
|VISITOR_INFO1_LIVE||5 months 27 days||A cookie set by YouTube to measure bandwidth that determines whether the user gets the new or old player interface.|
|YSC||session||YSC cookie is set by Youtube and is used to track the views of embedded videos on Youtube pages.|
|yt-remote-connected-devices||never||YouTube sets this cookie to store the video preferences of the user using embedded YouTube video.|
|yt-remote-device-id||never||YouTube sets this cookie to store the video preferences of the user using embedded YouTube video.|
|_an_uid||7 days||No description available.|
|_clck||1 year||No description|
|_clsk||1 day||No description|
|_dc_gtm_UA-718299-1||1 minute||No description|
|_hjSession_2602456||30 minutes||No description|
|_hjSessionUser_2602456||1 year||No description|
|6suuid||2 years||No description available.|
|AnalyticsSyncHistory||1 month||No description|
|CLID||1 year||No description|
|d-a8e6||1 year||No description available.|
|dpi_test||1 day||No description|
|dpi_utmOrigVals||5 months 27 days||No description|
|intercom-id-rbb6qelf||8 months 26 days 1 hour||No description|
|intercom-session-rbb6qelf||7 days||No description|
|li_gc||5 months 27 days||No description|
|loglevel||never||No description available.|
|referrer||session||No description available.|
|s-9da4||15 minutes||No description available.|
|SM||session||No description available.|
|xtc||1 year 1 month||No description|
We are becoming BonterraTM
We are becoming BonterraTM