S2000-Day

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)

top

1/19W

Course Overview

	Course disclosure statement
	Computer literacy survey
	Class web page access
	Using New Perspectives CD-ROM

top

1/24M

Using Computers
(Computer Concepts Ch1)

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 1/31M) User Interface (#1 & #2)- CC Page 1-40

Note: See CC Page 1-39 for instructions how to run the Lab Practices

top

1/26W

Computer Architecture (CC Ch5)

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

top

1/31M

Computer Architecture (CC Ch5)(cont)/Windows NT 4 Workstation (Barron & Lyskawa)
C. CPU
D. I/O
E. The Boot Process

	View the desktop
	Start a program; Resize a window; Use menus & toolbars
	Use dialog boxes & scroll bars

	Fomatting a disk
	Creating & saving a file( Save/Save As)
	Copy, Move, Delete, Restore, Rename files
	My Computer vs. Win Explore

HW #2 (due 2/7M)
Lab Assignment:
CC Page 5-43
CPU Simulator #1 & #4

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

top

2/7M

Windows NT/ Software

A. Software Basics
B. Installing S/W

	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

top

2/9W

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 #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

top

2/14M

The Internet(Ch 8)

The Internet

A. How It Works
B. The Web Browser
C. Web Authoring
D. Connecting to the Internet

top

2/16W

The Internet

The Internet (Ch 8)
HTML Tutor
HTML Tutor A
HTML Tutor B
HTML Tutor C
A Free Web Site

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)

2/21M

Washington’s Birthday (Holiday)

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)

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

2/28M

MS Word-Project 1(cont.)/ Project 3:Creating a Research Paper with a Table

3/1W

Exam #1(Computer Concepts: Chapters 1,2,4,5 & 8)(Win NT)

Exam #1

top

3/6M

MS Word: Project 3:Creating a Research Paper with a Table

	Margin settings; double space; header; footnote
	Table
	Ruler: hanging indent
	Sort paragraphs

HW #6: due 3/20M
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

top

3/8W

MS Word:
Project 2: Using Word's Resume Wizard to create a resume: P WD 2.7- 2.26

3/13W

Spring Recess

3/15W

Spring Recess

top

3/20M

MS Excel: My first spreadsheet (in-class lab)

	Starting Excel
	The Excel window
	Moving arounding a worksheet
	Navigating/opening a workbook

HW #7: due 3/27M
Page E 1.67 #1 Creating and Modifying a Sales Analysis Worksheet

3/22W

Project #2: High-Tech Stock Club(Pages E 2.1 - E 2.21)

	Multiple lines of text in a cell
	Formula & Functions

top

3/27M

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 4/3M
Page E 2.73 #2 Esther's Emporium Monthly Accounts Receivable Balance Sheet

top

3/29W

Project #3: What-If Analysis & Working w/ Large Worksheet

	Using assumptions
	IF function
	Chart: 3-D Pie chart
	Print

top

4/3M

MS Excel:Project #3: What-If Analysis & Working w/ Large Worksheet(cont.)

	Absolute/Relative addressing
	Freeze/Split the worksheet

	3-D chart formatting
	What-If analysis
	Goal seeking

HW #9: due 4/10M
Page E 3.65 #1 World Wide Web Bookstore Five-Year Projected Financial Statement

top

4/5W

MS Excel:Project #3: What-If Analysis & Working w/ Large Worksheet(cont.)/
MS Access:
Medaille.mdb

	Spreadsheet vs. Database
	Database concepts
	Create a Table
	Add records to a table

	Use a form to view data
	Create a report

top

4/10M

MS Access:
Medaille.mdb

	Create a Table
	Add records to a table

	Use a form to view data
	Create a report

top

4/12W

Exam #2(MS Word & Excel)

Exam #2 Results:
Class Average=71
Stem-and-Leaf Display:
9|11
8|39
7|15
6|1779
5|5999

top

4/17M

MS Access:
Project #1:Pilotech Services Database

	Create Tables
	Add records to a table

	Use a form to view data
	Create a report

HW #10: due 4/26W
Page A 1.65 #1. Creating Museum Mercantile Database

top

4/19W

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

HW #11: due 5/1M
Page A 2.54 #1. Querying the Museum Mercantile Database

4/24M

Easter Holiday

top

4/26W

MS Access:Project #2: QueryingDatabase - continued/

	To use a computing field
	To calculate statistics

Download Access Database(Medaille)

top

5/1M

MS PowerPoint: Project 1 - Using a Design Template (PP 1.8-1.39)

HW #12 (due 5/8M):
P 1.69 #1. Designing and Creating a Presentation

top

5/3W

MS PowerPoint:Project 2 - Using Outline View & Clip Art

Animation Effects

HW #13 (due 5/10W):
P 2.65 #1. Adding clip art & animation effects to a presentation created in outline view

top

5/8M

Telecommunication (CC Ch7)

	Network: WAN & LAN
	Network: Hardware
	Network: Software

top

5/10W

Ethics & computer security (CC Ch 9)

	What can go wrong
	Viruses
	Backup

5/15M

F I N A L E X A M (Comprehensive)
2-4PM at H215