There are various languages, some are better for data visualization than others.  Please review the basics of Python, SAS, R, and SQL.  What are the qualities of each language regarding data visualization (select at least two to compare and contrast)?  What are the pros and cons of each regarding data visualization (select at least two to compare and contrast)?

The project must be a presentation of 15 slides and final paper that is 5 pages (double-spaced) on a cybersecurity topic with APA citations.

Following are the topics:

 Network Access Control and Cloud Security 

 Transport-Level Security 

 Wireless Network Security 

IP Security

Key Distribution and User Authentication

 Exp19_Excel_Ch09_CapAssessment_Tips 

 Exp19 Excel Ch09 CapAssessment Tips 

 Excel Chapter 9 Capstone Assessment – Tips 

Project Description:

Your friend Kimo is a server at a restaurant. He downloaded data for his customers’ food and beverage purchases for the week. You will complete the workbook by applying consistent formatting across the worksheets and finalizing the weekly summary. The restaurant requires tip sharing, so you will calculate how much he will share with the beverage worker and the assistant.

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

  The Excel workbook contains circular references. When you open the file, an   error message displays. This error will be resolved as part of the project

The Tip Left column in the   Friday worksheet contains a fill color and number formatting. You want to   fill these formats to the other daily worksheets.
 

  Group the Friday through Monday worksheets, staring with the Friday   worksheet. Fill the format only for the range E5:E24.

Now you want to insert column   totals for the five worksheets simultaneously.
 

  With the worksheets still grouped, insert SUM functions in the range B25:E25   and apply the Totals cell style. Ungroup the worksheets.

The Week worksheet is designed   to be a summary sheet. You want to insert a hyperlink to the Total heading in   the Monday worksheet.
 

  On the Week worksheet, in cell A5, insert a hyperlink to cell A25 in the   Monday worksheet with the ScreenTip text Monday’s Totals. Test the hyperlink to ensure   it works correctly.

In cell A6 on the Week   worksheet, insert a hyperlink to cell A25 in the Tuesday worksheet with the   ScreenTip text Tuesday’s Totals. Test the hyperlink to ensure it works correctly.

In cell A7, insert a hyperlink   to cell A25 in the Wednesday worksheet with the ScreenTip text Wednesday’s   Totals. Test   the hyperlink to ensure it works correctly.

In cell A8, insert a hyperlink   to cell A25 in the Thursday worksheet with the ScreenTip text Thursday’s   Totals. Test   the hyperlink to ensure it works correctly.

In cell A9, insert a hyperlink   to cell A25 in the Friday worksheet with the ScreenTip text Friday’s   Totals. Test   the hyperlink to ensure it works correctly.

Now, you are ready to insert   references to cells in the individual worksheets. First, you will insert a   reference to Monday’s Food Total.
 

  In cell B5 on the Week worksheet, insert a formula with a 3-D reference to   cell B25 in the Monday worksheet. Copy the formula to the range C5:E5.

The next formula will display   the totals for Tuesday.
 

  In cell B6, insert a formula with a 3-D reference to cell B25 in the Tuesday   worksheet. Copy the formula to the range C6:E6.

In cell B7, insert a formula   with a 3-D reference to cell B25 in the Wednesday worksheet. Copy the formula   to the range C7:E7.

In cell B8, insert a formula   with a 3-D reference to cell B25 in the Thursday worksheet. Copy the formula   to the range C8:E8.

In cell B9, insert a formula   with a 3-D reference to cell B25 in the Friday worksheet. Copy the formula to   the range C9:E9.

Now you want to use a function   with a 3-D reference to calculate the totals.
 

  In cell B10 on the Week worksheet, insert the SUM function with a 3-D   reference to calculate the total Food purchases (cell B25) for the five days.   Copy the function to the range C10:E10.

The servers are required to   share a portion of their tips with the Beverage Worker and Assistants. The   rates are stored in another file.
 

  Open the Exp_Excel_Ch09_Cap_Assessment_Rates.xlsx   workbook. Go back to the Exp_Excel_Ch09_Cap_Assessment_Tips.xlsx   workbook. In cell F5 of the Week worksheet, insert a link to the Beverage   Worker Tip Rate (cell C4 in the Rates workbook) and multiply the rate by the   Monday Drinks (cell C5). Copy the formula to the range F6:F9.

Next, you will calculate the   tips for the assistant.
 

  In cell G5 in the Tips workbook, insert a link to the Assistant Tip Rate   (cell C5 in the Rates workbook) and multiply the rate by the Monday Subtotal   (cell D5). Copy the formula to the range G6:G9. Close the Rates workbook.
 

  Note: The tip is a monetary value in the Week worksheet. It should be   formatted for Accounting Number Format.

You noticed a circular error   when you first opened the Tips workbook. Now you will find and correct it.
 

  On the Week worksheet, check for errors and correct the formula with the   circular reference. 

You want to create a validation   rule to prevent the user from accidentally entering a negative value. For   now, you will create a validation in the Friday worksheet.
 

  Select the range E5:E24 in the Friday worksheet, create a validation rule to   allow a decimal value greater than or equal to zero. Enter the input message   title Tip   and the input   message Enter the amount of tip. (including the period). Use the Stop alert with   the error alert title Invalid Number and the error alert message The tip must   be zero or more.   (including the period). Test the data validation by attempting to enter -20 in cell E5 and then cancel the   change.

Now you will copy the validation   settings to the other daily worksheets.
 

  Copy the range E5:E24 in the Friday worksheet. Group the Monday through   Thursday worksheets, select the range E5:E24, and use Paste Special   Validation to copy the validation settings.

You want to unlock data-entry   cells so that the user can change the tips in the daily worksheets.
 

  Group the Monday through Friday worksheets. Select the ranges E5:E24 and   unlock these cells.

Create footer with your name on   the left side, the sheet name code in the center, and the file name code on   the right side of all worksheets.

Now that you unlocked data-entry   cells, you are ready to protect the worksheets to prevent users from changing   data in other cells. Individually, protect each sheet using the default   allowances without a password.

Mark the workbook as final.
 

  Note: Mark as Final is not available in Excel for Mac. Instead, use Always   Open Read-Only on the Review tab.

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

Workbook assignments. All assignments are compiled in the provided document. 

Additional files are in a zip that I will provide seperately.

Please read the document before replying.

Exp19_PowerPoint_Ch02_HOEAssessment_Wedding

Exp19 PowerPoint Ch02 HOEAssessment Wedding

PowerPoint_Chapter_2_Hands_On_Exercise_Assessment_Wedding  

Project Description:

You are asked to develop a presentation that will be used to promote La Belle Fleurs, a wedding planning service. Potential clients include prospective brides, grooms, and their families. Using accepted design principles, the presentation is developed to include shapes, animation, transitions, and video.

Start PowerPoint.   Download and open the file named Exp19_PPT_Ch02_HOEAssessment_Wedding.pptx.   Grader has automatically added your last name to the beginning of the   filename.

Replace Student Name on Slide 1 with Mary   Albert.   Change the title font to Arial.

Contrast is one of   the main design principles used in a presentation to direct focus and aid in   readability. You adjust the formatting of the font used in the presentation   so there is better contrast.
 

  Click Slide 2, select the title, and change the font to Arial. Change the   size to 72. Change the Font color to Brown, Text 1, Lighter   10%. Double-click the Format Painter button. Apply the   formatting to the titles for Slide 3 through Slide 7. Press ESC.

You begin to prepare   for adding objects that will enhance the presentation’s message to some of   the slides by deleting a couple of placeholders. These will not be needed   once the objects are added. You also adjust the formatting of the font on the   slides.
 

  Click Slide 3 and select the left content placeholder border. Change the Font   color to Brown, Text 1. Repeat for Slide 5. Delete the image on Slide 5.

This slide is   enhanced by using the alignment design principle to bring the email address   closer to the phrase Contact us.   The font formatting should be adjusted as well.
 

  Click Slide 7. Select the email address   and then click Align Right in the Paragraph group. Select Contact us at: and change the size to   44. Change the Font color to Brown, Text 1.

You add a heart shape   to enhance the message of the slide. Then the heart will be filled with a   picture of a wedding cake. Some additional text will be added to the slide to   finish the message.
 

  Click Slide 5 and delete the right content placeholder. Click the Insert tab.   Click Shapes in the Illustration group. Click the Heart in the Basic Shapes   group and then click in the right side of the slide.

Size the heart to a   height of 5.5” and a width of 5.5”. Position it Horizontally at 7.45” from Top Left corner   and Vertically 1.75” from Top Left Corner. Click   Shape Fill in the Shape Styles group, and then click Picture. Click From a File and   navigate to where you have your files stored. Click Cake.jpg and click Insert.
 

  Click Compress Pictures in the Adjust group on the Picture Format tab. In the   Compress Pictures dialog box, with Use default resolution selected, click OK.   

Begin a new paragraph   beneath the current paragraph and type For you to choose in the left Content   placeholder on Slide 5.

Animation is added to   the email address to emphasize it.
 

  Click Slide 7, select the email address, and then click the Animations tab.   Click More in the Animation group and then click Random Bars in the Entrance   category.

Select the email   address again and click Add Animation in the Advanced Animation group. Click   Bold Reveal in the Emphasis category.

Animation is added to   the new phrase on this slide to control how it appears on the slide. This   helps to focus how the audience receives the message of the slide.
 

  Click Slide 5 and select For you to   choose. Click More on the Animations tab and then click More Entrance   Effects. Click Expand in the Subtle category. Click OK.

You continue to add   and adjust animations used on several slides in the presentation. The goal is   to add interest to the presentation and keep the audience’s attention on the   slides.
 

  Click Slide 2 and select the text in the content placeholder. On the   Animations tab, in the Animation group, click More, and then click More   Entrance Effects. Click Fade in the Subtle category. Click OK. Change the   Font color to Brown, Text 1.

Select the content   placeholder on Slide 2. Click the Effect Options Dialog Box Launcher to   display the Fade dialog box. Click the Animate text arrow and click By word.

Click the Timing tab.   Click the Start arrow and then click After Previous. Set the Delay to 0.75   seconds   and the Duration to 2 seconds (Medium). Click OK. 

Click Slide 5 and   select the phrase For you to choose.   Set the Start to After Previous. Click the Delay arrow in the Timing group to   reach 00.75.

Click Slide 7 and then click the   content placeholder. Click the Animations tab. Click Animation Pane in the Advanced   Animation group. Click the second Exploring2019 arrow (for Bold Reveal   Emphasis). Click Start After Previous.

Click Slide 6. Drag the right edge   of the third timeline bar in the Animation Pane to the left until the   ScreenTip displays End: 8.4s. Drag the right edge of the fourth timeline bar   the left until the ScreenTip displays End: 11.4s.
 

  Note, Mac users, set the duration of the Fade animation for the third hexagon   to 5.4 seconds, and the duration for the fourth hexagon to 3 seconds.

Click Slide 2 and   click the content placeholder. Adjust the Delay arrow to 01.00.

You apply a   transition to all the slides in the presentation to create visual interest   and re-focus the audience attention as each new slide displays during the   presentation.
 

  Click the Transitions tab and click More in the Transition to This Slide   group. Click Push under Subtle. Click Apply to All in the Timing group.

Select the Slide 1   thumbnail, click the Effect Options arrow in the Transitions to This Slide   group, and then select From Left. Click On Mouse Click in the Timing group to   deselect it. Click After and set it to 00:02.00. Click Apply to All.

Video engages the   audience’s emotions and helps to reinforce the message of your presentation.   This helps the audience remember the message of the presentation, so you add   one on this slide.
 

  Select Slide 3. Click the right content placeholder. Click the Insert Video   icon. Navigate to where you have your file stored and insert the Violins.mp4 video.

You use the Playback   and Format tabs to adjust the video’s properties.
 

  Click Move Forward 0.25 Seconds on the Media Controls bar located beneath the   video to advance the video to the frame at 1.50 seconds. Click the Poster   Frame in the Adjust group on the Format tab, and then click Current Frame.

Click Video Shape in   the Video Styles group and click Hexagon in the Basic Shapes category. Click   Video Effects, point to Shadow, and then click Perspective: Lower Left in the Perspective   category.

Select the video   object, click the Playback tab, and then click Trim Video in the Editing   group. Drag the red End Time marker on the slider until 00:03.000 displays in   the End Time box. Click OK. Click the Start arrow in the Video Options group   and select Automatically. Click the Loop until Stopped check box in the Video   Options group to select it.
 

  Note, Mac users, skip the instruction to trim the video, however, set the   other options.

You check the   presentation to make sure all of the changes you have made work as you   designed them to work. Then you compress the media to reduce the overall file   size of the presentation.
 

  Click the Slide Show tab and click From Beginning in the Start Slide Show   group. Press ESC. Click the File tab, and then click Compress Media. Select   Standard (480p).

Save and close Exp_PPT_Ch02_HOEAssessment_Wedding_solution.pptx.   Exit PowerPoint. Submit the file as directed.

NOTE: **** post answers in separate documents for each Question

      **** Please follow the instructions to the point and pick relavant topics according to the subject

      **** Follow APA7 format

S

refer to the attached document.

In the analysis phase the teams need to:

1. Requirements Determination: All the requirements for the new system needs to be defined in this document
2. Data Flow Diagrams
3. Use Case Diagrams
4. Activity Diagram
5. Class Diagrams

More Info on the company you will be working on is below:

Project objective –

Develop a business intelligence dashboard to be used by the Analytics and Marketing departments to conveniently analyze data and present key insights in an easy-to-use and intuitive manner.

Justification for the project –

This project attempts to solve operational problems encountered by data analytics professionals at Swift Trade Corp. The business intelligence dashboard will facilitate the process of presenting data and other important business metrics important to the company’s performance.

a math problem that need very simple code on Julia. 

a summerization of 15 papers about data mining techniques and covid-19. with presentation.