computer_resources

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

Reflection on Homework for Week 7 March 26, 2012

Filed under: Homework — computer_resources @ 4:51 am

Dear students,

Sorry for late marking of your homework!  I have tonnes of work to be done at UBD; my assignments, group working activities, meetings…. pheewww!! at last your homework completely checked~

So please have a check… I have came across that some of you haven’t submit your work.  They are Khairurrabi’ee, Hazwan, and Joane.

Here is a good example that I would like to acknowledge Muhd  Faris Syarifuddin bin Hj Hirwan.  He organised his table well by formating it with borders and colours.  Very neat, indeed!!  (*** DOUBLE CLICK ON THE IMAGE TO GET A FULL IMAGE)

Advertisements
 

Homework For Week 7 February 20, 2012

Filed under: Homework — computer_resources @ 3:57 am

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

 

Answer: Homework For Week 6

Filed under: Homework — computer_resources @ 3:21 am

Students,

Perhaps you did not see the video clearly during our lesson today, here is the video I uploaded that regards with your Homework for Week 6 covering FORMULAE.

 

 

 

With regards to Homework for Week 6 February 17, 2012

Filed under: Homework — computer_resources @ 8:15 am

For you to be aware of

I have received answer via BLOG from:

  1. Joanishah
  2. Chien Jin Ming
  3. Zulzamirul Zambreen
  4. Ammirul Adiq
  5. Chien Yin
  6. Joane
  7. Norafazirah
  8. Nurul Nabillah
  9. Md Iman
  10. Nurnaqiqah
  11. Muhd Faris
  12. Nurmajidah Hazirah 
  13. Nurazirah
  14. Wusalim (Received on 20 Feb)

I only received EXCEL FILE via E-MAIL from:

  1. Ammirul Adiq
  2. Nurul Nabillah
  3. Md Iman
  4. Nurnaqiqah
  5. Muhd Faris
  6. Chien Jin Ming
  7. Chien Yin
  8. Norafazirah

So to those who haven’t post their work on blog OR send it via e-mail, please do so!! Your COOPERATION is very needed… INDEED!!

I remind you once again, TODAY IS THE

OF YOUR SUBMISSION

 

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

 

Homework for Week 2 January 15, 2012

Filed under: Homework — computer_resources @ 6:39 am

This homework MUST be FINISHED by THURSDAY, 19 JANUARY 2012

Instruction:

Answer the questions by indicating the “question number”

**********************************************************************

Q1. What is spreadsheet?

Q2. Give 2 examples of spreadsheet package

Q3. Columns are …………… (horizontal/vertical) and named with letters, like A, B, C and D.

Q4. Rows are …………… (horizontal/vertical) and named with numbers, like 1, 2, 3 and 4.

Q5. In the following diagram, the cell reference shows that it is at A1.  A1 is the space where …………………………… meets …………………………………..

Q6. (a) What is the cell address shown?

(b) How do you make sure if you have got the correct cell?

Q7. What is the range of the highlighted cells shown below?

(a) E11:G11   (b) E11:G12    (c) E12:G11    (d) E11:12G

 

Q8. Answer TRUE or FALSE for each statement

(a) Rows are vertical and named with letters.

(b) 5A is an example of a cell address.

(c) Spreadsheets can be used to calculate test results.

*For the FALSE statement, rewrite them  correctly by changing one word.

 

Q9.  To calculate companies profit or loss, which type of application should be used?

(a) Desktop Publishing     (b) Database      (c) Spreadsheet    (d) Word Processing

 

Q10.  The cell reference for the shaded cell is

(a) B:2           (b) 2:B            (c) B2               (d) 2B

 

Q11. What is the name of the cell in column G & row 20?

(a)  0G20     (b) 20G        (c) G20       (d) 20Go

 

Q12. A way to put DATA in order

(a) Sort       (b) Ascending        (c) Pattern     (d) Average

 

Q13. Sorting in alphabetical order A-Z

(a) Average      (b) Pattern       (c) Sort        (d) Ascending

 

Q14. Which toolbar icon is used to merge cells?

(a)          (b)           (c)                (d)

 

Q15.  One box in a Spreadsheet.  The place where a row and a column intersect.

(a) cell      (b) column        (c) row        (d) alignment

 

Q16. Setting up cell so writing is at top, bottom, center, left, or right side of the cell.

(a) cell      (b) column        (c) row        (d) alignment

 

Q17. A button on the tool bar that automatically adds up numbers.

(a)          (b)           (c)                (d)

 

Q18.  What is a cell?

 

Q19. What do you understand by the cell B5?

 

Q20. What is a range?  Give one example of a range.