Cerritos Home Susan Fuschetto Home Susan Fuschetto Home Cerritos Home Campus Information Admissions Academic Resources Student Resources Administration Personnel Services Search Cerritos College Computer and Information Sciences rectangle Susan Fuschetto header

Susan Fuschetto
(page divider)

CIS 151 Excel For I.T.

Excel Assignment 5 - Data to Information

Notes:

In the hands-on exercise 2 steps there are a couple corrections.  Page 332, item f should read "... cells D3:D14." not through D16.  Same problem on page 333, item b, and page 336, item a.  On page 336, item e be sure to format it left aligned and no fill.  On page 337, items a and d be sure to bold the labels.  Page 339, item d the average salary of all employees should be $52,462.  Page 357, item f be sure to switch back to Excel before doing the step.

For the practice exercise #3, page 366, item e, the first sentence should be "Click G4, not E4."  And in the second sentence it should be "Click E4, not F4."  Item f, first bullet where it says A25:E25 it should be A25:E26.  Also, item i, first bullet it may be easier just to do the following steps:  Page Layout Tab, Page Setup dialogue box launcher, Header/Footer Tab, Custom Footer.

For the practice exercise #4, page 368, step g can be tricky.  Select the cells E4:E8 which is the Sophomore column, then point to the edge of the selection and then drag it left.  You will see a vertical bar as you drag.  Drag the bar between columns B and C.  Release the mouse.  The goal is to have the classes in the correct order moving left to right:  Freshman, Sophomore, Junior, then Senior.  Widen the C column so that the heading Sophomore is not wrapped around in the cell.

I hope these notes help.

  1. Read Chapter 5 pages 303 - 357.
  2. Do all three hands-on exercises described on pages 303 - 357.
  3. Do Practice Exercise #3 pages 365 - 366.
  4. Do Practice Exercise #4 pages 367 - 368.
  5. Online students:  Upload the chap5_ho2_hremployee_solution, chap5_ho3_salesrep_solution, chap5_pe3_scholarship_solution, and  chap5_pe4_exscholarship_solution files to the Excel 5 assignment on the class website.
  6. Traditional students:  During the lab time show the chap5_ho2_hremployee_solution, chap5_ho3_salesrep_solution, chap5_pe3_scholarship_solution, and  chap5_pe4_exscholarship_solution files on your computer screen to me.

Last update: 08/26/08