Secondary 4

(1) Scratch Game

Butterfly Game

Conditions

1. When the Spacebar is pressed, the butterfly continuously moves towards the mouse.
2. When the butterfly is clicked on top of any of the 2 flowers, the flower will disappear, and the player scores
3. 25 points (Red Flower) or 100 points (Yellow Flower).
4. If the Score = 125 points, the player wins the game.
5. If the butterfly touches the blue borders, the game is over.

Thinking Questions

• How do you make the butterfly point and move towards the mouse pointer?
• How do you cause the flower to disappear when the butterfly is clicked while being on top of it?
• How do you make sure that the points do not continue to increase because the butterfly touches the flower for too long?

(2) MS-EXCEL | LOOKUP functions

Spreadsheet with LookUp

The MS-Excel spreadsheet requires you complete a spreadsheet made up of 2 tables.

The top table "looks up" the values from the bottom table.

There are 2 LOOKUP functions, we need to know

VLOOKUP : Looks up tables arranged by columns

HLOOKUP : Looks up tables by rows

....

Since, the bottom table is arranged in columns, we will use the VLOOKUP function.

VLOOKUP (Cell_Address, Lookup_Range, Column_Number, FALSE)

• Cell_Address : The cell in the top table which has a common value with the bottom table.
• Lookup_Range : The entire range in the bottom table (Highlight the entire table)
• Column_Number : The column number in the bottom table.
• FALSE :

example (not from the question)

=VLOOKUP(B2, B20:B25, 3, FALSE)

• B2 > an address in the top table (which has a common value with the bottom table)
• B20: B25 > a range of value from the bottom table
• 3 > column number 3 in bottom table
• FALSE > FALSE is reserved for approximate match which is the best in many cases.

...

For all other MS-Excel Spreadsheet functions, goto http://tinyurl.com/learn-cpa-sst