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.

Assignment 1 - Office Fundamentals

  1. You might be thinking "Hmm... Office Fundamentals?  I thought I was learning Excel."  Normally I would not have you do this chapter, but I think it will be helpful to most everyone due to two reasons.  One is that Office 2007's interface and navigation has changed significantly since the 2003 version.  And, for some students this is their first class using Office and they need to know the basics before getting in to the Excel software.  So enjoy.  This assignment will be easier and take less time than the Excel assignments.
  2. 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, floppy, etc.).
  3. Data file notes:  In order to do this assignment you will need a set of files.  Here is a link to the files.  The link is to a .zip file (compressed set of files).  You will need to download and unzip (uncompress) the files before using them.  If you are not familiar with unzipping files please read the Unzipping Files document for a general set of instructions.  The example is from my CIS 101 class.
  4. Read Chapter 1, Office Fundamentals pages 1 - 52.
  5. Do all three hands-on exercises described on pages 1 - 52.
  6. When you are finished with Exercise 3, step 7 the document should look like Figure 1.44 on page 52.  Please be sure to double check your document against this figure before submitting it for grading.
  7. Do Mid-Level Exercise 2 Formatting a Menu on page 63.
  8. Do Mid-Level Exercise 3 Enhance the Insurance Letter on page 64.
  9. Online students:  Upload the chap1_ho3_internet_solution, chap1_mid2_solution, and  chap1_mid3_solution files to the Office Fundamentals 1 assignment on the TalonNet class website.  Please note that you must submit all three files at the same time to the assignment in TalonNet.  So complete the Internet solution, Mid-Level 2, and Mid-Level 3 solution files before logging in to TalonNet and submitting the assignment.
  10. Traditional students:  During the lab time show me the files on your computer screen.

Last update: 01/06/09