Tip:
Highlight text to annotate it
X
Hi, I’m *** Zeller from CADRE. I want to share with you the latest version of our Table
7 dispute resolution Data Drill Tool. The version I will demonstrate is set up for use
with the 2010-2011 data, but since nothing has changed in the reporting requirements
from last year to this year you can also use it to examine your 2009-10 data. We hope you
find this tool useful in preparing your February 2012 APR submission. You can get a copy of
this report on the CADRE website by going to www.diretionservice.org/CADRE/datasubmission.cfm
or by entering “Data Drill” in the text search on our website. Well let’s look at
the tool. Ok, I am going to open the data drill tool in Excel, and that’s how you
should do it. You should download it, save it to your computer in some convenient location
and then open it within the Excel software. If you open it and try to operate directly
within a browser all the functions won’t work. You may see this warning -- security
warning, macros have been disabled, help protect me from unknown content -- just click “Ok”.
There is nothing in here that involves macros or presents any problems for you. The first
page you see is the instructions tab. Please note that there is a request for feedback
once you have had a chance to use the tool. Note also that this tool is not for reporting
your 618 data to the Data Accountability Center, although the rules we have used to guide accuracy
in the numbers are the same as those used by the DAC. So click on any of the four data
entry tabs at the bottom, in this case Section A. Written Complaints. If you’re familiar
with Table 7 you will notice immediately that Section A. Written Complaints, this portion
of it, is the same as what appears on Table 7. Enter you data here. For example I’ll
make up some data, 86 complaints filed and as soon as I hit return you’ll notice that
three other red cells light up. The relationship among these cells is described down here in
the first part of the notes, calculations and error checks part of the spreadsheet.
In this case, Complaints filed, cell 1, must be equal to the sum of cells 1.1 Complaints
with reports issued, 1.2 Complaints pending, and 1.3 Complaints withdrawn or dismissed.
I’ll throw in some possible numbers here: 54 Complaints filed, 4 Pending, 28 withdrawn
or dismissed. And you’ll see the red disappears, meaning that these numbers do not violate
the definitions provided in the Table 7 instructions. If you want to review any of the instructions
and cell definitions click on any cell to the left that is in Column B and you will
go to an instructions tab. So, for example reports with findings of non-compliance. They’re
defined here as the written decision of the SEA in response to a complaint which finds
the public agency out of compliance with one or more requirements of Part B. Click on “return
to complaints” and you’re back to the data entry sheet. I’ll complete some other
numbers here quickly: 47 reports with non compliance, 49 within 60 days, 5 with an extension,
and 1 pending a due process hearing. So now the data are complete. Once you’ve filled
in the data on any of the data entry spreadsheets you can scroll down and see ways to compare
your state to other states. So how do you compare to the national average on this indicator
and other intermediate indicators from Table 7. Well, on Indicator 16 the state got a 100%,
the national average is 98.4%, complaint investigations that resulted in a completed investigation
report 63% a little below national average of 68%, but findings of non-compliance 87%
and nationally about 70%. So you can think of these as just additional information for
you to consider as you think about planning for your changes in your system. Below that
are some suggested breakdowns for examining other written complaints data. For example,
do written complaint reports also address issues raised in due process complaints? If
so, and to what extent? There are three numbers to enter here and they have to total the total
number of complaint reports issued. So this is a breakdown of complaint reports issued.
So how many of them were included in a decision from a hearing officer? Say, essentially you
have to wait for the hearing officer to finish the complaint report. We’ll say six. Say
sixteen of these maybe have some findings but not all from a hearing officer. Seems
like a fairly high number and that would leave me with some number, I’ll put in 34 here.
Notice that that cell above stays red until I get a number here that allows these three
cells to equal 100%. Ok, so this is the total number of reports issued and seeing a fairly
high number of reports in this case that involved complaints where decisions were made by the
hearing officer. To what extent do written complaints address enforcement of prior complaint
corrective actions? Again you can enter numbers here. These are breakdowns of complaints as
they are filed - in this case you may end up with more or less than 100% depending on
the kind of data you have for this part - complaints withdrawn and reasons for withdrawal
or dismiss. So each of these data entry spreadsheets, I’ll go to mediation, I already entered
numbers here, mediation has similar kinds of comparison for it as does complaints and
expedited due process hearings. A tab called Indicator Values summarizes a lot of this
information giving you the four indicator values based on the data you entered and then
potential performance measures of your system. Again, these are like sub-indicators, based
on the data in Table 7. A page or two like this might be of interest to a planning group
if you’re thinking about the operation of your system. Finally, there’s a tab on issues
analysis and this hasn’t got anything in it at the moment. This is for you to use if
you find value in this. Let’s start looking at the reasons people file complaints or due
process complaints or go to mediation, who files, whether it’s the same people filing,
disability of the student in filings, how old the students are, and so on. So these
issue analyses are things that you would use for you own purposes and planning, not to
report to us or to OSEP necessarily, but for your purposes in thinking about how to improve
your system. There is a Table 7 copy in here. Once you have entered the data correctly on
the data entry spreadsheets it’s all transferred to this table. You can print this table and
submit it as part of your APR. That’s optional. Again, if you have a chance to use this we’d
appreciate feedback. Just click this on the spreadsheet and it’ll take you directly
to the Data Drill Tool Evaluation. Appreciate your feedback very much and hope this is of
value to you.