Monthly Archives: June 2023

200 words+

Review scholarly articles and reputable resources and discuss what are the latest technology/software for intrusion detection and prevention techniques.

Please  list  your references/resources.

Write two essay and each of these need 1000 words.

Write a 1- to 2-page reference table. 

Details of the assignment have been attached. 

Thank you!

Case Problem: Young Professional Magazine (p. 324)

Use Data File: Professional.xlsx (attached below)

As a new employee of the magazine, you have been asked to help analyze the survey results of their target audience.  Prepare a managerial report summarizing the results of the survey.  In addition to statistical summaries, discuss how the magazine might use these results to attract advertisers. 

I am looking for the interpretation of the data, not simply the regurgitation of results.  Please address the following:

1. Develop appropriate descriptive statistics to summarize the data.
2. Develop 95% confidence intervals for the mean age and household income of the subscribers.
3. Develop 95% confidence intervals for the proportion of the subscribers who have broadband access at home and the proportion of of subscribers who have children.
4. Would Young Professional be a good advertising outlet for online brokers?  Justify your conclusion with statistical data.
5. Would this magazine be a good place to advertise for companies selling educational software and computer games for young children?

Submit the report as a .doc/pdf and attach your .xlsx statistics file for grading.

 I am taking the following online course, Pearson Education MyLab IT.  The course has 13 tutorials and tests.  Is this something you can do this week, and if so, what is the cost?

Thanks

Word Volume 1, Chapter 1: Creating Documents with Microsoft Word 2016

Word Volume 1, Chapter 2: Creating Cover Letters and Using Tables to Create Resumes

Word Volume 1, Chapter 3: Creating Research Papers, Newsletters, and Merged Mailing Labels

Excel Volume 1, Chapter 1: Creating a Worksheet and Charting Data

Excel Volume 1, Chapter 2: Using Functions, Creating Tables, and Managing Large Workbooks

Excel Volume 1, Chapter 3: Analyzing Data with Pie Charts, Line Charts, and What-If Analysis Tools

Excel Comprehensive, Chapter 7: Creating PivotTable and PivotChart Reports and Using BI Tools in Excel

Access Volume 1, Chapter 1: Getting Started with Microsoft Access 2016

Access Volume 1, Chapter 2: Sort and Query a Database

Access Volume 1, Chapter 3: Forms, Filters, and Reports

PowerPoint Volume 1, Chapter 1: Getting Started with Microsoft PowerPoint

PowerPoint Volume 1, Chapter 2: Formatting PowerPoint PresentationsPowerPoint Volume 1, Chapter 3: Enhancing a Presentation with Animation, Video, Tables, and Charts

Week 8 Assignment – System Security Monitoring, Patch Management, and Update Policies

Introduction

In this assignment, you will develop  corporate policies for system security monitoring, patch management, and  updates that cover both wired and wireless components. A web search  will provide multiple examples of policy documents. The following  resources may also be helpful as you draft your policy documents: 

• SANS. No date. CIS Critical Security Controls. https://www.sans.org/critical-security-controls/?msc=main-nav     
  • This resource provides a list of case studies highlighting how  security professionals have made improvements in their security  controls.
• SANS. No date. Security Policy Templates. https://www.sans.org/information-security-policy/     
  • This resource provides a number of security policy templates that might be helpful in drafting your policy documents.

The specific course learning outcome associated with this assignment is: 

• Recommend best practices for monitoring, updating, and patching systems.

Instructions

Write a 6–10 page paper in which you: 

• Establish a system security monitoring policy addressing the need  for monitoring, policy scope, and exceptions and supported by specific,  credible sources.     
  • Justify the need for monitoring.
  • Define the scope of the policy (the personnel, equipment, and processes to which the policy applies).
  • Provide guidelines for policy exceptions, if approved by the IT and Security departments.
• Establish a system security patch management and updates policy  addressing the need for patch management and updates, policy scope, and  exceptions and supported by specific, credible sources.     
  • Justify the need for patch management and updates, aligned with ISO/IEC 27002.
  • Define the scope of the policy (the personnel, equipment, and processes to which the policy applies).
  • Provide guidelines for policy exceptions, if approved by the IT and Security departments.
• Support your main points, assertions, arguments, or conclusions  with at least four specific and credible academic sources synthesized  into a coherent analysis of the evidence.     
  • Cite each source listed on your source page at least one time within your assignment.

 What experience and interest do you have in cybersecurity? How might the knowledge and skills associated with this course support your career or life aspirations?

Have you personally (or your organization) experienced a cybersecurity breach – stolen identity, credit card fraud, computer virus infestation, malware attack, social engineering, etc.? If yes, describe how the attack progressed and the related damages you experienced. If no, then are you (or your organization) generally fearful of such attacks, and how is protection ensured?

Describe the kind of cybersecurity problems that either you or your company have experienced. What were the root causes of these problems? Based on what you know so far about cyber security, how should these have been addressed?

the question and direction is attached below.

 ScenarioYour new manager comes to you and asks you that he keeps hearing about read/write blockers for forensic imaging. He’s not sure what that is. He also is confused because he’s heard that there’s two different types (software and hardware). Also, there’s commercial and open source tools. He knows you just took a course in digital forensics so he asks you to prepare a memo for him explaining all that.Your assignment

1. Research on what is a forensic read/write blocker and what is the difference between a hardware and a software version?
2. Research on what tools are available e.g. commercial (you buy) or open-source (free) and what types are available.
3. Identify some situations where it makes sense to use the hardware versions or when it makes sense to use software versions?
4. Put it all together and summarize it for your manager! No more than 2 pages please.

What this teaches youBeing familiar with what tools the investigator used will help you. You gain credibility by asking what hardware or software tools they used, how they deployed it and why they went with a hardware or software version.  

 Exp19_Excel_Ch01_ML2_Sales

Project Description:

You own a small real estate company in Indianapolis. You track the real estate properties you list for clients. You want to analyze sales for selected properties. Yesterday, you prepared a workbook with a worksheet for recent sales data and another worksheet listing several properties you listed. You want to calculate the number of days that the houses were on the market and their sales percentage of the list price. In one situation, the house was involved in a bidding war between two families that really wanted the house. Therefore, the sale price exceeded the list price.

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

The owners of the house on 386   East Elm Street took their house off the market. You want to delete that row   since it did not sell.
 

  Delete row 8, which has incomplete sales data.

You want to assign a property ID   to each listing. The code will have the year 2021 with a sequential number.
 

  Type 2021-001 in cell A5 and use Auto Fill to   complete the series to assign a property ID to each property in the range   A6:A12.

Real estate agents study the   number of days houses are on the market. In some cases, the longer a house is   on the market, it might indicate the asking price is too high.
 

  Enter a formula in cell C5 that calculates the number of days the first house   was on the market by subtracting the date listed from the date sold. Copy the   formula to the range C6:C12.

Monetary values look better when   they are formatted to display the dollar signs. Because all monetary values   are whole numbers, you will decrease the decimal points to avoid columns   where all the data ends in .00.
 

  Format the list prices and sold prices in the range F5:G12 with Accounting   Number Format with zero decimal places.

To analyze the real estate   market, it is helpful to calculate the selling prices as a percentage of the   list price. For example, the second house was listed for $500,250, but it   sold for only $400,125. Therefore, the sale percentage of the list price is   .7999 or 79.99%.
 

  Enter a formula in cell H5 that calculates the sales price percentage of the   list price for the first house by dividing the sold price by the list price.   Copy the formula to the range H6:H12.

The calculated percentages need   to be formatted with the percent symbol rather than displaying the values as   raw numbers.
 

  Format the values in the range H5:H12 with Percent Style with two decimal   places.

Currently, the labels on row 4   are hard to read. You will wrap the headings within each cell to improve   readability.
 

  Wrap the headings in the range A4:H4.

For better sequencing of   columns, you want to display the Days on Market column after the two columns   containing the dates.
 

  Insert a new column between the Date   Sold and List Price columns.   Move the Days on Market data to the   new blank column F by moving the range C4:C12 to F4:F12. Delete column C.

You notice the list contains a   wrong date and wrong list price that need to be corrected.
 

  Edit the list date of the 41 Chestnut   Circle house to be 4/22/2021. Edit the list price of the house on Amsterdam Drive to be $355,000.

Increasing the height of the   rows of data and centering the data vertically between the top and bottom   cell margins will make it easier for the other agents to review the data.
 

  Select the property rows (rows 5:12), set a 25 row height, and apply Middle Align.

Displaying borders helps   separate the property listings.
 

  Apply the All Borders border style to the range A4:H12.

You want to improve the   alignment of number of days on market below the column label.
 

  Apply Align Right and increase the indent two times on the days on market   formula results in the range E5:E12.

The widths of the columns   containing the Days on Market, List Price, and Sold Price data need to be   adjusted for better appearance.
 

  Set the Days on Market column width to 9. Set the List Price and Sold Price column widths   to 11.86.

The property listings dataset is   small. To improve readability on the printed copy for the other real estate   agents, you will increase the scaling.
 

  Apply 120% scaling.

You don’t need the data on the   Properties sheet but you do want to insert another sheet for formulas.
 

  Delete the Properties sheet and insert a new sheet named Formulas.

You want to copy the original   data to the new sheet so that you can modify the duplicated data.
 

  Use the Select All feature to select all data on the Houses Sold worksheet   and copy it to the Formulas worksheet.

You do not want to display the   columns containing dates on the new worksheet.
 

  Hide the Date Listed and Date Sold columns in the Formulas worksheet.

You want to review the formulas within   the worksheet and prepare the Formulas sheet to be printed.
 

  Display cell formulas. Set options to print row and column headings. Set 6.86   column width for column E and 6 for column H.

You want to apply page setup   options to both sheets, so you need to group the sheets first.
 

  Group the two worksheets. Select Landscape orientation. Center the page   horizontally and vertically between the margins.

With both worksheets still   grouped, insert a footer with the text Exploring Series on the left side, the sheet   name code in the center, and the file name code on the right side.

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