[Year 12 IT Apps] Re: [Year 12 IPM] Suggested spreadsheet functions to teach for ITA U4O1

[Russell Edwards]

On 30/11/2006, at 9:16 PM, Mark Kelly wrote:

> A free unofficial, personal guide about how much spreadsheeting kids
> need to know for ITA U4O1...
>
> Anything I've forgotten or screwed up?
>

Your list seems eminently sensible. It's probably also worth bearing  
in mind the VCAA software functions list for spreadsheets:

* lookup tables
* conditional formatting
* conditional statements
* cell protection
* graphs
* insert notes/comments
* macros
* relative and absolute cell references
* naming a range
* electronic validation
* sheet referencing
* formatting/layout.

I take "layout" to be the link to stuff about formats and  
conventions, interfaces, yadda yadda yadda....

Russell



Important - This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education.