Monday, September 3, 2012
We continued with advanced Microsoft Excel functions tonight. The IF function consists of 3 parts: 1) a condition; 2) a True part and; 3) a False part. IF allows one to specify a condition, and if the condition is met then Excel will return the specified result (the True part). This result can be calculation or even a line of text. Should the condition not be met then Excel will return an alternative result (the False part).
We took this one step further by using a Nested IF. A nested if is when we put a second IF statement inside of an existing IF, in the place of the False part. This way one can build on the outcomes by having three possible outcomes instead of two. In the example we used, we created an admission system to our own 'night club' for 13 year olds. People of age 12 and under were sent back home, 13 year olds were welcomed in, those aged 14 and older were turned away. :-) By the way, one can have up to 7 Nested IFs inside one another.
We also looked at a cool website used to create your own short comic strips. Make Beliefs Comix allows you to make a comic of 2 - 3 panels. It has a multitude of characters, props, speech bubbles, thought bubbles, and panel prompts to choose from. You can add colour and adjust the position and scale of everything you add to your panels. These comics can then be printed or emailed. The computer club members were asked to go home and make their own comic strip about the computer club and mail it to me.
It looks like the computer club won't meet for a long time. With the outdoor education week, a public holiday, and the September school holiday coming up, we'll only meet again on 15 October 2012.
Until next time. Have a wonderful holiday and come back home safely.
Posted by Sea Grass at 1:21 PM