<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>
<div>
<div>Well articulated Kevork. I agree whole heartedly. We are one of the few year 12 subjects that can use authentic learning without hampering timeframes / skimping on content that is directly related to industry.</div>
<div><br>
</div>
<div>If our students are looking at programming as a career, building interfaces that utilise MySQL or Microsoft SQL servers are pretty much a given when developing data driven systems. We wouldn't need to look at the normalisation of databases / SQL scripts
but could provide a base for students to link into and then manipulate as necessary.</div>
<div><br>
</div>
<div>I would fully support bringing back the use of databases, simply as a direct link to authentic learning!</div>
<div>
<div>
<p class="MsoNormal" style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; ">
<br>
</p>
<p class="MsoNormal" style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; ">
Kind regards,</p>
<p class="MsoNormal" style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; ">
<br>
Dave</p>
<p class="MsoNormal" style="margin-top: 0in; margin-right: 0in; margin-bottom: 0.0001pt; margin-left: 0in; font-size: 11pt; font-family: Calibri, sans-serif; ">
<span style="color: rgb(31, 73, 125); "><img id="Picture_x0020_1" src="cid:3F544A6C-5B81-4C32-90C8-4ABB750C792B" alt="Description: signature" height="200" width="400" type="image/png"></span></p>
</div>
</div>
</div>
</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>Kevork Krozian <<a href="mailto:kevork@edulists.com.au">kevork@edulists.com.au</a>><br>
<span style="font-weight:bold">Reply-To: </span>Year 12 Software Development Teachers' Mailing List <<a href="mailto:sofdev@edulists.com.au">sofdev@edulists.com.au</a>><br>
<span style="font-weight:bold">Date: </span>Saturday, 23 June 2012 8:53 PM<br>
<span style="font-weight:bold">To: </span>Year 12 Software Development Teachers' Mailing List <<a href="mailto:sofdev@edulists.com.au">sofdev@edulists.com.au</a>><br>
<span style="font-weight:bold">Subject: </span>Re: [Year 12 SofDev] Databases in SD<br>
</div>
<div><br>
</div>
<div 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">
<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]-->
<div lang="EN-AU" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125); font-family: Calibri, sans-serif; ">Hi Mark,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125); font-family: Calibri, sans-serif; "><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125); font-family: Calibri, sans-serif; ">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: 11pt; color: rgb(31, 73, 125); font-family: Calibri, sans-serif; "><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125); font-family: Calibri, sans-serif; ">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: 11pt; color: rgb(31, 73, 125); font-family: Calibri, sans-serif; "><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125); font-family: Calibri, sans-serif; ">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: 11pt; color: rgb(31, 73, 125); font-family: Calibri, sans-serif; ">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: 11pt; color: rgb(31, 73, 125); font-family: Calibri, sans-serif; "><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125); font-family: Calibri, sans-serif; ">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: 11pt; color: rgb(31, 73, 125); font-family: Calibri, sans-serif; "><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125); font-family: Calibri, sans-serif; ">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: 11pt; color: rgb(31, 73, 125); font-family: Calibri, sans-serif; ">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: 11pt; color: rgb(31, 73, 125); font-family: Calibri, sans-serif; "><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125); font-family: Calibri, sans-serif; ">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: 11pt; color: rgb(31, 73, 125); font-family: Calibri, sans-serif; "><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: 11pt; color: rgb(31, 73, 125); font-family: Calibri, sans-serif; "><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125); font-family: Calibri, sans-serif; ">In fact, I also teach the Diploma in IT Networking ICA50411. One of the units is titled
</span><span style="font-size: 11.5pt; color: black; font-family: Arial, sans-serif; ">ICAWEB502A Create dynamic web pages .
</span><span style="font-size: 11pt; color: rgb(31, 73, 125); font-family: Calibri, sans-serif; ">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: 11pt; color: rgb(31, 73, 125); font-family: Calibri, sans-serif; "><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125); font-family: Calibri, sans-serif; ">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: 11pt; color: rgb(31, 73, 125); font-family: Calibri, sans-serif; "><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125); font-family: Calibri, sans-serif; "><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125); font-family: Calibri, sans-serif; ">Speak soon<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125); font-family: Calibri, sans-serif; "><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125); font-family: Calibri, sans-serif; "><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125); font-family: Calibri, sans-serif; ">Kevork Krozian<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125); font-family: Calibri, sans-serif; ">SD teacher<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125); font-family: Calibri, sans-serif; ">Ringwood SC<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125); font-family: Calibri, sans-serif; "><o:p> </o:p></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; ">
<a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a> [<a href="mailto:itapps-bounces@edulists.com.au">mailto:itapps-bounces@edulists.com.au</a>]
<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: 11pt; color: rgb(31, 73, 125); font-family: Calibri, sans-serif; ">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>
</div>
</div>
</span>
</body>
</html>