Currently Quaranting

This chart shows the number of students and staff currently quarantining according to Anne Arundel County Public Schools (AACPS) COVID-19 data dashboard. The dashboard is currently being updated daily, but I have not been diligent about collecting the data daily; therefore there is data missing from some days. So far, according to the data I recorded, the number of students quarantining peaked at 1,756 on September 29, 2021. On that date, there were 40 staff members quarantining, which was also a high point.

Below I have copied what AACPS says about who is included in the number of students and staff currently quarantining.

The number of current quarantine cases above includes those who are COVID-19 positive through confirmed testing, those who have been designated as having COVID-like symptoms, and those who are probable cases as defined below on this page. It also includes those who have been determined to be close contacts of those persons and who are not fully vaccinated. The data includes cases traced in schools as well as those involving AACPS students that are traced in the community and have no immediate impact on schools.

Anne Arundel County Public Schools

THoughts about the Chart

I like that datawrapper provides several options for displaying the date at the bottom of a chart. Because I have taken foreign languages and lived abroad, I have used both the day/month/year date formate and the month/day/year formate. I find it sort of confusing switching between the format conventions, so I'm happy that there is an option that eliminates that potential confusion by using the month abbreviations as such "Sep" or "Oct" with the date number above. I find this date format easier to read.

I used the straight number of students and staff currently quarantining for this chart because I was interested in the actual numbers. I could also show the percentage of students and staff currently quarantining. I would need to find an accurate count of students and staff for the current school year to make that chart.

Usually, I write about data visualizations and education policy. Today I am going to write about the fundraiser I am going to do for St. Jude’s Children’s Hospital in conjunction with the Game Theory Community Challenge 2021. With the recent loss of our family cat [EDIT 2: our cat returned a week later, we are now looking to bring happiness into the world in thanksgiving], my 10-year-old son and I decided that we wanted to bring some good to the world. He came across the Game Theory Community Challenge that is happening during the month of October 2021, and he said that we had to join this year as fundraisers, not just as donors. The details of what we are going to do to raise funds are still unclear beyond putting the word out that we are fundraising. His idea is for us to bake and sell sourdough bread. While I am grateful for his faith in my baking, I am unsure of the logistics. So while I try to figure out the logistics, I am just going to put our request out into the universe.

My son got into St. Jude’s mission last year when he was 9 through the Game Theory Community Challenge on YouTube. He got excited about the mission and asked for help in donating some of his own money to the cause, and convinced me to donate. This year he wanted to do more by asking for donations from others and I agreed to help. My son believes in St. Jude’s mission to give kids free cancer treatments free of charge. He says that he thinks that cancer treatments must cost a lot of money and childhood cancer must be scary for the kids and the parents.

So if you are interested in donating to St. Jude’s, and bring joy to a kid that wants to help other kids. Click here to donate. We are team “I-like-rice”.

Donate

Game Theory Community Challege for St. Jude’s 2021 Data Visulizations

Edit: Actually, I have an idea. I am going to try to figure out ways to visualize the data from the challenge! I don’t know if I will be able to keep up with the data, but I have a few visualizations that I would like to try with the data. For example, I would like to try a bar chart race with the top donors. But until I figure out the racing bar chart, please enjoy a regular bar chart. [Edit 2: We were so busy celebrating the return of our cat I took a few days off data visualization, but I am now back at it. I am finding the bar chart race very challenging. I want to switch the “years” in the example I am looking at to “days”, but it is breaking the formula.]

UpDate: October 13, 2021

I have not abandoned this project, but I am having trouble figuring out coding the racing bar chart using days rather than years as was used in the coding example I used. I have discovered that I need to understand the coding behind the chart better. I am also not making the time to record the data I need to make the chart as my work has recently gotten busier.

This map reflects the total outbreak-associated cases in schools on September 22, 2021. This is an update of the September 22, 2021 map.

This drill-down sunburst chart shows the breakdown of students that transferred to the University of Maryland College Park in fiscal 2020. The first layer shows the type of sending institution: Maryland Community Colleges; other University System of Maryland institutions; Maryland private institutions, including institutions that belong to the Maryland Univerity and College Association (MICUA); and out-of-state institutions. The second layer shows the institutions. However, since the original data source only shows the top institutions in a particular category, the names of not all out-of-state institutions are captured.

This chart is based on an Amcharts demo for a drill-down sunburst chart. This particular data only had two levels, but additional levels can be added if you have hierarchical data with multiple levels. As with several other charts I have tried making with Amcharts, this chart did not work in their add-in for WordPress. I however was able to add my data using Notepad. Then I saved the document as an HTML file by changing the file extension to .HTML. Then I uploaded the file to the media library for my website. Finally, I used some HTML code on this page to creat a frame and pull up the chart. I explained that process and shared the code I used in a previous post about my experiences making charts and maps with amcharts.

The chart shows that 63.6% of transfer students came from Maryland community colleges. Half (50.3%) of those students from Maryland community colleges came from Montgomery College, which is located in Montgomery County not far from UMCP. Anne Arundel Community College, Prince George’s Community College, and Howard Community College were also the source of a large number of transfer students. The second-largest source of transfer students is out-of-state institutions. For that category none of the sending schools are dominant. The biggest category is “other”.

UMCP Transfer Students in Fiscal 2020 Drill Down Sunburst Charth

Source: University System of Maryland, IRIS

This map reflects the total outbreak-associated cases in schools on September 22, 2021. This is an update of the September 15, 2021 map.

This is the September 21, 2021, update of a previous map.

This is an update of a previous post.

This is an update of a previous map.

The Anne Arundel County Public School System updated its COVID data dashboard today. It reflects cases where contract tracing has been completed and data fully entered as of noon on September 20, 2021. IT does not include cases in which tracing, documentation, or determination are still in progress. The data dashboard was due to be updated on Wednesday, September 22, 201, but they decided to update it early.

According to the data dashboard, 1,092 students and 21 staff are currently quarantine. There are 170 students and 14 staff with active cases. The cases are as distributed as follows: 9 student cases at charter/contract schools; 76 student cases at elementary schools; 33 cases at middle schools; 51 cases at high schools; and 1 case at a specialty center.

Chorpleth map of Act COVID-19 cases in Anne Arundel County PUblic SChools

The map shows the active COVID-19 case in Anne Arundel County Public Schools by feeder system as of noon on September 20, 2021. The map includes student and staff active cases. According to the map the feeder system with the most active case, 24 is the North County High School feeder system: 3 high school cases; 4 middle school cases; and 15 elementary school cases. The feeder system with the least active cases is the South River High School feeder system: 1 high school case and 4 elementary school cases. This is an update of a previous map.

I decided to see if I could make the Anne Arundel County Public School COVID-19 table I published yesterday a more usable table by eliminating schools with no active cases. I think it is prettier, but it might be less useful for people searching for their particular school.