150:080, Schedule and OnLine Materials

Wk. #

Week Beginning

MIS for the Information Age Readings & Lectures

Windows 95, Access 2000, Excel 2000, HTML Activities

Marks

1

Mo/01/08

Syllabus Review

Purchasing a Computer (Supplemental Lecture)

Windows 95 (Supplemental Lecture)

Appendix B: The Internet

 

 

2

Mo/01/15

Chap. 1: The Info Age in Which You Live

MLK Holiday (Mo/01/15)

InClass: Windows 95 Lab Exercise

IA01

3

Mo/01/22

Chap. 1: The Info Age in Which You Live

Appendix A: The Technology Tree

 

SE01

4

Mo/01/29

Appendix A: The Technology Tree

Chap. 2: Information Technology Systems

Chap. 3: Strategic and Competitive Opportunities

HW: Access Overview, pp. ACO-1 - ACO-5

HW: Access Tutorial 1: Creating a Database, pp. AC1-1 - AC1-47 File: Friend1.bmp

 

5

Mo/02/05

Chap. 3: Strategic and Competitive Opportunities

HW: Access Hands-On Practice Exercise 3, pp. AC1-57 - AC1-58

TE01

6

Mo/02/12

Chap. 4: Databases and Data Warehouses

HW: Access Tutorial 2: Modifying a Table and Creating a Form, pp. AC2-1 - AC2-33 File: Employee_Records.mdb

HW: Access Hands-On Practice Exercise 3, 4, pp. AC2-43 - AC2-45 File: Cafe_Purchases.mdb File: Learning.mdb

 

7

Mo/02/19

Chap. 4: Databases and Data Warehouses

HW: Access Tutorial 3: Analyzing Tables, pp. AC3-1 - AC3-27 File: Personnel_Records.mdb

HW: Access Hands-On Practice Exercise 3a-d, 4a-c, pp. AC3-53 - AC3-55

SE02

8

Mo/02/26

Chap. 4: Databases and Data Warehouses

Chap 5: Decision Support and Artificial Intelligence

HW: Access Tutorial 3: Creating Reports, pp. AC3-27 - AC3-43.

HW: Access Hands-on Practice Exercise 3e-g, 4d-f, pp. AC3-53 - AC3-55

 

9

Mo/03/05

Chap 5: Decision Support and Artificial Intelligence

HW: Excel Overview, pp. EXO-1 - EXO-5

HW: Excel Tutorial 1: Creating and Editing a Worksheet, pp. EX1-1 - EX1-63 File: Cafe_Budget.xls

HW: Excel Hands-On Practice Exercises 2, 3, 5, pp. EX1-73 - EX1 - 76 File: Highest_Paying_Jobs.xls File: Real_Estate_Prices.xls File: Homeowners_Association_Budget.xls

InClass: Excel Lab Exercise

SE03

 

Mo/03/12

Spring Break

 

 

10

Mo/03/19

Chap 6: Networks (pp. 220-226, 230-240, 243, 245-266)

HW: Excel Tutorial 2: Charting Worksheet Data, pp. EX2-1 - EX2-47 File: Cafe_Sales.xls

HW: Excel Hands-On Practice Exercises 2, 3, 6, pp. EX2-56 - EX2-60 File: Book_List.xls

SE04

11

Mo/03/26

Chap 6: Networks (pp. 220-226, 230-240, 243, 245-266)

HW: Excel Tutorial 3: Managing and Analyzing a Workbook, pp. EX3-1 - EX3-45 File: First_Quarter_Forecast.xls File: Annual_Forecast.xls

HW: Excel Hands-On Practice Exercises 2, 3, 4, pp.EX3-55 - EX3-56 File: Langs_Income_Statement.xls File: Time_Sheets.xls File: Sports_Company_Forecast.xls

TE02

12

Mo/04/02

Chap. 8: Planning for IT Systems

HW: HTML Quick Know-How, pp. 2-22

 

13

Mo/04/09

Chap. 8: Planning for IT Systems

Chap 9: Developing IT Systems

HW: HTML Organization Techniques, pp. 27-46

SE05

14

Mo/04/16

Chap 9: Developing IT Systems

Chap 10: Managing IT Systems

HW: HTML Power Techniques, pp. 51-67 [File: levy.gif]

 

15

Mo/04/23

Chap 10: Managing IT Systems

Chap. 11: Preparing for the Future

InClass: HTML Lab Exercise [File: Welcome3D.gif] [File: smile.gif]

SE06

FE

Mo/04/30

University Final Exam Schedule

 [File: hello.gif] [File: exclaim.gif] [File: 4star.gif]

FE01

 

Homework should be completed by the beginning of the week in which it is listed so that students will understand the references made to those assignments in the lectures.

Students in our Monday evening section are advised that this schedule will vary somewhat due to our not meeting on Mo/01/15. For example, SE01, scheduled for Mo/01/15, will be administered on the following Monday evening.

The links to In Class Lab Exercises, IA01 and IA02 lead to documents developed by Dr. Shashi Kaparthi, Dr. Rex Karsten, and/or Dr. Roberta Roth.

The schedule and online materials are tentative and therefore subject to change, if necessary. Individuals are responsible for any changes announced via sessions, EMail, Discussion List or Web postings.