1

The Title VI Infographic is designed to help you summarize and share your program data in a 

meaningful way. This infographic can be used to:

• Share information about your program with your elders, the community, and other 

stakeholders; 

• Support program planning; and

• Inform program monitoring and evaluation. 

This guide will help you customize the infographic to showcase your program. The instructions 

walk you step-by-step from where to find your data to how to enter your specific program 

information for each section of the infographic. In addition, the guide includes further 

recommendations and tips for using the infographic. 

USER GUIDE

Title VI Infographic Toolkit
2

Overview of the Infographic 

GRANTEE NAME AND YEAR 

This section of the infographic identifies your 

program/community and the year for which you are 

reporting. 

OVERVIEW OF TITLE VI PROGRAM

This section provides an overview of Title VI Programs and 

services. 

 

ELDER PROFILE

The Elder Profile section summarizes the self-reported 

health status of the elders living in your community. This 

information comes from your most recent Elder Needs 

Assessment Survey. 

 

PROGRAM DELIVERY AND PARTICIPATION 

The Program Delivery and Participation section 

summarizes the number of units and clients you have 

served by specific Title VI services. This information 

comes from your annual Program Performance Report 

(PPR) data. This section also highlights the percentage of 

elders who said they are currently using Title VI services.

This information comes from your Elder Needs 

Assessment Survey report.

PROGRAM IMPROVEMENT

The Program Improvement section summarizes key 

program improvement efforts you are doing, including 

staff trainings, technical support, and evaluation.

Title VI Infographic, Page 2

Title VI Infographic, Page 1
3

Updating Your Infographic 

This portion of the guide walks you through the process for updating the infographic to reflect 

your program data. There are instructions for each section of the infographic. For each section, 

you will see directions as to where you can find that information for your program, how to 

prepare the information, and how to enter the information into the infographic. 

Infographic Section: Elder Profile

SECTION CHART DATA SOURCE INSTRUCTIONS 

Feel Overall 

Unhealthy Donut

Chart 

Elder Needs Assessment 

(NRCNAA Identifying Our 

Needs: A Survey of Elders) 

• Question 1

1. Look at your Elder Needs Assessment 

report* from NRCNAA/UND and find 

the responses to Question 1. 

2. In the Infographic Calculations

Worksheet, enter the percentage for

“Fair”, “Poor”, “Very Good”, and 

“Excellent” in the “Elder Profile” tab, 

column O, rows 7-11, respectively.

Row 12 will calculate the value for “Q1. 

Fair + Poor”, and row 13 will calculate 

the value for “Q1. Excellent + Very 

Good + Good.” 

3. Follow instructions on how to 

enter/edit data in the Title VI Data 

Visualization Infographic (Appendix B). 

4. Enter the values from rows 12 and 13

in the infographic. These are the 

percentages for “Feel Overall 

Unhealthy.”

“Section Chart” tells you which section of the infographic you are 

focusing on. Have your Infographic open to better follow this step.

“Data Source” tells you where you will be able to find the 

information (Elder Needs Assessment and PPR). Have your data 

sources in hands to complete this step. 

“Instructions” tells you how to prepare the information to be added 

to your infographic. Use your Calculations Worksheet in this step. 
4

SECTION CHART DATA SOURCE INSTRUCTIONS 

Feel Mostly Happy 

Donut Chart

Elder Needs Assessment 

(NRCNAA Identifying Our 

Needs: A Survey of Elders) 

• Question 54**

1. Look at your Elder Needs Assessment 

report* from NRCNAA/UND and find 

the responses to Question 54. 

2. In the Infographic Calculations

Worksheet, enter the percentage for 

“All the time”, “Most of the time”, “A 

good bit of the time”, “Some of the 

Time”, “A Little Bit of the Time”, and 

”None of the Time” in the “Elder 

Profile” tab, column O, rows 17-22, 

respectively. Row 23 will calculate the 

value for “Q54. All the time + Most of 

the time + A good bit of the time”, and 

row 24 will calculate the value for

“Q54. Some of the Time + A Little Bit of 

the Time+ None of the Time.”

3. Follow instructions on how to 

enter/edit data in the Title VI Data 

Visualization Infographic (Appendix B).

4. Enter the values from rows 23 and 24

in the infographic. These are the 

percentages for “Feel Mostly Happy.”

Have Difficulties 

with Activities of 

Daily Living Donut 

Chart

 

Elder Needs Assessment

(NRCNAA Identifying Our 

Needs: A Survey of Elders) 

• Measure of Long 

Term Care Needed 

(generated from 

Questions 5 and 6) 

1. Look at your Elder Needs Assessment 

report* from NRCNAA/UND and find 

the responses to the section Measure 

of Long Term Care Needed.

2. In the Infographic Calculations

Worksheet, enter the percentage for 

“Little or None”, “Moderate”, 

“Moderately Severe”, and “Severe” in 

the “Elder Profile” tab, column O, rows 

28-31, respectively. Row 32 will 

calculate the value for “MLTCN: Little or 

None”, and row 33 will calculate the 

value for “MLTCN: Moderate + 

Moderately Severe + Severe.” 

3. Follow instructions on how to 

enter/edit data in the Title VI Data 

Visualization Infographic (Appendix B). 

4. Enter the values from rows 32 and 33

in the infographic. These are the 
5

SECTION CHART DATA SOURCE INSTRUCTIONS 

percentages for “Have Difficulties with 

Activities of Daily Living.”

Have an 

Illness/Condition 

Impacting Diet 

Donut Chart 

Elder Needs Assessment 

(NRCNAA Identifying Our 

Needs: A Survey of Elders) 

• Question 44**

1. Look at your Elder Needs Assessment 

report* from NRCNAA/UND and find 

the response to Question 44, option “I 

have an illness or condition that made 

me change the kind and/or amount of 

food I eat.” 

2. In the Infographic Calculations

Worksheet, enter the percentage for 

“Have an Illness/Condition Impacting 

Diet” in the “Elder Profile” tab, column 

O, row 37. Row 38 will generate the 

value for “Q44. Illness impacting Diet.” 

3. Follow instructions on how to 

enter/edit data in the Title VI Data 

Visualization Infographic (Appendix B).

4. Enter the value for row 38 in the 

infographic. This is the percentage for

“Have an Illness/Condition Impacting 

Diet.” 

Face Food 

Insecurity Donut 

Chart

1. Look at your Elder Needs Assessment 

report* from NRCNAA/UND and find 

the responses to Question 44, option “I 

don’t have enough money to buy the 

food I need.” 

2. In the Infographic Calculations

Worksheet, enter the percentage for 

“Face Food Insecurity” in the “Elder 

Profile” tab, column O, row 42. Row 43

will generate the value for “Q44. Not 

Enough Money to Buy Food.”

3. Follow instructions on how to 

enter/edit data in the Title VI Data 

Visualization Infographic (Appendix B).

4. Enter the value for row 43 in the 

infographic. This is the percentage for 

“Face Food Insecurity.”
6

SECTION CHART DATA SOURCE INSTRUCTIONS 

Live with a Family 

Caregiver Donut 

Chart

Elder Needs Assessment 

(NRCNAA Identifying Our 

Needs: A Survey of Elders) 

• Question 49**

1. Look at your Elder Needs Assessment 

report* from NRCNAA/UND and find 

the responses to Question 49. 

2. In the Infographic Calculations

Worksheet, enter the percentage for 

“With family members” and “With both 

family and non-family members”, “With 

non-family members”, and “Alone” in 

the “Elder Profile” tab, column O, rows 

47-50, respectively. Row 51 will 

calculate the value for “Q49. With 

family members + With both family and 

non-family members”, and row 52 will 

calculate the value for “Q49. With nonfamily members + Alone.”

3. Follow instructions on how to 

enter/edit data in the Title VI Data 

Visualization Infographic (Appendix B).

4. Enter the values for rows 51 and 52 in

the infographic. These are the 

percentages for “Live with a Family

Caregiver.”

Raise Grandchildren 

Donut Chart 

Elder Needs Assessment

(NRCNAA Identifying Our 

Needs: A Survey of Elders) 

• Question 53**

1. Look at your Elder Needs Assessment 

report* from NRCNAA/UND and find 

the responses to Question 53. 

2. In the Infographic Calculations 

Worksheet, enter the percentage for 

“Yes” and “No” in the “Elder Profile” 

tab, column O, rows 56 and 57, 

respectfully. Row 58 will generate the 

value for “Q52. Yes”, and row 59 will 

generate the value for “Q52. No.”

3. Follow instructions on how to 

enter/edit data in the Title VI Data 

Visualization Infographic (Appendix B).

4. Enter the values for rows 58 and 59 in

the infographic. These are the

percentages for “Raise Grandchildren. 

* See Appendix A for an example screenshot of the Elder Needs Assessment report. 

** Question numbers are from the Elder Needs Assessment Cycle VII Survey. The respective Cycle VI Survey 

question numbers are: Question 53 for Feel Mostly Happy, Question 43 for Have an Illness/Condition Impacting
7

Diet and Face Food Insecurity, Question 48 for Live with a Family Caregiver, and Question 51 for Raise 

Grandchildren.

Infographic Section: Program Delivery and Participation 

SECTION CHART DATA SOURCE INSTRUCTIONS 

Percent of 

Community Elders

Chart

 

Elder Needs Assessment 

(NRCNAA Identifying Our 

Needs: A Survey of Elders) 

• Question 60 **

1. Look at your Elder Needs Assessment 

report* from NRCNAA/UND and find 

the responses to Question 60, column 

“Now Using.” 

2. In the Infographic Calculations

Worksheet, enter the percentage for 

each Title VI Service in their respective 

rows in the “Program Delivery & 

Participation” tab, column O, rows 7-

11. Rows 12-16 will generate the values 

for “Q59. Now Using: Congregate 

Meals”, “Q59. Now Using: Home 

Delivered Meals”, “Q59. Now Using: 

Caregiver Services”, “Q59. Now Using: 

Transportation Services”, and “Q59. 

Now Using: Information and 

Assistance.” 

3. Follow instructions on how to 

enter/edit data in the Title VI Data 

Visualization Infographic (Appendix B).

4. Enter the values for rows 12-16 in the

infographic. This is the percent of 

“Community Elders Using Title VI 

Services.” 

Number of Clients 

Served AND Number 

of Units Served by 

Client Bar Chart*

Title VI PPR Data 1. Look at your most recent Annual Title 

VI PPR Data.

2. In the Infographic Calculations

Worksheet, enter the Units and Clients 

served for each of the Title VI services 

in the “Program Delivery & 

Participation” tab, column O, rows 22-

25 (Nutrition Services), 27-42 

(Supportive Services) and 44-59

(Caregiver Support Services). Rows 60-

67 will calculate the “Number of Units
8

SECTION CHART DATA SOURCE INSTRUCTIONS 

Served by Client” and “Clients Served” 

for Supportive Services, Caregiver 

Services, and Home Delivered Meals, 

and Congregate meals, respectively.

3. Follow instructions on how to 

enter/edit data in the Title VI Data 

Visualization Infographic (Appendix B).

4. Enter the values in rows 60-67 in the 

infographic.

Outreach Services 

Text Box

Your Knowledge and 

Experience of Your Program 

Practices (Qualitative Data)

Click on the text box to list the strategies you 

use to advertise and share information about 

your program as well as identify potential 

clients. This may include community 

newsletters, tabling at community events, and 

hosting resource fairs, among others.

Programs Activities 

and Events Text Box

Click on the text box to list a few examples of 

the types of activities and events your program 

provides to seniors, caregivers, families, and 

the community. This may include monthly lunch 

and learns, weekly shopping and bill pay trips 

for elders, an annual caregiver resource fair, 

Elder appreciation luncheons, Senior Olympics, 

and more.

Program Partners Click on the text box to list the key partners 

that support your Title VI program delivery. This 

may include other tribal departments (housing, 

clinic, etc.) as well as other local and state 

programs.

* Number of Clients Served and Number of Units Served by Client are presented in one single bar chart within the 

Program Delivery and Participation section. 

**Question numbers are from the Elder Needs Assessment Cycle VII Survey. The respective Cycle VI Survey 

question numbers for Percent of Community Elders is Question 59.
9

Infographic Section: Program Improvement 

SECTION CHART DATA SOURCE INSTRUCTIONS

Technical 

Assistance Text Box

Your Knowledge and 

Experience of Your Program 

Practices (Qualitative Data)

Click on the text box to list topics that program 

staff would like more support on in order to 

better provide Title VI and related services. 

These may include topics related to content

area (e.g., elder abuse), technical needs (e.g., 

data management), and program 

planning/development (e.g., strategic planning 

and budgeting).

Trainings Text Box Click on the text box to list the major trainings 

staff have attended this year to support their 

work with Title VI. This may include trainings 

offered by your community as well as state and 

federal agencies and partners.

Evaluation Text Box Click on the text box to list the ways your 

program assesses how the Title VI program 

meets the needs of elders and caregivers in the 

community. These may include surveys, 

suggestion boxes, interviews, and talking circles 

to assess elder and caregiver satisfaction. 
10

Using the Title VI Infographic 

The Title VI Infographic can support you in turning data into knowledge and action. Before using 

this tool, lay out a complete plan for your presentation by answering the following questions: 

When to Use the Title VI Infographic

To Inform Stakeholders About Your Program 

Funding agencies, local stakeholders, tribal leadership, and partner programs may be interested 

in knowing what the Title VI program service populations and delivery practices are. This is a 

great opportunity to highlight the reach of your services in the community. 

Tip: Bring information about your community context, data collection, and program needs for 

each key data point, highlighting the gaps and opportunities. 

To Support Program Planning

When reviewing your Title VI Infographic, try to identify the meaning in each data point. Your 

data provides information on clients’ needs, strengths and gaps in service delivery, and 

opportunities to improve program practices. The infographic can be a starting point for team 

discussions about goals for the program and strategic, actionable next steps. 

Tip: Involve your program team in the interpretation of your Title VI Infographic. Look across 

multiple years of program data to see patterns. 

To Facilitate Program Monitoring and Evaluation 

Your infographic can help you understand if your program is meeting its intended goals. By 

reviewing your data on a regular basis, your program can identify any gaps in your existing 

program data and knowledge. For example, are there other questions about your program that 

are not answered by your current available data? These questions can be the focus of 

additional evaluation efforts, such as talking circles with elders and caregivers. Further, 

comparing multiple years of your infographic data helps you monitor key program indicators 

and identify trends to inform continuous quality improvement initiatives. 

Tip: The infographic can be used as part of focus groups and talking circles with program 

stakeholders (e.g., elders, caregivers) to understand the context behind particular findings in the 

data. 

The Goal The Audience The Message The Intended 

Action

What is the point 

of sharing this 

data?

Who is interested 

in this data? Who 

has the ability to 

take action to 

meet your goal?

Does the 

information (data)

presented align 

with your goal?

What actions do you 

want the audience 

to take?
11

 

 

Appendix A

Screenshot of NRCNAA Identifying Our Needs: 

A Survey of Elders
12

Screenshot of the NRCNAA Identifying Our Needs: A Survey of Elders 

Report

Your Data will 

be displayed 

in the Tribal 

Data column. 

The Aggregated Tribal 

Data and National 

Data can serve as 

comparisons.
13

 

 

Appendix B

Entering Your Data in the Infographic
14

Entering Your Data in the Infographic 

In this section, you will learn how to update the infographic charts with your own program 

data. 

1. Right-click on the chart you want to update. 

2. When you right-click on the chart, a window will open. 

Right-click on the chart. 

Click on “Edit Data.” 
15

3. You now have the option to enter/edit your data in a pop-up or in Excel. 

5. Edit and enter your data in the pop-up or in Excel. 

In both the pop-up window and the Excel worksheet, you will be able to enter and edit your 

data. When you are done, simply close the window or the Excel worksheet. The chart will 

automatically update with your information.

If you select “Edit Data,” a pop-up window will appear: 

 

If you select “Edit Data in Excel”, an Excel worksheet will open:

When you are done entering your data, close the window. Your chart is now updated!

Enter your data numbers in the table. 

Enter your data numbers in the table. 
16

 

Appendix C

Identifying Your Data and Using the Calculations Worksheet
17

Identifying Your Data and Using the Calculations Worksheet For the “Number of Clients and Units Served by Client” chart in the Program Delivery and 

Participation section of the infographic, you will need to calculate the Number of Units Served 

by Client (rate) and total Clients Served for each of the following Title VI services: congregate 

meals, home-delivered meals, caregiver services, and supportive services. To do this, you will 

need to identify the total number of units of service and the unduplicated number of clients for 

each of the Title VI services and enter them into the Infographic Calculations Worksheet. This 

section walks you through where to find your data and how to use the Infographic 

Calculations Worksheet.

Congregate and Home Delivered Meals 

In the Title VI Program Performance Report (Title VI PPR), under the part A/B Report, find the 

data reported in section B. Nutrition Services in the tables for Congregate Meals and Home 

Delivered Meals (highlighted below).

Sample PPR Form 

 
18

To calculate the Clients Served and Units Served by Client for Congregate Meals and Home 

Delivered Meals: 

1. Open the Infographic Calculations Worksheet and select the “Program Delivery & 

Participation” tab. 

2. Using your PPR part A/B Report, B. Nutrition Services, enter the unduplicated number of 

persons and total number of units of services for congregate and home-delivered meals in 

the Number of Clients and Units Served by Client Bar Chart section of the Infographic 

Calculations Worksheet rows 21-25 (see screenshot below).

Sample Infographic Calculations Worksheet (Entering data) 

Notice that rows 64 to 67 automatically populate (see screenshot below). 

Sample Infographic Calculations Worksheet (Retrieving data)

3. Enter these values into the infographic following the instructions in Appendix B.
19

Supportive Services 

In the Title VI Program Performance Report, under the part A/B Report, find the data reported 

under section C. Supportive Services in the tables for Access Services, In-Home Services, and 

Other Supportive Services (highlighted below). Note that the “Total number of Social Events 

held” is not used in the infographic calculations.

Sample PPR Form

To calculate the Clients Served and Units Served by Client for Supportive Services: 

1. Open the Infographic Calculations Worksheet and select the “Program Delivery & 

Participation” tab. 

2. Identify your PPR part A/B Report, C. Supportive Services. Then enter the unduplicated 

number of persons and total number of units (hours, contacts, or visits) for Access Service, 

In-home services, and Other Supportive Services in the Number of Clients and Units Served 
20

by Client Bar Chart section of the Infographic Calculations Worksheet rows 27-42 (see 

screenshot below).

Sample Infographic Calculations Worksheet (Entering data)

Notice that rows 60 and 61 automatically populate (see screenshot below).

Sample Infographic Calculations Worksheet (Retrieving data) 

3. Enter these values into the infographic following the instructions in Appendix B.
21

Caregiver Services 

In the Title VI Program Performance Report, under the part C Report, find the data reported in 

table B. Total Caregivers Served and C. Caregiver Support Services: Services for Caregivers, 

Supplemental Services, and Respite Care for Caregivers (highlighted below). Note that the 

“Unduplicated number of caregivers receiving Counseling (e.g. formal and/or informal 

counselors)”, “Unduplicated number of caregivers served in Caregiver Training”, “Unduplicated 

number of caregivers of Elders provided Respite Care”, “Unduplicated number of caregivers of 

children under the age of 18 provided Respite Care”, and “Unduplicated number of caregivers 

of adults 18-59 years old with disabilities provided Respite Care” are not used for the 

Infographic calculations.

Sample PPR Form
22

 

To calculate the Clients Served and Units Served by Client for Caregiver Support Services: 

1. Open the Infographic Calculations Worksheet and select the “Program Delivery & 

Participation” tab. 

2. Identify your PPR part C Report, table B. Total Caregivers Served and C. Caregiver Support 

Services: Services for Caregivers, Supplemental Services, and Respite Care for Caregivers. 

Then enter the unduplicated number of persons and total number of units (activities, 

contacts, hours, or sessions hours) in the Number of Clients and Units Served by Client Bar 

Chart section of the Infographic Calculations Worksheet rows 44-59 (see screenshot 

below).

Sample Infographic Calculations Worksheet (Entering data)

Notice that rows 62 and 63 automatically populate (see screenshot below).

Sample Infographic Calculations Worksheet (Retrieving data)

3. Enter these values into the infographic following the instructions in Appendix B.