# computer_resources

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

### Do you have any PROBLEM with Task 3?April 2, 2012

Filed under: Project — computer_resources @ 4:02 am

I am still worrying that there might some of you finding it’s difficult to find the NET PROFIT.

As I explained in the classroom, in the TASK 3; it is given that:

NET PROFIT = TOTAL SALES – TOTAL EXPENSES

I explained to you that you need to find NET PROFIT for EACH RECIPE.

Let say, you have CHOCOLATE CUPCAKES, so you need to find NET PROFIT FOR CHOCOLATE CUPCAKES.  (This is only an example)

Below is the diagram of TOTAL EXPENSES of Chocolate Cupcakes for 1 month.

So, How to find TOTAL SALES & NET PROFIT?

To find TOTAL SALES, don’t just put a BIG ASSUMPTION on the amount.  Here are the clues:

If you look on the diagram above, the TOTAL EXPENSES= \$54.20  (This is the amount that you have spent on buying ingredients of 1 recipe FOR ONE MONTH)

Think LOGICALLY!!  one month = 4 weeks. You approximately divide TOTAL EXPENSES, \$54.20 by 4 weeks = \$13.55 per week.

Let say in week 1, you sell your product (Chocolate Cupcake) in a BOX every MONDAY, WEDNESDAY, and SATURDAY.  Below is the calculation:

1 box (consists of 2 cupcakes) costs \$1.50.  You sell 5 boxes per day.

• If 5 boxes were sold, you will get \$7.50 per day.
• If only 3 boxes were sold, you will get \$4.50 per day.
• IF you refer to the table above, it is actually calculated such as:
• MONDAY:5 boxes were sold  X  \$1.50 =  \$7.50
• WEDNESDAY: 5 boxes were sold  X  \$1.50 =  \$7.50
• SATURDAY: 5 boxes were sold  X  \$1.50 =  \$7.50

**\$7.50 + \$7.50 + \$7.50 = \$22.50 for WEEK 1  (You also need to do estimation for the rest of the weeks)

NOW!! Total up the TOTAL SALES OF ALL WEEKS For Chocolate Cupcakes

Week 1 = \$22.50

Week 2 = \$18.00

Week 3 = \$13.50

Week 4 = \$22.50

You sum them up, =\$76.50

*******

FINALLY!! Finding the NET PROFIT For Chocolate Cupcakes

Formula is: “NET PROFIT = TOTAL SALES – TOTAL EXPENSES”

NET PROFIT (\$22.30) = TOTAL SALES (\$76.50) – TOTAL EXPENSES (\$54.20)

***YOU NEED TO FIND NET PROFIT FOR EACH RECIPE***

### Reflection on Homework for Week 7March 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)

Filed under: Project — computer_resources @ 5:50 pm

AIM: For selling purpose.

Minimum required: 2 desserts.

Maximum required: 4 desserts.

TASK 1  (TIME FRAME: 27 Feb –  12 Mar)

• Search from the Internet and print the chosen recipes.
• Take the ingredients from the recipes.  (Work it out while you having school’s holiday)

TASK 2 (TIME FRAME: 26 Mar – 2 Apr)

• Start Microsoft Office Excel
• Begin with ‘SHEET 1’ and Rename “Things to Buy for 1 Month”
• Create table for each recipe, with label “ITEMS”, “QUANTITY”, “UNIT PRICE”, “AMOUNT” and “TOTAL EXPENSES”.  Diagram below is just an example:

• Enter all the data that you have taken from the recipe in TASK 1.
• Sort the ITEMS in ascending order.
• Formatting the cell – colours and borders
• Do appropriate calculation on the table that you created.

FINALIZING

• Page Setup and Printing –

Set the margins – Center on page: Both Horizontally and Vertically.
Insert Footer: “Your name and class”

• Give your HARD COPY (printed copy) to teacher.
• E-mail your SOFT COPY to qistinah.jalil@ripas.moe.edu.bn

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

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

TASK 3 (TIME FRAME: 2 Apr-9 Apr)

• Create table for month January.  Label the table “ITEMS”, “WEEK 1”, “WEEK 2”, “WEEK 3”, “WEEK 4”, “TOTAL SALES”, and “TOTAL”.  Diagram below is just an example:

• Formatting the cell – colours and borders
• Do appropriate calculation on the table that you created.
• Provide BAR CHART for the JANUARY sales.

FINALIZING

• Page Setup and Printing –

Set the margins – Center on page: Both Horizontally and Vertically.
Insert Footer: “Your name and class”

• Give your HARD COPY (printed copy) to teacher.
• E-mail your SOFT COPY to qistinah.jalil@ripas.moe.edu.bn

### Homework For Week 7February 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)

Formulae and functions: “SUM”

…………

………..

……….

……

and the rest of the subjects.

…………

…………

…….

….

and the rest of the students.

Functions: “AVERAGE”

…………

………..

……….

……

and the rest of the subjects.

…………

…………

…….

….

and the rest of the students.

Functions: “MAX, MIN, and COUNT”

…………

………..

……….

……

and the rest of the subjects.

…………

………..

……….

……

and the rest of the subjects.

…………

………..

……….

……

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 6February 17, 2012

Filed under: Homework — computer_resources @ 8:15 am

For you to be aware of

1. Joanishah
2. Chien Jin Ming
3. Zulzamirul Zambreen
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:

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

### Homework for Week 6February 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)

Formulae and functions: “SUM”

…………

………..

……….

……

and the rest of the subjects.

…………

…………

…….

….

and the rest of the students.

Are you clear?