Michigan Accountability Data Tools

1. Michigan Accountability Data Tools February 1, 2013

2. Learning Targets • I can use data tools developed by MDE related to school improvement, school rankings, and accountability to understand state level data and use it to ensure students’ needs are being met. • I can facilitate discussions around the tools and data with building staff as a part of the ongoing school improvement process.

3. Agenda • Top-to Bottom Individual School Look-Up Tool • Individual Focus School Look-Up Tool • Identifying Your Top and Bottom 30% • Accountability Scorecard/The Future of AYP and EdYES! • Favorite IGOR Reports

4. Michigan Accountability SystemsTTB, Priority, and Focus Or: Where does THAT number come from???

5. Flexibility Waiver MDE applied for “waivers” from certain requirements under the No Child Left Behind act (ESEA). Approved in July, 2012 Went into effect immediately http://www.michigan.gov/documents/mde/ESEA_Flexibility_Request_FINAL_377829_7.pdf

6. MDE Flexibility Waiver • Three Principles • Principle 1: College- and Career-Ready Expectations for All Students • Principle 2: State-Developed Differentiated Recognition, Accountability, and Support • Principle 3: Supporting Effective Instruction and Leadership

7. Principle 2: Accountability Accountability & Support • Top to Bottom Ranking given to all schools with 30 or more students tested, full academic year (0 – 99th percentile where 50th is average) • NEW Designations • Reward schools (Top 5%, Significant Improvement or Beating the Odds) • Priority schools (Bottom 5%, replaces PLA list) • Focus schools (10% of schools with the largest achievement gap between the top and bottom) • NEW in 2013, AYP Scorecard based on point system and a system of color-coding.

8. How is data used to determine the TTB List? • Top-to-Bottom ranking of schools • Student Achievement, Using scale scores, not proficiency cuts • Improvement in Achievement and Graduation Rate over time • Achievement gap between top scoring 30% of students and bottom scoring 30% of students • Ranking applies to all subjects tested in the school (not just mathematics and reading)

10. Standard Deviation and z-scores • Z-scores are centered around zero or the “state average” • Positive is ABOVE the “state average” • Negative is BELOW the “state average”

11. Pop Quiz! If your gap z score is a negative number, are you above or below the average? If you z score is .3, are you above or below average?

12. MDE Web Site: Data Tools • What is the data for my school related to the TTB list? • Search for “MDE Top to Bottom” • Click on: 2011-2012 Top-to-Bottom Individual School Lookup Tool with School Data • Other documents to check out: • At a Glance Overview • Priority and Focus (Title I) Set-Asides

13. How Is the Top to Bottom Ranking Calculated? Two-Year Average Standardized Student Scale (Z) Score School Achievement Z-Score 1/2 Two-Year Average Performance Level Change Index School Performance Level Change Z-Score Content Index Z-score School Content Area Index 1/4 Two-Year Average Bottom 30% - Top 30% Z-Score Gap School Achievement Gap Z-Score 1/4 • For grade 3-8 reading and mathematics

14. Weighted Performance Level Change (PLC) • A weighted composite of individual student performance level change is used to calculate improvement in grades 3-8 reading and mathematics • Rewards large improvements more heavily, rewards maintenance of proficiency if a student was already proficient

15. Chew . . .

16. MDE Web Site: Data Tools • What is the data for my school related to the “Gap?” • Search for “MDE Focus Schools” or click the Focus button on the Priority page • Click on: Individual Focus School Lookup Toolto download the data file and see your gap data. • Other documents to check out: • At a Glance Overview • Facts and Figures document

17. Are All Focus Schools High Achieving? • From MDE’s Focus Schools Page: • Click on 2011-2012 Focus Schools Facts and Figures

18. Distribution of Focus Schools

19. Chew . . .

20. What are the Details of my Bottom 30%? • Login to the MI School Report Card Web Site • https://oeaa.state.mi.us/ayp/login.asp • On the “School” level report card page, Click on: • “Request student data for … (your school)” • Download Michigan School Report Card Student Data File Tool

21. Who are my Bottom 30%? • From the Report Card Site • you will need your Report Card Student Data File: https://oeaa.state.mi.us/ayp/guide.asp • On the MDE Focus Schools page • Click on Tool for Identifying Bottom 30% Students for School Use • Click on How to Filter your AYP Student Data File to Identify Bottom 30% Students • And follow the directions!

22. Here are the Directions • Enable Filters • Click Data, then Filter • Column T: Set to True • Column Z and AA: choose your district/building code • Columns AH and AI: Set FAY to True • Now sort any of columns O through S by: • 1 – Top 30% • 2 – Middle 40% • 3 – Bottom 30% • To see names of students for each content area by “gap” group

23. Chew . . .

24. Accountability Scorecards An Early Orientation to the Future of Michigan School Accountability

25. Background Information • Michigan applied and was approved for ESEA flexibility for 2012-13 school year and onward. • MDE worked extensively with stakeholder groups and negotiations with USED to determine necessary changes and a new direction for Michigan’s School Report Cards. • The preliminary and public accountability results for the 2012-13 school year will look and feel brand new but have familiar pieces and parts. • The new report cards will be known as the: “Michigan School Accountability Scorecards”

26. Logistics • Preliminary Scorecards for2012-13 will reside on the newly-redesigned BAA Secure Site (set to launch July 2013). • Users will have to be authorized and login to the site using their MEIS account. • Permissions to view the report cards will be handled in the district. • Any appeals to the preliminary scorecards will be handled through the new BAA Secure Site, similar to previous years. • Public Scorecards will reside on MISchoolData.org with the other accountability designation results such as the Top-to-Bottom Rankings.

27. Overview • Two “levels” of Accountability Scorecards: DistrictScorecards & SchoolScorecards • Scorecards will use a color coding system (green, lime, yellow, orange, and red) to indicate school performance. • Combines traditional accountability metrics with Top-to-Bottom labels and other state/federal requirements. • Overall STATUS color in the top right corner is determined by Top to Bottom status as well as points earned by meeting traditional AYP requirements. • Individual “cells” use red/yellow/green coding scheme • Points-based system where full points earned for meeting a target, half points earned for meeting safe harbor

28. An Early Look at Scorecards

29. Color-Coded Scorecards • Colors are given to schools and districts for each “scorecard component” and an overall color. • Overall status color is determined using a point-based system from the number of target areas the school/district has met and the school ranking. Decreasing # points received and increasing # targets not met… *These may not be the exact shades utilized in the final scorecard product (still under development).

30. What Changed? • Additional subgroup: Bottom 30% • Attendance target of 90% -(only for school, no subgroups) • Differentiated proficiency targets • Based on a school’s past performance • Goal of 85% proficient for all subjects at end of 2021-22 • Targets increase in 10 equal increments • Safe Harbor based on 80th percentile of statewide proficiency • Use school/district improvement slope to determine met/not met • Inclusion of Educator Effectiveness label reporting and TSDL completion in Scorecards • Inclusion of Compliance Factors (SIP & SPR)

31. Most of the nuts and bolts of AYP have remained the same!

32. What Stayed the Same? • Participation requirement = 95% for school/district overall and all valid subgroups • Multi-year averaging remains in place (up to three years) • Graduation requirement = 80% for school/ district overall and all valid subgroups • Four, five, and six-year rates • Graduation “safe harbor” • Use of provisional and growth scores for accountable proficiency rates

33. School and District Scorecard Subgroups Previously ONE group! • All Students • Bottom 30% (for proficiency calculations only) NEW! • American Indian or Alaska Native • Black or African American • Asian NEW! • Native Hawaiian or Pacific Islander NEW! • White • Two or more races • Hispanic of any races • Economically Disadvantaged • English Language Learners • Students with Disabilities • Shared Education Entity (SEE) (district-level only)

34. Participation • 95% of students are still required to be tested to meet the assessment participation target for the scorecard. • If student group size is 30-39, target is no more than two non-participants (this makes it so that a single student cannot result in not meeting the target participation rate). • If student group size is 40 or more, target is 95% participation • Participation rate is rounded to nearest hundredth • If the “All Students” group does not have at least 30 students in one test cycle, a participation average will be calculated using up to three years of data in order to accumulate at least 30 students • Multi-year averaging used help meet the participation requirement

35. Participation Target • Two options for school/district color status for this target area. 95% Assessed Met 95% Assessed Not Met • These colors are given ONLY on the participation target portion of the scorecard. This does not change your entire school/district status, however, it can impact your overall color.

36. Proficiency Targets Targets are based on 2011-12 proficiency rates: • (85 – current percent proficient) / 10 = annual increment • Increments do not reset • Proficiency targets are set using PLs 1 & 2 only (not Provisional or Growth Proficient) • Provisional and/or Growth Proficient willhelp you meet targets

37. Example Proficiency Targets School has 65% proficiency in 2011-12 school year. School must be 85% proficient by 2021-22 school year. Subtract baseline target from end target rate and divide by the number of school years in between. (85 – 65)/10 = +2% annual increment of target The school’s target would be 67% in 2012-13, 69% in 2013-14, 71% in 2014-15, and so on.

38. Proficiency Targets Example Example school ends at (at least) 85% proficient in subject Example school starts from 65% proficient in subject Example School has +2% Annual Target

39. Multi-year Proficiency Calculations Multi-year weighted proficiency averages are used in cases where a single year’s proficiency rate is not meeting the school’s target Weighting is based on the school’s assessed enrollment in each year Up to three years are used in this sequence: 1. Calculate single year proficiency rate. Go to 2 if target is not met. 2. Calculate weighted two year proficiency rate. Go to 3 if target is not met. 3. Calculate weighted three year proficiency rate. Go to 4 if target not met. 4. Calculate Safe Harbor. If not met, cell is red (0 points).

40. Proficiency “Cell” Basics All valid subgroups will have a proficiency cell with possible points Districts will potentially have a SEE subgroup if they are a SEE member district with at least 30 FAY SEE students Schools and districts will always have an “All Students” group, even with one FAY student All assessed content areas will have cells (Reading, Mathematics, Writing, Science, and Social Studies)

41. Proficiency Cell Colors and Points Green cells are worth two points and are earned by meeting the school’s or district’s proficiency target Yellow cells are worth one point and are earned by meeting the Safe Harbor target (instead of meeting the proficiency target) Red cells are worth zero points and are earned by not meeting proficiency or Safe Harbor targets The Bottom 30% subgroup will earn a green cell and two points by meeting the Safe Harbor target

42. “Accountable Proficient” versus Proficient Students considered proficient are… vs. For ‘True Proficiency’ purposes: • Performance Level 1 or 2 For ‘Accountable Proficiency’ purposes: • Students must attain a performance level of 1 or 2 –OR– • Students must attain a scale score that is within 2 standard errors of the proficient cut score (provisionally proficient). –OR– • Students must demonstrate growth at a rate that will allow them to reach proficiency in three years (growth proficient).

43. “Accountable Proficient” versus Proficient Considerations: • Provisional proficiency and growth proficiency are helpful in meeting proficiency target rates but do not match your MEAP/MME raw reports and MISchoolData. • Proficiency rates in MISchoolData and on MME/MEAP reports will also be different from accountable proficiency rates because the accountable rates only reflect Full Academic Year (FAY) students at the appropriate feeder schools.

44. Full Academic Year (FAY) • Students that were present in the building for the last: • 2 count days + student in end-of-year collection (Elem/M.S.) • 3 count days + student in end-of-year collection (H.S.) • Only FAY students can count toward a school or district’s proficiency rates for accountability purposes. • Limits the impact of student transiency on accountability. • Ensures that only students that have been educated by the school/district count for proficiency.

45. 1% and 2% Caps & Alternate Assessments • 1% MI-Access • 1% Automatic Cap • +1% Additional (with waiver and appeal) • 2% MEAP-Access • 2% Automatic Cap • Assessment participation is never capped in either brand of alternate assessments.

46. Graduation Rates 3 Possible colors to receive for this target area: • If a school/subgroup has a graduation rate of at least 80%, it will receive a green cell (2 points). • If it makes the graduation rate improvement target, it will receive a yellowcell (1 point). • If it misses both the rate and the improvement target, they will receive a red cell (0 points). Audit: • A school/district’s overall status color is automatically yellow if it has a red for the “All Students” group for this target.

47. Attendance Rates 3 Possible colors to receive for this target area: • If a school meets the attendance target, it will receive a green cell (2 points) for attendance rate. • If a school meets the attendance improvement target, it will receive a yellowcell (1 point). • If it misses the attendance target, they will receive a redcell (0 points). Audit: • A school/district receiving a red indicator for attendance cannot have an overall color ranking better than yellow.

48. Educator Evaluations (NEW!) • Educator Evaluations are based on State law. All of Michigan’s educators will be evaluated using measures of student growth and the results of these evaluations will be reported into MDE’s data systems. • Educator Evaluations will be reported as “In Good Standing” or “Not in Good Standing” based on compliance with State law. • Two components make up the Educator Evaluations section • Effectiveness Labels Completion rate (100% target) • TSDL Student Inclusion rate (95% target) • 2 Possible colors to receive for this target: • Those in good standing will receive a green cell. • Those not in good standing will receive a red cell.

49. Compliance Factors (PARTIALLY NEW!) • Compliance Factors are based on State law. All schools are required by State law to have a School Improvement Plan (SIP), and to complete School Performance Indicator (SPR)reports. • If a school completes all of its required reports it will receive a green cell for the Compliance Factors. If a school does not complete its required reports, it will receive a red cell for Compliance Factors. • 2 Possible colors to receive for this target: • Those with completed reports receive a green cell. • Those with incomplete reports receive a red cell.

50. The Point-Based System for Overall School/District Color Status • Target areas on the Accountability Scorecard are worth points that contribute to your school or district overall status color. • In general, meeting a target will yield 2 pts or the full point value. • Meeting a target through safe harbor or improvement will yield 1 point or half the point value (NOT true for Ed Evals and Compliance Factors targets) • Not meeting a target will yield 0 points. • We determine the school/district’s % points received and apply it the color scale: