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
 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s