[Year 12 IPM] databases

[Laurie Savage]

We use Access, the Potts et al text has a reasonable set of introductory 
exercises you can write tasks around. If you have Filemaker I can 
recommend that - it's simpler to design forms in and you can develop 
relationships on the fly.

MySQL is very potent but SQL programming is beyond my students, most of 
whom are foundation Maths or worse. You can do great stuff with MySQL 
but its real power is at the command line or PHP/Perl API. Depends on 
your students but it's free and fun for students who like programming.

Laurie

Travers, Graham J wrote:
> I reckon it's really worth having a look at MySQL. 
> 
> I have used it in ITS and coupled with php (programming) and you can do
> some nice web stuff. That combo is the basis of many CMS
> (content-management-system) websites. 
> 
> You may be able to give the kids the 15-20 lines of php code w/o a real
> need for them to understand all of it.
> 
> Alternatively, I'm sure someone like Con Zymaris could direct you to
> some preliminary MySQL tasks (a squillion on the web). 
> 
> I think it may be more 'progressive' than the Word/Access/Excel path
> IMHO.
> 
> I have produced notes on how to setup a MySQL db and produce output from
> it. 
> 
> http://www.grahamtravers.com/pdf_files/Using_PHP_with_a_MySQL_database.p
> df
> 
> The notes may need a little updating, and phpdev is better than foxserv.
> 
> Graham Travers
> 
> 
> 
> -----Original Message-----
> From: ipm-bounces at edulists.com.au [mailto:ipm-bounces at edulists.com.au]
> On Behalf Of Keith Richardson
> Sent: Tuesday, 28 March 2006 2:59 PM
> To: Year 12 Information Technology Processing and Management
> Teachers'Mailing List
> Subject: Re: [Year 12 IPM] databases
> 
> Robyn - I have been using Access for the past few years, and it has
> worked fine.
> I do like its integration with both Excel and Word - useful for carrying
> out some useful projects.
> If I can be of any help, do not hesitate to ask.
> Ciao, Keith
> 
> 
> 
> On Tue, 28 Mar 2006 13:42:38 +1000, "Robyn Dunn"
> <robyn at camhigh.vic.edu.au> said:
>> Having looked at the study design and seen the dreaded word database I
>> suppose I'll have to come to terms with doing databases again after
>> dropping them about 5 years ago. What software are people looking at? 
>>
>> Ms Robyn Dunn
>> ICT Co-Ordinator
>> Camberwell High School
>> email: du at camhigh.vic.edu.au
>> phone: 98360555
>> fax: 98360194
>>
>>
>>
>> _______________________________________________
>> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
>> IPM Mailing List kindly supported by
>> http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment
>> Authority and
>> http://www.vitta.org.au  - VITTA Victorian Information Technology
>> Teachers Association Inc
> Keith Richardson
> IPM List Moderator
> Head of ICT, Leibler Yavneh College
> Elsternwick
> Ph: 03.9528.4911
> k.richardson at yavneh.vic.edu.au
> 
> _______________________________________________
> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
> IPM Mailing List kindly supported by
> http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment
> Authority and
> http://www.vitta.org.au  - VITTA Victorian Information Technology
> Teachers Association Inc
> 
> 
> 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 & Training.
> 
> _______________________________________________
> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
> IPM Mailing List kindly supported by
> http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment Authority and
> http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers Association Inc
> 
> 

-- 
Laurie Savage
=============================================
Student Assessment, Reporting and Tracking
Pascoe Vale Girls College, 03 9306 2544
Lake Ave, Pascoe Vale, Victoria, 3044
=============================================