I have a Bachelor's of Science in Computer Engineering
A career in Game Developement
Planning to persue Masters in Computer Graphics.
Games to my name: Madden 2005, NFL Street 2, and Cosmic Blobs
Studying to become a "game designer" is a bad idea, but let me tell you why I like my career first. Now yeah, some of the hours are tough and long, but I personally love it. Now that I've cut my teeth, I demand certain standards of deceny related to work hours and pay. I'm currently making a healthy salary $60k+/year, I work no more than 60 hours tops (crunch week 80-90), and I'm only 23. Only EA made me work 100+ hours.
Now, becoming strictly a "game designer," those people are definitely not needed. Game designers, good ones at least, emerge from other facets of the development process, be it art, programming, modeling/level creation, music/audio, because to be a good designer you have to have an understanding of the nuts and bolts of game development, and the only way you're going to do that is by working from the bottom up. A person that just designs, yet has never written a line of code, model a single entity, created a piece of art, or written a piece of music for a game, would you really trust their decision making?
So what to major if you want to get into games? Well the defacto standard is Computer Science, but I'll try to break it down here.
1. Computer Science: a BS in CS will give you a broad understanding of high level computer languages and a fundamental understanding of data structures and algorithms. Throughout school make your projects as game oriented as possible. A perfect example of this is to make your capstone project a game.
2. Computer and Electrical Engineering: Similar to CS, but an understanding at a low level of programming and hardware development. Here you will grasp the low level concepts of computer hardware, memory management, whilst learning some high level stuff. Couple this with a CS minor and it makes you quite diverse. An EE would more likely work strictly on hardware, making controllers, graphics cards, sound systems, all low level stuff. Similar to CS, try to incorporate games as much as possible into your work. Example: my capstone project was an electronic version of the game mastermind.
3. Mathmatics and Physics: A more non-traditional route that will most likely require a CS minor. However, being an proficent Mathematican/Physcist, especially with a solid grasp on 3D concepts can definitely put you in a sweet niche of game developers.
4. The Arts: This is a tough route, but very doable. There are many, many, average artists, and only a few talented ones. How do they separate themselves from the pack? Increasing the range of their skill set. An artist that knows the digital medium well and knows the tools (Maya, 3ds Max, Adobe Suite, Macromedia Suite, and so on). Getting a basic understanding of programming and web development can go a long way to helping an aspiring artist too. The same can be applied to music/audio (I'm lumping it together, but they are 2 very important and different facets of development), become excellent at your craft, but learn the digital/computer side of it. An audio engineer has to be able to mix tracks and create sound affects all via a computer. I am not very familar with what programs they use, though.
So there is a basic, brief overview how you can educate yourself and prep for the games industry. There are other avenues, such as writing, but those 4 I am most familar with. I personally love it, but its definitely not for everyone. I really enjoy it because its the only job I found where I can really practice my craft in an extremely creative enviroment. Database programming/management, can only get so creative in those areas
Good luck and remember to enjoy the ride through college. It shouldn't be study, study, study all the time. If you have any questions, feel free to ping me.