AI, Networking & Data Management | Richfield Assignment
QUESTION 1
1.1.Critically explain four ways in which Artificial Intelligence enhances computer network security, with reference to modern cyber-threat environments. 4 Marks
1.2 Explain the importance of data management in modern organizations, conclude by explaining the fundamentals of relational database operations and their value in decision-making
1.3 Define ethics and explain its importance in the digital workplace and the concept of privacy. Use relevant examples to show how organizations can manage ethical and privacy issues.
1.4 Discuss the role of computer hardware and software, including input, processing, output, and storage devices
1.5 Describe the 4 types of cybercriminals 4 Marks
1.6 An organisation plans to implement AI-driven network automation tools to reduce operational costs. As a senior network consultant, critically analyse whether AI can replace human network engineers, or whether it should be used to augment them. Support your answer with relevant examples
2.1 You are employed as an Information Systems Officer at Richfield LTD. Senior management has requested you to prepare a professional internal report for staff development and training purposes entitled: “The Role of Artificial Intelligence, Networking, and Data Management in Modern Organizations.”
This internal report will be used to train new employees and must follow professional corporate documentation standards. It must be in Microsoft Word Format as below
1. Design a professional internal cover page including:
a) Report title- ”Richfield internal report”
b) Student name & student number
c) Institution name
d) Date
e) Richfield logo
2. Insert a header and footers
A. Header “ Document title
B. Footer – web -“ info@richfirld.ac.za ,Student number & page number
C. Generate an automatic Table of Contents to show headings for internal report and permit card.
2.2 Design Richfield parking permit card using Microsoft Word only attach screenshot on your word document assignment that shows the ribbons.
Instructions
1. Use page layout ”Land scape” , text formatting, tables, shapes, and watermark tools.
2. Font size: 18–24, Bold, Centre alignment, Shapes → Rounded Rectangle
3. Shape Fill: Very light colour
4. Create the Main Title Inside the Card : RICHFIELD PARKING PERMIT
5. Insert Personal Details Section
a) Full Name and Surname
b) ITS Number
c) Card number = Rich2026
d) Parking slot number = Level 2908 block 10
e) Issue Date = your Date of registration
f) Expiry Date: Last date of your course
6. Add Photo and Signature
7. Insert a Watermark ( Richfield logo)
You have been appointed as a Data Analyst at a company specializing in Artificial Intelligence Solutions. Management has requested a detailed analysis of the company’s monthly AI product sales data. Using Microsoft Excel, you are required to apply appropriate formulas and functions to evaluate performance and present your results in a professional business report format. You have been appointed as a Data Analyst at a company specializing in Artificial Intelligence Solutions. Management has requested a detailed analysis of the company’s monthly AI product sales data. Using Microsoft Excel, you are required to apply appropriate formulas and functions to evaluate performance and present your results in a professional business report format. Paste 2 screenshots to show formulas and calculated data.
| Product | Units Sold | Selling Price(R) | Cost Price (R) | Total Revenue | Total Cost | Profit | Profit Level (IF) |
| AI Chatbot License | 120 | 350 | 210 | R | R | ||
| Machine Learning Software | 95 | 480 | 300 | R | R | ||
| Facial Recognition System | 60 | 750 | 500 | R | R | ||
| AI Virtual Assistant | 140 | 290 | 180 | R | R | ||
| Predictive Analytics Tool | 85 | 620 | 400 | R | R | ||
| AI Cyber security System | 70 | 810 | 560 | R | R | ||
| Speech Recognition App | 160 | 260 | 150 | R | R | ||
| AI Image Generator | 110 | 430 | 270 | R | R | ||
| Autonomous Robot Module | 50 | 1200 | 850 | R | R | ||
| Smart Recommendation Engine | 130 | 310 | 190 | R | R | ||
| Minimum profit | R | ||||||
| Maximum profit | R | ||||||
| Mode | R | ||||||
| Average profit | R | ||||||
| Profit range | R | ||||||
1. Calculate Total Revenue= Units Sold * Selling Price.
2. Calculate Total Cost =Units Sold * Cost Price.
3. Calculating Profit =Total Revenue – Total Cost
4. Determine Profit Level using IF Statement, display “High “ if Profit is greater than R1000 otherwise, “ if profit is less than R1000, display “Low” ,_
5. Highlight all High-profit products in green and all Low-profit products in red.
6. Enter formulas to find Minimum profit, Maximum profit, Mode, Average, and Profit range.
7. Align all column title labels (horizontally left and vertically center) at the center 450. (45 degrees).
8. Sort products from highest to lowest profit
9. Add a new column named New Selling Price (10% Increase), calculating using a formula.= Old Selling Price *10%.
10. Create a column chart showing Profit Chart, add title, Axis labels and Data labels
Experts Answer on Above Questions on Artificial Intelligence
Artificial Intelligence and computer network security
Threat detection – with the help of AI, it is possible to analyse network traffic and determine any unusual behaviour, which will help in detecting attacks such as ransomware and intrusion attempts.
Real time threat response – by utilising AI, it is possible to isolate compromised devices or block suspicious connections, which will help in reducing response time during attacks.
Anomaly detection – machine learning models help in flagging deviations that conventional rule based security may miss.
Predictive security – by using AI, it is possible to analyse historical attack data which will help in identifying emerging threats and vulnerabilities.
Data management and relational databases
With effective deter management, it is possible to efficiently manage the information in an accurate, secure, consistent and accessible way, which can be used for analysis. It helps in preventing duplicacy or any kind of unreliable information. A relational database stores information in tables, and data is used using primary keys and foreign keys. The basic operations that can be carried out include create, read, update and delete, which is performed using SQL.
Ethics and privacy
Ethics indicates the principles that highlight what is right and responsible, and it is useful for organisations in handling employee and customer data in a responsible way. Privacy concerns indicate the right of an individual to control the ways in which the personal information is collected, used, stored and shared. The effective management needs privacy policy, access control, employee training, data protection measures and responsible AI governance.
Computer hardware and software
It includes input like keyboard, mouse, microphone etc, processing through CPU and RAM, output in the form of monitor, printer and speakers, storage like SDDs, HDDs and USB devices, and software like operating systems.
4 types of Cyber criminal
The four different types of cyber criminals are black hat hackers, script kiddies, insiders and organised criminals.
Can AI replace network engineers
AI should augment rather than replace human network engineers. With the application of AI, it is possible to automate repetitive tasks, but human engineers are essential for architecture, complex fault diagnosis, risk assessment, cyber security decisions and accountability.
Internal report
The role of artificial intelligence, networking, and data management in modern organisation
Organisation is Richfield Ltd and the report type is internal staff development and training report.
Suggested table of content
Introduction
Artificial intelligence in modern organisation
AI and network security
Networking in modern organisations
Data management and relational databases
Digital ethics and privacy
Computer hardware and software
Cyber criminals and cyber security
AI network automation
Conclusion
Header – richfield internal report
Footer – student number| page number
Excel sales analysis
The calculations are performed in the Excel sheet and the results indicate that the minimum profit is R15000, maximum profit is R18700, Mode is R17500, average profit is R16880 and profit range is R3700
All the 10 products are high because every profit exceeds R1000
The highest to lowest profit order is indicated below:
Predictive analytics tool
Speech recognition app
AI Image generator
AI cyber security system
Autonomous Robot module
Machine learning software
AI chatbot license
Smart recommendation engine
AI virtual assistant
Facial recognition
| Disclaimer: This answer is a model for study and reference purposes only. Please do not submit it as your own work. |
Want Detailed Answers with References?
An analysis of AI network security, data management, digital ethics, computer system, cyber criminals and AI automation above revealed important findings about the role and implication of AI in managing data. With our professional information management experts in South Africa, get help with your AI networking assignment by visiting our assignment help homepage. Also access the expert written assignment from Richfield before ordering your assignment.
