CGS2108c Excel Cover Sheet
(Chapter 4: EX 265 - 336, Chapter 5: EX 337 - 415, Chapter 6: EX 417 - 505)

Name: _______________________

This assignment is worth 45 points

Chapters/Cases (*see notes below)

Points Deserved Earned

Excel Chapter 4 (EX 312), "all sections" only. See instructions below for how to put name in footer of worksheets .

5    

Excel Chapter 4, Case 2 (EX 335); create a data table using the "table" formula feature; range names, conditional format

10    

Excel Chapter 5 (EX 394 - print worksheet as one page, 398 -CSV file)

5    

Excel Chapter 5, Case 2 (EX 414) copy and paste each sort to a new sheet

10    

Excel Chapter 6 (EX 476) print consolidated worksheet and chart only

5    

Excel Chapter 6, Case 2 (EX 504). Create individual sheets, summary sheet and chart with appropriate consolidated data only on separate labeled sheet

10    

Total

45    
Extra Credit (list cases @ 1 - 5 points each)    

*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).

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

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)! OnLine students don't print; submit the final files (after each chapter and case is completed - zipped up...:).

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: