Prof. Johnson teaches Data and Knowledge Management

Week 11 Follow-Up and Week 12 Reading

Week 11 Followup

Unfortunately, there is no Fox Class Capture available for Wednesday’s class. (The class capture did not follow us to the computer lab.) You can find a copy of the database we used for the exercises, along with the hand-out from class, here.

Week 12

Assigned reading:

a) Pivot Table Reports 101 (expand sections at bottom of page to read entire page.)

b) Learn to use Pivot Tables in Excel 2007 to Organize Data. If you have never used Pivot Tables before, or at a little bit rusty with them, I highly recommend downloading the example spreadsheet (available at the bottom of the article) and working through the examples.

c) Chapter 4 (Hacking Pivot Tables) of Excel Hacks, Second Edition by David Hawley and Raina Hawley (2007). Free online access available via Safari books online via Temple Library — on campus or search for Safari at Temple library database finder.

Reading discussion question:

a) When would you prefer to have a “data dump” to analyze data with Excel pivot tables and when would you prefer to use Access queries?