	Class Schedule - Fall 2011 CIS 146 - Microcomputer Applications - MS Office 2010 Tue/Thu 9:30am-10:45am (12120) & 11:00am-12:15pm (13109)	Hal Harris, Jr. Phone: 983-5950(office) 979-3000(cell) Email: hharris@jeffstateonline.com
	Tuesday LAB (9:30am HSB 442, 11am HSB 447)	Thursday Lecture (9:30am HSB 442, 11am HSB 447)
Week #1 Aug. 18, 2011		Welcome, Introduction, Syllabus, Textbooks. Intro to Computers Pgs. COM1-COM39 Lec Notes: Concepts/Term 146ln01.htm
Week #2 Aug. 23, 2011 Aug. 25, 2011	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. 30, 2011 Sep. 1, 2011	LAB: Asgn02 Work through Pages OFF 1-75 LAB: Asgn03 - Ten Questions	Intro to Windws (Explorer, Help & Office 2011) Pages WIN 1-67 Lecture Notes: Windows and Files
Week #4 Sep. 6, 2011 Sep. 8, 2011	LAB: PowerPoint Chapter 1: Assignments 04, 05.	Review for Exam #1
Week #5 Sep. 13, 2011 Sep. 15, 2011	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. 20, 2011 Sep. 22, 2011	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. 27, 2011 Sep. 29, 2011	LAB: Word Chapter 2: Assignments 08, 09.	Resume wiz, tables, bullets, line brks, prnt prev, tabs, symbols, off clpbrd, borders, AutoText.
Week #8 Oct. 4, 2011 Oct. 6, 2011	LAB: Word Chapter 3: Assignments 10, 11, 12, & 13.	Review for exam #2
Week #9 Oct. 11, 2011 Oct. 13, 2011	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. 18, 2011 Oct. 20, 2011	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. 25, 2011 Oct. 27, 2011	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. 1, 2011 Nov. 3, 2011	LAB: Excel Chapter 3: Assignments 17, 18, 22, & 23.	Review for exam #3
Week #13 Nov. 8, 2011 Nov. 10, 2011	Exam #3 - Spreadsheets	Intro to databases; field, record, table, relational db, data types, db structure, primary key. Also. * CLASS phone dir (bonus asgn)
Week #14 Nov. 15, 2011 Nov. 17, 2011	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. 22, 2011 Nov. 24, 2011	NO CLASS - Faculty Professional Development	THANKSGIVING HOLIDAY NO CLASS - COLLEGE CLOSED
Week #16 Nov. 29, 2011 Dec. 1, 2011	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. 6, 2011 Dec. 8, 2011	Classroom HSB 415: Review for Exam #4	LAB: Exam #4 - Databases
Week #18 Dec. 13, 2011 Dec. 15, 2011	No Classes - Final Exams ♦ December 10-16 11am Class Comprehensive Final Exam ♦ Note Special Time Tuesday, December 13, 10:30am-12:30pm	No Classes - Final Exams ♦ December 10-16 9:30am Class Comprehensive Final Exam ♦ Note Special Time Thursday, December 15, 9:00am-11:00am