| Class Schedule - Fall 2004 CIS 146 - Microcomputer Applications - MS Office 2003 TR 9:30am-10:45, 11-12:15, 12:30-1:45 Room: 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. 24, 2004 Aug. 26, 2004 | 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. 31, 2004 Sep. 2, 2004 | 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. 7, 2004 Sep. 9, 2004 | 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. 14, 2004 Sep. 16, 2004 | Review for Exam #1 | Exam #1 - Concepts, Terminology, Windows & PowerPoint
Week #5 Sep. 21, 2004 Sep. 23, 2004 | Study Intro to Word Proc. Menu, .doc, tlbrs, zm, algnmnt, undo/redo, s elect, 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. 28, 2004 Sep. 30, 2004 | 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. 5, 2004 Oct. 7, 2004 | Resume wiz, tables, bullets, line brks, prnt prev, tabs, symbols, off clpbrd, borders, AutoText. I will not be in class on Oct. 5th - Please work on your assignments either from home, RSH200 (if available), or from the new open computer lab in RSH206. If the door is locked, please ask Jannis Farmer or Linda Hanson or Sandra Pugh to let you in. | 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. 12, 2004 Oct. 14, 2004 | Review for exam #2 | Exam #2 - Word Processing
Week #9 Oct. 19, 2004 Oct. 21, 2004 | 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. 26, 2004 Oct. 28, 2004 | 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. 2, 2004 Nov. 4, 2004 | 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. 9, 2004 Nov. 11, 2004 | Review for exam #3 | VETERANS DAY HOLIDAY NO CLASS - COLLEGE CLOSED
Week #13 Nov. 16, 2004 Nov. 18, 2004 | (in LAB) Exam #3 - Spreadsheets | 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. 23, 2004 Nov. 25, 2004 | NO CLASS - Faculty Professional Development | THANKSGIVING HOLIDAY NO CLASS - COLLEGE CLOSED
Week #15 Nov. 30, 2004 Dec. 2, 2004 | NOTES: foreign key, join, referential integrity, index, data redundancy, queries, computed field, rpts. Word & Access Integration (merge). | Project 2: LAB 27, 28, 29 & 30
Week #16 Dec. 7, 2004 Dec. 9, 2004 | Review for Exam #4 LAST DAY TO TURN IN HOMEWORK | Exam #4 - Databases
Week #17 Dec. 14, 2004 Dec. 16, 2004 | No Classes - Final Exams ♦ December 13-17 Comprehensive Final Exam ♦ Note Special Time 11am Class - Dec 14, 10:30am-12:30pm | No Classes - Final Exams ♦ December 13-17 Comprehensive Final Exam ♦ Note Special Times 9:30am Class - Dec. 16, 10:15am-12:15pm 12:30pm Class - Dec. 16, 12:30am-2:30pm