Quantitative Research on cybersecurity in healthcare in the US.

– Abstract

– Introduction

– Body paragraphs (research description and methods) 

– Findings

– Discussion

– Conclusion

– References

 Download and read the document and answer all questions in the document. Please see attached document H1.

 Assessment Description

The System Design Document (SDD) describes the high-level system design and the low-level detailed design specifications from which a system is built. As part of the security development team, this document provides the information necessary in designing and implementing a system.

Create a system design document making sure to:

1. Describe the design goals and considerations.
2. Provide a high-level overview of the system architecture.
3. Describe the data design associated with the system.
4. Describe the human-machine interface and operational scenarios.
5. Design a drawing appropriate for implementation. The high-level system design should be further decomposed into low-level detailed design specifications for each system component, including hardware, internal communications, software, system integrity controls, and external interfaces.

Refer to the “System Design Document,” provided within the required readings as an example. Note: Only the criteria listed above is required within the System Design Document; additional sections are not required.

APA style is not required, but solid academic writing is expected.

Refer to “CYB-690 System Design Scoring Guide,” prior to beginning the assignment to become familiar with the expectations for successful completion.

You are not required to submit this assignment to LopesWrite.

#Exp22_Excel_Ch09_Cumulative_Theatre 

#Exp22 Excel Ch09 Cumulative Theatre 

#Excel Chapter 9 Cumulative – Sugarhouse District Theatre 

Project Description:

You are an assistant to the manager of Sugarhouse District Theatre, where touring Broadway shows are performed. You created a workbook for the weekend evening performances to track the number of seats available and sold in each section of the theatre, along with gross revenue. You are ready to complete the workbook.

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

  Note: When you open the file, Excel prompts you to fix a circular error.   Click or press OK and continue.

The first column in the Template   worksheet contains cells with a different font color and levels of   indentation. You want to fill this formatting across the Friday, Saturday,   and Sunday worksheets.
 

  Group the Template, Friday, Saturday, and Sunday worksheets. Fill the   formatting for the range A5:A20.

You notice that a formula is   missing on worksheets. You will insert the formula simultaneously.
 

  With the worksheets still grouped, in cell E20, enter a formula to subtract   the Grand Total Percentage Sold from 1. Apply Bold to the cell.

The range I4:J7 displays the   average number of seats sold in each section. However, two results display   #DIV/0! because the template does not contain sample values in some sections.   You will edit the formula to avoid the error.
 

  With the worksheets still grouped, edit cell J5 by enclosing the AVERAGEIF   function within an IFERROR function. The value_if_error argument should   display the text Missing data. Copy the function to the range J6:J7. Fill   Without Formatting to preserve the borders.

Hide the Template worksheet.

The Totals worksheet contains   summary data. You will insert a hyperlink to the number of seats sold in each   respective worksheet.
 

  On the Totals worksheet, in cell A5, insert a hyperlink to cell C20 in the   Friday worksheet with the ScreenTip text Friday Seats Sold. In cell A6, insert a hyperlink   to cell C20 in the Saturday worksheet with the ScreenTip text Saturday   Seats Sold. In   cell A7, insert a hyperlink to cell C20 in the Sunday worksheet with the   ScreenTip text Sunday Seats Sold. Test the hyperlinks to ensure the work correctly.

Now you are ready to insert a   formula with a reference to the number of seats sold for Friday’s   performance.
 

  In cell B5, insert a formula with a 3-D reference to cell C20 in the Friday   worksheet.

Now you are ready to insert a   formula with a reference to the number of seats sold for Saturday’s   performance.
 

  In cell B6, insert a formula with a 3-D reference to cell C20 in the Saturday   worksheet.

Now you are ready to insert a   formula with a reference to the number of seats sold for Sunday’s   performance.
 

  In cell B7, insert a formula with a 3-D reference to cell C20 in the Sunday   worksheet.

The next section of the Totals   worksheet is designed to display total gross revenue by section.
 

  In cell B11, insert the SUM function with a 3-D reference to calculate the   total Orchestra Front gross revenue (cell G9) for the Friday, Saturday, and   Sunday worksheets.

You are ready to insert a   function to calculate the total Orchestra Back gross revenue.
 

  In cell B12, insert the SUM function with a 3-D reference to calculate the   total Orchestra Back gross revenue (cell G14) for the Friday, Saturday, and   Sunday worksheets.

You are ready to insert a   function to calculate the total gross revenue for the Balcony.
 

  In cell B13, insert the SUM function with a 3-D reference to calculate the   total Balcony gross revenue (cell G19) for the Friday, Saturday, and Sunday   worksheets.

The worksheet contains a   circular error. Now you want to find and correct it.
 

  On the Totals worksheet, check for errors and correct the formula with the   circular reference.

Although the Totals worksheet   contains specified aggregated data, such as the number of seats sold and   gross revenue by section, you want to create another summary that   consolidates data from the three daily worksheets. In the Details worksheet,   you will list the detailed section seating and gross revenue by day for those   seating sections.
 

  In the Details worksheet, in cell A2, use the Consolidate tool to select and   add the range I10:J19 in the Friday, Saturday, and Sunday worksheets. Use the   top row and left column labels when consolidating data.

Now you want to format the   consolidated data.
 

  Select the range B2:D2. Apply bold and center horizontal alignment.

The third section of the Totals   worksheet needs to link to a value in another workbook.
 

  Open the Exp22_Excel_Ch09_Cum_TheatreVenue.xlsx   workbook. Go back to the Exp22_Excel_Ch09_Cum_Theatre.xlsx   workbook. In cell B17 on the Totals worksheet, insert a link to the Weekend   Evening value (cell C5) in the TheatreVenue workbook. Close the TheatreVenue   workbook.

In cell B19 in the Totals   worksheet, multiply the Weekend Evening Fee by the No. of Evening   Performances.

You want to create a validation   rule to prevent the user from entering too many seats sold. For now, you will   create a validation for just one input cell.
 

  Select the range C6:C8 in the Friday worksheet, create a validation rule to   allow whole numbers less than or equal to =B6. Enter the input message title Seats Sold and the input message Enter the   number of seats sold.   (including the period). Use the Stop alert with the error alert title Invalid   Number and the   error alert message The number of seats sold cannot exceed the total seats   in the section.   (including the period). Test the data validation by attempting to enter 360 in cell C7 and then cancel the   change. Copy the range C6:C8 in the Friday worksheet. Select the range   C11:C13. Use the Paste Special Validation to copy the validation settings.   Select the range C16:C18 and paste the validation again.

You want to unlock data-entry   cells so that the user can change the number of seats sold in the worksheets.   
 

  Group the Friday, Saturday, and Sunday worksheets. Select the ranges C6:C8,   C11:C13, and C16:C18 and unlock these cells.

Now that you unlocked data-entry   cells, you are ready to protect the worksheets to prevent users from changing   data in other cells.
 

  Individually, protect the Friday, Saturday, and Sunday worksheets using the   default allowances with the password Expl0r!ng.

Mark the workbook as final.
 

  Note: Mark as Final is not available in Excel for Mac. Instead, use Always   Open Read-Only on the Review tab.

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

Discuss in 500 words or more best practices for incident response in the cloud. Refer to at least one incidence response framework.

Use at least three sources. Use the Research Databases available from the Danforth Library not Google. Include at least 3 quotes from your sources enclosed in quotation marks and cited in-line by reference to your reference list.  Example: “words you copied” (citation) These quotes should be one full sentence not altered or paraphrased. Cite your sources using APA format. Use the quotes in your paragaphs.  Stand alone quotes will not count toward the 3 required quotes.

Copying without attribution or the use of spinbot or other word substitution software will result in a grade of 0. 

Write in essay format not in bulleted, numbered or other list format. 

#Exp19_Access_Ch02_HOEAssessment – Drama Club 1.0 

#Exp19 Access Ch02 HOEAssessment  Drama Club 1.0

#Access Chapter 2 Hands-On Exercise Assessment – Drama Club

#EX19_AC_CH02_GRADER_HOE_AS

Project Description:

You are the treasurer of the local drama club, and have begun to create a database of potential donors and volunteers for your organization. You discovered that some donations have already been made, but the records are stored in an Excel workbook. You use your newly gained knowledge of Access to create a relational database to track the donors and their donations. You will begin by importing the Excel workbook into the database. You will create a table from scratch to track the dates for which volunteers have signed up to help, create relationships between the tables, and then create some baseline queries.

Start Access. Open the   downloaded Access file named Exp19_Access_Ch2_HOEAssessment_Drama.   Grader has automatically added your last name to the beginning of the   filename. Save the file to the location where you are storing your files.

You will examine the data in the   downloaded Excel worksheet to determine which field will become the primary   key in the table and which field will become the foreign key so that you can   join it to the existing table in the database.
 

  Open the Donations.xlsx Excel   workbook, examine the data, and close the workbook.
 

  You will import the Excel workbook that contains donation information into   the database.
 

  Click the External Data tab, click   New Data Source, point to From File in the Import & Link   group, and then select Excel.   Navigate to and select the Donations.xlsx   workbook to be imported as a new table in the current database. Ensure that First Row Contains Column Headings is   selected. Set the DonationID field Indexed option to Yes (No Duplicates). Select DonationID   as the primary key when prompted and accept the table name Donations. Do not save the import   steps.

Change the Data Type of the   DonationID field to Short Text in   Design view of the Donations table. Set the Field Size of DonationID to 5. Set the Field Size of DonorID   to Long Integer. Save the changes   and open the table in Datasheet view. Close the table.

You will create a new table that   will enable the club to associate each donor who agrees to volunteer with   dates in the database.
 

  Create a new table in Design view. Add the following fields in Design view   and set the properties as specified:
 

  Add the primary key field as VolunteerID with the   AutoNumber Data Type and Number assigned to a new volunteer activity. (type the period) as the   Description. Set the Caption property to Volunteer ID.

   Add DonorID with the Number Data Type and Donor Volunteer as the Description. Set the Caption property to Donor ID and the Required property to Yes.

Add VolunteerDate with the Date/Time Data Type. Set the Caption property to Volunteer Date. Switch to Datasheet view and save the table as Volunteer   Dates when   prompted. You will enter data into the table in a later step. Close the   table.

You will create the   relationships between the tables using the Relationships window.
 

  Add all three tables to the Relationships window. Identify the primary key   field in the Donors table and join it with its foreign key counterparts in   the related Donations and Volunteer Dates tables. Select the Enforce Referential Integrity and Cascade Update Related Fields check boxes.   Save and close the Relationships window.

   You will add 8 records to the Volunteer Dates table so that you can test   referential integrity in the database.
 

  Add the following records to the Volunteer Dates table:

Donor ID

Volunteer Date

9

4/10/2021

9

4/24/2021

10

4/10/2021

10

4/24/2021

11

5/01/2021

11

5/08/2021

19

5/01/2021

20

5/08/2021

  Close the table.

Sort the records in the   Donations table by the DonationAmount field in descending order. Save and   close the table.

You will use the Simple Query   Wizard to create a query of all donors who indicate that they are willing to   volunteer.
 

  Add the Firstname, Lastname, Phone, and Volunteer   fields from Donors (in that order). Save the query as Donor   Volunteers.

Add a criterion in Design view   to select only donors with Yes in the Volunteer field.

Sort the query results in   ascending order by Lastname. Run, save, and close the query.

You will copy the Donor   Volunteers query and modify it to add an additional table and field.
 

  Copy the Donor Volunteers query   and paste it using Donor Volunteers and Dates as the query name.

You decide to hide the Volunteer   column from the query results, as the value repeats in every record of the   datasheet.
 

  Open the Donor Volunteers and Dates   query in Design view and in the Volunteer column, click the Show check box to deselect it.

You will add a field from a   related table to display whom has volunteered for which dates.
 

  Add the Volunteer Dates table to   the top pane of the query design window. Add the VolunteerDate field to the last column of the design grid. Run,   save, and close the query.

You will create a query that   identifies donors and their associated donations. Because there is a   relationship between the two tables, you can now pull data from each of them   together as usable information.
 

  Create a query in Design view that includes the Donors and Donations   tables. The query should list the Firstname and Lastname (in that order),   then the DonationAmount and the DonationDate (in that order).

   Sort the query by the DonationAmount in ascending order. Run, close, and save   the query as Donors and Amounts.

You determine that the data in   the Donor Volunteers and Dates query could be summarized with a Total row.   You will group the records by donor name, and then count the number of dates   that each has volunteered.
 

  Copy the Donor Volunteers and Dates   query and paste it using Summary of Volunteer Dates as the query name.

Open the Summary of Volunteer Dates query in Design view and delete the Firstname, Phone, and Volunteer   columns.

Click Totals in the Show/Hide group on the Query Tools Design tab.   Click in the Total row of the   VolunteerDate field, click the arrow,   and then select Count. The records   will be grouped by the last name and the dates for each one will be   summarized.

Modify the field name of the   VolunteerDate column as Date Count: VolunteerDate to make the field more   identifiable. Click Run in the   Results group (5 records display in the Datasheet). The results display the   date count for each last name. Save and close the query.

Close all database objects.   Close the database and then exit Access. Submit the database as directed.

All posts must be a minimum of 250 words. APA reference. 100% original work. no plagiarism.

1. Briefly discuss how the concept of workstation domains figure into your organization’s security policies, please list your references

2. Briefly discuss how the concept of LAN domains figure into your organization’s security policies, please list your references

Is the security function expected to propose their plans as a Business Case? Explain.

The programming Language is C++. It should be a three file structure. I have attached the guidelines of the project below.

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.

Steps to Perform:

Step

Instructions

Points    Possible

1

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.

0

2

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.

6

3

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.

5

4

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.

5

5

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.

4

6

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)

2

7

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.

4

8

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

5

9

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

3

10

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.

6

11

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.

1

12

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.

5

13

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

2

14

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

10

15

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.

5

16

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.

14

17

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

4

18

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.

6

19

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.

5

20

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

  Add primary minor vertical gridlines to the bar chart.

0

21

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

4

22

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.

4

23

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

0

Total   Points

100