Does coffee actually help to wake someone up, or is it just a mind over matter type deal?

I heard once that coffee actually doesn't do anything to make someone more alert, and it was just one believing it did.