How then do I mange the expectation of people on me such that i don't get into depression when I'm unable to meet up with it.?
It's almost like everyone knows you're going to succeed but don't even care about what you're passing through while you're striving to make them proud.
You shouldn’t live base on expectations of other people because you will just feel pressured on your life choices most importantly when you experience failure which you will not bothered if you are free to do whatever you want.
You should remember that the majority of top rich people doesn’t do well on university but they manage to climb the wealth due to their passion. Sometimes people are not good on study because their skills is for actual work. You should find your passion and don’t live on someone expectation.
You should watch this Steve Jobs speech to Stanford because it tackles specifically to your situation. I hope it help you to boost your confidence.
https://www.youtube.com/watch?v=UF8uR6Z6KLc