CIS 105
Survey of Computer Information Systems
(Addendum to Assignment Schedule)

ESS-LAB-Excel

Keys for Success

Important: Although you are not required to "submit" all lessons/exercises in your lab book, it is important that you work through the steps to ensure you understand how to complete each of the tasks. The skills within the labs build upon each other and will be included in your tests.

Your data files can be found on the Essentials Student Data disk which came with your textbook, or online through the CIS105 Technology Toolbox or the link below. You will need to save the files to your USB flash drive. http://www.mc.maricopa.edu/dept/d07/cis105/student_disks.html  You will need Excel 2003 files for these projects.

When the book asks you to save to the 3 1/2" A: Floppy drive, you should instead save the files to your USB flash drive to complete your lessons (see syllabus).

Each project/lesson may either require you create a file, open a file and save it to a different name, or both. Be sure to read and follow each step carefully.

Don't forget to read information in the If You Have Problems and the Extending Your Knowledge boxes found throughout the pages of your lab book.

Complete the Following Tasks

1	Read and work through ALL of the Lessons in Projects 1 through 8 in the Microsoft Excel 2003 section of your textbook (pp 389-654)   You will need your data files (from your data CD or you can download them as indicated above.) Ensure your name is located within each file (use header or add to top row) Complete all lessons for each project in this section. A list of all of the files you will submit is listed below. Each file name should begin with your last name and the Project # ((i.e. Smith_P1_Music_Mania.xls) Note: DO NOT use spaces in the file name or it won't upload to WebCT correctly. Note: For Project 5 -- if you are using the 2-volume Essentials set, you will submit 1 file; If you are using the 1-volume Essentials set, you will submit 4 files. Upload each file to the Lab-Excel Dropbox (Don't click Submit until all files files listed below are uploaded).	40 pts
2	Complete and submit all of the following documents through the LAB-Excel Dropbox: Project 7, Challenge 3 - Charting Data Series in Rows or Columns (pg. 633) - Include your name and section number in a document header Save the file as: YourLastName _EE1_P7 challenge. mdb(i.e. Smith_EE1_P7_challenge) Note: DO NOT use spaces in the file name or they may not upload to the dropbox correctly. You do not need to print this document as you will be submitting it online.	20 pts
	Integrating Project 4 - Designing & Testing a Worksheet to Compute Auto Travel Expenses (pp 1207-1208) Integrating Projects are located at the end of the Essential book Include your name and section number in a document header Save the file as: YourLastName_Car_TravelBudget (i.e. Smith_Car_TravelBudget). Note: DO NOT use spaces in the file name or they may not upload to the dropbox correctly. You do not need to print this document as you will be submitting it online.	40 pts
	Integrating Project 5 - Completing a Multiple-Sheet Workbook for an Advertising Agency (pp 1208-1209) Integrating Projects are located at the end of the Essential book Include your name and section number in a document header Save the file as: Acme_Summary_YourLastName (i.e. Acme_Summary_Smith). Note: DO NOT use spaces in the file name or they may not upload to the dropbox correctly. You do not need to print this document as you will be submitting it online.	40 pts
	Submit when finished using the LAB-Excel Dropbox (do not send through email). You will need upload each file. Once all of the files are loaded; then Submit the files. Important: If the files are named incorrectly (without your last name included in the file name or if the name includes spaces) they may not be accepted/graded!	Total 140 pts

LAB-Excel Checklist (Files to be Submitted) 

The following files are worth 5 pts each project  (40 pts total):

• Project 1: Lesson 1-8: P1_YourLastName_Music_Mania.xls
• Project 2: Lesson 1-8: P2_YourLastName_Revenues2004.xls
• Project 3: Lesson 1-8: P3_YourLastName_Format.xls
• Project 4: Lesson 1-8: P4_YourLastName_Puzzle_Power.xls
  
• Project 5: Lesson 1-8: P5_YourLastName_Functions1.xls
  OR
• Project 5: Lesson 1: P5_YourLastName_Functions1.xls AND
• Project 5: Lesson 2-3: P5_YourLastName_Functions2.xls AND
• Project 5: Lesson 4: P5_YourLastName_Functions3.xls AND
• Project 5: Lesson 5-8: P5_YourLastName_Functions4.xls
  
• Project 6: Lesson 1-2: P6_YourLastName_Employee_Sort.xls
• Project 7: Lesson 1: P7_YourLastName_Sample_Charts.xls
• Project 7: Lesson 2-6: P7_YourLastName_My_Charts.xls
• Project 8: Lesson 1-6: P8_YourLastName_Reunion_Budget.xls

The following files are worth the points listed  (100 points total):

• Project 7, Challenge 3 - YourLastName_EE1_P7_Chall3 (20 pts)

• Integrating Project 4 - YourLastName_Car_Travel_Budget (40 pts)

• Integrating Project 5 - YourLastName_Acme_Summary (40 pts)

LATE DEDUCTIONS: (10% each day late; will not be accepted more than one week late).

NOTE:  This schedule may be changed at instructor's discretion.

Revised Aug 16, 2005