ITEC 200 - Spring 2010

The Edge of Information Technology

Class Schedule

Tuesdays 11:20 - 2:00 pm

Classroom: T61

Professor: J. Alberto Espinosa

Office Hours: see Blackboard

[Syllabus] [Student Web Sites] [Teams]
[ITEC 200 Master Lab Schedule] [FSIT Lab]
[Google Analytics] [SW Training Resources]

Note: Please go to Lynda.com through the AU Portal
(select "Technology", then "Web-Based Training Library")
for an excellent software training resource.

Last updated 1/10/10

Topic 1: Introduction to course, IT and IS
   

Week 1 Tue - 1/12
 

Lecture: Syllabus and course introduction

 

Lecture Lab: Web introduction and HTML lab exercise (instructions on Blackboard)
   

Week 2 Tue - 1/19

 

Lecture: Organizational Information Technology and Systems
  Readings: Chapters 1.1 and 2.2
 

Lecture Lab: Introduction to Dreamweaver -- Web Site Development
   

Topic 2: Hardware and Software
   

Week 3 Tue - 1/26
 

Lecture: Hardware & Software Basics

  Readings: Chapter 5.1
 

Practice Lab 1 (DUE pre-lab and end of lab, graded): Dreamweaver -- Web Site Development (instructions on Blackboard)
   

Topic 3: Database
   

Week 4 Tue - 2/2
 

Lecture: Introduction to Database Concepts
  Readings: Chapter 6
 

Lecture Lab: Database -- Introduction to MS Access
  Homework 1 (DUE): Dreamweaver Web Sites (instructions on Blackboard)
 

ITR deliverable 1 (DUE): Teams formed (instructions on Blackboard)
   

Week 5 Tue - 2/9

 

Lecture: Database queries
  SQL Tutorials: W3Schools  KeyData
  Practice Lab 2 (DUE pre-lab and end of lab, graded): Database queries (instructions on Blackboard)
   

Week 6 Tue - 2/16

 

Lecture: Database design

 

Practice Lab 3 (DUE pre-lab and end of lab, graded): Database design (instructions on Blackboard)
 

Homework 2 (DUE): Database queries (instructions on Blackboard)
   

Aside
   

Week 7 Tue - 2/23

   
  Lecture: ITR Planning; The Role of Research; Teamwork
   
 

Practice Lab 4 (DUE pre-lab and end of lab, graded): Advanced database features -- forms, reports, data entry and macros (instructions on Blackboard)
 

ITR deliverable 2 (DUE): Individual topic exploration (instructions on Blackboard)
   

Topic 4: Decision Support Systems
   

Week 8 Tue - 3/2

   
 

Lecture: Decision Support Systems, Spreadsheet Modeling and Business Intelligence

  Readings: Chapter 2.1
 

Lecture Lab: Introduction to Excel
 

ITR deliverable 3 (DUE): Team topic selection and analysis
 

Homework 3 (DUE): Database Design and Implementation
   

3/7 3/14
Spring Break
   

Topic 5: Telecommunications and Networks
   

Week 9 Tue - 3/16

 

Lecture: Telecommunications and Networks
  Readings: Chapter 7
 

Practice Lab 5 (DUE pre-lab and end of lab, graded): Financial Modeling in Excel (instructions on Blackboard)
 

ITR deliverable 4: Meet with Prof week (required)
   

Week 10 Tue - 3/23

 

Lecture: The Internet, the Worldwide Web and E-Business
  Readings: Chapter 3
  Review: Mid-term exam guidelines
 

Practice Lab 6 (DUE pre-lab and end of lab, graded): Advanced Excel modeling (IF, VLookups, HLookups and Analysis Tools) (instructions on Blackboard)
 

ITR deliverable 5 (DUE): ITR Draft
 

Homework 4 (DUE): Financial Modeling using Excel
   

Topic 6: IT and Business
   

Week 11 Tue - 3/30

  Lecture: The Enterprise View and Enteprise Systems
  Readings: Chapter 8.1, 9.1 and 10.1
 

Practice Lab 7 (DUE pre-lab and end of lab, graded): Excel Pivot Tables and Macros (instructions on Blackboard)
 

Homework 5 (DUE): Advanced Excel Modeling (IF, VLookups, HLookups and Analysis Tools)
   
Stop to think for a moment about what you have learned in the course up to this point. Do you think you may be able to pass a Microsoft Office certification exam. If you have done a great job with this class, there are 3 certification exams you may want to look into: Excel Specialist, Excel Expert and Access Specialist. Investigate what you need to know to pass these exams here.
   

Week 12 Tue - 4/6

   
 

** Mid-Term EXAM **

  (4-4:50pm) Guest Speaker: TBA
   

Week 13 Tue - 4/13

   
  Lecture: Information Technology Ethics and Security
  Readings: Chapter 4
 

Practice Lab 8 (DUE pre-lab and end of lab, graded): MS Visio Modeling & Diagrams (instructions on Blackboard)
   

Week 14 Tue - 4/20

 


 

ITReview final deliverables (DUE):
   6. ITR Paper
   7. Executive Summary
   8. Presentation
   9. Peer Evaluation

 

Homework 6 (DUE): MS Visio Modeling & Diagrams
   

4/27

Study Day (and ITR Competition 4-6:30pm)
   

Final Exam Day 5/4 (no exam)

   
 

American University's Office of Information Technology (OIT) Tour
Tour Information and Directions