ICS 101 Tools for the Information Age (Spring 2010)

Excel Show and Tell

Example 1: Winter Olympics Medal Counts

  • Vancouver 2010 Winter Olympics Medal Counts
  • Sorting
  • Charts
  • Add region
  • Pivot tables

    • Example 2: Plotting a mathematical expression

  • y=sin(RADIANS(x))

    • Example 3: Financing a Car

  • Wikipedia link with monthly payment formula
  • PMT function.
  • cf Credit Card

    • Example 4: Course Planning

  • List of ICS courses
  • Get pre-requisite information from UHM ICS Course Catalog
  • Boolean Expressions
  • grade B and higher: OR( grade="A", grade="B")
  • grade B and higher for ICS 111 and ICS 211: AND(OR( C1="A", C1="B"),OR( C2="A", C2="B") )