Can you believe it? The past fourteen weeks just flew by. Time to wrap up and look back, all the way to that first chilly Tuesday in January.
Remember that the final written exam will be held on Tuesday, April 21, 2009 at 4:00pm in room A2712. The take-home portion of the exam is due before the written exam begins. Don’t put it off until the last moment — you never know when we might have another power failure.
Posted in Notes by Dave, April 8, 2009 3:37 pm | Comments Off
For our optional topic, we’ll sharpen our search techniques and figure out what this thing called RSS really is. We’ll also take a tour of online applications that are starting to rival the features of Microsoft Word and Excel.
Readings and Links
RSS Feed Readers
Most recent browser versions can act as RSS feed readers themselves, but the online services and downloadable software products are more capable. All of the following are free.
Posted in Notes by Dave, April 7, 2009 9:36 am | Comments Off
Combining Word and simple tables from Excel is a surprisingly powerful tool. Despite its name, mail merge is useful for more than just written correspondence and mailing labels, but we’ll start with that.
Readings and Links
Posted in Notes by Dave, April 1, 2009 11:47 am | Comments Off
Scatter charts are used whenever the category axis values are numeric and continuous (that is, fractions are allowed).
Readings and Links
Posted in Notes by Dave, March 31, 2009 12:37 pm | Comments Off
Rather than dumbfound your audience with ream upon ream of figures, spellbind them with a glorious chromatic Excel chart that summarizes all of those fiddlesome numbers into a smiling pie-shaped graphic.
Posted in Notes by Dave, March 26, 2009 7:59 am | Comments Off
To Excel, dates are just numbers with fancy formatting applied. That means you can do math with dates. Now, adding two dates together doesn’t mean much, but subtracting one from another is useful.
Posted in Notes by Dave, March 24, 2009 8:32 am | Comments Off
Functions are pre-packaged formulas that can perform fairly complex calculations in our formulas.
Posted in Notes by Dave, March 18, 2009 11:15 am | Comments Off
If you find yourself reaching for the calculator while working with Excel, you’re doing it wrong.
Posted in Notes by Dave, March 17, 2009 11:01 am | Comments Off
A novel idea for computers: let them do the math.
Readings and Links
Posted in Notes by Dave, March 6, 2009 8:20 am | Comments Off
Word’s built-in Heading styles are more than just pretty fonts, especially when you combine them with a numbering scheme, or by cross-referencing them with page numbers in a table of contents.
Posted in Notes by Dave, March 3, 2009 8:33 am | Comments Off