Fw: [Year 12 IT Apps] Examination reports

[Robert]

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
>