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