skip to main content
Power BI
    • What is Power BI
    • Why Power BI
    • Customer stories
    • Data visuals
    • Security
    • Power BI Desktop
    • Power BI Pro
    • Power BI Premium
    • Power BI Mobile
    • Power BI Embedded
    • Power BI Report Server
  • Pricing
    • Azure + Power BI
    • Microsoft 365 + Power BI
      • Energy
      • Healthcare
      • Manufacturing
      • Media
      • Retail
    • For analysts
    • For IT
      • Overview
      • Embedded analytics
      • Power BI visuals
      • Automation
      • Documentation
      • Community
    • Overview
    • Find consulting services
    • Partner showcase
    • Find a partner
    • Become a partner
    • Instructor-led training
    • Getting started
      • Overview
      • Online workshops
      • Self-guided learning
      • Webinars
      • Documentation
      • Roadmap
      • Overview
      • Issues
      • Give feedback
    • Blog
    • Business intelligence topics
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • Events
    • User groups
    • Community blog
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Galleries
    • Community Connections & How-To Videos
    • COVID-19 Data Stories Gallery
    • Themes Gallery
    • Data Stories Gallery
    • R Script Showcase
    • Webinars and Video Gallery
    • Quick Measures Gallery
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Events
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Microsoft Power BI Community
    • Galleries
    • Data Stories Gallery
    • Ohio Primary and Secondary Education Performance

    Ohio Primary and Secondary Education Performance

    10-02-2016 11:09 AM - last edited 12-05-2016 10:51 AM

    Super User Greg_Deckler
    Super User
    11052 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    Greg_Deckler
    Super User Greg_Deckler
    Super User
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    Ohio Primary and Secondary Education Performance

    ‎10-02-2016 11:09 AM

    My oldest sister Laurie is a superintendent for an Ohio school district and she sent me data about all of schools and school districts in Ohio. Ohio uses a system of 16 different measures of school performance. To understand more about the different metrics used in Ohio, go here. The data presented in this report came from my sister Laurie, which originally received the data from the State of Ohio. Additional information was added to this, such as the revenue spent per pupil, which came from the Ohio Department of Education's website here.

     

    The data as provided was challenging to work with in a number of ways. Achieving the desired capabilities required merging various tables of data together, specifically for the District Comparison report to function properly. Additionally, the raw data provided for the rankings of the measures were in a format of A-F grading as well as a number of "NR" designations, meaning that certain schools and districts were not measured on that particular category. In order to create meaningful insights into the data, these letter grades were translated to numeric values 0-5 (A=5, B=4, C=3, D=2, F=1, NR=0). This allowed trends and calculations to happen on these measures of school performance. However, care was necessary to exclude NR (0) values from the calculation of averages, etc. This conversion also allowed the creation of an overall measure that averaged the 16 measures into a single value. Once these numeric translations and calculations were made, additional work was required in order to translate these calculated values back to the A-F ranking system used by the State of Ohio.

     

    Page 1, Ohio Overall, presents a snap shot of all school performance in the State of Ohio with the ability to filter using the county map in the lower left corner. The coloring of the county map is based upon the calculated measure of overall school performance with teal being better and pink being worse. This page also displays overall information on the amount of money spent per pupil, the number of districts, schools (buildings), students, % poverty and % minority.

     

    Page 2, District Comparison, is a tour de force in the ability to edit visual interactions. Color coding has been added to provide the user a visual cue as to what slicers affect which visuals. This report was designed to allow educators to find districts that are similar in classification and poverty level as their own and is specifically designed to identify outliers that significantly overperform based upon their classification. By identifying overperformers, it is hoped that other educators can learn what these overperformers are doing well that they are not and thereby facilitate learnings by school administrators that will ultimately benefit students in lower performing districts. The way that overperforming districts are identified is through simple calculations involving standard deviation. By translating the letter grades to numeric grades and creating the overall measure of school performance, it is possible to calculate the average (mean) of that value as well as its standard deviation. By subtracing this mean from a school district's overall score and then deviding by the standard deviation, a number is calculated that is that school district's number of standard deviations above or below the mean. School districts with higher, positive numbers are overperforming districts and those with lower, negative numbers are underperforming.

     

    Page 3, District Buildings, provides administrators with a snap shot of individual district and school performance similar to page

     

    Page 4, Trends and Correlations, provides interesting insights into the relationship of overall performance with respect to things like % poverty, % minority, revenue per pupil and enrollment. Some specific insights include:

    • % Poverty and overall performance appear to be strongly correlated. The higher the poverty within a district, the lower the test scores. This appears to contradict Ohio's state regulators who claim that poverty is factored into school rating scores. If poverty is indeed factored into the scoring, it is perhaps not factored in enough
    • Revenue per pupil does not appear to have a meaningful effect on school performance. If any correlation can be drawn, it must be concluded that greater revenue per pupil actually negatively affects student performance. This can most clearly be seen with "Urban" schools
    • There is a potential correlation between % Minority and overall school performance
    • There is a potential correlation between the number of students enrolled and overall school performance
    • Unlike "Small Town", "Suburban" and "Urban" schools, "Rural" schools do not show a correlation between % Minority and % Poverty
    • Revenue per pupil has increased steadily from 1995-2012 (latest year data was available) with an odd spike in 2011 (currently unexplained)

    Finally, page 5, County Map, provides a larger view of overall school performance by county with the ability to select individual counties and see vital statistics.

     

    EDIT 10/4/201

    • Added pages 6 and 7, Distributions and Power Law Distributions demonstrating that essentially none of the metrics used by the State of Ohio Department of Education follow any "normal" distributions seen in organizational performance management.
    • For a more in-depth analysis of how this report was conceived and evolved, see my blog article here: https://www.linkedin.com/pulse/analysis-ohios-primary-secondary-education-greg-deckler?trk=pulse_spo...

     

     

     

     

     

     

     

    eyJrIjoiNmE2ZDc0NTQtY2NmYS00YmYxLWI5NzYtMTRkMzFhM2U4ZWI4IiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9


    @ me in replies or I'll lose your thread!!!
    Instead of a Kudo, please vote for this idea
    Become an expert!: Enterprise DNA
    External Tools: MSHGQM
    YouTube Channel!: Microsoft Hates Greg
    Latest book!:
    Mastering Power BI 2nd Edition

    DAX is easy, CALCULATE makes DAX hard...
    Preview file
    522 KB
    LaurieSchoolDataNew.pbix
    Labels:
    • Labels:
    • Education
    Message 1 of 7
    11,052 Views
    9
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    fredwilson
    fredwilson
    Regular Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎06-25-2018 08:34 AM

    Ohio is one of the most important states in our country. We should do everything that we can to get them essay help at https://paperleaf.ca/. I hope that kids from there will have the brightest future possible. They are our future and we should help them. Just like what LeBron is doing right now. We need more scholarships so our kids could have an ability to go to college one day.

    Message 7 of 7
    7,784 Views
    0
    Reply
    BDonna901
    BDonna901
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎05-25-2018 04:46 AM

    Good day. It's really interesting and truthful information, i'm glad to read it. Especially i like this part: "The data as provided was challenging to work with in a number of ways. Achieving the desired capabilities required merging various tables of data together, specifically for the District Comparison report to function properly. Additionally, the raw data provided for the rankings of the measures were in a format of A-F grading as well as a number of "NR" designations, meaning that certain schools and districts were not measured on that particular category". It would be great if you share this information at https://pro-papers.com/proofreading-and-editing-services. I would be very grateful

    Message 6 of 7
    7,903 Views
    0
    Reply
    LPetty
    LPetty
    Frequent Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎11-24-2016 04:56 AM

    Great Work!  I wish there were more examples like this, to encourage educators to use these type of tools to help us use data to measure and improve our performance.

    Message 5 of 7
    8,515 Views
    0
    Reply
    mahimabedi
    mahimabedi Responsive Resident
    Responsive Resident
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎11-08-2016 04:05 PM

    How did you change the colour of the gauge to red for low values?

    Message 2 of 7
    10,515 Views
    0
    Reply
    FrankMelka
    FrankMelka
    New Member
    In response to mahimabedi
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎10-10-2018 06:39 AM

    I hope that kids will have the brightest future possible. They are our future and we should not help them. Just like what LeBron is doing right now. We couldn’t be able to go to college one day. Now in our schools we introduce additional metrics of estimation, cost metrics that are intended, of course, not for students. I do not know what benefit this can bring if no real action is taken on the basis of these metrics.

    Writer from canyon-news.com

    Message 4 of 7
    7,246 Views
    0
    Reply
    Greg_Deckler
    Super User Greg_Deckler
    Super User
    In response to mahimabedi
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎11-08-2016 04:22 PM

    Ah, sadly, that is slight of hand, it is not dynamic, it is statically set in the formatting (paintbrush) options for that visual. If you slice/filter to a school district that gets an "A" in that category, it will still be red. 😞 Sadly, no dynamic ability to set the gauge color based on a measure value. At least I am not aware of that capability with the default visualizations, and I prefer to not use custom visuals if I can at all help it.


    @ me in replies or I'll lose your thread!!!
    Instead of a Kudo, please vote for this idea
    Become an expert!: Enterprise DNA
    External Tools: MSHGQM
    YouTube Channel!: Microsoft Hates Greg
    Latest book!:
    Mastering Power BI 2nd Edition

    DAX is easy, CALCULATE makes DAX hard...
    Message 3 of 7
    10,511 Views
    0
    Reply

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Pages
    • Power Automate
    • Power Virtual Agents

    • Sign in
    • Sign up

    Browse

    • Solutions
    • Partners
    • Consulting Services

    Downloads

    • Power BI Desktop
    • Power BI Mobile
    • Power BI Report Server
    • See all downloads

    Learn

    • Guided learning
    • Documentation
    • Support
    • Community
    • Give feedback
    • Webinars
    • Developers
    • Blog
    • Newsletter

    © 2023 Microsoft

    Follow Power BI

    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks
    California Consumer Privacy Act (CCPA) Opt-Out Icon Your California Privacy Choices