CIS110-F99-Day

Home Up HW

9/1W 9/8W 9/13M 9/15W 9/20M 9/22W 9/27M 9/29W 10/4M 10/6W
10/13W 10/18M 10/20W 10/25M 10/27W 11/1M 11/3W 11/8M 11/10W 11/15M
11/17W 11/22M 11/24W 11/29M 12/1W 12/6M 12/8W 12/13M 2/15W

final

Announcement(12/14/99)
Office Hour Cancellation on 12/16/99(Thursday) 1-2PM:
Please send e-mails or leave phone messages at extension 320

Announcement(12/7/99)
F I N A L   E X A M (Comprehensive)
2-4PM Monday, December 20, 1999 at H225

Announcement(11/10/99)
Due Date Change: HW #6(Database)'s due date is now 11/17W.

Announcement(9/15/99)
All homework assignments should be prepared by computer word processing s/w unless other specific instructions given.

Last updated:  Tuesday, December 14, 1999

Period

Date

Topic

Intro to IS/VB6

Due

1

 

top

9/1W Course Overview
bulletCourse Disclosure Statement
bulletCareer path in CIS professionals
bulletMedaille CIS Program overview
bulletCertification: CCP & vendor specific
   
9/6M Labor Day (Holiday)    

2

 

top

9/8W Intro to IS (Ch 1)
bulletEssential computer concepts
bulletFunctions of an IS
bulletElements of a computer-based IS
bulletBusiness Applications vs. organizational levels: (TPS, MIS, DSS, ES) for (operational personnel, lower/middle/upper mgt)
 

3

 

 

top

9/13M Hardware (Ch 2)
bulletSystems board
bulletCPU: ALU & CU (CPU simulation)
bulletPeripheral devices
bulletMemory: RAM, VM, ROM, CMOS, Cache
bulletI/O: Expansion bus; Expansion slot; Expansion Card; Expansion Port; Cable; Output Device
 

4

 

top

9/15W Hardware (Ch 2) (cont.)

 

Ref: Computer Architecure

bulletBinary Numbering System
bulletThe Boot Process: Power-up; Boot Program in ROM; Power-on-Self Test(POST); Load Operating System; Check Configuration & Customization; Ready for Commands & Data
HW #1: (Due 9/22/99W)
A)Binary Numbers(hand written acceptable)
B)Page 69- Discussion Question #1

5

 

 

top

9/20M Software(Ch 3)
bulletApplications software
bulletGroupware, shareware, freeware, public domain program
bulletProgram language generations
bulletObject-oriented programming
bulletVisual programming
bulletBuying & Installing software (DOS based & Windows program)
HW #2 (due 9/27M/99):
A)Discussion Questions #2(Page 103)
B)Applying IT #1 (Page 104)

6

 

top

9/22W Software (cont.)/ Telecommunications (Ch 4)
bulletCapability of communication systems
bulletTypes of communication media
bulletCommunications devices, s/w, protocols
bulletNetwork configurations & classifications
HW #3 (due 9/29W):
Textbook Page 139-
Discussion Questions #2 & #3

7

9/27M Telecommunications (cont.)/WP Chapter 4  

8

 

 

 

top

9/29W WP (Ch5A)

 

 

HW #4 (due 10/13W): Write a document using word processing(WP) software (MS Word or Word Perfect) intorducing yourself (such as resume) applying different WP features (at least 12 of the following: header, footer, pagination, footnote, underline, different font styls/points, numbered list, bulleted list, multicolumn output, table, image inserted, background/print color, subscript, superscript, and comments. List all the features you will have applied in a separate page. Hand in the WP file on a 3 1/2" diskette along with its printed copy.

9

10/4M

Exam #1(Chapters 1 thru 4)

10

 

 

 

top

10/6W WP(Ch 5) Mail Merge(Form letter) Exam #1 Results:
Class Average=73.3
Stem-and-Leaf Display:

10|8
  8|9
  7|8

  5|2
  4|0

10/11M Columbus Day (Holiday)    

11
top

10/13W Spreadsheet (Ch5B)
bulletThe Basics: MS Excel
HW #5 (due 10/20W): Create Excel Workbook

12

 

 

 

top

10/18M Spreadsheet (Cont.)

Spreadsheet (Ch5B)
Download excel files

bulletWhat-If analysis
bulletGoal-seeking
bulletData map
Note on HW #5-Two numbers(underlined below) given in the problem descriptions have been corrected as follows:

The paper's senior-level managers hope to increase private advertising revenues by 3% per month, thus bringing in $3,893.40 in April; $4,017.00 in May; and $4,202.40 in June.

13

10/20W Spreadsheet (cont.) Chapter 5    

14

top

10/25M DBMS(Ch 6)
bulletDatabase concepts: Spreadsheet vs DBMS
bulletMS Access: Tables
   
 

 

 

 

top

HW #6 (worth three times of other HWs )due 11/17W: Choose an organization that interest you - for example, a particular company, a college, or a nonprofit organization. Then, using the steps listed in the textbook chapter 6, design a database structure (with design goals, output requirements, and input requirements) for a database that you think would be useful for the organization. Create the database with MS Access 97 with minimum three tables. Entering some sample data to the tables, create at least  two forms, three queries from multiple tables, and two reports. Hand in the MS Access database and a MS Word document describing its design goals and output requirements in a 3 1/2" diskette. THIS DATABASE SHOULD BE DEVELOPED ALL BY YOURSELF. Not to be copied from any existing sources including books, the Internet, other people and any publications.

15

10/27W DBMS(Ch 6)
bulletMS Access: Tables
   

16

 

top

11/1M DBMS(Ch 6)

 

Download Access Database(Medaille)

bulletTable: Required field; Validation Rule(In(), Between, AND, OR); Input Mask
bulletForm: AutoForm
bulletReport Wizard
   

17

top

11/3W DBMS
bulletQuery: Using multiple tables; AND, OR, IIF, Date field; Computed field
   

18

top

11/8M DBMS
bulletQuery: Using multiple tables; AND, OR, IIF, Date field; Computed field
   

19

top

11/10W Bus Info Systems:
Bus Info Systems(Ch 7)
bulletTransaction Processing Systems
bulletManagement Information Systems (MIS)
Due Date Change: HW #6(Database)'s due date is now 11/17W.

20

11/15M       Exam #2(Ch 5-6): WP; Spreadsheet; Database

21

 

 

top

11/17W Bus Info Systems
bulletDecision Support Systems
bulletExpert Systems/Artificial Intelligence
bulletSystems Development Life Cycle
Exam #2 Results:
Class Average=71.2
Stem-and-Leaf Display:

10|0
  8|3
  6|28

  4|3

22

11/22M Bus Info Systems(Ch 7)
bulletSystems Development Life Cycle
   

23

top

11/24W Visual Basic 6
bulletIntroduction to VB Programming
   

24

top

11/29M Visual Basic 6:Building an application
bulletProject 1: Calculating Sales Commission
HW#7( due 12/6M)- Page VB 1.63 #1(Kilometer Converter)
Page VB 1.64 #2 (Equivalency Application)

25

top

12/1W Visual Basic 6:Working with Intrinsic Controls and Active Controls
bulletProject 1: Calculating Sales Commission(cont.)
bulletProject 2:Movie Box Office
   

26

12/6M Visual Basic 6
bulletProject 2:Movie Box Office
HW #8 (due 12/13M):
Page VB2.63 #1- Changing Properties at Run Time with CheckBox Controls      

27

12/8W Visual Basic 6
bulletProject 2:Movie Box Office
   

28

12/13M Security, Privacy and Ethical Issue(Ch8)
bulletSecurity, Privacy and Ethical Issues
Internet Links:
Security:  Computer Security Information
               What is a Computer Virus?
Privacy:   Computer Privacy Information
               Americans for Privacy Act
               PrivacyMaker S/W
Ethics:     WWW Resources
               The Ten Commandments

29

top

12/15W Issues and Trends(Ch 9)
bulletIssues and Trends
Telecommunications Act of 1996

30

12/17 or 12/20

F I N A L   E X A M (Comprehensive)
2-4PM Monday, December 20, 1999 at H225

Home Up HW