**HIGHLIGHT!!**

**YOUR HOMEWORK TO BE COMPLETED ON 17 FEBRUARY 2012, FRIDAY**

You have discussed EXERCISE 2-SPREADSHEETS’ FORMULA with your group in the classroom on 13 February 2012.

You have answered ALL the questions. **Now as your homework**, answer the questions of **ACTIVITY 5.4.1, ONLY **on sub-topic** “Formulae and functions:”SUM”” -Question no. 1 & 2 (Total marks & Formulae).**

………………………………..

**DO NOT WORK ON FUNCTION AS YOU HAVEN’T LEARN IT.**

………………………………..

**??HOW TO DO??**

**INSTRUCTION: You must do this activity using ONLY Microsoft Office Excel, no calculator is allowed.**

STEP 1 – You enter **all the data** as in the **given TABLE**. Make sure all the data are **entered correctly**.

STEP 2 – Do calculations by entering the **FORMULA** in **appropriate cell** for “*Total Marks for Each Subject*” and “*Total Marks for Each Student”*

STEP 3 – **SAVE** your work as “*Activity 5.4.1 -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 as well as 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’

Formulae for Maths:’your answer’

…………

Total marks for English: ‘your answer’

Formulae for English: ‘your answer’

………..

……….

……

*and the rest of the subjects.*

2. Total marks for Angelina Jolie: ‘your answer’

Formulae for Angelina Jolie: ‘your answer’

…………

Total marks for Brad Pitt: ‘your answer’

Formulae for Brad Pitt: ‘your answer’

…………

…….

….

*and the rest of the students.*

**Are you clear?**

**Once again, your deadline will be on**

### Like this:

Like Loading...

*Related*

1)Total marks for MATHS : 358

Formula: =C2+C3+C4+C5+C7

Total marks for ENGLISH : 392

Formula: =C2+C3+C4+C5+C6+C7

2)Total marks for Angelina Jolie : 378

Formula: =C2+D2+E2+F2+G2

Total marks for Brad Pitt : 436

Formula: =C3+D3+E3+F3+G3

Norafazirah,

I think you not clear with the instruction above stated “and the rest of the subjects” “and the rest of the students”.

I need answers of the formulae and total marks for all the subjects as well as the students.

Answers you provided to me is in right format. Please do for the rest again.. =D

The one that I asked all of you to tick the questions that need to be done in the class is for the CLASSWORK, but it will be done next week.

Do NOT forget to e-mail me your ACTIVITY 5.4.1 as per request in “STEP 4 – E-mail your work to qistinah.jalil@ripas.moe.edu.bn (It is for my copy as well as to verify your answer)”

Teacher I’m not confident about my first answer so I want to do it again..can I ?

Yes you can do it again… 😀

1)a)Total marks for MATHS :358

b)Formula:=c5+c6+c7+c8+c9+c10

c) Total marks for ENGLISH : 479

d)Formula=d5+d6+d7+d8+d9+d10

2a)Total marks for Angelina Jolie:378

b)Formulae for Angelina Jolie:c5+d5+e5+f5+g5

c)Total marks for Brad Pitt: 436

d)Formulae for Brad Pitt:c6+d6+e6+f6+g6

Teacher Step One means?

STEP 1 – You enter all the data as in the given TABLE. Make sure all the data are entered correctly.

P/s:You are given the table given in your ACTIVITY 5.4.1, right? What you do is, you copy all the exact information in the table given in the MICROSOFT EXCEL. Once you done, you figure out on how to calculate the “Total Marks for Each Subject” and “Total Marks for Each Student”.

Am I answering your question?

yup

Jin Ming,

I think you not clear with the instruction above stated “and the rest of the subjects” “and the rest of the students”.

I need answers of the formulae and total marks for all the subjects as well as the students.

Answers you provided to me is in right format. Please do for the rest of the questions again.. =D

The one that I asked all of you to tick the questions that need to be done in the class is for the CLASSWORK, but it will be done next week.

Do NOT forget to e-mail me your ACTIVITY 5.4.1 as per request in “STEP 4 – E-mail your work to qistinah.jalil@ripas.moe.edu.bn (It is for my copy as well as to verify your answer)”

How To do with the step ONE?

total marks for maths: 358

formula: =c2+c3+c4+c5+c6+c7

total marks for english: 479

formula: =d2+d3+d4+d5+d6+d7

total marks for Angelina Jolie: 378

formula for Angelina Jolie: =c2+d2+e2+f2+g2

total marks for Brad Pitt: 436

formula for Brad Pitt: =c3+d3+e3+f3+g3

Nurmajidah,

I think you not clear with the instruction above stated “and the rest of the subjects” “and the rest of the students”.

I need answers of the formulae and total marks for all the subjects as well as the students.

Answers you provided to me is in right format. Please do for the rest of the questions again.. =D

The one that I asked all of you to tick the questions that need to be done in the class is for the CLASSWORK, but it will be done next week.

Do NOT forget to e-mail me your ACTIVITY 5.4.1 as per request in “STEP 4 – E-mail your work to qistinah.jalil@ripas.moe.edu.bn (It is for my copy as well as to verify your answer)”

teacher i enter the data in microsoft excel and calculate it and comment the asnwer here?

Mohammad Iman,

Yes…first thing you do is you enter all the data using Microsoft Excel and do the calculation. Once you done, you SAVE your work as well as EMAIL it to your teacher as per request on STEP 3 & STEP 4 ( it is for a reason of checking your answer).

You also have to post your answer here… =D

Am I answering you?

yes teacher… 🙂

should i have to write activities 5.4.1 here

Jin Ming,

I am not clear with what you ask…

You are now doing some part of activity 5.4.1 BUT you ONLY have to answer on sub-topic “Formulae and functions:”SUM”” -Question no. 1 & 2 (Total marks & Formulae).

1. Total marks for Maths:358

Formulae for Maths:=C3+C4+C5+C6+C7+C8

Total marks for English:479

Formulae for English:=D3+D4+D5+D6+D7+D8

Total marks for Science:277

Formulae for Science:=E3+E4+E5+E6+E7+E8

Total marks for Computer:332

Formulae for Computer:=F3+F4+F5+F6+F7+F8

Total marks for D&T:=380

Formulae for D&T:=G3+G4+G5+G6+G7+G8

2. Total marks for Angelina Jolie:378

Formulae for Angelina Jolie:=C3+D3+E3+F3+G3

Total marks for Brad Pitt:436

Formulae for Brad Pitt:=C4+D4+E4+F4+G4

Total marks for Nicholas Cage:340

Formulae for Nicholas Cage:=C5+D5+E5+F5+G5

Total marks for Eddie Murphy:215

Formulae for Eddie Murphy:C6+D6+E6+F6+G6

Total marks for Melissa Joan Hart:150

Formulae for Melissa Joan Hart:=C7+D7+E7+F7+G7

Total marks for Freddie Prince JR:307

Formulae for Freddie Prince JR:=C8+D8+E8+F8+G8

Please can you tell what is meaning of steps 3?

Joanishah,

Very good…you are on a right track!!!

Now, step 3 is asking you to SAVE your work in your PENDRIVE. name your work as “Activity 5.4.1 -Joanishah”

After that, for STEP 4- you attach your ACTIVITY and send it via e-mail qistinah.jalil@ripas.moe.edu.bn

I hope this helps you… =D

Joanishah,

Your overall mark is 22 out of 24. WELLDONE!! You’ve got all your answers correct but I deduct 2 marks because you didn’t submit your EXCEL file for me to check whether you did a correct way or not.

Formulae and functions: “SUM”

“Total Marks for Each Subject”

Total marks Formulae

Math’s 358 C5+c6+c7+c8+c9+c10

English 479 d5+d6+d7+d8+d9+d10

Science 227 E5+e6+s7+e8+e9+e10

Computer 332 F5+f6+f7+f8+f9+f10

D&t 380 G5+g6+g7+g8+g9+g10

“Total Marks for Each Student”

Total marks Formulae

Angelina Jolie 378 c5+d5+e5+f5+g5

Brad Pitt 436 c6+d6+e6+f6+g6

Nicholas cage 340 c7+d7+e7+f7+g7

Eddie Murphy 215 c8+d8+e8+f8+g8

Melissa Joan hart 150 c9+d9+e9+f9=g9

Freddie prince JR 307 c10+d10+e10+f10+g10

(STEP 5-Homework For Week 6)

correction:

Formulae and functions: “SUM”

“Total Marks for Each Subject”

1. Total marks for Maths:358

Formulae :=C3+C4+C5+C6+C7+C8

Total marks for English:479

Formulae :=d5+d6+d7+d8+d9+d10

Total marks for Science:277

Formulae =E3+E4+E5+E6+E7+E8

Total marks for Computer:332

Formulae :=F3+F4+F5+F6+F7+F8

Total marks for D&T:=380

Formulae :=G3+G4+G5+G6+G7+G8

“Total Marks for Each Student”

2. Total marks for Angelina Jolie:378

Formulae :=C3+D3+E3+F3+G3

Total marks for Brad Pitt:436

Formulae :=C4+D4+E4+F4+G4

Total marks for Nicholas Cage:340

Formulae :=C5+D5+E5+F5+G5

Total marks for Eddie Murphy:215

Formulae :C6+D6+E6+F6+G6

Total marks for Melissa Joan Hart:150

Formulae :=C7+D7+E7+F7+G7

Total marks for Freddie Prince JR:307

Formulae :=C8+D8+E8+F8+G8

Do not forget to e-mail your Excel file of this homework to your teacher. I would like to check from the Excel file

Chien Yin,

You’ve got an overall mark 21 out of 24. Very Good!! but unfortunately 3 marks deducted because:

-Incorrect file name

-Formulae for English should be ‘=D3+D4+D5+D6+D7+D8’

-Not following instruction on working out the FORMULAE (but good attempt on trying the FUNCTION)

Formulae and functions: “SUM”

“Total Marks for Each Subject”

1. Total marks for Maths:358

Formulae :=C3+C4+C5+C6+C7+C8

.Total marks for English:479

Formulae :=d5+d6+d7+d8+d9+d10

Total marks for Science:277

Formulae =E3+E4+E5+E6+E7+E8

Total marks for Computer:332

Formulae :=F3+F4+F5+F6+F7+F8

Total marks for D&T:=380

Formulae :=G3+G4+G5+G6+G7+G8

“Total Marks for Each Student”

2. Total marks for Angelina Jolie:378

Formulae :=C3+D3+E3+F3+G3

Total marks for Brad Pitt:436

Formulae :=C4+D4+E4+F4+G4

Total marks for Nicholas Cage:340

Formulae :=C5+D5+E5+F5+G5

Total marks for Eddie Murphy:215

Formulae :C6+D6+E6+F6+G6

Total marks for Melissa Joan Hart:150

Formulae :=C7+D7+E7+F7+G7

Total marks for Freddie Prince JR:307

Formulae :=C8+D8+E8+F8+G8

Jin Ming,

Do not forget to e-mail your Excel file of this homework to your teacher. I would like to check from the Excel file

Jin Ming,

You’ve got an overall mark 21 out of 24. Very Good!! but unfortunately 3 marks deducted because:

-Incorrect file name

-Formulae for English should be ‘=D3+D4+D5+D6+D7+D8’

-Not following instruction on working out the FORMULAE (but good attempt on trying the FUNCTION)

THANK YOU ALL FOR BEING COOPERATIVE!!

Joanishah has made a right work. SEE what he did… that’s what I mean. 🙂

REMEMBER your DUEDATE class… =D

AND DO NOT FORGET TO ATTACH YOUR WORK AND SEND IT VIA E-MAIL to qistinah.jalil@ripas.moe.edu.bn

formulae and functions. “SUM”

total marks for each subject.

total marks for maths:358

formulae=C3+C4+C5+C6+C7+C8

total marks for english: 479

formulae= D3+D4+D5+D6+D7+D8

total marks for science: 277

formulae= E3+E4+E5+E6+E7+E8

total marks for computer: 332

formulae=F3+F4+F5+F6+F7+F8

total marks for D & T: 380

formulae=G3+G4+G5+G6+G7+G8

“TOTAL MARKS OF EACH STUDENT.”

total marks for Angelina Jolie:378

formulae=C3+D3+E3+F3+G3

total marks for Brad Pitt: 436

formulae=C4+D4+E4+F4+G4

total marks for Nicholas Cage: 340

formulae= C5+D5+E5+F5+G5

total marks for Eddie Murphy: 215

formulae=C6+D6+E6+F6+G6

total marks for Melissa Joan Hart:150

formulae=C7+D7+E7+F7+G7

total marks for Freddie Prince JR: 307

formulae= C8+D8+E8+F8+G8

Mohammad Iman,

Do not forget to e-mail your Excel file of this homework to your teacher. I would like to check from the Excel file

Mohammad Iman,

Your overall mark is 23 out of 24!! wow…. Welldone!! You’re almost close to full mark. You know why you lost 1 mark?? I have checked your Excel file…the answers that you give in your excel file is not same with the answers that you give in this blog.

You didn’t calculate using formula. Did you calculate it manually?

1. Total marks for Maths=?

Formulae for Maths=C3+C4+C5+C6+C7+C8

= 358

Total marks for English=?

Formulae for English=D3+D4+D5+D6+D7+D8

= 479

Total marks for Science=?

Formulae for Science=E3+E4+E5+E6+E7+E8

= 277

Total marks for Computer=?

Formulae for Computer=F3+F4+F5+F6+F7+F8

= 352

Total marks for D&T=?

Formulae for D&T=G3+G4+G5+G6+G7+G8

=380

2. Total marks for Angelina Jolie=?

Formulae for Angelina Jolie=C3+D3+E3+F3+G3

= 378

Total marks for Brad Pitt:?

Formulae for Brad Pitt:=C4+D4+E4+F4+G4

=436

Total marks for Nicholas=?

Formulae for Nicholas Cage:=C5+D5+E5+F5+G5

=340

Total marks for Eddie Murphy=?

Formulae for Eddie Murphy:C6+D6+E6+F6+G6

= 215

Total marks for Melissa Joan Hart=?

Formulae for Melissa Joan Hart:=C7+D7+E7+F7+G7

= 150

Total marks for Freddie Prince JR=?

Formulae for Freddie Prince JR=C8+D8+E8+F8+G8

= 307

Zulzaimirul,

Have you done with:

STEP 3 – SAVE your work as “Activity 5.4.1 -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 as well as to verify your answer)

If you haven’t do, please do so… 😀

thanks for your cooperation

Zulzamirul,

You score is 21 out of 24. Very GOOD!!

You’ve miscalculate the total marks for computer, which it is supposed to be ‘332’. You also didn’t send your EXCEL file to me.

cikgu,email (step 4) yang aku dan jin ming udah sampai arah cikgu kah,..?

betul ke macam atu buat kah?

I haven’t receive….this is my email address again, perhaps you might type a wrong one..

qistinah.jalil@ripas.moe.edu.bn

1)Total for maths = 358

Formulae for Maths =C3+C4+C5+C6+C7+C8

2)Total for english =479

Formulae for English =D3+D4+D5+D6+D7+D8

3)Total marks for Science=277

Formulae for Science=E3+E4+E5+E6+E7+E8

4)Total marks for Computer=352

Formulae for Computer=F3+F4+F5+F6+F7+F8

5)Total marks for D&T=380

Formulae for D&T=G3+G4+G5+G6+G7+G8

6) Total marks for Angelina Jolie=378

Formulae for Angelina Jolie=C3+D3+E3+F3+G3

7)Total marks for Brad Pitt:436

Formulae for Brad Pitt:=C4+D4+E4+F4+G4

8)Total marks for Nicholas=340

Formulae for Nicholas Cage:=C5+D5+E5+F5+G5

9)Total marks for Eddie Murphy=215

Formulae for Eddie Murphy:C6+D6+E6+F6+G6

10)Total marks for Melissa Joan Hart=150

Formulae for Melissa Joan Hart:=C7+D7+E7+F7+G7

11)Total marks for Freddie Prince JR=307

Formulae for Freddie Prince JR=C8+D8+E8+F8+G8

*4(COMPUTER=332*

Thanks, now…have you done with:

STEP 3 – SAVE your work as “Activity 5.4.1 -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 as well as to verify your answer)

How to send the item??

Have you save your ACTIVITY?

Now, sign in to your e-mail account. Attach your ACTIVITY EXCEL file, then send it to my e-mail address qistinah.jalil@ripas.moe.edu.bn

are you clear..?

Ammirul Adiq,

Thanks for sending your Excel file via e-mail… Happy FRIDAY!!

Ammirul Adiq,

You score is 23 out of 24. WELLDONE!!! you know why you lost 1 mark?? You have INCORRECT FILE NAME as per request. 🙂 However, good job!!

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

Nurnaqiqah.

Thanks for sending your file via e-mail. =D Happy Friday!!

Nurnaqiqah,

Your score is 24 out of 24!! AWESOME!!! wow~ You have followed all the instructions very well…

Teacher,i can’t log in my e-mail..

Which e-mail? your school e-mail account or any other account?

My school e-mail

Norafazirah,

If you couldn’t open your school mail, just use your hotmail account =D

It’ll be fine too

1. Total marks for maths=358 formulae for maths=c3+c4+c5+c6+c7+c8

Total marks for english=479

formulae for english=D3+D4+D5+D6+D7+D8

Total marks for science=277

Formulae for science=E3+E4+E5+E6+E7+E8

Total for marks for D&T= 380

Formulae for D&T=G3+G4+G5+G6+G7+G8

2. Total marks for angelina jolie= 378

Formulae for angelina jolie=C3 +D3+E3+F3+G5

Total marks for nicholas cage= 340

Formulae for nicholas cage=C5+D5+E5+F5+5G

Total marks for eddie murphy=215

Formulae for eddie murphy=C6+D6+E6+F6+G6

Joanne,

Thanks for your cooperation.. Have you done:??

STEP 3 – SAVE your work as “Activity 5.4.1 -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 as well as to verify your answer)

Joanne,

You got 13 out of 24. You seems like understand the work given BUT you forgot to answer for:

-Computer.

-Brad Pitt

-Melissa Joan Hart

-Freddie Prince JR

And you also did not send your EXCEL file via E-mail. However, Good Attempt!

teacher can i make new email so that i can send my work to your email? because my last email cant sign in 🙂

heheheh 🙂

teacher i make new email so that i can send my work to your email because my last email can sign in 🙂

sure….that would be better, right? as long as I receive your work.. 😀

Thanks for your initiative 🙂

1. Total marks for Maths : 358

Formulae for Maths : C3+C4+C5+C6+C7+C8

Total marks for English : 479

Formulae for English : D3+D4+D5+D6+D7+D8

Total marks for Science : 277

Formulae for Science : E3+E4+E5+E6+E7+E8

Total marks for Computer : 332

Formulae for Computer : F3+F4+F5+F6+F7+F8

Total marks for D&T : 380

Formulae for D&T : G3+G4+G5+G6+G7+G8

2. Total marks for Angelina Jolie : 378

Formulae for Angelina Jolie : C3+D3+E3+F3+G3

Total marks for Brad Pitt : 436

Formulae for Brad Pitt : C4+D4+E4+F4+G4

Total marks for Nicholas Cage : 340

Formulae for Nicholas Cage : C5+D5+E5+F5+G5

Total marks for Eddie Murphy : 215

Formulae for Eddie Murphy : C6+D6+E6+F6+G6

Total marks for Melissa Joan Hart : 150

Formulae for Melissa Joan Hart : C7+D7+E7+F7+G7

Total marks for Freddie Prince JR : 307

Formulae for Freddie Prince JR : C8+D8+E8+F8+G8

Nabillah,

Your score is 24 out of 24!! AWESOME!!! wow~ You have followed all the instructions very well…

@Tr Qist, my second answer is the correct one. my first one is wrong since i forgot to put my ‘G8’ & I don’t know how to remove the comment. (:

Nabillah,

It’s alright.No worries… I will remove the first one. =D

Thanks for sending your answer via e-mail 😀 Happy Friday!!

teacher have u receive my email already? 🙂

Yes boy..I have received it!! Amazing~ 🙂 Happy FRIDAY!!

Formulae and Functions: SUM

1)Total marks for Maths = 358

Formulae for Maths = C3+C4+C5+C6+C7+C8

Total marks for English = 479

Formulae for English = D3+D4+D5+D6+D7+D8

Total marks for Science = 277

Formulae for Science = E3+E4+E5+E6+E7+E8

Total marks for Computer = 332

Formulae for Computer = F3+F4+F5+F6+F7+F8

Total marks for D&T = 380

Formulae for D&T = C3+C4+C5+C6+C7+C8

2)Total marks for Angelina Jolie = 378

Formulae for Angelina Jolie = C3+D3+E3+F3+G3

Total marks for Brad Pitt = 436

Formulae for Brad Pitt = C4+D4+E4+F4+G4

Total marks for Nicholas Cage = 340

Formulae forNicholas Cage = C5+D5+E5+F5+G5

Total marks for Eddie Murphy = 215

Formulae for Eddie Murphy = C6+D6+E6+F6+G6

Total marks for Melissa Joan Hart = 150

Formulae for Melissa Joan Hart = C7+D7+E7+F7+G7

Total marks for Freddie Prince JR = 307

Formulae for Freddie Prince JR = C8+D8+E8+F8+G8

Teacher my second email for my answer is the right one because the first one was wrong. I did the function not the formulae but the answer is still the same..sorry teacher

Muhd Faris,

Thanks so much… It’s alright.. I have deleted your e-mail that you stated as wrong 😀 BUT it’s good that you’ve tried the FUNCTION 🙂 we will learn them next class.

Enjoy your Friday

correction teacher for:

Total marks for D&T = 380

Formulae for D&T = G3+G4+G5+G6+G7+G8

Sorry teacher….

Noted! =D

Muhd Faris,

Your score is 23 out of 24. WELLDONE boy!! You have done the formulae part very well!! only 1 mark lost because your filename is incorrect as instructed. =D

teacher,ada cikgu received EXCEL FILE aku dan jin ming arah cikgu punya e-mail?

Chien Yin,

I have checked my INBOX as well as JUNK MAIL, but I didn’t received any from you… Please take a second look on my e-mail address, I’m afraid that you typed it wrong. OR perhaps you could check it in SENT ITEMS.

total marks for maths: 358

formula: =c2+c3+c4+c5+c6+c7

total marks for english: 479

formula: =d2+d3+d4+d5+d6+d7

total marks for science: 277

formula: =e2+e3+e4+e5+e6+e7

total marks for computer: 332

formula: =f2+f3+f4+f5+f6+f7

total marks for D&T: 380

formula: =g2+g3+g4+g5+g6+g7

total mark for Angelina Jolie: 378

formula: =c2+d2+e2+f2+g2

total marks for Brad Pitt: 436

formula: =c3+d3+e3+f3+g3

total marks for Nicholas Cage: 340

formula: =c4+d4+e4+f4+g4

total marks for Eddie Murphy: 215

formula: =c5+d5+e5+f5+g5

total marks for Melissa Joan Hart: 150

formula: =c6+d6+e6+f6+g6

total marks for Freddie Prince JR: 307

formula: =c7+d7+e7+f7+g7

Nurmajidah,

Please do Step 4 which is e-mail your EXCEL FILE to me… =D

Nurmajidah,

Your overall mark is 22 out of 24. Very Good!! You lost 2 marks because you didn’t send your EXCEL file via e-mail as instructed by your teacher.

1)Total marks for Maths: 378

Formula: =C3+C4+C5+C6+C8

Total marks for English: 479

Formula: =D3+D4+D5+D6+D7+D8

Total marks for Science: 277

Formula: =E3+E4+E6+E7+E8

Total marks for Computer: 332

Formula: =F3+F4+F5+F7+F8

Total marks for D&T: 416

Formula: =G3+G4+G5+G6+G7+G8

2)Total marks for Angelina Jolie: 378

Formula: =C3+D3+E3+F3+G3

Total marks for Brad Pitt: 436

Formula: =C4+D4+E4+F4+G4

Total marks for Nicholas Cage: 340

Formula: =C5+D5+F5+G5

Total marks for Eddie Murphy: 251

Formula: =C6+D6+E6+G6

Total marks for Melissa Joan Hart: 150

Formula: =D7+E7+F7+G7

Total marks for Freddie Prince JR: 307

Formula: =C8+D8+E8+F8+G8

Norafazirah,

Your overall mark is 15 out of 24. Good attempt!! you have made mistakes carelessly. For example:

You typed formulae for Maths is ‘=C3+C4+C5+C6+C8’ but the EXACT formulae for Maths should be ‘=C3+C4+C5+C6+C7+C8’

You check again formulae for SCIENCE, COMPUTER, NICHOLAS CAGE, EDDIE MURPHY, and MELISSA JOAN HART.

Other mistakes are:

-Incorrect file name as instructed.

-You didn’t calculate using formulae in your EXCEL file. Did you calculate it manually?

Total mark for math:358

=c3+c4+c5+c6+c8

Total mark for English:479

=d3+d4+d5+d6+d7+d8

Total mark for Science:277

=e3+e4+e6+e7+e8

Total mark for Computer:332

=f3+f4+f5+f7+f8

Total mark for D&T:380

=g3+g4+g5+g6+g7+g8

Total mark for Angelina Jolie:378

=c3+d3+e3+f3+g3

Total mark for Brad Pitt:436

=c4+d4+e4+f4+g4

Total mark for Nicholas Cage:340

=c5+d5+f5+g5

Total mark for Eddie Murphy:215

=c6+d6+e6+g6

Total mark for Melissa Joan Hart:150

=d7+e7+f7+g7

Total mark for Freddie Prince JR:307

=c8+d8+e8+f8+g8

Nurazirah,

Thanks so much… Please do STEP 4, which is e-mail your answer to mine

Nurazirah,

Your score is 16 out of 24. Good Attempt!! you have made mistakes carelessly. For example:

You typed formulae for Maths is ‘=C3+C4+C5+C6+C8′ but the EXACT formulae for Maths should be ‘=C3+C4+C5+C6+C7+C8′

You check again formulae for SCIENCE, COMPUTER, NICHOLAS CAGE, EDDIE MURPHY, and MELISSA JOAN HART.

You also lost mark because you didn’t send your EXCEL file via E-mail as instructed earlier.

cher,tadi aku htr EXCEL FILE pukul 5.00…cikgu ada received kah?

I have received it…Thank you… 😀

cher,u welcome 🙂

Teacher,i can’t log in to my other e-mail..so i make a new e-mail to post the ans to you.. 😀

Alright… 🙂 as long as you can manage your problem and as long as I receive your Excel file.. 😀

Thank you for your initiative fazirah.. 🙂

Norafazirah,

Thanks for your e-mail. I have received your work!!

Formulae and Functions: SUM

1)Total marks for Maths = 358

Formulae for Maths = C3+C4+C5+C6+C7+C8

Total marks for English = 479

Formulae for English = D3+D4+D5+D6+D7+D8

Total marks for Science = 277

Formulae for Science = E3+E4+E5+E6+E7+E8

Total marks for Computer = 332

Formulae for Computer = F3+F4+F5+F6+F7+F8

Total marks for D&T = 380

Formulae for D&T = C3+C4+C5+C6+C7+C8

2)Total marks for Angelina Jolie = 378

Formulae for Angelina Jolie = C3+D3+E3+F3+G3

Total marks for Brad Pitt = 436

Formulae for Brad Pitt = C4+D4+E4+F4+G4

Total marks for Nicholas Cage = 340

Formulae forNicholas Cage = C5+D5+E5+F5+G5

Total marks for Eddie Murphy = 215

Formulae for Eddie Murphy = C6+D6+E6+F6+G6

Total marks for Melissa Joan Hart = 150

Formulae for Melissa Joan Hart = C7+D7+E7+F7+G7

Total marks for Freddie Prince JR = 307

Formulae for Freddie Prince JR = C8+D8+E8+F8+G8

Sorry last minute I sent this h/w to you, teacher..

Thank you…

Please e-mail your answer too… 🙂

Wusalim,

Thanks for sending your work via e-mail…. I will mark it soon!! 🙂

Wusalim,

You score is 23 out of 24. Welldone!!

You lost 1 mark because of wrong file name: “Book1”

The correct one should be in this format: “Activity 5.4.1 – Wusalim”

NO.1 total mark for math:358

formula:=C5+C6+C7+C8+C8+C9+C10

total mark for english:479

formula:=D5+D6+D7+D8+D9+D10

total mark for science:227

formula :=E5+E6+E6+E7+E8+E9+E10

total for computer:332

formula:=F5+F6+F6+F7+F8+F9+F10

total for D&T:380

formula:=G5+G6+G7+G8+G9+G10

NO.2

TOTAL MARK FOR ANGGELINA JOLIE:378

FORMULA:=C5+D5+E5+F5+G5

TOTAL MARK FOR BRAD PITT:436

FORMULAE:=C6+D6+E6+F6+G6

TOTAL MARK FOR EDDIE MURPHY:215

FORMULAE:=C8+D8+E8+F8+G8

TOTAL MARK FOR MELISSA JOAN HART:150

FORMULAE:=C9+D9+E9+F9+G9

TOTAL MARK FOR FREDDIE PRINCE JR:307

FORMULAE:=C10+D10+E10+F10+G10

TOTAL MARK FOR NICHOLAS CAGE:340

FORMULAE:=C7+D7+E7+F7+G7

Rabiee,

Your score is 18 out of 24. Not bad, Rabiee.. I guess you have typed carelessly in:

NO.1 total mark for math:358

formula:=C5+C6+C7+C8+C8+C9+C10

(Supposed to be: =C5+C6+C7+C8+C9+C10)

total mark for science:227

(Supposed to be: 277)

formula :=E5+E6+E6+E7+E8+E9+E10

(Supposed to be: =E5+E6+E7+E8+E9+E10)

total for computer:332

formula:=F5+F6+F6+F7+F8+F9+F10

(Supposed to be: =F5+F6+F7+F8+F9+F10)

Please be more attentive in your work… =D

SORRY TEACHER … I SENT IT TOOOOOO………………………………….LATE SORRY TEACHER…… CAN YOU GIVE MY MARK EARLY TEACHER??

Rabiee,

Can you send me your EXCEL FILE by e-mail so that I can check your answer. I will mark your work soon….

ok teacher 🙂