Computer Science Transfer from CCC

I am transferring from a CCC to a UC and my major is Computer Science/engineer.
My highest goal is UCSD, UCD, and UCI, and the minimum goal is UCR, UCSC.

Currently, I have 3.73 GPA, 64 units. (Overall)

I got a D in Calc II, retake and got B.
I got an A in C++, Java, and Calc I.

Major preq GPA: 3.76 (Calc I, java, C++, Calc II)

IGETC: Finish.

Major Prereq: Cal III, 2 Physics, Differential, Linear Algebra left.

My application denied: Fall 2018 for UCI and UCD (Which my GPA was 3.53 bc I got a D in Calc II)

I’m not sure how my gpa gonna be change after I finish all my major preq course.
However, I assumed that the worst way ( which get all B in the major preq) overall gpa will be 3.56
and best way (which get all A in the major preq) overall gpa will be 3.80

The biggest problem to me is I’m not sure which school that I should apply for TAG.
My counselors, friends, and even this forum prefer me to TAG UCI, but I can’t find the reason that why TAG for UCI is the best option.
I heard that it is possible that UCI denied my TAG because I have an academic history that got a D in Calc II.

Also, I never had any withdrawal yet, but assume that prob will use withdrawal in physics or differential equation. Is this gonna be critical to my application in UC?

The last question, Since my highest goal is UCI UCSD and UCD, I know these schools are really hard to get in. However, you guys think I still have a chance to enroll to UCI UCSD UCD? or should I aim more to UCR and UCSC and CSU (SDSU or SJSU) to secure transfer?

I already asked this question to my counselor, but I just want to hear you guys opinion about me. I think it is great opportunity to get another opinion about me so.

You can TAG UCI as you retook Calc 2 and eliminated the D. There are no specific limitations within the Irvine TAG for Computer Engineering and the major requires at least a B cumulative in all major course work. So as long as all major coursework is complete via assist with a combined major GPA of 3.0, you should be able to TAG Irvine. The Ws, as long as they are retaken, should be fine.

http://admission.universityofcalifornia.edu/counselors/files/tag-matrix.pdf

Thanks for helping me. I have one more question about the tag.
According to assist.org,
I could finish all the course in MAJOR PREPARATION COURSES REQUIRED FOR TRANSFER

However, I will miss the 2 courses in ADDITIONAL APPROVED COURSES FOR THE MAJOR bc No course articulated.

Should I have to take 2 courses for TAG UCI? or I can just take the courses that I have and forget about that?

If they’re additional approved they are not required. You’re fine.