Creating Actionable Data for Schools, Part I June

Creating Actionable Data for Schools, Part I June 20 July 6, 2011 Dr. Yuwadee Wongbundhit Curriculum and Instruction Topics Overview FCAT 2.0/EOC Scores, School Performance Reports, and Student Data Sources Monitoring Tool for FCAT 2.0 Content Assessed Benchmarks Using Excel formula to calculate % Correct, IF statements to determine learning gains Using Pivot Table for data analysis Using Vlookup functions Assumptions: You... are familiar with FCAT 2.0/EOC assessments, school grade and AYP are familiar with the District Interim Assessments have some experience looking at the data and using Microsoft Excel applications love, love, love data!!! 3 NORMS Listen to others Next, set your learning into action Reflect on

relevance to you Engage with the ideas presented Norms Ask questions 4 http://osi.dadeschools.net/actiondata 5 Monitoring Tool for FCAT 2.0 Content Assessed Benchmark By Reporting Category Monitoring Tool for FCAT 2.0 Content Assessed Grades 3-5 Elementary Click on a subject/grade button below to go to that specific sheet. Mathematics Grade 3 Grade 4 Grade 5 Middle School Reading Science Grade 3

Grade 4 Grade 5 Grade 5 High School http://osi.dadeschools.net/actiondata 6 Interim Assessment Benchmark Mapping Go to actionable data website and click on Interim Assessment Benchmark School Level Data Sources Curriculum and Instruction Website FlDOE Website OADA Website School Level Data Sources Demographics Reports Report Builder from

Edusoft 8 Updated School Performance Report on C & I Website Benchmark Analysis Interim Assessment by Subgroups Five-Year AYP Year at a Glance Five-Year FCAT http://curriculum.dadeschools.net/schoolperformancereports.asp9 Selection of School Report School and Subject Selection Step 1. Select a school from the drop down list below. List of Schools Step 2. Click on a subject/grade button below to go to that specific sheet. School Performance Reports Grade 6 Grade 7 Grade 8 Benchmark List Description Grade 6 Grade 7 Grade 8 School Performance Reports

Grade 6 Grade 7 Grade 8 Benchmark List Description Grade 6 Grade 7 Grade 8 School Performance Reports N/A N/A Grade 8 Benchmark List Description N/A N/A Grade 8 Mathematics Reading Science http://curriculum.dadeschools.net/schoolperformancereports.asp10 Student Database FCAT, FCAT2.0, EOC scores Course

Enrollments Demographics Information Accountability Information Student Database Interim Assessments, FAIR 11 2010-2011 Ideal Data File Interim Assessments, FAIR 2011 FCAT2.0 and EOC Scores 2010 FCAT Scores Demographics Information Student Academic 20102011 Data File Student Accountability Information 12

Student Data Sources Student Performance Indicators (SPI) File Download Manager Student Data Sources Accountability Reports on Principal Portal Edusoft and PMRN PMRN Progress Monitoring Reporting Network 13 File Download Manager Demographic Class Academic ESE Download File ESOL Testing 14 Student Performance Indicators (SPI) 15

SPI School Data Elements 1. CLASS_SCHOOL 2. STUDENT_NAME 3. STUDENT_ID 4. STUDENT_STATUS_CODE 5. GENDER 6. STUDENT_ETHNICITY 7. STUDENT_GRADE 8. STUDENT_HOMEROOM 9. LEP_Entry_Date 10.LUNCH_CODE 11. Birthdate 12.ESE_INFO 13.LEP_INFO 14.FCAT_CURR_GROUP 15.FCAT_TEST_YEAR 16.FCAT_TEST_MONTH 17.FCAT_GRADE 18.FCAT_NRT_MATH_SCALE 19.FCAT_NRT_MATH_PERCENT 20.FCAT_NRT_MATH_STANINE 21.FCAT_NRT_READ_SCALE 22.FCAT_NRT_READ_PERCENT 23.FCAT_NRT_READ_STANINE 24.FCAT_SSS_MATH_SCORE 25.FCAT_SSS_MATH_LEVEL 26.FCAT_SSS_MATH_DEVELOP 27.FCAT_SSS_MATH_NS 28.FCAT_SSS_MATH_M 29.FCAT_SSS_MATH_GS 30.FCAT_SSS_MATH_AT 31.FCAT_SSS_MATH_DA 32.FCAT_SSS_READ_SCORE 33.FCAT_SSS_READ_LEVEL 34.FCAT_SSS_READ_DEVELOP 35.FCAT_SSS_READ_WP 36.FCAT_SSS_READ_MIP 37.FCAT_SSS_READ_C 38.FCAT_SSS_READ_RR 39.FCAT_SSS_SCI_SCORE 40.FCAT_SSS_SCI_LEVEL 41.FCAT_SSS_SCI_PC

42.FCAT_SSS_SCI_ES 43.FCAT_SSS_SCI_LE 44.FCAT_SSS_SCI_ST 45.FCAT_SSS_WRITE_PT 46.FCAT_SSS_WRITE_SCORE 47.FCAT_READ_PASS_FAIL 48.FCAT_MATH_PASS_FAIL Accountability Report Data Elements No. Variable Name No. Variable Name 1 Student_ID 12 Most_Recent_FCAT_DSS_Score 2 Name 13 Prior_FCAT_Grade 3 Gain 14 Prior_FCAT_Level 4

Bubble 15 Prior_FCAT_Scale_Score 5 Regress 16 Prior_FCAT_DSS_Score 6 Sur2_Schl 17 AYP_Ethnic 7 Sur3_Schl 18 LEP_code 8 Rank 19 LF___2_YR 9 Most_Recent_FCAT_Grade 20

LEP_Entry_Date 10 Most_Recent_FCAT_Level 21 SPED_EXCP 11 Most_Recent_FCAT_Scale_Score 22 Lunch_Code 2011 FCAT in pdf. File (Portable Document Format) 18 How will scores on the FCAT 2.0 be reported? Link to Understanding FCAT 2.0 Reports, Spring 2011 19 Sample of FCAT 2.0 Reading, Grade 4 Report 1 2 3 4 5 6 7 8 9 20

2011 FCAT 2.0 Scores 2007 NGSSS 1996 SSS Base scale of FCAT Base scale of FCAT 2.0 New FCAT 2.0 Scale 2012: In January 2012, the new achievement-level cut scores for the FCATFCAT FCAT 2.0 willFCAT be created for the FCAT 2.0 in reading (G3-10) FCAT 19992001 FCAT 2.0 FCAT 2.0 and mathematics (G3-8). FCAT 2002 2.0 2012 Equivalent 2010 Scores 2011 21 Equipercentile Linking Example The black and green lines represent scores on two different assessments The lines show how the raw score relates to the percentile rank A black score of 260 and a green score of 340 are both at the 50th percentile rank and are equivalent 22

23 1 FCAT Equivalent Scores 2 Achievement Level 3 Content Area Scores 2011 FCAT 2.0 Scores 2011 FCAT 2.0 Scores Raw Score Equivalent Scale Score V: Vocabulary RA: Reading(100 Application - 500) LA: Literary Analysis IR: Informational Text/Research Process Equivalent DSS (86 to 3008) Reading Content Scores V IR Equivalent Achievement Level (1 to 5) Raw

Score RA LA 24 Scale Score vs. Developmental Scale Score G4 G3 100 86 Scale Score 100 500 500 G10 100 Developmental Scale Scores Grade 3 500 3008 Grade 10 Achievement Levels for the FCAT Reading Equivalent Scale Score Grade 3 4 5 6

7 8 9 10 Ach. Level 1 Ach. Level 2 Ach. Level 3 Ach. Level 4 Ach. Level 5 100-258 259-283 284-331 332-393 394-500 100-274 275-298 299-338 339-385 386-500 100-255 256-285 286-330 331-383 384-500 100-264 265-295 296-338 339-386

387-500 100-266 267-299 300-343 344-388 389-500 100-270 271-309 310-349 350-393 394-500 100-284 285-321 322-353 354-381 382-500 100-286 287-326 327-354 355-371 372-500

Achievement Levels for the FCAT Reading Equivalent Scale Score Grade Ach. Level 1 Ach. Level 2 Ach. Level 3 Ach. Level 4 Ach. Level 5 3 100-258 (158) 259-283 (24) 284-331 (47) 332-393 (61) 394-500 (106) 4 100-274 (174) 275-298 (23) 299-338 (39) 339-385 (46) 386-500 (114) 5 100-255

(155) 256-285 (29) 286-330 (44) 331-383 (53) 384-500 (116) 6 100-264 (164) 265-295 (30) 296-338 (42) 339-386 (47) 387-500 (113) 7 100-266 (166) 267-299 (32) 300-343 (43) 344-388

(44) 389-500 (111) 8 100-270 (170) 271-309 (38) 310-349 (39) 350-393 (43) 394-500 (106) 9 100-284 (184) 285-321 (36) 322-353 (31) 354-381 (27) 382-500 (118) 10 100-286 (186)

287-326 (39) 327-354 (27) 355-371 (16) 372-500 (128) Achievement Levels for the FCAT Reading Equivalent DSS Grade 3 4 5 6 7 8 9 10 Ach. Level 1 Ach. Level 2 Ach. Level 3 Ach. Level 4 Ach. Level 5 86-1045 1046-1197

1198-1488 1489-1865 1866-2514 295-1314 1315-1455 1456-1689 1690-1964 1965-2638 474-1341 1342-1509 1510-1761 1762-2058 2059-2713 539-1449 1450-1621 1622-1859 1860-2125 2126-2758 671-1541 1542-1714 1715-1944 1945-2180

2181-2767 886-1695 1696-1881 1882-2072 2073-2281 2282-2790 772-1771 1772-1971 1972-2145 2146-2297 2298-2943 844-1851 1852-2067 2068-2218 2219-2310 2311-3008 Achievement Levels for the FCAT Reading Equivalent DSS Grade 3 4 5 6 7 8 9 10

Ach. Level 1 Ach. Level 2 Ach. Level 3 Ach. Level 4 Ach. Level 5 86-1045 (959) 295-1314 (1019) 474-1341 (867) 539-1449 (910) 671-1541 (870) 886-1695 (809) 772-1771 (999) 844-1851 (1007) 1046-1197 (151) 1315-1455 (140) 1342-1509 (167) 1450-1621 (171) 1542-1714 (172)

1696-1881 (185) 1772-1971 (199) 1852-2067 (215) 1198-1488 (290) 1456-1689 (233) 1510-1761 (251) 1622-1859 (237) 1715-1944 (229) 1882-2072 (190) 1972-214 (173) 2068-2218 (150) 1489-1865 (376) 1690-1964 (274) 1762-2058 (296) 1860-2125 (265) 1945-2180 (235) 2073-2281 (208) 2146-2297 (151) 2219-2310 (91) 1866-2514 (648)

1965-2638 (673) 2059-2713 (654) 2126-2758 (632) 2181-2767 (586) 2282-2790 (508) 2298-2943 (645) 2311-3008 (697) Reading DSS, Achievement Level, and Raw Scores* Grade Ach. Level 1 Ach. Level 2 Ach. Level 3 Ach. Level 4 Ach. Level 5 3 86-1045 (959) 1046-1197 (152) 1198-1488 (290)

1489-1865 (376) 1866-2514 (648) 2006 Raw Scores 0-17 (0% - 38%) 18 23 (40% - 51%) 24 34 (53% - 76%) 35 43 (78% - 96%) 44 45 (98% - 100%) 4 295-1314 (1019) 1315-1455 (140) 1456-1689 (233) 1690-1964 (274) 1965-2638 (673)

2005 Raw Scores 0-23 (0% - 45%) 24 29 (47% - 57%) 30 38 (59% - 75%) 39 45 (76% - 88%) 46 51 (90% - 100%) 5 474-1341 (867) 1342-1509 (167) 1510-1761 (251) 1762-2058 (296) 2059-2713 (654) 2007 Raw Scores 0-15 (0% - 33%)

16 21 (36% - 47%) 22 31 (49% - 69%) 32 39 (71% - 87%) 40 45 (89% - 100%) Reading DSS, Achievement Level, and Raw Scores* Grade Ach. Level 1 Ach. Level 2 Ach. Level 3 Ach. Level 4 Ach. Level 5 6 539-1449 (910) 1450-1621 (171) 1622-1859 (237) 1860-2125 (265)

2126-2758 (632) 2007 Raw Scores 0-16 (0% - 36%) 17 23 (38% - 51%) 24 33 (53% - 73%) 34 40 (76% - 89%) 41 45 (91% - 100%) 7 671-1541 (870) 1542-1714 (172) 1715-1944 (229) 1945-2180 (235) 2181-2767 (586)

2006 Raw Scores 0-19 (0% - 42%) 20 28 29 37 (84% - 93%) 43 45 (44% - 62%) (64% - 82%) 38 42 (96% - 100%) 8 886-1695 (809) 1696-1881 (185) 1882-2072 (190) 2073-2281 (208) 2282-2790 (508) 2005 Raw

Scores 0-24 (0% - 47%) 25 33 34 40 41 46 47 51 (49% - 65%) (67% - 78%) (80% - 90%) (92% - 100%) *Approximate Number of Correct Answers/Points Needed for Each Reading DSS, Achievement Level, and Raw Scores* Grade Ach. Level 1 Ach. Level 2 Ach. Level 3 Ach. Level 4 Ach. Level 5 9

772-1771 (999) 1772-1971 (199) 1972-214 (173) 2146-2297 (151) 2298-2943 (645) 2006 Raw Scores 0-20 (0% - 44%) 21 30 31 37 (84% - 91%) 42 45 (47% - 67%) (69% - 82%) 38 41 (93% - 100%) 844-1851 (1007) 1852-2067 (215)

2068-2218 (150) 2219-2310 (91) 2311-3008 (697) 0-29 (0% - 57%) 30 37 38 40 41 44 45 51 10 2004 Raw Scores (Firsttime) (59% - 73%) (75% - 78%) (80% - 86%) (88% - 100%) *Approximate Number of Correct Answers/Points Needed for Each How will scores on the Algebra 1 EOC be reported? 34 Algebra 1 EOC Scores

Raw Score Algebra Content Scores C1 EOC-Scale Scores (20 to 80) Raw Score C3 Achievement Level (1 to 5) C2 C1 Functions, Linear Equations, and Inequalities C2 Polynomials C3 Rationals, Radicals, Quadratics, and Discrete Mathematics Algebra End-of-Course Reporting Category EOC-Scale Score Test Form Statewide Comparison

1 2 Points Earned by Content Area 3 37 2011 Content Scores 39 Reading Reporting Categories Changing FCAT Reading Words and Phrases in Context Main Idea, Plot, and Purpose Comparisons and Cause and Effect Reference and Research FCAT 2.0 Reading Vocabulary Reading Application Literary Analysis: Fiction and Non Fiction Informational Text and Research Process 40 2011 FCAT 2.0 Possible Points Reading Reporting Category Content Vocabulary Content Focus

G3 G4 G5 G6 G7 G8 G9 G10 8 7 8 8 8 8 9 8 Reading Application Literary Analysis: Fiction and Non Fiction Informational Text and Research Process 16 19 17 17 17 16 12 14 12

11 12 12 11 13 11 11 9 8 8 8 9 8 13 12 Total 45 45 45 45 45

45 45 45 FCAT 2.0 Content Categories - Reading Approximate percentage of raw-score points that will be derived from each content category Literary Analysis: Fiction & Nonfiction Informational Text& Research Process Grade Vocabulary Reading Application 37 15-25% 25-35% 25-35% 15-25% 810 15-25% 20-30% 20-30%

25-35% Test Length: 50-55 items http://fcat.fldoe.org/pdf/designsummary.pdf 42 FCAT Mathematics Reporting Categories Reporting Category Number Sense, Concepts, and Operations Measurement Geometry and Spatial Sense Algebraic Thinking Data Analysis and Probability 3 4 Grades 5 6

7 8 43 New FCAT 2.0 Mathematics Reporting Categories Reporting Category Geometry and Measurement Number: Operations, Problems, and Statistics Number: Fractions Number: Operations and Problems Number: Base Ten and Fractions Expressions, Equations, and Statistics Fractions, Ratios, Proportional Relationships, and Statistics Expressions and Equations Ratios and Proportional Relationships Number: Base Ten Statistics and Probability Expressions, Equations, and Functions 3 4

Grades 5 6 7 8 44 2011 FCAT 2.0 Possible Points, Grades 3-5 Mathematics Reporting Category Content G3 Number: Operations, Problems, and Statistics 21 Number: Fractions 10 Geometry and Measurement 13

G4 G5 12 14 Number: Operations and Problems 17 Number: Base Ten and Fractions 11 Expressions, Equations, and Statistics Total 22 10 44 40 46 2011 FCAT 2.0 Possible Points, Grades 6-8 Mathematics Reporting Category Content G6 Fractions, Ratios, Proportional Relationships, and Statistics 18 Expressions and Equations

17 9 Geometry and Measurement Number: Base Ten Ratios/Proportional Relationships Statistics and Probability G7 G8 13 11 12 8 17 Number: Operations, Problems, and Statistics 12 Expressions, Equations, and Functions 19 48 Total 44 44 FCAT 2.0 Mathematics, Grade 3 - 5 Grade 3 4 5

Category % Number: Operations, Problems, and Statistics 50 Geometry and Measurement Number: Fractions Number: Operations and Problems Geometry and Measurement Number: Base Ten and Fractions Number: Base Ten and Fractions Geometry and Measurement Expressions, Equations, and Statistics 30 20 45 30 25 50 30 20 47 FCAT 2.0 Mathematics, Grade 6 - 8 Category Grade 6 7 8 % Fractions, Ratios, Proportional Relationships, and Statistics

40 Expressions and Equations 40 Geometry and Measurement 20 Geometry and Measurement 30 Ratios and Proportional Relationships 25 Number: Base Ten 25 Statistics and Probability Expressions, Equations, and Functions Geometry and Measurement 20 Number: Operations, Problems, and Statistics 40 35 48 25 End-of-Course Reporting Category Alg Functions, Linear Equations, and 1 Inequalities Polynomials Rationals, Radicals, Quadratics, and Discrete Mathematics

Geo. Two-Dimensional Geometry Three-Dimensional Geometry Trigonometry & Discrete Math Bio 1 Molecular and Cellular Biology Classification, Heredity, and Evolution Organisms, Populations, and Ecosystems % 2011 items 55% 30 20% 10 25% 12 65% 20% 15% 35% 25% 40% 2011 FCAT in pdf. File (Portable Document Format) 50 Sample of FCAT 2.0 Reading Content Area Scores 88% 56% 67% 67%

51 Practice Handout 1 - Calculate the % correct for each content area. Points Earned By Content Area % Correct By Content Area Students Content 1 Content 2 Content 3 Content 4 Number of Points Possible 7 21 11 6 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16

17 18 19 20 21 22 23 24 25 6 5 4 4 5 6 4 4 4 5 4 3 4 4 4 4 4 3 4 4 5 5 6 4 5 17 17 12 13 17 18 13

14 13 14 12 10 13 13 11 14 12 11 12 13 13 13 17 12 13 8 9 7 6 9 9 7 7 7 7 7 5 7 7 6 7 7 6 6 6 7 7 9 7

7 5 5 3 3 5 5 3 4 4 4 4 2 3 4 3 4 3 3 3 3 3 4 5 3 3 Content 1 Content 2 Content 3 Content 4 52 Practice Handout 1 - Calculate % correct for each content area. Points Earned By Content Area % Correct By Content Area

Student Content 1 Content 2 Content 3 Content 4 Number of Points Possible 7 21 11 6 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

24 25 6 5 4 4 5 6 4 4 4 5 4 3 4 4 4 4 4 3 4 4 5 5 6 4 5 17 17 12 13 17 18 13 14 13 14 12 10 13 13

11 14 12 11 12 13 13 13 17 12 13 8 9 7 6 9 9 7 7 7 7 7 5 7 7 6 7 7 6 6 6 7 7 9 7 7 5 5 3 3 5

5 3 4 4 4 4 2 3 4 3 4 3 3 3 3 3 4 5 3 3 Content 1 Content 2 Content 3 Content 4 86% 71% 57% 57% 71% 86% 57% 57% 57% 71% 57% 43% 57% 57%

57% 57% 57% 43% 57% 57% 71% 71% 86% 57% 71% 81% 81% 57% 62% 81% 86% 62% 67% 62% 67% 57% 48% 62% 62% 52% 67% 57% 52% 57% 62% 62% 62% 81% 57% 62% 73% 82% 64% 55% 82%

82% 64% 64% 64% 64% 64% 45% 64% 64% 55% 64% 64% 55% 55% 55% 64% 64% 82% 64% 64% 83% 83% 50% 50% 83% 83% 50% 67% 67% 67% 67% 33% 50% 67% 50% 67% 50% 50% 50% 50% 50% 67%

83% 50%53 50% Get to Know Excel Formula Student Total Items 1 2 3 4 5 6 7 Reading Math Science % Reading % Math % Science 45 40 56 42 15 17 30 38 21 35 28 30 25 17 32 27 39

30 23 45 37 17 40 30 Download file from http://osi.dadeschools.net/actiondata Under Excel Worksheets, click on Excel Practice Click Open and save on the desktop 54 Excel Worksheet: Practice 1Calculate Raw Score and % Correct Download file from http://osi.dadeschools.net/actiondata Under Excel Worksheets, click on 2011 FCAT Save the file on PC Follow handout Excel Worksheet Practice 1 Using Pivot Table to Answer These Questions Percentage of students achieved levels 1 to 5 in 2011 Percentage of students achieved high standards List of Students 2011 FCAT Level 3 and Levels 4 and 5 List of students with 2011 FCAT Levels 1 and 2 List of students of levels 1 with their content scores % Correct for each achievement levels Insert Pivot Table for Data Analysis 1. Click on Cell A2 2. On main menu, select Insert 3. Click on Pivot Table then select Pivot Table 4. Create Pivot Table will appear. 5. Check Table/Range to make sure it is correct. Then click OK. 6. Pivot Table appear with Pivot Table Field List. Continued 1. Click A3 and select Options under PivotTable Tools.

2. Next click on Options under . PivotTable Name. Next, select Options under PivotTable Tools. 3. Select Display Tab 4. Check on Classic Pivot Table layout http://osi.dadeschools.net/actiondata Convert 2011 FCAT student data from pdf. File to Excel file Input reading and math data into the template Built-in Reading, Math Reports and Pivot Table, including FCAT Content Focus 60 IF Statement Syntax =IF(logical_test, value_if_true, value_if _false) Logical test: Any value or expression that can be evaluated to TRUE or FALSE. Value_if_True: The value that you want to be returned if the logical_test argument evaluates to TRUE. Value_if_False: The value that you want to be returned if the logical_test argument

evaluates to FALSE. =if(Z2 > L2, Yes, No) Open Excel Practice Sample of FCAT 2.0 Reading, Grade 4 Report 1 2 3 4 5 6 7 8 9 62 Improve achievement Levels Maintain high standards Demonstrate more than one years growth (using the developmental scale score gains) when remaining in achievement level 1 or 2 for both years. 2011 Achievement Level Criteria for Making Annual Learning Gains 5 4

3 2 1 1 2 3 4 5 2010 Achievement Level and Reading Grade Annual Learning 3 to 4 Reading 231 Math

163 4 to 5 167 120 5 to 6 134 96 6 to 7 111 79 Levels 1 and 2 (Do 7 to 8 93 65 not use for retained students) 8 to 9 78 NA 9 to 10 78 49

Gains for FCAT Achievement Mathematics FCAT Worksheet Student Student Grade Achievement Developmental Level Scale Scores (DSS) 2009-10 2010-11 2009-10 2010-11 2009-10 2010-11 Change 1 6 7 2 2 1661 1676 15 2 6 7 4 3 1919

1926 7 3 6 7 1 1 1265 1502 237 4 6 7 1 3 1295 1853 558 5 7 7

1 1 1382 1502 120 6 6 7 3 2 1717 1748 31 7 6 7 1 1 1269 1382 113 8

7 7 2 2 1676 1748 72 9 6 7 4 4 1902 1939 37 10 6 7 1 1 1256

958 -298 11 6 7 2 3 1687 1930 243 12 6 7 3 3 1751 1870 119 1676 NA 1644 9

13 7 2 14 6 7 2 15 6 7 3 1 1635 1786 NA 2010-11 Meeting High Standards for School Grade 2010-11 Making Annual Learning Gains 2010-11 Meeting AYP Standards Yes/No

Yes/No Yes/No Mathematics FCAT Worksheet - Answer Student Student Grade Achievement Developmental Level Scale Scores (DSS) 2009-10 2010-11 2009-10 2010-11 2009-10 2010-11 Change 1 6 7 2 2 1661 1676 15 2 6 7 4 3

1919 1926 7 3 6 7 1 1 1265 1502 237 4 6 7 1 3 1295 1853 558 5 7 7

1 1 1382 1502 120 6 6 7 3 2 1717 1748 31 7 6 7 1 1 1269 1382 113

8 7 7 2 2 1676 1748 72 9 6 7 4 4 1902 1939 37 10 6 7 1 1 1256

958 -298 11 6 7 2 3 1687 1930 243 12 6 7 3 3 1751 1870 119 1676 NA 1644

9 13 7 2 14 6 7 2 15 6 7 3 1 1635 1786 NA 2010-11 Meeting High Standards for School Grade 2010-11 Making Annual Learning Gains 2010-11 Meeting AYP Standards Yes/No

Yes/No Yes/No No Yes No Yes No No No No Yes No Yes Yes No No NA No No Yes Yes No No Yes No Yes No Yes Yes NA No NA No Yes No Yes No No

No No Yes No Yes Yes No No NA IF Statements to Determine Gains C2 =IF(Z2 > L2,Y,N) E2 =IF(AND(Z2 = L2, Z2<3, AA2-N2>110),Y,N) F2 =IF(OR(C2 = Y, D2 = Y, E2 = Y) ,Y,N) D2 =IF(AND(Z2 = L2,Z2>2),Y,N) Using Pivot Table to Answer These Questions Percentage of students achieved levels 1 to 5 in 2011 by grade level/classroom/course/AYP subgroups. Percentage of students achieved high standards in both reading and math. Comparison of 2010 and 2011 Achievement Levels. List of Students 2011 FCAT Level 3 and Levels 4 and 5 who made learning gains. Which are the strengths/weakness areas for students performing at below grade levels. List of students of level 1 with their content scores. Using Pivot Table to Answer These Questions How many students made Learning gains? Which students improved in their achievement level

in 2011? Which students maintained high standards? For students in levels 1 and 2, who made a year growth? For students meeting high standards, who did not make learning gains? Using Pivot Table to Create the following tables Ethnicity by 2011 FCAT Levels ED subgroup by 2011 FCAT Levels ELL subgroup by 2011 FCAT Levels Winter IA Proficiency by 2011 Achievement Level 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 Open Excel Practice file =VLOOKUP($A2,Interim Assessment!$A$3:$R$103,3,FALSE) Vlookup Function (Open Interim Assessment file) S3 =vlookup($a3,'2010 Interim'!$A$5:$H$118,4,false) T3 =vlookup($a3,'2010 Interim'!$A$5:$H$118,6,false) U3 =vlookup($a3,'2010 Interim'!$A$5:$H$118,8,false) Accountability Reports on Principal Portal 75 Accountability Reports on Principal Portal Lowest 25, 35, 45

Bubble Gains Regress Reading Reading Reading Reading Math Math Math Math Other Reports on Principal Portal Interim Assessments FCAT 1 2 Missing Intensive Course Others Reading Reading Graduation Math Math

Dual Enrollment Top 45 for Grade 11 Science Accountability Reports on Principal Portal 78 Data Elements No. Variable Name No. Variable Name 1 Student_ID 12 Most_Recent_FCAT_DSS_Score 2 Name 13 Prior_FCAT_Grade 3 Gain 14 Prior_FCAT_Level 4

Bubble 15 Prior_FCAT_Scale_Score 5 Regress 16 Prior_FCAT_DSS_Score 6 Sur2_Schl 17 AYP_Ethnic 7 Sur3_Schl 18 LEP_code 8 Rank 19 LF___2_YR 9 Most_Recent_FCAT_Grade 20

LEP_Entry_Date 10 Most_Recent_FCAT_Level 21 SPED_EXCP 11 Most_Recent_FCAT_Scale_Score 22 Lunch_Code Y Gain (Annual Learning Gains) N Bubble P Possibility to be at the next level N Neutral R Risk to decline the level Ranking: Percentile Ranking based on DSS 0-25

26-35 36-45 45-100 Export Accountability Report Export file: csv format Formatting csv file Principal Accountability Report School Grade Export Data Print View Report Sample Data CSV file on Principal Portal Student_ID,Name_1,Gain,Bubble,Regress,Sur2_Schl,Sur3_Schl,Rank,Most_Recent_FCAT_Grade,Most_Recent_FCAT_Level_1,Most_Recent_FCAT_Scale_Score_1,Most_Recent_FCAT_DSS_Score_1 ,Prior_FCAT_Grade_1,Prior_FCAT_Level_1,Prior_FCAT_Scale_Score_1,Prior_FCAT_DSS_Score_1,AYP_Ethnic,LEP_code,LF___2_YR,LEP_Entry_Date,SPED_EXCP,Lunch_Code 0295084,TROUTMAN OCTAVIUS, ,,,,,,,,,,05,3,296,1571,B, ,,,,F 5423900,SOSSOUS ASHLEY, ,,,3621,3621,,,,,,05,1,242,1269,B,LF,,09/11/02, ,F 0337063,CORNEJO OSCAR, ,R, ,3621,3621,0,06,1,100, 539,,,,,H,LY,,08/24/09,, 0684797,MANZANO ALEJANDRO,N,N,R,3621,3621,1,06,1,168, 916,05,1,202,1045,H,LF,,08/27/02,V,F 8802862,CANNON JESSICA,N,N,R,3621,3621,2,06,1,175, 955,05,1,247,1297,B, ,,, ,F 9986821,QUINN VERSHAE,N,N,R,3621,3621,4,06,1,196,1071,05,1,219,1140,B, ,,, ,F 9914080,TARPLEY CARTIONNA,N,N,R,3621,3621,5,06,1,206,1127,05,1,255,1341,B, ,,,,F 9452054,AVILA BRYAN,N,N,R,3621,3621,6,06,1,207,1132,05,1,233,1218,H,LF,,09/17/01,G,F 0298825,FRANCO ANGELICA,N,N,R,3621,3621,7,06,1,210,1149,05,1,246,1291,H, ,,,,F 0660391,POWELL JOSHUA,N,N,R,6761,3621,8,06,1,219,1199,05,2,279,1476,B, ,,,K,F 8760739,BRUNO EDNER,N,N,R,3621,3621,8,06,1,221,1210,05,1,217,1129,B, ,,, , 0111261,WATKINS MITCHELL,N,N,R,3621,3621,9,06,1,223,1221,05,1,235,1229,B, ,,, ,F 0001177,VIRGIL JONATHAN,N,N,R,3621,3621,11,06,1,226,1238,05,1,240,1257,B, ,,,,F 8808018,STRACHAN JUSTIN,N,N,R,3621,3621,12,06,1,231,1266,05,1,246,1291,B, ,,,K,F

9841490,VAZQUEZ JACQUELINE,Y,N,N,3621,3621,14,06,1,236,1293,05,1,182, 933,H, ,,, ,F 6506648,LEON TASHONDA,Y,N,N,3621,3621,15,06,1,240,1316,05,1,220,1145,B, ,,,K,F 9919240,PHILLIPS TEDEISHA,Y,N,N,3621,3621,16,06,1,242,1327,05,1,198,1022,B, ,,,,F 9837140,HOLLINGSWORTH TYLER,N,N,R,3621,3621,17,06,1,244,1338,05,2,262,1381,W, ,,,F,F 5833878,NORTON SHOINTAVIA,N,N,R,3621,3621,18,06,1,245,1343,04,1,251,1179,B, ,,, ,F 6284252,FENELON TERRY,N,N,R,3621,3621,18,06,1,245,1343,05,2,278,1470,B, ,,,,F 0199940,WILLIAMS JEROME,N,N,R,6081,6081,20,06,1,247,1354,05,1,237,1241,B, ,,,,F 0738362,ANDRADE ALDO,N,N,R,3621,3621,22,06,1,248,1360,05,1,241,1263,H,LF,,08/29/02,,F 0183160,JARRETT SHAWN,N,N,R,3621,3621,23,06,1,252,1382,05,2,260,1369,B, ,,,,F 7447750,CHIBANGUZA RUFARO,Y,N,N,3621,3621,23,06,1,250,1371,05,1,233,1218,B, ,,, , 6989357,ROBERTS SHADAISHA,N,N,R,3621,3621,24,06,1,255,1399,05,1,243,1274,B, ,,, ,F 8510605,MESA HUMBERTO,N,N,R,3621,3621,24,06,1,255,1399,05,2,284,1504,H,LF,,09/03/02,V, 84 Formatting CSV file (Open 2010 FCAT.csv) Highlight Column A Select DATA menu Select Text to Columns. The window convert text to Column Wizard Step 1 of 3 will appear. Click Next Step 2 of 3 window, select comma only Click Next Formatting CSV file, Step 3 of 3 Select appropriate Column data format Click on Student_ID and select Text format Click on Sur2_Schl and select Text format; do the same for Sur3_Schl Scroll to the right to select Most Recent FCAT Grade and select Text format Click Finish Independent Assignment

1. Add the 3 interim assessment results to 2011 data file 2. Save the file name as IW-your employee ID-Last Name Example IW-123456-Wongbundhit 3. Send the file to [email protected] 88

Recently Viewed Presentations

  • Improving the user experience for University of Worcester

    Improving the user experience for University of Worcester

    We also decided to brand our website as worc.ac.uk/library, rather than libguides.worc.ac.uk, again for clarity. Creating content for the webpages was the most challenging aspect for the department. It meant a radical change in thinking about how best to present...
  • Cultural Influences on Cognitive Development Guided Participation Adults

    Cultural Influences on Cognitive Development Guided Participation Adults

    e.g., N G O H P I Q J ? Phase Two: How well do the children do in solving more challenging letter completion problems? e.g., U C T D S E R F ? Findings: Children who needed fewer...
  • The Human Body System - White Lake School District

    The Human Body System - White Lake School District

    The Human Body Systems By the Fourth Grade Computer Class ... When you were born, your skeleton had around 350 bones. By the time you become an adult, you will only have around 206 bones. This is because, as you...
  • Transfer Pricing Course - Universitas Indonesia

    Transfer Pricing Course - Universitas Indonesia

    Mampu mengembangkan filosofi teori akuntansi baru melalui riset, hingga menghasilkan karya ilmiah yang original, teruji dan kontributif. Mampu mengambil keputusan atas berbagai pilihan riset akuntansi yang bersifat holistik dengan pendekatan interdisiplin, multidisiplin, transdisiplin,dan atau multiparadigma.
  • Chapter 17 - from gene to protein

    Chapter 17 - from gene to protein

    Chapter 17 - from gene to protein. The information content of genes is in the form of specific sequences of nucleotides along the DNA strands. The DNA of an organism leads to specific traits by dictating the synthesis of proteins...
  • Partners in Practice: Archivists and Researchers ...

    Partners in Practice: Archivists and Researchers ...

    Partners in Practice: Archivists and Researchers Collaboratively Improving Access to Health CollectionsProcessing Collections with Protected Information: A Comparison of HIPAA and Non-HIPAA Covered EntitiesEmily R. Novak Gustainis, Head, Collections ServicesCenter for the History of Medicine, Countway Library, Harvard Medical [email protected]
  • 2020 Census - Northampton County, Pennsylvania

    2020 Census - Northampton County, Pennsylvania

    2020 Census Goals. Goals. To count everyone once, only once, and in the right place. What's New. We're maximizing outreach by using both traditional and new media. We're offering and encouraging people to use the secure online response option. We're...
  • Presented by Wanda Pagonis wpagonis@gmail.com UTHSCSA, I.N.Q ...

    Presented by Wanda Pagonis [email protected] UTHSCSA, I.N.Q ...

    Presented by Wanda Pagonis Lytle ISD PositivelyAging®/M.O.R.E. 2007© The University of Texas Health Science Center at San Antonio Objective 1: Students will identify parts of a ramp. Move granny up and down varying ramps to observe the effect of slope...