Data sources are a critical piece for reporting Indicators data. It is important to have the right tools to assist you with this task. The diagram below relates data sources or tools with data measured or tracked.
These data sources and tools may be in the form of either paper or electronic documents/systems.
The Rocky Mountain Center (RMC) and CDC developed several log sheets and registration templates in Microsoft© Word to assist DASH grantees with data collection and tracking. These templates are aligned to the Indicators and can be downloaded.
Grantees are free to modify these templates as they wish or create their own documents to meet their needs. The following templates are available and come in LEA Asthma Management, LEA-HIV, SEA-HIV (used for TEAs and TGs), and CSHP versions:
- Professional development/training event registration forms
- Information session/presentation forms
- Distribution/TA log sheets
In addition to the paper-based tools mentioned above, you can use electronic methods, such as databases, spreadsheets, and online registration forms, for recording and tracking Indicator data.
Database programs are more complicated to use, but they are also powerful for data aggregation and generating reports. Setting up a database system requires someone skilled in their use and function. If you have someone on staff that can do that, great! The following are examples of commercial database programs you might want to consider:
- Microsoft© Access
- Microsoft© FoxPro
- FileMaker© Pro
Training Tracker is a custom-designed database program (built with Microsoft© Access) available to grantees, free of charge. This program was developed to assist DASH-funded partners with recording and tracking information regarding the professional development (PD) events that they implement. RMC offers support documents and free training and TA on the use of Training Tracker. See below for more information.
Whatever tools you use or develop to track the Indicators, there must be a place to record all the information asked for within the Indicators for School Health Programs questionnaire.
For example: Not only do you need to track the number of participants at events, you need to track the number of schools, districts, regional support units, and external agency partners reached through PD events, distribution of materials, and TA. There needs to be a place within your tools to record this information.
|12 of 19|