	Class Schedule - Spring 2012 CIS 146 - Microcomputer Applications - MS Office 2010 11am CRN: 30912 • 12:30pm CRN: 33729	Hal Harris, Jr. Phone: 983-5950(off) 979-3000(cell) Email: hharris@jeffstateonline.com
	Tuesday (HSB 415)	Thursday LAB (11am 442/12:30pm 447)
Week #1 Jan. 10, 2012 Jan. 12, 2012	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. Start Windows introduction. LAB: Asgn01
Week #2 Jan. 17, 2012 Jan. 19, 2012	Introduction to Windows 146ln02.htm Disk storage - KB, MB, GB, TB floppy, CD, DVDs.	LAB: Asgn02 Work through Pages WIN 1-67 LAB: Asgn03 - Ten Questions
Week #3 Jan. 24, 2012 Jan. 26, 2012	Intro to Windws 7 (Explorer, Help & Office 2010) Pages WIN 1-67 Lecture Notes: Windows and Files	LAB: PowerPoint Chapter 1: Assignments 04, 05.
Week #4 Jan. 31, 2012 Feb. 2, 2012	Review for Exam #1	Exam #1 - Concepts, Terminology, Windows & PowerPoint
Week #5 Feb. 7, 2012 Feb. 9, 2012	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 Chapter 1: Assignments 06, 07. Get started on Word Chapter 2 (Assignment 08) as this assignment involves typing a short term paper.
Week #6 Feb. 14, 2012 Feb. 16, 2012	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	LAB: Word Chapter 2: Assignments 08, 09.
Week #7 Feb. 21, 2012 Feb. 23, 2012	Resume wiz, tables, bullets, line brks, prnt prev, tabs, symbols, off clpbrd, borders, AutoText.	LAB: Word Chapter 3: Assignments 10, 11, 12, & 13.
Week #8 Feb. 28, 2012 Mar. 1, 2012	Review for exam #2	Exam #2 - Word Processing
Week #9 Mar. 6, 2012 Mar. 8, 2012	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.	LAB: Excel Chapter 1: Assignments 14, 15. Get started on Excel Chapter 2: Assignment 16 (omit emailing).
Week #10 Mar. 13, 2012 Mar. 15, 2012	In class exercise AMORT: formulas, operators, order of operations, Abs/Rel, pt mode, sum, avg, sum, max, min, pmt	LAB: Excel Chapter 2: Assignment 16 LAB: Excel Assignments 19 (Payroll), 20 (AMORT) & 21 (Budget).
Spring Break (No Classes) - March 19-23, 2012
Week #11 Mar. 27, 2012 Mar. 29, 2012	IF function w/val & label. More abs/rel. In class exercise: Payroll, Change & Mtg.	LAB: Excel Chapter 3: Assignments 17, 18, 22, & 23. I will not be in class today - AAHEB.
Week #12 Apr. 3, 2012 Apr. 5, 2012	Review for exam #3	Exam #3 - Spreadsheets
Week #13 Apr. 10, 2012 Apr. 12, 2012	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.
Week #14 Apr. 17, 2012 Apr. 19, 2012	NOTES: foreign key, join, referential integrity, index, data redundancy, queries, computed field, rpts. Word & Access Integration (merge).	LAB: Access Chapters 2 & 3: Assignments 27, 28, 29 & 30 LAB: Finish any missing assignments.
Week #15 Apr. 24, 2012 Apr 26, 2012	Review for Exam #4 LAST DAY TO TURN IN HOMEWORK	Exam #4 - Databases
Week #16 May 1, 2012 May 3, 2012	No Classes - Final Exams ♦ April 30 - May 4 Comprehensive Final Exam ♦ Note Special Time 11am Class: Tuesday, May 1, 10:30am-12:30pm	No Classes - Final Exams ♦ April 30 - May 4 Comprehensive Final Exam ♦ Note Special Time 12:30pm Class: Thurs, May 3 11:30am-1:30pm