<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)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@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:"Wingdings 2";
panose-1:5 2 1 2 1 5 7 7 7 7;}
@font-face
{font-family:"Century Gothic";
panose-1:2 11 5 2 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
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";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";
mso-fareast-language:EN-US;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";
mso-fareast-language:EN-US;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@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="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">Hi Ben,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">You can setup MySQL servers on non IOS devices very easily – WAMP or XAMP will do the job, they just install like a normal program and then run Apache, MySQL and PHP services for you. You can then teach the students
basic SQL. They pick it up much more easily than I expected when I experimented with it in class.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">You can run the whole thing off a usb if you want to.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">To shortcut having to teach them a great deal of PHP syntax to interact with the database use the freebie version of PHP Generator form the SQL Maestro group (<a href="http://www.sqlmaestro.com/products/mysql/phpgenerator/">http://www.sqlmaestro.com/products/mysql/phpgenerator/</a>),
it will do most things the Pro version will do as far as students need (I’ve been using to rapid develop applications for school – it’s quite easy and powerful)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">If you have an existing Access database you want to quickly upload to MySQL with foreign keys etc intact then you can use AccessMySQL convertor from Bullzip (freebie too)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">I believe there is now an app for IOS to manage MySQL but I don’t think you can do any setup. That said PHPMyAdmin is very easy to use and there is no end of support for it on the net.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">I think it’s a good idea to start students on something that is very real world and translates to technologies they will encounter down the track that integrate with a whole host of web technologies like JQuery
etc etc<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Later on if you have students come back to Access it’s trivial to get Access to talk to MySQL so it incorporates a remote table with two way data writing.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Be brave give it a go!<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:black;mso-fareast-language:EN-AU">Kind Regards,
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black;mso-fareast-language:EN-AU"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:black;mso-fareast-language:EN-AU">Brett Groves<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black;mso-fareast-language:EN-AU"><img border="0" width="51" height="42" id="_x0000_i1026" src="cid:image002.gif@01CFD29E.B5B0EAD0" alt="logosmall"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black;mso-fareast-language:EN-AU">Melba College<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black;mso-fareast-language:EN-AU">eLearning Leader<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black;mso-fareast-language:EN-AU">03 9725 8277 Ext 221<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black;mso-fareast-language:EN-AU">0415 910011<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black;mso-fareast-language:EN-AU"><a href="http://melba.vic.edu.au/curriculum/elearning/"><span style="color:blue">eLearning Resources for Educators</span></a> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black;mso-fareast-language:EN-AU"><a href="http://melba.vic.edu.au/curriculum/elearning/elearning-newsletter/"><span style="color:blue">Newsletter sign up</span></a> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black;mso-fareast-language:EN-AU"><a href="http://us7.campaign-archive1.com/home/?u=3552e93cf6fe9d34510f19694&id=1cc14525a0"><span style="color:blue">Past Issues</span></a> <o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:EN-AU">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:EN-AU"> itapps-bounces@edulists.com.au
[mailto:itapps-bounces@edulists.com.au] <b>On Behalf Of </b>Baas, Benjamin B<br>
<b>Sent:</b> Wednesday, 17 September 2014 9:53 AM<br>
<b>To:</b> itapps@edulists.com.au<br>
<b>Subject:</b> [Year 12 IT Apps] Database programs that are BYOD friendly.<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Hi All,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I’m sure this question has been asked before, but are there any teachers out their using database programs that are BYOD friendly or does anybody know of any BYOD friendly options.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Cheers,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Ben.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b><span style="font-size:14.0pt;color:#17365D;mso-fareast-language:EN-AU">Benjamin Baas<o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="font-size:8.0pt;color:#1F497D;mso-fareast-language:EN-AU"><img border="0" width="32" height="27" id="Picture_x0020_1" src="cid:image003.png@01CFD29E.B5B0EAD0" alt="Description: cid:image001.png@01C9CA67.50F474D0"></span><b><span style="font-size:10.0pt;color:#948A54;mso-fareast-language:ZH-CN"> </span></b><b><span style="font-size:12.0pt;color:#17365D;mso-fareast-language:ZH-CN">Alkira
Secondary College</span></b><b><span style="font-size:10.0pt;color:#17365D;mso-fareast-language:ZH-CN"><o:p></o:p></span></b></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:9.0pt;font-family:Wingdings;color:#17365D;mso-fareast-language:ZH-CN">+</span><span lang="EN-US" style="font-size:9.0pt;color:#17365D;mso-fareast-language:ZH-CN">
<b>Nurture Ave, Cranbourne North | PO Box 4314, Narre Warren South 3805</b></span><span style="font-size:9.0pt;color:#17365D;mso-fareast-language:ZH-CN"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:9.0pt;font-family:"Wingdings 2";color:#17365D;mso-fareast-language:ZH-CN">'</span><span lang="EN-US" style="font-size:9.0pt;font-family:"Century Gothic","sans-serif";color:#17365D;mso-fareast-language:ZH-CN">
</span><b><span lang="EN-US" style="font-size:9.0pt;color:#17365D;mso-fareast-language:ZH-CN"> +61 3 5991 3500
</span></b><span lang="EN-US" style="font-size:9.0pt;font-family:"Wingdings 2";color:#17365D;mso-fareast-language:ZH-CN">6
</span><b><span lang="EN-US" style="font-size:9.0pt;color:#17365D;mso-fareast-language:ZH-CN">+61 3 5991 3599
</span></b><span lang="EN-US" style="font-size:9.0pt;font-family:Wingdings;color:#1F497D;mso-fareast-language:ZH-CN">8<b>
</b></span><span style="color:black;mso-fareast-language:ZH-CN"><a href="http://www.alkirasecondarycollege.com.au/"><b><span lang="EN-US" style="font-size:9.0pt;color:#548DD4">www.alkirasecondarycollege.com.au</span></b></a></span><b><span lang="EN-US" style="font-size:9.0pt;color:#1F497D;mso-fareast-language:ZH-CN"><o:p></o:p></span></b></p>
<p class="MsoNormal"><i><span style="font-size:8.0pt;color:#404040;mso-fareast-language:ZH-CN">Alkira Secondary College believes in
</span></i><i><span style="font-size:8.0pt;color:red;mso-fareast-language:ZH-CN">Personalised</span></i><i><span style="font-size:8.0pt;color:#404040;mso-fareast-language:ZH-CN"> learning for all, and
</span></i><i><span style="font-size:8.0pt;color:red;mso-fareast-language:ZH-CN">Respect</span></i><i><span style="font-size:8.0pt;color:#404040;mso-fareast-language:ZH-CN"> for the individual<o:p></o:p></span></i></p>
<p class="MsoNormal"><o:p> </o: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.<o:p></o:p></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>
</body>
</html>