	Class Schedule - Spring 2007 CIS 146 - Microcomputer Applications - MS Office 2003 TR 11:00am-12:15pm 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 Jan. 9, 2007 Jan. 11, 2007	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 Jan. 16, 2007 Jan. 18, 2007	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 Jan. 23, 2007 Jan. 25, 2007	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 Jan. 30, 2007 Feb. 1, 2007	Review for Exam #1	Exam #1 - Concepts, Terminology, Windows & PowerPoint
Week #5 Feb. 6, 2007 Feb. 8, 2007	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 Feb. 13, 2007 Feb. 15, 2007	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 Feb. 20, 2007 Feb. 22, 2007	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 Feb. 27, 2007 Mar. 1, 2007	Review for exam #2	Exam #2 - Word Processing
Week #9 Mar. 6, 2007 Mar. 8, 2007	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 Mar. 13, 2007 Mar. 15, 2007	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 Mar. 20, 2007 Mar. 22, 2007	Spring Break - No classes March 19-24, 2007
Week #12 Mar. 27, 2007 Mar. 29, 2007	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 #13 Apr. 3, 2007 Apr. 5, 2007	Review for exam #3	Exam #3 - Spreadsheets
Week #14 Apr. 10, 2007 Apr. 12, 2007	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 #15 Apr. 17, 2007 Apr 19, 2007	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 Apr. 24, 2007 Apr. 26, 2007	Review for Exam #4 LAST DAY TO TURN IN HOMEWORK	Exam #4 - Databases
Week #17 May. 1, 2007 May. 3, 2007	No Classes - Final Exams ♦ April 27-May 4 Comprehensive Final Exam ♦ Note Special Time May. 1, 10:30am-12:30pm	No Classes - Final Exams ♦ April 27-May 4