I think that this version works the way I want it to.
Continue reading “pLOTLY eXPERIMENT”Tag: Sankey
Trying to figure out how to align nodes. Got suggestion (from AI) to try different type of sankey. This is that attempt.
Continue reading “Both Houses-New Type of Sankey”This version of the Sankey chart illustrates the education bills that passed the Maryland General Assembly. It makes clear, in visual form, that most bills introduced do not ultimately pass. I wish I could get the chart to line up all first house committee assignments and second house committee assignments.
Continue reading “Both Houses again Again”Another option, but I don’t really like this one either. But it is more colorful.
Continue reading “Both Houses Again”I was able to get the progession of bills from both Houses in one Sankey, but I don’t love how it looks. I’m going to publish it, so I can look at it and try to figure out a better way to present the data.
Continue reading “Both Houses”This Sankey diagram visualizes the journey of education related (File codes F1-F5) bills that began in the Maryland House of Delegates during the 2025 legislative session. Each bill’s path is shown from its orginating chamber to its assigned primariy committee, and then to its final outcome. Doing this is more difficult then I thought it would be, although the data is readily available on the Maryland General Assembly website as a data download. Next I’m going to try to add in education related bills that originated in the Senate. This will be even more techically difficult because the Sankey doesn’t handle the oppisite house committees well. This is a work in progress.
Key Observations
- Mose House originated education bills were referred to the Ways and Means Committee or the Appropriations Committee
- The Ways and Means Committee handles bills related to:
- State and local taxation matters including assessments and tax credit programs
- Education financing
- Primary and secondary education programs
- Elections
- Funding of transportation programs
- Lottery and horse racing
- Issues relating to children, youth, and families
- The Appropriations Committee handles bills related to:
- State operating and capital budgets
- Supplementary appropriations bills
- State and county bond authorizations
- Higher education institutions
- State and local agency procedures and programs
- Collective bargaining
- Social services
- State personnel and pension matters
- The Ways and Means Committee handles bills related to:
This is a look at students enrolled in Maryland community colleges in fall 2019. In fall 2019, there were 113,288 students enrolled in Maryland Community College. Of those students, 35,905 (31.7%) were enrolled full-time and 77,383 (68.3%) were enrolled part-time. I decided to dig deeper into this information by combining attendance status with student age. The Maryland Higher Education Commission (MHEC) reports enrollment of students aged 25 and older by attendance status. Approximately one-third of community college students are aged 25 or older. About 85% of community college students aged 25 and older attend part-time, while approximately 60% of community college students under age 25 attend part-time.
I made a Sankey diagram to show both age and attendance status of community college students at the same time in the same diagram. This is a different use of a Sankey diagram than I have made in the past. In the past, I have used a Sankey diagram to show individuals flowing through the education system. This diagram shows two variables related to the same population of students. I am happy with the result and find it easy to understand and read; however, I don’t know if people unfamiliar with Sankey diagrams will find it easy to read and understand. My next step will be to ask my friends and family about what they think about the visualization. I also wonder if there are other data sets that I use that would be better understood using this formate. Another way to show this information would be with a single bar graph with four segments: 1) aged 25 and over and part-time; 2) aged 25 and older full-time; 3) under 25 and part-time; and 4) under 25 and full-time.
Sankey-Community College Fall 2019 Enrollment by age and attendance Status
Source: Maryland Higher Education Commission, Databook 2021
Bar Graph-community College Fall 2019 Enrollment by age and attendance Status
The bar graph shows the same information as the Sankey diagram above, but it is another formate. The purpose of this post is to show this data in different forms on the web and be able to test them on various platforms and to remember what I learned about the data. From the bar graph visualization, it is easy to see that the largest group are students who are under 25 and attending part-time and the smallest group (by far) are students who are 25 and older who are attending full-time.
I have made a few updates to my Sankey diagram that shows college enrollment by dually enrolled students. I really wish I had college enrollment data on non-dually enrolled students so I could compare the two groups.
I am publishing this update because my primary goal of this blog is to document for myself how to make better data visualizations.
Dual Enrollment College Pipeline
Twenty-one percent of public school 12th graders in Maryland during the 2019-2020 school year had a college record, that is they had been enrolled in a college class. The majority of these students participated in a dual enrollment program through their local school system. In fall 2020, the fall after they were slated to graduate from high school 79% of students who had a college record enrolled in college. This was during the height of the COVID-19 pandemic. Of those who enrolled in college, 75% enrolled at an in-State institution and 25% enrolled at an out-of-state institution. A little more than half of the in-State students (55%) enrolled at a community college, the remaining 45% enrolled at a public four-year or State-aided independent institution. Further, approximately half (51%) of students who enrolled in an in-State institution enrolled at their college of dual enrollment.
Source: Maryland Longitudinal Data System Center
Further Questions
I would be curious to know how college enrollment patterns of dual enrollment students compare to all public school 12th graders in Maryland. The Sankey graph above with that information would be much improved. Without that information, I am not really sure what it all means.
I am also interested in whether the dual enrollment credits earned transferred to the college in a meaningful way. According to MLDS data, students that took dual enrollment courses in high school earned an average of 2.14 credits.
Further, I wish that I had information on whether these students took AP or IB courses, which can also lead to college credit. I am curious if students are taking dual enrollment courses in addition to or instead of these courses. I wonder if the courses taken are primarily due to student choice, or due to the courses available at the student’s particular high school.
Finally, I am curious how these students perform in college.
Today I am taking a look at the dual enrollment data published by the Maryland Longitudinal Data System (MLDS) Center.
According to the data, 85% of 12 graders in the 2018-2019 student year who earned dual enrollment credits between 9th and 12th grades (academic years 2015-2016 to 2018-2019) enrolled in college in fall 2019. Of those who enrolled in college: 36% enrolled in an in-State community college; 35% enrolled in an in-State (public or private) four-year college; and 28% enrolled in an out-of-state college. This is showed in the Sankey diagram below.
I wish I could match up the dual enrollment students with the general student population. It would be nice to see if the behavior of students that dually enrolled differs from the general student population. I will take a deeper look at the data in the future to see if I can use math to make any conclusions.
As of yet MLDS Center has not yet published the general college enrollment data for the 2018-2019 cohort year. However, typically, 50% or less of high school graduates immediately enroll in college. Thus, students that participate in dual enrollment programs (unsurprisingly) seem to enroll in college at a higher rate than students generally.
Source: Maryland Longitudinal Data System Center, dual enrollment courses and credits: 2018-2019
According to the data set, of the 6,237 students that enrolled in-State following participation in a dual enrollment program, 3,012 in-state students, or 48%, enrolled at the college of dual enrollment. A further 2,936 in-state students, 47%, participated in a dual enrollment program at a community college and enrolled at an in-state four-year institution.
notes about the Data
- The data shows data on the college enrollment patterns for 2018-2019 12th grade high school students with dual enrllment activity at any point between 9th and 12th grade. The initial population was selected by identifying studetns who had noth a high school enrollment and a college enrollment recored in the 2018-2019 academic year (fall to spring). Summer enrollment information was excluded from this analysis.
- This diagram is the result of me exploring the limits of the data and the graphing software. The numbers and math have not been checked.