{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Indicator 9","Indicator 10","Discipline","Min Sample Sizes"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":57,"n_cols":4,"rows_kept":57,"cut":false,"hidden":false,"merged":[[8,0,8,14],[31,0,31,12],[32,0,32,12],[35,0,35,12],[36,0,36,12],[33,0,33,12],[34,0,34,12],[25,1,25,12],[26,1,26,12],[27,1,27,12],[20,1,20,12],[19,0,19,14],[21,1,21,12],[22,1,22,12],[23,1,23,12],[24,1,24,12],[41,0,41,12],[48,0,48,12],[49,0,49,12],[50,0,50,12],[39,0,39,12],[42,0,42,12],[43,0,43,12],[44,0,44,12],[40,0,40,12],[56,0,59,12],[51,0,51,12],[52,0,52,12],[53,0,53,12],[45,0,45,12]]}
[null,null,null,"Disproportionality: Procedural Compliance Self-Assessment"]
[null,null,null,"Sample Calculator Instructions"]
[]
[]
[]
["Instructions for generating a random sample and how to report Race/Ethnicity"]
[]
["Race/Ethnicity"]
["The combination of the answers given to the two-part question asked in WSLS and ISES (both parts are mandatory to answer) results in the Reporting Category that will be used for this Sampling Calculator and througout the Disproportionality: PCSA web application."]
["Part 1: Is this student Hispanic or Latino?"]
[null,"Hispanic or Latino"]
[null,"Not Hispanic or Latino"]
["Part 2: Select one or more of the following categories that apply to this student."]
[null,"American Indian or Alaskan Native"]
[null,"Asian"]
[null,"Black or African American"]
[null,"Native Hawaiian or Other Pacific Islander"]
[null,"White"]
[]
["The following table describes how the answers to the questions above correlate to the appropriate Reporting Category used in this Sampling Calculator and the Disproportionality: PCSA web application."]
["Reporting Category","Description / Comments"]
["American Indian or Alaska Native","Student is not Hispanic/Latino and identifies with exactly one race/ethnicity category, this category."]
["Asian","Student is not Hispanic/Latino and identifies with exactly one race/ethnicity category, this category."]
["Black or African American","Student is not Hispanic/Latino and identifies with exactly one race/ethnicity category, this category."]
["Hispanic or Latino","Student is Hispanic/Latino and identifies with one or more other race/ethnicity categories."]
["Native Hawaiian or Other Pacific Islander","Student is not Hispanic/Latino and identifies with exactly one race/ethnicity category, this category."]
["White","Student is not Hispanic/Latino and identifies with exactly one race/ethnicity category, this category."]
["Two or More Races","Student is not Hispanic/Latino and identifies with more than one other race/ethnicity categories."]
[]
[]
["Indicator 9"]
["1. Once you have calculated your sample size using the form on the Indicator 9 tab, save the spreadsheet. "]
["2. For each Race/Ethnicity listed where the Sample Size is greater than 0, create a list of students in that race/ethnicity. Number the students on each list consecutively beginning with 1."]
["3. Go to http://www.random.org/integer-sets. For each Race/Ethnicity, enter the following into the site under 'Step 1: The Sets': Generate 1 set(s) with [Sample Size] unique random integer(s) in each. Each integer should have a value between 1 and [SwD Count]."]
["4. Click 'Get Sets' under 'Step 3: Go!'. Save the results by printing the output, saving a PDF, or by copying the results into a new tab of this worksheet (if using the last method, save the spreadsheet after this step)."]
["5. For each Race/Ethnicity, use the list of randomly generated numbers to select the students for your Indicator 9 sample. For example if the numbers 5, 7, 10 and 15 are generated, you would select the 5th, 7th, 10th and 15th student in your list. "]
["6. Enter these students into the Disproportionality: PCSA web application, accessed through the Special Education Web Portal."]
[]
["Indicator 10"]
["1. Once you have calculated your sample size using the form on the Indicator 10 tab, save the spreadsheet. "]
["Complete the following steps for each disability with a Resulting Sample Size on the Indicator 10 tab."]
["2. For each Race/Ethnicity listed where the Resulting Sample Size is greater than 0, create a list of students in that race/ethnicity. Number the students on each list consecutively beginning with 1."]
["3. Go to http://www.random.org/integer-sets. For each Race/Ethnicity, enter the following into the site under 'Step 1: The Sets': Generate 1 set(s) with [Resulting Sample Size] unique random integer(s) in each. Each integer should have a value between 1 and [SwD Count]."]
["4. Click 'Get Sets' under 'Step 3: Go!'. Save the results by printing the output, saving a PDF, or copying the results into a new tab of this worksheet (if using the last method, save the spreadsheet after this step)."]
["5. For each Race/Ethnicity, use the list of randomly generated numbers to select the students for your Indicator 10 sample. For example if the numbers 5, 7, 10 and 15 are generated, you would select the 5th, 7th, 10th and 15th student in your list. "]
["6. Enter these students into the Disproportionality: PCSA web application, accessed through the Special Education Web Portal."]
[]
["Discipline"]
["1. Once you have calculated your sample size using the form on the Discipline tab, save the spreadsheet."]
["2. For each Race/Ethnicity listed where the Sample Size is greater than 0, create a list of students in that race/ethnicity. Number the students on each list consecutively beginning with 1."]
["3. Go to http://www.random.org/integer-sets. For each Race/Ethnicity, enter the following into the site under 'Step 1: The Sets': Generate 1 set(s) with [Sample Size] unique random integer(s) in each. Each integer should have a value between 1 and [Disciplined Count]."]
["4. Click 'Get Sets' under 'Step 3: Go!'. Save the results by printing the output, saving a PDF or by copying the results into a new tab of this worksheet (if using the last method, save the spreadsheet after this step)."]
["5. For each Race/Ethnicity, use the list of randomly generated numbers to select the students for your Discipline sample. For example if the numbers 5, 7, 10 and 15 are generated, you would select the 5th, 7th, 10th and 15th student in your list. "]
["6. Enter these students into the Disproportionality: PCSA web application, accessed through the Special Education Web Portal."]
[]
["Note:"]
["If you are not seeing worksheet tabs for each of the sampling calculators, you may have the ability to view sheet tabs disabled. Click the Microsoft Office button in the upper left corner of the Excel window, and then click Excel Options. In the Advanced category, under Display options for this workbook, look at the Show sheet tabs check box. Is it cleared? If so, select it, and then click OK."]

{"sheet":"Indicator 9","index":1,"n_rows":26,"n_cols":15,"rows_kept":26,"cut":false,"hidden":false,"merged":[[24,0,24,12],[25,0,25,12],[21,0,21,12],[3,0,4,12],[23,0,23,12],[20,0,20,12],[22,0,22,12],[7,11,8,11]]}
[null,null,null,"Disproportionality: Procedural Compliance Self-Assessment"]
[null,null,null,"Indicator 9 Sampling Calculator"]
[]
["Complete the table below ONLY if your LEA was identified as being disproportionately over-represented in one or more racial/ethnic groups in special education and related services.\n\nSwD Count\nStudents with Disabilities (including ages 6-21 and excluding parentally placed private students) with initial evaluations between July 1 of the previous year and June 30 of this year where the student was found eligible. The Race/Ethnicity of the students should be recorded as per the Reporting Category generated from the answers given to the two-part question asked in WSLS and ISES. The two-part question and resulting Reporting Category is included on the Instructions tab."]
[]
[]
["Race/Ethnicity","SwD Count","Racial/Ethnic Makeup","Sample Size",null,"Sample","Temp 1","Initial Diff","Final Diff",null,"Unrounded Value"]
["American Indian",null,{"$f":"IFERROR(B8/$B$15,\"\")","v":""},null,null,null,{"$f":"IF($F$15=$B$15,B8,ROUND($F$15*C8,0))","v":0},{"$f":"B8-G8","v":0},0,null,{"$f":"$F$15*C8","v":{"$error":"#VALUE!"}},"Legend","Enter Data"]
["Asian",null,{"$f":"IFERROR(B9/$B$15,\"\")","v":""},null,null,null,0,{"$f":"B9-G9","v":0},0,null,{"$f":"$F$15*C9","v":{"$error":"#VALUE!"}},null,"Calculated"]
["Black",null,"",null,null,null,0,0,0,null,{"$error":"#VALUE!"}]
["Hispanic",null,"",null,null,null,0,0,0,null,{"$error":"#VALUE!"}]
["Pacific Islander",null,"",null,null,null,0,0,0,null,{"$error":"#VALUE!"}]
["White",null,"",null,null,null,0,0,0,null,{"$error":"#VALUE!"}]
["Two or More races",null,"",null,null,null,0,0,0,null,{"$error":"#VALUE!"}]
["Total",{"$f":"IF(COUNTA(B8:B14)>0,SUM(B8:B14),\"\")","v":""},"",null,null,{"$f":"IF(SUMPRODUCT(('Min Sample Sizes'!A2:A30<=B15)*('Min Sample Sizes'!B2:B30>=B15)*('Min Sample Sizes'!C2:C30))=0,B15,SUMPRODUCT(('Min Sample Sizes'!A2:A30<=B15)*('Min Sample Sizes'!B2:B30>=B15)*('Min Sample Sizes'!C2:C30)))","v":""},{"$f":"SUM(G8:G14)","v":0}]
[]
[]
[]
[]
["Instructions for generating a random sample",null,null,null,null,null,null,null,null,null,null,null,null,null,"Example Entry into www.random.org/integer-sets"]
["1. Once you have calculated your sample size using this form, save this spreadsheet. "]
["2. For each Race/Ethnicity listed where the Sample Size is greater than 0, create a list of students in that race/ethnicity. Number the students on each list consecutively beginning with 1."]
["3. Go to http://www.random.org/integer-sets. For each Race/Ethnicity, enter the following into the site under 'Step 1: The Sets': Generate 1 set(s) with [Sample Size] unique random integer(s) in each. Each integer should have a value between 1 and [SwD Count]."]
["4. Click 'Get Sets' under 'Step 3: Go!'. Save the results by printing the output, saving a PDF, or by copying the results into a new tab of this worksheet (if using the last method, save the spreadsheet after this step)."]
["5. For each Race/Ethnicity, use the list of randomly generated numbers to select the students for your Indicator 9 sample. For example if the numbers 5, 7, 10 and 15 are generated, you would select the 5th, 7th, 10th and 15th student in your list. "]
["6. Enter these students into the Disproportionality: PCSA web application, accessed through the Special Education Web Portal."]

{"sheet":"Indicator 10","index":2,"n_rows":38,"n_cols":39,"rows_kept":38,"cut":false,"hidden":false,"merged":[[33,0,33,11],[34,0,34,11],[35,0,35,11],[3,0,3,8],[0,10,0,11],[1,10,1,11],[0,9,1,9],[32,0,32,11],[30,0,30,11],[29,0,29,11],[31,0,31,11]]}
[null,null,"Disproportionality: Procedural Compliance Self-Assessment",null,null,null,null,null,null,"Legend","Enter Data"]
[null,null,"Indicator 10 Sampling Calculator",null,null,null,null,null,null,null,"Calculated"]
[]
["Complete the table below ONLY for the specific disabilities that were identified as being disproportionately over-represented in one or more races/ethnicities. Do NOT complete the table for disabilities the LEA was NOT identified for. \n\nSwD Counts \nNumber of students with disabilities with initial evaluations between July 1 of the previous year and June 30 of this year where the student was found eligible - disaggregated by race/ethnicity. Include students ages 6-21 and exclude parentally placed private students. The Race/Ethnicity of the students should be recorded as per the Reporting Category generated from the answers given to the two-part question asked in WSLS and ISES. The two-part question and resulting Reporting Category is included on the Instructions tab."]
[]
[null,"SwD Counts",null,null,null,null,null,null,null,null,null,null,null,null,null,"A",null,null,null,"CD",null,null,null,"EBD",null,null,null,"LD",null,null,null,"OHI",null,null,null,"SL"]
["Race/Ethnicity","AUT","Racial/Ethnic Makeup","CD","Racial/Ethnic Makeup","EBD","Racial/Ethnic Makeup","LD","Racial/Ethnic Makeup","OHI","Racial/Ethnic Makeup","SL","Racial/Ethnic Makeup",null,null,"Sample","Temp 1","Initial Diff","Final Diff","Sample","Temp 1","Initial Diff","Final Diff","Sample","Temp 1","Initial Diff","Final Diff","Sample","Temp 1","Initial Diff","Final Diff","Sample","Temp 1","Initial Diff","Final Diff","Sample","Temp 1","Initial Diff","Final Diff"]
["American Indian",null,{"$f":"IFERROR(B8/$B$15, \"\")","v":""},null,{"$f":"IFERROR(D8/$D$15,\"\")","v":""},null,{"$f":"IFERROR(F8/$F$15,\"\")","v":""},null,{"$f":"IFERROR(H8/$H$15,\"\")","v":""},null,{"$f":"IFERROR(J8/$J$15,\"\")","v":""},null,{"$f":"IFERROR(L8/$L$15,\"\")","v":""},null,null,null,{"$f":"IF(B8=\"\",\"\",IF($P$15=$B$15,B8,ROUND($P$15*C8,0)))","v":""},{"$f":"B8-Q8","v":{"$error":"#VALUE!"}},2,null,{"$f":"IF($T$15=$D$15,D8,ROUND($T$15*E8,0))","v":{"$error":"#VALUE!"}},{"$f":"D8-U8","v":{"$error":"#VALUE!"}},0,null,{"$f":"IF($X$15=$F$15,F8,ROUND($X$15*G8,0))","v":{"$error":"#VALUE!"}},{"$f":"F8-Y8","v":{"$error":"#VALUE!"}},10,null,{"$f":"IF($AB$15=$H$15,H8,ROUND($AB$15*I8,0))","v":{"$error":"#VALUE!"}},{"$f":"H8-AC8","v":{"$error":"#VALUE!"}},16,null,{"$f":"IF($AF$15=$J$15,J8,ROUND($AF$15*K8,0))","v":{"$error":"#VALUE!"}},{"$f":"J8-AG8","v":{"$error":"#VALUE!"}},53,null,{"$f":"IF($AJ$15=$L$15,L8,ROUND($AJ$15*M8,0))","v":{"$error":"#VALUE!"}},{"$f":"L8-AK8","v":{"$error":"#VALUE!"}},96]
["Asian",null,{"$f":"IFERROR(B9/$B$15, \"\")","v":""},null,{"$f":"IFERROR(D9/$D$15,\"\")","v":""},null,{"$f":"IFERROR(F9/$F$15,\"\")","v":""},null,{"$f":"IFERROR(H9/$H$15,\"\")","v":""},null,{"$f":"IFERROR(J9/$J$15,\"\")","v":""},null,{"$f":"IFERROR(L9/$L$15,\"\")","v":""},null,null,null,"",{"$error":"#VALUE!"},298,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},2,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},4,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},21,null,{"$f":"IF($AJ$15=$L$15,L9,ROUND($AJ$15*M9,0))","v":{"$error":"#VALUE!"}},{"$f":"L9-AK9","v":{"$error":"#VALUE!"}},479]
["Black",null,"",null,"",null,"",null,"",null,"",null,"",null,null,null,"",{"$error":"#VALUE!"},199,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},36,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},62,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},32,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},384]
["Hispanic",null,"",null,"",null,"",null,"",null,"",null,"",null,null,null,"",{"$error":"#VALUE!"},100,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},8,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},17,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},11,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},96]
["Pacific Islander",null,"",null,"",null,"",null,"",null,"",null,"",null,null,null,"",{"$error":"#VALUE!"},9,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},1,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},63,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},21]
["White",null,"",null,"",null,"",null,"",null,"",null,"",null,null,null,"",{"$error":"#VALUE!"},10,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},199,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},357,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},42,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},3]
["Two or More races",null,"",null,"",null,"",null,"",null,"",null,"",null,null,null,"",{"$error":"#VALUE!"},5,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},19,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},33,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},73,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},1]
["Total",{"$f":"IF(COUNTA(B8:B14)>0,SUM(B8:B14),\"\")","v":""},"",{"$f":"IF(COUNTA(D8:D14)>0,SUM(D8:D14),\"\")","v":""},"",{"$f":"IF(COUNTA(F8:F14)>0,SUM(F8:F14),\"\")","v":""},"",{"$f":"IF(COUNTA(H8:H14)>0,SUM(H8:H14),\"\")","v":""},"",{"$f":"IF(COUNTA(J8:J14)>0,SUM(J8:J14),\"\")","v":""},"",{"$f":"IF(COUNTA(L8:L14)>0,SUM(L8:L14),\"\")","v":""},"",null,null,{"$f":"S19","v":0},{"$f":"SUM(Q8:Q14)","v":0},null,null,{"$f":"S20","v":0},{"$f":"SUM(U8:U14)","v":{"$error":"#VALUE!"}},null,null,{"$f":"S21","v":0},{"$f":"SUM(Y8:Y14)","v":{"$error":"#VALUE!"}},null,null,{"$f":"S22","v":0},{"$f":"SUM(AC8:AC14)","v":{"$error":"#VALUE!"}},null,null,{"$f":"S23","v":0},{"$f":"SUM(AG8:AG14)","v":{"$error":"#VALUE!"}},null,null,{"$f":"S24","v":0},{"$f":"SUM(AK8:AK14)","v":{"$error":"#VALUE!"}}]
[]
[]
[null,"Resulting Sample Size",null,null,null,null,null,null,null,null,null,null,null,null,null,"Disability","Breakdown","Total Sample","Final Sum","Initial Diff","Final Diff"]
["Race/Ethnicity","AUT","CD","EBD","LD","OHI","SL",null,null,null,null,null,null,null,null,"A",{"$f":"IFERROR(B15/$Q$26,\"\")","v":""},null,0,{"$f":"IFERROR(B$15-S19,0)","v":0},0]
["American Indian",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CD",{"$f":"IFERROR(D15/$Q$26,\"\")","v":""},null,0,{"$f":"IFERROR(D$15-S20,0)","v":0},0]
["Asian",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EBD",{"$f":"IFERROR(F15/$Q$26,\"\")","v":""},null,0,{"$f":"IFERROR(F$15-S21,0)","v":0},0]
["Black",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LD",{"$f":"IFERROR(H15/$Q$26,\"\")","v":""},null,0,{"$f":"IFERROR(H$15-S22,0)","v":0},0]
["Hispanic",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OHI",{"$f":"IFERROR(J15/$Q$26,\"\")","v":""},null,0,{"$f":"IFERROR(J$15-S23,0)","v":0},0]
["Pacific Islander",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SL",{"$f":"IFERROR(L15/$Q$26,\"\")","v":""},null,0,{"$f":"IFERROR(L$15-S24,0)","v":0},0]
["White"]
["Two or More races",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B15,D15,F15,H15,J15,L15)","v":0},{"$f":"IF(SUMPRODUCT(('Min Sample Sizes'!$A$2:$A$30<=Q26)*('Min Sample Sizes'!$B$2:$B$30>=Q26)*('Min Sample Sizes'!$C$2:$C$30))=0,Q26,SUMPRODUCT(('Min Sample Sizes'!$A$2:$A$30<=Q26)*('Min Sample Sizes'!$B$2:$B$30>=Q26)*('Min Sample Sizes'!$C$2:$C$30)))","v":0},{"$f":"SUM(S19:S24)","v":0}]
["Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Init Act Sum"]
["Instructions for generating a random sample",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A",{"$f":"IFERROR(ROUND($R$26*Q19,0),0)","v":0}]
["1. Once you have calculated your sample size using this form, save this spreadsheet. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CD",0]
["Complete the following steps for each disability with a Resulting Sample Size.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EBD",0]
["2. For each Race/Ethnicity listed where the Resulting Sample Size is greater than 0, create a list of students in that race/ethnicity. Number the students on each list consecutively beginning with 1.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LD",0]
["3. Go to http://www.random.org/integer-sets. For each Race/Ethnicity, enter the following into the site under 'Step 1: The Sets': Generate 1 set(s) with [Resulting Sample Size] unique random integer(s) in each. Each integer should have a value between 1 and [SwD Count].",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OHI",0]
["4. Click 'Get Sets' under 'Step 3: Go!'. Save the results by printing the output, saving a PDF, or copying the results into a new tab of this worksheet (if using the last method, save the spreadsheet after this step).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SL",0]
["5. For each Race/Ethnicity, use the list of randomly generated numbers to select the students for your Indicator 10 sample. For example if the numbers 5, 7, 10 and 15 are generated, you would select the 5th, 7th, 10th and 15th student in your list. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sum",{"$f":"SUM(S29:S34)","v":0}]
["6. Enter these students into the Disproportionality: PCSA web application, accessed through the Special Education Web Portal."]
[]
["Example Entry into www.random.org/integer-sets"]

{"sheet":"Discipline","index":3,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":false,"merged":[[5,8,6,8],[3,0,3,11],[35,0,35,12],[30,0,30,12],[31,0,31,12],[32,0,32,12],[33,0,33,12],[34,0,34,12]]}
[null,null,null,"Disproportionality: Procedural Compliance Self-Assessment"]
[null,null,null,"Discipline Sampling Calculator"]
[]
["Complete both tables below ONLY if your LEA was identified as having a significant discrepancy in discipline by race (Indicator 4B) or signficant disproportionality in the area of discipline.\n\nTotal Students with Disabilities at year end\nAll students with disabilities (including ages 3-21 and excluding parentally placed private students) at the end of the previous school year (as per the Individual Student Enrollment System (ISES) Year End records).\n\nDisciplined Students with Disabilities\nAll students with disabilities (including ages 3-21 and excluding parentally placed private students) that were suspended or expelled at least once during the previous school year. For specific instructions on what kinds of suspensions and expulsions to include, please see the Disproportionality: PCSA Guide located here: http://sped.dpi.wi.gov/files/sped/pdf/sa-dispro-guide.pdf\n\nRace/Ethnicity\nThe Race/Ethnicity of the students should be as recorded per the Reporting Category generated from the answers given to the two-part question asked in WSLS and ISES. The two-part question and resulting Reporting Category is included on the Instructions tab.\n\nTotal Students with Disabilities at year end"]
["Race/Ethnicity","SwD Count","Racial/Ethnic Makeup"]
["American Indian",null,{"$f":"IFERROR(B6/$B$13,\"\")","v":""},null,null,null,null,null,"Legend","Enter Data"]
["Asian",null,{"$f":"IFERROR(B7/$B$13,\"\")","v":""},null,null,null,null,null,null,"Calculated"]
["Black",null,""]
["Hispanic",null,""]
["Pacific Islander",null,""]
["White",null,""]
["Two or More races",null,""]
["Total",{"$f":"IF(COUNTA(B6:B12)>0,SUM(B6:B12),\"\")","v":""},""]
[]
["Disciplined Students with Disabilities"]
["Race/Ethnicity","Disciplined Count","Sample Size",null,"Temp1","Temp2","Initial Diff","Final Diff"]
["American Indian",null,null,null,{"$f":"IF($E$24=$B$24,B17,ROUND($E$24*C6,0))","v":0},{"$f":"IF(E17>B17,B17,E17)","v":0},{"$f":"B17-F17","v":0},0]
["Asian",null,null,null,{"$f":"IF($E$24=$B$24,B18,ROUND($E$24*C7,0))","v":0},{"$f":"IF(E18>B18,B18,E18)","v":0},{"$f":"B18-F18","v":0},0]
["Black",null,null,null,0,0,0,0]
["Hispanic",null,null,null,0,0,0,0]
["Pacific Islander",null,null,null,0,0,0,0]
["White",null,null,null,0,0,{"$f":"B22-F22","v":0},0]
["Two or More races",null,null,null,0,0,{"$f":"B23-F23","v":0},0]
["Total",{"$f":"IF(COUNTA(B17:B23)>0,SUM(B17:B23),\"\")","v":""},null,null,{"$f":"IF(SUMPRODUCT(('Min Sample Sizes'!A2:A30<=B24)*('Min Sample Sizes'!B2:B30>=B24)*('Min Sample Sizes'!C2:C30))=0,B24,SUMPRODUCT(('Min Sample Sizes'!A2:A30<=B24)*('Min Sample Sizes'!B2:B30>=B24)*('Min Sample Sizes'!C2:C30)))","v":""},{"$f":"SUM(F17:F23)","v":0}]
[]
[]
[]
[]
[]
["Instructions for generating a random sample"]
["1. Once you have calculated your sample size using this form, save this spreadsheet."]
["2. For each Race/Ethnicity listed where the Sample Size is greater than 0, create a list of students in that race/ethnicity. Number the students on each list consecutively beginning with 1."]
["3. Go to http://www.random.org/integer-sets. For each Race/Ethnicity, enter the following into the site under 'Step 1: The Sets': Generate 1 set(s) with [Sample Size] unique random integer(s) in each. Each integer should have a value between 1 and [Disciplined Count]."]
["4. Click 'Get Sets' under 'Step 3: Go!'. Save the results by printing the output, saving a PDF or by copying the results into a new tab of this worksheet (if using the last method, save the spreadsheet after this step)."]
["5. For each Race/Ethnicity, use the list of randomly generated numbers to select the students for your Discipline sample. For example if the numbers 5, 7, 10 and 15 are generated, you would select the 5th, 7th, 10th and 15th student in your list. "]
["6. Enter these students into the Disproportionality: PCSA web application, accessed through the Special Education Web Portal."]
[]
["Example Entry into www.random.org/integer-sets"]

{"sheet":"Min Sample Sizes","index":4,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
["Population Minimum","Population Maximum","Minimum \nSample Size"]
[1,10,0,"(All)"]
[11,15,10]
[16,20,12]
[21,25,14]
[26,30,15]
[31,35,16]
[36,40,17]
[41,45,18]
[46,50,19]
[51,60,20]
[61,70,21]
[71,85,22]
[86,100,23]
[101,120,24]
[121,160,25]
[161,210,26]
[211,300,27]
[301,320,35]
[321,360,43]
[361,420,51]
[421,480,59]
[481,550,60]
[551,650,61]
[651,800,62]
[801,1000,63]
[1001,1300,64]
[1301,2000,65]
[2001,3000,66]
[3001,99999,67]