<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, sans-serif; ">
<div>Thanks Jarrod. Regarding screencasts, the videos accompanying this article are as good as it gets. I showed the videos to the class so that we could focus on the very well explained process – and of course stop whenever I wanted to add or reinforce associated
concepts. The best thing about the article/videos is that they cover a variety of processes and concepts and demonstrate the relationships between them very clearly.</div>
<div><br>
</div>
<div>BTW Joyce Tabone's recent post with her 2011 SAC is a perfect follow up SAC for this year in 302 if you take the students through this. Her data set is perfect for what is in most circumstances a difficult SAC - given that most of my students have no prior
knowledge of Access or database concepts to begin with.</div>
<div>I am going to use it with a few modifications, thanks Joyce. </div>
<div><br>
</div>
<div>Cheers</div>
<div>George</div>
<div><br>
</div>
<div>
<div>
<div>
<div><!--StartFragment--><font face="Calibri,Verdana,Helvetica,Arial"><span style="font-size:11pt">The University High School<br>
77 Story Street, Parkville, Vic, 3052, Australia<br>
Ph: (03) 9347 2022<br>
mobile: 0412934782</span></font><!--EndFragment--></div>
<div><br>
</div>
</div>
</div>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<span id="OLK_SRC_BODY_SECTION">
<div style="font-family:Calibri; font-size:11pt; text-align:left; color:black; BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<span style="font-weight:bold">From: </span>"Robinson, Jarrod J" <<a href="mailto:robinson.jarrod.j@edumail.vic.gov.au">robinson.jarrod.j@edumail.vic.gov.au</a>><br>
<span style="font-weight:bold">Reply-To: </span>Year 12 IT Applications Teachers' Mailing List <<a href="mailto:itapps@edulists.com.au">itapps@edulists.com.au</a>><br>
<span style="font-weight:bold">Date: </span>Thu, 3 May 2012 13:01:33 +0000<br>
<span style="font-weight:bold">To: </span>Year 12 IT Applications Teachers' Mailing List <<a href="mailto:itapps@edulists.com.au">itapps@edulists.com.au</a>><br>
<span style="font-weight:bold">Subject: </span>Re: [Year 12 IT Apps] Excellent Normalisation example<br>
</div>
<div><br>
</div>
<div>
<div bgcolor="#FFFFFF">
<div>Brilliant stuff. Thanks for sharing </div>
<div><br>
</div>
<div>I would also love to see some screencasts made by some of the experienced teachers moving through normalisation </div>
<div><br>
</div>
<div>Could record the process with <a href="http://www.screencast-o-matic.com">www.screencast-o-matic.com</a> <br>
<br>
Sent from my iPhone</div>
<div><br>
On 03/05/2012, at 9:18 PM, "Ciotti, George W" <<a href="mailto:ciotti.george.w@edumail.vic.gov.au">ciotti.george.w@edumail.vic.gov.au</a>> wrote:<br>
<br>
</div>
<div></div>
<blockquote type="cite">
<div><style id="owaParaStyle">P {
MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px
}
</style>
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">
<p>Hi,</p>
<p> </p>
<p>after spending some time looking for a simple and relative Normalisation example for my ITA class I found this one. It's very good and it starts off in Excel and then ports the finished tables into Access in a way I never knew you could. It's a great starting
point and my kids are actually beginning to understand how it all fits together.</p>
<p> </p>
<p><a href="http://office.microsoft.com/en-us/excel-help/move-data-from-excel-to-access-HA010342703.aspx?CTT=1#_Toc297903648">http://office.microsoft.com/en-us/excel-help/move-data-from-excel-to-access-HA010342703.aspx?CTT=1#_Toc297903648</a></p>
<p> </p>
<p>I have attached the excel spreadsheet (Microsoft Example_norm_to_Access.xlsx) that I copied from the site plus the developed excel and associated access files - (MS_Access_ex1.zip).</p>
<p> </p>
<p>Firstly, I got the students to follow the procedure outlined in the article, and you really only need to view the 4 associated videos, and once they finish this I will get them to do it again using another 0NF spreadsheet. The one I am using is from the
VITTA PD at the start of the year.(Normalisation_Nat.zip).</p>
<p> </p>
<p>The process provides a great foundation for discussion regarding primary and foreign keys as well as whether and how to set up a database using imported IDs or setting up autonumbered IDs.</p>
<p> </p>
<p>Hope this is useful.</p>
<p> </p>
<p>cheers</p>
<p>George</p>
<p> </p>
<p>Uuniversity High School</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>
</blockquote>
<blockquote type="cite">
<div><Microsoft Example_norm_to_Access.xlsx></div>
</blockquote>
<blockquote type="cite">
<div><MS_Access_ex1.zip></div>
</blockquote>
<blockquote type="cite">
<div><Normalisation_Nat.zip></div>
</blockquote>
<blockquote type="cite">
<div><span>_______________________________________________</span><br>
<span><a href="http://www.edulists.com.au">http://www.edulists.com.au</a> - FAQ, resources, subscribe, unsubscribe</span><br>
<span>IT Applications Mailing List kindly supported by</span><br>
<span><a href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html">http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html</a> - Victorian Curriculum and Assessment Authority <br></span><br>
<span><a href="http://www.vitta.org.au">http://www.vitta.org.au</a> - VITTA Victorian Information Technology Teachers Association Inc <br></span><br>
<span><a href="http://www.swinburne.edu.au/ict/schools">http://www.swinburne.edu.au/ict/schools</a> - Swinburne University</span></div>
</blockquote>
<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>
_______________________________________________ <a href="http://www.edulists.com.au">
http://www.edulists.com.au</a> - FAQ, resources, subscribe, unsubscribe IT Applications Mailing List kindly supported by
<a href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html">
http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html</a> - Victorian Curriculum and Assessment Authority
<br>
<a href="http://www.vitta.org.au">http://www.vitta.org.au</a> - VITTA Victorian Information Technology Teachers Association Inc
<br>
<a href="http://www.swinburne.edu.au/ict/schools">http://www.swinburne.edu.au/ict/schools</a> - Swinburne University</span>
<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>