ITEC 200 - Spring 2012
The Edge of Information Technology
Wednesdays
11:45 am - 2:25 p
[Syllabus]
[Student Web Sites] [Teams]
[ITEC 200 TA Office Hours] [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 4/10/2012 - Updated
guest speaker
Topic 1: Introduction to course, IT and IS |
|
Week 1 Wed - 1/18 |
|
Lecture: Syllabus, Course Introduction; Organizational Information Technology and Systems; and Introduction to Web Development |
|
Readings: Chapters 1.1 and 2.1 | |
Topic 2: IT Infrastructure: Hardware and Software |
|
Week 2 Wed - 1/25 |
|
Lecture: Hardware & Software Basics |
|
Readings: Online Appendix B (http://highered.mcgraw-hill.com/sites/dl/free/0073376833/825296/AppendixB.pdf) | |
Practice Lab 1 (DUE: pre-lab before class; web site at end of class): Web site development (instructions on Blackboard) |
|
Topic 3: Database |
|
Week 3 Wed - 2/1 |
|
Lecture: Introduction to Database Concepts |
|
Readings: Chapter 6 | |
Lecture Lab: Database -- Introduction to MS Access |
|
Homework 1 (DUE): Google Web Sites (instructions on Blackboard) | |
ITR deliverable 1 (DUE): Teams formed (instructions on Blackboard) |
|
Week 4 Wed - 2/8 |
|
Lecture: Database queries |
|
SQL Tutorials: W3Schools KeyData | |
Practice Lab 2 (DUE pre-lab and end of lab, graded): Database queries (instructions on Blackboard) | |
Week 5 Wed - 2/15 |
|
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) |
|
ITR Planning and Training |
|
Week 6 Wed - 2/22 |
|
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 7 Wed - 2/29 (no lab) |
|
Lecture: Decision Support Systems, Spreadsheet Modeling and Business Intelligence |
|
Readings: Chapter 2.1, 9.2 | |
Lecture: Telecommunications and Networks |
|
Readings: Online Appendix C (http://highered.mcgraw-hill.com/sites/dl/free/0073376833/825296/AppendixC.pdf) | |
Homework 3 (DUE): Database Design and Implementation |
|
Topic 5: IT Infrastructure: Telecommunication and Networks |
|
Week 8 Wed - 3/7 (full class block in the lab) |
|
Lecture Lab: Introduction to Excel |
|
Practice Lab 5 (DUE pre-lab and end of lab, graded): Financial Modeling in Excel (instructions on Blackboard) |
|
ITR deliverable 3 (DUE): Team topic selection and analysis |
|
3/14 |
|
Week 9 Wed - 3/21 |
|
Lecture: The Internet, the Worldwide Web and E-Business |
|
Readings: Chapters 7 and 3 | |
Practice Lab 6 (DUE pre-lab and end of lab, graded): Advanced Excel modeling (IF, VLookups, HLookups and Analysis Tools) (instructions on Blackboard) |
|
Homework 4 (DUE): Financial Modeling using Excel |
|
ITR deliverable 4: Meet with Prof week (required) |
|
Topic 6: IT and Business |
|
Week 10 Wed - 3/28 |
|
Lecture: The Enterprise View and Enteprise Systems |
|
Readings: 8.2, 9.1 and 10.1 | |
Review: Mid-term exam guidelines | |
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) |
|
Week 11 Wed - 4/4 |
|
Lecture: Business Processes | |
Readings: Chapter 2.2 | |
Practice Lab 8 (DUE pre-lab and end of lab, graded): MS Visio Modeling & Diagrams (instructions on Blackboard) |
|
ITR deliverable 5 (DUE): ITR Draft |
|
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/11 |
|
(11:45 am - 1:15 pm) ** Mid-Term EXAM ** |
|
(1:25 pm - 2:25 pm) Guest Speaker |
|
Topic 7: IT, Ethics and Information Security |
|
Week 13 Wed - 4/18 |
|
Presentation Rehearsals with Kogod's Center for Business Communication (12:55 pm - 2:25 pm) |
|
Lecture:e5">Lecture: Information Technology Ethics and Security | |
Readings: Chapter 4 | |
Self Guided Lab Exercise DUE: HTML and Visual Web Development |
|
Homework 6 (DUE): MS Visio Modeling & Diagrams |
|
Week 14 Wed - 4/25 |
|
|
|
ITReview
final deliverables (DUE): |
|
5/1 |
|
Final Exam Day Wed 5/2 (no exam) |
|
(noon - 1 pm) |