<div class="gmail_extra">I used Filemaker so it wasn't the same for me. <br>IMO, creating forms isn't too onerous, and it's a very basic and vital skill.<br><br><div class="gmail_quote">On 23 April 2012 10:18, Smallacombe, Kate B <span dir="ltr"><<a href="mailto:smallacombe.kate.b@edumail.vic.gov.au" target="_blank">smallacombe.kate.b@edumail.vic.gov.au</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div link="blue" vlink="purple" lang="EN-AU">
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Hi all,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">I’ve read the list below of what’s required for U3O2. Just wondering, do you teach forms as part of this outcome or can students just enter the data directly
into the tables?<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d" lang="EN-US">Cheers,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d" lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d" lang="EN-US">Kate Smallacombe<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d" lang="EN-US">Brighton Secondary College<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d" lang="EN-US">120 Marriage Road<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d" lang="EN-US">Brighton East 3187<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"" lang="EN-US">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"" lang="EN-US"> <a href="mailto:itapps-bounces@edulists.com.au" target="_blank">itapps-bounces@edulists.com.au</a> [mailto:<a href="mailto:itapps-bounces@edulists.com.au" target="_blank">itapps-bounces@edulists.com.au</a>]
<b>On Behalf Of </b>Mark KELLY<br>
<b>Sent:</b> Thursday, 19 April 2012 11:00 AM</span></p><div class="im"><br>
<b>To:</b> Year 12 IT Applications Teachers' Mailing List<br>
<b>Subject:</b> Re: [Year 12 IT Apps] U3O2 - Relational Databased + Access<u></u><u></u></div><p></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">You could look at Greg Bowden's Guided computer tutorials. (<a href="http://gct.com.au" target="_blank">gct.com.au</a>)</p><div><div class="h5"><br>
<br>
As for level of difficulty, here are VCAA's mandated skills...<u></u><u></u></div></div><p></p><div><div class="h5">
<p>The following functions apply to ITA Unit 3:<u></u><u></u></p>
<ul type="disc">
<li class="MsoNormal">
create tables<u></u><u></u></li><li class="MsoNormal">
create relationships between tables<u></u><u></u></li><li class="MsoNormal">
use a range of data types<u></u><u></u></li><li class="MsoNormal">
electronic validation<u></u><u></u></li><li class="MsoNormal">
create, edit and use queries<u></u><u></u></li><li class="MsoNormal">
use of calculated fields<u></u><u></u></li><li class="MsoNormal">
sort records or index on different fields.<u></u><u></u></li></ul>
<p>If students use a relational database management system in Unit 4 ITA, the following additional functions apply:<u></u><u></u></p>
<ul type="disc">
<li class="MsoNormal">
import/export of data<u></u><u></u></li><li class="MsoNormal">
format data for display<u></u><u></u></li><li class="MsoNormal">
create and edit a range of forms, including different data types and controls<u></u><u></u></li><li class="MsoNormal">
create and edit a range of formatted reports.<u></u><u></u></li></ul>
<p class="MsoNormal" style="margin-bottom:12.0pt"><u></u> <u></u></p>
<div>
<p class="MsoNormal">On 19 April 2012 09:07, POLLOCK, Benn(POL) <<a href="mailto:POL@wantirnacollege.vic.edu.au" target="_blank">POL@wantirnacollege.vic.edu.au</a>> wrote:<u></u><u></u></p>
<div>
<div>
<p class="MsoNormal">Currently, my students are completing some in-class tutorials on creating relational databases for their SAC. We have 2010 Access at our school however I can’t seem to find many
good tutorials to help teach them. I’m also new to access so trying to wrap my head around everything at the same time has been a little daunting. I’m also not sure about the complexity of the required relational database that the students are required to
complete. Can someone give me an insight into the complexity that they’re expecting from their students? – Also If anyone has any links to resources or wants to share some of their class tutorials with me – I would be very grateful.
<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">Cheers<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:"Tw Cen MT Condensed","sans-serif";color:#c4163f">Benn Pollock</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:"Tw Cen MT Condensed","sans-serif";color:#e36c0a">Information Technology Teacher</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:"Tw Cen MT Condensed","sans-serif";color:#2a13b5">Wantirna College</span><u></u><u></u></p>
<p class="MsoNormal"><u><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:red">Ph:</span></u><span style="font-size:8.0pt;font-family:"Arial","sans-serif""> 9801 9700</span><u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"><br>
_______________________________________________<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 <br><br>
<a href="http://www.vitta.org.au" target="_blank">http://www.vitta.org.au</a> - VITTA Victorian Information Technology Teachers Association Inc <br><br>
<a href="http://www.swinburne.edu.au/ict/schools" target="_blank">http://www.swinburne.edu.au/ict/schools</a> - Swinburne University<u></u><u></u></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><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: <a href="tel:%2B613%208520%209085" value="+61385209085" target="_blank">+613 8520 9085</a>, Fax <a href="tel:%2B613%209578%209253" value="+61395789253" target="_blank">+613 9578 9253</a><br>
<a href="mailto:kel@mckinnonsc.vic.edu.au" target="_blank">kel@mckinnonsc.vic.edu.au</a> (don't use my Edumail account!)<br>
VCE IT Lecture Notes: <a href="http://vceit.com" target="_blank">http://vceit.com</a><br>
Moderator: IT Applications Edulist<br>
<br>
--<br>
An E-flat, a C, and a G go into a bar. The bartender says, "I'm sorry, but I can't serve minors."<br>
<br>
<u></u><u></u></p>
</div></div></div><div class="im">
<p></p><p><b>Important - </b>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.</p>
</div></div>
<br>_______________________________________________<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 <br><br>
<a href="http://www.vitta.org.au" target="_blank">http://www.vitta.org.au</a> - VITTA Victorian Information Technology Teachers Association Inc <br><br>
<a href="http://www.swinburne.edu.au/ict/schools" target="_blank">http://www.swinburne.edu.au/ict/schools</a> - Swinburne University<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> (don't use my Edumail account!)<br>
VCE IT Lecture Notes: <a href="http://vceit.com" target="_blank">http://vceit.com</a><br>Moderator: IT Applications Edulist<br><br>--<br>An E-flat, a C, and a G go into a bar. The bartender says, "I'm sorry, but I can't serve minors."<br>
<br><br>
</div>