EUP1501 Assignment 4 (COMPLETE ANSWERS) Semester 1 2026

Ethical Information and Communication Technologies for Development Solutions - EUP1501 Assignment 4 Semester 1 2026; 100 % TRUSTED workings, Expert Solved, Explanations and Solutions. For assistance call or W.h.a.t.s.a.p.p us on ...(.+.2.5.4.7.7.9.5.4.0.1.3.2)........... EUP1501 Semester 1 2026 Formative Assessment 4 Total Grade: 50 This practical assessment is designed to evaluate students' proficiency in Microsoft Excel by testing their ability to apply key functions, formulas, and data analysis tools to solve real-world problems and manage datasets effectively. Read the instructions carefully. Scenario You are the Class Administrator for BSc Computer Science (Year 1), and you are responsible for managing and analysing academic performance data for 20 students across five modules: Mathematics, Programming, Databases, Computer Networks, and Artificial Intelligence (AI). The faculty requires a professional Excel workbook that automatically analyses student performance and supports academic decision-making. Open a blank spreadsheet. Create the Student Marks Dataset using the data provided below, and complete the tasks: [5] Student_ID Name Maths Programming Databases Networks AI Average Score S001 Alice 78 85 69 72 80 S002 Brian 45 58 60 55 50 S003 Carol 90 92 88 91 95 S004 David 66 64 70 62 68 S005 Emma 82 76 79 81 77 S006 Farai 49 47 52 45 50 S007 Grace 59 61 55 60 58 S008 Hakeem 74 73 71 70 69 S009 Isabella 95 98 94 96 97 S010 Jason 38 42 35 40 45 S011 Khanyi 68 65 63 70 64 S012 Liam 55 53 50 58 52 S013 Maria 72 70 68 75 73 S014 Nthabiseng 81 85 79 80 84 S015 Oliver 60 59 58 62 61 S016 Priya 88 90 85 87 89 S017 Quinn 47 49 46 44 48 S018 Rudo 69 67 66 65 64 S019 Sipho 52 50 48 54 56 S020 Thabo 76 74 73 72 75 Section A: Calculations [25] 1. Use function “Average” to calculate the average score for all students (no decimals). [5] 2. Insert “Lowest score” on A22:B22 (Merge, Left align), and use “MIN Function” to find the lowest score for all subjects. [5] 3. Insert Highest score on A23:B23 (Merge, Left align), and use “MAX Function” to find the highest score for all subjects. [5] 4. Insert a new column “Grades Status” after “Average score” column. [10] Use the following score condition for the grade status (use IFS function) • Distinction: Average score ≥ 75 • Merit: Average Score ≥ 65 and 75 • Pass: Average Score ≥ 50 and 65 • Fail: Average Score 50 Section B: Data Formatting [10] 1. Format headers bold, centre Align, font size to 12pt. [2] 2. Apply table design to the table (Dark Green, Table style Medium 4 or any green). [4] 3. Insert a new row above the 1st row. On A1 type BSc 1st year Final Marks. Font size: 14pt, Bold. Merge and centre align (AI:I1). [4] Section C: Data Analysis [8] 1. Create a Column Chart “2D”. - Use only 1st 10 Students - Column: Name, Maths, Programming, Databases, Networks, and AI. - Label it (Chart title) “Student Performance Summary” Save the spreadsheet as Surname-StudentNumber (e.g. Brown_123456) and upload (Do not convert to pdf) [2] _________________________________________________________________________________