Crowdly
Add to Chrome
INFORMATION SYSTEMS 511(2025S1IS511AD)
Looking for INFORMATION SYSTEMS 511(2025S1IS511AD) test answers and solutions? Browse our comprehensive collection of verified answers for INFORMATION SYSTEMS 511(2025S1IS511AD) at learning.richfield.ac.za.
Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!
SECTION D: MS EXCEL QUESTIONS FOUR(20 MARKS)
PRACTICAL EXCEL
1. Create a new workbook using the given data above and save the file with the name “Football player Marks “ Enter the following data into an Excel spreadsheet. 2. Assign a Grade based on the Final Marks using the following criteria: e,g Use the IF• A: 80–100• B: 70–79• C: 60–69• D: 50–59• F: below 503. At the bottom of the spreadsheet, calculate the following statistics for Final Marks:• Mode• Count• Maximum• Minimum 4. Calculate the Final Marks by adding CA, Assignment, and Exam marks. 5. Use a formula to determine if each student Passed or Failed. A pass is 50 or above in Final Marks. 6. Use a formula to calculate the Average Final Marks for each student. 7. Bold the header row. 8. Add a Total row at the bottom of the CA, Assignment, and Exam columns.
3.2 Define a computer network and explain how network communication applications such as email, instant messaging, VoIP, video conferencing, and collaborative tools have transformed modern communication practices. What are the key challenges organizations face when using these technologies?(15 Marks)
3.1 Describe and explain the importance of backup, explain the different backup options available for backing up computer resources and discuss the reasons for using backup.(15 Marks)
2.3 Define and provide a brief description of the following types of malware (viruses, worms, Trojans, spyware, ransomware).(10 MARKS)
2.2 Describe different types of wireless media, including their advantages and disadvantages are in terms of range, speed, and security.(10 marks)
2.1 Describe two types of knowledge and explain the six steps of the KMS Cycle,(10 marks)
1.5 Discuss the types of devices available that protect computers from system failure(4 Marks)
1.4 Define hackers and identify their types and how they operate(4 Marks)
1.2 Explain how Big Data can be put to use in business decision-making. Provide at least three practical applications of Big Data across different industries, including healthcare, marketing, human resources, or urban planning."(4 Marks)
1.3 Differentiate between a data warehouse and a mart(4 Marks)