Advancing Excellence logo

Consistent Assignment

Now that you know what you want to improve, it’s important to identify your starting point or baseline. Download the data tracking tool and collect data for a month or so to determine your starting point.

Consistent Assignment Tracking Tool
MS Excel Track the number of caregivers each resident has for the month and calculate the percent of residents meeting your target number.
AE_ConsistentAssignmentTRACKINGTOOL_v2.3_2 4-13.xls
Adobe PDF Illustrated instructions for using the AE_ConsistentAssignmentTrackingTool.
AE_ConsistentAssignmentTrackingToolINSTRUCTIONS_10 23-12.pdf
MS Excel Do you want to track neighborhoods separately, or do you have more than 150 residents? This tool is for you! Complete the TrackingTool (above) for each group, then use this tool to automatically summarize your results.
AE_ConsistentAssignmentCONSOLIDATIONTOOL_V1.0_11 14-12.xls
MS Excel Prefer the original format? The original version, which tracks residents and their caregivers by week and by shift is back! Either tool may be successfully used to create the calculations for website entry.  The Common Qs & As will familiarize you with differences between the tools.  
AE_ConsistentAssignmentTRACKINGTOOL_ByShift.xls