​​​​​⚠​ This is an archived version​ of our Community Check Box help documentation.

Please find our most up to date documentation at Community Check Box ​​​​Help.​

​​​​​​Indica​​tors

Indicators are objective, population-level measures that can b​e useful in understanding community trends and assessing the impact of collective community action on longer-term outcomes. Indicators provide broad markers to help assess the impact of your work on longer-term outcomes in your community.

Illustrative examples of Indicators:​

  • Perceived availability of alcohol by youth
  • Employment rates
  • Infant mortality rates
  • Voter turnout
  • Number of low birth-rate babies
  • Amount of youth participation
  • Violent crime levels

Indicators can be graphed on their own to determine changes in the measure over time, or they can be graphed together with Accomplishments to determine if there is a correlation between the level of Accomplishments and changes in the Indicator. Information from the Indicator database can also be exported into Microsoft Excel for further analysis.​


Indicator Overview

Each Indicator includes several fields for specific information about the Indicator. These fields include:

  • Category: ​The category names for your Indicators.
  • Indicator: The specific Indicator of interest (e.g., percent of Kansas 10th graders reporting "yes" to 30-day use of alcohol in 2018).
  • Data Source: The source of the data that you are entering (e.g., Dept. of Health and Human Services, U.S. Census, Behavioral Risk Factor Surveillance System, etc.).
  • Initiative: The specific initiative to which the Indicator is related.
  • Topic Area: The category that the Indicator relates to (for example, Health Behaviors, Substance Abuse Prevention, Preventive Care, etc.).
  • Description: This provides more detailed information about the Indicator and what it represents.
  • Gauges: You can enter the 
  • Geographic Level: This box allows you to select at what geographic level the Indicator is taking place – City, State, a specific Zip Code, County, or Census Tract. You can also choose to enter a specific address. Your project also has the option to add a custom geographic level, if the Indicator is not taking place in one of the specified options.

These fields will always be included in the Indicator, and individual projects also have the option of adding five additional fields that are customized to the information they would like to collect.

View Indicators

Your site owner should have already set up Indicators for you. If you don't see any Indicators or need to add a new one, please check with your site owner.

To view Indicators, click on Indicators in the left navigation bar. This will take you to the Indicators listing page. 

ccb2-indicator-nav-bar.png

To view the existing indicator data, click on the > to the left of the indicator you want to view. This will display all existing data f​or that indicator.

ccb2-indicator-view.png 
​ 
From this page you can add data or make edits to existing indicators, or filter to view​ just what you want.

  

Enter new indicator data​​​

  1. Click on Indicators in the left navigation bar. This will take you to the Indicators listing page. ​
  2. Click on the > to expand the category (e.g., Teen Age Pregnancy)

    ccb2-indicator-add-data1.png

  3. Click on the category (e.g., Estimated pregnancy rates for ages 15-17 yars)., and then click Edit/Add Data.

    ccb2018-indicator-edit.png

  4. Click the Add button at the bottom of the page.

    ccb2-indicator-add-button.png
  5. Enter the Start Date, Stop Date, Value, and Notes (if needed) for the current time period.
  6. Click Save.
  7. If you decide not to make any additions or changes to the Indicator, you can click Cancel to leave the Indicator entry without making any changes.​

Edit existing In​dicator data

Users will rarely need to edit Indicators. Indicators that have already been created should have all relevant information already filled in. But if you have checked with your project lead and you do need to change or update any Indicator information, please follow these instructions.

  1. Click on Indicators in the left navigation bar. This will take you to the Indicators listing page. 
  2. Scroll to the category you want to update, e.g., Teen Age Pregnancy. 

    ccb2018-indicator-viewpage2.png

  3. Click on the > to expand the category (e.g., Estimated pregnancy rates for ages 15-17 yars).​

    ccb2-indicator-edit3.png

  4. Click on an existing entry to edit.​
  5. Make the edit and click Save.​

​Filter Indicator View

You can select from the follow filters to choose what data you view.

​ccb2018-indictor-filter.png


Create Indicator Graph​​

  1. Go to Dashboard and Click Graphs button.
  2. Click on + New Graph at the top of the Graphs page
  3. ​Select the appropriate option from the Create new graph dropdown menus 
  4. Select Indicators from the What data type do you want to graph? dropdown menu. 
  5. Select options from the additional fields that display.

    ccb2018-graph-indicator-new.png

  6. ​ ​Click Create Graph..​
  7. Enter Date Range and change other options as needed.
  8. When you are done making changes on this page click:
    1. ​​Update Graph if you want to save and stay on this page.
    2. Save & Go to Graph if you want to save and go back to the graph.
    3. Return to Graph if you do not want to save changes.

ccb2018-graph-indicator-new4.png
​

​

Export Indicators

  1. Click on Indicators on the left navigation bar.
  2. If you want to export all Indicators, click Export.
  3. If you want to export specific entries.​
    1. Click Filter Indicators ​and select the filters you want,
    2. Click Apply Filter.
    3. Click Export.
ccb2018-indictor-filter.png 



​​Import New Indicator Data​​

  1. Note: You must create or add any needed Indicator Form dropdown choices first in the Administration section of your CCB.
  2. Either export existing indicator data to use as a blank template for the column headers, or create your own Excel doc with the following headers:

    ​​Category

    		 Data Source Indicator Name Description Topic Area Initiative Geographic Level County Start Date Stop Date Value Notes
    ​Testing​
    		Behavioral Risk Factor Surveillance System
    		Paul TESTTESTMental HealthRoadmapCountyDouglas1/1/201412/31/201429.00Youth
    ​Testing
    		Behavioral Risk Factor Surveillance SystemPaul TESTTESTAccess to healthy nutritionRoadmapCountyDouglas1/1/201312/31/201331.70 
    ​Testing
    		Behavioral Risk Factor Surveillance SystemPaul TESTTESTAccess to healthy nutritionRoadmapCountyDouglas1/1/201112/31/201131.70 
    ​Testing
    		Behavioral Risk Factor Surveillance SystemPaul TESTTESTAccess to healthy nutritionRoadmapCountyDouglas1/1/201212/31/201231.70 

  3. Any existing data from an old form (see above) should be deleted and replaced with your own data in the Excel doc.
  4. The name of your indicator (Indicator Name) should be whatever you wish to call this new Indicator, and it should remain consistent for each entry (see above "Paul TEST"). Most of the other data will be replicated in each entry as well, with the exception of the last four colums: Start Date, Stop Date, Value, and Notes. Those are different in each row/entry.
  5. All of the columns above are required for import, with the exception of "Geographic Level." If this colum is filled out, the corresponding/triggered column for either County, State, City, or Custom Location should be filled in as well (it is a required field).
  6. Even though these column headers are required for import, it is not necessary to include data in the "Notes" field. Make sure the header is there, however.
  7. Additional columns/data may be included if desired, but these above are required.
  8. Once you have your data with the headers in a saved Excel doc, it is ready for import.
  9. ​Click on the Import button in the top section:

    IndicatorImport1.jpg
    ​
  10. ​Choose the Excel file from your computer and ​upload it.
  11. ​​After that, you'll see the Form Field Mapping interface, where you will drag and drop the fields on the left into the matching columns on the far right:

    IndicatorImport2.jpg

  12. Once you've finished the mapping, click on Validate. If there are any errors, correct them. If not​, click on Upload File. You should see an "Import Successful" prompt after that.​