[Informatics] MySQL

Wed Dec 2 21:58:15 AEDT 2015

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] 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] 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] 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] 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.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 - 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 - 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 - 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 - 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 - 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 - Swinburne University

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/informatics/attachments/20151202/5459072c/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: golfscores.csv
Type: application/octet-stream
Size: 459 bytes
Desc: golfscores.csv
Url : http://www.edulists.com.au/pipermail/informatics/attachments/20151202/5459072c/golfscores-0001.csv 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Unit2 O3 Task - myGolf - criteria sheet.docx
Type: application/vnd.openxmlformats-officedocument.wordprocessingml.document
Size: 19140 bytes
Desc: Unit2 O3 Task - myGolf - criteria sheet.docx
Url : http://www.edulists.com.au/pipermail/informatics/attachments/20151202/5459072c/Unit2O3Task-myGolf-criteriasheet-0001.docx 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: mygolf.zip
Type: application/x-zip-compressed
Size: 54805 bytes
Desc: mygolf.zip
Url : http://www.edulists.com.au/pipermail/informatics/attachments/20151202/5459072c/mygolf-0001.zip 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: movies.zip
Type: application/x-zip-compressed
Size: 13094 bytes
Desc: movies.zip
Url : http://www.edulists.com.au/pipermail/informatics/attachments/20151202/5459072c/movies-0001.zip 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: movies.sql
Type: application/octet-stream
Size: 24628 bytes
Desc: movies.sql
Url : http://www.edulists.com.au/pipermail/informatics/attachments/20151202/5459072c/movies-0001.sql 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Unit2 O3 Task - myGolf.docx
Type: application/vnd.openxmlformats-officedocument.wordprocessingml.document
Size: 635978 bytes
Desc: Unit2 O3 Task - myGolf.docx
Url : http://www.edulists.com.au/pipermail/informatics/attachments/20151202/5459072c/Unit2O3Task-myGolf-0001.docx 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: U2 AoS3 Data Management.zip
Type: application/x-zip-compressed
Size: 1110785 bytes
Desc: U2 AoS3 Data Management.zip
Url : http://www.edulists.com.au/pipermail/informatics/attachments/20151202/5459072c/U2AoS3DataManagement-0001.zip 