Crowdly
Додати до Chrome
INFORMATION SYSTEMS 511(2025S1IS511AD)
Шукаєте відповіді та рішення тестів для INFORMATION SYSTEMS 511(2025S1IS511AD)? Перегляньте нашу велику колекцію перевірених відповідей для INFORMATION SYSTEMS 511(2025S1IS511AD) в learning.richfield.ac.za.
Отримайте миттєвий доступ до точних відповідей та детальних пояснень для питань вашого курсу. Наша платформа, створена спільнотою, допомагає студентам досягати успіху!
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)