Stephanie Iancu, Aiden FitzGerald and Lily Sexton

Is Kindergarten the New College?

Many Massachusetts parents are struggling to afford child care, which has become more expensive than certain public colleges in some parts of the state.

Link to Methodology

The first few years of a child's life are critical in shaping their academic performance in the years that follow. However, in most parts of Massachusetts, the state or local government doesn’t get involved in children’s education until they reach elementary school. 

The high cost of childcare in Massachusetts is a major barrier for many families, especially  those with lower incomes. The state's reimbursement rates for childcare expenses are often inadequate, leaving many families unable to afford quality preschool programs. This is particularly concerning given research that shows the long-term benefits of early childhood education.

To understand the extent of the issue, we analyzed state budget data and enrollment data for preschool programs in Massachusetts. We found that the state's investment in early childhood education is significantly lower than other areas of the budget, and the number of children enrolled in preschool programs lags behind neighboring states. Our data visualization highlights the need for increased investment in early childhood education in Massachusetts, particularly for families who are struggling to afford quality preschool programs.

Cost of childcare:

The first thing we looked at was the cost of childcare in Massachusetts compared to surrounding states. The data shows that Massachusetts has some of the highest childcare costs in the country:

Based on data from the Department of Labor, the median cost of infant center care in Middlesex and Norfolk counties was $26,409.12, which is the third highest in the country. Only Arlington County, Virginia, with a median cost of $27,219.92, and San Francisco County, California, with a median cost of $26.775.12, have higher childcare costs. These figures demonstrate that childcare costs in these Massachusetts counties are significantly high, which makes it difficult for families, particularly those with lower incomes, to afford early childhood education programs.

This data visual doesn’t just account for the total price of the childcare, but also factors in percentage of average household income per state. Even with this factored in - Massachusetts is significantly more expensive than the surrounding states. 

As you can see in the visual, the cost of childcare in Massachusetts takes up nearly 20 percent of the average household income. 

“It’s really difficult to afford, but it’s not something that feels optional”, said Rachel Nabbetfielt, a mother that pays $210 a week for three days of care for her son. 

The data also shows that the average annual fees for full-time care in a center for an infant in Massachusetts are more than $17,000 - which is compared to the average annual tuition and fees for in-state public four-year colleges at nearly $11,000 based on data from the U.S. Department of Labor Statistics.

“The market for childcare is a failed market because the cost of care is not affordable for most working families,” said Jill Ashton, Northeast Regional Administrator for the Women’s Bureau, in a recent phone interview. “We cannot build a care system on the backs of an underpaid workforce, which is predominantly women and women of color.” 

State budgeting:

Our next step was to look at the budgeting of the state. We pulled data from the government of the Commonwealth of Massachusetts and found the 2024 state budget recommendations. The data visualization is below: 

The data shows in Massachusetts - education, including childhood education, is severely underfunded compared to other states. Because of this, families often do not receive enough reimbursement rates from the state to afford to send their children to most preschools. The other data we included was from Vermont, where they already have a near-universal pre-K program

Here in Massachusetts, the funding given to the Executive Office of Education is overshadowed by the Executive office of Health and Human Services - and it is comparable to the amount given to Administration and finances. But in the state it is being compared to, Education is very close to being the most funded area. 

This lack of investment can have a significant impact on children's development, particularly for those from low-income households.

According to a recent study by Columbia University researcher Kim Noble, giving low-income families just $333 a month for childcare could drastically improve their child’s cognitive development. In addition, investing in a child’s early education and care generates a very large return on investment. Studies estimate that for every dollar put into childcare, around $7 will be returned.

But Massachusetts does not budget to allow for that return - therefore preventing children of lower income families from attending the early education facilities they could use. 

According to a recent Boston Globe article, “Research shows that kids from well-resourced households are ahead of their low-income peers by kindergarten.” The first few years of a child’s life are crucial in defining how the child will perform academically in the years that follow.

“If you think of the brain as a machine that needs experiences to build itself, what you notice is that, when there are fewer experiences, whether it be in social interaction with parents, or with caregivers, or whether it be in the amount of place that you have in the environment, to build mental and social capital, those kids do end up very early on, by age three, showing differences,” said Dr. Kathy Hirsh-Pasek, an expert on early childhood development. “I don't ever want to argue that there's a threshold at which things aren't recoverable for people. I believe the brain is a very flexible organ, but what we do find though is that the earlier, the better.”

State budgeting per capita:

At this point we are already examining the funding differences between Massachusetts and Vermont, but with their population being so different - it is also useful to look at how much each state is investing per capita in education.

This graph shows how much Vermont overshadows Massachusetts. As of 2022, Massachusetts has a per capita budget of $12,539, while Vermont's per capita budget is significantly higher at $34,182. This disparity is striking, and raises questions about how each state is allocating its resources to support education. 

“The market for childcare is a failed market because the cost of care is not affordable for most working families,” said Jill Ashton, Northeast Regional Administrator for the Women’s Bureau, in a recent phone interview. “We cannot build a care system on the backs of an underpaid workforce, which is predominantly women and women of color.” 

The potential solutions:

“Investing in early education and care is a critical piece of the Healey-Driscoll administration strategy to ensure our earliest learners have classrooms where they can thrive regardless of their background, and parents and families have the child care they need to participate in the workforce and grow and strengthen the economy,” said Delaney Corcoran, Spokesperson for the Massachusetts Executive Office of Education. 

The new administration recognized that adequately funding the early education system had become an economic imperative. Governor Healy secured Commonwealth Cares for Children (C3) – a set of child Care Stabilization Grants aiming to support early education and care providers’ day-to-day operational and workforce costs – funding through the end of the 2023 fiscal year when she signed the supplemental budget, and that 2024 budget would invest more state funds in “sustaining and expanding access to early education and child care than ever before” according to Corcoran. 

Corcoran also said that the 2024 budget includes $475 million fully supporting the continuation of C3 stabilization grants to child care providers through the end of that year.

“The grants have allowed providers to continue to operate and provide critical education and care for young children across the state, despite increasing operational costs and challenges in workforce recruitment and retention. Parents, many of whom are women, have been able to return to work as a result,” she said. “Without the continuation of these grants, we are looking at a serious swath of child care closures across our state. Nearly 1 in 10 of C3 grant recipients said they would close their doors without this funding.”

With waitlists also being a significant challenge for many parents when it comes to childcare access, the House approved a budget of $25 million to provide greater access to families on the state’s waiting list for child care and doubled funding for the Commonwealth Pre-School Partnership Initiative from $15M to $30M. An additional $1.5M is also being proposed by the Healy administration to fund trauma-informed professional development of early educators with the goal of enabling them to better support the social and emotional needs of their students.

“We know that the pandemic has only exacerbated the mental health challenges of our children and we want to support our teachers who are facing it every day with the best tools available,” said Corcoran.

Conclusion: 

The high cost of childcare in Massachusetts is a major barrier for many families, and the state's reimbursement rates for childcare expenses are often inadequate, leaving many families unable to afford quality preschool programs. 

The newly launched National Database of Childcare Prices, sponsored by the U.S. Department of Labor Women’s Bureau, provides childcare prices in 2,360 U.S. counties and is the most comprehensive federal source of childcare prices at the county level. It depicts the undeniably exorbitant childcare expenses for families throughout the country.

The database highlights the urgent need for greater federal investments. With record low national employment rates and people who want to join the workforce but for the lack of affordable childcare, Ashton said, “what is a way that we as a country can come together to address this failed market?” 

Women’s Bureau Director Wendy Chun-Hoon said in a recent press release that families are facing burdensome childcare expenses all across the country. “The last few years have highlighted the tension parents experience when they need to go to work to provide for their families, but have difficulty doing so if they can’t access affordable child care.”

The data reviewed today shows the ways that Massachusetts is underfunded and families are struggling to afford quality preschool programs. The high cost of childcare in the state, coupled with inadequate reimbursement rates, makes it difficult for low-income families to provide their children with the early education they need to succeed in school. 

While neighboring states - namely, Vermont - have already implemented near-universal pre-K programs, Massachusetts lags behind in terms of investment in early childhood education. However, investing in a child's early education and care generates a significant return on investment, and the state should consider increasing funding for early childhood education to ensure that all children, regardless of their family's income, have access to quality preschool programs. 

By investing in early childhood education, Massachusetts can help to level the playing field for all children, giving them the foundation they need to succeed in school and in life. The Healy administration has committed significant resources toward addressing this issue and the next few years will be crucial in determining if these investments pay off.

Take Home Quiz: Finding a Story

Blue Bikes in Boston and Beyond

For this story, I chose to focus on Greater Boston and the surrounding towns’ Blue Bikes, a city-wide initiative that provides bicycles as a means of transportation for residents, who must sign up via an app and pay a fee to pick up bikes that they can freely ride around the city and drop off at the closest dock when they are done.

I wanted to see if there was any correlation between the number of blue bike docks allocated to a town and that town’s median household income, as I had the impression that wealthier towns seemed to have more Blue Bike docks. This would therefore be an interaction story, as it examines how the relative wealth of a neighborhood may influence the city’s decision of where to place blue bike stations.

I used two main spreadsheets:

  • One detailing the number of Blue Bike docks and dock locations in the cities and towns of Boston, Cambridge, Brookline, Malden, Medford, Newton, Salem, Somerville, Everett, Revere, Chelsea, Watertown, and Arlington based on data provided by Analyze Boston.

  • And another one with median household income rates for each one of these towns based on data from the United States Census Bureau and the Massachusetts Demographics website.

I started by creating a map of Greater Boston’s towns that shows how many blue bike stations are located within each one.

I then normalized the data by creating a calculated field of docks per population ([total docks]/[population]) to see how many blue bike docks there were per capita in each town as some towns are more populous than others.

I created two additional bar graphs with the median income for each town and city and the number of blue bike docks in each town or city in ascending order.

I finally compared these two bar graphs in my last visualization to determine if a reasonable correlation could be identified between both phenomena.

There does not seem to be a strong correlation between a town’s median income and the number of blue bike docks per capita. Higher-income towns like Newton and Arlington Have relatively few docks per capita, whereas lower-income towns such as Salem and Everett have around the same amount of docks although the median income is much lower. Of course, other additional factors should also be taken into account, such as public transpositions proximity and accessibility, the number of cars per household, as well as demographic factors such as the average age of the population in each neighborhood because these factors were also probably examined during the allocation process of Blue Bikes docks by authorities.

Sources:

Analyze Boston (https://data.boston.gov)

United States Census Bureau (https://www.census.gov/)

Massachusetts Demographics by Cubit (https://www.massachusetts-demographics.com)

Data User Guide

Original purpose and application

Emerson salaries:

This data from Payscale.com depicts estimated salaries of different positions at Emerson College, including Assistant Professor, Associate Professor, Director of Human Resources and Director of Operations. According to UnivStats.com, “Emerson College has 767 employees including both instructional staffs (faculties) and non-instructional staffs. The average salary for faculties is $93,795 and $82,035 for all non-instructional staffs.” 

Links to original data sets:

https://www.glassdoor.com/Salary/Emerson-College-Assistant-Professor-Salaries-E22372_D_KO16,35.htm

https://www.univstats.com/salary/emerson-college/

https://www.payscale.com/research/US/Employer=Emerson_College/Salary

Industry salaries:

Industry salaries: The data is based on job postings made by employers through the ZipRecruiter and Zippia platforms. According to the ZipRecruiter website, “To estimate the most accurate annual salary range for Journalist jobs, ZipRecruiter continuously scans its database of millions of active jobs published locally throughout America.” This type of data is mostly used by people working in this specific industry to get a better idea of the salary they should be asking for when applying for jobs. The tables downloaded give the average salaries for a journalist, media specialist and publisher, and the average salaries for the top 5 highest paying jobs in those specific fields.

Links to original data sets:

https://www.ziprecruiter.com/Salaries/Journalist-Salary

https://www.zippia.com/publisher-jobs/salary/

https://www.zippia.com/media-specialist-jobs/salary/

History, standards, and format

Emerson salaries: The data from Payscale was last updated on Jan 17, 2023, so the data is recent but there is no comparison to other years. According to its website, Payscale, which was founded in 2002, is “an American compensation software and data company which helps employers manage employee compensation and employees understand their worth in the job market.” Univststs is a private company that collects data about colleges and universities. Similarly, Glassdoor is a digital platform that collects (and provides) information and reviews about companies, salaries and job openings. The company is headquartered in California and it attains information from employers all over the world. According to Glassdoor’s data, the average salary for an Assistant Professor is $128,568 per year in the United States, which is 44% higher than the average Emerson College salary of $88,753 per year for this job.

Industry salaries: It is unclear how long this data has existed for, but ZipRecruiter was founded in 2010 and Zippia in 2015. Both platforms constantly update the dataset and new job postings are added to their websites and use additional data from third-party sources. According to information shared with us by the Zippia Support team, “Zippia sources data from various government organizations  including the Bureau of Labor Statistics, Department of Labor, and Census Bureau, in addition to job-related information from private companies. Additionally, we have a database of 30 million people's online profiles that we use to help estimate data points for various jobs, salaries, skills, and companies.” The job categories (ex: data journalist) in the table are based on labels or tags selected by employers when filling in the website’s recruiting form. The data is structured in a way that makes it easier for applicants to see how much they should be asking for in terms of yearly, monthly and hourly rates. No new columns seem to have been added to the spreadsheet recently.


Organizational context

Emerson salaries: The accuracy of these datasets is unclear. A lot of the numbers provided are averages, so they may be misleading. Glassdoor, in particular, receives its data directly from employees so while we hope the numbers are accurate, we really don’t know.

Industry salaries: As these are both for-profit recruitment websites, the data is in large part dependent on the job postings added by employers to the website, which can vary from month to month. Often, these datasets are also partly generated by algorithms that may have their own limitations, like for example the fact that they may not be able to identify an amount that a recruiter inputs into the system if it is not formatted correctly. Furthermore, the salary amount indicated by employers in these postings might not always be the exact amount they will be paying the employee they end up hiring.


Workflow

Emerson salaries: According to PayScale’s site, the company uses “a combination of techniques to ensure data integrity and validity.” They use “robust statistical analysis, automated data validation rules, and annual studies with 3rd party surveys” to ensure that datasets are accurate, reliable, and free from biases. “Any data profiles that do not pass our validation rules and statistical analysis, or are deemed questionable, incomplete, or duplicate, are not used in calculating compensation reports.”

Industry salaries: Zippia aggregates over a million open job postings through their website and combines them with Bureau of Labor Statistics (BLS), Census Bureau, and Department of Labor statistics and proprietary data on salaries, companies, and job-based metrics each month in order to generate up-to-date datasets that evolve with the job market. According to a statement on their website, data analysts at Zippia also hand curate the resulting list to remove any potentially inconsistent data. In addition, the website states that “all the data are scored and standardized to location and job title so that each company is comparable.”

ZipRecruiter derives their salary estimates, histograms, trends and comparisons from a mix of employer job postings and third party data sources (although the names of these sources are not specified).

This data is used by the Zippia and ZipRecruiter to generate recommendations for both recruiters and job seekers on how to find employers or employees that best fit their criteria. Zippia is free and ZipRecruiter does not charge job seekers any fees, but it does charge employers based on the number of jobs they post on the platform.

Exploratory Visualization/s of the Data

We decided to compare Emerson employee salaries with various average media salaries to explore the question “is it more financially viable to go into academia/college-affiliated work post-graduation rather than taking a job within the industry?” We also more broadly wanted to see if professor/employee salaries at a media college at Emerson are somehow correlated to the level of salaries within that specific field (journalism, publishing, general media, etc.) or not.

Things to know about the data, including limitations

Emerson salaries: As previously stated, these datasets are recent and hopefully accurate. Employees are becoming increasingly open about their salaries, which is a good step toward narrowing pay gaps. As reported by the New York Times earlier this year, in January, in some states there are new laws being created that require companies to post salary ranges on job listings. “As companies embrace pay transparency — either because the law forces them to, or because their employees are becoming more comfortable disclosing their salaries anyway — both employers and workers have noticed ripple effects. It’s changing how bosses set salaries.”

Industry salaries: these datasets are based on the U.S. as a whole, which can be considered as a limitation as we could reasonably assume that there is considerable disparity between the salaries of journalists, media professionals and publishers in large hubs like New York or Washington D.C. and more rural areas.

Although it is technically illegal for employers to retaliate against their employees for discussing wages with their colleagues thanks to the National Labor Relations Act of 1935, many still shy away from disclosing how much they make, so this data is difficult to access in any other way.

Side note: In 2019, the Washington Post and the Columbia Journalism Review reported on a viral spreadsheet that has been circulating in various media circles where journalists had been inputting information such as company names, years of experience, and salaries in a bid to create more transparency within the field. This information was however not easily verifiable and several media organization directors called it out for inaccuracy.

Other Stories, Reports and Outputs from this data

We have not found any other reports that used this specific data.

Supplementary Information

Industry salaries:

Journalism salaries on ZipRecruiter additional info information:

Publishing salaries on Zippia additional information:

Media Specialist salaries on Zippia additional information: 

Authors of this Data User Guide

Stephanie Iancu

Aiden FitzGerald

Lillian Sexton

Source Log 

Massachusetts Executive Office of Labor and Workforce Development

(617) 626-7100

Website contact form

Zippia support team

(254) 294-7742

support@zippia.com

ZipRecruiter

(877) 252-1062

Website contact form

Payscale

payscale.com

Website contact form

Charts: Populations Who Have Access to Drinking Water

For this assignment, I chose to analyze which countries in the world have safe drinking water and which ones do not by illustrating them on a map that would enable me to see which regions might generally be affected by droughts or a lack of water resources.

I started my first sheet by creating a bar graph of the percentages of each country’s water resources that were not considered drinking water (surface water only) in order to see which countries have unusable water resources.

I then created another sheet that showed all of the percentages for each category per country.

I then created my final two sheets that illustrate the data in the form of maps, with the first map using color gradients to help visualize what I selected as my two most important categories (no access and safely managed percent) and the second map using circles of different sizes to illustrate the proportions for each country.

This exercise prompted me to ask a series of questions about this data:

Would there be another more effective way of conveying this information through a map?

Could this data be combined with other data (for example, the type of climate in each one of these countries or regions) to build a more comprehensive visualization?

What criteria were used to differentiate some of the more specific categories such as “limited,” “basic,” and “unimproved percent”?

Raleigh and Boston: beyond the college town

Boston is commonly known as “America’s college town” as the greater Boston area is home to more than 50 colleges and universities. In this short data story, a series of data illustrating Boston’s higher education system will be compared to that of Raleigh (NC), another college town, to illustrate each city’s specificities.

In terms of population numbers, with 1.36 million residents, Raleigh is about twice the size of Boston (689’0000 residents), but universities in Raleigh only awarded 25,220 degrees in 2020, whereas universities in Boston awarded 45,037 degrees, almost double the amount. In both cities, the student population is skewed toward women.

The most popular majors in both cities are general business administration and management, followed by nursing in Raleigh and Liberal Arts and Sciences in Boston.

Another interesting statistic is that 28.2% of Boston’s residents are born outside of the country, whereas only 12% of Raleigh’s population is foreign-born. This may be in part related to the large number of international students who enroll in Boston’s many colleges and universities every year. In addition, Raleigh has less ethnic diversity than Boston, with 60.6% of its population identifying as white (non-Hispanic), versus 44.7% in Boston.

According to numbers disclosed by North Carolina State, Raleigh’s largest college in terms of the student population, international students make up around 9.1% of the student body. Boston University, Boston’s largest college, suggests that international students make up almost 25% of the student body, a much larger percentage.

The median tuition costs in Raleigh are $11,382 for private four-year colleges. In Boston, this number rises to $38,410, which is more than three times the amount in Raleigh. Median tuition costs for public four-year colleges for in-state students and out-of-state students are relatively the same in both cities though.

Beyond education and into the employment sector, both cities have a similar employment rate and a similar median household income ($78’000 and $76’000 respectively). However, Raleigh’s poverty rate (9.22%) is approximately half of that of Boston (18%), which suggests that there is more income disparity in Boston than in Raleigh.

It would be interesting to further investigate why Boston, despite its reputation as a hub for higher education, has such a high poverty rate. This question could be explored by looking into state and city investments in higher education versus other sectors such as infrastructure, primary education, and healthcare and also the accessibility of higher education for low-income households.

Another open question is why so many international students choose to study in Boston over other cities in the United States and which factors these students take into account when making their decision. More information is also needed to determine how many of these international students decide or have the ability to stay in Boston after graduating.

Sources:

Data USA
College Factual, North Carolina State University at Raleigh

StudyAbroad.com: Boston University

Source: Wikipedia Commons

Source: Wikipedia Commons