Monday, August 20, 2012

Lookup & Moovl

We can't always just have fun - we need to do some serious work too.  :-) This evening the Sunridge Computer Club looked into Microsoft Excel - specifically the VLOOKUP function. This is probably one of the most useful functions Excel has to offer. It allows you to look up a value from a pre-defined list (table) by referencing it with a value you enter into the spreadsheet. 

One such useful application for this function is for us teachers to have a list of percentages 0% - 100%, and alongside that are listed the various levels used on our learners' reports for grades 6 & 7 for example.  Using this method, we can have one centrally located correct list where all the teachers can work from. Teachers enter their marks onto their own spreadsheet which converts the mark to a percentage. Their spreadsheet then uses that percentage to reference the level from the appropriate column in the pre-defined list.

Needless to say, the computer club members had no problem mastering this function - despite the fact that the VLOOKUP function uses four variables. I'll have to think up something more complicated next time. :-)

We had some time left so we had a look at a nifty online app (also available for smartboards) called Moovl. Moovle applies the laws of physics by allowing you to draw objects and have you manipulate factors such as gravity, it's density, and firmness by changing an objects "stickiness", "slippiness", and other fun descriptions.

Our next club meeting will be on Monday evening, 3 September 2012.

Until next time...

1 comment: