EUP1501
Assignment 4 Semester 1 2026
Due Date: April 2026
TABLE OF CONTENTS
DETAILED STEP BY STEP GUIDELINES .................................................... 3
FINAL EXCEL ANSWER ............................................................................ 12
Terms of use
By making use of this document you agree to:
Use this document as a guide for learning, comparison and reference purpose,
Terms of use
Not to duplicate, reproduce and/or misrepresent the contents of this document as your own work,
By making use of this document you agree to:
Use this document
Fully accept the consequences
solely as a guide forshould you plagiarise
learning, reference,or and
misuse this document.
comparison purposes,
Ensure originality of your own work, and fully accept the consequences should you plagiarise or misuse this document.
Comply with all relevant standards, guidelines, regulations, and legislation governing academic and written work.
Disclaimer
Great care has been taken in the preparation of this document; however, the contents are provided "as is" without any express or
implied representations or warranties. The author accepts no responsibility or liability for any actions taken based on the
information contained within this document. This document is intended solely for comparison, research, and reference purposes.
Reproduction, resale, or transmission of any part of this document, in any form or by any means, is strictly prohibited.
, +27 81 278 3372
TABLE OF CONTENTS
DETAILED STEP BY STEP GUIDELINES.................................................... 3
FINAL EXCEL ANSWER ............................................................................ 12
Disclaimer
Great care has been taken in the preparation of this document; however, the contents are provided "as is"
without any express or implied representations or warranties. The author accepts no responsibility or
liability for any actions taken based on the information contained within this document. This document is
intended solely for comparison, research, and reference purposes. Reproduction, resale, or transmission
of any part of this document, in any form or by any means, is strictly prohibited.
, +27 81 278 3372
DETAILED STEP BY STEP GUIDELINES
Step 1: Create the dataset
In the spreadsheet, enter the headings in row 1 first:
A1: Student_ID
B1: Name
C1: Maths
D1: Programming
E1: Databases
F1: Networks
G1: AI
H1: Average Score
Then type all 20 students’ records underneath those headings exactly as shown in the
question, from row 2 to row 21.
That means:
Row 2 = S001 Alice ...
Row 3 = S002 Brian ...
Continue until
Row 21 = S020 Thabo ...
Do not type anything yet in the Average Score column because that will be calculated with a
formula.
Section A: Calculations
Question 1: Use AVERAGE to calculate the average score
for all students with no decimals
The marks for each student are in columns C to G.
Steps:
1. Click on cell H2.
2. Type this formula:
=ROUND(AVERAGE(C2:G2),0)
3. Press Enter.
Disclaimer
Great care has been taken in the preparation of this document; however, the contents are provided "as is"
without any express or implied representations or warranties. The author accepts no responsibility or
liability for any actions taken based on the information contained within this document. This document is
intended solely for comparison, research, and reference purposes. Reproduction, resale, or transmission
of any part of this document, in any form or by any means, is strictly prohibited.
Assignment 4 Semester 1 2026
Due Date: April 2026
TABLE OF CONTENTS
DETAILED STEP BY STEP GUIDELINES .................................................... 3
FINAL EXCEL ANSWER ............................................................................ 12
Terms of use
By making use of this document you agree to:
Use this document as a guide for learning, comparison and reference purpose,
Terms of use
Not to duplicate, reproduce and/or misrepresent the contents of this document as your own work,
By making use of this document you agree to:
Use this document
Fully accept the consequences
solely as a guide forshould you plagiarise
learning, reference,or and
misuse this document.
comparison purposes,
Ensure originality of your own work, and fully accept the consequences should you plagiarise or misuse this document.
Comply with all relevant standards, guidelines, regulations, and legislation governing academic and written work.
Disclaimer
Great care has been taken in the preparation of this document; however, the contents are provided "as is" without any express or
implied representations or warranties. The author accepts no responsibility or liability for any actions taken based on the
information contained within this document. This document is intended solely for comparison, research, and reference purposes.
Reproduction, resale, or transmission of any part of this document, in any form or by any means, is strictly prohibited.
, +27 81 278 3372
TABLE OF CONTENTS
DETAILED STEP BY STEP GUIDELINES.................................................... 3
FINAL EXCEL ANSWER ............................................................................ 12
Disclaimer
Great care has been taken in the preparation of this document; however, the contents are provided "as is"
without any express or implied representations or warranties. The author accepts no responsibility or
liability for any actions taken based on the information contained within this document. This document is
intended solely for comparison, research, and reference purposes. Reproduction, resale, or transmission
of any part of this document, in any form or by any means, is strictly prohibited.
, +27 81 278 3372
DETAILED STEP BY STEP GUIDELINES
Step 1: Create the dataset
In the spreadsheet, enter the headings in row 1 first:
A1: Student_ID
B1: Name
C1: Maths
D1: Programming
E1: Databases
F1: Networks
G1: AI
H1: Average Score
Then type all 20 students’ records underneath those headings exactly as shown in the
question, from row 2 to row 21.
That means:
Row 2 = S001 Alice ...
Row 3 = S002 Brian ...
Continue until
Row 21 = S020 Thabo ...
Do not type anything yet in the Average Score column because that will be calculated with a
formula.
Section A: Calculations
Question 1: Use AVERAGE to calculate the average score
for all students with no decimals
The marks for each student are in columns C to G.
Steps:
1. Click on cell H2.
2. Type this formula:
=ROUND(AVERAGE(C2:G2),0)
3. Press Enter.
Disclaimer
Great care has been taken in the preparation of this document; however, the contents are provided "as is"
without any express or implied representations or warranties. The author accepts no responsibility or
liability for any actions taken based on the information contained within this document. This document is
intended solely for comparison, research, and reference purposes. Reproduction, resale, or transmission
of any part of this document, in any form or by any means, is strictly prohibited.
