<div dir="ltr">Hi Damien. <div><br></div><div>By "the big question" are you referring to the 8-10 mark question that has appeared in the past couple of ITA papers?<div><br></div><div>- Such big, high-mark questions are purely at the whim of the exam-setters... there is nothing in the study design saying that such a question is required, so there is no guarantee that such a question will appear in future. </div>
<div><br></div><div>- Having said that, recent history suggests that the examiners <b>will </b>continue to do it in spite of horrible results: last year's average result was 2 marks out of 8, from memory. ITA kids are just not built for long, complex answers. To be frank, that's why they do ITA rather than SD or physics.</div>
<div><br></div><div>- Even if such a question appears again this year, there is no guarantee that it would have to be about databases, or a database/spreadsheet option. It could just as easily be about data security or any other meaty key knowledge. (Dog help me, it had better <b>not</b> be about the physical layer of the OSI model !)</div>
<div><br></div><div>- What students will need to provide in their answers will completely depend on what the question asks them to provide, so it's impossible to answer your question. If asked for a formula, they will need to provide a formula; if asked for a design for an input form, they would need to give that.</div>
<div><br></div><div>- SQL definitely won't be there, if that's any consolation, since it is not mentioned or even alluded to in the study design.</div><div><br></div><div>- Neither can the examiners even ask for a precise formula or query, since different databases/spreadsheets have different syntaxes. They would either have to give students the rules for the syntax of a hypothetical dB/SS and expect students to answer using the provided syntax, or they would have to use universally-accepted IT/VCAA conventions (i.e. pseudocode with standard IF , AND/OR, >= , etc.)</div>
<div><br></div><div>So, having not answered your question at all, I hope I have answered your question.</div><div><br></div><div>Regards</div><div><br></div><div>Mark</div><div>Whose beach-walking has been <b>greatly</b> incommoded by rain and hurricane-force wind. Grrr.</div>
<div><div class="gmail_extra"><br><div class="gmail_quote">On 29 October 2013 14:10, ATKINSON-BUCK, Damien <span dir="ltr"><<a href="mailto:Damien.ATKINSON-BUCK@ivanhoe.com.au" target="_blank">Damien.ATKINSON-BUCK@ivanhoe.com.au</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div lang="EN-AU" link="blue" vlink="purple">
<div>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Arial,sans-serif">Hi folks,</span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Arial,sans-serif"> With the big question, I’ve been going through some of the past exam papers and the examiners comments. Am I right to assume that if a student chooses the SpreadSheet
option, they will need to provide the formula. Whereas if they choose the database option, they have to describe the query, not write SQL or draw a query design box (we used Access, not sure what Filemaker etc. display is like).
</span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Arial,sans-serif">I’m thinking it’s a safer bet to describe a query than to remember the exact formula for something in the pressure of an exam. Just wondering what others thought of this and
how they are recommending students handle the big question. </span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Arial,sans-serif">Cheers</span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Arial,sans-serif">Damien</span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Arial,sans-serif"> </span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:Arial,sans-serif"> </span></p>
<p class="MsoNormal"><b><span style="font-size:9pt;font-family:'Times New Roman',serif;color:rgb(136,2,49)"><br>
</span></b><b><span style="font-size:12pt;font-family:Arial,sans-serif;color:rgb(130,0,44)">Damien</span></b><b><span style="font-size:9pt;font-family:'Times New Roman',serif;color:rgb(136,2,49)">
</span></b><b><span style="font-size:12pt;font-family:Arial,sans-serif;color:rgb(136,2,49)">Atkinson-Buck</span></b><span style="font-size:12pt;font-family:'Times New Roman',serif"><br>
</span><span style="font-size:10pt;font-family:Arial,sans-serif">Head of Learning Area: Technology/Arts</span><span style="font-size:8pt;font-family:'Times New Roman',serif">
</span></p>
<table border="0" cellpadding="0">
<tbody>
<tr>
<td style="padding:0.75pt 36pt 0.75pt 0.75pt">
<p class="MsoNormal"><b><span style="font-size:8pt;font-family:Arial,sans-serif">p:</span></b><span style="font-size:8pt;font-family:Arial,sans-serif"> <a href="tel:%2B61%203%209490%203848" value="+61394903848" target="_blank">+61 3 9490 3848</a></span><span style="font-size:8pt;font-family:Arial,sans-serif"></span></p>
</td>
<td style="padding:0.75pt 36pt 0.75pt 0.75pt">
<p class="MsoNormal"><b><span style="font-size:8pt;font-family:Arial,sans-serif">e:</span></b><span style="font-size:8pt;font-family:Arial,sans-serif">
<a href="mailto:damien.atkinson-buck@ivanhoe.com.au" target="_blank"><span style="color:blue">damien.atkinson-buck@ivanhoe.com.au</span></a></span><span style="font-size:8pt;font-family:Arial,sans-serif"></span></p>
</td>
</tr>
<tr>
<td style="padding:0.75pt">
<p class="MsoNormal"><b><span style="font-size:8pt;font-family:Arial,sans-serif">f:</span></b><span style="font-size:8pt;font-family:Arial,sans-serif"> <a href="tel:%2B61%203%209490%203490" value="+61394903490" target="_blank">+61 3 9490 3490</a></span><span style="font-size:8pt;font-family:Arial,sans-serif"></span></p>
</td>
<td style="padding:0.75pt">
<p class="MsoNormal"><b><span style="font-size:8pt;font-family:Arial,sans-serif">w:</span></b><span style="font-size:8pt;font-family:Arial,sans-serif">
</span><span style="font-size:8pt;font-family:Arial,sans-serif"><a href="http://www.ivanhoe.com.au" target="_blank"><span style>www.ivanhoe.com.au</span></a></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:12pt;font-family:'Times New Roman',serif"><img border="0" width="750" height="105" src="cid:image001.jpg@01CED4A0.94831EC0"></span><span style="font-size:12pt;font-family:'Times New Roman',serif"><br>
</span><span style="font-size:7.5pt;font-family:Arial,sans-serif">Please consider the environment before printing this e-mail.</span></p></div></div></blockquote></div><div><br></div><br><div dir="ltr">--<div>Mark Kelly</div>
<div>mark AT vceit DOT com</div><div><a href="http://vceit.com" target="_blank">http://vceit.com</a></div><div><br></div><div><span style="color:rgb(0,0,0);font-family:verdana,arial,helvetica,sans-serif;background-color:rgb(253,253,255)"><font size="1">Day 19, I have successfully conditioned my master to smile and write in his book every time I drool.- Pavlov's Dog</font></span><br>
</div><div><br></div></div>
</div></div></div></div>