ITEC 200 - Spring 2008
The Edge of Information Technology
Class Schedule
Wednesdays 2:10 - 4:50
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 |
|
|
|
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 ** |
|
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 |
|
Spring Break 3/9 to 3/16