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