<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:"Consolas","serif";
mso-fareast-language:EN-AU;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-AU link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Hi Mark,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> Perhaps we need to shift this to the SD list, hence the redirection.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>There was a genuine issue with some languages having IDEs that allowed a wizard driven connection to database storage. Hence the ban on use of databases. <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> My position as a teacher of SD, and no more than that, is one where a solution built to operate on a network ( prototype or full implementation ) implies multi user, implies a large number of people.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>The SD course has brought in a larger and deeper look at networks, security, multi users and multiple access devices ( mobile, desktop, wireless etc ).<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>I will leave it up to the advocates of “files are best in that environment” to make their case. In fact, I have nothing against anyone who wishes to use files. I do have a problem with the fact my students are prevented from using database technologies in Yr 12. Specifically MySQL with PHP. They can use Python and MySQL as well for what it is worth. <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> I speak from the perspective of having built school wide solutions in the very context that the Study Design describes ( 1500 users, remote and local access, security, mobile devices, multiple OSs, etc ). Examples include Parent Teacher interviews bookings online, submission and monitoring and allocating Extras for teachers absent and away from school, Resource booking systems and monitoring and logging of web traffic through the school internet connections. <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Each of these have been built with PHP and MySQL and not files for storage. The web interface has meant one solution works for all devices rather than multiple apps ( xcode for ipad and iphone, java for android etc before we discuss MAC vs Windows laptops, desktops. Some of these solutions have been purchased by other schools.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>My students have seen these solutions built, developed and deployed before their eyes. The solutions have not been focussed on the database. The programming has neither been trivial nor wizard driven. In fact in Yr 11 the students have built, simpler versions of these. They use Dreamweaver for the html and CSS. The PHP is written in Notepad++ and MySQL statements are inserted to interact with the database. They really enjoy it. Incidentally we have also explored privacy and related issues with these solutions. <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><br>They have asked why they can’t do this in Yr 12 and have to use files. This experiential learning is not available to them in their own demonstration of learning and assessment. <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>In fact, I also teach the Diploma in IT Networking ICA50411. One of the units is titled </span><span style='font-size:11.5pt;font-family:"Arial","sans-serif";color:black'>ICAWEB502A Create dynamic web pages . </span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>This requires use of server side and client side programming. Quite similar to what the Yr 11 students achieved with some extensions. This is neither trivial, nor wizard driven. <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>I will not be losing sleep over this issue. But, the driver for it was to improve the poor student scores in the written exam on the algorithm questions. I believe these have not improved this year despite the banning of databases. I am happy for teachers of other databases to make their own case since I am not supporting wizard driven database interaction, but where is the rationale for banning my use of MySQL as a database in SD now ?<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Speak soon<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Kevork Krozian<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>SD teacher<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Ringwood SC<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;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> Saturday, 23 June 2012 2:44 PM<br><b>To:</b> Year 12 IT Applications Teachers' Mailing List<br><b>Subject:</b> Re: [Year 12 IT Apps] RDBMS systems<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'>P'raps not so much irony as much as concentrating each study on its core business. <br><br>ITA is about databases, so MySQL is valid. <br><br>SD is about programming, but apparently too many people were turning it into a database programming exercise and losing track of programming fundamentals.<br><br>I can see VCAA's point in explicitly banning database extensions in SD: it certainly seemed to be distracting people towards the end of the previous study design.<br><br><o:p></o:p></p><div><p class=MsoNormal>On 22 June 2012 22:28, Brett Groves <<a href="mailto:groves.brett.g@edumail.vic.gov.au" target="_blank">groves.brett.g@edumail.vic.gov.au</a>> wrote:<o:p></o:p></p><div><p class=MsoNormal>A delicious irony that we can teach MySQL in Applications but not in Software Development, sighs, reaches for red wine.....<br><br><o:p></o:p></p><pre>Regards,<o:p></o:p></pre><pre>Brett Groves<o:p></o:p></pre><pre>ICT Manager<o:p></o:p></pre><pre>Croydon Maroondah College - Croydon Campus<o:p></o:p></pre><p class=MsoNormal><br>On 15/06/12 13:29, Roland Gesthuizen wrote: <o:p></o:p></p><p class=MsoNormal>I have been a bit quiet this year (only teaching year 11 IT) <o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Was hugely surprised at the ISTE conferences in the USA how large FMP is overseas, especially in the education sector. I think the past dominance of MS Access is perhaps a local thing.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Crikey, wasn't always been like that. I still remember teaching DBase III and in some ways, it seemed to be a more explicit towards teaching databases and computational thinking. I rediscovered this when I revisited the PHP SQL programming in Kevorks splendid book.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Regards Roland<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>On 12/06/2012, at 12:01 PM, Laurie Savage wrote:<o:p></o:p></p></div><p class=MsoNormal><br><br><o:p></o:p></p><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Outside of the Arts/Design world do you know of any major users or large scale deployments of FMP?</span><o:p></o:p></p></div><p class=MsoNormal><o:p> </o:p></p></div><p class=MsoNormal><o:p> </o:p></p></div><pre><o:p> </o:p></pre><pre>_______________________________________________<o:p></o:p></pre><pre><a href="http://www.edulists.com.au" target="_blank">http://www.edulists.com.au</a> - FAQ, resources, subscribe, unsubscribe<o:p></o:p></pre><pre>IT Applications Mailing List kindly supported by<o:p></o:p></pre><pre><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><o:p></o:p></pre><pre><a href="http://www.vitta.org.au" target="_blank">http://www.vitta.org.au</a> - VITTA Victorian Information Technology Teachers Association Inc <br><o:p></o:p></pre><pre><a href="http://www.swinburne.edu.au/ict/schools" target="_blank">http://www.swinburne.edu.au/ict/schools</a> - Swinburne University<o:p></o:p></pre><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.<o:p></o:p></p></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<o:p></o:p></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: +613 8520 9085, Fax +613 9578 9253<br><a href="mailto:kel@mckinnonsc.vic.edu.au" target="_blank">kel@mckinnonsc.vic.edu.au</a> << use this, not Edumail please!<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><o:p></o:p></p></div></body></html>