Class Schedule - Spring 2002
CIS 146
- Microcomputer Appl. - MS Office
Mon. & Wed. 12:30pm-1:45pm, Room: RSH 200
Hal Harris, Jr. Ph: 520-5950(o) 979-5000(h)
Email at school: hharris@jscc.cc.al.us
Email at home: halharris@charter.net

Monday

Wednesday

Week #1
Jan. 7, 2002
Jan. 9, 2002
Welcome, Introduction, Syllabus & Textbook. Intro to Computers Pg. COM1-COM12 Notes: Concepts/Term fm web page (first few)

Notes: Concepts/Term fm web page (finish) Intro to Computers Pg. COM12-COM29 Introduction to Windows 98 Pg. INT1.4-INT1.30

Week #2
Jan. 14, 2002
Jan. 16, 2002

How to save and turn in assignments electronically LAB 01:  RAM search Asgn01 on network

Intro to Win 98 (Explorer, Help and Office 2000) Pg. INT1.30-INT1.74 LAB 02: Pg. INT1.78 Qu. 1-18 (ans. 5,14, & 17)

Week #3
Jan. 21, 2002
Jan. 23, 2002

College Closed
Martin Luther King Day

PowerPoint Pgs. PP1.6-PP1.70 LAB 03
LAB 04: TenQuestions.doc from network.

Week #4
Jan. 28, 2002
Jan. 30, 2002

LAB: 05: PowerPoint - Apply Your Knowledge 1, steps 1-8 only on pg. PP1.71 LAB: Finish Lab Assignments (01-05)

Review for first exam

Week #5
Feb. 4, 2002
Feb. 6, 2002
EXAM #1 - Concepts, Terminology & Windows

Go over exam. Introduction to Word Processing with Word 2000. See Word Proc. notes. Insertion pt, word wrap, hard/soft ret, save, font. LAB 06

Week #6
Feb. 11, 2002
Feb. 13, 2002

Project 1: Pgs. WD1.6-WD1.58 - doc, menu, toolbars, zoom, alignment, undo/redo, select, graphics, print. LAB 07: steps 1-15 Pg. WD1.61

Project 2: Pgs. WD2.4-WD2.36. Show/Hide, marg, line spac, headers/footers, pg nbrs, indent, AutoCor, sty, pg bk, F1 hlp key. LAB 08

Week #7
Feb. 18, 2002
Feb. 20, 2002

Project 2: Pgs. WD2.36-WD2.55 hanging indent, find/replace, selecting text, clipboard, hyperlinks. LAB 09: In the Lab 2 on Pg. WD2.59-WD2.61

Project 3: Pgs. WD3.4-WD3.61 Res wiz, tables, bullets, line brks, prnt prev, tabs, symbols, off clpbrd, borders, AutoText. LAB 10

Week #8
Feb. 25, 2002
Feb. 27, 2002

LAB 13: In the Lab 1 on Pg. WD3.63, steps 1-5 LAB 11 & 12. LAB: Finish Lab Assign (06-12)

Review for exam #2

Week #9
Mar. 4, 2002
Mar. 6, 2002
EXAM #2 - Word Processing

Go over exam and introduction to spreadsheets using Excel See spreadsheet notes on web. Cell/ cell address, modes, value/label,.3 mouse pointers.

Week #10
Mar. 11, 2002
Mar. 13, 2002

Project 1:, fill handle, range, fnctns, frmt nbrs, argmnts, F2 edit ky, abs/rel., LAB 14: Work thru proj.  & LAB 15: In the Lab 1 on Pg. E1.60, st 1-10.

Project 2: formulas, oper, ord of oper, Abs/Rel, pt mode, sum, avg. LAB 16: Work thru proj. LAB 17: In the Lab 1 Pg E2.68-E2.69, st 1-13.

Mar. 18-31

Spring Break - No Classes March 18-31

Week #11
Apr. 1, 2002
Apr. 3, 2002

In class exercise CALC & AMORT LAB 20 & 21: (AMORT handout on network) LAB 18: Work thru proj 3 and LAB 19

In class exercise: CHANGE LAB 23: MTG handout on network  LAB 22:

Week #12
Apr. 8, 2002
Apr. 10, 2002

Review for exam #3

EXAM #3 - Spreadsheets
Week #13
Apr. 15, 2002
Apr. 17, 2002

Go over exam and introduction to databases; field, record, table, relational database. Create CLASS phone directory (bonus assignment)

Project 1 & data types, database structure, primary key
LAB 24, 25, & 26.
Week #14
Apr. 22, 2002
Apr. 24, 2002

LAB 27, 28 & 29

Project 2 & foreign key, join, referential integrity, index, data redundancy, queries, computed field, reports. LAB 30

Week #15
Apr. 29, 2002
May 1, 2002

Review for Exam #4
LAST DAY TO TURN IN HOMEWORK!!!

EXAM #4 – Databases
Week #16
May 6, 2002
May 8, 2002

No Classes - Final Exam Week
May 6-10, 2002

Comprehensive Final Exam
Wednesday May 8, 2002
Note Special Time - 12:45pm - 2:45pm