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 |