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 Tutorial 4 - Enhancing a Workbook with Charts and Graphs

Another excellent tutorial.  This tutorial is all about transforming numbers in to charts and graphs.  Studies show that we can understand and analyze data more quickly if it is presented in a visual format.  "A picture is worth a thousands words."  Also, management and top management prefer charts over looking at numbers.  If you work in an office or business environment at some point you may have to create charts.  This tutorial will give you a good foundation in charts and graphs.  Also, sparklines is a new feature in Excel 2010.

Please read all of the directions before getting started on the assignment.

  1. Please note:  Throughout the book it will instruct you to save your files.  In the computer labs on campus you will need to save the files to your USB drive.  If you are using your own computer, then you may save the file to the drive of your choice (hard drive, USB, etc.).
  2. Data file notes:  In order to do this assignment you will need a set of files.  The files are in TalonNet on the Resources page in the Data Files folder.  The data file links are .zip files (compressed set of files).  You will need to download and unzip (uncompress) the files before using them.  Right-click the file link to get the shortcut menu.  Select the Save Target As option and save the file to your drive.  You will then need to unzip (uncompress) the .zip file.  If you are not familiar with unzipping files please read pages FM17 - FM19 or read the Unzipping Files document for a general set of instructions.  The example is from my CIS 101 class.
  3. Read and do the steps in Excel Tutorial 4 pages EX169 - EX222.
  4. Do Case Problem 1 (Kenai Fjords Park) on pages EX224 - EX225.  When you are done your spreadsheets should look like this document.  If you have done the formulas correctly then you will have the same values as shown in the above document.  Please note there maybe multiple pages in the answer document so click the Next Page arrow to see all of the pages.  I do not provide the formulas.  You are to figure them out yourself.  If you have trouble, then email me.  I will help you.  Also, please note we are not using SAM so please ignore the directions about SAM.
  5. Online students:  Upload the New Century Fund.xlsx and Kenai Fjords Park.xlsx files to the Excel Tutorial 4 assignment on the class website in TalonNet.  Please note that you must submit both files at the same time to the assignment in TalonNet.  So complete both the tutorial and the Case Problem 1 before logging in to TalonNet and submitting the assignment.
  6. Traditional students:  During the lab time show the above files listed in step 5 on your computer screen to me.

Last update: 01/29/11