	Class Schedule - Fall 2005 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. 23, 2005 Aug. 25, 2005	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. 30, 2005 Sep. 1, 2005	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. 6, 2005 Sep. 8, 2005	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. 13, 2005 Sep. 15, 2005	Review for Exam #1	Exam #1 - Concepts, Terminology, Windows & PowerPoint
Week #5 Sep. 20, 2005 Sep. 22, 2005	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. 27, 2005 Sep. 29, 2005	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. 4, 2005 Oct. 6, 2005	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. 11, 2005 Oct. 13, 2005	Review for exam #2	Exam #2 - Word Processing
Week #9 Oct. 18, 2005 Oct. 20, 2005	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. 25, 2005 Oct. 27, 2005	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 Nov. 1, 2005 Nov. 3, 2005	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. 8, 2005 Nov. 10, 2005	Review for exam #3	Exam #3 - Spreadsheets
Week #13 Nov. 15, 2005 Nov. 17, 2005	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. 22, 2005 Nov. 24, 2005	NO CLASS - Faculty Professional Development	THANKSGIVING HOLIDAY NO CLASS - COLLEGE CLOSED
Week #15 Nov. 29, 2005 Dec. 1, 2005	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. 6, 2005 Dec. 8, 2005	Review for Exam #4 LAST DAY TO TURN IN HOMEWORK	Exam #4 - Databases
Week #17 Dec. 13, 2005 Dec. 15, 2005	No Classes - Final Exams ♦ December 12-16	No Classes - Final Exams ♦ December 12-16 Comprehensive Final Exam ♦ Note Special Time Dec. 15, 12:45pm-2:45pm