Tuesday, September 30, 2014

Interesting Read...



They say money doesn't grow on trees, but did you know a salad can? Over the past 20 years farmers James and Kerry West have developed what they called Fruit Salad Trees - one potted plant that can grow a variety of fruits all at once! The miracle plants come in varieties like citrus, stone fruits and multi-apples, growing all the ingredients for a delicious fruit salad on one plant!

The Wests dreamed up the fruit salad tree back in the early 1990s, and slowly began experimenting with saplings. By gradually cutting, taping together and grafting different kinds of tree, they finally were able to get the fruit bearers to harmonize, forming one unified tree.

The Fruit Salad Trees can bear up to six different kinds of fruits, like peaches, plums, nectarines, apricots and peachcots, or even oranges, lemons, limes and grapefruit. Raised in Australia, the plants can be shipped worldwide, with a tree to suit every climate.


Urban farmers can even partake in the magic of the Fruit Salad Tree, as the plants do well in fields, but also in indoor planters. Fruit Salad Trees are a great way to grow a variety of home grown fruits when you have little space. They do say variety is the spice of life!


In July of this year, even further advancements have been made in this area; a multicolored tree that produces 40 different kinds of fruits has also been grafted.  If you're interested in reading more on this, check out the following link:
http://inhabitat.com/amazing-multicolored-tree-produces-40-different-kinds-of-fruit/#ixzz3ErJB8LBF

Tuesday, September 23, 2014

Wall of Fame... Test 1 Results

Congratulations to the following students:
Rhiki Alegria - Class 3A
Lucas Cal - Class 3A
Nestor Leonardo - Class 3C
Syon Vasquez - Class 3C
Anthony Phillips - Class 3D
Goldberg Samuels - Class 3D
Zydane Thompson - Class 3D
Krishaun Villafranco - Class 3D

You all brought your "A-game" to the test and earned an A
Pick up your bonus buck from me, then bring it on the raffle date to trade it for an entry in the A-Game Test Raffle.
Upcoming raffle:  Friday, September 26, 2014 at midday in the IT Lab


Excel Homework for all 3rd form classes

Due dates:
3A and 3C - Day 1 Cycle 4
3D - Day 3 Cycle 4

In notebooks

Using the Spreadsheet below, write IF Statements for the following:


  1. Let’s suppose sales have to be greater than or equal to $100K for a salesman to receive a 12% bonus, write the If Statement that would be applicable for this scenario.
  2. Now let's suppose that sales have to be greater than or equal to $100K for a salesman to receive a 12% bonus; or greater than or equal to $200K for a salesman to receive a 15% bonus; but suppose sales is less than $100K, then the salesman will only receive 5% bonus.  Write the If Statement that would be applicable.
  3. Write the if statement that would be placed in Cell C3 to state if the difference between the maximum and the minimum is $10,000 or more, the minimum should be increased by 5%; otherwise it should remain the same.
  4. Using the same spreadsheet, lets practice writing criteria for filtering.  First, let's extract all Sales that are greater than $100,000.00  Write the applicable criterion.

Thursday, September 18, 2014

Class 3A Homework

Homework to be completed in notebooks.
Due Cycle 3 Day 5
Topic: Spreadsheet

Information Technology for CSEC 3rd Edition
Page 309
Exercise 7b.

Modify the questions as follows:

  • Using absolute referencing, calculate the prices for "Hot"
  • Using relative referencing, calculate the prices for "Madd"
  • Using mixed referencing, calculate the price for "Teen"

Note:  Come prepared next class for a theory quiz on the basic functions and use of formulae in Excel