Tag: Uncategorized

Top 10 Questions to ask a University IT Department – 2009

Over the last couple of years I’ve helped at the new student/ prospective student admissions department fairs at Temple University. As a result, I’ve managed to get a sense for the typical questions that parents or students ask the IT department and also possibly the types of questions they should be asking. So here’s my list for 2009 of the top 10 topics you should ask the IT department at your university.

  1. Technical Support
  2. Software discounts
  3. Hardware discounts
  4. Printers and Printing
  5. Residence Hall Room network restrictions
  6. Wireless Access
  7. Seminars and Training
  8. Computer Labs and Social Spaces
  9. Off-campus access to restricted resources
  10. File Space

Buying 220V Gadgets

Whenever my parents visit there’s always a dilemma about what gadgets they can take back with them. On the one hand they can walk into Best Buy and pick up any 110V gadget and buy the appropriate voltage converters but on the other hand you can take a trip out to Edison, NJ or Jersey City, NJ or Jackson Heights, NY.

This year, the store that worked out for all my Dad’s gadget needs ended up being:

808 Newark Ave,
Jersey City, New Jersey

How to compare data in two columns to find duplicates in Excel

More information regarding comparison of data in two columns is available at http://support.microsoft.com/kb/213367, however method 1 in this solution is an interesting approach to this issue.

Method 1: Use a worksheet formula
To use a worksheet formula to compare the data in two columns, follow these steps:

  1. 1. Start Excel
  2. In a new worksheet, enter the following data (leave column B empty):
    A1: 1   B1:     C1: 3
    A2: 2   B2:     C2: 5
    A3: 3   B3:     C3: 8
    A4: 4   B4:     C4: 2
    A5: 5   B5:     C5: 0
  3. Type the following formula in cell B1:
    =IF(ISERROR(MATCH(A1,$C$1:$C$5,0)),””,A1)
  4. Select cells B1:B5.
  5. In Microsoft Office Excel 2003 and in earlier versions of Excel, point to Fill on the Edit menu, and then click Down.

In Microsoft Office Excel 2007, click Fill in the Editing group, and then click Down.

The duplicate numbers are displayed in column B, as in the following example:

A1: 1   B1:     C1: 3
A2: 2   B2: 2   C2: 5
A3: 3   B3: 3   C3: 8
A4: 4   B4:     C4: 2
A5: 5   B5: 5   C5: 0