Excel Homework 1
Staff Trip Fundraiser

---

Schedule | Syllabus | Printable Version

Note that this assignment was updated 9/1/08 to clarify some points that were asked.

You and two of your staff will be attending a trade show. Besides representing your organization, you will be selling 5 logo items at your booth. This trade show typically receives 10,000 visitors. The proceeds from the logo items will be used for a whitewater rafting trip for all staff members. There is some competition between your staff members as to who will sell the most products for the trip. The top seller of each item will receive that logo item. For this assignment, you will build a spreadsheet to keep track of sales and profits from the logo items for the trip fund.

Excel Skills

• Creating a new Excel spreadsheet - page 321
• Naming a spreadsheet - page 340
• Adding a header to your spreadsheet - pages 354 - 355
• Formatting your spreadsheet to be easy to understand and identify - pages 341 - 346
• Copying information to your spreadsheet - pages 332 - 334
• Creating a simple formula in a spreadsheet - pages 328 - 330
• Adding comments to your spreadsheet - page 356
• Printing your spreadsheet - pages 353 - 356

Homework 1 Specifics

• Create a new Excel spreadsheet file. 5 points
• Save your spreadsheet. Name the file with your last name and Excel. ex. McDougallExcel. This assignment and all of your spreadsheet assignments should be stored as new worksheets in one file. 5 points
• Name your worksheet TripFund. 5 points
• Add a header to your spreadsheet with your first and last name, the current date (using the date function) and CS172. 5 points
• Add your logo to your spreadsheet, using good placement principles. 5 points
• Go online and find a rafting trip near the area of your organization. Find out how much it would cost for 5 people to go on that trip. Keep the URL of the rafting trip - you will need it for your spreadsheet. Your worksheet will show the cost per person and a calculated total. 10 points
• Find a company online that carries 5 products you would like printed with your logo. You will need this information for your spreadsheet. 15 points
• Layout your spreadsheet with the following information. 40 points
  
  1. Title
  2. List yourself and both your employees with the items for sale; so, that you can show how many of each item each employee sold, the cost for the total of each type of item and the total revenue for each type of item - include your self in this. We will discuss the layout in class.
  3. Copy the cost of each item to the spreadsheet - use Paste Special - Unformatted Text to remove all web formatting from the amounts.
  4. The target amount you need for the trip.
  5. Total sales for each employee and for each item.
  6. Formulas to figure out the profit for each employee for each item - and the total per employee.
  7. A place for the amount needed to reach the goal near the profit amount to date.
• All numbers, except the cost of each item, the price of each item, the number each employee has sold, and the sales goal should be the result of formulas in your spreadsheet.
• Copy and paste the two URLS into a comment in the title cell of your spreadsheet. 5 points
• Print your spreadsheet on one sheet. You may need to set the sheet to print in landscape. We will discuss strategies for printing on one sheet in class. 5 points
• Send the spreadsheet file, as an attachment, to the homework email address. Be sure that your Subject line is your last name and Excel Assignment 1. Ex. McDougall Excel Assignment 1
• Turn in a hard copy of your spreadsheet to the instructor, or to the CS office by your lab time on Monday, Sept 8. This hard copy will allow you to have some credit for the assignment, if your file is bad.