<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style>@font-face {
font-family: Wingdings;
}
@font-face {
font-family: Wingdings;
}
@font-face {
font-family: Calibri;
}
@font-face {
font-family: Tahoma;
}
@font-face {
font-family: Tw Cen MT Condensed;
}
@page WordSection1 {margin: 72.0pt 72.0pt 72.0pt 72.0pt; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.EmailStyle18 {
COLOR: #1f497d; FONT-FAMILY: "Calibri","sans-serif"
}
.MsoChpDefault {
FONT-FAMILY: "Calibri","sans-serif"
}
OL {
MARGIN-BOTTOM: 0cm
}
UL {
MARGIN-BOTTOM: 0cm
}
</style><style id="owaParaStyle">P {
MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px
}
</style>
</head>
<body lang="EN-AU" vlink="purple" link="blue" fPStyle="1" ocsi="0">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">
<p>You don't need to create forms or reports for this outcome, but obviously you can if you want. You have to cover reports if you do databases again in Unit 4.</p>
<p> </p>
<p>Gordon Cameron</p>
<div style="FONT-SIZE: 16px; COLOR: #000000; FONT-FAMILY: Times New Roman">
<hr tabindex="-1">
<div id="divRpF122117" style="DIRECTION: ltr"><font face="Tahoma" color="#000000" size="2"><b>From:</b> itapps-bounces@edulists.com.au [itapps-bounces@edulists.com.au] on behalf of Smallacombe, Kate B [smallacombe.kate.b@edumail.vic.gov.au]<br>
<b>Sent:</b> Monday, 23 April 2012 10:18 AM<br>
<b>To:</b> Year 12 IT Applications Teachers' Mailing List<br>
<b>Subject:</b> Re: [Year 12 IT Apps] U3O2 - Relational Databased + Access<br>
</font><br>
</div>
<div></div>
<div>
<div class="WordSection1">
<p class="MsoNormal"><span style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">Hi all,</span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"></span> </p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">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?</span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"></span> </p>
<p class="MsoNormal"><span lang="EN-US" style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">Cheers,</span></p>
<p class="MsoNormal"><span lang="EN-US" style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"></span> </p>
<p class="MsoNormal"><span lang="EN-US" style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">Kate Smallacombe</span></p>
<p class="MsoNormal"><span lang="EN-US" style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">Brighton Secondary College</span></p>
<p class="MsoNormal"><span lang="EN-US" style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">120 Marriage Road</span></p>
<p class="MsoNormal"><span lang="EN-US" style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">Brighton East 3187</span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"></span> </p>
<p class="MsoNormal"><b><span lang="EN-US" style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">From:</span></b><span lang="EN-US" style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"> itapps-bounces@edulists.com.au [mailto:itapps-bounces@edulists.com.au]
<b>On Behalf Of </b>Mark KELLY<br>
<b>Sent:</b> Thursday, 19 April 2012 11:00 AM<br>
<b>To:</b> Year 12 IT Applications Teachers' Mailing List<br>
<b>Subject:</b> Re: [Year 12 IT Apps] U3O2 - Relational Databased + Access</span></p>
<p class="MsoNormal"> </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>)<br>
<br>
As for level of difficulty, here are VCAA's mandated skills...</p>
<p>The following functions apply to ITA Unit 3:</p>
<ul type="disc">
<li class="MsoNormal">create tables </li><li class="MsoNormal">create relationships between tables </li><li class="MsoNormal">use a range of data types </li><li class="MsoNormal">electronic validation </li><li class="MsoNormal">create, edit and use queries </li><li class="MsoNormal">use of calculated fields </li><li class="MsoNormal">sort records or index on different fields.</li></ul>
<p>If students use a relational database management system in Unit 4 ITA, the following additional functions apply:</p>
<ul type="disc">
<li class="MsoNormal">import/export of data </li><li class="MsoNormal">format data for display </li><li class="MsoNormal">create and edit a range of forms, including different data types and controls
</li><li class="MsoNormal">create and edit a range of formatted reports.</li></ul>
<p class="MsoNormal" style="MARGIN-BOTTOM: 12pt"> </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:</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.
</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Cheers</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><span style="FONT-SIZE: 14pt; COLOR: #c4163f; FONT-FAMILY: 'Tw Cen MT Condensed','sans-serif'">Benn Pollock</span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 14pt; COLOR: #e36c0a; FONT-FAMILY: 'Tw Cen MT Condensed','sans-serif'">Information Technology Teacher</span></p>
<p class="MsoNormal"><span style="FONT-SIZE: 14pt; COLOR: #2a13b5; FONT-FAMILY: 'Tw Cen MT Condensed','sans-serif'">Wantirna College</span></p>
<p class="MsoNormal"><u><span style="FONT-SIZE: 8pt; COLOR: red; FONT-FAMILY: 'Arial','sans-serif'">Ph:</span></u><span style="FONT-SIZE: 8pt; FONT-FAMILY: 'Arial','sans-serif'"> 9801 9700</span></p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> </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</p>
</div>
<p class="MsoNormal" style="MARGIN-BOTTOM: 12pt"><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>
</p>
</div>
<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>
</div>
<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>
</body>
</html>