see all attachments

need in 5 hours 

willing to pay more for rushing

Exp22_Excel_AppCapstone_IntroAssessment_Travel  

Exp22 Excel AppCapstone IntroAssessment Travel

Excel Application Capstone Assessment 

Project Description:

You are considering several cities for a vacation. In particular, you are interested in Washington DC, Philadelphia, and Boston. You will format a list of memorials in DC, add Sparklines to compare the number of visitors over a 15-year period, and create a bar chart to illustrate annual visitors at each memorial. In addition, you will create a table of sightseeing locations, sort and filter the data, apply conditional formatting, and add a total row to display average time needed to spend at each memorial. Finally, you will complete a worksheet by adding formulas to compare estimated major expenses for each city.

Start Excel. Download and open   the file named Exp22_Excel_AppCapstone_IntroAssessment_Travel.xlsx.   Grader has automatically added your last name to the beginning of the   filename.

One worksheet has the original   default name, Sheet1. You want to give the worksheet a meaningful name.
 

  Rename Sheet1 as DC2017.

You want to move the Year   Completed column between the Memorial and 2002 columns.
 

  Select and cut column F. Insert cut cells in cell B1.

Now you want to separate the   worksheet title and source from the dataset with a blank row.
 

  Insert a blank row between rows 2 and 3.

Now you are ready to work with   the DC2020 worksheet. Your first task is to correct spelling errors.
 

  Display the DC2020 worksheet. Check the spelling and correct all misspelled   words.

Continue using the DC2020   worksheet. You will format the headings on row 4.
 

  Select the range A4:G4, wrap the text, apply Center horizontal alignment, and   apply Blue, Accent 5, Lighter 60% fill color.

You now want to format the title   so that it is more prominent.
 

  Merge and center the title in the range A1:G1. Apply Blue, Accent5 cell style   and bold to the title.

The first column is too narrow   for the names of the memorials. You will increase the width to display the   full memorial names.
 

  Change the width of column A to 34.

Sparklines provide visual   representations of data. You will insert sparklines for the dataset.
 

  Select the range C5:F10 and insert Line Sparklines in the range G5:G10.

Now you will format the   sparklines.
 

  Select the range G5:G10, display the high point sparkline marker, and change   the color of the high point markers to Dark Red.

You want to create a chart that   compares the number of visitors for each memorial.
 

  Select the ranges A4:A10 and C4:F10 and create a clustered column chart.   Apply the Monochromatic Palette 12 chart color. Apply the gradient fill to   the chart area. Do not change the default gradient options.

The chart displays over the   data. You will move it below the dataset and adjust its size. In addition,   you will add Alt Text for accessibility compliance.
 

  Cut the chart and paste it in cell A13. Change the chart height to 6″   and the chart width to 7″. Add Alt Text The chart shows the number of visitors to   each memorial for four years. (including the period).

The chart needs a meaningful   title. In addition, you want to format the axes and add gridlines.
 

  Change the chart title to Annual Visitors. Apply Blue, Accent 5, Darker 25% font color to   the chart title and category axis labels. Change the value axis display units   to Millions. Add Primary Minor Vertical gridlines to the chart.

You want to add data labels for   one data series.
 

  Apply data labels to the outside end position of the 2020 data series. Apply   Number format with 1 decimal place to the data labels.

Now you are ready to focus on   the Places worksheet. First, you will find an abbreviation and replace it   with a city name.
 

  Display the Places worksheet. Find all occurrences of BOS and replace them with Boston.

You decide to convert the   dataset to a table, assign a name to the table, and apply a table style.
 

  Convert the data to a table, assign the table name Tourist_Attractions, and apply Blue, Table Style   Light 13.

The table on the Places   worksheet is large. As you scroll through the table, you want the headings to   remain onscreen.
 

  Freeze the top row.

You decide to rearrange the data   to cluster the memorials by city and then by location.
 

  Sort the table by City in alphabetical order and then within City, sort by   Sightseeing Locations in alphabetical order.

You want to insert a total row   to display the average time recommended to view the memorials.
 

  Add a total row. Change the total value to display the average of the Time   Needed column. Apply Number format with zero decimal places to the total.   Type Average   Time in cell   A41.

You want to apply conditional   formatting to highlight the times over 60 minutes to view the memorial.
 

  Select the values in the Time Needed column (range D2:D40) and apply   conditional formatting to highlight cells containing values greater than 60 with Light Red Fill.

Most memorials have free   admission, but some charge a small fee. You want to set a filter to display   only memorials that charge less than or equal to $10.
 

  Apply a filter to display only fees that are less than or equal to $10.

For the rest of the tasks, you   will work with the Cities worksheet. Your first task is to enter today’s   date.
 

  Display the Cities worksheet. Insert the TODAY function in cell B1.

You want to calculate the   estimated car rental cost.
 

  Click cell F4 and enter a formula that will subtract the Departure Date (B2)   from the Return Date (B3) and then multiply the result by the Rental Car per   Day value (F3).

Depending on the city, you will   either take a shuttle to/from the airport or rent a car. Your next task is to   enter the cost of the shuttle or rental car in the dataset using a logical   function.
 

  Click cell E14. Insert an IF function that compares to see if Yes or No is   located in the Rental Car? column for a city. If the cell contains No, display the shuttle value in   cell F2. If the cell contains Yes, display the value in the Rental Car Total   (cell F4). Copy the function from cell E14. Use the Paste Formulas option to   copy the function to the range E15:E19 without removing the border in cell   E19.

Next, you will enter a formula   to calculate the lodging. The lodging is based on a multiplier by City Type.   Some cities are more expensive than others. You coded cities 1, 2, 3, or 4   and a percentage of cost.
 

  Click cell F14. Insert a VLOOKUP function that looks up the City Type (cell   B14), compares it to the City/COL range (A8:B11), and returns the COL   percentage. Then multiply the result of the lookup function by the Total Base   Lodging (cell B6) to get the estimated lodging for the first city. Copy the   function from cell F14 and use the Paste Formulas option to copy the function   to the range F15:F19 without removing the border in cell F19.

You are now ready to calculate   the total expenses for each city.
 

  Click cell H14 and enter the function that calculates the total costs for the   first city, including airfare, shuttle or rental, lodging, and meals. Copy   the function in cell H14 and use the Paste Formulas option to copy the   function to the range H15:H19 without removing the border in cell H19.

You are considering taking out a   one-year (12 month) loan to pay for your vacation.
 

  In cell I14, insert the PMT function. Divide the APR (cell I7) by the number   of months in a year (cell I8). The   term is one year (12 months). Use a cell reference. The Total Cost for the   city is the present value. Use relative and mixed (or absolute) references   correctly. Make sure the result is a positive value. Copy the function from   cell I14 to the range I15:I19 and maintain the original border formatting.

You decide to format the values   in the dataset.
 

  Select the range E15:I19 and apply Comma Style with zero decimal places.   Select the range E14:I14 and apply Accounting Number format with zero decimal   places.

The Summary Trip Costs section   is designed to display average, lowest, and highest costs.
 

  In cell I2, enter a function that will calculate the average total cost per   city. In cell I3, enter a function that will identify the lowest total cost.   In cell I4 enter a function that will return the highest total cost.

The Lookup section (range D7:F8)   is designed to enable you to enter a city in cell D8 and return the   corresponding total cost for that vacation.
 

  In cell F8, insert the XLOOKUP function that looks up the city in cell D8,   compares it to the Destination City range and returns the applicable Total Cost. Use appropriate ranges. Enter Boston in cell D8 to make sure the function returns   the correct value.

On the Cities worksheet, select   Landscape orientation, set a 1″ top margin, and center the worksheet   data horizontally on the page.

Save and close Exp22_Excel_AppCapstone_IntroAssessment_Travel.xlsx.   Exit Excel. Submit the file as directed.

 COMPANY DETAILS

Company Description (Tech Lopes)

Tech Lopes delivers expert level IT support. We handle both software and hardware issues, as well as general maintenance and IT consultation. We have IT experts ready to provide assistance and results on data recovery, hardware repair, virus removal, and general IT support. We work with all brands of computers, smartphones and tablets in relation to both hardware and software.

Mission: 

Our mission is to provide fast, expert level IT Support and educate our customers on simple IT solutions.

Vision:

Our vision is to become the most reliable IT Support Company for consumers, and small businesses. 

Target Market

• Small to Medium Local Business
  • Newly established
• Highschool / College Students
• Elderly Personale

QUESTION

Use the following outline to describe your industry and competitive advantage. For each section use the heading provided and address each bulleted point.

Introduction

· Identify your audience and explain what a competitive advantage is and why it is essential for your organization. Outline what this document will cover.

Industry Analysis

· Conduct an analysis to ensure the market size of your industry is growing (if not, you might want to diversify) and to help identify new opportunities for growth.

SWOT Analysis

· Construct a graphical SWOT diagram and detail each point briefly.

Competitive Analysis

· Identify who your key competitors are. List their strengths and weaknesses.

Competitive Advantage

· Determine your current competitive advantages and ways to develop additional advantages. What makes your business competitive? What makes your business stand out from what your competitors offer?

· What risks are associated with this competitive advantage? 

· Is this competitive advantage sustainable? Why or why not?

Explain your thoughts on the future of IoT and the security implications. Why do you believe it is important to secure these devices as they become more common in our lives and our businesses? Need this in a word document with no less than 350 words in APA format with 2 references & Citations.

Write 8 page network plan for  “A dual location medical clinic with doctors/physician’s assistants rotating between locations on different days”.

In this assignment, you will develop a deep learning system for the classification of images containing decimal digits into three categories:

1. A-digit 0
2. B-digit 1
3. C-others (e.g. any digit in 2,3,4,5,6,7,8,9)

For this purpose, you will use the MNIST dataset. (Download Here) (Links to an external site.) 

You will develop your solution within a transfer learning paradigm. Rather the designing and training a deep learning system from the scratch, you can use the Internet to find solutions to start from and/or augment. (HINT: There are many models in Python that can be found online to solve this problem.)

Tasks:

1. Download and arrange a subset of the MNIST data in the three categories above, performing the proper partition into training, validation and testing
2. Design, train, validate and test a model
3. Compare and interpret the performance of each model (accuracy, behavior of the validation versus training, etc).

Note: Ensure you explain the rational and the methodology for tasks 1 and 2.

This is meant to be fun, challenging, and a stretch assignment.  Effort is what matters, not the perfect solution!!!

 In the second milestone writing assignment, you will analyze asymmetric and symmetric encryption. Evaluate the differences between the two of them and which one that you would determine is the most secure. At first glance, the key wrapping approach to encrypting symmetric keys for key management applications seems unnecessarily elaborate. The alternative would be a simple encryption using AES or an authenticated encryption using one of the block cipher modes of operation that provides authenticated encryption. Discuss the relative merits of using one of these approaches compared to key wrapping.The writing assignment requires a minimum of 800 words.You must use a minimum of three scholarly articles to complete the assignment.  The assignment must be properly APA formatted with a separate title and reference page. 

Describe in 500 words discuss the scope of a cloud computing audit for your business.

Use at least three sources. not Google. Include at least 3 quotes from your sources enclosed in quotation marks and cited in-line by reference to your reference list.  These quotes should be one full sentence not altered or paraphrased. Cite your sources using APA format. Use the quotes in your paragaphs.  Stand alone quotes will not count toward the 3 required quotes.

Copying without attribution or the use of spinbot or other word substitution software will result in a grade of 0. 

Assignment:
Provide a reflection of at least 500 words (or 2 pages double spaced) of how the knowledge, skills, or theories of this course have been applied, or could be applied, in a practical manner to your current work environment. If you are not currently working, share times when you have or could observe these theories and knowledge could be applied to an employment opportunity in your field of study. 

Requirements:

• Provide a 500 word (or 2 pages double spaced) minimum reflection.• Use of proper APA formatting and citations. If supporting evidence from outside resources is used those must be properly cited.• Share a personal connection that identifies specific knowledge and theories from this course.• Demonstrate a connection to your current work environment. If you are not employed, demonstrate a connection to your desired work environment. • You should not provide an overview of the assignments assigned in the course. The assignment asks that you reflect how the knowledge and skills obtained through meeting course objectives were applied or could be applied in the workplace.

This is an individual assignment.

Title: Interaction Design

ISBN: 9780470665763

Authors: Yvonne Rogers, Helen Sharp, Jenny Preece

Publisher: John Wiley & Sons

Publication Date: 2011-06-07

Need help with this Python Project