[Year 12 IT Apps] Examination reports

Sat Aug 8 14:02:14 EST 2009

Yes, it isnt so much as they came up with something different or that
they have invented a new standard. There is an open standards group
that is trying to improve the exchange of recalculated formulas in
spreadsheets and I suspect that is what they have used. Google Docs
uses this format too. Let me check. Yep .. works with double quotes.

Curious I did not directly spot this before as I jump across between
XLS, ODC and GoogleDocs. Shows how plastic our minds are to these
subtle changes. I guess when it flags an error, I just thump my
forehead to shake a neuron loose and amend the formula with either
single or double quotes. REM hmmm

Regards Roland

2009/8/7 Robert <robert at yinnar.com>:
> 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
>>
>
>
> _______________________________________________
> 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
>

-- 
Roland Gesthuizen - ICT Coordinator - Westall Secondary College
http://www.westallsc.vic.edu.au

"Never doubt that a small group of thoughtful, committed citizens can
change the world; indeed it is the only thing that ever has."
--Margaret Mead