<p>fresh start
I have not read everyone’s replies so excuse if it is redundant, but here would be my advice.
Go to CC for a year and amass some EXCELLENT grades. Take on some impressive projects you can list on your app. Cultivate some wonderful glowing recommendations. Then apply with all your transcripts (you MUST) and an essay explaining how you have had a shift in attitude and priorities. This honest approach would not at all be considered odd to admissions. Seriously, LOTS of kids bail and come back with a winning work ethic after a time in the real world. You are not the first nor will you be the last. Tell admissions you don’t even care if they honor ANY of your credits, you just want to start over with your new found attitude and your most recent classes were taken to prove you are capable of doing the work required. You may not get an undergraduate chance at a top tier, but that is not necessarily the end of your education. If you are that motivated and have a wonderful showing in whatever undergrad program you can into, you have an excellent chance of getting into a top tier graduate program. And ultimately for your stated line of desired work, you may need to get a masters.
Best of luck to you.</p>