Assignments Reading Assignment Topic: Enterprise Asset Management in Cybersecurity Operations Output: Write a one-page analyst summary explaining: Why asset visibility matters. How SOC teams use asset information. How asset importance affects security decisions. Research Assignment Topic: Security Monitoring Practices in Financial Organisations Research: How financial organisations protect: Customer information Online services Employee systems Output: Industry […]
Class Activity 2
Security Monitoring Discovery Exercise The SOC manager provides a list of company systems. Your task: Identify: Which systems require continuous monitoring. Which systems contain sensitive information. Which systems could create serious business impact if compromised. Complete the Enterprise Monitoring Priority Worksheet.
Assignment 1
Assignments Reading Assignment Read about the role of Security Operations Centres and how SOC teams support enterprise cybersecurity operations. Output: Create a one-page summary explaining: What a SOC does. Why organisations require SOC teams. The responsibilities of Junior SOC Analysts. Research Assignment Research: “How financial institutions use Security Operations Centres to protect customer information and […]
Class Activity 1
You have joined the AVACOA Financial Services SOC team. Review the organisation description and identify: The most important business systems. The systems requiring continuous monitoring. The possible consequences if each system is compromised. Complete the Security Environment Discovery Worksheet.
Assignment 2
Reading Assignment Explain how Gantt Charts help project managers monitor project performance and communicate schedules with stakeholders. Research Assignment Research a major global project and analyze how poor schedule planning or critical path mismanagement contributed to delays. Hands-on Assignment (Real-Life Case) A logistics startup is launching a digital freight management platform that connects […]
Class Activity 2
Students will work in teams to analyze a project and perform the following: Create a task timeline using a Gantt Chart• Identify at least five project milestones• Develop a network diagram for project tasks• Calculate the project’s Critical Path• Identify tasks with float or slack
Assignment 2
Reading Assignment Read about how Pivot Tables are used in business reporting and dashboard creation. Research Assignment Research how companies use Pivot Charts in executive reporting and explain their advantages. Hands-On Practice Task A nationwide retail company wants to analyze its sales performance across different regions and time periods. The dataset includes product names, regions, […]
Class Activity 2
A retail company provides a dataset containing product, region, sales, and date. Students should: Create a Pivot Table to summarize total sales by product Create another Pivot Table for sales by region Build a Pivot Chart to visualize performance Group sales data by month
Assignment 1
Reading Assignment Study how Excel functions are used in financial reporting and sales analytics. Research Assignment Research the differences between VLOOKUP and XLOOKUP and explain why XLOOKUP is preferred in modern Excel. Hands-On Practice Task A supermarket chain wants to analyze its weekly sales performance across multiple branches. You are given a dataset containing product […]
Class Activity 1
A retail company has provided a dataset containing product names, sales values, and product IDs. Students should: Calculate total sales using SUM Determine average sales using AVERAGE Count total transactions using COUNT Classify sales using IF Retrieve product prices using VLOOKUP or XLOOKUP