Trying to transfer to a good university after dismissal

You need a few more semesters at the CC maintaining that GPA - ideally you’d apply after earning 45 credits or so, with a 3.5+ GPA. You’re on the right track, now you need to demonstrate your ability consistently and earn the right credits for your major.