|
| Class Schedule
- Fall
2004
CIS 146 - Microcomputer Applications - MS Office
2003
TR 9:30am-10:45, 11-12:15, 12:30-1: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
Aug. 24, 2004
Aug. 26, 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
Aug. 31, 2004
Sep. 2, 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
Sep. 7, 2004
Sep. 9, 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
Sep. 14, 2004
Sep. 16, 2004
| Review for Exam #1 |
Exam #1 - Concepts,
Terminology,
Windows & PowerPoint |
Week #5
Sep. 21, 2004
Sep. 23, 2004
|
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
Sep. 28, 2004
Sep. 30, 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
Oct. 5, 2004
Oct. 7, 2004
| Resume wiz, tables, bullets, line brks, prnt prev, tabs, symbols,
off clpbrd, borders, AutoText.
I will not be in class on Oct. 5th - Please work on your assignments either from home, RSH200 (if available), or from the new open computer lab in RSH206. If the door is locked, please ask Jannis Farmer or Linda Hanson or Sandra Pugh to let you in.
|
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
Oct. 12, 2004
Oct. 14, 2004
| Review for exam #2
|
Exam #2 - Word
Processing |
Week #9
Oct. 19, 2004
Oct. 21, 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
Oct. 26, 2004
Oct. 28, 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 |
Week #11
Nov. 2, 2004
Nov. 4, 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
Nov. 9, 2004
Nov. 11, 2004 |
Review for exam #3 |
VETERANS DAY HOLIDAY
NO CLASS - COLLEGE CLOSED |
Week #13
Nov. 16, 2004
Nov. 18, 2004 |
(in LAB) Exam #3 - Spreadsheets |
Intro to databases;
field, record, table, relational db, data types, db structure,
primary key. Also. CLASS phone dir (bonus asgn)
Project 1 &
LAB 24, 25, & 26. |
Week #14
Nov. 23, 2004
Nov. 25, 2004 |
NO CLASS - Faculty Professional Development |
THANKSGIVING HOLIDAY
NO CLASS - COLLEGE CLOSED |
Week #15
Nov. 30, 2004
Dec. 2, 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 #16
Dec. 7, 2004
Dec. 9, 2004
|
Review for Exam #4
LAST DAY TO TURN IN HOMEWORK |
Exam #4 - Databases |
Week #17
Dec. 14, 2004
Dec. 16, 2004
|
No Classes -
Final Exams ♦
December 13-17
Comprehensive Final Exam ♦ Note
Special Time
11am Class - Dec 14, 10:30am-12:30pm |
No Classes -
Final Exams ♦
December 13-17
Comprehensive Final
Exam ♦ Note Special Times
9:30am Class - Dec. 16, 10:15am-12:15pm
12:30pm Class - Dec. 16, 12:30am-2:30pm |
