Listen! You are not dead in water at all. There are other good schools out there and they want you more than students who failed ** courses. Just apply to the other schools and go back to the books as soon as you can. So what you don't pass the shelf exams?
Just go to a different school and seek advise from professors at your new school.
I wish you all the best! Hang in there tight
