Class Schedule - Spring 2015
CIS 146 - Microcomputer Applications - MS Office 2013
11am-12:15pm CRN: 31088
Hal Harris, Jr.
Phone: 983-5950(off) 979-3000(cell)
Email: hharris@jeffstateonline.com

Tuesday LAB (HSB 447)

Thursday (HSB 413)

Week #1

Jan. 8, 2015
  Welcome, Introduction, Syllabus, Textbooks.
Intro to Computers Pgs. IT1-IT36
Lec Notes: Concepts/Term Computer Concepts
Week #2
Jan. 13, 2015
Jan. 15, 2015
Finish Concepts and demonstrate how to save and turn in assignments electronically. Start Windows introduction.
LAB: Asgn01
Introduction to Windows
Disk storage - KB, MB, GB, TB floppy, CD, DVDs. (Explorer, Help & Office 2015) Pages OFF1-OFF81
Week #3
Jan. 20, 2015
Jan. 22, 2015
LAB: Asgn02 • LAB: Asgn03 - Ten Questions
Work through Pages OFF1-OFF81
PowerPoint Introduction
Week #4
Jan. 27, 2015
Jan. 29, 2015

LAB: PowerPoint Chapter 1: Assignments 04, 05. Review for Exam #1
Week #5
Feb. 3, 2015
Feb. 5, 2015

Exam #1 - Concepts, Terminology,
Windows & PowerPoint

 
 
Study Intro to Word Processing. Menu, .doc, tlbrs, zm, algnmnt, undo/redo, select, graphics. Ins pt, wd wrap, hard/soft ret, save, font.
Week #6
Feb. 10, 2015
Feb. 12, 2015

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
Feb. 17, 2015
Feb. 19, 2015

LAB: Word Chapter 2: Assignments 08, 09.

Resume wiz, tables, bullets, line brks, prnt prev, tabs, symbols, off clpbrd, borders, AutoText.

Week #8
Feb. 24, 2015
Feb. 26, 2015

LAB: Word Chapter 3: Assignments 10, 11, 12, & 13
 

Review for exam #2
Week #9
Mar. 3, 2015
Mar. 5, 2015

Exam #2 - Word Processing Go over exam. Intro to Spreadsheets. Cell, cell addr, modes, val/lab, 3 mouse ptrs, fill handle, range, fnctns, frmt nbrs, argmnts, F2 edit ky, abs/rel.  
Week #10
Mar. 10, 2015
Mar. 12, 2015

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
Mar. 19, 2015
Mar. 19, 2015
LAB: Excel Assignments 19 (Payroll), 20 (AMORT) & 21 (Budget). LAB: Excel Chapter 2: Assignment 16
IF function w/val & label. More abs/rel.
In class exercise: Payroll, Change & Mtg.
Week #12
Mar. 24, 2015
Mar. 26, 2015
LAB: Excel Chapter 3: Assignments 17, 18, 22, & 23.
Review for exam #3

No Classes - Spring Break March 30 - April 3, 2015

Week #13
Apr. 7, 2015
Apr. 9, 2015
Exam #3 - Spreadsheets
 
Intro to databases; field, record, table, relational db, data types, db structure, primary key.
Week #14
Apr. 14, 2015
Apr. 16, 2015
CLASS phone dir (bonus asgn)
LAB: Access Chapter 1 Assignments 24, 25, & 26.
Get started on Access Chapter 2 Assignment 27.

Microsoft Access: foreign key, join, referential integrity, index, data redundancy, queries, computed field, rpts. Word & Access Integration (merge).

Week #15
Apr. 21, 2015
Apr. 23, 2015

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


Review for Exam #4

Week #16
Apr. 28, 2015
Apr. 30, 2015

Exam #4 - Databases

LAB: Finish any missing assignments.
LAST DAY TO TURN IN HOMEWORK
Week #17
May. 5, 2015
May. 7, 2015

No Classes - Final Exams ♦ May 2-8
Comprehensive Final Exam ♦ Note Special Time
Tuesday, May 5, 10:30am-12:30pm

No Classes - Final Exams ♦ May 2-8