2012 Data Coach Training Day 4

1. 2012 Data Coach Training Day 4 Dr. Yuwadee WongbundhitCurriculum and Instruction

2. Recap Day 3

3. Data Coach Day 4 Topics

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

5. 2011-12 Math Winter IA Predictive Performance Levels

6. 2011-12 Math Fall and Winter IA Predictive Performance Levels

7. 2011-12 Reading Winter IA Predictive Performance Levels

8. 2011-12 Reading Fall and Winter IA Predictive Performance Levels

9. Geometry and Science (Default Cut Scores)

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

11. Availability of Winter IA School Reports

12. 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 Accountability Mid-Year Narrative Report, Form DA-2

13. 2011-2012 Baseline Assessment by Subgroup

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

15. School Performance of Winter IA Reports

16. 2011-2012 Winter Interim Assessment by Subgroup

17. Analyzing Student Progress Aug. 2011 Oct. 2011 Jan. 2012 Apr./May 2012 All PG Q1 PG Q2 All Baseline Fall IA Winter IA 2012FCAT2.0EOC

18. Year-at-a Glance Detailed Report (E)

19. Year-at-a Glance Detailed Report (M)

20. Year-at-a Glance Detailed Report (H)

21. Science Data Interpretation

22. Math Reading

23. Science

24. DATA/COM Questions (Feb. 13, 2012)

25. Checking of Independent Assignment

26. 2011-2012 School Database File Structure File Download Manager

27. Individualized Educational Portfolio PDF download assistance Program

28. Intervention Group Schematic

29. Intervention Groups Rank 0-35 Missing Data Retained Low 35 No FCAT and/or No IA Retained

30. Intervention Groups Rank 36 - 100 FCAT Levels 3-5 FCAT Level 2 FCAT Level 1 On Track 3-5 Bubble L2 Bubble 1 Regress 3-5 Neutral L2 Neutral L1 Decline L2

31. EdusoftReport Builder-1

32. Edusoft Report Builder-2 Result

33. Edusoft Report Builder-3 A Result B

34. Edusoft Report Builder-4 2. Type Report Name Note: Create a new folder and name “Edusoft Files” Save the export file under “Edusoft Files” Folder

35. To Add Winter IA Data into Database • Create Winter IA from Edusoft Report Builder file (See Day 2 for instruction) • Open the database file • Open Edusoft Report Builder file that contains Winter IA data • Use Move/Copy to copy Edusoft Winter IA to the Database file • Rename Winter IA worksheet (Worksheet 1) to “WIA Data” • On WIA Data, Cell B9, type “1”; on Cell C9, type “2” • Highlight cell B9 and C9 and do border, center, color them; • Next drag to the last cell of the WinIA to create the series of number 1, 2, 3 starting from B9 • Highlight D10 to the last cell of row 12 (R12 for reading file); • Select Copy • On the DataBasesheet tab, click into the cell in row 1 of the first empty cell after the Fall IA data • Click patse. The first three rows should be pasted with Winter IA assessment name, reporting categories, and scores (Raw Score, % Correct, and PerformanceBand) • Rename according to its reporting categories. Format these headers (border, center, wrap-text, color) • Filter the entire Row 3 • 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

36. Instruction for Creating Intervention Groups • Open Database file • Use “Move/Copy Sheet” command to Copy “Database Sheet” into the Data base file. • Rename the sheet to “Intervention”; color the sheet. • 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 • For the next three blank column headers on row 3, type the following: • Intervention Group • Support Method • Interventionist • Format the Intervention Group, Support Method, and Interventionist columns (Border, center, wrap-text, color) • On row 3, do filter • Using “Filter” and “Fill Down” Commands to create Intervention Groups in the following order. • Retained (For high school: Retained F or Retained P). • Before create the next intervention group, clear all filters with the exception of Intervention Group, filter Blank • Low35 • On Track 3-5 • Regress 3-5 • Bubble L2 • Neutral L2 • Decline L2 • Bubble L1 • Neutral L1 • NoFCAT • NoIA 2

37. Create Intervention Schedule • Download data from the File Download Manager (FDM) see Day3 instruction • Format the FDM file, see Day3 instruction and save the file • Open the database file • Use Move/Copy command to copy FDM sheet tab to the database file • Rename sheet tab as “FDM All Courses” • Use Move/Copy command to copy “FDM All Courses” into the same file. Rename the sheet tab as “Intervention Schedule” • Use the filter feature to delete unwanted courses or grade. • Column M1, type “Intervention Group” and do “filter” on Row 1 • 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. • Use “vlookup” function to bring intervention groups from the Intervention sheet tab. Sample formula =VLOOKUP($A2,Intervention!$A$4:$CF$766,81,FALSE) • Use “Fill Down” command to copy down the formula • Format the Intervention Schedule make it looks nice (border, center, color, freeze header and student name, etc.) • Use “Sort and Filter” command to perform custom sort; under the column Sort by selection the following: • Last Name; • Click “Add Level” and select First Name; • Click “Add Level” and select Middle Initial, and • Click “Add Level” and select Period then click OK • Use filter feature to color only Period = 1 and color those rows • Clear all filters 3

38. Instruction for Creating Support Method and Interventionist Create Worksheets: “Support Method” and “Interventionist” • Insert two blank worksheets (shift+F11 twice) • Name the sheets as “Support Method” and “Interventionist” • Click “Support Method” and type the support method into the cells under Column ASample support methods: Push in, Pull out, Parallel, Technology, etc. • Click “Interventionist” and type interventionist names into the cells under Column ATeacher 01; Teacher 02; Teacher 03, etc. Create the drop-down list for Support Method • Click “Intervention Group” Sheet, highlight BO4 to the last cell of BO • On Data menu, click “Data Validation” and select “Data Validation” • Under “Allow” select “list” item • Under “Source”, type “='Support Method'!$A$1:$A$10”; click OK • Test the drop-down list Create the drop-down list for Interventionist • Click “Intervention Group” Sheet, highlight BP4 to the last cell of BP • On Data menu, click “Data Validation” and select “Data Validation” • Under “Allow” select “list” item • Under “Source”, type “=Interventionist!$A$1:$A$50”; click OK • Test the drop-down list 4

39. Download File Download Manager

40. Format File Download Manager Step 1. Rename the sheet tab, sample “All Courses”. Next, Filter and Freeze Panes Step 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)

41. EOC Subject Areas Algebra 1 Geometry 1206310 - Geometry 1206320 - Geometry Hon. 1206810 - IB Middle Years Program Geometry Hon. 1209820 - Pre-AICE Mathematics 2 • 1200310 - Algebra 1 • 1200320 - Algebra 1 Hon. • 1200380 - Algebra 1B • 1209810 - Pre-AICE Mathematics 1 • 1200390 - IB Middle Years Program – Algebra 1 Hon. 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.