Group Members: Alex, Lucas, Jiao Jiao, Shalim, Jeremy
Problems
- What issues have you run into?
- There were no issues in data collection, all the data was nicely formatted already and was quite simple to translate over to our spreadsheet
- The Carletonian’s articles only ended in the class of 2020, which is the freshman class who applied during the 2015-16 application cycle.
- Have they forced you to change your initial plan?
- No, it just means we can’t solely rely on the Carletonian
- Do you have a proposed solution or do you need help formulating one?
- We will simply have to find other resources (i.e. the US News and World Report) to analyze a particular year whose trends we find interesting.
Tools and Techniques
What applications/languages/frameworks have you selected and how are you going to implement them?
- We used Google Sheets to input our data into; we have created a csv file
- We will use Flourish to create visualizations showing interesting trends we found in our data. There will be some dynamic as well as some static visualizations.
Deliverables Timeline
- By the end of week 9, we plan to have finished our data and trend analysis and have begun our presentation. In week 10, we will finish up our presentation and then present our findings to the class.
- Is your project still on track?
- Yes, our project is still on track to being completed on time.
Citations/References
Rothfeld, Ian. “Admitting the Class of 2028: Admissions after affirmative action and legacy preference.” The Carletonian, 5 Apr. 2024, https://thecarletonian.com/19046/news/admitting-the-class-of-2028-admissions-after-affirmative-action-and-legacy-preference/.
Culligan, Bea. “Carelton accepts class of 2027.” The Carletonian, 20 Apr. 2023, https://thecarletonian.com/17844/news/carleton-accepts-class-of-2027/.
Polanco, Aldo. “Carelton 2026 profile: lowest acceptance rate to date.” The Carletonian, 12 May. 2022, https://thecarletonian.com/13144/news/carleton-2026-profile-lowest-acceptance-rate-to-date/.
Quast, Sophia. “Class of 2025 Profile.” The Carletonian, 3 Oct. 2021, https://thecarletonian.com/11275/news/class-of-2025-profile/.
Matican, Ross. “Class of 2024 sees higher acceptance rate, larger proportion of early decision admits.” The Carletonian, 10 Apr. 2020, https://thecarletonian.com/8674/news/class-of-2024-sees-higher-acceptance-rate-larger-proportion-of-early-decision-admits/.
Matican, Ross. “Class of 2023 currently over-enrolled, more diverse than anticipated.” The Carletonian, 18 May. 2019, https://thecarletonian.com/6181/news/class-of-2023-currently-over-enrolled-more-diverse-than-anticipated/.
Sutherland, Rachael. “Acceptance Rate Drops to 19.4% for Class of 2022.” The Carletonian, 6 Apr. 2018, https://thecarletonian.com/5364/news/acceptance-rate-drops-to-19-4-for-class-of-2022/.
Stein, Perrin. “Low acceptance rate for class of 2021.” The Carletonian, 7 Apr. 2017, https://thecarletonian.com/5035/news/low-acceptance-rate-for-class-of-2021/.
Miller, Julia. “Class of 2020 yeild largest in Carleton history.” The Carletonian, 27 May. 2016, https://thecarletonian.com/4789/news/class-of-2020-yield-largest-in-carleton-history/.
Carleton. “Common Data Set (CDS)” Institutional Research and Assessment, 18 Apr. 2023, https://www.carleton.edu/ira/institutional-data/cds1/.
“The Best Undergraduate Teaching Liberal Arts Colleges.” US News & World Report, 2025, www.usnews.com/best-colleges/rankings/national-liberal-arts-colleges/undergraduate-teaching?_sort=rank&_sortDirection=asc. Accessed 17 Mar. 2025.
Personal messages:
Overall, the work has been fairly evenly split among the group members.
Jeremy: I’m responsible for getting information for the years 2009-10 until 2013-14 on Freshmen Men Applied, Freshmen Women Applied, Total Applied, Men Admitted, Women Admitted, Total Admitted, Freshmen Men Enrolled, Freshmen Women Enrolled, Freshmen Total Enrolled, Acceptance %, and Application Fee $.
Lucas: So far, the work I have done on the project has been to collect the data and information on class years from 2014-15 to 2018-19. This information has been on the numbers of men, women, and total applied, admitted, and enrolled. Once this was collected, the acceptance rate% was then calculated and whether or not there was an application fee.
Alex: I was responsible for gathering data for 2004-5 to 2008-9. I collected data for Freshmen men and women (numbers applied, admitted, and enrolled). The acceptance rate was also calculated. I noted the admission fee price and whether or not there was an online fee.
Shalim: I was responsible for gathering data from 1999-00 to 2003-04. I translated the data on total female and male applicants, total male and female enrollments, and total males and females enrolled of the incoming freshman class from the datafiles into our spreadsheet. Along the way, I also calculated the acceptance rate and noted the admission fee.
Jiao Jiao: I gathered the data for 2019-2020 to 2023-2024, including the number of freshmen men, women, and total who applied, were admitted, and enrolled. I also looked through the sources for whether or not there was an enrollment fee for that year; there were none for all of the years I looked at. Acceptance rates and totals were calculated in excel.
7 thoughts on “Final Project Update”
Leave a Reply
This site uses Akismet to reduce spam. Learn how your comment data is processed.
This is such a clear and organized update! I’m really impressed with how your team has divided the workload and kept the project on track despite the limitations with the Carletonian data. I like your flexible approach of pulling in other sources like US News and World Report to fill the gaps — it’s a smart solution that keeps your analysis comprehensive. I’m also looking forward to seeing how the trends play out visually with Flourish. It sounds like your team is managing the historical scope of the data really well! Keep up the great work!
It’s great to see that your group’s final project is going well. You all seem to be doing a great job dividing up the work and staying within your timeline. Regarding the complications you have encountered, such as the issue with using just the Carletonian data, it seems like you have the right idea about what to do next.
Hi all! It sounds like you have made great progress toward the final project. The scope of the research is fascinating and I look forward to seeing the results! I wonder if the data would look different if collected from when the college first admitted female students. I’m sure that data would be hard to acquire but would be interesting to compare.
Sounds like your team is making solid progress! It’s great that the data was already well-formatted—definitely makes things easier. Running into the Carletonian cutoff seems like a bit of a hurdle, but your plan to supplement with other sources is a smart move. I like that you’re using Flourish for visualizations; it should make the trends really engaging. Seems like the workload is well-distributed too, which is always a plus. As your classmate, I’m really looking forward to seeing the final analysis!
I really like Flourish for data visualization so I am excited to see how the final project turns out! You guys have divided up the work in an interesting way. We simply divided different types of work but I think the way you guys did allows everyone to dabble in different aspects of the project. I’m excited to also hear about particular years with interesting trends.
The project sounds interesting! I am curious if you guys will be doing any amount of inference relating to the data you are collecting. It sound like you guys are currently just visualizing the csv values already created. This of course will still be valuable to see trends over time for the various forms of data, but I would be curious on analysis you could add. It seems possible that you could create new variables or add predictions along with the existing data. Either way I think that this project will turn out great!
Your project is coming along well! It’s great that data collection was easy and that you ran into any problem. The timeline looks solid, and it’s good to see the work split evenly. Looking forward to seeing your final presentation and the trends you’ve discovered!