Page 13 - ILCC BUSINESS COMPUTER APPS SYLLABUS FALL 2017

EXCEL
SPREADSHEETS

WEEK 9 - October 16 - 18

EXCEL MODULE 1

EXCEL SPREADSHEETS  Creating A Worksheet and A Chart ................................................................ EX 1—EX 49 (5 pts)

In-The-Labs

 Lab1: First Quarter Revenue Analysis Worksheet .............................. EX 53—EX 54 (5 pts)

SUBMIT COMPLETED ASSIGNMENTS VIA E-COMPANION DROPBOX

WEEK 10 - October 23 - 25
EXCEL MODULE 2

 Formulas, Functions, and Formatting .......................................................... EX 57—EX 105 (5 pts)

In-The-Lab

 Lab 1: Insurance Premium Worksheet ............................................ EX 109—EX 110 (5 pts)

SUBMIT COMPLETED ASSIGNMENTS VIA E-COMPANION DROPBOX

WEEK 11 - October 30 - November 1
EXCEL MODULE 3

 Working With Large Worksheets Charting and What If Analysis ............ EX 113—EX 172 (5 pts)

In-The-Lab

 Lab 1: Eight-Year Financial Projections ......................................... EX 177—EX 181 (5 pts)

WEEK 12 - November 6 - 8
CATTCH UP

WEEK 13 - November 13 - 15

 SAM - EXCEL 2016 - MODULE 1-3 - CAPSTONE PROJECT 1A (50 pts)