After my last map that shows public schools that have ever had an active outbreak, I got curious about what it would look like to just show schools with current active cases with trend information. Please see the notes for the data in the previous posts.
Category: Chart Test
My kids return to school in person tomorrow so I have been thinking about public school-associated outbreaks all day and different ways to graph the data available.
This map shows schools that have had a school-associated outbreak on 25 August 2021 or 1 September 2021. The circle shows the max size of the outbreak. I first tried sizing by the 1 September 2021 outbreak size, but that eliminated the schools that had an outbreak on 25 August but had zero cases on 1 September. The color shows if the cases at the particular school are increasing, staying the same, or decreasing. The tooltips show the number of cases on each day and the “type” of school based on the NCES School Directory. The two cases at Success Program on 1 September in Frederick County is not recorded because it does not have an address in the NCES School Directory. I will have to decide whether to add the Success Program or to just footnote it.
I also have to decide if I want to add private schools in the future. I would need to look up the address for each private school.
I have made more treemaps. This time showing transfer students to the University of Maryland, College Park in 2020.
In the first treemap, I show the level 1 names, and the level 2 names are hidden. Clicking on the level 1 names will reveal level 2.
Source: University System of Maryland, IRIS
In the second treemap, I show the level 2 names at first open. Clicking on the level 1 names will focus just on that level.
Source: University System of Maryland, IRIS
I am not sure which treemap style I like the best. I think it will depend on what I want the treemap to show. It might depend on the story I want to tell with the data.
I have found it is a little difficult to read the smaller categories of the treemaps, which might make them less useful. I expanded the height from 300 px to 500 px, but I am thinking of expanding them further to 700 px or 800 px. I also find the smaller categories sort of difficult to click on.
In my previous post, I built my first treemap using Amcharts. Today I built another treemap, this one is 3 levels deep. I am unsure about the presentation of the data in this manner, it may not actually be very useful. However, since I was able to successfully explore building a multi-level treemap using the Amcharts demo I will call it a success.
In this example, I was able to get the level 1 labels to appear, which I was not able to figure out yesterday.
Source: University System of Maryland, IRIS
Today I am testing out a treemap that I made in Amcharts. I made a treemap of the students that transfer into the University System of Maryland in 2020. The top layer is the education sector, the second layer is the institution. I am still having a bit of trouble getting it to behave as I would like. I would like the second layer names to appear in the boxes, but I can not seem to get it to work as it does in CodePen. Again I got it to work in CodePen using an Amcharts demo as a model, but again I ran into an internal 500 error when I tried to transfer the code over. So I rewrote the code keeping out the pieces that were not rendering properly.
The treemap clearly shows that there are a large number of transfer students from the US Armed Forces, in part because of the University of Maryland Global Campus. I may make another treemap that excludes transfer students from the University of Maryland Global Campus.
Second Layer Hidden
Source: University System of Maryland, IRIS
I figured out how to show the size of the institutions before drill down, but not the institution names. There is likely a simple way to show the labels on a treemap in Amcharts, but I have not yet figured out how. I think that I like the first style better, but I will need to test both versions.
Second Layer Shown
Source: University System of Maryland, IRIS
UPDate
I realized while I was digging into the data further that I missed the 16,362 students that transferred from “other” out-of-state institutions and 5 students that transferred from “other” MICUA/MD private institutions. I missed them because the institution details is only provided for the top 15 institutions in each of the drill-down categories.
This should be a bigger map. I fixed the CSS style at the beginning of the HTML code. Therefore the map should be bigger. I still do not understand why the Amcharts plugin is not rendering this code correctly.
Testing the rendering of the Maryland dot map in another way.
This is a test for a map that I am having issues with rendering properly. It is getting a 500 internal server error in preview.
I am posting this because I am curious if posting embed Html from CodePen will embed properly on my website.
See the Pen Maryland Dot map by Caroline (@New-Fish) on CodePen.
This code is properly working on CodePen, but I am having issues with it working on my website. I am not sure what I am doing incorrectly.
Another way to show the information in a divergent bar chart, like the one I posted a few days ago, is in a split bar chart. Datawrapper staff wrote a blog post not recommending divergent bar charts, so they only offer a split bar chart.
I put together this split bar chart to get a better idea of what the Maryland Comprehensive Assessment Program (MCAP) results would look like displayed in this manner. In addition to the five score levels, I added a percent proficient column which is level 4 and level 5 added together. Percent proficient is reported in the official data chart and shown in the official column charts developed by the Maryland State Department of Education for the Maryland Report Card. The percent proficient is shown in green on the right of the centerline in my divergent bar chart.
I’m not sold that a split bar chart is always superior to a divergent bar chart. Especially when the data has categories that are distinctly good or bad and no awkward middle neutral category. However, I like the split bar chart. I especially like that it can be easily sorted by percent proficient, which includes levels 4 and 5. For this data, the percent proficient is more important than the percentage of students at each level.
I find it interesting that the percent proficient ranges from nearly 70% to less than 20%. With such a large gap, it is likely that there are methods that can be learned from the higher-performing counties to increase scores (and hopefully ultimately learning) in the lower-performing counties.
Notes About the Data
- Values listed as 5.0% are acutally less than or equal to 5.0%. I am not sure if there is a way to show uncertain values in Datawrapper bar charts. In education data with small populations is often repressed. I could probably back into some of these numbers but I have not for this chart as the goal is to look at the data visualization.
