If you repeat the exact same course, your repeat grade will be factored into your UC GPA, but you still have to report your F grade on the application.
The UC’s have their own GPA calculation which uses only 10-11th grades in the a-g course requirements, so the first thing you need to do is calculate your UC GPA Unweighted, Capped Weighted and Fully Weighted at the end of Junior year.
https://rogerhub.com/gpa-calculator-uc/
Having already 1 C grade Sophomore year puts at a disadvantage at UCB since applicants with 4.0+ UC GPA’s are rejected.
UC’s tend to be very GPA focused but for a school like UCB you need a competitive overall package. HIgh GPA. High test scores, interesting EC’s and essays. An SAT of 1200 is not going to make it. Think around the average of around 1400+.
Also intended major can play a significant part for your chances. The more competitive the major, the more competitive stats are needed.
Just to give you some statistical data for admit rates based the Capped Weighted UC GPA and SAT ranges for each UC:: see below:
Freshman admit rates for UC GPA of 3.40-3.79:
UCB: 1.8%
UCLA: 2.2%
UCSD: 7.2%
UCSB: 10.1%
UCI: 11.1%
UCD: 16.6%
UCSC: 43.8%
UCR: 63.3%
UCM: 88.7%
Freshman admit rates for UC GPA of 3.80-4.19:
UCB: 12.6%
UCLA: 11.7%
UCSD: 38.7%
UCSB: 53.6%
UCD: 56.5%
UCI: 52.1%
UCSC: 75.7%
UCR: 90.1%
UCM: 96.1%
Freshman admit rates for UC GPA of 4.20 or above:
UCB: 42.7%
UCLA: 47.2%
UCSD: 84.2%
UCSB: 82.0%
UCD: 90.3%
UCI: 94.1%
UCSC: 92.7%
UCR: 97.5
UCM: 98.1%
25th - 75th percentiles for SAT:
UCB: 1280-1490
UCLA: 1280-1500
UCSD: 1250-1470
UCSB: 1210- 1450
UCD: 1190-1430
UCI: 1190-1420
UCSC: 1170-1380
UCR: 1090-1310
UCM: 1020-1230
SLO uses 9-11th grades so you can plug in the same data into the UC GPA calculator but include 9th grades for the SLO GPA. SLO’s GPA is capped at 8 semesters of honors points taken 10-11th grades.
Here is the SLO Freshman Profile for 2017 by College. You can compare your stats to the admitted students to get an idea of your chances:
https://admissions.calpoly.edu/prospective/profile.html
Based on what you have posted all schools like like a Reach at the moment. You need to concentrate on getting good grades and cut back on your EC’s.