1 / 53

Data Coach Training Day 3

Data Coach Training Day 3. Dr. Yuwadee Wongbundhit Curriculum and Instruction. Recap. Recap (Continued). Data Coach Day 3 Topics. Predictive Performance Levels of Interim Assessments. Performance Level of Interim Assessments. Performance Level Definition.

tate
Download Presentation

Data Coach Training Day 3

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Data Coach Training Day 3 Dr. Yuwadee WongbundhitCurriculum and Instruction

  2. Recap

  3. Recap (Continued)

  4. Data Coach Day 3 Topics

  5. Predictive Performance Levels of Interim Assessments

  6. Performance Level of Interim Assessments

  7. Performance Level Definition

  8. 2011-12 Math Fall IA Predictive Performance Levels

  9. 2011-12 Reading Fall IA Predictive Performance Levels

  10. Where can you find the cut scores in Edusoft? • Click on Benchmark • Click on Assessments • Select Assessment • Click on View Details • Under Performance Bands, click on View Details

  11. School Performance Reports as of 11-25-2011

  12. 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

  13. Data Analysis Scheme (G3-8) Grade 5/8 BL, FIA, WIA, FCAT 2010-11 Grade 3/6 BL, FIA, WIA, FCAT Grade 4/7 BL, FIA, WIA, FCAT Grade 5/8 BL, FIA, WIA, FCAT 2011-12 Grade 3/6 BL, FIA, WIA, FCAT Grade 4/7 BL, FIA, WIA, FCAT Grade 5/8 BL, FIA, WIA, FCAT 2012-13 Grade 3/6 BL, FIA, WIA, FCAT Grade 4/7 BL, FIA, WIA, FCAT

  14. Data Analysis Scheme, High School in Reading Retaker BL, FIA, WIA, FCAT 2010-11 Grade 9 BL, FIA, WIA, FCAT Grade 10 BL, FIA, WIA, FCAT Retaker BL, FIA, WIA, FCAT 2011-12 Grade 9 BL, FIA, WIA, FCAT Grade 10 BL, FIA, WIA, FCAT Retaker BL, FIA, WIA, FCAT 2012-13 Grade 9 BL, FIA, WIA, FCAT Grade 10 BL, FIA, WIA, FCAT

  15. Data Analysis Scheme, High School - EOC 2010-11 Algebra I BL, FIA, WIA, EOC Biology BL, FIA, WIA, EOC 2011-12 Algebra I BL, FIA, WIA, EOC Geometry BL, FIA, WIA, EOC Biology BL, FIA, WIA, EOC 2012-13 Algebra I BL, FIA, WIA, EOC Geometry BL, FIA, WIA, EOC

  16. Year-at-a Glance Report Note

  17. Year-at-a Glance Summary Report (E)

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

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

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

  21. Year-at-a Glance Summary Report (H)

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

  23. Benchmark Analysis (E)

  24. Benchmark Analysis (M)

  25. Benchmark Analysis (HS)

  26. Science Fair Game Benchmarks Principals’ Liaison Committee Meeting Dr. Yuwadee Wongbundhit Curriculum and Instruction 11/28/2011 and 11/30/2011

  27. Science Fair Game Principle

  28. Benchmark Classification System Each benchmark in the NGSSS is labeled with a system of numbers and letters.

  29. Science Fair Game Benchmark, Grade 5

  30. Science Fair Game Benchmark, Grade 5 Monitoring Tool

  31. Science Fair Game Benchmark, Grade 8

  32. Science Fair Game Benchmark, Grade 8 Monitoring Tool

  33. Science Fair Game Benchmarks, Gr. 5 There are 25 AA Benchmarks.

  34. Science Fair Game Benchmarks, Grade 8 There are 32 AA Benchmarks.

  35. Grade 8 Fair Game AA Benchmarks • Grade 6 (10 out of 32, 31%): • SC.6.N.2.2 SC.6.P.13.1 SC.6.P.13.3 • SC.6.E.7.4 SC.6.E.7.5 SC.6.L.14.1 • SC.6.L.14.2 SC.6.L.14.4 SC.6.L.14.5 • SC.6.L.15.1 • Grade 7 (13 out of 32, 41%): • SC.7.N.1.2 SC.7.N.1.5 SC.7.N.3.1 • SC.7.E.6.2 SC.7.E.6.4 SC.7.E.6.5 • SC.7.P.10.1 SC.7. P.10.3 SC.7. P.11.2 • SC.7.P.11.4 SC.7.L.15.2 SC.7.L.16.1 • SC.7.L.17.2

  36. Science Data Interpretation

  37. 2011-2012 Fall Interim Assessment by Subgroup

  38. 2011-2012 Fall Interim Assessment by Subgroup

  39. 2011-2012 Fall Interim Assessment by Subgroup

  40. 2011-2012 Fall Interim Assessment by Subgroup

  41. 2011-2012 Fall Interim Assessment by Subgroup

  42. 2011-2012 Fall Interim Assessment by Subgroup

  43. Student Master File Student ID Student ID Student ID Student ID “Student ID” is used as a lookup value to merge the data from different files using Excel formula “V-Lookup” =VLOOKUP(LOOKUP_VALUE, TABLE_ARRAY, COLUMN INDEX NUMBER, FALSE)

  44. 2011-2012 School Database File Structure

  45. VLOOKUP FUNCTION =VLOOKUP(LOOKUP_VALUE, TABLE_ARRAY, COLUMN INDEX NUMBER, FALSE) Lookup_Value: What value are you searching for? Excel will look for a match to this value in the leftmost column of the lookup table Table_Array: Where do you want to search? Use absolute references to “lock” the range by pressing F4 key Col_index_num Which column contains the search result? Count over from the first column to figure out what this number should be, starting with 1. FALSE To force Excel to lookup value be exact match =VLOOKUP($A3,‘IA File Name'!$B$13:$R$739,3,FALSE)

  46. Practice Test Day 3 Go to Data Coach Website and down load “Practice Vlookup Day 3” =VLOOKUP(LOOKUP_VALUE, TABLE_ARRAY, COLUMN INDEX NUMBER, FALSE)

  47. Merging File Structure AJ3 = VLOOKUP($A3,‘IA File Name'!$B$13:$R$739,3,FALSE) AK3 = VLOOKUP($A3,‘IA File Name'!$B$13:$R$739,4,FALSE) AM3 = VLOOKUP($A3,‘IA File Name'!$B$13:$R$739,5,FALSE)

  48. Column Label with 4 Reporting Categories

More Related