RECR 200 - Week 10 Assignment

All assignments must be submitted to Sakai.

Excel

General Description

Scheduling is a common use of Excel - especially when you are managing a space with multiple rooms and multiple activities. This assignment will require you to take a very basic schedule in Excel and make it easier to read using some basic functions in Excel. You will use this Excel file.

Instructions

This Excel file has THREE tabs and you will have activities to complete in each of the tabs. The first tab is a schedule you will need to revise to make look nicer, the second tab will be a mock schedule you will build for Tuesday of the week, the third tab is employee and volunteer hours that will require specific tasks. Using this Excel file, make the schedule easier to read by doing the following:

Tabs ONE and TWO

  1. The text currently has overlapping text because the cells are all the same size. Adjust the size of the cells so the text is easier to read and one does not have to click on the cell to read the contents - they should be immediately readable.
  2. It is difficult to see where one activity starts and stops. Color each of the activities in a room different colors. For example, the items happening on the tennis court should have different colors. The colors can be duplicated in other rooms. For example, if you use yellow in the tennis court reservations, you can also use yellow for pool 1.
  3. Make the font easier to read.
  4. Make borders around the schedule, between the spaces, and between the events.
  5. Make the list of time in the first column and the rooms in the first row stand out differently from the text in the body part of the spreadsheet.
  6. Use the second tab for December 6th and enter in a similar schedule for this day. Make sure to also label the tab appropriately.

Tab THREE

  1. Adjust the cells to make the text within them visible.
  2. Add yourself in as either a volunteer or employee.
  3. Sort the data so the employee hours are listed before the volunteer hours
  4. Alphabetize the employees by last name.
  5. Using the sum function in Excel, add up each employee's and volunteer's hours.
  6. Add up the total volunteer hours and total employee hours using the sum function.
  7. Add borders for each row and make Row 2 and Column A bold
  8. Add in some color to distinguish the volunteers from the employees.

Output

The revised Excel file submitted on Sakai.