[Year 12 IT Apps] Sample Data for Database

[Mike Brookes]

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 <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 
> <http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html%20> 
> - Victorian Curriculum and Assessment Authority and
> http://www.vitta.org.au <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/6ecc3680/attachment.html