|
op11-TW130 |
Class Schedule - Spring 2005
CIS 146 (504) - Microcomputer Applications - MS Office
XP
TR 11am-12:15, Room: RSH 200 & RSH 201 |
Hal Harris, Jr.
Phone: 520-5950(off) 979-5000(hm)
Email: hharris@jeffstateonline.com
|
|
Tuesday (RSH 201)
|
Thursday LAB (RSH 200)
|
Week #1
Jan. 11, 2005
Jan. 13, 2005 | 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. 18, 2005
Jan. 20, 2005 |
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. 25, 2005
Jan. 27, 2005
| 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. 1, 2005
Feb. 3, 2005
| Review for Exam #1 |
Exam #1 - Concepts,
Terminology,
Windows & PowerPoint |
Week #5
Feb. 8, 2005
Feb. 10, 2005
|
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. 15, 2005
Feb. 17, 2005
| 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. 22, 2005
Feb. 24, 2005
| 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. 1, 2005
Mar. 3, 2005
| Review for exam #2
|
Exam #2 - Word
Processing
|
Week #9
Mar. 8, 2005
Mar. 10, 2005
| 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. 15, 2005
Mar. 17, 2005
|
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
21-26, 2005 (No Classes) - College Closed March 24-26, 2005 |
Week #11
Mar. 29, 2005
Mar. 31, 2005 | 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. 5, 2005
Apr. 7, 2005 |
Review for exam #3 |
Exam #3 - Spreadsheets |
Week #13
Apr. 12, 2005
Apr. 14, 2005 | 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. 19, 2005
Apr. 21, 2005 |
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. 26, 2005
Apr. 28, 2005 |
Review for Exam #4
LAST DAY TO TURN IN HOMEWORK |
Exam #4 - Databases |
Week #16
May 3, 2005
May 5, 2005
|
Final Exams April 29, 2005 - May
5, 2005
Final Exam in room RSH 206
May 3, 2005 10:30am-12:30am |
Final Exams April 29, 2005 - May
5, 2005
No Class - Final Exam Week |
