Students,
This homework has to be completed on 24 FEBRUARY 2012, FRIDAY.
You have done a group work on ACTIVITY 5.4, page 65. I hope you get the positive feedback of doing it collaboratively.
Your homework is focused on ACTIVITY 5.4.1. Before this you have worked on the FORMULAE. COMPLETE the activity by ANSWERING ALL THE UNANSWERED QUESTIONS LEFT.
………………………………..
??HOW TO DO??
INSTRUCTION: You must do this activity using ONLY Microsoft Office Excel, no calculator is allowed.
STEP 1 – Continue with your SAVED EXCEL FILE.
STEP 2 – Do calculations by entering the FUNCTION in appropriate cell for all the questions.
STEP 3 – SAVE your work as “Activity 5.4.1 FUNCTION -your name” in pendrive. (for your next class purpose)
STEP 4 – E-mail your work to qistinah.jalil@ripas.moe.edu.bn (It is for my copy to verify your answer)
STEP 5 -Once you figured out the answer, PRESS “Leave a comment” in THIS POST and start TYPING YOUR ANSWER as format below:
Formulae and functions: “SUM”
1. Total marks for Maths: ‘your answer’
Function for Maths:’your answer’
…………
Total marks for English: ‘your answer’
Function for English: ‘your answer’
………..
……….
……
and the rest of the subjects.
2. Total marks for Angelina Jolie: ‘your answer’
Function for Angelina Jolie: ‘your answer’
…………
Total marks for Brad Pitt: ‘your answer’
Function for Brad Pitt: ‘your answer’
…………
…….
….
and the rest of the students.
Functions: “AVERAGE”
1. Average marks for Maths: ‘your answer’
Function for Maths:’your answer’
…………
Average marks for English: ‘your answer’
Function for English: ‘your answer’
………..
……….
……
and the rest of the subjects.
2. Average marks for Angelina Jolie: ‘your answer’
Function for Angelina Jolie: ‘your answer’
…………
Average marks for Brad Pitt: ‘your answer’
Function for Brad Pitt: ‘your answer’
…………
…….
….
and the rest of the students.
Functions: “MAX, MIN, and COUNT”
1. Maximum marks for Maths: ‘your answer’
Function for Maths:’your answer’
…………
Maximum marks for English: ‘your answer’
Function for English: ‘your answer’
………..
……….
……
and the rest of the subjects.
Minimum marks for Maths: ‘your answer’
Function for Maths:’your answer’
…………
Minimum marks for English: ‘your answer’
Function for English: ‘your answer’
………..
……….
……
and the rest of the subjects.
2. Count data for Maths: ‘your answer’
Function for Maths:’your answer’
…………
Count data for English: ‘your answer’
Function for English: ‘your answer’
………..
……….
……
and the rest of the subjects.
DUEDATE!! As you can see on the right >>>
computer_resources 
FORMULA AND FUNCTION: “sum”
1. TOTAL MARKS FOR EACH SUBJECT:
– Maths = 358
Formula: =C5+C6+C7+C8+C9+C10
– Eng = 479
Formula: =D5+D6+D7+D8+D9+D10
– Science = 277
Formula: =E5+E6+E7+E8+E9+E10
– Computer = 332
Formula: =F5+F6+F7+F8+F9+F10
– D&T = 380
Formula: =G5+G6+G7+G8+G9+G10
2. TOTAL MARKS FOR EACH STUDENT:
– Angelina Jolie = 378
Formula: =C5+D5+E5+F5+G5
– Brad Pitt = 436
Formula: =C6+D6+E6+F6+G6
– Nicholas Cage = 340
Formula =C7+D7+E7+F7+G7
– Eddie Murphy = 215
Formula: =C8+D8+E8+F8+G8
– Melissa Joan Hart = 150
Formula: =C9+D9+E9+F9+G9
– Freddie Prince JR = 307
Formula: =C10+D10+E10+F10+G10
FUNCTION: “average”
1. AVERAGE MARKS FOR EACH SUBJECT:
– Maths = 71.6
Function: =AVERAGE(C5:C10)
– English = 79.83333333
Function: =AVERAGE(D5:D10)
– Science = 55.4
Function: =AVERAGE(E5:E10)
– Computer = 66.4
Function: =AVERAGE(F5:F10)
– D&T = 63.33333333
Function: =AVERAGE(G5:G10)
2. AVERAGE MARKS FOR EACH STUDENT:
– Angelina Jolie = 75.6
Function: =AVERAGE(C5:G5)
– Brad Pitt = 87.2
Function: =AVERAGE(C6:G6)
– Nicholas Cage = 85
Function: =AVERAGE(C7:G7)
– Eddie Murphy = 53.75
Function: =AVERAGE(C8:G8)
– Melissa Joan Heart = 37.5
Function: =AVERAGE(C9:G9)
– Freddie Prince JR = 61.4
Function: =AVERAGE(C10:G10)
FUNCTION: “max, min and count”
1. MAXIMUM MARKS:
– Maths = 85
Function: =MAX(C5:C10)
– English = 95
Function: =MAX(D5:D10)
– Science = 87
Function: =MAX(E5:E10)
– Computer = 92
Function: =MAX(F5:F10)
– D&T = 90
Function: =MAX(G5:G10)
2. MINIMUM MARKS:
– Maths = 50
Function: =MIN(C5:C10)
– English = 43
Function: =MIN(D5:D10)
– Science = 29
Function: =MIN(E5:E10)
– Computer = 30
Function: =MIN(F5:F10)
– D&T = 37
Function: =MIN(G5:G10)
3. COUNT:
– Maths = 5
Function: =COUNT(C5:C10)
– English = 6
Function: =COUNT(D5:D10)
– Science = 5
Function: =COUNT(E5:E10)
– Computer = 5
Function: =COUNT(F5:F10)
– D&T = 6
Function: =COUNT(G5:G10)
Just as stated on above instruction, it asked you to follow following format:
Formulae and functions: “SUM”
1. Total marks for Maths: ‘your answer’
Function for Maths:’your answer’
…………
Total marks for English: ‘your answer’
Function for English: ‘your answer’
………..
……….
……
and the rest of the subjects.
2. Total marks for Angelina Jolie: ‘your answer’
Function for Angelina Jolie: ‘your answer’
…………
Total marks for Brad Pitt: ‘your answer’
Function for Brad Pitt: ‘your answer’
…………
…….
….
and the rest of the students.
I have checked your EXCEL file, you can already make changes on cells for Formulae for TOTAL MARKS FOR EACH SUBJECT and TOTAL MARKS FOR EACH STUDENT by REPLACING the FORMULAE into FUNCTION.
Is it clear to you…?
Nurnaqiqah,
There’s a little correction for you… On ‘FORMULA AND FUNCTION: “sum”’, you should ONLY FOCUS on FUNCTION, since you have answered on FORMULA part in HOMEWORK FOR WEEK 6.
So, please do make changes… 😀
Functions: “AVERAGE”
1. Average marks for Maths: 71.6
Function for Maths: =AVERAGE(C5:C10)
Average marks for English: 79.83333333
Function for English: =AVERAGE(D5:D10)
Average marks for Science: 55.4
Function for Science: =AVERAGE(E5:E10)
Average marks for Computer: 66.4
Function for Computer: =AVERAGE(F5:F10)
Average marks for D&T: 63.33333333
Function for D&T: =AVERAGE(G5:G10)
2. Average marks for Angelina Jolie: 75.6
Function for Angelina Jolie: =AVERAGE(C5:G5)
Average marks for Brad Pitt: 87.2
Function for Brad Pitt: =AVERAGE(C6:G6)
Average marks for Nicholas Cage: 85
Function for Nicholas Cage: =AVERAGE(C7:G7)
Average marks for Eddie Murphy: 53.75
Function for Eddie Murphy: =AVERAGE(C8:G8)
Average marks for Melissa Joan Hart: 37.5
Function for Melissa Joan Hart: =AVERAGE(C9:G9)
Average marks for Freddie Prince JR: 61.4
Function for Freddie Prince JR: =AVERAGE(C10:G10)
Functions: “MAX, MIN, and COUNT”
1. Maximum marks for Maths: 85
Function for Maths: =MAX(C5:C10)
Maximum marks for English: 95
Function for Maths: =MAX(D5:D10)
Maximum marks for Science: 87
Function for Science: =MAX(E5:E10)
Maximum marks for Computer: 92
Function for Computer: =MAX(F5:F10)
Maximum marks for D&T: 90
Function for D&T: =MAX(G5:G10)
Minimum marks for Maths: 50
Function for Maths: =MIN(C5:C10)
Minimum marks for English: 43
Function for English: =MIN(D5:D10)
Minimum marks for Science: 29
Function for Science: =MIN(E5:E10)
Minimum marks for Computer: 30
Function for Computer: =MIN(F5:F10)
Minimum marks for D&T: 37
Function for D&T: =MIN(G5:G10)
2. Count data for Maths: 5
Function for Maths: =COUNT(C5:C10)
Count data for English: 6
Function for English: =COUNT(D5:D10)
Count data for Science: 5
Function for Science: =COUNT(E5:E10)
Count data for Computer: 5
Function for Computer: =COUNT(F5:F10)
Count data for D&T: 6
Function for D&T: =COUNT(G5:G10)
Nurnaqiqah,
You’ve been confused. What I mean is you need to do correction ONLY for sub-topic “Formulae and Functions:SUM”.
If you see the questions on sub-topic “Formulae and Functions:SUM”, it is asking for ‘Formulae’ and ‘Functions’. You have answered the Formulae part during previous homework, so FOR THIS WEEK, your HOMEWORK only focused on “FUNCTIONS”
Are you clear…? 😀
Functions: “SUM”
1. Total marks for Maths: 358
Function for Maths: =SUM(C5:C10)
Total marks for English: 479
Function for English: =SUM(D5:D10)
Total Marks for Science: 277
Function for Science: =SUM(E5:E10)
Total marks for Computer: 332
Function for Computer: =SUM(F5:F10)
Total marks for D&T: 380
Function for D&T: =SUM(G5:G10)
2. Total marks for Angelina Jolie: 378
Function for Angelina Jolie: =SUM(C5:G5)
Total marks for Brad Pitt: 436
Function for Brad Pitt: =SUM(C6:G6)
Total marks for Nicholas Cage: 340
Function for Nicholas Cage: =SUM(C7:G7)
Total marks for Eddie Murphy: 215
Function for Eddie Murphy: =SUM(C8:G8)
Total marks for Melissa Joan Hart: 150
Function for Melissa Joan Hart: =SUM(C9:G9)
Total marks for Freddie Prince JR: 307
Function for Freddie Prince JR: =SUM(C10:G10)
Functions: “AVERAGE”
1. Average marks for Maths: 71.6
Function for Maths: =AVERAGE(C5:C10)
Average marks for English: 79.83333333
Function for English: =AVERAGE(D5:D10)
Average marks for Science: 55.4
Function for Science: =AVERAGE(E5:E10)
Average marks for Computer: 66.4
Function for Computer: =AVERAGE(F5:F10)
Average marks for D&T: 63.33333333
Function for D&T: =AVERAGE(G5:G10)
2. Average marks for Angelina Jolie: 75.6
Function for Angelina Jolie: =AVERAGE(C5:G5)
Average marks for Brad Pitt: 87.2
Function for Brad Pitt: =AVERAGE(C6:G6)
Average marks for Nicholas Cage: 85
Function for Nicholas Cage: =AVERAGE(C7:G7)
Average marks for Eddie Murphy: 53.75
Function for Eddie Murphy: =AVERAGE(C8:G8)
Average marks for Melissa Joan Hart: 37.5
Function for Melissa Joan Hart: =AVERAGE(C9:G9)
Average marks for Freddie Prince JR: 61.4
Function for Freddie Prince JR: =AVERAGE(C10:G10)
Functions: “MAX, MIN, and COUNT”
1. Maximum marks for Maths: 85
Function for Maths: =MAX(C5:C10)
Maximum marks for English: 95
Function for Maths: =MAX(D5:D10)
Maximum marks for Science: 87
Function for Science: =MAX(E5:E10)
Maximum marks for Computer: 92
Function for Computer: =MAX(F5:F10)
Maximum marks for D&T: 90
Function for D&T: =MAX(G5:G10)
Minimum marks for Maths: 50
Function for Maths: =MIN(C5:C10)
Minimum marks for English: 43
Function for English: =MIN(D5:D10)
Minimum marks for Science: 29
Function for Science: =MIN(E5:E10)
Minimum marks for Computer: 30
Function for Computer: =MIN(F5:F10)
Minimum marks for D&T: 37
Function for D&T: =MIN(G5:G10)
2. Count data for Maths: 5
Function for Maths: =COUNT(C5:C10)
Count data for English: 6
Function for English: =COUNT(D5:D10)
Count data for Science: 5
Function for Science: =COUNT(E5:E10)
Count data for Computer: 5
Function for Computer: =COUNT(F5:F10)
Count data for D&T: 6
Function for D&T: =COUNT(G5:G10)
Nurnaqiqah,
You’ve scored full marks!! WOOOOWWW!! Outstanding work you’ve got, very good!!
You have followed all the instructions very well…Keep it up girl!!
Functions : ‘Average’
1) Average marks for Maths: 71.6
Function for Maths: =AVERAGE(C3:C8)
Average marks for English: 79.83
Function for English: =AVERAGE(D3:D8)
Average marks for Science: 55.4
Function for Science: =AVERAGE(E3:E8)
Average marks for Computer: 66.4
Function for Computer: =AVERAGE(F3:F8)
Average marks for D&T: 69.33
Funtion for D&T: =AVERAGE(G3:G8)
2) Average marks for Angelina Jolie: 75.6
Function for Angelina Jolie: =AVERAGE(C3:G3)
Average marks for Brad Pitt: 87.2
Function for Bard Pitt: =AVERAGE(C4:G4)
Average marks Nicholas Cage: 85
Functions for Nicholas Cage: =AVERAGE(C5:G5)
Average marks for Eddie Murphy: 62.74
Functions for Eddie Murphy: =AVERAGE(C6:G6)
Average marks for Melissa Joan Hart: 37.5
Functions for Melissa Joan Hart: =AVERAGE(C7:G7)
Average marks for Freddie Prince JR: 61.4
Functions for Freddie Prince JR: =AVERAGE(C8:G8)
Funtions : ‘MAX,MIN and COUNT’
1) Maximum marks for Maths: 85
Functions for maths: =MAX(C3:C8)
Maximum marks for English: 95
Funtions for English: =MAX(D3:D8)
Maximum marks for Science: 95
Functions for Science: =MAX(E3:E8)
Maximum Marks for Computer: 92
Functions for Computer: =MAX(F3:F8)
Maximum marks for D&T: 90
Functions for D&T: =MAX(G3:G8)
Minimum marks for Maths: 50
Functions for Maths: =MIN(C3:C8)
Minimum marks for English: 43
Functions for English: =MIN(D3:D8)
Minimum marks for Science: 29
Funtions for Science: =MIN(E3:E8)
Minimum marks for Computer: 30
Function for Computer: =MIN(F3:F8)
Minimum marks for D&T: 48
Functions for D&T: =MIN(G3:G8)
2) Count data for Maths: 5
Functions for maths: =COUNT(C3:C8)
Count data for English: 6
Functions for English: =COUNT(D3:D8)
Count data for Science: 5
Functions for Science: =COUNT(E3:E8)
Count data for Computer: 5
Functions for Computer: =COUNT(F3:F8)
Count data for D&T:6
Funtions for D&T: =COUNT(G3:G8)
NOrafazirah,
Please do FUNCTION for TOTAL MARKS FOR EACH SUBJECT and TOTAL MARKS FOR EACH STUDENT. Previous homework, you did FORMULAE. Now, for this homework you have to change the FORMULA into FUNCTION.
please re-send your EXCEL file after you make changes. Are you clear?
NOrafazirah,
Please do make sure before you send your EXCEL MAIL via e-mail, you save your EXCEL FILE in EXCEL type bCos I can’t open your file..
Norafazirah,
I wonder why your answers in this blog are TOTALLY DIFFERENT from your excel file for “RANGE” PART? Did you give me a wrong one? I guess so…
However, I gave you 1/2 marks for all those different answers. You have scored 59 and 1/2 out of 76. You will be EXCELLENT if you focus on what you are doing. Sooo…girl, please be attentive next time.. 🙂
I also deduct mark for wrong ‘file name’ of Excel file.
A)FORMULA AND FUNCTION: “sum”(total mark for each subject)
1)TOTAL MARKS FOR MATHS =358
FUNCTION=SUM(C5:C10)
2)TOTAL MARKS FOR ENG= 479
FUNCTION =SUM(D5:D10)
3)TOTAL MARKS FOR SCIENCE =277
FUNCTION=SUM(D3:D8)
4)TOTAL MARKS FOR COMPUTER=332
FUNCTION=SUM(E5:E10)
5)TOTAL MARKS FOR D&T=380
FUNCTION=SUM(F5:F10)
B) TOTAL MARKS FOR EACH STUDENT:
1)TOTAL MARKS FOR ANGELINA JOLIE =75.6
FUNCTION=SUM(C5:G5)
2)TOTAL MARKS FOR BRAD PITT=87.2
FUNCTION=SUM (C6:G6)
3)TOTAL MARK FOR NICHOLAS CAGE=85
FUNCTION SUM(C7:G7)
4)TOTAL MARK FOR EDDIE MURPHY =53.75
FUNCTION SUM(C8:G8)
5)TOTAL MARK FOR MELISSA JOAN HEART=37.5
FUNCTION SUM(C9:G9)
6)TOTAL MARK FOR FREDDIE PRINCE JR=61.4
FUNCTION SUM(C10:G10)
C)FUNCTION: “average”( AVERAGE MARKS FOR EACH SUBJECT)
1)AVERAGE MARKS Maths = 71.6
Function: =AVERAGE(C5:C10)
2)English = 79.83333333
Function: =AVERAGE(D5:D10)
3) AVERAGE MARKS Science = 55.4
Function: =AVERAGE(E5:E10)
4)AVERAGE MARKS Computer = 66.4
Function: =AVERAGE(F5:F10)
5)AVERAGE MARKS D&T = 63.33333333
Function: =AVERAGE(G5:G10)
D).AVERAGE MARKS FOR EACH STUDENT:
1)AVERAGE MARKS FOR Angelina Jolie = 75.6
Function: =AVERAGE(C5:G5)
2)AVERAGE MARKS FOR Brad Pitt = 87.2
Function: =AVERAGE(C6:G6)
3) AVERAGE MARKS FOR Nicholas Cage = 85
Function: =AVERAGE(C7:G7)
4)AVERAGE MARKS FOR Eddie Murphy = 53.75
Function: =AVERAGE(C8:G8)
5) AVERAGE MARKS FOR Melissa Joan Heart = 37.5
Function: =AVERAGE(C9:G9)
6)AVERAGE MARKS FOR Freddie Prince JR = 61.4
Function: =AVERAGE(C10:G10)
E)FUNCTION: “max, min and count”(MAXIMUM MARKS )
1)MAXIMUM MARKS FOR Maths = 85
Function: =MAX(C5:C10)
-2) MAXIMUM MARKS FOR English = 95
Function: =MAX(D5:D10)
3) MAXIMUM MARKS FOR Science = 87
Function: =MAX(E5:E10)
4)MAXIMUM MARKS FOR Computer = 92
Function: =MAX(F5:F10)
5)MAXIMUM MARKS FOR D&T = 90
Function: =MAX(G5:G10)
B). MINIMUM MARKS :
1)MINIMUM MARKS FOR Maths = 50
Function: =MIN(C5:C10)
2)MINIMUM MARKS FOR English = 43
Function: =MIN(D5:D10)
3)MINIMUM MARKS FOR Science = 29
Function: =MIN(E5:E10)
4) MINIMUM MARKS FOR Computer = 30
Function: =MIN(F5:F10)
5)MINIMUM MARKS FOR D&T = 37
Function: =MIN(G5:G10)
C) COUNT:
1)COUNT FOR Maths = 5
Function: =COUNT(C5:C10)
2)COUNT FOR English = 6
Function: =COUNT(D5:D10)
3)COUNT FOR Science = 5
Function: =COUNT(E5:E10)
4)COUNT FOR Computer = 5
Function: =COUNT(F5:F10)
5)COUNT FOR D&T = 6
Function: =COUNT(G5:G10)
Jin Ming,
Thank you for being early in handing your work. I have received your e-mail too… Happy Independence Day!!
Jin Ming,
I wonder why the RANGE of your cell for every FUNCTIONS in this blog are different from you EXCEL FILE? Perhaps, you give me a wrong EXCEL FILE.
Do you check it very carefully before you write down your answer in this blog?
However, I gave you 1/2 for those different answers. You’ve scored 50 and 1/2 out of 76. Not bad, boy… I also deducted 1 mark for the wrong FILE NAME.
The filename should be typed in “Activity 5.4.1 FUNCTION – Jin Ming” NOT “Book1 original’.
I would like to remind you to be focus on everything that you do, to avoid any careless mistake.
FORMULA & FUNCTION.
A) TOTAL MARKS FOR EACH STUDENTS.
1. ANGELINA JOLIE = 378.
FORMULA ; =SUM(C3:G3)
2. BRAD PITT = 436.
FORMULA ; =SUM(C4:G4)
3. NICHOLAS CAGE = 340.
FORMULA ; =SUM(C5:G5)
4. EDDIE MURPHY = 215.
FORMULA ; =SUM(C6:G6)
5. MELISSA JOAN HART = 150.
FORMULA ; =SUM(C7:G7)
6. FREDDIE PRINCE JR = 307.
FORMULA ; =SUM(C8:G8)
B) TOTAL MARKS FOR EACH SUBJECTS.
1. TOTAL MARKS FOR MATHS = 358
FUNCTION ; =SUM(C3:C8)
2. TOTAL MARKS FOR ENGLISH = 479
FUNCTION ; =SUM(D3;D8)
3. TOTAL MARKS FOR SCIENCE = 277
FUNCTION ; =SUM(E3:E8)
4. TOTAL MARKS FOR COMPUTER = 332
FUNCTION ; =SUM(F3:F8))
5. TOTAL MARKS FOR D&T = 380
FUNCTION ; =SUM(G3:G8)
C) AVERAGE MARKS FOR EACH SUBJECTS.
1. AVERAGE MARKS MATHS = 71.6
Function ; =AVERAGE(C3:C8)
2. AVERAGE MARKS FOR ENGLISH = 79.83333
Function ; =AVERAGE(D3:D8)
3. AVERAGE MARKS SCIENCE = 55.4
Function ; =AVERAGE(E3:E8)
4. AVERAGE MARKS COMPUTER = 66.4
Function ; =AVERAGE(F3:F8)
5. AVERAGE MARKS D&T = 63.33333
Function ; =AVERAGE(G3:G8)
D) AVERAGE MARKS FOR EACH STUDENTS.
1. AVERAGE MARKS FOR ANGELINA JOLIE = 75.6
Function ; =AVERAGE(C3:G3)
2. AVERAGE MARKS FOR BRAD PITT = 87.2
Function ; =AVERAGE(C4:G4)
3. AVERAGE MARKS FOR NICHOLAS CAGE= 85
Function: =AVERAGE(C5:G5)
4. AVERAGE MARKS FOR EDDIE MURPHY = 53.75
Function: =AVERAGE(C6:G6)
5. AVERAGE MARKS FOR MELISSA JOAN HART = 37.5
Function ; =AVERAGE(C7:G7)
6)AVERAGE MARKS FOR FREDDIE PRINCE JR = 61.4
Function ; =AVERAGE(C8:G8)
E) MAXIMUM MARKS.
1. MAXIMUM MARKS FOR MATHS = 85
Function ; =MAX(C3:C8)
2. MAXIMUM MARKS FOR ENGLISH = 95
Function ; =MAX(D3:D8)
3. MAXIMUM MARKS FOR SCIENCE = 87
Function ; =MAX(E3:E8)
4. MAXIMUM MARKS FOR Computer = 92
Function ; =MAX(F3:F8)
5. MAXIMUM MARKS FOR D&T = 90
Function ; =MAX(G3:G8)
F) MINIMUM MARKS.
1. MINIMUM MARKS FOR MATHS = 50
Function ; =MIN(C3:C8)
2. MINIMUM MARKS FOR ENGLISH = 43
Function ; =MIN(D3:D8)
3. MINIMUM MARKS FOR SCIENCE = 29
Function ; =MIN(E3:E8)
4. MINIMUM MARKS FOR COMPUTER = 30
Function ; =MIN(F3:F8)
5. MINIMUM MARKS FOR D&T = 37
Function ; =MIN(G3:G8)
G) COUNT.
1. COUNT FOR MATHS = 5
Function ; =COUNT(C3:C8)
2. COUNT FOR ENGLISH = 6
Function ; =COUNT(D3:D8)
3. COUNT FOR SCIENCE = 5
Function ; =COUNT(E3;E8)
4. COUNT FOR COMPUTER = 5
Function ; =COUNT(F3:F8)
5. COUNT FOR D&T = 6
Function ; =COUNT(G3:G8))
Nabillah,
Thanks for completing your work and e-mail your work too.. =D
Nabillah,
You’ve scored full marks!! WOOOOWWW!! Outstanding work you’ve got, very good!!
You have followed all the instructions very well…Keep it up girl!!
A)FORMULA AND FUNCTION: “sum”(total mark for each subject)
1)TOTAL MARKS FOR MATHS =358
FUNCTION=SUM(C5:C10)
2)TOTAL MARKS FOR ENG= 479
FUNCTION =SUM(D5:D10)
3)TOTAL MARKS FOR SCIENCE =277
FUNCTION=SUM(D3:D8)
4)TOTAL MARKS FOR COMPUTER=332
FUNCTION=SUM(E5:E10)
5)TOTAL MARKS FOR D&T=380
FUNCTION=SUM(F5:F10)
B) TOTAL MARKS FOR EACH STUDENT:
1)TOTAL MARKS FOR ANGELINA JOLIE =75.6
FUNCTION=SUM(C5:G5)
2)TOTAL MARKS FOR BRAD PITT=87.2
FUNCTION=SUM (C6:G6)
3)TOTAL MARK FOR NICHOLAS CAGE=85
FUNCTION SUM(C7:G7)
4)TOTAL MARK FOR EDDIE MURPHY =53.75
FUNCTION SUM(C8:G8)
5)TOTAL MARK FOR MELISSA JOAN HEART=37.5
FUNCTION SUM(C9:G9)
6)TOTAL MARK FOR FREDDIE PRINCE JR=61.4
FUNCTION SUM(C10:G10)
C)FUNCTION: “average”( AVERAGE MARKS FOR EACH SUBJECT)
1)AVERAGE MARKS Maths = 71.6
Function: =AVERAGE(C5:C10)
2)English = 79.83333333
Function: =AVERAGE(D5:D10)
3) AVERAGE MARKS Science = 55.4
Function: =AVERAGE(E5:E10)
4)AVERAGE MARKS Computer = 66.4
Function: =AVERAGE(F5:F10)
5)AVERAGE MARKS D&T = 63.33333333
Function: =AVERAGE(G5:G10)
D).AVERAGE MARKS FOR EACH STUDENT:
1)AVERAGE MARKS FOR Angelina Jolie = 75.6
Function: =AVERAGE(C5:G5)
2)AVERAGE MARKS FOR Brad Pitt = 87.2
Function: =AVERAGE(C6:G6)
3) AVERAGE MARKS FOR Nicholas Cage = 85
Function: =AVERAGE(C7:G7)
4)AVERAGE MARKS FOR Eddie Murphy = 53.75
Function: =AVERAGE(C8:G8)
5) AVERAGE MARKS FOR Melissa Joan Heart = 37.5
Function: =AVERAGE(C9:G9)
6)AVERAGE MARKS FOR Freddie Prince JR = 61.4
Function: =AVERAGE(C10:G10)
E)FUNCTION: “max, min and count”(MAXIMUM MARKS )
1)MAXIMUM MARKS FOR Maths = 85
Function: =MAX(C5:C10)
-2) MAXIMUM MARKS FOR English = 95
Function: =MAX(D5:D10)
3) MAXIMUM MARKS FOR Science = 87
Function: =MAX(E5:E10)
4)MAXIMUM MARKS FOR Computer = 92
Function: =MAX(F5:F10)
5)MAXIMUM MARKS FOR D&T = 90
Function: =MAX(G5:G10)
B). MINIMUM MARKS :
1)MINIMUM MARKS FOR Maths = 50
Function: =MIN(C5:C10)
2)MINIMUM MARKS FOR English = 43
Function: =MIN(D5:D10)
3)MINIMUM MARKS FOR Science = 29
Function: =MIN(E5:E10)
4) MINIMUM MARKS FOR Computer = 30
Function: =MIN(F5:F10)
5)MINIMUM MARKS FOR D&T = 37
Function: =MIN(G5:G10)
C) COUNT:
1)COUNT FOR Maths = 5
Function: =COUNT(C5:C10)
2)COUNT FOR English = 6
Function: =COUNT(D5:D10)
3)COUNT FOR Science = 5
Function: =COUNT(E5:E10)
4)COUNT FOR Computer = 5
Function: =COUNT(F5:F10)
5)COUNT FOR D&T = 6
Function: =COUNT(G5:G10)
Chien Yin,
I wonder why the RANGE of your cell for every FUNCTIONS in this blog are different from you EXCEL FILE? Perhaps, you give me a wrong EXCEL FILE.
In your EXCEL FILE, you didn’t calculate using FUNCTION for AVERAGE MARKS FOR EACH STUDENT
Do you check it very carefully before you write down your answer in this blog?
However, I gave you 1/2 for those different answers. You’ve scored 48 and 1/2 out of 76. Not bad, boy… I also deducted 1 mark for the wrong FILE NAME.
The filename should be typed in “Activity 5.4.1 FUNCTION – Chien YIn” NOT “Book1’.
I would like to remind you to be focus on everything that you do, to avoid any careless mistake.
1)Total marks for Maths: 358
Functions for Maths: =SUM(C5:C10)
Total marks for English: 479
Functions for English: =SUM(D5:D10)
Total marks for Science:277
Funtions for Science: =SUM(E5:E10)
Total marks for Computer: 332
Functions for Computer: =SUM(F5:F10)
Total marks for D&T: 416
Funtions for D&T: =SUM(G5:G10)
2)Total marks for Angelina Jolie: 378
Functions for Angelina Jolie: =SUM(C5:G5)
Total marks for Brad Pitt: 436
Functions for Brad Pitt: =C6:G6)
Total marks for Nicholas Cage: 340
Funtions for Nicholas Cage: =SUM(C7:G7)
Total marks for Eddie Murphy: 251
Functions for Eddie Murphy: =SUM(C8:G8)
Total marks for Melissa Joan Hart: 150
Functions for Melissa Joan Hart: =SUM(C9:G9)
Total marks for Freddie Prince JR: 307
Functions for Freddie Prince JR: =SUM(C10:G10)
A)FORMULA AND FUNCTION: “sum”(total mark for each subject)
1)TOTAL MARKS FOR MATHS =358
FUNCTION=SUM(C5:C10)
2)TOTAL MARKS FOR ENG= 479
FUNCTION =SUM(D5:D10)
3)TOTAL MARKS FOR SCIENCE =277
FUNCTION=SUM(D3:D8)
4)TOTAL MARKS FOR COMPUTER=332
FUNCTION=SUM(E5:E10)
5)TOTAL MARKS FOR D&T=380
FUNCTION=SUM(F5:F10)
B) TOTAL MARKS FOR EACH STUDENT:
1)TOTAL MARKS FOR ANGELINA JOLIE =75.6
FUNCTION=SUM(C5:G5)
2)TOTAL MARKS FOR BRAD PITT=87.2
FUNCTION=SUM (C6:G6)
3)TOTAL MARK FOR NICHOLAS CAGE=85
FUNCTION SUM(C7:G7)
4)TOTAL MARK FOR EDDIE MURPHY =53.75
FUNCTION SUM(C8:G8)
5)TOTAL MARK FOR MELISSA JOAN HEART=37.5
FUNCTION SUM(C9:G9)
6)TOTAL MARK FOR FREDDIE PRINCE JR=61.4
FUNCTION SUM(C10:G10)
C)FUNCTION: “average”( AVERAGE MARKS FOR EACH SUBJECT)
1)AVERAGE MARKS Maths = 71.6
Function: =AVERAGE(C5:C10)
2)English = 79.83333333
Function: =AVERAGE(D5:D10)
3) AVERAGE MARKS Science = 55.4
Function: =AVERAGE(E5:E10)
4)AVERAGE MARKS Computer = 66.4
Function: =AVERAGE(F5:F10)
5)AVERAGE MARKS D&T = 63.33333333
Function: =AVERAGE(G5:G10)
D).AVERAGE MARKS FOR EACH STUDENT:
1)AVERAGE MARKS FOR Angelina Jolie = 75.6
Function: =AVERAGE(C5:G5)
2)AVERAGE MARKS FOR Brad Pitt = 87.2
Function: =AVERAGE(C6:G6)
3) AVERAGE MARKS FOR Nicholas Cage = 85
Function: =AVERAGE(C7:G7)
4)AVERAGE MARKS FOR Eddie Murphy = 53.75
Function: =AVERAGE(C8:G8)
5) AVERAGE MARKS FOR Melissa Joan Heart = 37.5
Function: =AVERAGE(C9:G9)
6)AVERAGE MARKS FOR Freddie Prince JR = 61.4
Function: =AVERAGE(C10:G10)
E)FUNCTION: “max, min and count”(MAXIMUM MARKS )
1)MAXIMUM MARKS FOR Maths = 85
Function: =MAX(C5:C10)
-2) MAXIMUM MARKS FOR English = 95
Function: =MAX(D5:D10)
3) MAXIMUM MARKS FOR Science = 87
Function: =MAX(E5:E10)
4)MAXIMUM MARKS FOR Computer = 92
Function: =MAX(F5:F10)
5)MAXIMUM MARKS FOR D&T = 90
Function: =MAX(G5:G10)
B). MINIMUM MARKS :
1)MINIMUM MARKS FOR Maths = 50
Function: =MIN(C5:C10)
2)MINIMUM MARKS FOR English = 43
Function: =MIN(D5:D10)
3)MINIMUM MARKS FOR Science = 29
Function: =MIN(E5:E10)
4) MINIMUM MARKS FOR Computer = 30
Function: =MIN(F5:F10)
5)MINIMUM MARKS FOR D&T = 37
Function: =MIN(G5:G10)
C) COUNT:
1)COUNT FOR Maths = 5
Function: =COUNT(C5:C10)
2)COUNT FOR English = 6
Function: =COUNT(D5:D10)
3)COUNT FOR Science = 5
Function: =COUNT(E5:E10)
4)COUNT FOR Computer = 5
Function: =COUNT(F5:F10)
5)COUNT FOR D&T = 6
Function: =COUNT(G5:G10)
Wusalim,
As you don’t provide your EXCEL FILE, I can see the logic of your function. Only the part that I wondering is why your answers in “TOTAL MARKS FOR EACH STUDENT” is different??
Is it logic you have got ‘point’ answers for TOTAL MARKS FOR EACH STUDENT?
I also deducted your 2 marks (attachment & file name) because you didn’t send your EXCEL FILE. So… your overall mark that you scored is 60 out of 76. Put little effort to your good work so it can be the BEST ONE!
A)FORMULA AND FUNCTION: “sum”(total mark for each subject)
1)TOTAL MARKS FOR MATHS =358
FUNCTION=SUM(C5:C10)
2)TOTAL MARKS FOR ENG= 479
FUNCTION =SUM(D5:D10)
3)TOTAL MARKS FOR SCIENCE =277
FUNCTION=SUM(D3:D8)
4)TOTAL MARKS FOR COMPUTER=332
FUNCTION=SUM(E5:E10)
5)TOTAL MARKS FOR D&T=380
FUNCTION=SUM(F5:F10)
B) TOTAL MARKS FOR EACH STUDENT:
1)TOTAL MARKS FOR ANGELINA JOLIE =75.6
FUNCTION=SUM(C5:G5)
2)TOTAL MARKS FOR BRAD PITT=87.2
FUNCTION=SUM (C6:G6)
3)TOTAL MARK FOR NICHOLAS CAGE=85
FUNCTION SUM(C7:G7)
4)TOTAL MARK FOR EDDIE MURPHY =53.75
FUNCTION SUM(C8:G8)
5)TOTAL MARK FOR MELISSA JOAN HART=37.5
FUNCTION SUM(C9:G9)
6)TOTAL MARK FOR FREDDIE PRINCE JR=61.4
FUNCTION SUM(C10:G10)
C)FUNCTION: “average”( AVERAGE MARKS FOR EACH SUBJECT)
1)AVERAGE MARKS Maths = 71.6
Function: =AVERAGE(C5:C10)
2)English = 79.83333333
Function: =AVERAGE(D5:D10)
3) AVERAGE MARKS Science = 55.4
Function: =AVERAGE(E5:E10)
4)AVERAGE MARKS Computer = 66.4
Function: =AVERAGE(F5:F10)
5)AVERAGE MARKS D&T = 63.33333333
Function: =AVERAGE(G5:G10)
D).AVERAGE MARKS FOR EACH STUDENT:
1)AVERAGE MARKS FOR Angelina Jolie = 75.6
Function: =AVERAGE(C5:G5)
2)AVERAGE MARKS FOR Brad Pitt = 87.2
Function: =AVERAGE(C6:G6)
3) AVERAGE MARKS FOR Nicholas Cage = 85
Function: =AVERAGE(C7:G7)
4)AVERAGE MARKS FOR Eddie Murphy = 53.75
Function: =AVERAGE(C8:G8)
5) AVERAGE MARKS FOR Melissa Joan Hart = 37.5
Function: =AVERAGE(C9:G9)
6)AVERAGE MARKS FOR Freddie Prince JR = 61.4
Function: =AVERAGE(C10:G10)
E)FUNCTION: “max, min and count”(MAXIMUM MARKS )
1)MAXIMUM MARKS FOR Maths = 85
Function: =MAX(C5:C10)
-2) MAXIMUM MARKS FOR English = 95
Function: =MAX(D5:D10)
3) MAXIMUM MARKS FOR Science = 87
Function: =MAX(E5:E10)
4)MAXIMUM MARKS FOR Computer = 92
Function: =MAX(F5:F10)
5)MAXIMUM MARKS FOR D&T = 90
Function: =MAX(G5:G10)
B). MINIMUM MARKS :
1)MINIMUM MARKS FOR Maths = 50
Function: =MIN(C5:C10)
2)MINIMUM MARKS FOR English = 43
Function: =MIN(D5:D10)
3)MINIMUM MARKS FOR Science = 29
Function: =MIN(E5:E10)
4) MINIMUM MARKS FOR Computer = 30
Function: =MIN(F5:F10)
5)MINIMUM MARKS FOR D&T = 37
Function: =MIN(G5:G10)
C) COUNT:
1)COUNT FOR Maths = 5
Function: =COUNT(C5:C10)
2)COUNT FOR English = 6
Function: =COUNT(D5:D10)
3)COUNT FOR Science = 5
Function: =COUNT(E5:E10)
4)COUNT FOR Computer = 5
Function: =COUNT(F5:F10)
5)COUNT FOR D&T = 6
Function: =COUNT(G5:G10)
Adiq,
I guess that you have sent a wrong EXCEL FILE. Your FUNCTION & RANGE of CELL in this blog is totally different from the EXCEL FILE that you sent.
For example in FORMULA AND FUNCTION: “SUM”, TOTAL MARKS FOR EACH SUBJECT:
Your answer in this blog: TOTAL MARKS FOR MATHS =358
FUNCTION =SUM(C5:C10)
**Note: In your EXCEL FILE, you type =C5+C6+C7+C8+C9+C10
For example, in TOTAL MARKS FOR EACH STUDENT:
Your answer in this blog: TOTAL MARKS FOR ANGELINA JOLIE=75.6
FUNCTION =SUM(C5:G5)
**Note: In your EXCEL FILE, you are using FORMULA instead of FUNCTION. I wondering that why you give answers in ‘point’? is it logic when you calculate them manually and your answer is point, while the input data has no point at all..?
Think carefully…
Overall mark that you scored is 48 and 1/2 out of 76. Good Try!! I also deducted 1 mark because the FILE NAME for your EXCEL FILE should be:
“Activity 5.4.1 FUNCTION – Ammirul Adiq” NOT “Activity 5.4.1’.
Gentle reminder, please be extra careful and focus in doing your work boy.. to avoid any careless mistake. Alright…
Formulae and functions: “SUM”
1.Total marks for Maths: 358
Function for Maths: =SUM(C3:C8)
Total marks for English: 479
Function for English: =SUM(D3:D8)
Total marks for Science: 277
Function for Science: =SUM(E3:E8)
Total marks for Computer: 332
Function for Computer: =SUM(F3:F8)
Total marks for D&T: 380
Function for D&T: =SUM(G3:G8)
2.Total marks for Angelina Jolie: 378
Function for Angelina Jolie: =SUM(C3:G3)
Total marks for Brad Pitt: 436
Function for Brad Pitt: =SUM(C4:G4)
Total marks for Nicholas Cage: 340
Function for Nicholas Cage: =SUM(C5:G5)
Total marks for Eddie Murphy: 215
Function for Eddie Murphy: =SUM(C6:G6)
Total marks for Melissa Joan Hart: 150
Function for Melissa Joan Hart: =SUM(C7:G7)
Total marks for Freddie Prince JR: 307
Function for Freddie Prince JR: =SUM(C8:G8)
Functions: “AVERAGE”
1. Average marks for Maths: 71.6
Function for Maths:=AVERAGE(C3:C8)
Average marks for English: 72.75
Function for English:=AVERAGE(D3:D8)
Average marks for Science: 55.4
Function for Science:=AVERAGE(E3:E8)
Average marks for Computer: 66.4
Function for Computer:=AVERAGE(F3:F8)
Average marks for D&T: 63.333333
Function for D&T:=AVERAGE(G3:G8)
2. Average marks for Angelina Jolie: 75.6
Function for Angelina Jolie: =AVERAGE(C3:G3)
Average marks for Brad Pitt: 87.2
Function for Brad Pitt: =AVERAGE(C4:G4)
Average marks for Nicholas Cage: 85
Function for Nicholas cage: =AVERAGE(C5:G5)
Average marks for Eddie Murphy: 53.75
Function for Eddie Murphy: =AVERAGE(C6:G6)
Average marks for Melissa Joan Heart: 37.5
Function for Melissa Joan Heart: =AVERAGE(C7:G7)
Average marks for Freddie Prince JR: 61.4
Function for Freddie Prince JR: =AVERAGE(C8:G8)
Functions: “MAX, MIN, and COUNT”
1. Maximum marks for Maths: 85
Function for Maths:=MAX(C3:C8)
Maximum marks for English: 95
Function for English:=MAX(D3:D8)
Maximum marks for Science: 87
Function for Science:=MAX(E3:E8)
Maximum marks for Computer: 92
Function for Computer:=MAX(F3:F8)
Maximum marks for D&T: 90
Function for D&T:=MAX(G3:G8)
Minimum marks for Maths: 50
Function for Maths: =MIN(C3:C8)
Minimum marks for English: 43
Function for English: =MIN(D3:D8)
Minimum marks for Science: 29
Function for Science: =MIN(E3:E8)
Minimum marks for Computer: 30
Function for Computer: =MIN(F3:F8)
Minimum marks for D&T: 37
Function for D&T: =MIN(G3:G8)
2. Count data for Maths: 5
Function for Maths:=COUNT(C3:C8)
Count data for English: 6
Function for English:=COUNT(D3:D8)
Count data for Science: 5
Function for Science:=COUNT(E3:E8)
Count data for Computer: 5
Function for Computer:=COUNT(F3:F8)
Count data for D&T: 6
Function for D&T:=COUNT(G3:G8)
Faris,
EXCELLENT WORK!! I like the way you think boy!! Your work is very neat and organize in a good manner. You have complete your work with good formatting skill.
You also followed the instruction very well; you attached the excel file AND file name is in a correct format.
You scored 75 out of 76. You know why you miss 1 mark? The reason is:
Your answer for AVERAGE MARKS FOR ENGLISH: 72.75
Function for English: =AVERAGE(D3:D8)
****NOTE: Your answer should be 79.83. Your function “=AVERAGE(D3:D8)” is already correct BUT in your EXCEL FILE you have typed “=AVERAGE(D5:D8)”
Please be extra careful boy… However, I like what you did!!
total marks for maths: 358
function: =SUM(C2:C7)
total marks for english: 479
function: =SUM(D2:D7)
total marks for science: 277
function: =SUM(E2:E7)
total marks for computer: 332
function: =SUM(F2:F7)
total marks for D&T: 380
function: =SUM(G2:G7)
total marks for Angelina Jolie: 378
function: =SUM(C2:G2)
total marks for Brad Pitt: 436
function: =SUM(C3:G3)
total marks for Nicholas Cage: 340
function: =SUM(C4:G4)
total marks for Eddie Murphy: 215
function: =SUM(C5:G5)
total marks for Melissa Joan Hart: 150
function: =SUM(C6:G6)
total marks for Freddie Prince JR: 307
function: =SUM(C7:G7)
average marks for maths: 71.6
function: =AVERAGE(C2:C7)
average marks for english: 79.83333
function: =AVERAGE(D2:D7)
average marks for science: 55.4
function: =AVERAGE(E2:E7)
average marks for computer: 66.4
function: =AVERAGE(F2:F7)
average marks for D&T: 63.33333
function: =AVERAGE(G2:G7)
average marks for Angelina Jolie: 75.6
function: =AVERAGE(C2:G2)
average marks for Brad Pitt: 87.2
function: =AVERAGE(C3:G3)
average marks for Nicholas Cage: 85
function: =AVERAGE(C4:G4)
average marks for Eddie Murphy: 53.75
function: =AVERAGE(C5:G5)
average marks for Melissa Joan Hart: 37.5
function: =AVERAGE(C6:G6)
average marks for Freddie Prince JR: 61.4
function: =AVERAGE (C7:G7)
maximum marks for maths: 85
function: =MAX(C2:C7)
maximum marks for english: 95
function: =MAX(D2:D7)
maximum marks for science: 87
function: =MAX(E2:E7)
maximum marks for computer: 92
function: =MAX(F2:F7)
maximum marks for D&T: 90
function: =MAX(G2:G7)
minimum marks for maths: 50
function: =MIN(C2:C7)
minimum marks for english: 43
function: =MIN(D2:D7)
minimum marks for science: 29
function: =MIN(E2:E7)
minimum marks for computer: 30
function: =MIN(F2:F7)
minimum marks for D&T: 37
function: =MIN(G2:G7)
count data for maths: 5
function: =COUNT(C2:C7)
count data for english: 6
function: =COUNT(D2:D7)
count data for science: 5
function: =COUNT(E2:E7)
count data for computer: 5
function: =COUNT(F2:F7)
count data for D&T: 6
function: =COUNT(G2:G7)
Nurmajidah,
It is so enjoyable to mark your work, HOWEVER it would be MORE enjoyable if you provide me your EXCEL FILE.
You have lost 2 marks for not providing me EXCEL FILE. Overall score is 74 out of 76. Not bad huh… 🙂 VERY GOOD!! keep it up girl…
Total marks for maths:358
Function: =sum(c3:c8)
Total marks for english:479
Function: =sum(d3:d8)
Total marks for science:277
Function: =sum(e3:e8)
Total marks for computer:332
Function: =sum(f3:f8)
Total marks for d&t:380
Function: =sum(g3:g8)
Total marks for Angelina Jolie:378
Function: =sum(c3:g3)
Total marks for Brad Pitt:436
Function: =sum(c4:g4)
Total marks for Nicholas Cage:340
Function: =sum(c5:g5)
Total marks for Eddie Murphy:215
Function: =sum(c6:g6)
Total marks for Melissa Joan Hart:150
Function: =sum(c7:g7)
Total marks for Freddie Prince JR:307
Function: =sum(c8:g8)
Average mark for Maths:71.6
Function: =average(c3:c8)
Average mark for english:79.3333333
Function: =average(d3:d8)
Average mark for science:55.4
Function: =average(e3:e8)
Average mark for computer:66.4
Function: =average(f3:f8)
Average mark for d&t:63.33333333
Function: =average(g3:g8)
Average mark for Angelina Jolie:75.6
Function: =average(c3:g3)
Average mark for Brad Pitt:87.2
Function: =average(c4:g4)
Average mark for Nicholas Cage:85
Function: =average(c5:g5)
Average mark for Eddie Murphy:53.75
Function: =average(c6:g6)
Average mark for Melissa Joan Hart:37.5
Function: =average(c7:g7)
Average mark for Freddie Prince JR:61.4
Function: =average(c8:g8)
Maximum marks for maths:85
Function: =max(c3:c8)
Maximum marks for eng:95
Function: =max(d3:d8)
Maximum marks for science:87
Function: =max(e3:e8)
Maximum marks for computer:92
Function: =max(f3:f8)
Maximum marks for d&t:90
Function: =max(g3:g8)
Minimum marks for maths:50
Function: =min(c3:c8)
Minimum marks for eng:43
Function: =min(d3:d8)
Minimum marks for science:29
Function: =min(e3:e8)
Minimum marks for computer:30
Function: =min(f3:f8)
Minimum marks for d&t:37
Function: =min(g3:g8)
Count data for maths:5
Function: =count(c3:c8)
Count data for eng:6
Function: =count(d3:d8)
Count data for science:5
Function: =count(e3:e8)
Count data for computer:5
Function: =count(f3:f8)
Count data for d&t:6
Function: =count(g3:g8)
Nurazirah,
I guess you have sent me a wrong file because your FUNCTIONS in the EXCEL FILE are not complete.
However, I see your logic. You have used correct ‘RANGE’ in your functions. 😦 it would be more fun to mark if I see the correct EXCEL FILE sent.
Okay, your overall mark that you score is 75 out of 76. 1 mark lost is because the file name of your excel file is wrong.
The correct one should be:
“Activity 5.4.1 FUNCTION – Nurazirah”
Above all, good work Nurazirah. Keep it up!!
A)FORMULA AND FUNCTION: “sum
”(total mark for each subject) 1)TOTAL MARKS FOR MATHS =358
FUNCTION=SUM(C5:C10)
2)TOTAL MARKS FOR ENG= 479
FUNCTION =SUM(D5:D10)
3)TOTAL MARKS FOR SCIENCE =277
FUNCTION=SUM(D3:D8)
4)TOTAL MARKS FOR
COMPUTER=332
FUNCTION=SUM(E5:E10)
5)TOTAL MARKS FOR D&T=380
FUNCTION=SUM(F5:F10) B) TOTAL MARKS FOR EACH
STUDENT: 1)TOTAL MARKS FOR ANGELINA
JOLIE =75.6
FUNCTION=SUM(C5:G5)
2)TOTAL MARKS FOR BRAD
PITT=87.2
FUNCTION=SUM (C6:G6)
3)TOTAL MARK FOR NICHOLAS
CAGE=85
FUNCTION SUM(C7:G7)
4)TOTAL MARK FOR EDDIE MURPHY
=53.75
FUNCTION SUM(C8:G8)
5)TOTAL MARK FOR MELISSA JOAN
HART=37.5
FUNCTION SUM(C9:G9)
6)TOTAL MARK FOR FREDDIE PRINCE
JR=61.4
FUNCTION SUM(C10:G10)
C)FUNCTION: “average”( AVERAGE
MARKS FOR EACH SUBJECT)
1)AVERAGE MARKS Maths = 71.6
Function: =AVERAGE(C5:C10)
2)English = 79.83333333
Function: =AVERAGE(D5:D10)
3) AVERAGE MARKS Science = 55.4
Function: =AVERAGE(E5:E10)
4)AVERAGE MARKS Computer =
66.4
Function: =AVERAGE(F5:F10)
5)AVERAGE MARKS D&T =
63.33333333
Function: =AVERAGE(G5:G10)
D).AVERAGE MARKS FOR EACH
STUDENT:
1)AVERAGE MARKS FOR Angelina
Jolie = 75.6
Function: =AVERAGE(C5:G5)
2)AVERAGE MARKS FOR Brad Pitt =
87.2
Function: =AVERAGE(C6:G6)
3) AVERAGE MARKS FOR Nicholas
Cage = 85
Function: =AVERAGE(C7:G7)
4)AVERAGE MARKS FOR Eddie
Murphy = 53.75
Function: =AVERAGE(C8:G8)
5) AVERAGE MARKS FOR Melissa
Joan Hart = 37.5
Function: =AVERAGE(C9:G9)
6)AVERAGE MARKS FOR Freddie
Prince JR = 61.4
Function: =AVERAGE(C10:G10)
E)FUNCTION: “max, min and count
”(MAXIMUM MARKS )
1)MAXIMUM MARKS FOR Maths = 85
Function: =MAX(C5:C10)
2) MAXIMUM MARKS FOR English =
95
Function: =MAX(D5:D10)
3) MAXIMUM MARKS FOR Science =
87
Function: =MAX(E5:E10)
4)MAXIMUM MARKS FOR Computer =
92
Function: =MAX(F5:F10)
5)MAXIMUM MARKS FOR D&T = 90
Function: =MAX(G5:G10) B). MINIMUM MARKS :
1)MINIMUM MARKS FOR Maths = 50
Function: =MIN(C5:C10)
2)MINIMUM MARKS FOR English = 43
Function: =MIN(D5:D10)
3)MINIMUM MARKS FOR Science =
29
Function: =MIN(E5:E10)
4) MINIMUM MARKS FOR Computer =
30
Function: =MIN(F5:F10)
5)MINIMUM MARKS FOR D&T = 37
Function: =MIN(G5:G10)
C) COUNT: 1
)COUNT FOR Maths = 5
Function: =COUNT(C5:C10)
2)COUNT FOR English = 6
Function: =COUNT(D5:D10)
3)COUNT FOR Science = 5
Function: =COUNT(E5:E10)
4)COUNT FOR Computer = 5
Function: =COUNT(F5:F10)
5)COUNT FOR D&T = 6
Function: =COUNT(G5:G10)
how to make the excel cher? And sorry for late sumbit the homework . 🙂
Zulzamirul,
I’ve accepted your work in this wordpress blog.. What do you mean by “how to make the excel?” Don’t you calculate your function using EXCEL?
It’s alright for the late submit..the most important thing is you submit your work! and that’s good
Zulzamirul,
Sorry to say this…but this is what I feel… I assumed that you didn’t do your work using EXCEL because I found out that the RANGE that you used in FUNCTION for calculation are not consistent UNLESS you sent me your SOFTCOPY of your excel.
For example, your answer:
TOTAL MARKS FOR SCIENCE =277
FUNCTION =SUM(D3:D8)
****NOTE: Isn’t column D has been used for English?
I also wonder why your answers in “TOTAL MARKS FOR EACH STUDENT” is in “point”? Is it logic you have got ‘point’ answers while the input data has no “point” at all?
For example, your answer:
TOTAL MARKS FOR ANGELINA JOLIE =75.6
FUNCTION =SUM(C5:G5)
INPUT DATA for Angelina Jolie are: 85, 95, 58, 74, 66
which gives answer: 378
However, your final score is 62 out of 76. Not bad… good work!! I deducted 2 marks for not sending your Excel file. 1 mark for inconsistency RANGE in functions. 1 mark for not organized in typing the answers in this blog.
Please make a big effort, be organized, as well as attentive in your work.
Formulae and functions: “SUM”
1. Total marks for Maths:358
Function for Maths:=SUM(C3:C8)
Total marks for English:479
Function for English:=SUM(D3:D8)
Total marks for Science:277
Function for Science:=SUM(E3:E8)
Total marks for Computer : 332
Function for Computer : =SUM(F3:F8)
Total marks for D&T:380
Function for D&T:=SUM(G3:G8)
2. Total marks for Angelina Jolie: 378
Function for Angelina Jolie: =SUM(C3:G3)
Total marks for Brad Pitt: 436
Function for Brad Pitt: =SUM(C4:G4)
Total marks for Nicholas Cage:340
Function for Nicholas Cage:=SUM(C5:G5)
Total marks for Eddie Murphy:215
Function for Eddie Murphy:=SUM(C6:G6)
Total marks for Melissa Joan Hart:150
Function for Melissa Joan Hart:=SUM(C7:G7)
Total marks for Freddie Prince JR:307
Function for Freddie Prince JR:=SUM(C8:G8)
Functions: “AVERAGE”
1. Average marks for Maths:71.6
Function for Maths:=AVERAGE(C3:C8)
Average marks for English:79.83333
Function for English:=AVERAGE(D3:D8)
Average marks for Science:55.4
Function for Science:=AVERAGE(E3:E8)
Average marks for Computer :66.4
Function for Computer :=AVERAGE(F3:F8)
Average marks for D&T:63.3333
Function for D&T:=AVERAGE(G3:G8)
2. Average marks for Angelina Jolie: 75.6
Function for Angelina Jolie:=AVERAGE(C3:G3)
Average marks for Brad Pitt:87.2
Function for Brad Pitt:=AVERAGE(C4:G4)
Average marks for Nicholas Cage:85
Function for Nicholas Cage:=AVERAGE(C5:G5)
Average marks for Eddie Murphy:53.75
Function for Eddie Murphy:=AVERAGE(C6:G6)
Average marks for Melissa Joan Heart:37.5
Function for Melissa Joan Heart:=AVERAGE(C7:G7)
Average marks for Freddie Prince JR:61.4
Function for Freddie Prince JR:=AVERAGE(C8:G8)
Functions: “MAX, MIN, and COUNT”
1. Maximum marks for Maths: 85
Function for Maths:=MAX(C3:C8)
Maximum marks for English:95
Function for English: =MAX(D3:D8)
Maximum marks for Science:87
Function for Science:=MAX(E3:E8)
Maximum marks for Computer :92
Function for Computer :=MAX(F3:F8)
Maximum marks for D&T:90
Function for D&T:=MAX(G3:G8)
Minimum marks for Maths: 50
Function for Maths:=MIN(C3:C8)
Minimum marks for English:43
Function for English: =MIN(D3:D8)
Minimum marks for Science:29
Function for Science:=MIN(E3:E8)
Minimum marks for Computer :30
Function for Computer :=MIN(F3:F8)
Minimum marks for D&T:37
Function for D&T:=MIN(G3:G8)
2. Count data for Maths: 5
Function for Maths:=COUNT(C3:C8)
Count data for English: 6
Function for English:=COUNT(D3:D8)
Count data for Science:5
Function for Science:=COUNT(E3:E8)
Count data for Computer :5
Function for Computer :=COUNT(F3:F8)
Count data for D&T:6
Function for D&T:=COUNT(G3:G8)
Joanishah,
You are very good in using functions. The only thing that you have to be bear in your mind is that you need to organize your table by formatting it using border and colour so that it will be neat and easy to look on. 😀
However, you scored quite high mark: 75 out of 76. You know why you missed 1 mark? Your file name should be typed in a correct format, such as:
“Activity 5.4.1 FUNCTION – Joanishah”, NOT ““Activity 5.4.1 – Joanishah”
WELLDONE boy!!
FUNCTION ‘SUM’
1.TOTAL MARKS FOR MATHS:358
FUNCTION:=SUM(C3:C8)
TOTAL MARKS FOR ENGLISH:479
FUNCTION:=SUM(D3:D8)
TOTAL MARKS FOR SCIENCE:277
FUNCTION:=SUM(E3:E8)
TOTAL MARKS FOR COMPUTER:332
FUNCTION:=SUM(F3:F8)
TOTAL MARKS FOR D & T:380
FUNCTION:=SUM(G3:G8)
2.TOTAL MARKS FOR ANGELINA JOLIE:378
FUNCTION:=SUM(C3:G3)
TOTAL MARKS FOR BRAD PITT:436
FUNCTION:=SUM(C4:G4)
TOTAL MARKS FOR NICHOLAS CAGE: 340
FUNCTION:=SUM(C5:G5)
TOTAL MARKS FOR EDDIE MURPHY: 215
FUNCTION:=SUM(C6:G6)
TOTAL MARKS FOR MELISSA JOAN HART:150
FUNCTION:=SUM(C7:G7)
TOTAL MARKS FOR FREDDIE PRINCE JR:307
FUNCTION:=SUM(C8:G8)
FUNCTION ‘AVERAGE’
AVERAGE MARKS FOR MATHS:71.6
FUNCTION:=AVERAGE(C3:C8)
AVERAGE MARKS FOR ENGLISH:79.3333333
FUNCTION:=AVERAGE(D2:D8)
AVERAGE MARKS FOR SCIENCE:55.4
FUNCTION:=AVERAGE(E3:E8)
AVERAGE MARKS FOR COMPUTER:66.4
FUNCTION:=AVERAGE(F3:F8)
AVERAGE MARKS FOR D & T:63.33333333
FUNCTION:=AVERAGE(G3:G8)
4.AVERAGE MARKS FOR ANGELINA JOLIE:75.6
FUNCTION:=AVERAGE(C3:G3)
AVERAGE MARKS FOR BRAD PITT:87.2
FUNCTION:=AVERAGE(C4:G4)
AVERAGE MARKS FOR NICHOLAS CAGE:85
FUNCTION:=AVERAGE(C5:G5)
AVERAGE MARKS FOR EDDIE MURPHY:53.75
FUNCTION:=AVERAGE(C6:G6)
AVERAGE MARKS FOR MELISSA JOAN HART:37.5
FUNCTION:=AVERAGE(C7:G7)
AVERAGE MARKS FOR FREDDIE PRINCE JR:61.4
FUNCTION:=AVERAGE(C8:G8)
FUNCTION ‘MAX,MIN AND COUNT’
MAXIMUM MARKS
MAXIMUM MARKS FOR MATHS:85
FUNCTION:=MAX(C3:C8)
MAXIMUM MARKS FOR ENGLISH:95
FUNCTION:=MAX(D3:D8)
MAXIMUM MARKS FOR SCIENCE:87
FUNCTION:=MAX(E3:E8)
MAXIMUM MARKS FOR COMPUTER:92
FUNCTION:=MAX(F3:F8)
MAXIMUM MARKS FOR D&T:90
FUNCTION:=MAX(G3:G8)
2.MINIMUM MARKS
MINIMUM MARKS FOR MATHS:50
FUNCTION:=MIN(C3:C8)
MINIMUM MARKS FOR ENGLISH:43
FUNCTION:=MIN(D3:D8)
MINIMUM MARKS FOR SCIENCE:29
FUNCTION:=MIN(E3:E8)
MINIMUM MARKS FOR COMPUTER:30
FUNCTION:=MIN(F3:F8)
MINIMUM MARKS FOR D&T:37
FUNCTION:=MIN(G3:G8)
3.COUNT
COUNT FOR MATHS:5
FUNCTION:=COUNT(C3:C8)
COUNT FOR ENGLISH:6
FUNCTION:=COUNT(D3:D8)
COUNT FOR SCIENCE:5
FUNCTION:=COUNT(E3:E8)
COUNT FOR COMPUTER:5
FUNCTION:=COUNT(F3:F8)
COUNT FOR D&T:6
FUNCTION:=COUNT(G3:G8)
SORRY TEACHER……LATE SUBMIT I WASNT AT HOME YESTERDAY SORRY 🙂 BY THE WAY TEACHER HAVE YOU RECEIVE MY EMAIL ALREADY??
Iman,
You are good in using formula and function. Additionally, you are also very good in using ‘comment’ to inform me what you did. Keep it up boy!!
However, you need to organise a bit on your table. You need to put the ‘function’ as well instead by just typing the answer.
Your score is 72 and 1/2 out of 76. 1 and 1/2 mark lost is because you have type down answer:
AVERAGE MARKS FOR ENGLISH: 79.3333333
FUNCTION: =AVERAGE(D2:D8)
The correct one should be:
AVERAGE MARKS FOR ENGLISH: 79.8333333
FUNCTION: =AVERAGE(D3:D8)
***Since in your excel file is given correct answer, so I give you 1/2.
Another 1 mark lost is because you have type wrong format of file name. It should be typed in such format:
“Activity 5.4.1 FUNCTION – Mohammad Iman”
Well,
Keep up the good work boy!!
FORMULA AND FUNCTION: “sum”
1. TOTAL MARKS FOR EACH SUBJECT:
– Maths = 358
Formula: =C5+C6+C7+C8+C9+C10
– Eng = 479
Formula: =D5+D6+D7+D8+D9+D10
– Science = 277
Formula: =E5+E6+E7+E8+E9+E10
– Computer = 332
Formula: =F5+F6+F7+F8+F9+F10
– D&T = 380
Formula: =G5+G6+G7+G8+G9+G10
2. TOTAL MARKS FOR EACH STUDENT:
– Angelina Jolie = 378
Formula: =C5+D5+E5+F5+G5
– Brad Pitt = 436
Formula: =C6+D6+E6+F6+G6
– Nicholas Cage = 340
Formula =C7+D7+E7+F7+G7
– Eddie Murphy = 215
Formula: =C8+D8+E8+F8+G8
– Melissa Joan Hart = 150
Formula: =C9+D9+E9+F9+G9
– Freddie Prince JR = 307
Formula: =C10+D10+E10+F10+G10
FUNCTION: “average”
1. AVERAGE MARKS FOR EACH SUBJECT:
– Maths = 71.6
Function: =AVERAGE(C5:C10)
– English = 79.83333333
Function: =AVERAGE(D5:D10)
– Science = 55.4
Function: =AVERAGE(E5:E10)
– Computer = 66.4
Function: =AVERAGE(F5:F10)
– D&T = 63.33333333
Function: =AVERAGE(G5:G10)
2. AVERAGE MARKS FOR EACH STUDENT:
– Angelina Jolie = 75.6
Function: =AVERAGE(C5:G5)
– Brad Pitt = 87.2
Function: =AVERAGE(C6:G6)
– Nicholas Cage = 85
Function: =AVERAGE(C7:G7)
– Eddie Murphy = 53.75
Function: =AVERAGE(C8:G8)
– Melissa Joan Heart = 37.5
Function: =AVERAGE(C9:G9)
– Freddie Prince JR = 61.4
Function: =AVERAGE(C10:G10)
FUNCTION: “max, min and count”
1. MAXIMUM MARKS:
– Maths = 85
Function: =MAX(C5:C10)
– English = 95
Function: =MAX(D5:D10)
– Science = 87
Function: =MAX(E5:E10)
– Computer = 92
Function: =MAX(F5:F10)
– D&T = 90
Function: =MAX(G5:G10)
2. MINIMUM MARKS:
– Maths = 50
Function: =MIN(C5:C10)
– English = 43
Function: =MIN(D5:D10)
– Science = 29
Function: =MIN(E5:E10)
– Computer = 30
Function: =MIN(F5:F10)
– D&T = 37
Function: =MIN(G5:G10)
3. COUNT:
– Maths = 5
Function: =COUNT(C5:C10)
– English = 6
Function: =COUNT(D5:D10)
– Science = 5
Function: =COUNT(E5:E10)
– Computer = 5
Function: =COUNT(F5:F10)
– D&T = 6
Function: =COUNT(G5:G10)
Ezzul,
I see the logic of the range. However it will be more fun for me to mark your work if you provide me your excel file.
Since you didn’t provide excel file. Your mark is deducted as described below:
File name & Attachment: -2
TOTAL MARKS FOR EACH SUBJECT & TOTAL MARKS FOR EACH STUDENT should be calculated by using FUNCTION, NOT FORMULA.
Example, your answer:
-Maths =358
Formula: =C5+C6+C7+C8+C9+C10
Instead formula, it should be written in FUNCTION:
-Maths =358
Function: =SUM(C5:C10)
**So for these mistakes, I deduct 10 marks for the wrong format of calculation.
Overall score: 62 out of 76. Good work!!