Friday, July 30, 2021By:
This week, I spent all my time on revising the work I have been doing throughout this internship so that the data that gets published on the APS website is accurate. I started by making a note explaining the issue of NSF data not including second majors in their numbers to the NSF documentation I had created. Then, I downloaded all the necessary 2019 data files from IPEDS and revised the How Does Your Institution Compare spreadsheets for 2018 and 2019 with this data. After that, I revised my code to read in IPEDS data files and add the new year’s data to the Überspreadsheet. From the updated Überspreadsheet, I generated the Top Educators spreadsheet with 3-year averages. Thankfully, I did not have to revise my code for this as the Überspreadsheet format remains the same. Finally, I revised the Top Educator Lists so that the ordering of the institutions is accurate after the corrected data.
I am happy to have fixed the issue and that my work will get published on the APS website after all. It is very important to our physics community that institutions can use the Compare Your Institution and Top Educators web pages to know where they stand and what they need to do to improve diversity and inclusion in their physics education programs. I am now focusing on my presentation and finalizing my work at APS. I am excited to present and talk about this 10-week journey, where I learned a lot!
Zeynep Tuna (she/her/hers)