Subtask 1: Create a MS Access database. Subtask 2: Create a chart. Subtask 3: Create a PowerPoint presentation template.

Computer Science
Subtask 1: Create a MS Access database. Subtask 2: Create a chart. Subtask 3: Create a PowerPoint presentation template.

ScanSolve AI Answer

Here's how to complete Subtask 2: Create a chart.

Step 1: Calculate the "Increased Amount" for each cyber threat. The increased amount is found by subtracting the "PRESENT" value from the "FUTURE" value.

  • DDoS attacks: 6961=869 - 61 = 8
  • Compromised third parties: 5250=252 - 50 = 2
  • Android malware: 4235=742 - 35 = 7
  • Nation-state attacks: 4526=1945 - 26 = 19
  • Cyber extortion: 4219=2342 - 19 = 23
  • Clickjacking: 2419=524 - 19 = 5

Step 2: Complete the spreadsheet with the calculated "Increased Amount".

THREATPRESENTFUTUREINCREASED AMOUNTDDoS attacks61698Compromised third parties50522Android malware35427Nation-state attacks264519Cyber extortion194223Clickjacking19245\begin{array}{|l|c|c|c|} \hline \textbf{THREAT} & \textbf{PRESENT} & \textbf{FUTURE} & \textbf{INCREASED AMOUNT} \\ \hline \text{DDoS attacks} & 61 & 69 & \textbf{8} \\ \text{Compromised third parties} & 50 & 52 & \textbf{2} \\ \text{Android malware} & 35 & 42 & \textbf{7} \\ \text{Nation-state attacks} & 26 & 45 & \textbf{19} \\ \text{Cyber extortion} & 19 & 42 & \textbf{23} \\ \text{Clickjacking} & 19 & 24 & \textbf{5} \\ \hline \end{array}

Step 3: Create an embedded pie chart in Excel. To create the pie chart displaying the increased amount of all threats:

  • Enter the data from the completed table into an Excel spreadsheet.
  • Select the "THREAT" column and the "INCREASED AMOUNT" column.
  • Go to the "Insert" tab, then select "Pie Chart" from the Charts group.
  • Add an appropriate chart title, such as "Increased Cyber Threats".
  • Add data labels to show the specific increased amount for each slice of the pie.
  • Ensure a legend is visible to identify which threat corresponds to which color slice.
  • Embed the chart below the spreadsheet data.
Was this helpful?

Still stuck on this one?

Ask a follow-up, and the answer starts from this question.

Got a different question?Ask your own question
Handwritten step-by-step solution preview

Handwritten Step-by-Step Solution

Get this as a handwritten image on WhatsApp — like a tutor wrote it for you.

Try on WhatsApp