FP - CT PITT Template (Reinforcing Protection of the Kenya Border shared with Somalia).xlsx
XLSX spreadsheet 27 KB Posted
- Opportunity number
- DFOP0018074
About this file
This file is a Performance Indicator Tracking Table (PITT) template and instructions for implementing organizations to monitor and report progress on counterterrorism capacity-building projects funded by the U.S. Department of State's Bureau of Counterterrorism. The PITT is a required reporting tool that documents all indicator data and tracks progress over time, enabling implementers and CT to identify gaps, trends, and inconsistencies. Organizations must populate the template using their project's Performance Monitoring Plan (PMP), incorporating both output-level indicators (minimum two per outcome) and outcome-level indicators (minimum one per outcome), with at least three relevant CT indicators required across the project. The template requires organizations to establish initial baselines, set quarterly and final targets, report actual quarterly and final results, calculate percentage progress to completion, and provide comments explaining variances and any data limitations.
The instructions specify that PITTs must be updated quarterly with the latest indicator data and submitted as stand-alone spreadsheets or annexes within quarterly performance reports. For projects exceeding one year, additional columns must be added for quarterly targets and actuals. Organizations should disaggregate data by relevant categories such as geography or sex to create additional units of analysis. The template includes fields for Award/Agreement Number, Implementing Organization, Period of Performance dates, and project year/quarter information. Data review and analysis must occur quarterly during implementation, with notable successes or challenges documented in quarterly report narratives. This template applies specifically to the 15-month Kenya border security cooperative agreement focused on advancing counterterrorism capabilities within Kenya's Administrative Police Services tasked with securing the Somalia border.
PITT
View the file
Other files
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Instructions
| PITT Instructions |
| Working from a CT project's Performance Monitoring Plan (PMP), implementers should incorporate all indicator data into a performance indicator tracking table (PITT) using the template under the next tab as a model. The PITT documents every indicator's data and tracks its progress over time. This allows for implementers and CT to easily identify gaps, trends, and inconsistencies. When submitting quarterly and final reports, PITTs must be updated with the latest indicator data ("actuals" columns) and submitted as stand-alone spreadsheets or as annexes within the quarterly performance report itself. Implementers should draw from relevant PMP fields (e.g., indicators, indicator type, disaggregations, baselines, targets, etc.) to populate their PITTs. For projects lasting longer than one year, additional columns should be added to the template for quarterly targets and actuals. During project implementation, indicator data should be reviewed and analyzed on a quarterly basis to determine the extent of the project's progress over its period of performance. Notable successes or challenges deriving from the data should be noted in the quarterly report narratives. |
| 1. Copy the Outcomes from the PMP to your PITT in Column B. Add rows as needed to accomodate additional outcomes that reflect your project's parameters. |
| 2. Indicator: Add indicators in Column B under their relevant outcomes. In line with PMP requirements, the PITT must include both output-level indicators (at least two per outcome) and outcome-level indicators (at least one per outcome). These can be drawn from the list of provided CT indicators (see Annex II in PMP Indicators "How To" Guide), and recipients are reminded to use at least three relevant CT indicators. Recipients may also develop/use customized indicators as needed. |
| 2a. Disaggregation: Add any disaggregates of an indicator in separate rows below the indicator. Disaggregation involves additional sub-dividing of data to create additional units of analysis such as geography or sex for a specific indicator. |
| 3. Initial Baseline: Add an initial baseline number in Column C. Baselines are data that are collected before or at the start of a project and provide a basis for planning and/or assessing subsequent progress and impact. For new projects, baselines are usually "zero." The baselines for ongoing projects that have been implemented for some time (e.g., through cost amendments, etc.) should include previous project figures (the number of individuals previously trained or supported). If a project conducts a baseline study, then the PITT must be updated with those figures once the study is completed. |
| 4. Target: In the "Target" columns, add the expected target value for each indicator for each quarter (and for the entire project). Targets are the value of what we expect to achieve for each indicator for each quarter and for the entire project (under "Final Target"). They should be ambitious but achievable. For indicators with disaggregations, include disaggregated targets as well, such as targets specifically for males and females. Use the PMP's Final Target value to establish your quarterly and overall project targets. |
| 5. Actual: The quarterly “Actual” columns are used to report the most recent data available for each indicator. This figure must be updated on a quarterly basis. In the "Final Actual" column, tabulate data from each quarter to determine the total actual for each indicator. |
| 6.Progress to Completion: In this column, "progress to completion" indicates the % progress against an indicator's total target. The percentage formula is as follows: final actual/final target*100=% progress to completion. |
| 7. Comments: Add a brief description in the comments cell for each indicator as needed. If indicators are significantly lower or higher than the target, explain why. If there are any data limitations/challenges for specific indicators, please provide a brief explanation (e.g., self-reporting bias, obtaining follow-up, determining demographic information from administrative files, etc.). Please also include an explanation if data is missing, and mark these cells "N/A". Outlining such limitations and challenges helps to understand/explain the feasibility of collecting and measuring data and controlling for data quality. |
PITT
Project Information Award (Grant or CoAg only) or Agreement Number (IAA only): <Number> Implementing Organization: <Organization Name>
| Period of Performance (POP): MM/DD/YYYY - MM/DD/YYYY | Project Year 1 | ||||
| [Add project years and quarters as needed] | Project Cumulative | ||||
| Qtr. 1 | |||||
| (Oct - Dec YYYY) | Qtr. 2 | ||||
| (Jan - Mar YYYY) | Qtr. 3 | ||||
| (Apr - Jun YYYY) | Qtr. 4 |
(Jul - Sep YYYY)
| Indicator | |||||||||||||
| [Add disaggregrations if needed and type of indicator - output or outcome] | Initial Baseline (PoP Start) | Final Target (PoP End) | Target | Actual | Target | Actual | Target | Actual | Target | Actual | Final Actual | % Progress to Completion | |
| (actual/target) | Comments | ||||||||||||
| OUTCOME 1 [Insert outcome statement from your PMP] | |||||||||||||
| Indicator 1.1: [Insert indicator title & (Output or OUTCOME)] | ERROR:#DIV/0! | ||||||||||||
| Disaggregation [if needed] | |||||||||||||
| Indicator 1.2: [Insert indicator title & (Output or OUTCOME)] | ERROR:#DIV/0! | ||||||||||||
| Disaggregation [if needed] | |||||||||||||
| Indicator 1.3: [Insert indicator title & (Output or OUTCOME)] | ERROR:#DIV/0! | ||||||||||||
| Disaggregation [if needed] | |||||||||||||
| [Add rows for additional indicators as needed] | ERROR:#DIV/0! | ||||||||||||
| OUTCOME 2 [Insert outcome statement from your PMP] | |||||||||||||
| Indicator 2.1: [Insert indicator title & (Output or OUTCOME)] | ERROR:#DIV/0! | ||||||||||||
| Disaggregation [if needed] | |||||||||||||
| Indicator 2.2: [Insert indicator title & (Output or OUTCOME)] | ERROR:#DIV/0! | ||||||||||||
| Disaggregation [if needed] | |||||||||||||
| Indicator 2.3: [Insert indicator title & (Output or OUTCOME)] | ERROR:#DIV/0! | ||||||||||||
| Disaggregation [if needed] | |||||||||||||
| [Add rows for additional indicators as needed] | ERROR:#DIV/0! |
File details come from the government source that posted it. Updated .