December 2020 // Volume 58 // Number 6 // Tools of the Trade // v58-6tt7
Existing Data Sources as Tools for Entry-Stage Extension Professionals
Due to the nature of Extension, work across counties differs because efforts are grounded in the needs of a community and intentional programming helps address these needs. A common competency required for entry-stage Extension professionals is program development, which includes planning, design, implementation, and evaluation. Understanding a community's needs is a crucial aspect of the program planning process, yet new Extension professionals may not know where to locate existing information about their communities. Before creating Extension programs, Extension professionals should understand local communities and identify existing data to facilitate the needs assessment phase of program development.
Program development involves the four main steps of planning, design, implementation, and evaluation (Franz et al., 2015), and needs assessments are a critical component of planning programs. Due to the nature of Extension, work across counties differs because efforts are grounded in the unique needs of each community. A needs assessment for a particular community is useful because it identifies a gap between "what is . . . and what should be" (Witkin & Altschuld, 1995, p. 4). Indeed, a critical first step in program development is becoming familiar with the needs of a community (Futris & Schramm, 2015), and existing data can be used to guide program development, determine feasibility of programs, develop situation statements, highlight existing areas of need, and create predictive power. Early-career Extension professionals can use existing data to guide their program development processes.
Data comprises "factual information used as a basis for reasoning, discussion, or calculation" (Merriam-Webster, n.d., para. 1). Many agencies and institutions, including members of the health and service industries, schools and libraries, and businesses, maintain records (Witkin & Altschuld, 1995). These sources of existing data can be helpful to Extension professionals because they are readily available and cost effective to access. Zimmerman and Kahl (2018) published a guide for Extension professionals related to locating online data and navigating data websites. Herein we build on the work of Zimmerman and Kahl and outline additional internal and external data sources.
Internal Data Sources
Internal data sources are "retrieved from inside the organization to make decisions for successful operations" (Johns & Scalia, n.d., para. 2). The key to locating internal data sources is determining who the gatekeepers are for the relevant kinds of data. New Extension professionals should start this process by contacting their supervisors and program leaders. Examples of internal data sources found in many state Extension systems include
- individual plans of work,
- annual accomplishment reports,
- past county needs assessments,
- advisory council minutes,
- county-level strategic plans,
- state-level strategic plans,
- customer satisfaction data,
- federal plans of work, and
- past statewide Agricultural Research, Extension, and Education Reform Act reports.
External Data Sources
External data sources are "all data outside [an] organization's operating systems" (Walters, n.d., p. 1). We compiled a list of external data sources useful to Extension professionals (Table 1).
|U.S. Census||This resource has data about the U.S. population and economy (U.S. Census, n.d.). The U.S. Census website includes how-to videos on gathering and presenting data.||
U.S. Census information:
Data Gems how-to videos:
|U.S. Department of Education (DOE) and National Center for Education Statistics (NCES)||These resources have data about U.S. schools, such as (a) state report cards, (b) district report cards, and (c) school report cards (DOE, n.d.). DOE and NCES existing data are valuable for educational programming, especially for 4-H.||
|U.S. Department of Agriculture (USDA) and state departments of agriculture (e.g., Florida Department of Agriculture and Consumer Services)||Such resources have data regarding agriculture, natural resources, and nutrition (USDA, n.d.-a). The USDA Census of Agriculture has county profiles outlining numbers of farms, sizes of farms, and commodities grown (USDA, n.d.-b). Extension professionals can search by state and county to narrow results specific to communities.||
USDA Census of Agriculture information:
|U.S. Environmental Protection Agency (EPA) and state environmental protection agencies (e.g., California EPA)||Such resources have data such as resident and business water usage and water characteristics (e.g., quality, quantity, availability) in a given area. State environmental protection agencies can be found across the United States.||
U.S. EPA information:
|Centers for Disease Control and Prevention (CDC) Social Vulnerability Index (SVI)||This resource has information from health officials who identify communities likely to need support due to hazardous events such as hurricanes or disease outbreaks (CDC, n.d.). This resource informs on potential challenges related to vulnerability factors such as lack of transportation and crowded housing (CDC, n.d.).||
CDC SVI information:
|The National Association of Counties (NAC)||This resource has data on nationwide issues such as public safety, transportation, and community development (NAC, n.d.).||
|State associations of counties (e.g., Arkansas Association of Counties [AAC])||These resources provide services such as legal representation, general research, training, and conferences to help county officials (AAC, n.d.). Member counties have local governments that collect data on topics such as commercial businesses, building footprints, zoning, and stormwater management (AAC, n.d.).||State associations of counties information: https://www.countyexecutives.org/state-associations|
|The Farm Bureau||This resource includes lobbyists who represent the agriculture industry at the national, state, and local levels (Farm Bureau, n.d.). County Farm Bureau offices have information regarding policy, events, and educational outreach (Farm Bureau, n.d.).||
Farm Bureau information:
|Agricultural associations or other interest groups (e.g., farmers market coalitions)||Such resources are generally described as people or organizations with common concerns (Lumen, n.d.). For example, the Washington Apple Commission (n.d.) is a commodity group that supports "advertising, promotion, education and market development for the Washington fresh apple crop" (para. 1).||
Farmers Market Coalition information:
Conclusion and Recommendations
A guiding principle of Extension is ensuring its continued relevance and connection to the local community (Henning et al., 2014). Early-career Extension professionals can use existing data to write a situation statement for a plan of work or present a summary of existing data to an advisory council to discuss priority needs. Additionally, existing data can help one determine who should be on an advisory council, thus helping ensure an equal representation of stakeholders. Furthermore, existing data may be helpful when writing grant applications for local community organizations that traditionally support Extension programs, such as banks, nonprofit centers, library districts, and retail stores. Early-career Extension professionals can conserve their limited resources such as time and money by taking advantage of available data sources. These existing data sources should be used by Extension professionals as the first step in program development to address a variety of programmatic issues applicable to their local communities.
This material is based on work supported by the National Science Foundation Graduate Research Fellowship Program. Any opinions, findings, and conclusions or recommendations expressed in this material are those of the authors and do not necessarily reflect the views of the National Science Foundation.
Correspondence concerning this article should be addressed to Olivia Caillouet. Email: firstname.lastname@example.org
Arkansas Association of Counties. (n.d.). About us. https://www.arcounties.org/about-us/
Centers for Disease Control and Prevention. (n.d.). Social vulnerability index. https://svi.cdc.gov/map.html
Farm Bureau. (n.d.). About us. https://www.fb.org/about/overview
Franz, N. K., Garst, B. A., & Gagnon, R. J. (2015). The Cooperative Extension program development model: Adapting to a changing context. Journal of Human Sciences and Extension, 3(2), 3–12. https://www.jhseonline.com/article/view/682
Futris, T. G., & Schramm, D. G. (2015). Program development from start-to-finish: A case study of the healthy relationship and marriage education training project. Journal of Extension, 53(3), Article v53-3a4. https://www.joe.org/joe/2015june/a4.php
Henning, J., Buchholz, D., Steele, D., & Ramaswamy, S. (2014). Milestones and the future for Cooperative Extension. Journal of Extension, 52(6), Article v52-6comm1. https://joe.org/joe/2014december/comm1.php
Johns, A., & Scalia, S. (n.d.). What is internal data? Definition and sources. https://study.com/academy/lesson/what-is-internal-data-definition-sources.html
Lumen. (n.d.). Types of interest groups. https://courses.lumenlearning.com/boundless-politicalscience/chapter/types-of-interest-groups/
Merriam-Webster. (n.d.). Definition of data. https://www.merriam-webster.com/dictionary/data
National Association of Counties. (n.d.). Stronger communities together. https://www.naco.org/what-we-do/about-naco
U.S. Census. (n.d.). Explore census data. https://data.census.gov/cedsci/
U.S. Department of Agriculture. (n.d.-a). Reports and documents. https://www.usda.gov/our-agency/about-usda
U.S. Department of Agriculture. (n.d.-b). USDA census of agriculture. https://www.nass.usda.gov/AgCensus/
U.S. Department of Education. (n.d.). Data & statistics. https://www2.ed.gov/rschstat/landing.jhtml?src=pn
Walters, T. (n.d.). Incorporating external data into the data warehouse. https://support.sas.com/resources/papers/proceedings/proceedings/sugi22/DATAWARE/PAPER116.PDF
Washington Apple Commission. (n.d.). About WAC. https://bestapples.com/general-contact-info/
Witkin, B. R., & Altschuld, J. W. (1995). Planning and conducting needs assessments: A practical guide. SAGE Publications.
Zimmerman, J. N., & Kahl, D. (2018). Finding publicly available data for Extension planning and programming: Developing community portraits. Journal of Extension, 56(3), Article v56-3tt5. https://www.joe.org/joe/2018june/tt5.php