FlowingData Forums » Data Visualization

How woud you best show comparitive position?

Started 1 year ago by sholland / 3 posts

  1. I'm working on a presentation to our school district, which is planning on closing a number of smaller elementary schools and combining them into a mega-elementary school.

    I am looking for a way of showing the board, during a presentation we make to them, just what this does to our school size in comparison to the other schools in our province.

    (Yes, at the moment it's in PowerPoint.)

    I've been looking for ways of simply representing this, while at the same time showing the number of schools and the relative positive with some accuracy. So help me, the cyan thing and magenta thing from Data Underload #9 seems to be the best idea as yet! However, I do want to check to see if anyone else has some great ideas or examples.

    Sample slides at the moment:
    Our school Now
    Currently have 315 students, in English and French
    This makes us 359th in size in the province – 35% of schools are larger
    with 6s and 7s back
    In 2010/11, with return of grade 6s and 7s and projected kindergarten numbers, we would have 421 students, in English and French
    This makes us 163rd in size in the province – 16% of schools are larger

    Take away French
    Let’s now take away our French students – we have 273 left, English only
    This makes us 461st in size in the province – 45% of schools are larger

    Add School A
    If we add School A’s projected 2010/11 with 6s and 7s, we would have 470 students, English only
    This makes us 93rd in size in the province – 9% of schools are larger

    Add School B
    If we then add School B's projected 2010/11 with 6s and 7s, we would have 561 students, English only

    This makes us 30th in size in the province – 3% of schools are larger
    Assume 50% of French students transfer to English
    A number of French students would not be travelling out of our area to go to school, for various reasons.
    If we assume 50% of these students would transfer to English track, we would have 635 students, English only
    This makes us 6th in size in the province – 0.5% of schools are larger

  2. It would be great if you could post the actual data. I always find it helps me to play around with the full dataset. Then I can come up with a visual after I try out a few different options. Is that possible?

  3. I've put together a rather brute force approach.

    Find it here in PPTX and PDF form:

    http://slhslinux.cla.umn.edu/Documents

    The line is 20 cm long for ease of positioning.

    Edward Carney
    Research Assoc.
    University of Minnesota, USA


Reply

You must log in to post.

About this Topic

Tags

No tags yet.