Class Schedule - Fall 2010
CIS 146 - Microcomputer Applications - MS Office 2007
12:30pm-1:45pm (12123)		 Hal Harris, Jr.
Phone: 983-5950(off) 979-5000(hm)
Email: hharris@jeffstateonline.com

Tuesday LAB (RSH 447)

Thursday (RSH 415)

Week #1

Aug. 19, 2010		  Welcome, Introduction, Syllabus, Textbooks.
Intro to Computers Pgs. COM1-COM39
Lec Notes: Concepts/Term 146ln01.htm
Week #2
Aug. 24, 2010
Aug. 26, 2010		 Finish Concepts and demonstrate how to save and turn in assignments electronically. Copy data files.
LAB: Asgn01

Introduction to Windows 146ln02.htm
Disk storage - KB, MB, GB, TB floppy, CD, DVDs.

Week #3
Aug. 31, 2010
Sep. 2, 2010
 LAB: Asgn02
Work through Pages WIN 1-67
LAB: Asgn03 - Ten Questions		 Intro to Windws Vista (Explorer, Help & Office 2010)
Pages WIN 1-67
Lecture Notes: Windows and Files
Week #4
Sep. 7, 2010
Sep. 9, 2010
 LAB: PowerPoint Chapter 1: Assignments 04, 05. Review for Exam #1
Week #5
Sep. 14, 2010
Sep. 16, 2010

Exam #1 - Concepts, Terminology,
Windows & PowerPoint

 Study Intro to Word Proc. Menu, .doc, tlbrs, zm, algnmnt, undo/redo, select, graphics. Ins pt, wd wrap, hard/soft ret, save, font.
Week #6
Sep. 21, 2010
Sep. 23, 2010
 LAB: Asgn06: Word Chapter 1: Assignments 06, 07.
Get started on Word Chapter 2 (Assignment 08) as this assignment involves typing a short term paper.

Project 2: Show/Hide, marg, line spac, headers/footers, pg nbrs, indent, AutoCor, sty, pg bk, F1 hlp key,
hang ind, find/replace, sel text, clpbd, hyplks

Week #7
Sep. 28, 2010
Sep. 30, 2010

LAB: Word Chapter 2: Assignments 08, 09.

 Resume wiz, tables, bullets, line brks, prnt prev, tabs, symbols, off clpbrd, borders, AutoText.
Week #8
Oct. 5, 2010
Oct. 7, 2010
 LAB: Word Chapter 3: Assignments 10, 11, 12, & 13.  Review for exam #2
 
Week #9
Oct. 12, 2010
Oct. 14, 2010

Exam #2 - Word Processing

 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.
Week #10
Oct. 19, 2010
Oct. 21, 2010
 LAB: Excel Chapter 1: Assignments 14, 15.
Get started on Excel Chapter 2: Assignment 16 (omit emailing).
 		 In class exercise AMORT: formulas, operators, order of operations, Abs/Rel, pt mode, sum, avg, sum, max, min, pmt
 
Week #11
Oct..26, 2010
Oct. 28, 2010		 LAB: Excel Chapter 2: Assignment 16
LAB: Excel Assignments 19 (Payroll), 20 (AMORT) & 21 (Budget).		 IF function w/val & label. More abs/rel.
In class exercise: Payroll, Change & Mtg.
Week #12
Nov. 2, 2010
Nov. 4, 2010		 LAB: Excel Chapter 3: Assignments 17, 18, 22, & 23.
 		 Review for exam #3

 

Week #13
Nov. 9, 2010
Nov. 11, 2010

Exam #3 - Spreadsheets

 

VETERAN'S DAY HOLIDAY
NO CLASS - COLLEGE CLOSED

Week #14
Nov. 16, 2010
Nov. 18, 2010

Intro to databases; field, record, table, relational db, data types, db structure, primary key. Also. * CLASS phone dir (bonus asgn) LAB: Access Chapter 1 Assignments 24, 25, & 26.
Get started on Access Chapter 2 Assignment 27.

 NOTES: foreign key, join, referential integrity, index, data redundancy, queries, computed field, rpts. Word & Access Integration (merge).
Week #15
Nov. 23, 2010
Nov. 25, 2010

NO CLASS - Faculty Professional Development

THANKSGIVING HOLIDAY
NO CLASS - COLLEGE CLOSED

Week #16
Nov. 30, 2010
Dec. 2, 2010

Access Chapters 2 & 3: Assignments 27, 28, 29 & 30

 LAB: Catch up on any missing assignments
 LAST DAY TO TURN IN HOMEWORK
Week #17
Dec. 7, 2010
Dec. 9, 2010		  Classroom HSB 415: Review for Exam #4

LAB: Exam #4 - Databases

Week #18
Dec. 14, 2010
Dec. 16, 2010

No Classes - Final Exams ♦ December 11-17
 

No Classes - Final Exams ♦ December 11-17
Comprehensive Final Exam ♦ Note Special Time
Thursday, December 16, 11:30am-1:30pm