|
|
Class Schedule - Fall 2002 CIS 146 503- Microcomp Appl. - MS Office XP Mon. & Wed. 11am-12:15pm, Room: RSH 201 |
Hal Harris, Jr. Ph: 520-5950(o)
979-5000(h) Email at school: hharris@jeffstateonline.com Email at home: halharris@directvinternet.com |
|
Monday |
Wednesday (LAB: RSH 200) | |
| Week #1 Aug. 26, 2002 Aug. 28, 2002 |
Welcome, Introduction, Syllabus &
Textbook. Intro to Computers Pg. COM1-COM31 Lec. Notes: Concepts/Term 146ln01.htm |
Finish Concepts and demonstrate how to save and
turn in assignments electronically. |
| Week #2 Sep. 2, 2002 Sep. 4, 2002 |
College Closed |
Introduction to Windows 146ln02.htm |
| Week #3 Sep. 9, 2002 Sep. 11, 2002 |
Intro to Win 98 (Explorer, Help and Office 2000) Pg. INT1.30-INT1.74 LAB 02: Pg. INT1.78 Qu. 1-18 (ans. 5,14, & 17) |
PowerPoint Pgs. PP1.6-PP1.70 LAB 03 |
| Week #4 Sep. 16, 2002 Sep. 18, 2002 |
LAB: 05: PowerPoint - Apply Your Knowledge 1, steps 1-8 only on pg. PP1.71 LAB: Finish Lab Assignments (01-05) Review for first exam |
EXAM #1 - Concepts, Terminology & Windows |
| Week #5 Sep. 23, 2002 Sep. 25, 2002 |
Go over exam. Introduction to Word Processing with Word 2000. See Word Proc. notes. Insertion pt, word wrap, hard/soft ret, save, font. LAB 06 |
Project 1: Pgs. WD1.6-WD1.58 - doc, menu, toolbars, zoom, alignment, undo/redo, select, graphics, print. LAB 07: steps 1-15 Pg. WD1.61 |
| Week #6 Sep. 30, 2002 Oct. 2, 2002 |
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 08 |
Project 2: Pgs. WD2.36-WD2.55 hanging indent, find/replace, selecting text, clipboard, hyperlinks. LAB 09: In the Lab 2 on Pg. WD2.59-WD2.61 |
| Week #7 Oct. 7, 2002 Oct. 9, 2002 |
Project 3: Pgs. WD3.4-WD3.61 Res wiz, tables, bullets, line brks, prnt prev, tabs, symbols, off clpbrd, borders, AutoText. LAB 10 |
LAB 13: In the Lab 1 on Pg. WD3.63, steps 1-5
LAB 11 & 12. LAB: Finish Lab Assign (06-12) |
| Week #8 Oct. 14, 2002 Oct. 16, 2002 |
Review for exam #2 |
EXAM #2 - Word Processing |
| Week #9 Oct. 21, 2002 Oct. 23, 2002 |
Go over exam and introduction to spreadsheets using Excel See spreadsheet notes on web. Cell/ cell address, modes, value/label,.3 mouse pointers. |
Project 1:, fill handle, range, fnctns, frmt nbrs, argmnts, F2 edit ky, abs/rel., LAB 14: Work thru proj. & LAB 15: In the Lab 1 on Pg. E1.60, st 1-10. |
| Week #10 Oct. 28, 2002 Oct. 30, 2002 |
Project 2: formulas, oper, ord of oper, Abs/Rel, pt mode, sum, avg. LAB 16: Work thru proj. LAB 17: In the Lab 1 Pg E2.68-E2.69, st 1-13. |
In class exercise CALC & AMORT LAB 20 & 21: (AMORT handout on network) LAB 18: Work thru proj 3 and LAB 19 |
| Week #11 Nov. 4, 2002 Nov. 6, 2002 |
In class exercise: CHANGE LAB 23: MTG handout on network LAB 22: |
Review for exam #3 |
| Week #12 Nov. 11, 2002 Nov. 13, 2002 |
College Closed |
EXAM #3 - Spreadsheets |
| Week #13 Nov. 18, 2002 Nov. 20, 2002 |
Go over exam and introduction to databases; field, record, table, relational database. Create CLASS phone directory (bonus assignment) |
Project 1 & data types, database structure, primary key LAB 24, 25, & 26. |
| Nov. 25-29 | No Classes - Prof. Development Nov. 25-27 & Thanksgiving Holiday Nov. 28 & 29 | |
| Week #14 Dec. 2, 2002 Dec. 4, 2002 |
LAB 27, 28 & 29 |
Project 2 & foreign key, join, referential integrity, index, data redundancy, queries, computed field, reports. LAB 30 |
| Week #15 Dec. 9, 2002 Dec 11, 2002 |
Review for Exam #4 |
EXAM #4 – Databases |
| Week #16 Dec. 16, 2002 |
Comprehensive Final Exam |
No Classes - Final Exams |