Special Projects

As Told by a Nonprofit Data Wrangler

Data wrangling is the conventional term for the process of transforming raw data into a usable form. Suppose your database stored date records as “YYYY-MM-DD.” If your analysis focused on the calendar month, extracting “MM” (and maybe converting it to an actual name) might be part of your analytical workflow. Though not holistically representative, that’s an easy example of data wrangling.

Many data analysts—in the interest of showing off their competency and technical prowess—paint the process as elegant, smooth, and consistent. Of course, those are the qualities stakeholders desire for the end product. In fast-paced, evidence-based settings, insights and reporting should not only be actionable, usable, and sustainable, but they should also come in pretty packaging.

"...data wrangling can be a fairly indirect process that lands you somewhere you don’t expect. The same can be said of your early professional journey."

The spaghetti code amassed between their PostgreSQL, Pandas, and Matplotlib workflows be damned! Those data scientists can make a good visualization.

As a junior data analyst over a year into the field, I take a lot of pride in producing accessible insights for dozens of different stakeholder groups. In the first half of my fellowship, this has ranged from facilitating market-wide data democratization workshops to running Social Work-focused data trainings to the ever-cliché PowerBI dashboard. Some of this data comes from my original consumer research with participants, but the bulk of it comes from a highly mature and curated system of data collection at Year Up United. If the first year was spent exploring, the second year has so far been spent taking action.

Thus, it becomes a game of making all that raw data usable for study.  According to my coworkers, it’s a game I’m good at. “Avery’s the guy for all things data,” some say! I want to say that the game’s always easy, too. Yet, Truth would come out of her well to shame the consumer insights analyst.

Frequently in my work, Truth does not come out the data well on her own—given the usual conditions of organizational data storage, she can’t. Unconventional formatting, inconsistent styles of data entry, and deprecated categories don’t make data wrangling easier. Rather, data specialists come at Truth, buried somewhere in over a hundred relational tables of data, with mining explosives. And though some data professionals will tell you that Excel is archaic and limited, sometimes Truth doesn’t start upward vertical movement until you break out PivotTables.

Overwrought metaphors aside, the following is a 0 to 1 example of my own analytical workflow, going from an ad hoc stakeholder request to end-product visualization. Keep in mind that this can vary from project to project. This account is slightly fictionalized! The following data, though, is all real:

1.

I get a request to pull and process data from a stakeholder. This might be someone higher up in my department (in this case, the Director of Program), or it might be a stakeholder from another functional team (like the Director of Student Services, Site Director, or even a national Growth & Strategy Lead). Here, Wilfrid Velazquez wants to explore some data regarding “firings” for a debrief meeting. “Firings” are Year Up United’s historical term for attrition—a participant leaving the program, whether intentionally, willingly, or by regulatory necessity. For the purposes of this demonstration, we’ll wrangle only two selections of data into a singular visualization.

2.

I write a relevant SQL query to pull the data from a relevant relational database. In this case, I’m using SOQL (a proprietary dialect of SQL) to rapidly export a table from Salesforce, a CRM (customer relationship management) Platform. I’m specifically looking for participants who have left program—that is, count as attrition.

3.

I export the resulting array from this query into a usable format. (Note: I’ve removed confidential, identifying information important to my typical workflow.)

4.

I load the resulting file (in this case a CSV, a comma-separated value file) into a data manipulation tool. For many, this can be as simple as plopping it into Excel! That is a totally valid avenue of explanation. In this specific case, however, I’m using “pandas”, a data analysis library written in Python (a general purpose programming language) within the program VSCode. If you have the prerequisite knowledge, you can perform the same actions as in Excel with extreme efficiency and relative ease. And all these resources are free!

5.

Some exploratory data analysis is good for you. In this case, I’ve calculated the relative percentages of Attrition Reasons (referred to here as “Reasons for Status Change” and historically referred to as “Firings”). These numbers should add up to approximately 100: that is, a whole population.

6.

It’s become an organizational priority to investigate how our programming may impact different demographics– including age. This analysis sees how many participants of a particular age ultimately left the program. You can definitely see the higher numbers here, but it might be a little difficult to see what’s happening just from this.

7.

Woah! It looks like 19 years take the lead in attrition. It’s much easier to discern from this bar graph. In a Statistics course, we might describe this distribution as a bit “right-skewed”—attritions lean towards younger participants!

8.

That’s all good, but let’s see how this stacks up against the general population distribution of age. That is: maybe this is just proportional to how many 19 year olds were in this particular cohort? Let’s export another CSV using SQL, this time incorporating the entire population regardless of program status. The difference here is that I haven’t specified for “Status__c = ‘Fired’”, which would otherwise limit me to Attrition data. We’re no longer looking at a specific sample: we are looking at the true population.

9.

I’ve now loaded the CSV into my Python environment. You might be curious what those “NaN” values mean for the general population. In its literal most meaning, NaN means “Not a Number.” Contextually, it’s a “null” value: there’s absolutely nothing there. It’s an utter blank space where data could go. There isn’t any attrition data associated with that particular individual’s file because the individual completed the program in full!

10.

I’ll use the pandas library’s native support for Matplotlib, just as I had for the Attrition data. Huh, seems like there’s an entirely different distribution—with the exception of a singular (incorrectly entered) outlier calculated as 0 years old at enrollment!

11.

We’re getting more advanced now. I’ve super-imposed the age distribution of Attrition against the General Population. 19 year-olds are uniquely overrepresented here! I’ve normalized the y-axis—in Statistics, that means I’ve transformed the data in such a way that it’s easier to compare the values presented. The practice of steps 8 to 11 are commonly referred to as “exploratory visualization.” I’m not making any definite claims yet, beyond an observable instance of correlation.

12.

And now we export and save as a “.png” image file. It’s now time to send our end-product to our stakeholder to see if they think this topic is worth further investigation. In a social impact context, such phenomena might indicate a gap in service or the presence of something particular to this age group. As in all statistical investigation—no matter how simple—it’s important to remember that correlation is not causation. Higher attrition correlates with 19 year olds in this particular cohort: there might be any number of factors actually causing this. Still, it’s worth flagging for our stakeholder!

13. 

Don’t forget to tell your stakeholder what exactly they’re looking at if you ever try this yourself! I don’t consider reports—even if they’re small, ad hoc things—to be one-and-done deals. Be ready to explain your process and what the body of data you’re working with actually is. Soft skills are part of data analytics—there’s always going to be someone with a follow-up question.

As you might gather from this 13-step process—whether data layperson or not—data wrangling and ad hoc reporting can be a fairly indirect process that lands you somewhere you don’t expect. The same can be said of your early professional journey, at any organization—whether for-profit or nonprofit, social impact-oriented or driven by sales. “Indirect” doesn’t have to mean bumpy, but many challenges are meant to be transformed into victories.

When I first came into my role at Year Up, I imagined myself as a predominantly qualitative researcher who could flex some mixed methods muscle. Now, I understand myself as an adept data analyst ready to tackle both qualitative and quantitative data to extract whatever story they might tell. As I reflect on my options following my two-year opportunity with the FAO Schwarz Fellowship, I find myself saying what I’ve said before: I don’t just get one “year up,” the fellowship has given me two.

Picture of Avery Trinidad

Avery Trinidad

Avery Trinidad (he/him) is the Research & Insights FAO Schwarz Fellow at Year Up in New York City.

SHARE THIS STORY

Fellowship Reflections: Interview Between Current and Alumni Museum of Science Fellows

Jocelyn Poste is a current Fellow at the Museum of Science. She recently interviewed Kira Azulay, an alumni Fellow, and her alumni mentor, who remained on with the Museum of Science after her Fellowship ended in 2023 as an Education Associate. Jocelyn and Kira discuss Kira’s time at the Museum of Science, Fellowship memories, the importance of supporting youth, and more.

Kira now works for The Philanthropic Trust in Boston.

 

Jocelyn Poste, current Fellow: What do you do in your current position in the Museum of Science’s In-Gallery Learning Department?

Kira Azulay, alumni Fellow: Most of my work is centered on Youth Programs, which attracts high schoolers / students aged of 14 to 19 to the Museum in various ways. In the summer this can look like running our Summer Youth Intern program. In the academic year, this can be school partnerships. We have a longstanding partnership with Fenway high school where we have weekly a group of juniors come, and we do a science exploration curriculum here at the Museum. We also have larger events called our High School Science Series (HSSS) where we’ll invite Massachusetts and greater New England area students and teachers from high schools to come to the Museum for a day of exploration around a specific science topic such as: Artificial Intelligence, Chemistry, or Climate Change. A lot of different work like this, but we also do general education in the museum, so we support the education team by doing live animal shows, as well as facilitating drop-in activities. There’s a lot of variety.

You definitely get out of the Fellowship what you put into it.

JP: What did your direct service consist of as a Fellow?

KA: A lot of my direct service was the education that we’re doing on the floor like developing a live animal show and then presenting that. Working with visitors in in the halls, but also going out to the community with the community engagement department and doing drop-in activities. For example, we hosted vaccine clinics, which we turned into celebrations of science and brought activities and try to make it a joyful experience. Or going to Horizons for Homeless Children and we would do more activities for very young learners. Also, working with our high school juniors from Fenway High School every week, where we were developing a curriculum for them to explore science identity and specific science topics. It was very hands-on, working closely with a group of about 20 students.

JP: What did your special project consist of?

KA: At the beginning, my special project was researching about a youth leadership council and how that had been implemented at other institutions, then looking into how that would work at the Museum of Science. I think that because of the transition period the Museum was in post-COVID, it was not feasible to make that happen within my Fellowship time. While there’s a lot of excitement around [youth leadership councils], it takes a lot of stakeholders, so that process is complicated, but I did get to learn a lot about youth leadership opportunities. I learned how other institutions have been doing it and how they have been inviting youth into their institutions and getting them involved in a way that is more individual and not just being brought as part of a school or class. I also got involved with the Cambridge Youth Community, as well as youth workers communities, like a group called Reaching All Youth which is a monthly get-together of people that interact with youth in Cambridge in different capacities. That experience was beneficial.

Since we decided that instituting a youth leadership council was going to be difficult and not going to happen within the next academic year, my special project pivoted to running the High School Science Series and trying to create accessible opportunities. Our first couple ended up being virtual, so I was a moderator for one. We worked on getting subtitles for those and getting an ASL interpreter, and we ended up doing live captioning in English and Spanish which was important. Then, I took on more responsibility by running a whole High School Science Series myself, which I did in my second year once we had held one in person, which would have been October 2022.

JP: Do you have any favorite memories from your time as a Fellow?

KA: I think all Fellows might say this, but I really loved the retreats. I think that especially during COVID, that connection was important and the Fellowship component of having a cohort had a really big impact on my experience. I loved getting to connect with other Fellows in person because there’s not really a substitute even though we had Zoom meetings and trainings. In person connection was special and I feel like we created connections and friendships that were important. I keep in touch with all the Fellows, and especially Ryan, who’s in Boston. I think it was fun and it was good to hear other perspectives about what is happening at other types of institutions.

The Museum of Science is a bit of a different host organization from some of the others, and so it was interesting to hear about smaller or bigger places and what the other Fellows’ experiences were with their supervisor, how they were navigating problems, and whether we could share experiences around that. Also, getting to see New York and Philly and just getting to be in those places was nice.

JP: What was your most valuable takeaway from your experience as an FAO Schwarz Fellow?

KA: The youth are the future! I think people can be intimidated by and underestimate youth at the same time. Teens are people and you should treat them as such. I think treating them with the respect and understanding, that I would any other person any other adult, has gone a long way in building relationships with them. They are not kids, and they are still learning, but as an educator, we are there to support and guide their learning.

Something that is important and valuable is that the youth have a voice and they have opinions. You can have conversations with them that you might not be able to have with a younger learner. It’s a good thing to get the perspective of teens and see what they think. Everyone is coming in with their own life experiences and people show up differently, so I have had to learn that not everyone’s learning or listening style looks the same. I had my own preconceptions of what it looks like for students to be paying attention and engaged and that may not always be the case, so I have had to learn a lot from the youth. If you talk to the students they’ll tell you, “Hey, I have a lot going on right now so what would be best for me is just sitting over here and I’ll listen,” or talking to them about their interests.

They are interesting and fully formed people and are capable of a lot more than people think. They just need the like trust and support to do it, but they can do cool things. The youth at the Museum have done like a lot of projects here that are interesting to me, and they come up with and execute these ideas themselves. For example, we had interns over the summer that made an educational activity to talk about wildfires and different things about the ecology of wildfires. They make these different things that are so cool, unique, creative, and are effective at communicating and teaching. It was amazing to see what they could do in just seven weeks. They just needed the space to do that, so it’s been exciting and energizing and a cool experience to watch the youth do amazing things and see them grow over time.

JP: Do you have any advice for current/incoming/prospective Fellows?

KA: You definitely get out of the Fellowship what you put into it, and there are some important things that can impact it. You want to have a good relationship with your supervisor, and I think that is a huge factor in how your Fellowship goes, so you want to make sure that you’re communicating with them and that they are an advocate for you. Related to that, if you are excited about things and intentionally participate, then you’ll have a good experience. If something is not working for you, speak up and you can change things—this is good career advice outside of the Fellowship as well. I know there are Fellows who have worked with their supervisor to take on projects to explore different interests.

Also, huge advice, talk to Priscilla! She is a great advocate for all the Fellows, and she really cares, so I know that she’ll be a resource and will do whatever she can to be supportive. Priscilla will do anything in her power to support your success.

Be brave! Apply!

JP: If you could describe your Fellowship experience in 3 words, what would it be?

KA: Growth, Supportive, Fun (Honorary mention: Grateful)

JP: Having Kira as an alum mentor and working alongside her has taught me a lot, both personally and professionally. Kira has contributed endless efforts during her time at the Museum of Science, as an FAO Schwarz fellow and post-fellowship. I know Kira will bring even more creativity, energy, and wisdom in this next journey of hers!


Picture of Jocelyn Poste

Jocelyn Poste

Jocelyn (she/her) is the FAO Schwarz Fellow at the Museum of Science in Boston.

SHARE THIS STORY

An Unforgettable Experience: Reflecting on Two Years as a Fellow at Audubon Mid-Atlantic

Sophie Becker-Klein completed her Fellowship with Audubon Mid-Atlantic in Philadelphia in July 2024. She remained with the organization, serving as Senior Coordinator, Conservation Education. 

In the past two years, I have established a deep connection between Audubon Mid-Atlantic at the Discovery Center and four schools in Philadelphia, three of which are in Strawberry Mansion, the neighborhood where the Discovery Center lies. When I started as a fellow, we had established connections with two schools, one of those being in Strawberry Mansion. In this role, I have created the opportunity for Audubon to increase their engagement in their target neighborhood threefold. 

I have just completed my last week of lessons for this school year. This marks the second full year of lessons for the Community Partnership School, John B. Kelly School, and Dr. Ethel Allen School. This also marks the first full year of lessons at Edward Gideon School, a connection I made with alumni fellow Gregory Wright ‘13. 

These past two years have seen me grow into a more confident educator and birder, as well as a leader.

I created four lesson plans per school year, for a total of 8 lesson plans. However, in teaching five to six grades at each school, I tailored each of these lessons to each grade level based on their curriculum and learning levels. These lesson plans can now be used by Audubon Mid-Atlantic for any future lessons, whether I or another educator is teaching them. 

I have taught every class of every grade, kindergarten through fifth grade at two schools, and every class of every grade, pre-K through fifth grade at the other two schools. Each class received four lessons in a row from me, allowing us to create a lesson arc that I believe achieved my goal in my last update of “fostering a love of nature as well as a care for the environment while getting students excited about science.” I have had conversations with many administrators and educators about the transition from myself into the next fellow, and while many were disappointed that ‘Ms. Sophie’ would not be returning in the same capacity, they were excited that the program would go on. 

This summer, I will be taking on the role of Senior Coordinator for Conservation Education at Audubon Mid-Atlantic and I look forward to growing within the organization. One of the most exciting aspects of staying on at Audubon is the chance to see the program I piloted grow and change as the next FAO Schwarz Fellow steps into the role. It was a joy for me to be part of the hiring process for the next fellow and I look forward to mentoring officially through the Foundation as well as through my new role at Audubon. 

As we move into the summer months and the last month of my fellowship shifts away from school programs and into field trips and summer programs, I look both back on my experience as a fellow and forward to my upcoming experience as an alumni mentor and my role at Audubon. 

These past two years have seen me grow into a more confident educator and birder, as well as a leader. I look forward to continuing to grow as I move beyond the FAO Schwarz Fellowship, but I will take with me the wonderful connections that I have made and the support I have received from the fellowship community.

Picture of Sophie Becker-Klein

Sophie Becker-Klein

Sophie Becker-Klein (she/her) is an FAO Schwarz Fellow at Audubon Mid-Atlantic's Discovery Center in Philadelphia.

SHARE THIS STORY

Reflecting on Hidden Voices of New York City: AAPI Month 

During the second semester of each school year, my fellow educators at MCNY and I host an online student webinar series titled Hidden Voices of New York City. The series consists of monthly free virtual workshops designed for students in grades 3-5 that highlight and honor the individual and collective experiences of a diverse swath of New Yorkers. Each month has a different theme and features three different New York City-based activists. As May is Asian American and Pacific Islander (AAPI) Heritage Month, a time to celebrate and reflect on the contributions, achievements, and struggles of the AAPI community, the Hidden Voices series for the month not only celebrated the rich diversity of AAPI cultures but also highlighted the inspiring work of AAPI activists who have made significant strides in advocating for social justice and equity.

Researching the figures was particularly rewarding because I spent time looking at many primary and secondary sources from MCNY’s collection and several digital archives.

Our May program highlighted three individuals – Wong Chin Foo, Yuri Kochiyama, and Vishavjit Singh. Students gained insights into the experiences, challenges, and triumphs of these remarkable individuals. For example, with Wong Chin Foo (1847-1898), students learned about the Chinese American community during the period of Chinese exclusion and how Wong used writing to combat stereotypes. Yuri Kochiyama (1921-2014) was a Japanese American civil rights activist, internment survivor, and friend of Malcolm X whose story introduced students to the idea of solidarity through her participation in multiple social justice and human rights movements. Lastly, with Vishvajit Singh (1972 – ), students learned about a contemporary activist, Sikh American cartoonist and author who created the persona “Sikh Captain America” to fight against stereotypes and promote better representation for his community. 

It was a privilege to both write the script for and facilitate the May programs. Researching the figures was particularly rewarding because I spent time looking at many primary and secondary sources from MCNY’s collection and several digital archives. It was also fun to create the narrative for our program with my colleagues that would be accessible to 3-5th graders but also address the struggles and gravity of their stories. Throughout each program, students engaged thoughtfully and enthusiastically with our questions and prompts for reflection. I was inspired by how much these 3-5th graders already knew about our Hidden Voices, and grateful that I shared new information with them as well. While I am sad that this was the last time I will facilitate the Hidden Voices series, I am honored to have been part of a program that uplifts individuals whose stories have too often been “hidden” from the traditional historical record, but whose lives and legacies continue to shape our collective history and identity in the city.

Picture of Natalia Wang

Natalia Wang

Natalia (she/they) is the FAO Schwarz Fellow at the Museum of the City of New York.

SHARE THIS STORY

Feature image by Filip Wolak for the Museum of the City of New York.

Nothing Short of Life-Changing: A Reflection on Two Years as a Fellow at NYC Audubon

When I began my fellowship on July 12, 2022, I knew I was interested in the world of urban wildlife, but lacked direction and a point of view. Not to mention, I knew nothing about birds. Throughout my time with NYC Audubon, I have been given opportunities to learn about urban wild bird conservation, develop my own perspective and questions, and practice my developing expertise as a social scientist of urban wildlife conservation.

My position at NYC Audubon has been split into two distinct but related halves: Advocacy and Engagement. These halves have also served as a distinction between my Special Project and Direct Service work. My Special Project has been developing NYC Audubon’s advocacy initiatives for city- and state-level bird-friendly legislation. My Direct Service work has involved engaging directly with the public at NYC Audubon’s seasonal environmental center on Governors Island. 

My experience as an FAO Schwarz Fellow and a member of the team at NYC Audubon has been nothing short of life-changing.

Over the past two years, I have built out advocacy campaigns, organized rallies, testified at New York City Council, worked with elected officials, and engaged thousands of New Yorkers in taking action for wild birds. I am most proud of my work with Dustin Partridge, PhD—NYC Audubon’s Director of Conservation and Science—to research and write a guidance memo on drone light shows for the Mayor’s Office, which will soon be drafted into city-wide legislation to protect birds and people from the harmful effects of artificial light at night. I have also developed, coordinated, and conducted nature—and conservation—related programming for children and families on Governors Island and developed the analytical groundwork with which to measure progress as NYC Audubon continues developing bird outings and programming that engage the whole city and reflect the organization’s commitment to Equity, Diversity, Inclusion, and Accessibility. 

With the development of experience and knowledge from the Fellowship, I acquired research assistantships with faculty from Rutgers University and Colorado State University to better understand the formation of hemispheric approaches to shorebird conservation, which will result in at least one published academic paper, a conference presentation in Canada, and a research trip to observe shorebird migration—and the people who study it—at the Delaware Bay this May. And, after a long and tasking application process, I am thrilled and honored to begin my PhD in Environmental Psychology at The Graduate Center at CUNY this fall. I plan to study the political ecology of queer cruising geographies in New York City as habitat for wild birds and sites of contestation between people and institutions/agencies. I will also continue to work at NYC Audubon part-time in a new role mainly devoted to advocacy.

My experience as an FAO Schwarz Fellow and a member of the team at NYC Audubon has been nothing short of life-changing. I’m looking forward to seeing the ways in which this experience continues to guide me in my career.

 

Picture of Jesse McLaughlin

Jesse McLaughlin

Jesse (he/him) is the Advocacy & Engagement FAO Schwarz Fellow at NYC Bird Alliance (formerly NYC Audubon).

SHARE THIS STORY

You and Me and Data

“They’re always surprised when I say this,” the panelist says. It’s the Head of User Research at a certain company. He’s poised confidently in his tall, white bar stool, gripping the microphone. “But here’s something I always tell the people I’m supervising: only 30 to 50 percent of a research job is being a researcher.” The other panelists listen intently, pivoting their heads towards him. “The other 50 to 70 percent are your soft skills: working cross-functionally, and storytelling with data.” Thoughts and murmurs reverberate across the crowd. He gauges the audience’s reaction. “That sort of thing.” 

Meanwhile, my hands fly percussively across the keyboard of my work laptop—I’ve been taking notes the entire presentation. It’s not really common to see a researcher representing their company at a panel, much less a researcher active at the intersection of technology and social impact. Yet here he is: another queer man of color who had connected the dots between his own fancy-schmancy New England education and the impact he could make in Applied Research. Of course, it isn’t statistically insignificant that he has around a decade of experience over my measly full-time months. He’s the only reason I bothered coming to a panel that, for the most part, mostly had targeted client-facing B2B professionals.  He can probably hear the clacking. I hope he understands—it’s not all that different from qualitative research, right? 

For all the research I had executed and wanted to execute, for all the rigor I had taken into Year Up and learned within it, for all the data carved into the shape of 70 colorful, animated slides and graphs: am I truly embodying a researcher?

Keyboard clacking or not, the researcher continues his thought. “It’s a human-centered practice,” he concludes. He’s referring to both research participants and coworkers. A practice that’s 30 to 50 percent research, 50 to 70 percent stakeholder management. There’s a pause. 

Another panelist flicks the switch of his own microphone. Conversation then drifts back to the Director of Sales at a Series A startup, and we start talking about product management again. 

The idea of those human-centered proportions thus haunts me for several hours. 

I don’t believe that the researcher had been wrong: even as an early career researcher and analyst, the words still ring true. Since the start of my fellowship at Year Up, I have been plunging headlong into data and its repercussions. Most of my first month of the fellowship—besides the inherently hectic nature of onboarding anywhere—had been occupied by meticulous survey design, study rollout, mixed methods analysis, workshop agenda-building, and the construction of a corresponding 80-odd slide deck. In fact, the researcher’s words align with what had been my approach at Year Up beforehand: gather your data into a nice, lean repository and do the work of extracting narrative for the data’s eventual audience. Easier said than done, and a process that stops getting faster after a certain point of skill. Doable. 

Yet that researcher ratio strikes me at a very specific time. Less than 12 hours after this in-person, after-work, Wednesday night panel comes a very special Thursday morning: I am going to be facilitating another LC Lookback, the second of four.  

I’ve been working towards this data democratization workshop since as early as October, starting with a lengthy research proposal centered on the use of semi-structured interviewing as part of market-level research. Even with semi-structured interviewing pushed to next cycle, I’ve been grinding away at participant surveys—whether attempting to eliminate all chance for respondent bias, or simply just making sure trainees respond at all. Surveys turn into results, results turn into spreadsheets, and spreadsheets turn into waves of PivotTables and flashy visualizations. With any luck, presentations transform into change– whether incremental or sweeping– that delivers a better experience for the program’s end users. It’s a continuous, delicate art of observation, adjustment, and implementation.

Even beyond the data of this study, I’ve dived into the rigor of research: I voraciously consume articles penned by researchers and rapidly absorb the language particular to different industries and facets of the craft. I consult mentors in the field and establish a laundry list of professional development opportunities for myself throughout the remainder of the fellowship. I decide that I want to embody the strengths of both qualitative and quantitative methods—and, in the process, earn a certification in User Research and Design from the University of Michigan. I interrogate my own qualitative skills, and obliterate any vaguely leading questions from my interview scripts. I pin Survey Design down to its academic science, grinding each and every distracting element away from my surveys. I grind away at quant: I master SQL, and build myself up to an intermediate degree of Python for Data Analysis. I convince IT to let me install RStudio, and I almost get them to install a Python IDE.  Request denied—security reasons, they say.  

Still, for a while, data becomes me. Rigor becomes me. Embodying the researcher becomes me. I learn what the hottest discourse among corporate researchers is this season: proving your value add. 

And a few days before that Thursday, at the suggestion of a mentor, I drop a slide from my lengthy, lengthy workshop deck into a channel accessible to my stakeholders. That’s the nature of research, right? You grow stakeholder buy-in through drops of insights. It’s a good, basic metric: it’s a Net Promoter Score, a measurement cooked up at Bain & Co for the sake of comparing quantified, popular opinion between industries and companies. It’s not very common in non-profits, but we use it at Year Up. I upload my visualization to Slack, and respond accordingly when someone asks for a bit of context. It’s industry standard—and moreover, one of our standards at Year Up: I think there’s no harm done. 

The day after—but still before that Thursday, and before that Wednesday night—the Director of Program combs over my slides over a video call, and he finds himself a bit frazzled by the length. He’s especially concerned about the technical language I’ve deployed across my presentation. I’ve put in a slide explaining the history, purpose, and conventions of Lickert scales, those 1 to 5 or 1 to 7 or 0 to 10 things. I’ve put in a slide explaining response bias, and the ways in which a respondent’s context may affect their answers. There’s three, hefty slides discussing the roles of Qualitative Research, Quantitative Research, and Desk Research before any bulk of the data rears its head. “That’s the first time I’ve heard ‘desk research’ used that way,” he tells me. Then, he continues, “I think we need to make some cuts here.” 

I pause. I’ve been grinding away at these surveys, these spreadsheets, these hulking affinity diagrams of open-ended qualitative responses—to me, this is already a dilution. I think about the rigor I had so deeply immersed myself in. I think about the ways I had held myself back from including documentation of statistical significance. I think about my research, the ways I want it to grow, and how I want to grow. I wonder how, in that moment, to advocate for that growth. I wonder how to prove my value add.

I wonder how to prove my value add to myself. 

“You’ve only got 60 minutes for this, and it’s going to be a long, long day on Thursday,” the Director tells me. “I think—well, you have to consider your audience.” I see his eyes, even over Zoom, scanning across the numbers and texts and graphics. He asks, “Is everyone going to be able to understand this?” I consider his question, and hover my mouse over the delete button. “Wait,” he continues, “I think nerds like you and me can talk about this forever when we have the time.” I hover off the delete button. 

“Hide these slides—you or I or someone else can find them very, very helpful later,” he muses. I follow his instructions. That’s 3 fewer slides to sift through. “Try compressing them into one: what’s the main thought you’re communicating here? That a lot of work went into this, right?” Typing away again, I reply, “Yeah, that’s right.” The Director confirms my line of thinking, “Great. You have to make sure you’re telling a story with what you’re showing us. What’s the story we’re painting with the data?” 

We trim a slide or two off the deck, and compress and clarify where necessary. The deck actually doesn’t change very much—he muses about whether an hour will be enough time for all of the content, and I try to respond with confidence. “Hey, by the way: Great work, Avery,” he tells me, “You’ve been working hard on this.” I smile a bit and nod. He’s right, after all.

Come Thursday morning, and I’m reflecting while setting up the presentation space. I’m not so much nervous as I am jittery, and I suppose that the coffee hadn’t helped. Yet I’m still asking myself questions.

For all the research I had executed and wanted to execute, for all the rigor I had taken into Year Up and learned within it, for all the data carved into the shape of 70 colorful, animated slides and graphs: am I truly embodying a researcher? In my pursuit of not only scientific precision in my analysis, but scientific exactness in my reporting: am I managing my stakeholders’ expectations and understanding, or am I arrogantly positioning myself as a sole source of knowledge? And for the participants, the stakeholders for whom the data would matter most—yet wouldn’t be in the room of this day-long workshop—is this report going to be to their benefit? Am I making sure not to reduce them to a set of data points? 

Where am I on that scale of 30 to 50 percent against 50 to 70 percent? 

Interactives and warm-up activities come and go. My presentation—in all of its data-laden glory—comes and goes. I try not to pontificate; instead, I carve out a story through a reservoir of statistics and words, all stemming from the participants we had worked with for months upon months upon months. If I keep anything to an exact science, it’s my timekeeping: questions have their dedicated sections, and interruptions are not allowed. It’s appreciated by my colleagues. Someone compliments my sweater; it was going to be a long day, so our Site Director thought it best for us all to wear casual.

At the end of the workshop, we hold a “Plus/Delta,” an exercise to identify the strengths and growth areas of an event. One of my coworkers comes up to a whiteboard in front of the room, pops the cap off of her marker, and gestures toward the dozens of people seated. 

“Well,” she tells them, “I have a Plus to start off with.” My head pivots towards her. 

“Avery,” she continues, “Fantastic data. I learned a lot today.” She writes Avery’s Data in fat, bold letters at the top of the board, right under a plus-sign. “Check,” someone calls out, signaling agreement. “Check,” goes another voice. “Check.” Another. “Check.” Another. “Check.” Again. “Check.” It goes on like this for a little while, until there’s a stream of little checkmarks following my name. “Clarity of the data,” someone else calls out. “Check to that too,” says another. I try not to laugh. 

“Glad to hear that,” I joke. And there I am, an early career researcher and analyst. 

Even by the end of our Plus/Delta— even by the end of a day spanning all the way from 9 AM to 6 PM— I don’t know where I lie on that scale of 30 to 50, 50 to 70. I still haven’t put the puzzle pieces of my own research entirely together with that of Year Up’s national research functions. Unfortunately, I’m still 78% of the way off from completing my certification in Data Science in Python, but NumPy hasn’t been too hard to figure that out. I’ve been given the possibility of starting some semi-structured interviewing, but even that hasn’t been set in stone.

Yet, through all of that, I know I’m a researcher with a clear value add. And I don’t think I have to perform too many tests to prove that. The data against the null hypothesis is self-evident, even to me. 

Picture of Avery Trinidad

Avery Trinidad

Avery Trinidad (he/him) is the Research & Insights FAO Schwarz Fellow at Year Up in New York City.

SHARE THIS STORY

Talking with Kayla Johnson, FAO Schwarz Fellow at The Clay Studio

A second Fellow will join The Clay Studio in 2024. Thanks to the team at The Clay Studio for creating and sharing this video with us! 

Picture of Kayla Johnson

Kayla Johnson

Kayla (she/they) is the After-School Program Coordinator & FAO Schwarz Fellow at The Clay Studio in Philadelphia.

SHARE THIS STORY

Feature image by NAME OF PHOTOGRAPHER, courtesy of LINK TO NAME OF SOURCE . Please do not open link in new tab as it messes us accessibility.

Day in the Life: Teaching Artist

In my role as an FAO Fellow here at The Clay Studio in Philadelphia, I get to enjoy lots of variety in my day-to-day experience. My direct service work in the fellowship is working with Claymobile, our mobile engagement community program. The majority of this work is centered around teaching ceramic classes in schools, but I also get to teach in community centers, libraries, and farms. I began in this role acting as a teaching assistant, which means that I worked with the lead teacher in setting up the materials necessary for the class and supported students in their creative process. More recently, I have begun lead teaching in classrooms; it has been a wonderful process starting from having no knowledge about ceramics, to learning how to assist, then to leading a residency. Last week, I had my first class lead teaching at Steel Elementary. I started my day at the studio packing all of the necessary materials and then driving to the school. On arrival, we bring all of the materials to the classroom and introduce ourselves to students. 

Each day at work is different and I wouldn’t have it any other way!

As a lead teacher, one of the main components is teaching a demonstration of the ceramic project we will be completing. For this particular class, we made coil bowls which are made of small ceramic spirals using a plastic bowl as a mold. During my demonstration, I focused on the feeling of the clay as it was many student’s first experience with it. Teaching how to make a coil, how to smooth the inside of the bowl, and glazing are some of the main focuses for this project. After the demonstration, the rest of the class is spent moving around the classroom, checking in with students and answering any questions that arise. Many students shared ideas of projects they want to make in the future, what they might eat out of their bowls and share information about themselves and their families. The classroom teacher took pictures of each student with their finished bowls and we said goodbye, all in under two hours. 

After a Claymobile class, I’ll switch over to my special project work which is teaching in our new after-school program. The after-school program started last year, and we are now working with four schools in the area. After unpacking and taking lunch, I’ll set up our studio with the tools and demonstrations necessary for our class. Then, I walk to the school that we work with that day to pick up students at dismissal. After all of the students arrive, we walk to the studio together. Once we arrive, we have snacks and homework help which is necessary time for students to relax and connect with each other. Then we switch to studio time. Teaching in the after-school program can be similar to the style of Claymobile teaching, but as it is a smaller group who have had practice in multiple making techniques, it runs more independently. Some days we offer a full demonstration, others are free-making days where students choose what they want to make, but most days fall somewhere in between. This is a long-term program for students, so the curriculum is built particularly for the students from each school. Connecting with students on a weekly basis is one of my favorite parts of my job, and being able to provide a fun and safe space for students to make art and chat with friends. Working within the after-school program lends itself to a stable consistent schedule which is nice for me and Claymobile gives my schedule some flexibility and fun. Each day at work is different and I wouldn’t have it any other way!

Picture of Kayla Johnson

Kayla Johnson

Kayla (she/they) is the After-School Program Coordinator & FAO Schwarz Fellow at The Clay Studio in Philadelphia.

SHARE THIS STORY

You Want What I Want: Research, Rapport, and Surveys

It’s January at Year Up New York|New Jersey, and I’m once again compelling 292-odd program participants to participate in a research study. That is, a survey-reliant research study.

Ever tried to get hundreds of people to do a survey? It’s harder than you would think. 

The first hurdle: having people even consider it. In client-facing contexts, many potential participants view corporate surveys as “lacking in empathy” and as a general inconvenience (Dholakia 2021). Employee engagement surveys—intended to gauge areas of discontent and improvement within organizations—sometimes exacerbate ongoing issues, failing to address the concerns workers actually have (Wahba 2023). According to a 2022 analysis, online surveys have an overall average response rate of 44.1%: even getting a tenuous majority of potential participants to respond is a major victory for researchers (Wu et. al 2022). Ultimately, whereas sloppy studies erode popular trust in surveys and their application, a good survey is always delicate, intentional, and targeted. Like a coffee shop.

Chat with your future participants. Block out time for them. Make your intentions, methods, and motivations transparent. Take notes on just about everything.

The reason, of course, that you would ever invest time (and sometimes money) in such a particular, harder-than-it-looks research method is the data. You probably want lots of data. Lots and lots of quantitative data. (Kind-of) fast and cheap. Even the best surveys are a relatively quick and standardized method of gathering data on a population: interviews take days if not weeks to process, observational studies require precise planning and timing, and usability studies often necessitate proprietary tools and training. In the context of social impact, particularly in the non-profit space, internal surveys can churn out numerical insights without the budget crunch of an outside consultation.

Year Up, for example, loves its quantitative data—it’s part of its pervasive “Feedback Culture”. The national organization, headquartered in Boston, charts outs surveys across the participant life cycle, meant to track engagement and opinion metrics at critical touchpoints of a trainee cohort’s journey. These “Direct Service Survey” metrics are then, among a myriad of other functions, analyzed by a dedicated team, shared with corporate partners, and play a critical part in the organization’s overall and agile Service Design. Data is used to make data-informed decisions by data-informed teams. Year Up’s New York|New Jersey market, in turn one of the largest across the organization, has its own pattern of surveys and evaluations. After all, as useful as national metrics are, the needs of individual cities, tracks, and cohorts can be very different. That’s where I come in.

My first survey at Year Up, conducted in only my first three weeks of employment, was focused on our contemporary Learning & Development (L&D) and Internship cohorts. Preparation for the Program Evaluation segment of LC Lookback, a biannual market-wide meeting of staff, required a rapid and targeted collection of student metrics. I did what I could with the resources I had available to me—a detailed guide left by the previous Fellow, Nia. Yet, despite still hovering above the 44.1% average recorded by Wu’s 2022 team, I still felt a bit nonplussed at an ultimate L&D response rate of 51.6%. I hadn’t been fully acclimated to Year Up’s organizational culture, wasn’t entirely sure of the research goals of our study, and definitely lacked the time to become familiar with my study participants. As good as the insights we drew, I had a constant feeling that they could have been better. It seemed like trainees, in the midst of organizational changes, had viewed my research with raised eyebrows.

I was missing a rapport between researcher and participant.

Thus, I decided to roll out my own strategy for rapport building. Starting with the next L&D cohort, set to graduate July 2024, I adopted four, simple research practices. If you ever find yourself designing internal research, always try to:

1. Make your research meaningful

Appeal to your study participants’ interests, emotions, and experiences. It might be a Rousseau-flavor cliché, but people like helping other people. People, of course, also like helping themselves. Inform participants of the benefits of participating in your research: let them know that, with the data that they may provide, you can improve not only their experience but those of others. Rather than positioning researchers as exclusive arbiters of knowledge and authority, emphasize the collaboration inherent in your work. Align your interests with theirs. Human-focused research is ultimately the culmination of a researchers’ skills and interlocutors’ contributions. If a survey evaluates the design of a longer-term service (such as the L&D period at Year Up), actively cultivate trust between researchers and participants. Contributing to research becomes helping researchers out!

2. Make your research practical

In the case of surveys, do not make your survey openable only on the second blue moon of a leap year. Do not make your survey consist of 50 consecutive matrices. Do not make your survey a series of 30 required open-ended questions with minimum 100 word counts. Do not compel your participants into responding in a time window that biases their responses. Do not make your survey a combination of the above. Surveys, at a minimum viable state, should be painless to access, complete, and submit. Completion is the second hurdle of a survey, and a difficult survey diminishes data quality and participant trust. Minimize the length of your engagement. Provide gentle-ish reminders. To whatever extent you can, anonymize results and remove personally identifying information. No one enjoys being given a hard time. In particular, no one enjoys being given a hard time in the form of an over-extended Google Forms sheet. Research, at its best, becomes an opportunity to share information.

3. Make your research insightful

Discerning an actual takeaway from research serves as a third hurdle: results should be analyzed, then translated. When elaborating on a previous study, track ongoing trends and patterns: how have organizational changes been reflected in your metrics? Identify your set of key performance indicators, and drill down where and when you can. Document opportunities for expansion in future elaborations of the study. Archive your findings in a way that remains accessible to future researchers and stakeholders. Above all else: make sure you can digestibly communicate your findings to those outside of the research team, especially your participants. To build trust towards your research and those of future researchers, your findings must be actually legible. Research is the production of information. When you perform good research, you begin to assign that information meaning.

4. Make your research actionable

Ideally, indicate immediate actions that can be taken in accordance with your findings. Carry out the easy fixes and continue on the clear points of success. Action—or, at the very least, a plan of action—can make or break the trust of your participants. If you are cultivating trust on the basis that your research will work to the benefit of the participant group, it should work to the benefit of the participant group. Find the bravery to challenge institutional assumptions: at what points can we alter the course of our design or implementation, should it be to the benefit of our interlocutors? Recognize your study’s failings, limitations, and opportunities for improvement. Ultimately, champion a sustainable path forward. Any path of action shouldn’t lead to burn out: it should lead to progress. More than simply considering your research, stakeholders should be able to work with it. Action leads to better outcomes, which lead to better trust, which in turn leads to better research. Some would call it a virtuous cycle.

While these blocks of text may make things seem complicated, these maxims are fairly simple in practice. Chat with your future participants. Block out time for them. Make your intentions, methods, and motivations transparent. Take notes on just about everything. 

Not only have these practices increased trainee trust towards organizational research, but they’ve grown both the volume and quality of our data. I’ve been able to gather contextual research on the experiences of participants throughout the Learning & Development Phase. I’ve been able to build upon the work of of previous fellows, crafting a qualitative research protocol for Year Up New York|New Jersey. I’ve been able to become a trusted advocate for our participants. And most metric-friendly, I’ve been able to raise the response rate from a passable 51.6% to a new high of 95.7%—and still counting!

But as you refine your own research practice, life goes on at Year Up New York|New Jersey. The reminder emails to the remaining 20% continue to fly out of my outbox. My little T-tests continue to sort out random chance from statistically relevant phenomena, my presentation decks prepared for their deployment. Participants pop up at my desk, asking for everything from advice to a laptop charger.

Yet in-between all of my little notes, projects, and ambitions—and a wave of organizational change—our site still had our own End of Year meeting. There, I was rewarded the “Newbie Award,” tagged as a new staff member that had already greatly contributed to the Year Up New York|New Jersey collective. Presenting to the entirety of our market staff, my supervisor cracked a joke about how I was able to bring data into any conversation, presentation, or strategy. Our market laughed. As I accepted my neatly printed certificate, I couldn’t help but flash a guilty smile. 

I suppose, then, I’ve been doing something right.

 

WORKS CITED

Dholakia, Utpal. “Why Customers Hate Participating in Surveys.” Psychology Today. June 6, 2021. https://www.psychologytoday.com/us/blog/the-science-behind-behavior/202106/why-customers-hate-participating-in-surveys

Wahba, Phil. “Too Many CEOs Don’t Know What Their Workers Need. Employee ‘Engagement’ Surveys Can Make the Problem Even Worse.” Fortune. July 12, 2023. https://fortune.com/2023/07/12/employee-engagement-surveys-dissatisfaction/

Wu, Meng-Jia, Kelly Zhao and Francisca Fils-Aime. “Response Rates of Online Surveys in Published Research: A Meta-Analysis.” Computers in Human Behavior Reports 7 (2022). August 2022. https://www.sciencedirect.com/science/article/pii/S2451958822000409#sec1

 

Picture of Avery Trinidad

Avery Trinidad

Avery Trinidad (he/him) is the FAO Schwarz Fellow at Year Up in New York City.

SHARE THIS STORY

Accessibility Toolbar