Class is held every Monday and Wednesday, unless otherwise noted below, from 1:00PM to 2:15PM in room 5502 of Sennott Square.

My office hours are on my contact page.

It's best to setup an appointment with me before you come to see me during my office hours so that you are guaranteed to be able to talk with me. Of course, you are also free to just walk in, but an appointment guarantees that part of your time won't be spent waiting for me to finish helping another student.

• Week 1:
  • Jan. 6 (Wednesday): Class introduction, computer parts and terms
    • Bob's Quick Guide to the Apostrophe
    • How to use semicolons
• Week 2: Word 2007 Shortcuts
  • Jan. 11: shortcuts & mini-lab 1
  • Jan. 13: Document views, side by side view, splitting view, non-breaking spacing, symbols, lists, images (types, formats [including pros and cons of each]), typesetting units
    • JPEG Compression Example
    • Raster Versus Vector Example
• Week 3:
  • Jan. 18: no class (Dr. Martin Luther King's birthday observance)
  • Jan. 20: Lab 2
• Week 4:
  • Jan. 25: Images (inserting into your document, manipulating them in your document), styles, columns, figures
  • Jan. 27: Citations, Tabs, headers, footers, Homework #1 released
• Week 5: Excel 2007 Shortcuts
  • Feb. 1: Excel! (SUM & AVERAGE functions, referencing other cells, basics of moving around and formatting spreadsheets)
  • Feb. 3: In class lab #3
• Week 6:
  • Feb. 8: University classes canceled due to weather
  • Feb. 10: University classes canceled due to weather | Homework #1 due
• Week 7:
  • Feb. 15: IF statements (plus AND, OR, NOT), plus other useful functions (average, sum, count, min, max, standard deviation, square root, logarithms)
  • Feb. 17: In class lab #4
• Week 8:
  • Feb. 22: Some cell formatting (rotating columns, borders, adding a header/footer), print layout + margins, VLOOKUP, "advanced" copy and paste, conditional formatting
  • Feb. 24: Graphs & charts (plus FREQUENCY function)! | Homework #2 released | Pittsburgh Wikipedia Page
• Week 9:
  • Mar. 1: In class lab #5
  • Mar. 3: PowerPoint Shortcuts | PowerPoint intro: making slides, changing slide layout, customizing slide look, basic animations | Sketch comedy on how NOT to use PowerPoint | TED: Ideas worth spreading¹⁾
• Week 10: Spring Break: no classes
• Week 11:
  • Mar. 15: Review | Homework #2 due
  • Mar. 17: Test #1 (Word & Excel)
• Week 12:
  • Mar. 22: Lab #6 | Homework #3 released
  • Mar. 24: SmartArt, Charts, Drawing Tools, Motion Paths
  • Mar. 27 (Saturday, make up day): At Home Lab #7 (Do NOT come into class today unless you want to sit alone and use one of the computers)
• Week 13:
  • Mar. 29 Start of Access (database terminology, designing tables, entering data)
  • Mar. 31: Lab #8
• Week 14:
  • Apr. 5: Access queries and lookup values | Homework #3 due
  • Apr. 7: Lab #9 | Homework #4 released
• Week 15:
  • Apr. 12: Access Forms and reports
  • Apr. 14: Lab #10
• Week 16:
  • Apr. 19: We will not have class ²⁾ | office hours are extended (from 1:00 until 2:45) | Read/do at home topic: mail merge with Access data source
  • Apr. 21: Review for the final | Homework #4 due
• Week 17:
  • Apr. 30 (Friday): Final exam @ 8:00AM - 9:50AM

Download the syllabus from this link here.