Week Ending 17/11/06

During this week, in class and at home i have learnt bits a pieces about spreadsheets. I have learnt about Conditional Formatting which format cells depending on their contents or those of another cell. I have also learnt about how to set up a system within the spreadsheets, i can now password protect certain cells that i don't want other people to edit e.g. cells with formulas etc. During task 2, i also not only learnt about passwording cells but about passwording the entire spreadsheets, upon making a system i can use the Validation function which means i can set rules which will determine whether data entered into a cell is valid for your application. I have a number of options which can be set:

• Data type (whole number, decimal, date, time)
• Text length
• Range check
• List check

During task three, i am beging to learn about the IF function and various other Conditional Functions, i am already kind of familar with the IF function as i use it in PHP when coding websites but the IF function in excel i slightly different which i am now currently learning.

Letter

Dear Mr Barr and MS O’Carolann
I am writing to thank you for helping me get an A Grade at AS Applied ICT this year. I am grateful for all the support and help that you have given me during this year.

To achieve an A in Applied ICT, I had to pay attention in class, be prepared and well organised for class, to regularly attend class and be on time for class, to revise for all exams when needed, to draw up a thorough revision timetable for preparation for the exams

I also thank you both for the hard work and effort that you put into our class over the past year to ensure we got the grades we deserved, for helping us with our coursework and teaching us very effectively, thank you for providing us with good notes, and for making class more enjoyable and understandable through the use of ict. If we ever missed a day during class we were able to go on to www.blogger.com to catch up on any work that was missed... this also improved our communication skills