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