Class Schedule - Spring 2008
CIS 146 - Microcomputer Applications - MS Office 2007
11am - 12:15pm
Hal Harris, Jr.
Phone: 520-5950(off) 979-5000(hm)
Email: hharris@jeffstateonline.com

Tuesday (HSB 415)

Thursday LAB (HSB 451)

Week #1
Jan. 8, 2008
Jan. 10, 2008
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. 15, 2008
Jan. 17, 2008
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. 22, 2008
Jan. 24, 2008

Intro to Windws Vista (Explorer, Help & Office 2007)
Pages WIN 1-67
Lecture Notes: Windows and Files
LAB: PowerPoint Chapter 1: Assignments 04, 05.
Week #4
Jan. 29, 2008
Jan. 31, 2008

Review for Exam #1

 

Exam #1 - Concepts, Terminology,
Windows & PowerPoint
 
Week #5
Feb. 5, 2008
Feb. 7, 2008

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. 12, 2008
Feb. 24, 2008

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. 19, 2008
Feb. 21, 2008

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. 26, 2008
Feb. 28, 2008

Review for exam #2

 

Exam #2 - Word Processing

 
Week #9
Mar. 4, 2008
Mar. 6, 2008

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.

I will be at a conference today, so NO CLASS TODAY
Please work on assignments in computer lab.

LAB: Excel Chapter 1: Assignments 14, 15.
Get started on Excel Chapter 2: Assignment 16 (omit emailing).
Week #10
Mar. 11, 2008
Mar. 13, 2008

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 16-22, 2008

Week #11
Mar. 25, 2008
Mar. 27, 2008
IF function w/val & label. More abs/rel.
In class exercise: Payroll, Change & Mtg.
 
LAB: Excel Chapter 3: Assignments 17, 18, 22, & 23.

 
Week #12
Apr. 1, 2008
Apr. 3, 2008
Review for exam #3

 
Exam #3 - Spreadsheets
Week #13
Apr. 8, 2008
Apr. 10, 2008
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. 15, 2008
Apr. 17, 2008

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

Week #15
Apr. 22, 2008
Apr 24, 2008
Review for Exam #4
LAST DAY TO TURN IN HOMEWORK
Exam #4 - Databases
 
Week #16
Apr. 29, 2008
May. 1, 2008

No Classes -Final Exams ♦ April 26-May 2
Comprehensive Final Exam ♦ Note Special Room & Time
HSB 451 - Tuesday, April 29, 10:30am-12:30pm
No Classes - Final Exams ♦ April 26-May 2