Success StoryExtension Statewide Community Needs Assessment



Extension Statewide Community Needs Assessment

Author: Julie N. Zimmerman

Planning Unit: Community & Leadership Development

Major Program: Community Analysis

Outcome: Initial Outcome

In 2023, UK Cooperative Extension conducted a Statewide Community Needs Assessment.  The survey contained 4 sections: Agriculture and Natural Resources, Youth Development, Family and Individual Development, and Community and Economic Development.  Each section contained survey questions about specific topics and possible initiatives and residents were asked to indicate the level of importance of each one.  There were around 36,000 respondents to the survey and the results were placed online on a dynamic dashboard website.  

 

To make the survey results useful for local decision-making as communities conducted the Extension plan of work process (or use the results for grant proposals, etc), I was asked to develop, compile, and provide secondary data that related to the issues covered in the survey.  Each county received 4 issues of Kentucky: By The Numbers with secondary data related to that section of the survey.  

 

In order to create the issues of Kentucky: By The Numbers for the community needs assessment, 63 different data sources were examined for possible data to include.  Most data sources contained multiple variables.   For example, data from the American Community Survey drew from nearly 20 different tables and 13 separate tables were used from County Business Patterns.  To ensure that the data were the most recent available, we used data release schedules for each source to time the data downloads.  All told, we used 312 individual variables resulting in 411 columns of data (not including data used in custom calculations).  Providing data for each of Kentucky’s 120 counties as well as the state, this added up to 49,731 individual data points.  

 

To ease the use and access to the secondary data, data sources (including table numbers and URLS) were provided on each issue.  In addition, each file was exported to a pdf file so that community members could use the dynamic dashboard with the survey results and still have easy access to the secondary data.  Four different webpages were created for the Kentucky: By The Numbers website – one for each section of the survey - and all 484 pdf files were uploaded.






Stories by Julie N. Zimmerman


Beyond The Numbers – Understanding Rural America

about 1 years ago by Julie N. Zimmerman

While my specific Extension program “Kentucky: By The Numbers” focuses on providing access and assis... Read More


Data on Demand – Being Responsive through Kentucky: By The Numbers

about 1 years ago by Julie N. Zimmerman

It used to be that you never knew where a phone call might lead. But today, it more often comes in t... Read More


Stories by Community & Leadership Development


Kentucky Leadership Summit: Facilitating Networks and Conversation & Introducing Ripple Effects Mapping as an Important Tool for Community Leadership Programs

about 1 years ago by Nicole Breazeale

Collaborative Partners:Nicole Breazeale, UK Extension, CLD Associate ProfessorSarah Congleton, UK Co... Read More


Recovery Garden Toolkit & Trainings

about 1 years ago by Nicole Breazeale

The Recovery Garden Toolkit is a Kentucky CES resource developed by a multi-disciplinary team of Ext... Read More