, PLEASE USE THIS DOCUMENT AS A GUIDE ONLY
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.
Section A: Calculations
1. Use function “Average” to calculate the average score for all students (no decimals).
2. Insert “Lowest score” on A22:B22 (Merge, Left align), and use “MIN Function” to find the lowest score for all subjects.
3. Insert Highest score on A23:B23 (Merge, Left align), and use “MAX Function” to find the highest score for all subjects.
4. Insert a new column “Grades Status” after “Average score” column.
Use the following score condition for the grade status (use IFS function)
Distinction: Average score ≥ 75
Merit: Average Score ≥ 65 and < 7
Pass: Average Score ≥ 50 and < 65
Fail: Average Score < 50
Section B: Data Formatting
1. Format headers bold, centre Align, font size to 12pt.
2. Apply table design to the table (Dark Green, Table style Medium 4 or any green).
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).
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.
Section A: Calculations
1. Use function “Average” to calculate the average score for all students (no decimals).
2. Insert “Lowest score” on A22:B22 (Merge, Left align), and use “MIN Function” to find the lowest score for all subjects.
3. Insert Highest score on A23:B23 (Merge, Left align), and use “MAX Function” to find the highest score for all subjects.
4. Insert a new column “Grades Status” after “Average score” column.
Use the following score condition for the grade status (use IFS function)
Distinction: Average score ≥ 75
Merit: Average Score ≥ 65 and < 7
Pass: Average Score ≥ 50 and < 65
Fail: Average Score < 50
Section B: Data Formatting
1. Format headers bold, centre Align, font size to 12pt.
2. Apply table design to the table (Dark Green, Table style Medium 4 or any green).
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).
