CCPA Programs and Resources Summer 2022
Expand your knowledge and skill set this summer through some programs and workshops, as well as through self-guided learning opportunities.
Offered by CCPA
Excel Basics Series [Intro Level] - AESOP Virtual Learning Program, Technical Skills Workshop
Saturday, June 4, 2022. 10:00 a.m.-12:30 p.m. EDT
Whether you want to work for a non-profit, a large or small company, a startup, or become an entrepreneur, these foundational Excel skills will kick start your professional building blocks so you can comfortably work through an Excel task. This workshop is crafted specifically for intro level Excel learners.
Captivating Outreach & Self-Marketing Communications - AESOP Virtual Learning Program, Professional Skills Workshop
Saturday, June 4, 2022, 3:00 p.m. - 4:30 p.m. EDT
Crafting communications that resonate while networking.
Learning how to effectively market yourself to experienced professionals is a key skill to develop during the career search process and will continue to be utilized throughout your career – whether pitching your services, changing careers, or connecting internally for new opportunities.
In this session, we will learn how to develop the captivating outreach message so you can proudly represent yourself as you introduce your talents to the professional world and employers.
Excel Essentials Crash Course: Data Analysis & Reporting [Intro – Mid Level] - AESOP Virtual Learning Program, Technical Skills Workshop
Saturday, June 11, 2022, 10:00 a.m. - 2:30 p.m. EDT
Data analysis and reporting using essential Excel techniques.
Join us for this Excel series that brings together essential Excel methods and techniques to help you quickly and successfully step into your career, irrespective of industry.
Crash Course into Tableau Analytics - AESOP Virtual Learning Program, Technical Skills Workshop
Saturday, June 18, 2022, 10:00 a.m. - 2:30 p.m. EDT
A ‘learn by doing’ crash course series into Tableau analytics, data visualizations, & dashboard development.
New industry leading tools like Tableau are now designed to simplify the process of blending, aggregating, and analyzing data through intuitive visualizations and functions. In this series, students will learn the powerful tool of Tableau that helps quickly blend data sources to generate a simplified dashboard that multiple users can access to enable data analytics at scale for any organization.
SQL Crash Course into Data Extraction & Query Creation - AESOP Virtual Learning Program, Technical Skills Workshop
Saturday, June 25, 2022, 10:00 a.m. - 2:30 p.m. EDT
SQL (Structured Query Language) is a programming language designed to manage data stored in relational databases. This is a skill that is in demand in this data-driven era where organizations are seeking to extract, analyze, and make sense of the data stored in their warehouses. Having this ability makes any employee the ‘gatekeeper’ of key digital information that drives business decisions.
Watson Fellowship Info Session
Tuesday, June 28, 6:00 p.m. to 6:45 p.m. EDT
Plan ahead for a unique fellowship for the year after you graduate. The Thomas J. Watson Fellowship is a one-year grant for purposeful, independent exploration outside the United States, awarded to graduating seniors nominated by one of 40 partner colleges.
For the class of 2023, the application deadline is Thursday, September 1, 2022.
Capitalism, Survival Guide: Money, Housing, Jobs, and other Real World Skills
Saturdays July 9, 16, 23 and 30, 2022. 2:00 - 3:00 p.m. EDT
Haverford is a caring, supportive environment designed to help you reach your full potential. The real world is... different. During this series, you’ll learn useful survival skills for post-college life. By grasping a few important concepts now, you’ll be ready to approach your professional/adult existence with less stress and uncertainty.
The format for these sessions will be informal with plenty of time for Q&A. The series is hosted by an HC alum and will feature other alumni guest speakers.
Topics will include:
- Money (managing your expenses and debt)
- Investing (how to not lose money once you have it)
- Lifestyle Design (housing, transportation, and other expensive decisions)
- Jobs (how to find one you like, how to actually get hired)
Career Success Series — a CCPA resource created for students
An online, self-paced program designed by CCPA for first-years and sophomores – but open to students from all class years – to explore and focus your career interests and prepare to apply for internships, jobs, and other opportunities. Read our blog.
Search volunteer projects worldwide where you can contribute and gain substantial skills.
Build skills with courses online from world-class universities and companies. There are many free courses.
By opening the classroom through online learning, edX empowers millions of learners to unlock their potential and become changemakers. Many of the courses are free.
LinkedIn Learning – a resource provided by the College
Enhance your skills with expert-led online video tutorials. Browse courses from beginner to advanced within business, technology, and creativity! Log in or activate your account via the link http://hav.to/learn.
LinkedIn Learning Collections – created by CCPA
Management Consulted – CCPA subscribes to this resource
Available between June 1 and August 31, 2022
One-stop consulting prep. Provides recruiting, interview prep, and skill-building help with interactive courses on topics like developing an effective resume and cover letter (with templates), networking (including how to write an effective cold networking email that will get opened), interviewing (with example videos, specific case interviews, drills, and 500 practice cases), and Excel and PowerPoint training.
This collection features free lessons and practice materials in 48 languages, including Spanish, French, English, Mandarin, Italian, Russian, ASL, and more. Stream or download audio lessons.
Explore multiple paid short assignments, ranging from 5-40 hours of work, with organizations across a variety of industries. You decide which opportunities seem most interesting based on assignment details, deadlines and pay. Start looking by creating a free account!
"Picture Your Career: Visualize and Plan Your Career Path"
Written by Katharine Brooks and Grace Foy of Vanderbilt University’s Career Center, and illustrated by Emilly Mills.
This guidebook contains dozens of interactive exercises. Using visual thinking techniques, this workbook will help you discover your strengths, develop your vision, design a path forward, and deliver your talent.
Prep Lounge – CCPA subscribes to this resource
Join the world's leading case interview community and get access to 234,000+ case partners, 140+ cases, 80+ video tutorials, 50+ framework articles, resume templates, mental math tools and much more.
Science Careers' myIDP
Though designed for PhD candidates, this self-guided assessment of one's interests, values, and skills is applicable to undergraduate science students. It combines the self-assessment with recommended pathways in science (i.e. Government Affairs, Science Policy, etc.) and provides opportunities to learn more.
Student Physics Society Careers Toolbox
The Careers Toolbox focuses on undergraduate physics students entering the workforce after graduation. Many of these tools can be applied to finding internships, research positions, or even entrance into graduate programs.
Discover free, curated video series and lessons on topics such as “Our Changing Climate,” “Math in Real Life,” “Think Like a Coder,” “Master the Art of Storytelling,” and so much more!
The Way We Work
The Way We Work is an original video series where leaders and thinkers offer practical wisdom and insight into how we can adapt and thrive amid changing workplace conventions.
Firsthand (formerly Vault) – CCPA subscribes to this resource
Explore careers through in-depth overviews, including “insider” data on industries, employers and internships. Access this through our subscriptions page by logging in with single sign on.
Wall Street Prep Student Passport – CCPA subscribes to this resource
Wall Street Prep’s Student Passport picks up where the academic textbook leaves off to teach students the real-world Excel, financial analysis and Powerpoint skills bankers use most before taking them step-by-step through the financial and valuation model-building process. Register for unlimited access. Space limited- first come first served.