[Year 12 IT Apps] Examination reports

[Robert]

And I have just checked Open Office. Different again.

Requires semicolons rather than commas as separators between items, eg

=IF(C2>40;"yes";"no")

?


Robert Hind (Semi-retired)
Ashwood and Traralgon
robert at yinnar.com


----- Original Message ----- 
From: "Robert" <robert at yinnar.com>
To: <itapps at edulists.com.au>
Sent: Friday, August 07, 2009 3:50 PM
Subject: Fw: [Year 12 IT Apps] Examination reports


> Whoops! I missed out one (double straight) quote :-)
>
> Should have read:
>
> And can I add to Mark's message by noting that Excel does not like "smart 
> quotes", or curly quotes but only straight quotes, ie
>
> =IF(C2>40,"YES"," ")
>
> Robert Hind (Semi-retired)
> Ashwood and Traralgon
> robert at yinnar.com
>
>
>
> ----- Original Message ----- 
> From: "Robert" <robert at yinnar.com>
> To: "Year 12 IT Applications Teachers' Mailing List" 
> <itapps at edulists.com.au>
> Sent: Friday, August 07, 2009 3:33 PM
> Subject: Re: [Year 12 IT Apps] Examination reports
>
>
>> And can I add to Mark's message by noting that Excel does not like "smart 
>> quotes", or curly quotes but only straight quotes, ie
>>
>> =IF(C2>40,"YES," ")
>>
>> Pedantic? Yes! But Excel, and other apps, will only accept exactly what 
>> they have been programmed to expect.
>>
>> Robert Hind (Semi-retired)
>> Ashwood and Traralgon
>> robert at yinnar.com
>>
>>
>>
>>
>> ----- Original Message ----- 
>> From: "Mark Kelly" <kel at mckinnonsc.vic.edu.au>
>> To: "Year 12 IT Applications Teachers' Mailing List" 
>> <itapps at edulists.com.au>
>> Sent: Friday, August 07, 2009 1:26 PM
>> Subject: Re: [Year 12 IT Apps] Examination reports
>>
>>
>>> Examiners' report, ITA Q12b:
>>>
>>> Quote
>>>
>>> Few students could correctly write the formula for the IF statement 
>>> =IF(C2>40, ‘YES’,’ ‘).
>>>
>>> End Quote
>>>
>>> And fewer examiners could either, apparently:  double quotes rather than 
>>> single quotes are needed (at least in Excel, which is the undeclared 
>>> standard for all spreadsheet questions in the exam).
>>>
>>> It does bug me when a commentary on what is correct and what is not gets 
>>> it wrong.
>>>
>>> Christophersen, Paula P wrote:
>>>> Dear colleagues
>>>>
>>>>  In case you are not aware, the examination reports for the 2008 exams 
>>>> in
>>>> IT apps and Software development are available at the following
>>>> addresses.
>>>>
>>>>
>>>> http://www.vcaa.vic.edu.au/vce/studies/infotech/it-applications/exams.ht
>>>> ml#H2N10037
>>>>
>>>>
>>>> http://www.vcaa.vic.edu.au/vce/studies/infotech/softwaredevel/exams.html
>>>> #H2N10037
>>>>
>>>>  Regards
>>>>
>>>> Paula
>>>>
>>>>  Paula Christophersen
>>>>
>>>> ICT Curriculum Manager
>>>>
>>>> VCAA
>>>>
>>>> 41 St Andrews Place
>>>>
>>>> EAST MELBOURNE 3002
>>>>
>>>> (03) 9651 4378
>>>>
>>>>  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 and Early Childhood Development.
>>>>
>>>
>>> -- 
>>> Mark Kelly
>>> Manager - Information Systems
>>> McKinnon Secondary College
>>> kel AT mckinnonsc.vic.edu.au
>>> McKinnon Rd, McKinnon 3204, Victoria, Australia
>>> Direct line / Voicemail: 8520 9085 Fax +613 9578 9253
>>>
>>> Webmaster - http://www.mckinnonsc.vic.edu.au
>>> IT Lecture notes: http://vceit.com
>>> Moderator: IT Applications Mailing List
>>>
>>> Why do people mis-spell 'grammar' and mispronounce 'pronuniciation'?
>>> _______________________________________________
>>> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
>>> IT Applications Mailing List kindly supported by
>>> http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html - 
>>> Victorian Curriculum and Assessment Authority and
>>> http://www.vitta.org.au  - VITTA Victorian Information Technology 
>>> Teachers Association Inc
>>>
>>
>>
>> _______________________________________________
>> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
>> IT Applications Mailing List kindly supported by
>> http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html - 
>> Victorian Curriculum and Assessment Authority and
>> http://www.vitta.org.au  - VITTA Victorian Information Technology 
>> Teachers Association Inc
>>
>
>
> _______________________________________________
> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
> IT Applications Mailing List kindly supported by
> http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html - 
> Victorian Curriculum and Assessment Authority and
> http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers 
> Association Inc
>