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