Orange County NC Website
Browse       Search
Exhibit A <br />Proposed Scope of Work <br />Data Analytical Support for 2023 Orange County Community Health Assessment <br />for the Orange County Health Department <br /> <br /> <br />CHA Support Activities: <br /> <br /> Analyze the randomized and online sample survey results in a manner that is clear, concise, and <br />understandable for community presentations and final document. <br /> Develop informative frequency tables, rates, graphs and charts using results of analyses of the <br />randomized and online community surveys. <br /> Conduct secondary data analysis with comparisons made to peer and neighboring comparison <br />counties, and the state of NC using leading causes of death and HNC 2030 as indicators. <br /> Provide information, numbers and descriptions of methodology, analysis, and results of the random <br />sample survey. <br /> Geolocate/code addresses to develop maps showing census blocks and survey locations for <br />randomized community survey. <br /> Submit request to the NC State Center for Health Statistics for address-identified detailed birth <br />certificate and death certificate files for Orange County. <br /> Acquire address-identified data files for most recently available pregnancy, birth and mortality data. <br /> Recode variables and prepare datasets for geocoding and analysis. <br /> Geocode—i.e., assign addresses to residential location-- in geographic information system software. <br /> Aggregate births and deaths by residence to larger geographic levels, including ZIP Codes and census <br />tracts. <br /> Geocode addresses and create maps displaying sub-county geographic variation for selected measures <br />such as distribution of low-birthweight and preterm births and leading causes of death to identify areas <br />where poor health outcomes are concentrated. <br /> Provide GIS/mapping information for geographically identified data collected. <br /> Other data and GIS analysis as needed. <br />Work Process and Reimbursement <br /> Communicate with Orange County HD staff via emails, phone calls and web-conferencing to develop <br />plan of work and discuss findings. <br /> Orange County CHA project work will be documented and reimbursed at the rate of $45.00 per hour. <br /> Invoices will be submitted to the Orange County HD on a monthly basis. <br /> <br />DocuSign Envelope ID: D980F6A6-30F8-487E-BF23-9297B07E2438