op130

Class Schedule - Spring 2003
CIS 146 503
- Mcr Comp Apl - MS Office XP
Tues. & Thurs. 9:30am-10:45am, Room: RSH 203
Hal Harris, Jr. Ph: 520-5950(o) 979-5000(h)
Email at school: hharris@jeffstateonline.com
Email at home: harris@wwisp.com

Tuesday

Thursday (LAB: RSH 200)

Week #1

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

Cncpts/Trm fm web pg (finish COM12-COM29)
How to save & turn in asgn electronically.
Demo - how to do LAB 01- RAM Asg

LAB: 01- RAM Asgn on Web
LAB: 02 - WIN1.06-2.25 Lab 2 steps 1-8
LAB: 03. Ten Questions Asgn from Web

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

Intro to Win XP (Explorer, Help and Office 2002) Pg. INT1.4 - INT1.74 LAB 02: Pg. INT1.78 Qu. 1-18 (ans. 5,14, & 17) AND Intro to PowerPoint.

LAB 04: PowerPoint Pgs. PP1.06-PP1.64
LAB: 05: PowerPoint - Apply Yr Knw 1, st 1-6 only on pg. PP1.68 Finish Lab Asgn (01-05)

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

Review for first exam

EXAM #1 - Concepts, Terminology & Windows

Week #5
Feb. 4, 2003
Feb. 6, 2003

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

LAB 06 - Project 1: Pgs. WD1.06-WD1.54
LAB 07: In Lab2 steps 1-14 Pg. WD1.67-1.68
Week #6
Feb. 11, 2003
Feb. 13, 2003

menu, toolbrs, zoom, algnmnt, undo/redo, prnt,  select, graphics. Show/Hide, marg, head/fters, line spac, pg nbrs, indent, AutoCor, sty, pg bk, F1.

LAB 08 - Project 2: Pgs. WD2.04-WD2.52
LAB 09 - In Lab 2, parts 1 & 2 Pgs. WD2.60-2.62
 

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

hnging indent, find/repl, selectg text, tables,  clipbrd, hyperlinks, Res wiz, bullets, line brks, prnt prev, tabs, symbols, off clpbrd, brdrs, auto txt.

LAB 10, 11, 12: Project 3: Pgs. WD3.04-WD3.57 
LAB 13: In Lab 1, steps 1-4 on Pg. 3.64
Finish Lab Assign (06-13)

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

Review for exam #2

EXAM #2 - Word Processing

Week #9
Mar. 4, 2003
Mar. 6, 2003
Go over exam and introduction to spreadsheets using Excel.  See spreadsheet notes on web. Cell/ cell address, modes, value/label, mouse pointers. I will not be in class on March 6th due to a seminar on NE Campus. Please work on Labs 14, 15 & 16.
LAB 14: Project 1 Pgs. E1.06-E1.54
LAB 15: In the Lab 1 Pg. E1.58-1.59, steps 1-10
LAB 16: Proj. 2 (omit emailing) Pg. E2.04-E2.64
Week #10
Mar. 11, 2003
Mar. 13, 2003

fill handle, range, fnctns, frmt nbrs, argmnts, F2 edit ky, abs/rel., formulas, oper, ord of oper, Abs/Rel, pt mode, sum, avg.

LAB 16: Finish Proj. 2 (omit email) Pg. E2.04-E2.64
LAB 17: In the Lab 1 Pg E2.69-E2.70, steps 1-14
LAB 18: Project 3 Pgs. E3.04-E3.65

Week #11
Mar. 18, 2003
Mar. 20, 2003

In class exercise CALC & AMORT 
Demo - In class exercise: CHANGE
Demo - IF statement for Payroll Asgn (str & val)

LAB 19, 20, 21 Payroll, Amort, & Pg. E3.68 #2, 3, & 5
LAB 22: MTG handout on Web
LAB 23: CHANGE

Mar. 23-29, 2003

March 23-29, 2003 - SPRING BREAK - NO CLASSES

Week #12
Apr. 1, 2003
Apr. 3, 2003

Review for exam #3

EXAM #3 - Spreadsheets

Week #13
Apr. 8, 2003
Apr. 10, 2003

Go over exam and intro to databases; field, record, table, rel db, prim key, structure, data types, & how to copy Access files for turning in elect.
Demo - class phone dir.

Create CLASS phone directory (bonus assignment)
LAB 24: Project 1 Pgs. A1.06-A1.49
LAB 25: Apply Knowledge 1 pg. A1.54-55 steps 1-7
LAB 26: In the Lab 1 steps 1-9 pg. A1.56-57

Week #14
Apr. 15, 2003
Apr. 17, 2003

foreign key, join, referential integrity, index, data redundancy, queries, computed field, reports.
Demo - merge classified records from Access table into Word doc. as quick job search

LAB 27: Project 2, Pgs. A2.04-A2.42
LAB 28: Apply Knowledge 1 pg. A2.44 steps 1-19
LAB 29: In the Lab 1 steps 1-16 pg. A2.44-A2.45
LAB 30: Project 3 Pg. A3.04-A3.48

Week #15
Apr. 22, 2003
Apr. 24, 2003
LAST DAY TO TURN IN HOMEWORK!!!
Review for Exam #4
EXAM #4 – Databases
Week #16
Apr. 29, 2003
May. 1, 2003
Catch up any missing assignments and get help before the final exam. OPEN LAB: In library.

No Classes - Final Exams
May 1-7, 2003

Week #17
May 6, 2003
 

Comprehensive Final Exam
Tuesday May 6, 2003
Note Special Time - 10:15am - 12:15pm