https://www.berkeleytime.com/ can be helpful in learning what percentage of students in prerequisite courses for GPA-based goals (e.g. capped major, pre-med) earn grades high enough to be helpful for those goals.
Note: percentages may change in the future as additional semesters’ worth of courses and grades are added. Also, many courses may include students who goals are other than the GPA-based goals listed below.
For example, L&S CS requires a 3.3 GPA in CS 61A, 61B, 70. https://www.berkeleytime.com/grades/?course1=2321-all-all&course2=2323-all-all&course3=2327-all-all indicates that the percentage of students earning a B+ or higher is:
49% in CS 61A
59% in CS 61B
47% in CS 70
Pre-meds commonly take Biology 1A, 1AL, 1B; Chemistry 1A, 1AL, 3A, 3AL, 3B, 3BL; MCB 102; Physics 8A, 8B; Math 10A, 10B. Pre-meds typically aim for a 3.7 GPA or higher to have a decent chance of medical school admission. From https://www.berkeleytime.com/grades/ , the percentage earning A- or higher is:
22% in Biology 1A
31% in Biology 1AL
22% in Biology 1B
27% in Chemistry 1A
69% in Chemistry 1AL
23% in Chemistry 3A
88% in Chemistry 3AL
27% in Chemistry 3B
76% in Chemistry 3BL
23% in MCB 102
28% in Physics 8A
28% in Physics 8B
31% in Math 10A
35% in Math 10B