I've been shot in my dreams too.... it's rather horrific when you die in a dream. (Although I actually have a deep sympathy for zombies due to one of these dreams... whereupon I was a zombie and I just wanted to be buried!)

You can certainly be a productive citizen, it just might take a bit of adjusting to find out how you can be at your most productive, and probably shifting your expectations of yourself (because really now, 'society' has got some rather harsh expectations that so many of us can't meet no matter what we do!)

What field of work are you wanting to go into btw? It's great that you've got a goal you're working towards - I'm sure that there's a way to work in your prospective field and be successful at it!