Tag: Drill Down Sunburst

The impact of earning college credit “early” as a high school-aged student interests me. As with many things in education, what is defined as dual enrollment depends on the program or the researcher. Factors that are considered in the definition include, when the course was taken during the year (summer programs often are not included), who paid for the course, and whether the student received both high school and college credit for the course.

I am trying to understand what dual enrollment “looks like” in Maryland using data published by the Maryland Longitudinal Data System (MLDS) Center. To make this sunburst chart I took the number of 12th graders enrolled in Maryland public schools for the 2019-2020 school year from the Maryland Report Card. Then I took dual enrollment information published by MLDS Center: the number of public 12th-grade students with a college enrollment record and the number of students with a dual enrollment record. Students with dual enrollment record have information on the number of college credits earned while in high school.

According to this data, approximately 20% of high school seniors had a college record, and about 14% had taken a dual enrollment course. About 45% of those who had taken a dual enrollment course earned between 0.5 and 1 credits. Almost 2% of students who had taken a dual enrollment course, 160 students, earned 12 credits or more.

It is unknown how many dual enrollment credits transferred and counted towards degree requirements.

Click on “Flagged Dual Enrollment” for information on credits earned by these students.

Data Notes From the MLDS Center data

This table provides data on the dual enrollment credits based upon dual enrollment activity that spans 9th to 12th grade for high school students in 12th grade in 2019-2020 academic year.  The following definitions apply:
The initial population was selected by identifying students who had both a high school enrollment record and a college enrollment record in the 2019-2020 academic year (fall to spring). Summer enrollment information was excluded from this analysis.   For the portions of this analysis that related to courses and credits, the initial population was reduced using the following logic:
1) the student’s course record must be flagged as a dual enrollment course (comprehensive course data is not available for all local school systems), and
2) the student must have both a college enrollment record for the same period as the high school course record, and
3) the course must have credits (0 credit courses were excluded which represent <1% of all courses flagged as dual enrollment courses).

Course records identified as duplicate were unduplicated to include only a single record in the analysis. The duplicate records appear to be a data reporting issue. Unduplicating the records may understate the overall course record total.

Earned credits were calculated based upon the course completion status of passed.  Attempted credits were calculated based upon the course status of passed, failed, withdrawn, and incomplete.  Due to timing of data extraction course outcome data may be incomplete.  It is possible that students not counted as earning credit did earn credit once courses with the status of incomplete were resolved.  It is also possible that courses with the status of failed or withdrawn had grade changes that occurred after data extraction.   All credit values were derived from course records from the Maryland State Department of Education.

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

I found code for a drill-down sunburst chart on Amchart’s website. I just popped in the data I had already typed up that has Bowie State Univesity spring 2021 headcount enrollment by area of origin. This version is kind of nice because you can drill down to see the details of the smaller categories. A disadvantage is that you can not see the drill-down categories until you drill down. In the future, I may be able to figure out how to show the hidden layers, but I am not sure if that will be an advantage, it might be too close together to see the categories well.

To drill down to a level click on the pie slice. This will expand the slice to the entire area of the pie. It is rather difficult to explain, it is easier to just play with the chart down below to understand how it operates.

The drill-down sunburst chart goes down to the level provided in the original data. For in-State students, the data shows to the county level the area of origin. For out-of-state students, it shows students from the major surrounding states and the District of Columbia. The states are New Jersey, New York, Pennsylvania, and Virginia. The remaining students are from other states, “foreign”, or of unknown origin.

To make the other sunburst chart look cleaner I divided the counties into five regions: Capital Region, Central Maryland, Southern Maryland, Western Maryland, and Eastern Shore. The regions and the counties assigned to each region are from the “Visit Maryland” website. For this semester Bowie State University had no students from Western Maryland counties, so that region is not on the chart. As with the other charts, I withhold judgment on the chart until I have an opportunity to play with it.

Bowie State University Drill Down SunBurst CHart

Source: University System of Maryland, IRIS, headcount by area of origin

We use cookies to personalize content and ads, to provide social media features and to analyze our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information that you have provided to them or that they have collected from your use of their services. You consent to our cookies if you continue to use our website.

Preference Allow All Disable All