CGS2100 Excel Cover Sheet (45 pts)
(Chapter 1: EX 1 - 80, Chapter 2: EX 81 - 159, Chapter 3: EX 161 - 248)

Deserved

Earned

Excel Chapter 1 (EX 58) - Worksheet/chart with name in footer - See instructions below for how to put name in footer.

5

Excel Chapter 1, Case 2 (EX 79) Format worksheet cells, create 3D column chart, include expense averages (rows) and quarterly totals (columns).

10

Excel Chapter 2 (EX 134, 135, 136) – Fit to one page - worksheets and formulas. Online students will send final file only.

5

Excel Chapter 2, Case 2 (EX 157) – Use formulas provided in case, wrap labels, include appropriate theme, conditional format, save/print after changing #'s, fit to one page - worksheet and formulas.

10

Excel Chapter 3 (EX 218, 227 after running goal seek) - Fit to one page - worksheets and formulas. Online students should copy data to a separate worksheet before performing "goal seek" and saving results.

5

Excel Chapter 3, Case 2 (EX 245- 246) - This case is similar to chapter with assumptions listed below worksheet data; use Abs cell ref$ in formulas;  Chart and "What-If" on separate worksheets.  Include appropriate theme, text/number formatting, cylinder chart, formulas, fit to page.

10

Total Points

5

*You should begin these assignments on the first page of each chapter and work through the page(s) listed above, printing or saving as necessary (depending on whether you are in an on-campus or online class). On Campus students MUST PRINT FORMULAS (CTRL ~) in addition the regular worksheet printouts. Make sure you print the formulas in landscape and "fit to one page" (make sure all worksheets fit on one page using this technique, as necessary)!

**Data Disk files can be downloaded from SCsite  (see inside back cover of book) or from campus computers: G:\Datalib\CGS2100

Insert Footer to put your name on every printout/file (For web page printouts, you will have to put your name within the document, not the footer)!  Print Preview before printing to insure everything is as it should be....(Online students don't print; send me completed files)

Make sure you use the concepts and techniques taught in the chapter on your cases to insure full credit is earned.  Even though I may have you save or print a file before the end of the chapter, you are responsible for continuing through the book and knowing all material presented.

Instructor/Student Notes: