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

Please do comment here if you still in doubt… Your comments are very much appreciated!!

Advertisements
 

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)

 

Spreadsheet Project!! February 25, 2012

Filed under: Project — computer_resources @ 5:50 pm

Ask yourselves…. 😀

THEMES FOR YOUR PROJECT: Dessert

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 –

Adjust your worksheet that fit into single page, Portrait.
Set the margins – Center on page: Both Horizontally and Vertically.
Insert Header: “Spreadsheet Project – Dessert”
Insert Footer: “Your name and class”

  • Save As your project as DESSERT-your name.
  • 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)

  • Continue your TASK 2 by adding ‘SHEET 2’ and Rename “Total Sales”
  • 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 –

Adjust your worksheet that fit into single page, Landscape.
Set the margins – Center on page: Both Horizontally and Vertically.
Insert Header: “Spreadsheet Project – Dessert”
Insert Footer: “Your name and class”

  • Save As your project as DESSERT-your name.
  • Give your HARD COPY (printed copy) to teacher.
  • E-mail your SOFT COPY to qistinah.jalil@ripas.moe.edu.bn
 

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