Announcement(3/22/00)
The week of 3/27 classes  will run from 6 - 7:30 PM to accomodate registration

Announcement(3/21/00)
Exam #2 will be given on 3/27(M)

Announcement(3/13/00)
HW's #7/#8 are due 3/22W instead of 3/20M because Medaille Computer Complex is closed for the Spring break.
Have a great break!

Announcement(3/5/00)
Exam #2 will be given on 3/22(W)

Announcement(3/5/00)
Please remember that late submittals of homework  won't be accepted(Course Policy)

Announcement(2/1/00)
Please bring a 3 1/2" diskette for Monday(2/2/00) class.

Last updated:  Sunday, March 26, 2000

Period	Date	Topic	Computer Concepts(CC)/ Win NT/MS Office97 InfoWeb	HW Due/ Recommended Lab Practices (Important: Specify your Name; HW # on both printouts and diskette label)
1           top	1/26W	Course Overview/ Using Computers(Ch 1) Course disclosure statement Computer literacy survey Class web page access Using New Perspectives CD-ROM A. Computers: Mind Tools B. Computer Systems Basics C. The User Interface D. User Focus:Help, Tutorials, and Manuals	Definition of computer by Von Neuman Computer system basic: Software; Categories of computer; System components; Microcomputer compatibility; Peripheral devices; Computer network The User Interface: Prompted Dialog;Commands; Menu & Dialog Boxes; Wizards;GUI	Suggested computer basic skills:(CC Page 1-40 thru 1-42) Peripheral Devices(#1) Using a Mouse (#1 & #2) Using a Keyboard (#1) HW #1 (due 2/7M): User Interface (#1 & #2)- Computer Concept Page 1-40(chapter 1) Note: See CC Page 1-39 for instructions how to run the Lab Practices
2           top	1/31M	Using Computers/ Computer Architecture(Ch1/5) A. Digital Electronics B. Memory C. CPU D. I/O E. The Boot Process	Inside the system unit;Mother board Memory: RAM; Virtual Memory; ROM; CMOS; Cache (internal/external) CPU: Control unit; ALU I/O: Expansion bus; Expansion slot; Expansion Card; Expansion Port; Cable; Output Device The Boot Process: Power-up; Boot Program in ROM; Power-on-Self Test(POST); Load Operating System; Check Configuration & Customization; Ready for Commands & Data	HW #2 (due 2/7M) Lab Assignment: CPU Simulator #1 & #4 Computer Concept Page 5-43(chapter 5)
3       top	2/2W	Windows NT	Organize FD/HD using folders/subfolders Create/Save As/ Copy/Rename/Remove file Ctrl/Shift click to select multiple file Delete; Restore; Empty the Recycle Bin Rename Folder/File	Suggestions: Win NT 4 Pracice Page NT A-21 Skills Review #1 thru #6 Suggestions: Win NT 4 Pracice Page NT B-23-25 Skills Review #1 thru #9
4   top	2/7M	Windows NT: Organize FD/HD using folders/subfolders Create/Save As/ Copy/Rename/Remove file Ctrl/Shift click to select multiple file Delete; Restore; Empty the Recycle Bin Rename Folder/File
5           top	2/9W	Ch 2. Software: S/W Categories: Systems/Applications Liscensed s/w: Shrink-wrap, Concurrent-user, & Site license Shareware, Freeware,Public domain Business s/w: Horizontal-market & Vertical-market s/w Installing s/w A. Software Basics B. Installing S/W	Ch 4. Files & Data Storage Data & Information File: Execution files; Data files; Source files Document centric approach to files File naming convention Windows Directories, Folders, and Files File Open, New, Save, Save As, Copy, Rename, Delete operations	HW #1 & HW #2 Due dates have been extended to today. HW #3 (due 2/16W) 1)Windows, Directories, Folders & Files (CC Page 4-43) #1 thru #4 2)Using Files (page 4-44) #1 thru #3
6     top	2/14M	The Internet (Ch 8) HTML Tutor HTML Tutor A HTML Tutor B HTML Tutor C A Free Web Site	The Internet (Ch 8) A. How It Works B. The Web Browser C. Web Authoring D. Connecting to the Internet	HW #4(due 2/23W) Lab Assignments: 1)The Internet:WWW- #1,2,3 (CC P8-37) 2)Web pages & HTML- #1,2 (CC P8-38)(note: print the HTML code for both problems #1 & #2)
7 top	2/16W	The Internet (Ch 8)
	2/21M	Washington's Birthday - Holiday
8       top	2/23W	MS Word Project 1. Creating and Editing a Word Document (pages WD 1.9-1.60)	Fundamentals: Start Word; Understanding application & document windows; Working w/ documents; Opening document; Correcting errors(additions, deletions, modifications); MS Word Help( Office Assistant, Contents Sheet)	Exam #1: Computer Concepts - Chapters 1,2,4,5 & 8 and Windows NT Exam #1 Results: Class Average=77.8% Stem-and-Leaf Display:   8|033899   7|115777779   6|   5|1
9           top	2/28M	MS Word/Project 1. Creating and Editing a Word Document (cont.) Project 3:Creating a Research Paper with a Table	Formatting documents: Word's default settings; Document navigation; Text selection; Character Formatting; Paragraph Formatting; Downloading image from the Web	HW #5: due 3/6M Page WD 1.67-Creating an announcement w/ ClipArt - Hand in a disk w/ printout as directed in textbook. Note: Include the following in your MS Word document and on diskette label:        HW/Lab #          CIS115            Your Name            Today's date
10   top	3/1W	MS Word:Project 3:Creating a Research Paper with a Table (cont.)	Margin settings; double space; header; footnote Table Ruler: hanging indent Sort paragraphs	HW #6: due 3/8W Page WD 3.59-2. Preparing a Research Report with a Footnote and a Table: Hand in a disk w/ printout as directed in textbook
11       top	3/6M	MS Excel: My first spreadsheet (in-class lab) Starting Excel The Excel window Moving arounding a worksheet Navigating/opening a workbook	Project #1: Computer Discount Daily Sales (Pages E 1.6 - E 1.45) Project #2: High-Tech Stock Club(Pages E 2.1 - E 2.21): Multiple lines of text in a cell Formula & Functions	HW #7: due 3/22W Page E 1.67 #1 Creating and Modifying a Sales Analysis Worksheet
12   top	3/8W	MS Excel:Project #2: High-Tech Stock Club ((Pages E 2.41 - E 2.65)	Formatting: font; boarder; align text; col width & row height	HW #8: due 3/22W Page E 2.73 #2 Esther's Emporium Monthly Accounts Receivable Balance Sheet
	3/13M	Spring Recess
	3/15W	Spring Recess
13 top	3/20M	MS Excel:Project #2: Review of High-Tech Stock Club/ Project #3(download Project 3 Start)
14     top	3/22W	MS Access:Project #1:Pilotech Services Database	Client Table: Structure & Data (Page A 1.14) Technician Table: Structure & Data (Page A 1.33) Using a form to view data(Page A 1.35) Create a Report (Page A 1.40)
15 top	3/27M			Exam #2 (MS Word & Excel)
16         top	3/29W	MS Access: Project #2: Querying the Pilotech Services Database	Query Criteria: use number; comparison; compound criteria using and & or Sorting the query; Omitting duplicates Joining tables To use a computing field To calculate statistics To use a computing field To calculate statistics
17 top	4/3M	MS PowerPoint: Project 1 - Using a Design Template (PP 1.8-1.39)/ Project 2: Using Outline View & Clip Art
18	4/5W	F I N A L E X A M (Comprehensive)