ITEC 200 - Spring 2008

The Edge of Information Technology

Class Schedule

Wednesdays 2:10 - 4:50 pm

Classroom: Watkins G02 & Kogod Lab

Office Hours: Tuesdays 2-5 pm and Wednesdays 5-8 pm

Professor: J. Alberto Espinosa

[Syllabus] [Glossary] [Readings (see Blackboard)]
[ITEC 200 Master Lab Schedule] [Kogod Lab Schedule]
[Student Web Sites] [Teams]

Last updated 4/13/08
rev: posted information on OIT tour

Topic 1: Introduction to course, IT and IS [Glossary]

   

Week 1 Wed 1/16

 

Lecture: Syllabus and course introduction

 

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

   

Week 2 Wed 1/23

 

Lecture: Introduction to Information Technology and Organizational Information Systems

 

Lecture Lab (by CTE): Introduction to Dreamweaver -- Web Site Development

   

Topic 2: Hardware and Software [Glossary]

   

Week 3 Wed 1/30

 

Lecture: Hardware & Software Basics

 

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

   

Topic 3: Database [Glossary]

   

Week 4 Wed 2/6

 

Lecture: Introduction to Database Concepts

 

Lecture Lab (by CTE): Database -- Introduction to MS Access (Download database from Blackboard)

  Homework 1 (DUE): Dreamweaver Web Sites (instructions on Blackboard)
   

Week 5 Wed 2/13

 

Lecture: Database queries

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

IT Review deliverable 1 (DUE): Teams formed (instructions on Blackboard)

   

Week 6 Wed 2/20

 

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)

   

Topic 4: Telecommunications and Networks [Glossary]

   

Week 7 Wed 2/27

 

Lecture: Database Wrapup; Introduction to Telecommunications

 

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

 

IT Review deliverable 2 (DUE): Topic exploration (instructions on Blackboard)

   

Week 8 Wed 3/5

   
 

Lecture: Networks; Lab Introduction: Decision Support Systems and Spreadsheet Modeling

 

Lecture Lab (by CTE): Introduction to Excel

 

IT Review deliverable 3 (DUE): Topic selection and analysis

 

Homework 3 (DUE): Database Design and Implementation

   

Spring Break 3/9 to 3/16

   

Week 9 Wed 3/19

 

Lecture: The Internet, Intranets, Extranets and Client-Server Architecture

 

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

   

Week 10 Wed 3/26

 

Lecture: Wireless Communications and Networks

 

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

 

IT Review deliverable 4 (DUE): IT Review Draft

 

Homework 4 (DUE): Financial Modeling using Excel

   

Topic 5: Information Security and Ethics [Glossary]

   

Week 11 Wed 4/2

 

Lecture: Information Security

 

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 Wed 4/9

   
 

** EXAM: 2:10 PM (sharp) - 3:30 PM **

   
 
3:35 - 4:50 PM Guest Speaker
Randy Mah
(Bio)
Deloitte Consulting
   

Week 13 Wed 4/16

   
  Lecture: Information Technology & Ethics
 

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

  IT Review deliberable 5 (DUE): Written Report
   

Week 14 Wed 4/23

 


 

IT Review deliverable 6 (DUE *** IN CLASS ***): IT Review Article

 

IT Review deliverable 7 (DUE *** IN CLASS ***): In-Class Presentation

 

Homework 6 (DUE): MS Visio Modeling & Diagrams

   

Study Days Wed 4/29 to 4/30

   

Final Exam Day 5/7 (no exam)

   
 

2:30 - 3:15 PM
American University's Office of Information Technology (OIT) Tour
Tour Information and Directions