All our Essay orders are Original, and are written from scratch. Try us today at 30% off

County Food Inspection Students Project

Want answers to the assignment Below?

Text or Whatsapp Olivia at +1 (307) 209-4351


 

Project 4 Instructions Starting File: Project 4 – CountyFoodInspections – Student.xlsx The Palm Beach County Health Department has asked you to analyze data about health department inspections of a subset of establishments that serve food in Palm Beach County. Follow the steps to produce the results shown in the figures at the end of this document. REALLY IMPORTANT Notes: • This workbook has 3 worksheets initially – you will be adding more: the Documentation worksheet (for the history of this workbook), the Inspections worksheet, and the Reference worksheet. Be sure to work on the correct worksheet as indicated in the instructions. • There is a large amount of data in this workbook! You may want to close most other applications while working on this project to ensure that Excel has enough memory to perform the required operations. • You will be making copies of the different worksheet in many steps – do this by using worksheet copy features (do NOT copy and paste the data, as this may produce incorrect results later). Name the worksheets as indicated, and keep them in order of creation unless otherwise instructed. • Be sure you know how to select just the data in an Excel table column – if you select worksheet columns instead of table columns, your resulting file may become huge in size, making it difficult or impossible to save or upload! • Use the figures at the end of the instructions to verify your results. These figures show only a portion of the data in most cases (ragged edge indicates partial data). • If you have any questions or problems, contact the instructor by FIU email or use the Professor’s WhatsApp chat group. • Remember: Project work must be your own individual work – no group work allowed! Steps: Download the starting file from the Assignment Dropbox and save it on your computer. Then open it to work on it. 1. In the Documentation worksheet, enter your name in cell B3, and the date you created this workbook in cell B4. 2. Enter a short purpose statement in cell B5. Switch to the Inspections worksheet. 3. Re-read the highlighted note above before completing this step. Create an Excel table using all of the data (and only the data) on the Inspections worksheet. Rename the table InspData. Change the table style to light red alternating rows, as shown in Figure 1 below. 4. Center the data within the table in column E. (Hint: position cursor over the table’s column header – when you see the downward-pointing black arrow, click to select just column data within the table. WARNING!! Do not select the entire column in the worksheet. If you select using Excel’s worksheet column letter, you will be selecting the entire column in the worksheet, which could be several hundred thousand rows! If you do this, you may see error messages about insufficient memory.) Adjust the column width appropriately. 5. You will need a custom sort list by the Disposition values in a later step, but Excel has a limit of 255 characters in total for the text in a list. So instead you will create coded values and use a VLOOKUP table to show the disposition value as a coded value instead. a. Insert a new column immediately after the Disposition column. Name it Code. b. Create a formula using the VLOOKUP function and the lookup table on the Reference worksheet. (Hint: the lookup table has a defined name of DispositionCode that you can use for the table_array argument of VLOOKUP.) Copyright © 2019 by P. McDermott-Wells – All Rights Reserved. May not be posted on any internet site except FIU Canvas c. Center the data in the Code column and adjust its width appropriately. Refer to Figure 1 to check your results. 6. Take a moment to save your work. 7. Make a copy of the Inspections worksheet itself (do NOT copy and paste just the data), and rename the newly copied worksheet as Sort. (Hint: Press the Ctrl key and drag the Inspections worksheet tab to the right to make a copy of the entire worksheet.) Switch to the Sort worksheet. 8. Do a multi-level sort of the table data in ascending order by City, then in ascending order by Address, and then in descending order (newest to oldest) by Action Date. (Hint: Use the Sort dialog for this.) 9. Use conditional formatting to highlight all values in the Disposition column that contain the word “Emergency”. Use Yellow fill with Dark Yellow text. (Hint: select only the column in the table by hovering your cursor over the table’s column name. When you see the downward black arrow, click to select. If you use Excel’s worksheet column letter, you will be selecting the entire column in the worksheet, which could be several hundred thousand rows!) 10. Use conditional formatting to highlight all values in the Disposition column that contain “Warning”. Use Green fill with Dark Green text. Refer to Figure 2 to check your results. Take a moment to save your work. 11. Make another copy of the Inspections worksheet (not the Sort worksheet), and rename the new worksheet as Filter. Switch to the Filter worksheet. 12. Filter the table to display only establishments in Belle Glade, Juno Beach and Jupiter. 13. Create a custom sort list to sort the resulting data by the Code value in the order of severity, as shown in this list (Hint: use copy and paste to get these exactly correct): E4 A5 E3 E2 A4 A3 A2 C3 C2 W1 E1 A1 C1 I1 Sort the filtered table using your new custom sort list. 14. Insert a Total row on the filtered table using Excel table features. This should produce a count of the number of rows in your filtered table (not the entire table) at the bottom of the Action Date column. Verify your results using Figure 3 below. Take a moment to save your work. 15. Make a copy of the Inspections worksheet, and rename the new worksheet as Subtotals. Copyright © 2019 by P. McDermott-Wells – All Rights Reserved. May not be posted on any internet site except FIU Canvas Switch to the Subtotals worksheet. 16. Do a multi-level sort by City (ascending), then by Establishment (ascending), then by Code (using your custom list created in Step 13). 17. Turn off the Filter arrows. Convert the table back to a normal range. 18. Use the Subtotal feature to subtotal this data first by Establishment, showing total count for Code. Include the summary information. This may take some time – be patient! 19. Then subtotal again by Disposition using count on Disposition. Do not replace your current subtotals. This will take even more time than the first Subtotal operation, due to the amount of data – be patient! (Hint: You are creating a second set of subtotals.) Expand col. F to see the subtotal labels. Refer to Figure 4 to check your results. Take a moment to save your work. Switch back to the Inspections worksheet. 20. Based on the data in the Inspections worksheet, create a PivotTable in a new worksheet that displays the number of each type of Code by city. Select the pivottable contents and format with cell borders. Change the row and column labels as shown in Figure 5. Name the new worksheet PivotTable, and move this worksheet to the last position (to the right of all other tabs). 21. Add a slicer on the PivotTable worksheet based on City. Position the slicer at N3:P17. Set it to display only Belle Glade, Boynton Beach, Jupiter, and Lantana. Refer to Figure 5 to check your results. 22. Add a PivotChart with style of stacked column chart based on your PivotTable. Position the PivotChart at A11:L25. Refer to Figure 5 to check your results. 23. Your worksheets should be arranged in the order shown in Figure 6. 24. Save your file, close Excel, and submit your file into the Assignment Dropbox in Blackboard. Use the figures on the following pages to verify your work. Copyright © 2019 by P. McDermott-Wells – All Rights Reserved. May not be posted on any internet site except FIU Canvas Figure 1 – Partial view of the data Copyright © 2019 by P. McDermott-Wells – All Rights Reserved. May not be posted on any internet site except FIU Canvas Figure 2 – Partial view of the data Copyright © 2019 by P. McDermott-Wells – All Rights Reserved. May not be posted on any internet site except FIU Canvas Figure 3 Copyright © 2019 by P. McDermott-Wells – All Rights Reserved. May not be posted on any internet site except FIU Canvas Figure 4 – Partial view of the data Copyright © 2019 by P. McDermott-Wells – All Rights Reserved. May not be posted on any internet site except FIU Canvas Figure 5 Figure 6 – Worksheet tab order Copyright © 2019 by P. McDermott-Wells – All Rights Reserved. May not be posted on any internet site except FIU Canvas Palm Beach County Food Inspections Author: Date: Purpose: Data source: ftp://dbprftp.state.fl.us/pub/llweb/2fdinspi.csv License Nbr 6000041 6000071 6000071 6000072 6000073 6000073 6000073 6000073 6000073 6000073 6000073 6000073 6000073 6000094 6000094 6000098 6000112 6000125 6000156 6000164 6000164 6000169 6000199 6000221 6000221 6000221 6000228 6000228 6000234 6000234 6000243 6000243 6000243 6000247 6000255 6000255 6000265 6000283 6000283 6000292 6000292 6000293 6000293 6000297 6000297 6000297 Establishment STAND #4 BANANA BOAT BANANA BOAT THE_BEACH CLUB RESTAURANT HOWLEY’S RESTAURANT HOWLEY’S RESTAURANT HOWLEY’S RESTAURANT HOWLEY’S RESTAURANT HOWLEY’S RESTAURANT HOWLEY’S RESTAURANT HOWLEY’S RESTAURANT HOWLEY’S RESTAURANT HOWLEY’S RESTAURANT MAIN KITCHEN MAIN KITCHEN BRRC DINING ROOM YACHT CLUB RESTAURANT EMPLOYEE CAFETERIA SURFSIDE DINER KFC KFC CAFE BOULUD DELRAY BEACH CLUB INTERNATIONAL HOUSE OF PANCAKES 36-19 INTERNATIONAL HOUSE OF PANCAKES 36-19 INTERNATIONAL HOUSE OF PANCAKES 36-19 LAS REYNAS 3 LAS REYNAS 3 VERDES TROPICANA RESTAURANT VERDES TROPICANA RESTAURANT BATH & TENNIS CLUB RESTAURANT BATH & TENNIS CLUB RESTAURANT BATH & TENNIS CLUB RESTAURANT TOWER REST MCDONALD’S #468 MCDONALD’S #468 MOM’S KITCHEN CARLTON’S WORLD FAMOUS CHICKEN & SEAFOOD INC CARLTON’S WORLD FAMOUS CHICKEN & SEAFOOD INC FOUNTAINS COUNTRY CLUB DR FOUNTAINS COUNTRY CLUB DR RESTAURANT RESTAURANT CLUBHOUSE DINING ROOM CLUBHOUSE DINING ROOM CLUBHOUSE DINING ROOM Address 1111 N CONGRESS AVE 739 E OCEAN AVE 739 E OCEAN AVE 755 N COUNTY RD 4700 S DIXIE HWY 4700 S DIXIE HWY 4700 S DIXIE HWY 4700 S DIXIE HWY 4700 S DIXIE HWY 4700 S DIXIE HWY 4700 S DIXIE HWY 4700 S DIXIE HWY 4700 S DIXIE HWY 501 E CAMINO REAL 501 E CAMINO REAL 501 E CAMINO REAL 2425 MAYA PALM DR 501 E CAMINO REAL 314 S COUNTY RD 4720 N BROADWAY 4720 N BROADWAY 301 AUSTRALIAN AVE 2001 S OCEAN BLVD 312 US HWY 1 312 US HWY 1 312 US HWY 1 3438 LAKE WORTH RD 3438 LAKE WORTH RD 1801 BELVEDERE RD 1801 BELVEDERE RD 1170 S OCEAN BLVD 1170 S OCEAN BLVD 1170 S OCEAN BLVD 44 COCOANUT ROW 3551 BROADWAY 3551 BROADWAY 7478 LAKE WORTH RD 5701 N AUSTRALIAN AVE 5701 N AUSTRALIAN AVE 4476 FOUNTAINS DR 4476 FOUNTAINS DR 10600 S PINE TREE TER 10600 S PINE TREE TER LOST TREE VILLAGE LOST TREE VILLAGE LOST TREE VILLAGE 6000300 6000300 6000304 6000311 6000311 6000314 6000314 6000314 6000348 6000348 6000360 6000360 6000361 6000361 6000370 6000370 6000373 6000373 6000373 6000373 6000377 6000377 6000378 6000380 6000382 6000382 6000383 6000383 6000385 6000392 6000407 6000443 6000445 6000455 6000455 6000472 6000472 6000479 6000479 6000479 6000486 6000486 6000486 6000486 6000500 6000504 6000507 MCDONALD’S #1077 MCDONALD’S #1077 EVERGLADES CLUB DINING ROOM BOCA DUNES COUNTRY CLUB BOCA DUNES COUNTRY CLUB ALTANOUR MEDITERRANEAN CUISINE INC ALTANOUR MEDITERRANEAN CUISINE INC ALTANOUR MEDITERRANEAN CUISINE INC OKEECHOBEE STEAK HOUSE OKEECHOBEE STEAK HOUSE NORTH PALM BEACH COUNTRY CLUB NORTH PALM BEACH COUNTRY CLUB DELRAY SANDS RESORT DELRAY SANDS RESORT BURGER KING # 47 BURGER KING # 47 COLONY HOTEL DINING RM COLONY HOTEL DINING RM COLONY HOTEL DINING RM COLONY HOTEL DINING RM THE BLUE THE BLUE OCEAN BREEZE GOLF & COUNTRY CLUB THE ITALIAN RESTAURANT BOSTON’S BOSTON’S DUNKIN DONUTS DUNKIN DONUTS TEQUESTA COUNTRY CLUBHOUSE DEBRA’S PLACE AMBASSADORS TABLE (THE) BOCA RATON RESORT & CLUB CONVENTION HALL GOLF TERRACE DINING ROOM COUNTRY CLUB DINING RM COUNTRY
The post County Food Inspection Students Project first appeared on Assignment writing service.

Testimonials

Great Job

Great job! Those were you, guys, who made my coursework perfect in time according to all my requirements. I will...

No Complaints So far Guys

Yeah …I really like all the discounts that they offer, the prices are very flexible. Plus they have different promotions...

Best

They look cool and trustworthy enough to me. I gather they made discounts as their prices are quite affordable if...

Best Service

The book review I asked for is so amazing! Endless thanks to your team for completing my review and for...

Mh! not bad…

The worst part ever was to find my deadline postponed for 1 hour ! They couldn`t finish the essay within...

Comes through every time

I have used this website for many times, and each time they found perfect writers for me and they produce...

CLICK HERE  To order your paper

About Scholarfront Essay writing service

We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.

How It Works

To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Are there Discounts?

All new clients are eligible for upto 20% off in their first Order. Our payment method is safe and secure.

 CLICK HERE to Order Your Assignment

 

ORDER WITH 15% DISCOUNT

Let your paper be done by an expert

Custom Essay Writing Service

Our custom essay writing service has already gained a positive reputation in this business field. Understandably so, all custom papers produced by our academic writers are individually crafted from scratch and written according to all your instructions and requirements. We offer Havard, APA, MLA, or Chicago style papers in more than 70 disciplines. With our writing service, you can get quality custom essays, as well as a dissertation, a research paper, or term papers for an affordable price. Any paper will be written on time for a cheap price.

Professional Essay writing service

When professional help in completing any kind of homework is all you need, scholarfront.com is the right place to get it. We guarantee you help in all kinds of academia, including essay, coursework, research, or term paper help etc., it is no problem for us. With our cheap essay writing service, you can be sure to get credible academic aid for a reasonable price, as the name of our website suggests. For years, we have been providing online custom writing assistance to students from countries all over the world, including the United States, Canada, the United Kingdom, Australia, Italy, New Zealand, China, and Japan.