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 >>>

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!!