Excel Project EXP ECH04 H2 - Biology Department Teaching Schedule 2.2

Helpfulness: 0
Set Details Share
created 5 years ago by ArmandoSilveira
318 views
Excel Project EXP ECH04 H2 - Biology Department Teaching Schedule 2.2
show moreless
Page to share:
Embed this setcancel
COPY
code changes based on your size selection
Size:
X
Show:
1

Excel Project EXP ECH04 H2 - Biology Department Teaching Schedule 2.2

Buy here:

http://homework.plus/products.php?product=Excel-Project-EXP-ECH04-H2-%252d-Biology-Department-Teaching-Schedule-2.2

2

Excel Project EXP ECH04 H2 - Biology Department Teaching Schedule 2.2

EXP ECH04 H2 - Biology Department Teaching Schedule 2.2

Project Description:

As the department head of the Biology Department at a university, you prepare and finalize the faculty teaching schedule. Scheduling preparation takes time because you must ensure that you do not book faculty for different courses at the same time or double-book a classroom with two different classes. You downloaded the Spring 2015 schedule as a starting point and edited it to prepare the Spring 2016 schedule, and now you need to sort and filter the schedule to review it from several perspectives.

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

Step

Instructions

Points Possible

1

Start Excel. Download and open the file namede4_grader_h2.xlsx.

0.000

2

Freeze the top row in the Faculty sheet.

2.000

3

In the Faculty sheet, convert the data to a table and name the table Spring2016.

5.000

4

In the Faculty sheet, apply Table Style Light 14 to the table.

5.000

5

In the Faculty sheet, sort the table by Instructor, then Days, and then Start Time. Create a custom sort order for Days so that it appears in this sequence: MTWR, MWF, MW, M, W, F, TR, T, R. (The day abbreviations are as follows: M=Monday, T=Tuesday, W=Wednesday, R=Thursday, F=Friday.)

10.000

6

In the Faculty sheet, remove duplicate records from the table.

5.000

7

Copy the Faculty sheet, place the copied worksheet to the right of the Faculty sheet, and then rename the duplicate worksheetRooms.

10.000

8

Sort the data in the Rooms sheet by Room in ascending order, then by Days using the custom sort order you created in step 5, and finally by Start Time from earliest to latest time. Delete the ID, Course Number, and Instructor columns in the Rooms sheet.

5.000

9

Copy the Rooms sheet, place the copied worksheet to the right of the Rooms sheet, and then rename the duplicate worksheetPrime Time.

10.000

10

Filter the table in the Prime Time sheet to show only classes scheduled on any combination of Monday, Wednesday, and Friday. Do not include any combination of Tuesday or Thursday classes though.

6.000

11

Keep the existing filter and add a filter to display classes that start at 9:00 AM, 10:00 AM, 11:00 AM, and 12:00 PM.

5.000

12

In the Faculty sheet, insert a field on the right side of the Room field. Type the label Capacity. Insert a lookup function that looks up the room number, compares it to the lookup table in the Room Capacity worksheet, and returns the room capacity. Make sure the function copies down the entire column.

15.000

13

To prepare the workbook for printing, repeat the column labels on all pages for the Faculty, Rooms, and Prime Time worksheets.

Select the first three sheet tabs. Set 0.2-inch left and right margins, Landscape orientation, and 95% scaling.

10.000

14

On the Faculty sheet, set these column widths: 8.43 (64 Pixels) - Capacity and 25 (180 Pixels) - Instructor.

6.000

15

On the Faculty sheet, insert a footer with the text Exploring Series on the left side, the sheet name code in the center, and the file name code on the right side.

6.000

16

Ensure that the worksheets are correctly named and placed in the following order in the workbook: Faculty, Rooms, Prime Time, Room Capacity. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.

0.000

Total Points

100.000