There is some useful stuff on Element 14 on using the Raspberry Pi for some great appliacations.
However for an absolute newcomer, some of this is daunting as it assumes a certain amount of basic knowledge.
This can keep a lot of this information "out of reach" of a large chunk of potential users. In the interest of getting people started off on the Raspberry Pi, we have put together a couple of presentations.
These are on Slideshare.
This one is on getting started and getting to the raspberry on the screen
This one is on using Python to turn an led on and off and reading the status of a switch.
Enjoy.