How colleges look at academic transcripts

Applying to College Admission Stories
1

How a D of chemistry affect the admission? My other records are mostly A and B. My SAT is over 2000. How much is my chance for “seven sisters”. Please advise. Thanks.