computer_resources

The purpose of this site is for my teaching aids in Computer Studies as well as ICT subjects

Homework for Week 6 February 12, 2012

Filed under: Homework — computer_resources @ 9:07 am

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

Advertisements
 

97 Responses to “Homework for Week 6”

  1. Norafazirah Binti Ramlan Says:

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

  2. Norafazirah Binti Ramlan Says:

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

  3. jin ming Says:

    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

    • Ammirul Adiq Bin Yanam Says:

      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?

      • Ammirul Adiq Bin Yanam Says:

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

  4. Ammirul Adiq Bin Yanam Says:

    How To do with the step ONE?

  5. Nurmajidah Hazirah Binti Majid Says:

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

  6. Mohammad Iman bin Abdullah Says:

    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?

  7. jin ming Says:

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

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

  9. chien yin Says:

    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)

    • chien yin Says:

      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)

  10. jin ming Says:

    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)

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

  12. Mohammad Iman bin Abdullah Says:

    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?

  13. zulzaimirul zambreen bin zulkefli Says:

    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.

  14. chien yin Says:

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

    betul ke macam atu buat kah?

  15. Ammirul Adiq Bin Yanam Says:

    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

  16. Nurnaqiqah Morni Says:

    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

  17. Norafazirah Binti Ramlan Says:

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

  18. Joane Exclase Wee Says:

    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!

  19. Mohammad iman bin abdullah Says:

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

  20. Mohammad iman bin abdullah Says:

    heheheh 🙂

  21. Mohammad iman bin abdullah Says:

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

  22. Nurul Nabillah Binti Abdullah Says:

    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

  23. Nurul Nabillah Binti Abdullah Says:

    @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. (:

  24. Mohammad iman bin abdullah Says:

    teacher have u receive my email already? 🙂

  25. Muhd Faris Syarifuddinbin Hj Hirwan Says:

    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

  26. chien yin Says:

    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.

  27. Nurmajidah Hazirah Binti Majid Says:

    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

  28. Norafazirah Binti Ramlan Says:

    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.

  29. Nurazirah Binti Ismail Says:

    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.

  30. chien yin Says:

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

  31. Norafazirah Binti Ramlan Says:

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

  32. Mohd Wusalim Bin Abdullah Says:

    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

  33. rabiee Says:

    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

  34. rabiee Says:

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

  35. rabiee Says:

    ok teacher 🙂


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s