Word protect 

#Kader_Excel_3G_Administration_as

#Excel_3G_Department_Expenses_AS

Project Description:

In the following project, you will edit a worksheet that will be used to summarize the departmental administration expenses for the City of Orange Blossom Beach.

Open   the Excel workbook Student_Excel_3G_Administration_as.xlsx   downloaded with   this project.

In the Expenses worksheet, use   the SUM function to calculate row totals for each Expense item in the range   F5:F9. Format F6:F9 with Comma Style, zero decimal places. Calculate column   totals (using SUM) for each quarter and for the Annual Total in the range   B10:F10.

In cell G5, construct a formula   to calculate the Percent of Total by dividing the Annual Total for City   Manager by the Annual Total for Totals by Quarter. Use absolute cell   references as necessary, format the result in Percent Style, and then Center.   Fill the formula down through cell G9.

Create a 3-D Pie chart to chart   the Annual Total for each item using the ranges A5:A9 and F5:F9. Move the   chart to a new sheet and then name the sheet Administration Costs Chart.

For the chart title, type Summary of   Administration Costs   and format the chart title using a WordArt Style—in the first row, the second   style. Change the chart title font size to 28.

Remove the Legend from the chart   and then add Data Labels formatted so that only the Category Name and   Percentage display positioned in the Center. Change the data labels Font Size   to 12, and apply Bold and Italic.

Format the Data Series using a   3-D Format effect. Change the Top bevel and Bottom bevel to the first bevel   in the first row. Set the Top bevel Width and Height to 50 pt and then set the Bottom   bevel Width and Height to 256 pt. Change the Material to the fourth Standard Effect—Metal.

Display the Series Options, and   then set the Angle of first slice to 140 so that the City Manager slice is in   the front of the pie. Select the City Manager slice, and then explode the   slice 10%. Change the Fill Color of the City Manager slice to a Solid fill—in   the fifth column, the fourth color.

Format the Chart Area by   applying a Gradient fill using the Preset gradients–in the fourth column,   the first color. Format the Border of the Chart Area by adding a Solid line   border–in the eighth column, the first color. Change the border Width to 5   pt.

Display the Page Setup dialog   box, and then for this chart sheet, insert a custom footer in the left   section with the File Name element.

Display the Expenses worksheet,   and then by using the Quarter names and the Totals by Quarter, insert a Line   with Markers chart in the worksheet. Move the chart so that its upper left   corner is positioned slightly inside the upper left corner of cell B12. Type Annual   Administration Expenses by Quarter as the Chart Title.

Format the Bounds of the   Vertical (Value) Axis so that the Minimum is 1085000 and the Major unit is at 10000. Format the Fill of the Chart   Area with a Gradient fill by applying the Preset gradient—in the first row,   the third gradient. Format the Plot Area with a Solid fill using White,   Background 1—in the first column, the first color.

Copy the Annual Total in cell   F10 and then use Paste Special to paste Values & Number Formatting in   cell B35. In cell C35, construct a formula to calculate the Projected   Expenses after the forecasted increase of 3.5% in cell B31 is applied. Fill   the formula through cell F35, and then use Format Painter to copy the   formatting from cell B35 to the range C35:F35.

Change the Orientation of this   worksheet to Landscape, and then use the Scale to Fit options to fit the   Height to 1 page. From the Page Setup dialog box, center the worksheet   Horizontally, and insert a custom footer in the left section with the File   Name element.

Display the Contracts worksheet.   Using the data in A5:B7, insert a Funnel Chart. Move the chart so that the   upper left corner aligns with the upper left corner of D1. Change the chart   title to Contract Analysis and then change the Height to 2 and the Width to 4. Make cell A1   the active cell. Change the Orientation to Landscape, center the worksheet,   and insert a footer with the file name in the left section.

Display the County Partnerships   worksheet. Select the range A4:B8 and then insert a Filled Map chart map.   Change the Width to 4 and then move the chart so that its upper left corner   aligns with the upper left corner of D1. For the chart title, type Partnership   Analysis and   then make cell A1 the active cell. Change the worksheet Orientation to   Landscape. From the Page Setup dialog box, center this worksheet   Horizontally, and insert a custom footer in the left section with the File   Name element.

  Ping Pong Game App.  A retro ping pong game, Comp. vs. user, similar to http://www.twoplayergames.org/play/1003-Retro_Pong.html in Sprite kit. Two view, main and setting. Audio visual component is required, i.e., appropriate sound and appropriate  visual presentation. A scoreboard is maintained. In setting side, ask user which ball to select (different color), what is the speed of the ball, size of paddles, etc. 

#1. I  would like for you to write me a two-page document this week with at least three resources other than your book which discusses the natural and human process we all go through daily in managing risks in our daily lives. I want you to draw direct correlation between the processes we go through mentally to avoid risks which could harm us and the risk processes organizations go through in dealing with risk relative to a project. How do they differ – how are they the same?  Give me some examples of behaviors you engage in with your daily life to avoid personal risk. 

Requirements:

• There is no minimum or maximum required number of pages. Your response will be considered complete, if it addresses each of the components outlined above.
• Use of proper APA formatting and citations – If supporting evidence from outside resources is used those must be properly cited. A minimum of 7 sources (excluding the course textbook) from scholarly articles or business periodicals is required.
• Include your best critical thinking and analysis to arrive at your justification.

Text

Title: Managing Project Risks ISBN: 9781119489733 Authors: Peter J. Edwards, Paulo Vaz Serra, Michael Edwards Publisher: John Wiley & Sons Publication Date: 2019-08-13

This week’s discussion board has 2 parts, complete both parts.

Click on the link below to see an example of calculating opportunity cost. 

Opportunity cost arises when you have scarce resources and you are forced to make a choice amongst various competing alternatives. In the example, the scarce resource is time so the individual has to choose between the 2 jobs.  

Formulate your own example that shows what opportunity cost is and go ahead and calculate your opportunity cost. 

In your example state what your scarce resource is and show what was the next best alternative then calculate the opportunity cost. 

Hint: opportunity cost arises in numerous decisions that we make including; going to college, going for a doctors appointment, making a purchase (like buying a car or anything else) etc.  

How to calculate the opportunity cost

Part 2

Watch the video below and briefly share what are some of your own misconceptions of economics and what do you know now about economics that you did not know before

What is economics?

Exp22_Excel_Ch03_ML1_Airports

Exp22 Excel Ch03 ML1 Airports

Excel Chapter 3 Mid-Level 1 – Airport Passenger Counts  

Project Description:

As an analyst for the airline industry, you track the number of passengers at the top six major U.S. airports: Atlanta (ATL), Chicago (ORD), Los Angeles (LAX), Dallas/Fort Worth (DFW), Denver (DEN), and New York (JFK). You researched passenger data and created a worksheet that lists the number of total yearly passengers. You will create a clustered column chart to compare the number of passengers at each airport. Then, you will create a line chart that compares trends over time. Next, you will create a bar chart to compare the passenger count for the latest year of data available and emphasize the airport with the largest number of passenger traffic. Finally, you will insert sparklines to visually represent trends in passengers at each airport over the ten-year period.

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

You want to create a clustered   column chart to depict the passenger counts at the six airports over several   years.
 

  Create a clustered column chart for the range A4:L10. Cut the chart and paste   it in cell A15.

You want to customize the column   chart with a chart title, display the years as a data series, enlarge the   chart to be easier to read, and apply a chart style.
 

  •Type Passengers   Counts at Top U.S. Airports as the chart title.
  •Swap the data on the category axis and in the legend.
  •Set a 3.5″ height and 11.4″ width.
  •Apply the Style 7 chart style.

The value axis takes up a lot of   space for the numbers. You will adjust the value axis to simplify it.
 

  •Change the display units to Millions for the value axis.
  •Edit the axis title to display Millions of Passengers.

You want to focus on the 2019 data   series by adding data labels.
 

  Display data labels above the columns (Outside End position) for the 2019   data series only.

Applying a fill color to the   chart area will make the chart visually appealing.
 

  Apply the Light Gradient – Accent 1 gradient fill to the chart area.

A best practice is to add Alt   Text to a chart for accessibility compliance.
 

  Add Alt Text: The column chart displays the number of passengers. (including the period).

You want to create a bar chart   to display passenger counts for only one year.
 

  Create a clustered bar chart for the range A5:A10 and L5:L10 and move the   chart to a chart sheet named Bar Chart.

You want to customize the bar   chart.
 

  •Change the chart color to Monochromatic Palette 5.
  •Enter Passengers   at Top 6 U.S. Airports in 2019 as the chart title.
  •Apply the Style 5 chart style.
  •Add Alt Text: Atlanta had the most passengers. (including the period).

Modifying the axes will improve   readability of the bar chart.
 

  •Change the font size to 10 for the category axis and value axis.
  •Change the value axis Maximum Bound to 1.1E8.
 

You will format a data point so   that it stands out and then add gridlines to enhance readability in the bar   chart.
 

  •Format the Atlanta data point with Dark Blue fill color.
  •Add Primary Minor Vertical gridlines.

A line chart effectively shows   trends over time for the passenger counts at the different airports.
 

  Create a line chart using the range A4:L10 in the Passenger worksheet and   move the chart to a chart sheet named Line Chart. Add a chart title Passengers   at U.S. Airports   and bold the title.

You want to customize the line   chart.
 

  •Set the Minimum Bound to 4.0E7 for the value axis and set the Maximum Bound to 1.1E8.
  •Set the Vertical (Value) Axis Display units to Millions. Delete the Vertical   (Value) Axis Display Units Label from the upper-left corner of the chart. Add   a value axis title In Millions.
  •Change the font size to 10 for the value axis and category axis.
  •Move the legend to the top.
  •Open the Select Data source dialog box and deselect the check boxes for the   even-numbered years. (On a Mac, change the Chart data range by selecting   these ranges: A4:B10,D4:D10,F4:F10,H4:H10,J4:J10,L4:L10 since the dialog box   does not contain check boxes to deselect the years.)
  •Add Alt Text: The line chart displays trends for top six U.S.   airports.   (including the period).

Sparklines provide a simple   visualization to represent data in a worksheet.
 

  Display the Passenger worksheet and insert Line sparklines in the range   M5:M10 to illustrate the data in the range B5:L10.
 

You want to customize the   sparklines to point out high and low points.
 

  •Show the high and low points in each sparkline.
  •Apply Black, Text 1 color to the high point marker in each sparkline.
 

Set page formats for the   Passenger worksheet.
 

  Select Legal paper size, select Landscape orientation, set 0.3″ left and right margins, and   scale to fit 1 page.

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

refer to the attached document

 You are a new employee of DigiFirm Investigation Company. As part of your company orientation, you are being exposed to each area of the computer forensics investigations firm.DigiFirm is preparing to set up a new on-site forensics laboratory facility. Kim Blake, the laboratory manager, has asked you to select three examples of software or a state-of-the-art piece of equipment that could be acquired and used in your organization’s new lab. Your supervisor mentioned to Kim that you could use some indoctrination to the DigiFirm technical capabilities, and what better way than to have you jump right in and help the company plan the new lab. You will help make some important decisions regarding investment in equipment and/or software. For this assignment:

1. Research forensic lab tools and equipment.
2. Choose three examples of software and one state-of-the-art piece of equipment that would benefit the lab.
3. Write a proposal that covers:
   1. Your choices include costs.
   2. The reasons for choosing them.
   3. The benefits and limitations (if any) of each choice.

This paper should be written in Microsoft Word (or compatible), Font: Arial, 12-point, double-spaced, Citation Style: your choice, and a length of 3-4 pages. 

Week 2: Discussion

 1. What are the common errors to avoid in your program when using

a.  variables?

b. conditional if statements?

Use examples to explain.

________________________________________________________________________________

You are required to make at least two comments on the responses posted by you classmates with a minimum of 50 words.