Convene Action Phase 1
Assess Action Phase 2
Analyze Action Phase 3
ACT Together Action Phase 4

Action Phase 3: Analyze

Analyze the community assessment findings and determine action priorities for your community.  This phase consists of three key steps.

Step 1: Prepare to Analyze the Assessment Findings

The community assessment team lead and data entry person should revisit the assessment instructions and data collection tools (described in Step 2).  



Collect and review all completed questionnaires.  Make sure each one has a unique code, using the sector abbreviation and a number. For example, clinic questionnaires would be C1 for the first interviewee, C2 for the second, etc.  Sort by sectors and count totals.


Step 2: Compile the Collected Data

Download and save a copy of each data collection tool below.  Use these tools to enter data and findings from the completed questionnaires.  If there are data gaps, conduct more interviews and complete the related questionnaires.

Check Box and Inventory Questions

For questions with answers like “yes/no” or “check all that apply,” tally the number of responses for each answer option and input into the Community Needs Assessment.  Transfer inventory responses into the Assessment as well.


Community Needs Assessment


Level of Activity and Priority Rating Questions

For opinion questions, plot the level of activity and priority rating responses on the corresponding matrix worksheets.  As a guide, view the toolkit video How to Use the Visual Matrices to Set Priorities.


Matrix Worksheets (folder with worksheets for Questions 5 – 25)


Open-ended Questions

The completed questionnaires include an open-ended question about community strengths and gaps concerning dementia, as well as a question about referrals.  Document responses in the corresponding worksheets. 

Community Gaps Worksheet – Question 3                               
Referrals Worksheet – Question 4

Project Involvement Questions
The completed questionnaires have three questions about interest in the dementia-friendly community work.  Document responses in the List of Contacts Worksheet.


List of Contacts Worksheet


Step 3: Analyze the Data

When all data is compiled into the data collection tools and worksheets, a subgroup (2-3 people) of the Action Team needs to analyze the data and identify the top priorities in your community.  

Share the findings about diverse and underserved communities and the resources available with both people and organizations serving these communities. 

Determine your community’s strengths (high level of activity) and gaps/opportunities (low level of activity) for each key area.  View the toolkit video How to Use the Visual Matrices to Set Priorities for guidance.  Summarize activity/priority findings from each matrix in the Priority Rating Worksheet. 


Priority Rating Worksheet


Use responses from the open-ended questions to identify themes and compare these themes with what the team has identified as high priority and low level of activity.

Share high-level results with the full Action Team rather than the detailed worksheets.

Use the Questions for Reflective Team Discussion tool to facilitate discussion of the assessment results and to identify dementia-friendly priorities for your community.