[Informatics] MySQL
Laurie Savage
08327998 at pvgc.vic.edu.au
Thu Dec 3 06:32:36 AEDT 2015
Thanks for these resources Andrew. They will find a few good homes.
Laurie Savage
IT Teacher/Assessment and Reporting Coordinator
Pascoe Vale Girls College
> On 2 Dec 2015, at 9:58 PM, Andrew Pate <arp at mentonegrammar.net> wrote:
>
> Hi all,
> I taught my Year 11 class MySQL this year.
> Here is some notes I used. Feel free to use, adapt or delete.
>
> · U2 AofS 3 Data Management.zip contains PPTs that I used to introduce concepts and practice SQL queries.
> · movies.sql is a mySQL dump of sample data that I used. Questions are in the PPTs that I ran my classes from. Students create a MySQL database then copy and paste the dump into an SQL window in phpMyAdmin
> · movies.zip contains a series of pages using a custom CRUD class (Create, read, update, delete) in PHP. It contains basic styling and functionality. Some steps and some completed pages – this was the teaching tool.
> · Doc is my Assessment task. Students were also given the csv file to upload the data (with assistance) once they created the structure themselves.
> · Mygolf.zip contains some php/css and image files, as well as the crud.php class file. Students needed to expand this file and create the rest of the site. They could copy code from their other work – and of course we had already completed U2O1 using PHP, so they were familiar with this. This task was much more focused on writing queries and displaying results sets.
>
> Enjoy.
>
> Andrew.
>
> Andrew Pate
> Deighton House Coordinator
>
> Mentone Grammar
> 63 Venice Street, Mentone
> Victoria, Australia 3194
> T +61 3 9584 4211 F +61 3 9581 3290
> M +61 3 0416 228 436
> Direct +61 3 9581 3274
> arp at mentonegrammar.net <mailto:arp at mentonegrammar.net>
> www.mentonegrammar.net <http://www.mentonegrammar.net/>
>
>
>
> <>
> From: informatics-bounces at edulists.com.au <mailto:informatics-bounces at edulists.com.au> [mailto:informatics-bounces at edulists.com.au <mailto:informatics-bounces at edulists.com.au>] On Behalf Of Roland Gesthuizen
> Sent: Wednesday, 2 December 2015 8:42 PM
> To: Year 12 VCE Informatics Teachers' Mailing List
> Cc: Mark Richardson
> Subject: Re: [Informatics] OT- Macbooks vs PCs
>
> Hmm, if there is interest we could organise some SQL and WAMP workshops with DLTV early February,
> perhaps using the popular webinar format that Mark Richardson ran this year for the Digitech workshops.
> I don’t mind helping run this unless anybody else wants to give it a go? Kevork?
>
> Regards Roland
>
> On 2 Dec 2015, at 2:28 PM, Baas, Benjamin B <baas.benjamin.b at edumail.vic.gov.au <mailto:baas.benjamin.b at edumail.vic.gov.au>> wrote:
>
> I have some tutorials for WAMP that I created. There not good, but if people are interested I can send them out.
>
> Cheers,
>
> Ben.
> -Alkira Secondary College
>
> From: informatics-bounces at edulists.com.au <mailto:informatics-bounces at edulists.com.au> [mailto:informatics-bounces at edulists.com.au <mailto:informatics-bounces at edulists.com.au>] On Behalf Of Garth, Lucas A
> Sent: Wednesday, 2 December 2015 2:12 PM
> To: Year 12 VCE Informatics Teachers' Mailing List <informatics at edulists.com.au <mailto:informatics at edulists.com.au>>
> Cc: Margaret Lawson <lawson_m at materchristi.edu.au <mailto:lawson_m at materchristi.edu.au>>; Gary Bass <garybass at me.com <mailto:garybass at me.com>>
> Subject: Re: [Informatics] OT- Macbooks vs PCs
>
> Hello
>
> Great to hear the feedback on the Khan Academy SQL course. My students did the JavaScript one as part of U2O2 last year and though it was using ProcessingJS it still gave a nice introduction to programming visually and the step-by-step approach really helped the students.
>
> It does help if you’ve done the course before, as for students who are struggling, you can provide really quick structures to assist them to move forward to the next level.
>
> SQL is the way forward – it’s where industry was (more than) a decade ago and it’s a transferrable skill that’s not platform dependent.
>
> As James has rightly mentioned WAMP (for Windows) or MAMP/XAMP - basically all of these easy webserver setups work with MySQL. I’m trying to write out good materials that work with a MySQL database for U3O1 and may even use this for U2O3 if it is simple enough.
>
> Teaching RDBMS tools once students already have a knowledge of SQL is so much easier.
>
> Lucas Garth
> Lalor SC
>
>
>
> From: informatics-bounces at edulists.com.au <mailto:informatics-bounces at edulists.com.au> [mailto:informatics-bounces at edulists.com.au <mailto:informatics-bounces at edulists.com.au>] On Behalf Of Roland Gesthuizen
> Sent: Wednesday, 2 December 2015 1:45 PM
> To: Year 12 VCE Informatics Teachers' Mailing List
> Cc: Margaret Lawson; Gary Bass
> Subject: Re: [Informatics] OT- Macbooks vs PCs
>
> Yes, its the way to go forward with this. Last week I had a good talk about this with Garry Bass last week who helped me to understand why this was so and the learning errors that come with teaching databases with just MS Access. Margaret Lawson also did some homework to point out that the time was ripe to start using SQL. Glad I took the plunge.
>
> Just asked my 2016 year 12 students and they give it a big thumbs up. There you go!
>
> Regards Roland
>
> PS: Crikey, my last VCE Class at Keysborough College and they are lining up to shake my hand. Go outside and kick a ball ..
>
> On 2 Dec 2015, at 1:37 PM, Baas, Benjamin B <baas.benjamin.b at edumail.vic.gov.au <mailto:baas.benjamin.b at edumail.vic.gov.au>> wrote:
>
> I ran SQL with some of my students this year, I gave them a choice between SQL and Access. The students that did SQL better on the SAC than the Access students.
>
> Cheers,
>
> Ben.
>
> From: informatics-bounces at edulists.com.au <mailto:informatics-bounces at edulists.com.au> [mailto:informatics-bounces at edulists.com.au <mailto:informatics-bounces at edulists.com.au>] On Behalf Of Roland Gesthuizen
> Sent: Wednesday, 2 December 2015 1:21 PM
> To: Year 12 VCE Informatics Teachers' Mailing List <informatics at edulists.com.au <mailto:informatics at edulists.com.au>>
> Subject: Re: [Informatics] OT- Macbooks vs PCs
>
> I am going to make do with SQL and wean myself off MS Access next year.
>
> During our year 12 headstart course (a keysborough transition course for year 11 students) I was quite impressed by how the kids took to it using the Khan Academy tutorials, crikey they learned it fast and better than my chugalug approach to teaching MS Access. OpenOffice Base is better now too but I reckon that SQL Lite could work just fine for what we need to do for 2016. I’ll keep you posted how I go.
>
> https://www.khanacademy.org/computing/computer-programming/sql <https://www.khanacademy.org/computing/computer-programming/sql>
>
> https://www.evernote.com/l/AB-2p_5qfdZJo6H1Y5vgkws-9W1PmU-TNkA <https://www.evernote.com/l/AB-2p_5qfdZJo6H1Y5vgkws-9W1PmU-TNkA>
>
> Regards Roland
>
> On 2 Dec 2015, at 12:42 PM, Poke, Michael C <poke.michael.c at edumail.vic.gov.au <mailto:poke.michael.c at edumail.vic.gov.au>> wrote:
>
> Hi Sylvia,
> Here at Manor Lake College we use Apple computers and devices across the college. It’s awesome as far as what students can do present their work in innovative ways. As far as from an Informatics perspective, the lack of a decent (free) database management system like MS Access has been a real issue. We survived using Libre Office Base but as an open source platform, it was prone to crashing at times and doing things a bit funny. Now we’ve managed to get our IT guys to set up remote access to MS Access for Windows via the College server. It works like a virtual machine but only gives them direct access to Access… but only at school on our iMacs in our computer labs. It was tricky for the IT guys to set up, but now it’s all set up, it works well. We’ll see how it goes in 2016.
>
> Hope this is useful to you.
>
> Cheers,
> Michael
>
>
> Michael Poke
> Senior Years ICT Teacher
> Senior Years Digital Learning Leader (2016)
> Manor Lakes P-12 College
> 2-50 Minindee Road
> Wyndham Vale Victoria 3024
> poke.michael.c at edumail.vic.gov.au <mailto:poke.michael.c at edumail.vic.gov.au>
> P.(03)97414202 F.(03)97411420
>
> Google+: bit.ly/PokeGoogle <http://bit.ly/PokeGoogle>
> YouTube: bit.ly/MichaelPokeYouTube <http://bit.ly/MichaelPokeYouTube>
> Twitter: @michaelpoke <http://bit.ly/MichaelPokeTwitter>
>
>
>
>
>
>
>
>
>
> On 2 Dec 2015, at 11:09 AM, Sylvia Pastore <smp191172 at gmail.com <mailto:smp191172 at gmail.com>> wrote:
>
> Hi all
> Just wanted to know of any schools that have moved from PCs to Macbooks. How has your experience been and what are issues that you have had. Would love to have feedback of schools that have done this move and the reaction of staff as well!!!!
>
> Thanks in advance for your thoughts
>
> Sylvia
> _______________________________________________
> http://www.edulists.com.au <http://www.edulists.com.au/> - FAQ, resources, subscribe, unsubscribe
> VCE Informatics Mailing List kindly supported by
> http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html <http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html> - Victorian Curriculum and Assessment Authority <br>
> http://www.vitta.org.au <http://www.vitta.org.au/> - VITTA Victorian Information Technology Teachers Association Inc <br>
> http://www.swinburne.edu.au/ict/schools <http://www.swinburne.edu.au/ict/schools> - Swinburne University
>
>
> Important - 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 Training.
> _______________________________________________
> http://www.edulists.com.au <http://www.edulists.com.au/> - FAQ, resources, subscribe, unsubscribe
> VCE Informatics Mailing List kindly supported by
> http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html <http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html> - Victorian Curriculum and Assessment Authority <br>
> http://www.vitta.org.au <http://www.vitta.org.au/> - VITTA Victorian Information Technology Teachers Association Inc <br>
> http://www.swinburne.edu.au/ict/schools <http://www.swinburne.edu.au/ict/schools> - Swinburne University
>
>
> Important - 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 Training.
> _______________________________________________
> http://www.edulists.com.au <http://www.edulists.com.au/> - FAQ, resources, subscribe, unsubscribe
> VCE Informatics Mailing List kindly supported by
> http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html <http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html> - Victorian Curriculum and Assessment Authority <br>
> http://www.vitta.org.au <http://www.vitta.org.au/> - VITTA Victorian Information Technology Teachers Association Inc <br>
> http://www.swinburne.edu.au/ict/schools <http://www.swinburne.edu.au/ict/schools> - Swinburne University
>
> Important - 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 Training.
>
> Important - 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 Training.
> _______________________________________________
> http://www.edulists.com.au <http://www.edulists.com.au/> - FAQ, resources, subscribe, unsubscribe
> VCE Informatics Mailing List kindly supported by
> http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html <http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html> - Victorian Curriculum and Assessment Authority <br>
> http://www.vitta.org.au <http://www.vitta.org.au/> - VITTA Victorian Information Technology Teachers Association Inc <br>
> http://www.swinburne.edu.au/ict/schools <http://www.swinburne.edu.au/ict/schools> - Swinburne University
>
> <golfscores.csv><Unit2 O3 Task - myGolf - criteria sheet.docx><mygolf.zip><movies.zip><movies.sql><Unit2 O3 Task - myGolf.docx><U2 AoS3 Data Management.zip>_______________________________________________
> http://www.edulists.com.au <http://www.edulists.com.au/> - FAQ, resources, subscribe, unsubscribe
> VCE Informatics Mailing List kindly supported by
> http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html <http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html> - Victorian Curriculum and Assessment Authority <br>
> http://www.vitta.org.au <http://www.vitta.org.au/> - VITTA Victorian Information Technology Teachers Association Inc <br>
> http://www.swinburne.edu.au/ict/schools <http://www.swinburne.edu.au/ict/schools> - Swinburne University
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/informatics/attachments/20151203/c69f6203/attachment-0001.html
More information about the informatics
mailing list