week5

 Your task this week is to write a research paper discussing the concept of risk modeling. Please also evaluate the importance of risk models. Lastly, construct an approach to modeling various risks and evaluate how an organization may make decisions about techniques to model, measure, and aggregate risks.Your paper should meet the following requirements:

  • Be approximately four to six pages in length, not including the required cover page and reference page.
  • Follow APA7 guidelines. Your paper should include an introduction, a body with fully developed content, and a conclusion.
  • Support your answers with the readings from the course and at least two scholarly journal articles to support your positions, claims, and observations, in addition to your textbook. The UC Library is a great place to find resources.
  • Be clearly and well-written, concise, and logical, using excellent grammar and style techniques. You are being graded in part on the quality of your writing.

Excel_Introductory_Capstone1_Year_End_Report

Excel_Introductory_Capstone1_Year_End_Report

In this project, you will work with multiple worksheets and enter formulas and functions to calculate totals, averages, maximum values, and minimum values. Additionally, you will create a summary sheet, format cells, insert charts, insert sparklines, and create a table in a workbook.

     

1

Open the Excel file Student_Excel_Intro_Cap1_Year_End_Report.xlsx   downloaded with this project.

 

2

On the Net Sales worksheet,   calculate totals in the ranges F4:F8 and B9:F9. Apply the Total cell style to   the range B9:F9.

 

3

Using absolute cell references   as necessary, in cell G4, construct a formula to calculate the percent that   the Colorado Total is of Total Sales, and then apply Percent Style with zero   decimals. Fill the formula down through the range G5:G8.

 

4

In the range H4:H8, insert Line   sparklines to represent the trend of each state across the four quarters. Do   not include the totals. Display Markers.

 

5

Select the range A3:E8, and then   use the Recommended Charts command to suggest an appropriate chart. Click the   first Clustered Column chart that uses the state names as the category axis.   Align the upper left corner of the chart inside the upper left corner of cell   A11, and then size the chart so that its lower right corner is slightly   inside cell H24. Apply chart Style 7. As the chart title, type Quarterly Net   Sales by State.

 

6

To show the percent that each   state contributes to the total sales, select the nonadjacent ranges that   represent the state names and state totals. Insert a 3-D Pie chart, and then   move the chart to a New sheet. Name the sheet Net Sales by State.

 

7

Change the Chart Title to   and then   change the chart title Font Size to 36. Remove the Legend from the chart, and   then add Data Labels that display only the Category Name and Percentage   positioned in the Center. Change the data labels Font Size to 14 and apply   Bold and Italic. Change the Font color to White, Background 1.

 

8

Select the entire pie and   display the Format Data Series pane. From the 3-D Format gallery, modify the   3-D options by changing the Top bevel and Bottom bevel to first bevel in the   first row. Set all of the Width and Height boxes to 512 and then change the   Material to the third Standard type—Plastic.

 

9

Insert a Custom Footer with the   File name in the left section and then save your workbook.

 

10

On the Seattle Inventory   worksheet, in cell B5, enter a function that will display the average retail   price. In cell B6, enter a function that will display the median retail   price. In cell B7, enter a function that will calculate the lowest retail   price. In cell B8, enter a function that will calculate the highest retail   price. Format the range B5:B8 with Accounting Number Format.

 

11

In cell B10, insert a COUNTIF   function that counts the number of Skiing items in the Sport column.

 

12

On the Seattle Inventory   worksheet, in cell G14, enter an IF function to determine the items to be   ordered. If the Quantity in Stock is less than 50, then the cell should display Order. If not, then the cell should   display OK.   Copy the function down through cell G19.

 

13

Format the range A13:G19 as a   table with headers. Filter the table on the Sport column to display only the   Skiing types. Display a Total Row in the table, and then sum the Quantity in   Stock for Skiing items. Type the result in cell B11. Remove the total row   from the table and then clear the Sport filter.

 

14

Add Gradient Fill Blue Data Bars   to the range A14:A19. Add conditional formatting to the range G14:G19 so that   the cells with text that contain the word Order are formatted with Bold and Italic. Sort the table   by Item # from Smallest to Largest.

 

15

Display the Inventory Summary   sheet. In cell B4, enter a formula that references cell B4 in the Seattle   Inventory sheet so that the Seattle Total Items in Stock displays in cell B4.   In cell B5, enter a formula that references cell B5 in the Seattle Inventory   sheet so that the Seattle Average Price displays in cell B5. In cells B6, B7,   and B8, enter similar formulas to reference the Median Price, Lowest Price,   and Highest price in the Seattle Inventory sheet.

 

16

In cell C4, enter a formula that   references cell B4 in the Denver Inventory sheet so that the Denver Total   Items in Stock displays in cell C4. In cells C5, C6, C7, and C8, enter   similar formulas to reference the Average Price, Median Price, Lowest Price,   and Highest price in the Denver Inventory sheet. Apply Accounting Number   format to the range B5:C8.
 

 

17

On the Annual Expenses sheet,   construct formulas to calculate Totals by Quarter in the range B10:E10 and   the Annual Totals in the range F5:F10. Apply the Total cell style to the   Totals by Quarter (B10:F10), and then center the column headings (B4:G4) and   apply the Heading 4 cell style.

 

18

Using absolute cell references   as necessary, in cell G5, construct a formula to calculate the % of Total by   dividing the Sales Expense Annual Total by the Annual Totals by Quarter. Fill   the formula down through the range G6:G9.

 

19

Using the data in the   nonadjacent ranges B4:E4 and B10:E10, insert a Line with Markers chart.   Position the upper left corner of the chart slightly inside the upper left   corner of cell A12. Change the height of the chart to 1.75 inches and the width of the   chart to 8   inches.
 

  Note, Mac users, change the height of the chart to 1.5 inches.

 

20

Apply chart Style 7. Change the   chart title to Direct Expenses. Edit the Vertical (Value) Axis so that the   Minimum is 8000000 and the Major unit is 1000000.

 

21

Use Format Painter to copy the   formatting from cell A2 to A20. In cell B23, enter a formula that references   the value in cell F10.

 

22

Using absolute cell references   as necessary, in cell C23, construct a formula to calculate the projected   expenses for 2020 after the Forecasted increase in cell B21 is applied. Fill   the formula through cell F23.

 

23

Display the Sales Reps sheet. By   using Flash Fill and deleting columns as necessary, place the last names in   column A and the first names in column B. Widen both columns to 100 pixels,   and then merge and center the title Sales Reps across the two columns. Apply   the Heading 1 cell style to the title.
 

 

24

With any sheet except the chart   sheet active, group the worksheets. Change the Orientation to Landscape,   center the worksheets Horizontally, and insert a footer in the left section   with the file name. (Mac users, click the Net Sales sheet, hold down SHIFT,   and then click the Sales Reps sheet. Then apply the Page Layout options.)

 

25

Save and close the file and   submit for grading.

perimeter defence

 

This lab will be different. Your only task is to create a single page* document called an executive summary. An executive summary simply summarizes a report. Some would say it’s an executive summary because it allows executives to not have to read the entire report, but that would be pessimistic. 🙂 You could also consider it an executive summary because it summarizes the execution of a plan, and that’s a great way keep in mind what it should do. You need to create a single page report on why your hypothetical organization needs a security policy, and this executive summary should do two things:

1) Allow an executive that has to approve your plan to understand why it’s so important without having to understand all the things you learned over the course of the semester. You have to let them know enough to convince them without burying them in details. This is why Chapter 12 is helpful in framing the ‘why’.

2) You have to let them know how you’re going to do it with a broad outline of the structure of the Security Policy and who and how it applies to in the organization. These are the logistics behind the “who/what/where/when/how” elements all executives have to reconcile to the larger organizational issues they are responsible for.

The document should be one page with standard margins, single spaced, and well formatted. Your instructor reserves the right to determine any specific elements they wish you to follow in this assignment.

Parallel Comp and Dist Sys

 the assignment is about using multithreading for parallel programming. In the assignment folder you will find:

  • zip file for examples of using Java Multithreading main functions.
  • the pdf version of the assignment

Write a composition

Write a composition using one of the topics listed below. Your composition needs to be three to five paragraphs long. It must contain an introduction, a body, and a conclusion. • Argue for or against the limitation of speed limits. • Explain why a certain sport is your favorite. • Compare and contrast driving in the winter and driving in the summer. • Describe a SINGLE memorable day in your life.Write a letter of complaint. Follow the rules for a formal letter, and use the full-block style. The complaint may be about anything you wish (such as malfunctioning equipment, poor building maintenance, or disruptive noises from a nearby business). You can base your letter on a true experience, or you can make up all the details you need. Please note that a form letter or a template cannot be used in constructing your response to question 2. When a form letter or template is used, you are giving little to no thought to wording or formatting, and you are not actually creating your own complaint; you are simply filling in the blanks of someone else’s work. For this reason, a grade of 1% will be issued if a form letter or template is used.Checklist Ask yourself these questions after you answer the questions for your exam.Is my composition three to five paragraphs long? (It must include an introduction, body paragraphs, and a conclusion.) Did I select a topic for my composition from the list given in the instructions? Did I fully expand on the topic I selected for my composition? (Example: If you selected to describe a memorable day, you should only describe ONE day.) Does my letter include a complaint? Did I include all parts of a business letter? (This includes a signature! You can use a different font to indicate your signature.) Is my letter written in full-block style? Did I answer both questions on my own, without help from the internet? Are both answers saved in one document? Is my work saved as a Microsoft Word document or in Rich Text Format? If you answered NO to any of these questions, please go back and make the needed changes before submitting your work.If you answered YES to all of the questions, you are ready to submit your work for grading!

Informational Interview

 Part 1 (recommend completing during Week 5)

In Part 1 of this activity, you will complete the following tasks: 

  • Watch “How to Do an Informational Interview.”
  • Select your prospective interview candidate. See below for guidance on identifying a suitable interviewee.
  • Gather professional/biographical details about your prospective interview subject.
  • Request an interview by email, by phone, or in person. If you’re going to send your request by email, review this site for suggested wording. Consider CC’ing me on the request.

To identify a suitable interview subject, find professionals in your career you would like to explore. Think about tapping these sources:

  • Check with your personal and professional networks and professors to connect you with professionals in your field of interest.
  • Check within Community Connect within CareerQuest or the UMUC/UMGC Alumni LinkedIn group for access to potential alumni and mentors. 
  • Consider members within student or professional organizations you have joined or would like to join. 

There are no restrictions on your interviewee’s location. CareerQuest has a video chat feature you can use if you connect with your subject through that platform. 

After you explore your interviewee options, request the interview. Reach out in a timely manner, as many professionals have demanding schedules and may not be available right away. It is also wise to consider having more than one potential interview candidate, in case your first choice doesn’t pan out.

As you prepare for your interview, bear in mind these tips: 

  • Maintain a professional demeanor, both in writing and orally.
  • Draft a list of questions in advance.
  • Schedule the interview for no longer than 20 minutes.

Part 2 (recommend completing during Week 6)

Prepare for your interview well in advance. In Part 2 of this activity, you will prepare for and conduct your informational interview by completing the following tasks: 

  • Determine the logistics of your interview. Will you meet in person? Via video chat or web conference (Zoom, Google Hangouts, FaceTime, Skype, etc.)? An interview in real time is preferable, but if you and your subject are unable to arrange that, you can use email.
  • Draft your interview questions. See below for guidance.
  • Conduct the interview.

Here are some questions you might consider: 

  • What sparked your interest in this career field? 
  • What does a typical day entail in your line of work? 
  • What do you like most about your career field? 
  • What are some challenges you face in this career choice? 
  • How do you handle your work-life balance? 
  • What suggestions do you have for someone who is interested in this field? 
  • Who else do you recommend I talk to? 

Part 3 (due by the end of Week 7)

After your interview, summarize your notes in two or three paragraphs. Include the name of the interviewee, a short biography describing his or her professional background and experiences, and a brief synopsis of your interview details/highlights. Be sure to include a reflection on why you chose to interview this person and what you learned relative to your career. Finally, make sure to include the questions you asked. You may find this template helpful.  This documentation is due by the end of Week 7.

Cloud implementing

 Write a 1-page paper describing some of the questions an organization  should consider when evaluating a cloud collaboration service. Your  paper should also: 

  • List the advantages and disadvantages of utilizing a cloud collaboration solution.
  • Explain the difference between synchronous and asynchronous collaboration tools.

Top ten recommendations for securing virtual servers

Project Topic: Top ten recommendations for securing virtual servers

Take any industry and relate your recommendations to that particular industry. 

Your Research Project must consist of:

1. Five source annotated bibliography

2. Slide presentation with 12 or more slides

3. Summary or Abstract containing at least 750 words.

The topic must be appropriate for graduate level. Find a topic that we covered in the course and dig deeper or find something that will help you in your work or in a subject area of interest related to the course topic. Use the  Research Databases available from the Danforth Library not Google.

you may use the following references.

References

Carr, D. F. (2006). Primer virtual servers; what is a virtual server? Baseline, 1(54), 1. Retrieved from http://nec.gmilcs.org/login?url=https://www-proquest-com.nec.gmilcs.org/docview/213422891

Dubie, D. (2007). Hypervisor security a growing concern. Network World, 24(46), 1-1,18. Retrieved from http://nec.gmilcs.org/login?url=https://www-proquest-com.nec.gmilcs.org/docview/215982137

Antonopoulos, A. (2007). Virtual servers: More or less secure? Network World, 24(28), 16. Retrieved from http://nec.gmilcs.org/login?url=https://www-proquest-com.nec.gmilcs.org/docview/215980025

Mitchell, R. L. (2010). THE scary SIDE OF VIRTUALIZATION. Computerworld, 44(21), 19-20,24,26. Retrieved from http://nec.gmilcs.org/login?url=https://www-proquest-com.nec.gmilcs.org/docview/816471301

CCL Are your virtual servers vulnerable and exposed?; are they intrusion protected and firewall secure?; are they open to external attack through unsecured VPN access? (2009). M2 Presswire Retrieved from http://nec.gmilcs.org/login?url=https://www-proquest-com.nec.gmilcs.org/docview/444121791

It should be your own work and should pass a plagiarism check.