|
|
Class Schedule - Fall 2003 CIS 146 502- Microcomp Appl. - MS Office XP Tues. & Thurs. 9:30am-10:45am, Room: RSH 200 and RSH 201 |
Hal Harris, Jr. Ph: 520-5950(o)
979-5000(h) Email at school: hharris@jeffstateonline.com Email at home: harris@wwisp.com |
|
Tuesday |
Thursday (LAB: Library & RSH 200) | |
| Week #1 Aug. 26, 2003 Aug. 28, 2003 |
Welcome, Introduction, Syllabus &
Textbook. Intro to Computers Pg. COM1-COM12 Notes: Concepts/Term fm web page
(first few) |
(LAB in Library) |
| Week #2 Sep. 2, 2003 Sep. 4, 2003 |
How to save and turn in assignments electronically LAB 01: RAM search Asgn01 on network |
(LAB in Library) |
| Week #3 Sep. 9, 2003 Sep. 11, 2003 |
PowerPoint Pgs. PP1.6-PP1.70 LAB 03 |
(LAB in RSH 200) |
| Week #4 Sep. 16, 2003 Sep. 18, 2003 |
Review for first exam |
EXAM #1 - Concepts, Terminology & Windows |
| Week #5 Sep. 23, 2003 Sep. 25, 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 |
(LAB in RSH 200) 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, 2003 Oct. 2, 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 |
(LAB in RSH 200) 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, 2003 Oct. 9, 2003 |
Project 3: Res wiz,
tables, bullets, line brks, prnt prev, tabs, symbols, off clpbrd,
borders, AutoText. LAB 10 |
Project3: Pgs. WD3.4-WD3.61 Finish Lab Assign
(06-12) |
| Week #8 Oct. 14, 2003 Oct. 16, 2003 |
Review for exam #2 |
EXAM #2 - Word Processing |
| Week #9 Oct. 21, 2003 Oct. 23, 2003 |
Go over exam and introduction to spreadsheets using Excel See spreadsheet notes on web. Cell/ cell address, modes, value/label,.3 mouse pointers. |
(LAB in RSH 200) 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, 2003 Oct. 30, 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. |
(LAB in RSH 200) 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, 2003 Nov. 6, 2003 |
(LAB in RSH 200) In class exercise: CHANGE LAB 23: MTG handout on network LAB 22: |
Review for exam #3 |
| Week #12 Nov. 11, 2003 Nov. 13, 2003 |
VETERANS DAY HOLIDAY |
EXAM #3 - Spreadsheets |
| Week #13 Nov. 18, 2003 Nov. 20, 2003 |
Go over exam and introduction to databases; field, record, table, relational database. Discuss Project 1: data types, database structure, primary key. |
Create CLASS phone directory (bonus assignment) Project 1 - LAB 24, 25 & 26 |
| Nov. 24-29 | No Classes - Prof. Development Nov. 24-26 & Thanksgiving Holiday Nov. 27 - 29 | |
| Week #14 Dec. 2, 2003 Dec. 4, 2003 |
Discuss Project 2: foreign key, join,
referential integrity, index, data redundancy, queries, computed field, reports.
|
Project 3 |
| Week #15 Dec. 9, 2003 Dec 11 2003 |
Review for Exam #4 |
EXAM #4 – Databases (in Computer Lab in RSH 200) |
| Week #16 Dec. 18, 2003 |
No Classes - Final Exams |
Comprehensive Final Exam |