2012 Data Coach Training Day 4

Dr. Yuwadee WongbundhitCurriculum and Instruction

Recap Day 3Predictive

Performance Level

Satisfactory Progress

(FCAT 2.0 L3-5)

Limited Progress(Not Sure)

Insufficient Progress

(FCAT 2.0 L1-2)

Interpret Fall IA School

Report

Reading

Math

Science

Update Database

FCAT 2011

Baseline Scores

Fall IA Scores

Data Coach Day 4 Topics

Predictive Scores of Winter IA

Winter IA School Performance Reports

Creation of Intervention Groups

Use of Pivot Table for Data Analysis

Check of Independent Work

Predictive Performance Levels of Interim AssessmentsReading (G3-10) and Math(G3 -8, Algebra I)

Satisfactory Progress: Predictive values within FCAT 2.0

Levels 3-5

Limited Progress (Not sure)

Insufficient Progress: Predictive values within FCAT 2.0

Levels 1-2

Rea

ding

(G3-

10) a

nd M

ath(

G3

-8, A

lgeb

ra I)

2011-12 Math Winter IA Predictive Performance Levels

Grade Total Points

Insufficient Progress

Limited Progress

Satisfactory Progress

%Insufficient Progress

% Limited Progress

% Satisfactory Progress

  Raw Score % Scores

3 34 0 - 13 14 - 15 16 - 34 0 to 38% 41% - 44% 47% or higher

4 40 0 - 15 16 - 18 19 - 40 0 to 38% 40% - 45% 48% or higher

5 38 0 - 21 22 - 23 24 - 38 0 to 55% 58% - 61% 63% or higher

6 40 0 - 16 17 - 18 19 - 40 0 to 40% 43% - 45% 48% or higher

7 47 0 - 21 22 - 24 25 - 47 0 to 45% 47% - 51% 53% or higher

8 40 0 - 19 20 - 22 23 - 40 0 to 48% 50% - 55% 58% or higher

ALG 40 0 - 13 14 - 16 17 - 40 0 to 33% 35% - 40% 43% or higher

2011-12 Math Fall and Winter IA Predictive Performance Levels

GradeTotal Pts.

% Insufficient

% Limited

%Satisfactory

Total Pts. %

Insufficient%

Limited%

Satisfactory

  Fall IA Winter IA

3 30 0 to 47% 50% - 57% 60% or higher 34 0 to 38% 41% - 44% 47% or higher

4 34 0 to 44% 47% - 53% 56% or higher 40 0 to 38% 40% - 45% 48% or higher

5 34 0 to 53% 56% - 59% 62% or higher 38 0 to 55% 58% - 61% 63% or higher

6 37 0 to 41% 43% - 49% 51% or higher 40 0 to 40% 43% - 45% 48% or higher

7 39 0 to 38% 41% - 46% 49% or higher 47 0 to 45% 47% - 51% 53% or higher

8 40 0 to 43% 45% - 50% 53% or higher 40 0 to 48% 50% - 55% 58% or higher

ALG 34 0 to 32% 35% - 41% 44% or higher 40 0 to 33% 35% - 40% 43% or higher

2011-12 Reading Winter IA Predictive Performance Levels

Grade Total Points

Insufficient Progress

Limited Progress

Satisfactory Progress

%Insufficient Progress

% Limited Progress

% Satisfactory Progress

  Raw Score % Scores

3 56 0 - 32 33 - 35 36 - 56 0 to 57% 59% - 63% 64% or higher

4 58 0 - 34 35 - 37 38 - 58 0 to 59% 60% - 64% 66% or higher

5 59 0 - 35 36 - 38 39 - 59 0 to 59% 61% - 64% 66% or higher

6 53 0 - 31 32 - 35 36 - 53 0 to 58% 60% - 66% 68% or higher

7 47 0 - 26 27 - 29 30 - 47 0 to 55% 57% - 62% 64% or higher

8 48 0 - 28 29 - 31 32 - 48 0 to 58% 60% - 65% 67% or higher

9 50 0 - 29 30 - 32 33 - 50 0 to 58% 60% - 64% 66% or higher

10 49 0 - 28 29 - 32 33 - 49 0 to 57% 59% - 65% 67% or higher

2011-12 Reading Fall and Winter IA Predictive Performance Levels

GradeTotal Pts.

% Insufficient

%Limited

% Satisfactory

Total Pts. %

Insufficient%

Limited%

Satisfactory

  Fall IA(Grades 8-10, the cut scores are tentative) Winter IA

3 56 0 to 48% 50% - 55% 57% or higher 56 0 to 57% 59% - 63% 64% or higher

4 56 0 to 54% 55% - 61% 63% or higher 58 0 to 59% 60% - 64% 66% or higher

5 56 0 to 55% 57% - 63% 64% or higher 59 0 to 59% 61% - 64% 66% or higher

6 54 0 to 54% 56% - 61% 63% or higher 53 0 to 58% 60% - 66% 68% or higher

7 56 0 to 48% 50% - 57% 59% or higher 47 0 to 55% 57% - 62% 64% or higher

8 61 0 to 51% 52% - 59% 61% or higher 48 0 to 58% 60% - 65% 67% or higher

9 57 0 to 51% 53% - 60% 61% or higher 50 0 to 58% 60% - 64% 66% or higher

10 53 0 to 45% 47% - 55% 57% or higher 49 0 to 57% 59% - 65% 67% or higher

Geometry and Science (Default Cut Scores)

Geometry

Proficient at 70%

Non-proficient

Science: Grades 5, 8, and Biology

Proficient at 70%

Non-proficient

Interim Assessment Mappinghttp://osi.dadeschools.net/datacoach/

Elementary, Grades 3-5

Reading, P1-3

Math, P4-6

Science, P7

Middle Schools, Grades 6-8

Reading, P1-3

Math, P4-6

Science, P7

High Schools

Reading, G9 (P1), G10 (P2)

Algebra (P3), Geo (P4)

Biology, P5

Availability of Winter IA School Reports

Year-at-a-Glance(DATA/COM 2/13)

• C & I Websitehttp://curriculum.dadeschools.net/schoolperformancereports.asp

Benchmark Analysis

(DATA/COM, 2/13)• C & I Website

http://curriculum.dadeschools.net/schoolperformancereports.asp

Winter IA Reports By Subgroup

• C & I Websitehttp://curriculum.dadeschools.net/schoolperformancereports.asp

Winter IA Results for Mid-Year Reporting to

FLBSI (Cut Scores at 70%)

• OSI Websitehttp://osi.dadeschools.net/wia4myr

2011-2012 Mid-Year Narrative Report, Form DA-2

Describe the gains and/or decreases in student achievement percentage points that have occurred between the baseline and midyear assessments. Include specific information about the grade levels or subgroups where improvements or declines have occurred.

Source: Florida Department of Education, Differentiated AccountabilityMid-Year Narrative Report, Form DA-2

2011-2012 Baseline Assessment by Subgroup

2011-2012 Winter Assessment Results for Mid-Year Reporting to FLBSI

School Performance of Winter IA Reports

2011-2012 Winter Interim Assessment by Subgroup

Analyzing Student Progress

Baseline

Aug. 2011

Fall IA

Oct. 2011

Jan. 2012

2012FCAT2.0

EOC

Apr./May

2012

Winter IA

PG Q1 PG Q2All All

Year-at-a Glance Detailed Report (E)

Year-at-a Glance Detailed Report (M)

Year-at-a Glance Detailed Report (H)

Science Data Interpretation

Do not compare the 2011 results to the 2010 results.

The average % correct can be compared from the baseline to the Fall IA and to the Winter IA.

For 2011 only, the % proficient (70% of higher) can be compared from the baseline to the Fall IA and to

the Winter IA

Math Reading

Science

DATA/COM Questions (Feb. 13, 2012)

1• Reading and Math: With the exception of

Geometry, compare the percentage of students making satisfactory progress between the fall and the winter interim assessments. What strategies are you implementing to improve the percentage of students making Satisfactory Progress?

2• Reading and Math: Identify areas of

weakness based on the average percent correct. What strategies are you implementing to remediate students on covered benchmarks that were not mastered?

3 • What strategies are you implementing to improve student achievement in science?

• WRITING: When reviewing the Mid-Year writing data, focus on percent of students scoring at 4 or higher for each of the assessed prompts. Based on the data, what instructional action plan are you implementing to boost the number of students scoring 4 or above?

Checking of Independent Assignment

Place your data coach binder on the table.

On the monitor, open the database folder.

Open the database grade 5, 8, or 10 reading file.

Acct. Files

Reading

Math

2011-2012 School Database File Structure

File Download Manager

Individualized Educational Portfolio PDF download assistance Program

27

Intervention Group Schematic

Intervention Groups

Retained

Retained

Missing Data

No FCAT and/or No

IA

Rank 0-35

Low 35

Intervention Groups

Rank 36 - 100

FCAT Levels 3-5 FCAT Level 2 FCAT Level 1

On Track 3-5

Regress 3-5

Bubble L2

Neutral L2

Decline L2

Bubble 1

Neutral L1

Edusoft Report Builder-1

31

Edusoft Report Builder-2

32

Result

Edusoft Report Builder-3

33

A

B

Result

Edusoft Report Builder-4

34

2. Type Report Name

Note:Create a new folder and name “Edusoft Files”

Save the export file under “Edusoft Files” Folder

To Add Winter IA Data into Database1. Create Winter IA from Edusoft Report Builder file (See Day 2 for instruction)2. Open the database file3. Open Edusoft Report Builder file that contains Winter IA data4. Use Move/Copy to copy Edusoft Winter IA to the Database file5. Rename Winter IA worksheet (Worksheet 1) to “WIA Data”6. On WIA Data, Cell B9, type “1”; on Cell C9, type “2”

1. Highlight cell B9 and C9 and do border, center, color them; 2. Next drag to the last cell of the WinIA to create the series of number 1, 2, 3 starting from B93. Highlight D10 to the last cell of row 12 (R12 for reading file);4. Select Copy

7. On the DataBase sheet tab, click into the cell in row 1 of the first empty cell after the Fall IA data

8. Click patse. The first three rows should be pasted with Winter IA assessment name, reporting categories, and scores (Raw Score, % Correct, and Performance Band)

9. Rename according to its reporting categories. Format these headers (border, center, wrap-text, color)

10. Filter the entire Row 311. Use the Vlookup function to add the Winter IA data, example:

=vlookup($a4,’WIA Data’!$B$13:$AG$230,’WIA Data’!D$9,false)

1

Instruction for Creating Intervention Groups1. Open Database file2. Use “Move/Copy Sheet” command to Copy “Database Sheet” into the Data base file.3. Rename the sheet to “Intervention”; color the sheet.4. On the Intervention sheet tab, hide all columns with the exception of the following column headers:

• Bubble, • Rank, • Most Recent FCAT Grade, • Most Recent FCAT Level, • Student Grade, • Homeroom for elementary and middle school• FCAT Pass/Fail for High School only• WIA Raw Score, • WIA % Correct, and • WIA Performance Band

5. For the next three blank column headers on row 3, type the following: • Intervention Group• Support Method• Interventionist

6. Format the Intervention Group, Support Method, and Interventionist columns (Border, center, wrap-text, color)7. On row 3, do filter8. Using “Filter” and “Fill Down” Commands to create Intervention Groups in the following order.

a) Retained (For high school: Retained F or Retained P). b) Before create the next intervention group, clear all filters with the exception of Intervention Group, filter Blankc) Low35d) On Track 3-5e) Regress 3-5f) Bubble L2g) Neutral L2h) Decline L2i) Bubble L1j) Neutral L1k) NoFCATl) NoIA

2

Create Intervention Schedule1. Download data from the File Download Manager (FDM) see Day3 instruction

2. Format the FDM file, see Day3 instruction and save the file

3. Open the database file

4. Use Move/Copy command to copy FDM sheet tab to the database file

5. Rename sheet tab as “FDM All Courses”

6. Use Move/Copy command to copy “FDM All Courses” into the same file. Rename the sheet tab as “Intervention Schedule”

7. Use the filter feature to delete unwanted courses or grade.

8. Column M1, type “Intervention Group” and do “filter” on Row 1

9. On “Invention” sheet tab, click into the cell above intervention header and type =column() and enter. This is a column index that will be used later with the vlookup.

10. Use “vlookup” function to bring intervention groups from the Intervention sheet tab. Sample formula =VLOOKUP($A2,Intervention!$A$4:$CF$766,81,FALSE)

11. Use “Fill Down” command to copy down the formula

12. Format the Intervention Schedule make it looks nice (border, center, color, freeze header and student name, etc.)

13. Use “Sort and Filter” command to perform custom sort; under the column Sort by selection the following:

1. Last Name;

2. Click “Add Level” and select First Name;

3. Click “Add Level” and select Middle Initial, and

4. Click “Add Level” and select Period then click OK

14. Use filter feature to color only Period = 1 and color those rows

15. Clear all filters

3

Instruction for Creating Support Method and InterventionistCreate Worksheets: “Support Method” and “Interventionist”1. Insert two blank worksheets (shift+F11 twice)2. Name the sheets as “Support Method” and “Interventionist”3. Click “Support Method” and type the support method into the cells under Column A

Sample support methods: Push in, Pull out, Parallel, Technology, etc.4. Click “Interventionist” and type interventionist names into the cells under Column A

Teacher 01; Teacher 02; Teacher 03, etc.

Create the drop-down list for Support Method5. Click “Intervention Group” Sheet, highlight BO4 to the last cell of BO6. On Data menu, click “Data Validation” and select “Data Validation”7. Under “Allow” select “list” item8. Under “Source”, type “='Support Method'!$A$1:$A$10”; click OK9. Test the drop-down list

Create the drop-down list for Interventionist10. Click “Intervention Group” Sheet, highlight BP4 to the last cell of BP11. On Data menu, click “Data Validation” and select “Data Validation”12. Under “Allow” select “list” item13. Under “Source”, type “=Interventionist!$A$1:$A$50”; click OK14. Test the drop-down list

4

Download File Download Manager

Format File Download ManagerStep 1. Rename the sheet tab, sample “All Courses”. Next, Filter and Freeze PanesStep 2. Fill in leading zero on “Course Subject Code” Field (column F).

• Highlight Column F• On the Home menu, find Format. Next select “Format Cells”• Under Number Tab, select Custom• Under Type: type 0000000 (seven zeros)• Click OK

Step 3. Sort “Course Subject Code” by clicking on filter arrow and select from smallest to largest• Fill leading 2 zeros for Column I (Class Section)

Step 4. Convert Student ID from Number value to Text value• Highlight Column B• On the Home menu, select Insert Sheet Column. Now, Column B is blank.• Type “Student ID” on Cell B1 to be a new column header• On B2, type formula as follow: =text(A2,”0000000”)• File down from Cell B2 to the last row.• Highlight Column B and select copy. Next Select Paste “Value”• Delete Column A (old Student ID)

EOC Subject AreasAlgebra 1

• 1200310 - Algebra 1• 1200320 - Algebra 1 Hon.• 1200380 - Algebra 1B• 1209810 - Pre-AICE

Mathematics 1• 1200390 - IB Middle Years

Program – Algebra 1 Hon.

Geometry• 1206310 - Geometry• 1206320 - Geometry Hon.• 1206810 - IB Middle Years

Program Geometry Hon.• 1209820 - Pre-AICE

Mathematics 2

Biology

• 2000310 - Biology 1• 2000320 - Biology 1 Hon.• 2000322 - Pre-AICE Biology • 2000430 - Biology Technology • 2000800 - Biology 1 PreIB

• 2000850 - IB Middle Years Program Biology Hon.

• 2002440 - Integrated Science 3• 2002450 - Integrated Science 3

Hon.