You wouldn't <b>lose</b> marks for adding formatting, forms, controls etc, but you wouldn't be getting marks for them. And spending too much time on these things may distract students from spending time on things that <b>do</b> get marks.<br>
<br>Some primitive form of input/output is necessary to get the data into the tables and get printouts of answers produced (I get kids to print output rather than assessing onscreen). It's just that I/O is not much important in U3O2. Anyway, it's not as if it takes hours of work or masses of skill to produce basic output ! <br>
<br>I wouldn't panic about <b>adding</b> features, just about leaving out necessary features.<br><br>Regards<br>Mark<br><br><div class="gmail_quote">On 26 May 2011 11:08, Mark KELLY <span dir="ltr"><<a href="mailto:kel@mckinnonsc.vic.edu.au">kel@mckinnonsc.vic.edu.au</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">Hi, OtherMark<br><br>Formatting is not important to this outcome, but it is assessable if RDBMS is used for U4O1...<br>
<br><p><b>If students use a relational database management system in Unit 4, the following additional functions apply:</b></p>
<ul><li><b>import/export of data</b></li><li><b>format data for display</b></li><li><b>create and edit a range of forms, including different data types and controls</b></li><li><b>create and edit a range of formatted reports.</b></li>
</ul><br><br><div class="gmail_quote"><div><div></div><div class="h5">On 26 May 2011 10:47, Mark Scott <span dir="ltr"><<a href="mailto:msc@luther.vic.edu.au" target="_blank">msc@luther.vic.edu.au</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div></div><div class="h5">
<div link="blue" vlink="purple" lang="EN-AU"><div><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"> </span></p><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">HELP!!!!!!!!</span></p><p class="MsoNormal">
<span style="font-size:11.0pt;color:#1F497D"> </span></p><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">From VCAA</span></p><p class="MsoNormal"><i><span style="font-size:11.0pt;color:#1F497D">Relational database management system <br>
The following functions apply to Unit 3:</span></i></p><p><span style="font-size:11.0pt;font-family:Symbol;color:#1F497D"><span>·<span style="font:7.0pt "Times New Roman""> </span></span></span><i><span style="font-size:11.0pt;color:#1F497D">create tables</span></i></p>
<p><span style="font-size:11.0pt;font-family:Symbol;color:#1F497D"><span>·<span style="font:7.0pt "Times New Roman""> </span></span></span><i><span style="font-size:11.0pt;color:#1F497D">create relationships between tables</span></i></p>
<p><span style="font-size:11.0pt;font-family:Symbol;color:#1F497D"><span>·<span style="font:7.0pt "Times New Roman""> </span></span></span><i><span style="font-size:11.0pt;color:#1F497D">use a range of data types</span></i></p>
<p><span style="font-size:11.0pt;font-family:Symbol;color:#1F497D"><span>·<span style="font:7.0pt "Times New Roman""> </span></span></span><i><span style="font-size:11.0pt;color:#1F497D">electronic validation</span></i></p>
<p><span style="font-size:11.0pt;font-family:Symbol;color:#1F497D"><span>·<span style="font:7.0pt "Times New Roman""> </span></span></span><i><span style="font-size:11.0pt;color:#1F497D">create, edit and use queries</span></i></p>
<p><span style="font-size:11.0pt;font-family:Symbol;color:#1F497D"><span>·<span style="font:7.0pt "Times New Roman""> </span></span></span><i><span style="font-size:11.0pt;color:#1F497D">use of calculated fields</span></i></p>
<p><span style="font-size:11.0pt;font-family:Symbol;color:#1F497D"><span>·<span style="font:7.0pt "Times New Roman""> </span></span></span><i><span style="font-size:11.0pt;color:#1F497D">sort records or index on different fields.</span></i></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"> </span></p><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">Can someone confirm that:</span></p><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"> </span></p>
<p><span style="font-size:11.0pt;font-family:Symbol;color:#1F497D"><span>·<span style="font:7.0pt "Times New Roman""> </span></span></span><span style="font-size:11.0pt;color:#1F497D">formatting (apart from sorting) is not a part of this SAC?<br>
<br></span></p><p><span style="font-size:11.0pt;font-family:Symbol;color:#1F497D"><span>·<span style="font:7.0pt "Times New Roman""> </span></span></span><span style="font-size:11.0pt;color:#1F497D">drop down lists are not appropriate for tables (only forms)</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"> </span></p><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">Mark Scott</span></p><p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">Luther College</span></p>
</div></div><br></div></div>_______________________________________________<br>
<a href="http://www.edulists.com.au" target="_blank">http://www.edulists.com.au</a> - FAQ, resources, subscribe, unsubscribe<br>
IT Applications Mailing List kindly supported by<br>
<a href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html" target="_blank">http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html</a> - Victorian Curriculum and Assessment Authority and<br>
<a href="http://www.vitta.org.au" target="_blank">http://www.vitta.org.au</a> - VITTA Victorian Information Technology Teachers Association Inc<br></blockquote></div><br><br clear="all"><br>-- <br>Mark Kelly<br>Manager of ICT, Reporting, IT Learning Area<br>
McKinnon Secondary College<br>McKinnon Rd McKinnon 3204, Victoria, Australia<br>Direct line / Voicemail: +613 8520 9085, Fax +613 9578 9253<br><a href="mailto:kel@mckinnonsc.vic.edu.au" target="_blank">kel@mckinnonsc.vic.edu.au</a><br>
VCE IT Lecture Notes: <a href="http://vceit.com" target="_blank">http://vceit.com</a><br>Moderator: IT Applications Edulist<br><br><font>Want a good time? Call 0112358. Ask for Mr </font>Fibonacci.<br>
</blockquote></div><br><br clear="all"><br>-- <br>Mark Kelly<br>Manager of ICT, Reporting, IT Learning Area<br>McKinnon Secondary College<br>McKinnon Rd McKinnon 3204, Victoria, Australia<br>Direct line / Voicemail: +613 8520 9085, Fax +613 9578 9253<br>
<a href="mailto:kel@mckinnonsc.vic.edu.au" target="_blank">kel@mckinnonsc.vic.edu.au</a><br>VCE IT Lecture Notes: <a href="http://vceit.com" target="_blank">http://vceit.com</a><br>Moderator: IT Applications Edulist<br><br>
<font>Want a good time? Call 0112358. Ask for Mr </font>Fibonacci.<br>