Data breaches are now a way of life. The Privacy Rights Clearinghouse provides a continually updated list of recent breaches at https://www.privacyrights.org/data-breaches. Many of these are also listed on Fraud.org’s Data Breach webpage: https://www.fraud.org/latest_breaches.

For your first assignment, find a data breach that has occurred in the past two years and provide a summary of it in your own words. Include the following:

• Who was affected (both the organization and any end-users)?
• What was compromised (both the systems and types of data)?
• How did the attack occur? Include the threat and attack vectors used, if known.
• How could the breach have been prevented?

350 words due 9-8-21 

Subject: ITS-834: Emerging Threats & Countermeasures

Reading Resources:

Abomhara, M., & Koien, G.M. (2015). Cyber security and the internet of things: Vulnerabilities, threats, intruders, and attacks. Journal of Cyber Security, 4, 65-88. DOI:  https://doi.org/10.13052/jcsm2245-1439.414

NIST. (2019). Guide to Protecting the Confidentiality of Personally Identifiable Information (PII). United States Department of Commerce. National Institute of Standards and Technology Special Publication No. 800-122. https://nvlpubs.nist.gov/nistpubs/Legacy/SP/nistspecialpublication800-122.pdf

Chapters 5, 9, and 10 in the course textbook 

Textbook Title: (ISC)2 CISSP Certified Information Systems Security Professional Official Study Guide ISBN: 9781119475958, Authors: Mike Chapple, James Michael Stewart, Darril Gibson, Publisher: John Wiley & Sons, Publication Date: 2018-04-10  

Discussion: Physical Security and Threats

Word count: 300+ words

Chapters 5, 9, and 10 in the course textbook 

Many business environments have both visible and invisible physical security controls. You see them at the post office, at the corner store, and in certain areas of your own computing environment. They are so pervasive that some people choose where they live based on their presence, as in gated access communities or secure apartment complexes. Alison is a security analyst for a major technology corporation that specializes in data management. This company includes an in house security staff (guards, administrators, and so on) that is capable of handling physical security breaches. Brad experienced an intrusion—into his personal vehicle in the company parking lot. He asks Alison whether she observed or recorded anyone breaking into and entering his vehicle, but this is a personal item and not a company possession, and she has no control or regulation over damage to employee assets. This is understandably unnerving for Brad, but he understands that she’s protecting the business and not his belongings.

When or where would you think it would be necessary to implement security measures for both?

Make sure to back up your statements with scholarly support.

· Please cite properly in APA 7

· At least one scholarly source should be used. 

· Use proper citations and references in your post.

Research Paper:Cyber security and the internet of things

Number of pages: 3+

For this assignment, review the article:

Abomhara, M., & Koien, G.M. (2015). Cyber security and the internet of things: Vulnerabilities, threats, intruders, and attacks. Journal of Cyber Security, 4, 65-88. Doi: 10.13052/jcsm2245-1439.414

and evaluate it in 3+ pages, using your own words, by addressing the following:

· What did the authors investigate, and in general how did they do so?

· Identify the hypothesis or question being tested

· Summarize the overall article.

· Identify the conclusions of the authors

· Indicate whether or not you think the data support their conclusions/hypothesis

· Consider alternative explanations for the results

· Provide any additional comments pertaining to other approaches to testing their hypothesis (logical follow-up studies to build on, confirm or refute the conclusions)

· The relevance or importance of the study

· The appropriateness of the experimental design

When you write your evaluation, be brief and concise. Also, you should include a complete reference (title, authors, journal, issue, pages) you turn in your evaluation. This is good practice for your literature review, which you’ll be completing during the dissertation process. 

Your paper should meet the following requirements:

· 3+ pages in length, not including the required cover page and reference page.

· Follow APA 7 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.

· 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.

Note: plagiarism check required, APA7 format, include References, within 8hrs

This post has 2 individual assignments (a discussion and a research paper). Please provide answers in separate documents. 

Exp19_Excel_Ch04_CapAssessment_Rockville_Auto_Sales

Project Description:

You work for Rockville Auto Sales and have been asked to aid in the development of a spreadsheet to manage sales and inventory information. You will start the task with a prior worksheet that contains vehicle information and sales data for 2018. You need to convert the data to a table. You will manage the large worksheet, prepare the worksheet for printing, sort and filter the table, include calculations, and then format the table.

96% mark

Please read case studies II-3 and II-4.



Answer these questions about the case studies:

 II-3:

1. Describe the benefits of data warehousing and business intelligence at Norfolk Southern.



2. What did the company do right that has led to the successful deployment of data 

warehousing and business intelligence within Norfolk Southern?



3. What has promoted the spread or growth of data warehousing and business intelligence 

within and across Norfolk Southern over time?

II-4:



1. Why didn’t the California Franchise Tax Board do this type of data mining in 1980 or 

1990?



2. How well did managers at the Filing Compliance Bureau address technical challenges?

 

3. How well did managers at the Bureau address various political and social challenges?

Instructions: Double spaced- 9-10 pages.

Please answer the following questions with complete sentences, well-thought-out paragraphs, and supported by information from the pertinent chapters. Use the case studies themselves for material and any pertinent sections of the textbook to support your answers; online sources are acceptable. Anytime you use sources outside of the textbook, they must be cited appropriately. Textbook sources may be briefly cited with a simple page number (e.g. “ref. p.34”).

Requirements: 9-10

Exp19_Excel_Ch12_CapAssessment_Teaching_Schedule

Exp19_Excel_Ch12_CapAssessment_Teaching_Schedule

#Exp19_Excel_Ch12_CapAssessment_Teaching_Schedule 

#Excelch12CapAssessmentTeachingSchedule

#You have just started your first career as a high school teacher. To jump start your planning process, you would like to create a teaching schedule template to help plan your weekly tasks. You will create a template, create custom macros to automatically insert dates, and inspect the document for issues.

#     

Clear   all data validation in the range A1:G19.

Delete the sample text in cell   B2

Type Teaching Schedule in cell B1.

Type prepared by: in cell F1.

Delete the value in cell G1.

Add the following comment in   cell G1 Enter Name.

#Type Monday in cell C4 and use the fill handle to fill the   range D4:G4 with the remaining days of the week. 

#Use the document inspector to   inspect the document. Remove document properties and personal information and   then click close.
 

  Note: Mac users, from the Excel menu, open your preferences, click Security,   and then click the check box to Remove personal information from this file on   save.

#Use the accessibility checker to   check the document for issues. Accept the recommended actions for merged   cells and use the recommended action to select Rose, Table Style Medium 23.   Close the accessibility checker pane.

#Record a macro named ClearSchedule using the shortcut   CTRL+SHIFT+J. Add the description #When run, this macro clears the values in the schedule (no period). When run, the   macro should delete the values in cell G1 and in the ranges C3:G3, C5:G6,   C8:G9, C11:G12, C14:G15, C17:G19, in that order.

#Create a form control button   that fills cell F2. Assign the ClearSchedule macro and edit the button text   to Clear.

#Create a form control button   that fills cell G2 and edit the button text to Insert Dates.

#Open the VBA editor and create a   new module named DateStamp. Create a procedure named InsertDate. Insert the comment Inserts   weekly dates,   then enter the following code Range(“C3:G3”) = Array(Date, Date + 1, Date +   2, Date + 3, Date + 4)   and exit the VBA editor.

#Assign the InsertDate macro to   the Insert Dates form control button.

#Test both macros and then open   the VBA editor. Locate the module containing the ClearSchedule macro. Copy   the code and paste it starting in cell B2 in the Code worksheet. 

#Locate the module containing the   InsertDate macro. Copy the code and paste it starting in cell D2.

Check the document for   compatibility with Excel 2010, 2013, and 2016.
 

  Note: Mac users, skip this step

 Cybercriminals use many different types of malware to attack systems. Select one common type of malware listed in this article link and using your own words, explain how to defend yourself against it in a word document with no less than 300 words in “APA format” with “Two references & Citations”   https://www.esecurityplanet.com/malware/malware-types.html#maliciousmobileapp 

PowerPoint_1F_Refuge

Open   the file Student_PowerPoint_1F_Refuge.pptx downloaded with this project. 

Change the Slide Size to   Widescreen (16:9).

Display the presentation   Outline. In the Outline, on Slide 2, increase the list level of the third and   the fifth bullet points. Click at the end of the last bullet point after the   word roads, and then type or facilities

Return the presentation to   Normal view, and then display Slide 4. Display the Reuse Slides pane. Browse   to open from your downloaded files, p01F_Excursions.pptx. Make sure the   Keep source formatting check box is cleared. With Slide 4 in your   presentation displayed, insert the last two slides from the Reuse Slides   pane.
 

  Note—Mac users insert all slides and delete Slide 5—Wildlife and Excursions.

Display Slide 1, and then change   the layout to Title Slide.

On Slide 1, select the subtitle—Experience Alaska with Kodiak West Travel.   Change the Font to Arial, and the Font Size to 28. Change the Font Color to   black. Center the title and the subtitle.

Display Slide 5, and then select   the paragraph in the content placeholder. Apply Bold and Italic, and then   change the Font Size to 16.

In the same paragraph, center   the text, and then change the Line Spacing to 1.5. Center the slide title.

In Slide Sorter view, delete   Slide 3. Move Slide 5 to position it after Slide 2.

Move Slide 4 to the end of the   presentation.

In Normal view, display Slide 1.   Apply the Split transition and change the Effect Options to Horizontal Out.   Change the Duration to 1.75, and then apply the transition to all of the   slides in the presentation. 

Insert a Header & Footer on   the Notes and Handouts. Include the Date and time updated automatically, the   Page number, a Footer with the text 1F_Refuge and then apply to all notes and   handouts.

Display the Document Properties.   As the Tags type refuge, tours
  Note—Mac users use the Keywords box.

Save and close the file, and   then submit for grading.

Exp19_Excel_Ch03_CapAssessment_Movies

Exp19 Excel Ch03 CapAssessment Movies

Project Description:

You are an assistant manager at Premiere Movie Source, an online company that enables customers to download movies for a fee. You need to track movie download sales by genre. You gathered the data for April 2021 and organized it in an Excel workbook. You are ready to create charts to help represent the data so that you can make a presentation to your manager later this week.

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

You want to create a pie chart   to show the percentage each category contributes to the monthly movie   downloads.
 

  Select the ranges A5:A10 and F5:F10. Create a pie chart and move it to a   chart sheet named April Pie Chart.

The chart needs a descriptive   title that is easy to read.
 

  Type April   2021 Downloads by Genre as the chart title, apply bold, 18 pt font size, and Black, Text   1 font color.

Percentage and category data   labels will provide identification information for the pie chart.
 

  Add category and percentage data labels in the Inside End position. Remove   value data labels and the legend. Apply 14 pt font size and Black, Text 1   font color.

You want to focus on the comedy   movies by exploding it and changing its fill color.
 

  Explode the Comedy slice by 7% and apply Dark Red fill color.

A best practice is to include   Alt Text for accessibility compliance.
 

  Add Alt Text: The pie chart shows percentage of downloads by genre   for April 2021.   (including the period)

Next you want to create a combo   chart to depict the monthly totals and percentages by category.
 

  Display the Data sheet, select the ranges A4:A10 and F4:G10, and then create   a Clustered Column – Line on Secondary Axis combo chart.

You want to position the chart   below the data source.
 

  Cut the chart and paste it in cell A13. Change the height to 3.5″ and the width to 6″.

Change the combo chart title to April 2021   Downloads.   Apply Black, Text 1 font color to the chart title.

Axis titles will help   distinguish the number and percentage of downloads.
 

  Add a primary value axis title and type Number of Downloads. Add a secondary value axis   title and type Percentage of Monthly Downloads. Apply Black, Text 1 font color   to both value axis titles.

Now that you added an axis title   for each vertical axis, you can remove the legend and format the secondary   value axis to display whole percentages.
 

  Remove the legend for the combo chart. Display 0 decimal places for the   secondary value axis.

You want to add some color to   the plot area for the combo chart.
 

  Apply Light Gradient – Accent 1 gradient fill color for the plot area.

A best practice is to include   Alt Text for accessibility compliance.
 

  Add Alt Text: The combo chart shows the number and percentage of   downloads by genre for April 2021. (including the period).

To provide a visual summary of   the weekly totals for each genre, you will insert sparklines.
 

  Select the range B5:E11. Insert Line Sparklines in the range H5:H11. Apply   Black, Sparkline Style Dark #4

Displaying the markers helps   identify the specific points on the sparklines. You will also change the high   point to a different color to stand out.
 

  Show the high point and markers for the sparklines. Change the high point   marker color to Red.

Your last major task is to   create a bar chart for weekly downloads.
 

  Select the range A4:E10. Create a stacked bar chart. Move the chart to new   chart sheet. Type Weekly Downloads for the sheet name. Apply Style 8 chart style.

Add a chart title above the bar   chart and type April 2021 Weekly Downloads by Genre. 

Increasing the font size will   make the chart elements easier to read.
 

  Apply 11 pt font size to the category axis, value axis, and the legend for   the bar chart.

Because the largest value is   less than 9,000, you can reduce the maximum bound in the chart. In addition,   you want to display the category labels in the same order that they are in   the worksheet.
 

  Change the maximum bounds for the value axis to 9000 and set the Major Units to 500 for the bar chart. Use the Axis   Options to format the category axis so that the category labels are in   reverse order in the bar chart.

Although the bar chart displays   major gridlines, minor gridlines could improve the appearance.
 

  Add primary minor vertical gridlines to the bar chart.

A best practice is to include   Alt Text for accessibility compliance for the bar chart.
 

  Add Alt Text: The stacked bar chart shows downloads by each week for   each genre.   (including the period).

Insert a footer with Exploring   Series on the   left, the sheet name code in the center, and the file name code on the right   on all the sheets. Change to Normal view.

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

Individual Research Paper

Prepare a report to address all aspects of the assignment.  This report should be no less than 5 pages of content.  You need to include outside sources and properly cite and reference your sources.  You must have at least 5 references, all of which must be scholarly peer-reviewed articles.  In addition to the 5 pages of content, you will want a title page and a reference sheet.  This report needs to be in proper APA format.  Please note that 5 pages with 5 references are the minimum requirement for a passing grade.  The minimum effort will earn a maximum of a C grade.  

Paper Sections

The following sections should be outlined as Headers in the paper.

Introduction, thesis statement, overview, purpose
Background, discuss the history of the topic 
Discussion, identify benefits, obstacles, innovations 
In conclusion, summarize the overall study, lessons learned 
References, minimum three references with citations in the body

very easy homeworks. due saturday