|
op none |
Class Schedule - Fall 2003 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: harris@wwisp.com |
|
Monday |
Wednesday (LAB: RSH 200) | |
| Week #1 Aug. 25, 2003 Aug. 27, 2003 |
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. 1, 2003 Sep. 3, 2003 |
College Closed |
Introduction to Windows 146ln02.htm |
| Week #3 Sep. 8, 2003 Sep. 10, 2003 |
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. 15, 2003 Sep. 17, 2003 |
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. 22, 2003 Sep. 24, 2003 |
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. 29, 2003 Oct. 1, 2003 |
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. 6, 2003 Oct. 8, 2003 |
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. 13, 2003 Oct. 15, 2003 |
Review for exam #2 |
EXAM #2 - Word Processing |
| Week #9 Oct. 20, 2003 Oct. 22, 2003 |
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. 27, 2003 Oct. 29, 2003 |
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) |
| Week #11 Nov. 3, 2003 Nov. 5, 2003 |
LAB 18: Work thru proj 3 and LAB 19 |
In class exercise: CHANGE LAB 23: MTG handout on network LAB 22: |
| Week #12 Nov. 10, 2003 Nov. 12, 2003 |
Review for exam #3
|
EXAM #3 - Spreadsheets |
| Week #13 Nov. 17, 2003 Nov. 19, 2003 |
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. 24-28 | No Classes - Prof. Development Nov. 24-26 & Thanksgiving Holiday Nov. 27 & 29 | |
| Week #14 Dec. 1, 2003 Dec. 3, 2003 |
LAB 27, 28 & 29 |
Project 2 & foreign key, join, referential integrity, index, data redundancy, queries, computed field, reports. LAB 30 |
| Week #15 Dec. 8, 2003 Dec 10, 2003 |
Review for Exam #4 |
EXAM #4 – Databases |
| Week #16 Dec. 15, 2003 |
Comprehensive Final Exam |
No Classes - Final Exams |