computer_resources

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

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
Advertisements
 

I just would like you to have your own….. February 20, 2012

Filed under: Uncategorized — computer_resources @ 4:33 am

To make a COPY for yourself for all the homework that you done in this BLOG by PRINTING the QUESTIONS POSTED together with YOUR ANSWER

AFTER your teacher marked your answer.

The purpose is for you to refer to for your REVISION!!

 

Homework For Week 7

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.

 

 

 

One Team, Many ideas….Many Solutions!! February 19, 2012

Filed under: Uncategorized — computer_resources @ 5:58 am

Dear students,

Here are some IMPORTANT information for you to read.  I just would like to share with you all because I believe learning in TEAMWORK or GROUP WORK helps us a lot.  It is an effective way for us to learn in group because you could see different solutions, ways, ideas from others.

http://teacherbootcamp.edublogs.org/2010/11/19/cooperative-learning-effective-team-work-15-resources/

The benefits of cooperative learning. Through cooperative learning students learn effective team work through:

  • Accountability– students realize the contribution of each individual will determine the success of the task.
  • Team building– students learn how to listen to each other, resolve conflicts, delegate tasks, set deadlines and support each other.

 

 

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