everything.study
15.564

Information Technology I

Graduate · Historical course

Spring 2003

Topics

  • Introduction: Course Overview; Inside the CPU
  • Computer Architecture: Processing, Memory and I/O
  • Computer Representations; Compression
  • Operating Systems
  • Software Development
  • Relational Databases; Database Queries using SQL
  • An Introduction to Microsoft Access
  • Relational Database Design
  • Introduction to User Interface Building with Access Examples
  • Telecommunication Concepts; Data Transmission
  • Local Area Networks; Ethernet; Packet-switched Networks
  • Wide Area Networks; The Internet
  • Wireless Network Technologies
  • Client/Server, Peer-to-Peer and the WWW
  • Security I: Public Key Cryptography
  • Security II: Digital Signatures; Network Security
  • Evolution of Web Technologies
  • Under the Hood of a Commercial Web Site
  • Data Mining, Data Warehousing
  • Software Agents
  • Student Presentations I
  • Student Presentations II
  • Trends in eBusiness Technology; Course Wrap-up

Readings

  • SES #: 1 · TOPICS: Introduction: Course Overview; Inside the CPU · READINGS: Madnick, Stuart. Little Man Computer.
    Reading assignment
  • Optional: How Computers Work. Parts 1-5.
    Listed reading
  • Listed reading
  • Listed reading
  • Gibbs, W. W. Software’s Chronic Crisis . In Scientific American. September 1994, pp. 86-95.
    Listed reading
  • Elmasri, and Navathe. Fundamentals of Database Systems. Benjamin/Cummings, 1989, Chapter 7 (plus pp. 143-144).
    Listed reading
  • SES #: 7 · TOPICS: An Introduction to Microsoft Access · READINGS: Recommended Textbook: Viescas, John L. Running Microsoft Access 2000. Microsoft Press, 1999.
    Reading assignment
  • SES #: 8 · TOPICS: Relational Database Design · READINGS: Watterson, Karen. Visual Basic Database Programming. Addison-Wesley, 1994, pp. 12-43.
    Reading assignment
  • SES #: 9 · TOPICS: Introduction to User Interface Building with Access Examples · READINGS: Recommended Textbook: Viescas, John L. Running Microsoft Access 2000. Microsoft Press, 1999.
    Reading assignment
  • Fitzgerald, and Dennis. Business Data Communications and Networking. 6th ed. Wiley, 1999, pp. 83-92, 107-129.
    Listed reading
  • Optional: Dodd, Annabel Z. Basic Telecom Concepts . Chapter 1 in The Essential Guide to Telecommunications. Prentice Hall, 1999.
    Listed reading
  • SES #: 11 · TOPICS: Local Area Networks; Ethernet; Packet-switched Networks · READINGS: Fitzgerald, and Dennis. Business Data Communications and Networking. 6th ed. Wiley, 1999, pp. 192-216.
    Reading assignment
  • Fitzgerald, and Dennis. Business Data Communications and Networking. 6th ed. Wiley, 1999, pp. 30-33, 164-189.
    Listed reading
  • Listed reading
  • SES #: 14 · TOPICS: Wireless Network Technologies · READINGS: Noll, A. Michael. Wireless Telephone Service . Chapter 9 in Introduction to Telephones and Telephone Systems (Third Edition) . Artech House Telecommunications Library, 1999.
    Reading assignment
  • Orfali, R., et. al. Client/Server Survival Guide. 3rd ed. Wiley, 1999, Chapters 2-3.
    Listed reading
  • Sadoski, Darleen. Client/Server Software Architectures–An Overview . Carnegie Mellon University, 2004.
    Listed reading
  • Listed reading
  • Zimmerman, Phil. An Introduction to Cryptography . Included in freeware documentation to Pretty Good Privacy (PGP) software program, which is downloadable.
    Listed reading
  • Behar, R. Who’s Reading Your E-Mail . Fortune. February 3, 1997, 57-70.
    Listed reading
  • Zimmerman, Phil. An Introduction to Cryptography . Included in freeware documentation to Pretty Good Privacy (PGP) software program, which is downloadable. pp. 11-36 (also skim Part 2).
    Listed reading
  • Introduction to SSL . Available on the Web.
    Listed reading
  • Orfali, R., et. al. Client/Server Survival Guide. 3rd ed. Wiley, 1999. Chapters 26-27.
    Listed reading
  • Optional: Wright, R. The Man Who Invented the Web . Time , May 19, 1997.
    Listed reading
  • Optional: Technology Forecast. pp. 545-592.
    Listed reading
  • SES #: 19 · TOPICS: Under the Hood of a Commercial Web Site · READINGS: Davis, Jeffrey. How it Works. Business 2.0. February 2000, pp. 112-140. Optional: Technology Forecast. Pp. 357-472.
    Reading assignment
  • SES #: 20 · TOPICS: Data Mining, Data Warehousing · READINGS: Two Crows Corporation. Introduction to Data Mining and Knowledge Discovery. Optional: Technology Forecast. pp. 253-310.
    Reading assignment
  • One of the unusual aspects of this course is the diversity of student objectives, backgrounds and previous exposure to the subject matter. To accommodate this diversity we propose that each student select his or her individualized sets of supplementary study materials from the list below. We will describe the recommended study materials and the strategy for choosing between them in the first session of the course. Please feel free to send us email if you have questions related to the best study materials for you. Required materials
    Listed reading
  • Listed reading
  • Recommended materials
    Listed reading
  • PriceWaterhouseCooper’s Technology Forecast: 2002-2004, Vol. 1: In addition to a concise technical introduction to the various topics covered, it provides excellent surveys of the marketplace, including pointers to leading vendors and products, as well as assessments of trends and directions. Our recommendation: Students with no previous exposure in IT might find this a bit heavy. On the other hand, students who have had some previous IT exposure and especially graduate students who are interested in connecting the technological principles we will learn in the lectures with the marketplace will find this an excellent reference.
    Listed reading
  • White, Ron et. al., How Computers Work, 6th ed., Que, 2001. Good introductory text on the internals of computer hardware and system software. Recommended if you don’t have a background in science or engineering. Science and engineering majors might find this book too elementary. You may purchase this book from an online bookstore.
    Listed reading
  • Finally, for students who would like to learn Microsoft Access in depth, the following is a recommended textbook (you may choose either):
    Listed reading
  • Viescas, John L., Running Microsoft Access 2000, Microsoft Press, 1999. One of the best and most detailed “bibles” on Microsoft Access. Coverage is way beyond what will be covered in this course. This is an excellent reference book for students who are interested in becoming Microsoft Access experts. If you are looking for something more concise, you may consider the Byrne textbook.
    Listed reading
Sources