Transcript Slide 1
Do You Have Processes in Place to Help You Calculate Accreditation and Track Historical AYP Data? Presenters: Barry Kavy, VATD Board Dr. Paulette France, Virginia Beach City Public Schools October 28, 2009 Comparison of Accreditation and AYP Benchmarks Accreditation Benchmarks AYP Benchmarks Performance Participation Other Academic Indicator (ES/ MS): Attendance Other Academic Indicator (HS): Graduation Rate Other Academic Indicators for ES/MS: Writing, History, or Science Reading 81% 95% Math 79% 95% OAI 94% 61% 70% AYP Ratings 2009-2010 based on 2008-2009 Data • SOA and AYP 2009-2010 Ratings rules 010212009.doc Comparison of Accreditation and AYP Handout Subgroups Participation vs. Performance Recovery vs. Retest Substitute Tests VGLA/VAAP/VSEP Comparison Chart • AYP Accreditation Requirements Chart 10-2109.xlsx Summary of 2008-2009 SOL Scores for Preliminary Determination of Accreditation Accreditation Templates - Based on 2008-2009 Calculations - Locked File.xlsx AYP Historical Chart AYP DB blank.xlsx Data tabs setup VIRGINIA DEPARTMENT OF EDUCATION, Adequate Yearly Progress (AYP) (row 2) 2009-2010 Results Based on 2008-2009 Test Data (row 3) This report shows 2009-2010 Results based on 2008-2009 Test Data. It is copied into cell B1 on the 0809 Data tab. Be sure formulas in column A are copied down for every line of data. Schools tab setup From the most recent data report, copy the first two columns, School Number and School Name. Paste them into cell G1 on the Schools tab. Sort by the School Name column, column H. Schools appear alphabetically in column B. In the HS column, column D, mark high schools with a "Y". Open the Name Manager from the formulas tool bar. Be sure the area named 'Schools' includes all schools in column B. This named region, Schools, is used for the drop down menu on the Report tab. Using the Report tab Cell A1 has a drop down menu of all the schools. To show the list, click in cell A1 then click the arrow that appears. Select a school to produce that report. Assessment Record Review and Change Request Web Application System (ARRCRWAS) User’s Guide for the ARRCRWAS http://www.doe.virginia.gov/VDOE/Assessment/home.shtml The Guide Assessment Record Review and Change Request Web Application System (ARRCRWAS) https://p1pe.doe.virginia.gov/ssws/ Kavy France ES Jackpot…we have data!