#Exp19_PowerPoint_Ch02_CapAssessment_Food  

#Exp19 PowerPoint Ch02 CapAssessment Food

Project Description:

Your school’s Culinary Club is raising money for the local food bank. You volunteer to create a slide show that will be shown at a potluck fundraiser put on by the club. In this activity, you will create a presentation that meets slide show design principles, and has shapes, animation, video, and audio.

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

#Replace Student Name in the subtitle placeholder on Slide 1 with Carl Patterson Change the title font size to 54.

#Click Slide 2. Change the title font size to 48. Change the subtitle font size to 32.

#Click Slide 3. Change the title to sentence case. Change the title font size to 54. Change the bulleted text to 32

#Click Slide 4. Change the title font size to 48. Change the bulleted text to 32.

#Click Slide 5. Change the title font size to 48. Change the subtitle font to 27.

#Click Slide 4 and insert a heart shape. Size it to a height of 2.5” and a width of 2.75” . Apply Colored Fill – Red, Accent 1, Darker 25%. Apply a shape outline in Black, Text 1. Apply Preset 2 as a shape effect. Position the shape horizontally at 10.35” from the Top Left Corner. Position the shape vertically at 4.9” from the Top Left Corner.

#Click Slide 2. Select the subtitle text and add the Zoom Entrance animation. Click After Previous in the Start box. Adjust the Duration to 01.75 and the Delay to 00.50.

#Click Slide 3. Select the first text bullet and apply the Fade Entrance effect. Set the animation to start After Previous with a Duration of 02.00 and a Delay of 01.75. Click the Animation Pane, and then click the arrow for the first bullet. Select Effect Options to access the Fade dialog box. Set the After Animation to Orange (sixth from the left) on the Effect tab.

#Select the second text bullet and apply the Fade Entrance effect. Set the animation to start After Previous with a Duration of 02.00 and a Delay of 01.75. Click the arrow for the second bullet in the Animation Pane. Select Effect Options to access the Fade dialog box. Set the After Animation to Orange (sixth from the left) on the Effect tab.

#Select the third text bullet and apply the Fade Entrance effect. Set the animation to start After Previous with a Duration of 02.00 and a Delay of 01.75. Click the arrow for the last bullet in the Animation Pane. Select Effect Options to access the Fade dialog box. Set the After Animation to Orange (sixth from the left) on the Effect tab.

#Click Slide 4 and select the heart shape. On the Animations tab, in the Animations group, click More and add the Pulse Emphasis effect. Set the animation to start After Previous with a Duration of 02.00 and a Delay of 0.25. Click the arrow for the shape in the Animation Pane. Select Timing and set Repeat to Until End of Slide and click OK.

#Click Slide 1 and add the Fade transition. Set the Duration at 01.00. Set the slides to advance automatically after 00:07.00. Set it to apply to all.

#Click Slide 5. Insert the downloaded video file Veggies.mp4. 

#Apply the Rounded Diagonal Corner, White moderate video style.

#Set the video to start Automatically. Change the Video Options to Hide While Not Playing and to Rewind after Playing. Compress the media in the presentation using the Standard setting. Mac users, compress all pictures in the presentation using the On-screen setting.

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

Click–> Aggressive Sales Quotas or Unfair Business Practice? and complete the questions at the end of the case study.

Check the attachments

Review the material on routers.

It is sometimes said that information extracted from a router or switch does not necessarily provide specific evidence of a particular crime. What is meant by that?  If true, what then is the most useful information collected from these devices in an investigation?

Many organizations use password-based authentication to authenticate their users. Passwords that do not meet the criteria can be placed in a vulnerable state. Hackers can use password crackers to guess the passwords and infiltrate systems.

NIST Cyber Security Frameworks

When a company is looking for potential vendors/suppliers for a project, what would be the impact if the company asked vendors submitting proposals to provide information about their cybersecurity framework profile? How would that affect the supplier-customer relationship?

1. Solve the following linear programming problem graphically:
maximize 2X1 3X2
subject to X1 8
X2 6
X1 2X2 16
X1
, X2 0
Units of L per period 

2. In problem 1, how would the optimal solution change if the restrictions imposed (i.e.,
the ri’s) were all cut in half? 

3. Solve the following linear programming problem using the general solution method:
minimize C 3X1 4X2
subject to X1 X2 2
2X1 4X2 5
X1
, X2 0 

4. The advertising manager at Cadillac wishes to run both television and magazine ads to
promote the new Cadillac GTS in the greater Chicago area market. Each 30-second television ad will reach 30,000 viewers in the target age group of buyers 35 to 55 years old.
Running one full page ad in Cool Driver magazine will reach 10,000 readers in the 35 to 55
year-old target market. To further promote the new GTS, the manager wishes to stimulate
prospective buyers to come in to Chicago area dealerships to test drive the GTS. Past
experience in Chicago indicates that a television ad will generate 500 test dri- ves, while a
magazine ad will generate only 250 test drives.
In order to reach the desired level of new-model penetration in the Chicago area, the
advertising manager believes it is necessary to reach at least 90,000 potential buyers in the 35
to 55 age bracket and to get at least 2,000 of these potential buyers to take a test drive. Each
30- second TV ad costs $100,000 and each magazine ad costs $40,000. In reaching these
objectives, the manager wishes to minimize the total expenditure on TV and magazine ads.
a. State the linear programming problem facing this advertising manager. Be sure to
formulate the objective function and inequality constraints (including appropriate nonnegativity constraints).
b. Solve the linear programming problem. What is the optimal number of TV ads and
magazine ads? What will be the minimum possible level of total expenditures on
television and magazine ads necessary to successfully promote the GTS in Chicago?
c. Suppose the local television stations, in order to reduce set-up costs, require Cadillac
to run its ad two or more times. How would this constraint alter the solution to this
linear programming problem?

5. Form the dual to the linear programming problem presented in problem 3; then solve
it to obtain the optimal value of C . Does the minimum value of C for the primal in
Problem 3 equal the maximum value of C in the dual for this problem? 

Independent Project 2-4

Windows   Mac

Central Sierra Insurance (CSI) sets bonus percentages based on commissions earned by each agent and calculates totals by branch office. This workbook also tracks fundraising efforts of employees for a community event.

[Student Learning Outcomes 2.1, 2.2, 2.3, 2.5, 2.6, 2.7]

File Needed: CentralSierra-02.xlsx (Available from the Start File link.)

Completed Project File Name: [your name]-CentralSierra-02.xlsx

Skills Covered in This Project

• Create, copy, and edit formulas.
• Name cell ranges.
• Set mathematical order of operations.
• Set cell references to be absolute.
• Use the NOW function.
• Use HLOOKUP and VLOOKUP
• Use the SUMIF function.
• Build an IF function.

1. Open the start file CentralSierra-02.xlsx workbook. If the workbook opens in Protected View, click the Enable Editing button so you can modify it. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.
2. Select the Tables sheet, select cells A6:B10, and create range names using the Create from Selection button [Formulas tab, Defined Names group].
3. Select cells B1:F2 and click the Name box. Name the selection H_Rates. Note that the first row is arranged in ascending order.
4. Create an HLOOKUP function to display the bonus rate.
   1. Click the Commissions sheet tab and select cell F5.
   2. Start the HLOOKUP function and use cell E5 as the lookup_value.
   3. For the table_array argument, use the H_Rates range.
   4. Use the second row for the row_index_num argument (Figure 2-100).Figure 2-100 HLOOKUP function to display bonus
5. Format the results as Percent Style with two decimal places.
6. Copy the formula in cell F5 to cells F6:F14.
7. Set order of operations to calculate total earnings.
   1. Select cell G5.
   2. Build a formula to add the commissions amount (E5) to the commissions amount times the rate (F5*E5).
   3. Copy the formula in cell G5 to cells G6:G14.
8. Create and copy a SUMIF function to calculate total earnings by branch office.
   1. Select cell E18.
   2. Start the SUMIF function with cells $D$5:$D$14 as the Range argument.
   3. Set the Criteria argument as a relative reference to cell C18.
   4. Select cells G5:G14 for the Sum_range argument and make the references absolute.
   5. Copy the formula in cell E18 to cells E19:E20 without formatting to preserve borders.
   6. Format cells E18:E21 as Currency.
9. Total the earnings in cell E21.
10. Create and format the current date.
    1. Select cell G23 and insert the NOW function.
    2. Select cell G23 and click the Number group launcher [Home tab]. On the Number tab, select the Date category.
    3. Scroll the Type list to find the date that displays the month spelled out, the date, a comma, and a four-digit year (Figure 2-101).Figure 2-101 Date format selected
    4. Click OK. Press Ctrl+Home.
11. Create and copy a VLOOKUP function to display goals for each funding source.
    1. Click the Family Day sheet tab and select cell F6.
    2. Start the VLOOKUP function and use cell E6 as the lookup_value.
    3. Click the Tables sheet tab for the table_array argument and use cells $A$6:$B$10. The data is sorted by the first column in ascending order.
    4. Use the second column as the col_index_num The range_lookup argument is empty.
    5. Copy the formula in cell F6 to cells F7:F20 without formatting to preserve the fill color.
    6. Format cells F6:F20 as Currency with no decimal places.
12. Create and copy an IF function.
    1. Select cell H6 and start an IF
    2. Type a logical_argument to determine if cell G6 is greater than or equal to (>=) cell F6.
    3. Type Yes as the Value_if_true argument and No as the Value_if_false argument.
    4. Copy the formula in cell H6 to cells H7:H20 without formatting to maintain the fill color.
    5. Center align cells H6:H20.
    6. Press Ctrl+Home.
13. Insert a new sheet at the end of the tab names and paste the range names starting in cell A1. AutoFit columns A:B and name the worksheet as Range Names.
14. Save and close the workbook (Figure 2-102).Figure 2-102 Excel 2-4 completed
15. Upload and save your project file.
16. Submit project for grading.

Please check the image

 Need to present a research reports on 

1. Machine learning method

2. User Behaviour Analytics (UBA)

 Both reports should be written with a word count of 70-105 words(not more than the count provided) and should provide a URL reference link too . 

Note : NO PLAGIARISM 

Should have minimum of 3 statements which describes the information about the report.

Tips: Should be in simple own words and no usage of critical words and attached the file to know in detail to write on it. This question is from a cyber security subject so that the matter should relate to cyber security for sure and should connect to readers.

Deadline Sep10, 2022 12:00Pm.Cst