Docstoc

NACCRRAware Notes _14 Percentage of Records Updated In Past Year

Document Sample
NACCRRAware Notes _14 Percentage of Records Updated In Past Year Powered By Docstoc
					                                  NACCRRAware Notes #14
 Report on Percentage of Records Updated In Past Year
NQA Criteria 5.A.4.a & 2.A.1.d

Select Provider Reports, Frequency Count




Choose Full Update Date
(If you don’t have this field in your database, please call the CCR&R Network for assistance.)




                                                                                        Continued
                                                                          NACCRRAware Notes #14
                                               Report on Percentage of Records Updated In Past Year
                                                                                        Page 2 of 3
When the report comes up, choose Edit>Select All, then Edit>Copy




Open an Excel spreadsheet, choose Edit>Paste, and adjust column widths as needed.

Frequency
Count
Results
Full Update Date
Total Records: 749
Total Records with Responses: 707

                       % of     % of
Value       Count      Records Responses
 10/24/2006     1          0.13      0.14
  11/7/2006     1          0.13      0.14
  4/10/2007     1          0.13      0.14
  10/2/2007     1          0.13      0.14
  11/2/2007     1          0.13      0.14
 11/19/2007     2          0.27      0.28
 12/13/2007     1          0.13      0.14
 12/14/2007     2          0.27      0.28
   1/7/2008     1          0.13      0.14
   1/9/2008     1          0.13      0.14
  1/14/2008     1          0.13      0.14
  1/24/2008     1          0.13      0.14
  4/15/2008     7          0.93      0.99
  4/16/2008     2          0.27      0.28
  4/21/2008     1          0.13      0.14
   5/7/2008     1          0.13      0.14
   5/9/2008     1          0.13      0.14
                                                                                         Continued
                                                                             NACCRRAware Notes #14
                                                  Report on Percentage of Records Updated In Past Year
                                                                                           Page 3 of 3

Insert a new row just above the date that is closest to one year ago today. Sum the “Count”
column to find out how many records have NOT been updated in the past year.

      8/25/2008        1      0.13         0.14
      8/27/2008        1      0.13         0.14
      8/28/2008        1      0.13         0.14
       9/3/2008        2      0.27         0.28
       9/4/2008        1      0.13         0.14
       9/8/2008        2      0.27         0.28
       9/9/2008        1      0.13         0.14
      9/18/2008        1      0.13         0.14
                     105
      9/22/2008        1      0.13         0.14
      9/24/2008       12       1.6          1.7
      9/30/2008        1      0.13         0.14
      10/8/2008        1      0.13         0.14
     10/16/2008        1      0.13         0.14
     10/24/2008        2      0.27         0.28

Sum the “Count” column from the bottom of the list up to the previous total row.
     9/11/2009        4     0.53         0.57
     9/14/2009        4     0.53         0.57
     9/16/2009        6      0.8         0.85
     9/17/2009        2     0.27         0.28
     9/18/2009        2     0.27         0.28
     9/23/2009        4     0.53         0.57
     7/22/2209        1     0.13         0.14
                    602


Using the “Total Records” number from the NACCRRAware report (listed at the top of the table),
perform a percentage calculation as follows:

602 records Updated in the past year divided by 749 Total Records = % Records Updated
(Format the result as a percentage.)

In this example, 80% of the records were updated in the past year.

You will need to submit the entire Excel Spreadsheet as evidence.




                                                                 By Laura Giddings - Updated Oct 2009
                                           The Washington State Child Care Resource & Referral Network

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:2/20/2012
language:
pages:3