Team-level Excel Database (updated 2011) | USAID Health Care Improvement Portal
Follow Us HCI Project on FacebookHCI Project on Vimeo
Why Register?     Register      Login

Team-level Excel Database (updated 2011)

Author(s): 
Simon Hiltebeitel
Organization: USAID Health Care Improvement Project/URC
Year: 
2009
Language: 
English
Description: 

A key component to both the site-level Documentation Journal and Synthesis form is the annotated graph showing the relationship between changes and results. Both the Documentation Journal  and Synthesis forms include a hard copy template in which data can be graphed, and the graph annotated. However, if QI teams and collaborative managers have access to a computer, electronic versions of these graphs can be used.  This Excel database has been created by HCI for use at the site level. It provides a mechanism for data entry of monthly or weekly collaborative indicator data, with automatic calculation of percentages and automatic creation of time series charts with appropriate labeling and documentation. This database also includes several features to reduce data entry error.

This database is for a single facility. Different versions of the database are available for monthly or weekly data. Also available is a version of the database that can aggregate data for multiple facilities.

Note: this file requires Excel 2007 or newer. Click here for excel tips for run charts.