Will this affect my dream college?

My dream college is Ucla or NYU or maybe even UM.. My grades as followed all a's and one B in algebra... I am in the 7th grade taking algebra and next year honors geometry.... I got a B on the mid-term and HSA. I got a D on the final exam!!! I studied so hard and also a lot of friends that are really smart got E and and some D.. though passing. I asked my counselor would this affect me later for college she said no, i mean they( college people) really look at that you passed the course.. not really on the grades... Will this affect me later for getting a scholarship to any of my dream colleges??? Plz Help?????