[Year 12 IT Apps] Sample Data for Database

[Robert]

Nice point Mike.

OK to provide sample data

BUT

that data must not in any way guide students towards the relational database solution

So  as you suggest provide the data "in a single spreadsheet ", etc

Robert Hind (Semi-retired)
Ashwood and Traralgon
robert at yinnar.com


  ----- Original Message ----- 
  From: Mike Brookes 
  To: Year 12 IT Applications Teachers' Mailing List 
  Sent: Tuesday, March 09, 2010 5:44 PM
  Subject: Re: [Year 12 IT Apps] Sample Data for Database


  At the risk of playing devil's advocate, why do you need to provide data in the first place? 
  In particular, giving them data which has already been split into tables prevents them from demonstrating skills in designing the table structure of a relational database.
  The students are required to generate data to test that the database works properly so you don't need to provide any.
  If you wanted to provide a set of data to make it easy to check output then the data should be in a single spreadsheet and include some irrelevant and invalid data.

  Mike Brookes
  Chief cook and bottlewasher Copperfield College

  On 8/03/2010 9:34 AM, Paul Miller wrote: 
    Hi Guys,



    Just sitting down to write the SAC for Outcome 1.



    I get the girls to run an import of data from excel into access. I generally like to give them a lot of data...it produces more meaningful query results. For the last few years I've done a pet database and want to change for this year. Does anyone have a good set of sample data I can use for any other fictitous company...e.g. orders or something like that. Rather than scour the net or pinch stuff off the good old northwind database, wanted to see if any of you had anything with some decent data. Have attached the excel files I used last year...



    Would very much appreciate any help there!



    Cheers,



    Paul.

    _______________________________________________ 
    http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe 
    IT Applications Mailing List kindly supported by 
    http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html - Victorian Curriculum and Assessment Authority and 
    http://www.vitta.org.au - VITTA Victorian Information Technology Teachers Association Inc

  _______________________________________________ 
  http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe 
  IT Applications Mailing List kindly supported by 
  http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html - Victorian Curriculum and Assessment Authority and 
  http://www.vitta.org.au - VITTA Victorian Information Technology Teachers Association Inc 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20100309/8185234a/attachment-0001.html