|
op130 | Class Schedule - Spring
2004
CIS 146 - Microcomputer Applications - MS Office
XP
TR 9:30am-10: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
Jan. 13, 2004
Jan. 15, 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
Jan. 20, 2004
Jan. 22, 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
Jan. 27, 2004
Jan. 29, 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
Feb. 3, 2004
Feb. 5, 2004
| Review for Exam #1 |
Exam #1 - Concepts,
Terminology,
Windows & PowerPoint |
Week #5
Feb. 10, 2004
Feb. 12, 2004
|
I will not be in class on Feb. 10 due to a
seminar - MSDN TechNet Briefing.
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. 17, 2004
Feb. 19, 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
Feb. 24, 2004
Feb. 26, 2004
| 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
Mar. 2, 2004
Mar. 4, 2004
| Review for exam #2
|
Exam #2 - Word
Processing
I will
not be in class on Mar. 4 due to an AAHEB conference.
Linda Hanson will administer the exam for me while I'm out. |
Week #9
Mar. 9, 2004
Mar. 11, 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
Mar. 16, 2004
Mar. 18, 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 |
|
Spring Break - March
22-26, 2004 - College Closed March
25-26, 2004 |
Week #11
Mar. 30, 2004
Apr. 1, 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
Apr. 6, 2004
Apr. 8, 2004 |
Review for exam #3 |
Exam #3 - Spreadsheets |
Week #13
Apr. 13, 2004
Apr. 15, 2004 | Go
over exam and Intro to databases;
field, record, table, relational database, data types, database structure,
primary key. Also. |
Create CLASS phone directory (bonus assignment)
Project 1 &
LAB 24, 25, & 26. |
Week #14
Apr. 20, 2004
Apr. 22, 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 #15
Apr. 27, 2004
Apr. 29, 2004 |
Review for Exam #4
LAST DAY TO TURN IN HOMEWORK |
Exam #4 - Databases |
Week #16
May 4, 2004
May 6, 2004
|
Final Exams April 30, 2004 - May
6, 2004
No Class - Final Exam Week |
Final Exams April 30, 2004 - May
6, 2004
Final Exam
May 6, 2004 10:15am-12:15am |