1 / 38

Kentucky’s School Report Card and Spreadsheets

Kentucky’s School Report Card and Spreadsheets. 2014 Workbook. Free Powerpoint Templates. Spreadsheets for Profile, Accountability, Assessment, Learning Environment and Delivery Targets for 2011-12,12-13 and 13-14 are located under the Data Sets tab.

rafael-mann
Download Presentation

Kentucky’s School Report Card and Spreadsheets

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. Kentucky’s School Report Card and Spreadsheets 2014 Workbook Free Powerpoint Templates

  2. Spreadsheets for Profile, Accountability, Assessment, Learning Environment and Delivery Targets for 2011-12,12-13 and 13-14 are located under the Data Sets tab.

  3. Learning Environment tab shows school/district details and demographics. Profile tab shows basic school/district information/location. Assessment tab shows data for all students tested on all assessments. NEW Finance tab shows district level finances. Accountability tab shows all five categories of Next- Generation Learners with data based on 100 day students. NEW Career and Technical Education tab shows program information. NEW Program Review tab shows all categories of Program Reviews for each school. Delivery Targets tab has targets for improvement.

  4. Accountability Tab Accountability Profile Tab click click

  5. NEW NEW

  6. Accountability Profile Discussion Points • What is our overall score? • What is our percentile rank? (Remember this is a percentile not a percentage.) • What is our distance from the Overall Score associated with proficiency (70th percentile) and AMO for 2015? • What is our Classification? Do we have a Rewards or Assistance Category? • Are we where we want to be?

  7. Accountability Tab Learners Tab click Weighted Score comes from Achievement, Gap, Growth, College/Career Readiness and Graduation Rate Points multiplied by the weights each has in Learners. Weighted Score Summary adds the Weighted Scores for each area. Opening page on Learners shows the five category tabs: Achievement, Gap, Growth, CCR and Graduation Rate. It opens automatically on the Achievement tab.

  8. Learners Questions • Looking at the five categories, generalize what is seen. • Looking at the weighted score, in which category do we score the lowest? Why? • Looking at the weighted score, in which category do we score the highest? Why? Note: After identifying the category with the lowest weighted score, the next step is to click on the tab identified and drill down with further questions for each category.

  9. Accountability - Learners Tab - Achievement Tab

  10. Accountability - Learners Tab - Achievement Tab - Grade Level Breakdown After picking a subject area, you can click on the specific grade levels to view further breakdown of the data. Use this to compare performance level by groups of students. Remember: 1) Novice, Apprentice, Proficient, Distinguished(NAPD) Calculation comes from the formula: N=0; A=.5; P/D=1(Bonus of .5 is added if there are more distinguished than novice.) 2) Points come from the NAPD Calculation multiplied by the equal weight of content areas: Reading, Mathematics, Science, Social Studies are 20% and Writing/Language Mechanics is 20% (Writing 16% and Language Mechanics 4%) 11

  11. Achievement Questions • Which NAPD performance level shows the lowest percentage of students for reading, mathematics, etc.? • Which performance level shows the highest percentage of students for reading, mathematics, etc.? • What can we do to increase P/D while reducing N/A? (e.g., instructional strategies, increasing teacher training and professional development) • Do any particular subgroups stand out as needing improvement more than others? (sample shows highest percent novice are students with IEPs)

  12. Accountability – Learners – Gap

  13. Accountability – Learners – Gap – Subject Breakdown Remember: 1). NAPD Calculation for Gap comes from the percent of Proficient/Distinguished only in the Non-duplicated Gap Group. 2). Points come from the NAPD Calculation multiplied by the equal weight of content areas: Reading, Mathematics, Science, Social Studies being 20% and Writing/Language Mechanics 20% (Writing 16% and Language Mechanics 4%).

  14. Gap Questions • In what content area are Gap studentsmost challenged? • In what content area are Gap studentsmost successful? • In what content area do we have the largest percent of P/D performance? • How are we identifying our Gap students? • By subject area, drill down to see areas for improvement and how we compare in the district/state.

  15. Accountability – Learners– Growth Reminder: Growth Points Total comes from average of Reading Percent and Mathematics Percent of students making typical annual growth (at or above the 40th Student Growth Percentile).

  16. Growth Questions • Typical Growth is at the 40th percentile; what percentage of our studentsare not there in reading? Mathematics? • Which subject has the highest Growth? • What do Growth percentiles look like for students who scored Distinguished or Novice? (Refer to spreadsheet and student listing, to identify specific students.) • What can we do to improve Growth for students below the 40th percentile? (Refer to spreadsheet and student listing, to identify specific students.) • How does our school/district compare to Growth in other schools/districts?

  17. Accountability – Learners – CCR – Student Breakdown Remember: Percentage of graduates College and/or Career Ready shows non-duplicated totals for a school. Bonus is added, if applicable.

  18. CCR Questions • What are the criteria for the 3 categories – college, career or both? • How many students were determined college ready? Career ready? Earned Bonus? • How do we compare to other schools in the district/state? • What is the college/career readiness percentage for specific student groups within our school? What are the implications for instruction and curriculum? • Knowing what it takes to be CCR, look at ACT performance of current seniors. What can we do to get more students ready? Are we using COMPASS/KYOTE?

  19. Graduation Rate Reminder • The Five-Year Adjusted Cohort graduation rate data are used in the 2013-14 calculation for the Graduation Rate component (20% of high school Next-Generation Learners). • The Four-Year Adjusted Cohort graduation rate will be used to evaluate whether a school met its graduation rate goals. The graduation rate goals for 2013-14 were set using the Four-Year Adjusted Cohort.

  20. Accountability – Learners– Graduation Rate – Cohort Information Past cohort data can be accessed here.

  21. Graduation Rate Questions • How does our Graduation Rate compare to other schools in our district? In the state? • What type of interventions can be provided to increase student completion and persistence to graduation? • Comparing Graduation Rate (cohort) to the disaggregated data presented on the Accountability Tab: Which groups of students had the lowest graduation rate? What strategies might improve lower group rates?

  22. Key Points for Program Reviews • Data are presented by school level (elementary, middle and high) and aggregated for the district and state. For example, a K-8 school will have both an elementary and middle school score. • Only data from A1 schools are aggregated for districts and the state. • Data presented are consistent with the Program Review rubrics.  If a school entered a characteristic score that was not required, the data have been removed. If a school entered not applicable (n/a) on a required characteristic, the n/ahas been changed to a score of 0.

  23. Accountability – Program Review Accountability

  24. Program Review Questions • Which Program Review and standard is lowest this year? • Which Program Review is the highest? What are we doing to achieve this score? • Look to the future: Which area of K-3 is the lowest? • What can be done to raise the K-3 score for 2014-15?

  25. Assessment Tab Assessment tab offers data for tested students on state-required and other tests (i.e., Advanced Placement and NAEP).

  26. Assessment – State Required Tests – K-PREP – Middle School - 07 Under the Assessment tab you will pick either State-Required Tests or Other Tests. With the test of interest , select the disaggregated data you want to review. Clicking on the grade level breaks it down into groups. (Any spot with a triangle that is underlined is a link to disaggregated data.)

  27. Assessment – State-Required Tests – K-PREP – Middle School - 07 Use data found here to compare particular groups, to find high/low performing groups or to help identify where your school/district might want to add more focused attention. For individual student information, refer to the KDE-provided spreadsheets. For reporting category information from Pearson assessments, see School Summary Reports in PearsonAccess.

  28. Assessment – State-Required Tests – K-PREP End-of-Course End-of-Course data is broken down by subject, all students and by groups of students (M/F, ethnicity, free/reduced, etc.).

  29. Assessment – State Required Tests – ACT/ACT Plan/ACT Explore Shown are the average scores and percent meeting each set of benchmarks. Then, use spreadsheets to find individual student information.

  30. Assessment – Other Tests – Advanced Placement or NAEP Advanced Placement data is loaded as it becomes available from the vendor. NAEP data is general state level information, never school or student level.

  31. Delivery Targets –Proficiency/Gap Tab Gap is located at the bottom when you drill down to all students

  32. Delivery Target Questions (Proficiency/Gap) • Comparing Proficiency Rates to the disaggregated data on the Accountability Tab: Which subjects have the lowest performance rates and for what grade levels? • Drill down by subject and school level: Which gap groups have the lowest proficiency rates? • What are you doing to close these achievement gaps?

  33. Delivery Targets – CCR Tab

  34. Delivery Target Questions (CCR) • CCR delivery targets are calculated using the CCR total without a bonus. Considering your school/district scores, where have you made gains (e.g., college ready or career ready)? • Similarly, in order to meet future targets, where is there room for greatest growth (e.g., college ready or career ready)? • Considering 1) the demographic distribution of students in your schools and 2)the disaggregated CCR outcomes presented on the Accountability Tab, which student groups appear to have lower success rates?

  35. Finance Tab

  36. Finance Tab • Includes district level data only. • Data are extracted from the Superintendent's Annual Attendance Report (SAAR), MUNIS via the Annual Financial Report (AFR), SEEK System, Tax Reports, and Professional/Classified Staff Data (PSD/CSD) files. 

  37. Career and Technical Education Tab Career and Technical Education data to populate the new tab.

More Related