	Class Schedule - Fall 2006 CIS 146 - Microcomputer Applications - MS Office 2003 TR 12:30pm-1:45pm Room: Tues: RSH 201, Thurs: RSH 200	Hal Harris, Jr. Phone: 520-5950(off) 979-5000(hm) Email: hharris@jeffstateonline.com
	Tuesday (RSH 201)	Thursday LAB (RSH 200)
Week #1 Aug. 22, 2006 Aug. 24, 2006	Welcome, Introduction, Syllabus, Textbooks. Intro to Computers Pgs. COM1-COM39 Lec Notes: Concepts/Term 146ln01.htm	Finish Concepts and demonstrate how to save and turn in assignments electronically. LAB: Asgn01
Week #2 Aug. 29, 2006 Aug. 31, 2006	Introduction to Windows 146ln02.htm Disk storage - KB, MB, GB, TB floppy, CD, DVDs.	LAB: Asgn02 Work through Pages INT1.04-INT1.81 LAB: Asgn03 - Ten Questions
Week #3 Sep. 5, 2006 Sep. 7, 2006	Intro to Windws XP (Explorer, Help & Office XP) Pgs. INT1.04-INT1.81 Lecture Notes: Windows and Files	LAB: Asgn04 & Asgn05: PowerPoint Proj 1 on pgs PP1.06-PP1.65. On page PP1.64, step #2, you'll save Make Friends.ppt (Asgn #04).
Week #4 Sep. 12, 2006 Sep. 14, 2006	Review for Exam #1	Exam #1 - Concepts, Terminology, Windows & PowerPoint
Week #5 Sep. 19, 2006 Sep. 21, 2006	Study Intro to Word Proc. Menu, .doc, tlbrs, zm, algnmnt, undo/redo, select, graphics. Ins pt, wd wrap, hard/soft ret, save, font.	LAB: Asgn06: Word Project 1: Pages WD1.06-WD1.61. LAB: Asgn 07: In The Lab 2: Pages WD1.67-WD1.68 steps 1-14
Week #6 Sep. 26, 2006 Sep. 28, 2006	I will not be in class today. I will return to campus around 2pm. Please use class time today to complete assignments 08, 09 & 10 in the open lab in RSH 206 We will make up the missed lecture time today in class on Thursday. ~~Project 2: Pgs. WD2.4-WD2.36. Show/Hide, marg, line spac, headers/footers, pg nbrs, indent, AutoCor, sty, pg bk, F1 hlp key.~~	Lecture class today in RSH 200 to make up time missed on Tuesday. Topics: 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: Asgn 08: Project 2: Pgs WD2.36-WD2.55 hang ind, find/replace, sel text, clpbd, hyplks. LAB 09: In the Lab 2 on Pg. WD2.60-WD2.62~~
Week #7 Oct. 3, 2006 Oct. 5, 2006	Resume wiz, tables, bullets, line brks, prnt prev, tabs, symbols, off clpbrd, borders, AutoText.	LAB 10: Proj. 3: Pgs. WD3.4-WD3.61 LAB 11 & 12. LAB: Finish Lab Assign (06-12) LAB 13: In the Lab 1 on Pg. WD3.63, steps 1-5
Week #8 Oct. 10, 2006 Oct. 12, 2006	Review for exam #2	Exam #2 - Word Processing
Week #9 Oct. 17, 2006 Oct. 19, 2006	Go over exam. Intro to Excel. Cell, cell addr, modes, val/lab, 3 mouse ptrs, fill handle, range, fnctns, frmt nbrs, argmnts, F2 edit ky, abs/rel.	Project 1: LAB 14: Work through Project1. LAB 15: In the Lab 1 on Pg. E1.58-E1.59, steps 1-10 (save #10), start on Project 2 if time.
Week #10 Oct. 24, 2006 Oct. 26, 2006	In class exercise AMORT: formulas, opererators, order of operations, Abs/Rel, pt mode, sum, avg, sum, max, min, pmt	Project 2: LAB 16: Work thru project 2. LAB 17: In The Lab 1 Pg E2.69-E2.70, steps 1-14 (save #14) & LAB 19 Payroll & 20 AMORT
Week #11 Oct. 31, 2006 Nov. 2, 2006	IF function w/val & label. More abs/rel. In class exercise: CHANGE & Payroll	Project 3: LAB 18: Pgs E3.04-E3.65 (save #2) LAB 23: Change Exercise, LAB 21Apply Knowledge pg E3.68 #2,3,5. LAB 22: MTG Ex
Week #12 Nov. 7, 2006 Nov. 9, 2006	Review for exam #3	Exam #3 - Spreadsheets
Week #13 Nov. 14, 2006 Nov. 16, 2006	Intro to databases; field, record, table, relational db, data types, db structure, primary key. Also.	CLASS phone dir (bonus asgn) Project 1 & LAB 24, 25, & 26.
Week #14 Nov. 21, 2006 Nov. 23, 2006	NO CLASS - Faculty Professional Development	THANKSGIVING HOLIDAY NO CLASS - COLLEGE CLOSED
Week #15 Nov. 28, 2006 Nov 30, 2006	NOTES: foreign key, join, referential integrity, index, data redundancy, queries, computed field, rpts. Word & Access Integration (merge).	Project 2 & 3: LAB 27, 28, 29 & 30
Week #16 Dec. 5, 2006 Dec. 7, 2006	Review for Exam #4 LAST DAY TO TURN IN HOMEWORK	Exam #4 - Databases
Week #17 Dec. 12, 2006 Dec. 14, 2006	No Classes - Final Exams ♦ December 11-15	No Classes - Final Exams ♦ December 11-15 Comprehensive Final Exam ♦ Note Special Time Dec. 14, 11:30am-1:30pm