unnecesary but just for fun:
Airfoil: wifi audio streaming for airport express
iAlertU: motion sensitive security system
Delicious Library: barcode scanner for isight
Grab: configurable screenshot capturer
EarthDesk: realtime satellite...
You should be able to get a free repair (or suitable replacement) under the CCD issue, or you can upgrade to A560 ($89), SD1000 ($100), or SX100 IS ($125) as refurb replacements.
Canon Loyalty Program - return old camera, get better camera
I disagree. problems in the long run- three to five years- won't be dealt with by your local stores. you will be dealing with the manufacturer's warranty directly. go for cheap sales, but hold out for reputable lines. many decent online...
undergrad degree is the new high school degree. really consider a masters or phd if you are looking for a high tier position. good news is you get to enjoy and work hard towards your personal subject of interest in undergrad....