^^^ @suzy79: The short answer: No.
The long answer: Yale does not recruit by major. All student’s apply to Yale as Liberal Arts Majors, and choose a major during their sophomore year. So, whatever students select as their “intended major” on the Common Application has absolutely no bearing on their chances. Nor does writing an essay about CS (or any other academic subject) increase your chances of acceptance.
The reason: As more than 60% of US college students switch majors during their 4 years of school, it’s impossible for an Admissions Office to use an applicant’s “intended major” as a recruiting tool, as most students will graduate with a major that is different from the one they wrote down on the Common Application. The same thing applies to writing an essay about CS or another academic subject.
Colleges ask about your “intended major” to see how committed you are to your interests – the idea being that your commitment, energy and drive is a transferrable skill. So whatever student’s write down as their “intended major” they should make sure they have documented evidence in the rest of their application of their commitment to that major.
FWIW: If you’re applying to a college with an “intended major” of Computer Science, rather than writing an essay about CS, you should consider creating a website that displays your CS skills by posting examples of games or app’s you have created or designed – along with a link to the code you wrote, so Admissions can forward it to the CS department for evaluation. If you can demonstrate that you have CS skills beyond that of an average high school senior that might be impressive and increase your chances.
Full Disclosure: My son applied to colleges by hanging himself on the “Computer Science Display Rack” and selected CS as his “intended major.” In addition to three specific essays not related to an academic subject, he submitted a link to his website which contained several computer games written in Java, Python and SQL, as well as animations written in Adobe Flash. Along with each game/animation, he included a link to the code for inspection. My son graduated from Yale in 2015 with a degree in Psychology (yes, he switched majors) and is a now project owner and data scientist with a well known tech company.