430 likes | 443 Views
This tool simplifies the process of lifting assessment data from Section 618 Table 6 reports for APR Indicator 3. It allows for easy creation of participation and performance tables.
E N D
Assessment Data From: 618: Table 6 To: APR Indicator 3 NCEO Indicator 3 Tool To be used for lifting assessment data from Section 618: Table 6 reports Altman, J. R., Bremer, C., Vang, M., Thurlow, M., & Rogers, C. (2008)
APR and Table 6 of 618 – Trail of History APR 03-04 (looks a lot like Table 6) SPP 04-05 (new format) SEPARATE 04-05 Table 6 APR 05-06 through 07-08 Table 6 attached! X
Table 6: What is it? • Table 6 is included in the section 618 report • Table 6 must be submitted w/ APR in February • It looks something like this (broken up into worksheets in excel):
Annual Performance Report: Indicator 3 • The entire APR Indicator 3 participation table can be created using 618: Table 6 Data!!!! • In the example to come Table 6 location is listed in the following format: • (Column) : (Grade)
Annual Performance Report: Indicator 3 618: Column 1 Grade 3 618: Column 8 Grade 4
Indicator 3 Child Count Data 618: Table 6 Test Data
Indicator 3 Regular Assessment Data 618: Table 6 IEPs in regular assessment with no accommodations equal to BLUE minus GREEN
Indicator 3 Regular Assessment Data 618: Table 6
Indicator 3 Alternate Assessment Data 618: Table 6
Indicator 3 618: Table 6
Indicator 3 Alternate Assessment Data 618: Table 6
Indicator 3 Alternate Assessment Data 618: Table 6
Indicator 3 618: Table 6
Indicator 3 Alternate Assessment Data 618: Table 6
Indicator 3 Overall Calculations Overall equal to Blue + Green + Red + Yellow + Violet
Indicator 3 Overall Calculations Overall % equal to Blue divided by Green and then multiplied by 100
Indicator 3 Non-Participant Data 618: Table 6
Indicator 3 Non-Participant Data 618: Table 6
Indicator 3 Non-Participant Data 618: Table 6 618: Table 6
Indicator 3 Non-Participant Data 618: Table 6
Annual Performance Report: Indicator 3 Overall Row Total equal to Blue + Green + Red + Yellow + Violet + Orange + Pink (same is true for all cells in this COLUMN)
Annual Performance Report: Indicator 3 Overall % equal to Blue divided by Green and then multiplied by 100 (same is true for all cells in this COLUMN)
Annual Performance Report: Indicator 3 • Most of the APR Indicator 3 performance table can be created using 618: Table 6 Data!!!! • In the example to come Table 6 location is listed in the following format: • (Column) : (Grade)
Annual Performance Report: Indicator 3 618: Column 1 Grade 3 618: Proficient Levels Table 9d Grade 6
Indicator 3 Child Count Data 618: Table 6
Regular Assessment Data Indicator 3 618: Table 6 Not Available on 618: Table 6
Regular Assessment Data Indicator 3 For IEPs in regular assessment with no accommodations sum columns shaded below then take that result and subtract Green 618: Table 6 Example of state with minimum proficient level of 3
Alternate Assessment Data Indicator 3 618: Table 6 For IEPs in AA-GLAAS sum columns shaded above starting with minimum proficient level and moving right Example of state with minimum proficient level of 3
Indicator 3 Alternate Assessment Data 618: Table 6 For IEPs in AA-MAAS sum columns shaded above starting with minimum proficient level and moving right Example of state with minimum proficient level of 2
Indicator 3 Alternate Assessment Data 618: Table 6 For IEPs in AA-AAAS sum columns shaded above starting with minimum proficient level and moving right Example of state with minimum proficient level of 4
Overall Calculations Indicator 3 Overall equal to Blue + Green + Red + Yellow + Violet
Indicator 3 Overall Calculations Overall % equal to Blue divided by Green and then multiplied by 100
Annual Performance Report: Indicator 3 Overall Row Total equal to Blue + Green + Red + Yellow + Violet + Orange + Pink (same is true for all cells in this COLUMN)
Annual Performance Report: Indicator 3 Overall % equal to Blue divided by Green and then multiplied by 100 (same is true for all cells in this COLUMN)
contacts • Questions related to AYP, Participation, & Performance Data: • Jason R. Altman, Research Coordinator, altma014@umn.edu, 612-624-8561 • Questions related to Improvement Activities: • Chris Bremer, Research Associate, brem006@umn.edu, 612-625-7595 • Chris Rogers, Research Fellow, roge0229@umn.edu, 612-626-7233 • General Indicator 3 Questions: • Martha Thurlow, Director, thurl001@umn.edu, 612-624-4826 For additional information on Indicator 3 please see: http://nceo.info/indicator3/default.html