Level 2 Unit 7 Database Design 2010 Spec Part 4
So final instalment: If you are running a VLE that accepts Scorm resources, I've written the Gamez Frenzy Assignment in a self contained course. It sits easily on VLEs like Moodle but could easily be unpacked and used as offline HTML pages. Contact me if you would like the 3Mb zipped content.
Any similarity to other games rental companies trading as Gamez Frenzy is purely coincidental.
Pete
- 2059 views
- 28 replies


Replies
Please can I have a copy of the Unit 7 resources.
email: harris.m@caldicotschool.com
Many thanks
Please can i have a copy of the Unit 7 resources. Email me at: bfc1974 AT hotmail DOT com
Im sure Pete's new spec U7 resources are really good but I also I have a full set including bespoke scenario, all documentation, teaching materials etc etc here for FREE: http://vle.fulford.york.sch.uk/course/view.php?id=440
Enjoy
Nick
Hi Pete,
I would also be grateful for a copies of any resources for New Spec level 2 Unit 7 please. Thank you
email: jonesc@st-maryshigh.lancs.sch.uk
Carol
Hi,
Please could you email to me all resource avaialble for unit 7 at level 2 also. Thanks, much appreciated.
email to: gez_collier@yahoo.co.uk
Regards.
Please could I have a copy of any resources available and any examplar work if possible as we are teaching this for the first time in September. I have student work and scenarios for various units if needed.
simons.k@we-learn.com
Thank you
Kay
Could I please have a copy of this resource.
Thanks
dclarke@thornleigh.bolton.sch.uk
Could I also get a copy of your resources for Unit 7 ?
email: cmccrossan458@c2kni.net
Many thanks.
Hi Pete,
Could you please email me a copy of your Unit 7 resources?
My email in idevans969@bishopston.swansea.sch.uk
We are just starting out with the Nationals and this would be most appreciated.
Many thanks, it's very generous of you to be sharing your resources.
Ian
Hi Pete
Please can I have your resources for the 2010 Spec of Unit 7, we use Moodle here and it will work quite well
My email is rmckinlay@sacc.notts.sch.uk
Cheers in Advance
Ross
Hi Pete
I would like to take you up on the offer of your resources for the 2010 Spec of Unit 7
My email is j.bailey@springvalelearning.com
Nicola,
The problem is that if you have a set of data that can be imported it is, almost by definition, organised in a field structure already and it is this that I think we need to get the students to define.
Dave
Absolutely Dave. Not only is the teacher defining the fields required but also the tables, which is probably the most important discriminator between Pass and Merit - the ability to create a design for multiple tables.
Hi, thanks for your replies.
i have improted the data but not assigned any data types/primary keys/input masks/combo boxes or validation rules, they have designed these themselves and can make the changes/add rules to these tables including creating the relationships. Will this be ok then?
Thanks
Nicola
Nicola,
The problem is that if you have a set of data that can be imported it is, almost by definition, organised in a field structure already and it is this that I think we need to get the students to define.
Dave
Hi
i wondered if anyone can help with AO2? do pupils have to show evidence of importing the data to the tables? it would help me timewise if they could open the created tables and just add the validation rules/combo boxes and input masks to the data provided.
Please help :$
thanks
Nicola
Hi, thanks for your replies.
i have improted the data but not assigned any data types/primary keys/input masks/combo boxes or validation rules, they have designed these themselves and can make the changes/add rules to these tables including creating the relationships. Will this be ok then?
Thanks
Nicola
Under the new spec I see no requirement to demonstrate how the tables were populated; although it says "A form will be created to enter data in the table", it doesn't specify that it has to be ...
Under the new spec I see no requirement to demonstrate how the tables were populated; although it says "A form will be created to enter data in the table", it doesn't specify that it has to be used to enter *all* the data. I would suggest that as long as at least one record is entered through the form (which of course would also form part of the testing required for AO6) that would be sufficient.
The guidance does suggest that a minimum of 30 records but again doesn't specify how those records are added to the tables.
Although Dave is right to say that there is no requirement to demonstrate HOW the tables were populated the AO is about constructing a database that the candidate has designed. This means setting up the tables from scratch and entering the data. The Knowledge, Understanding and Skills section of the unit specification lists the skills that candidates need to be taught before they embark upon assessment. Simply adding validation to existing tables does not meet this requirement. As it is expected that candidates' designs for their database will not be the same then their requirements for data tables will be different too.
Anne Kelsall (Regional Chief Co-ordinator, Midlands)
Hi
i wondered if anyone can help with AO2? do pupils have to show evidence of importing the data to the tables? it would help me timewise if they could open the created tables and just add the validation rules/combo boxes and input masks to the data provided.
Please help :$
thanks
Nicola
Under the new spec I see no requirement to demonstrate how the tables were populated; although it says "A form will be created to enter data in the table", it doesn't specify that it has to be used to enter *all* the data. I would suggest that as long as at least one record is entered through the form (which of course would also form part of the testing required for AO6) that would be sufficient.
The guidance does suggest that a minimum of 30 records but again doesn't specify how those records are added to the tables.
Hi
i wondered if anyone can help with AO2? do pupils have to show evidence of importing the data to the tables? it would help me timewise if they could open the created tables and just add the validation rules/combo boxes and input masks to the data provided.
Please help :$
thanks
Nicola
Hi Pete,
Please could you also send me a copy of your Unit 7 resources to jclampin@rusheymead-sec.leicester.sch.uk. Many thanks - mcuh appreciated.
Regards,
John Clampin: Lead Teacher KS4 ICT
Hi Pete
would like to take you up on the offer of your resources for the 2010 Spec of Unit 7.
Email address: sophiafoxuk@yahoo.co.uk
Many thanks
sophie
Hi Pete
would like to take you up on the offer of your resources for the 2010 Spec of Unit 7.
Email address: sophiafoxuk@yahoo.co.uk
Many thanks
sophie
Hi Pete,
Please could you also send a copy of your Unit 7 resources to me at jclampin@rusheymead-sec.leicester.sch.uk. Many thanks - much appreciated.
John Clampin: Lead Teacher KS4 ICT
Hi Pete
would like to take you up on the offer of your resources for the 2010 Spec of Unit 7.
Email address: sophiafoxuk@yahoo.co.uk
Many thanks
sophie
Hi Komal
I've emailed the content requested today. Let me know how you get on with it
Pete
Hi, could I please have a copy?
s.smith01@kimberleyschool.co.uk
Thanks in advance
Hi Pete
I would like to take you up on the offer of your resources for the 2010 Spec of Unit 7.
Email address: paul.squire@pilgrim.lincs.sch.uk
Many thanks
paul squire
Hi Pete
I would like to take you up on the offer of your resources for the 2010 Spec of Unit 7.
Email address: rawlings@humphry-davy.cornwall.sch.uk
Many thanks
Melanie Rawlings
I would also like to take you up on the offer of Unit 7 and anything for unit 6, 20, 21, 22 and 23 would be a great help too
Thanks
Samantha
spascoe@netherhall.cambs.sch.uk
Thank you for these resources. I am teaching this unit for the first time and any help is much appreciated. Do you have any handouts that you give to the students to support them in lesson as well. Don't worry if not I will have to sort some out myself.
Best wishes and well done
Claire Morrison
cmorrison@stivoschool.org
Dear Pete
Thank you for sharing your resources, I would kindly like to you up on the offer too with the new Unit 7 Specification. The email is: kvyas@Whtc.co.uk
Please feel free if you would like any ...
Dear Pete
Thank you for sharing your resources, I would kindly like to you up on the offer too with the new Unit 7 Specification. The email is: kvyas@Whtc.co.uk
Please feel free if you would like any help or materials for the other current or old spec units from the following: 1, 2, 4, 6, 7, 20, 21, 22 & 23.
Many Thanks
Komal
Hi Komal
I've emailed the content requested today. Let me know how you get on with it
Pete
Dear Pete
Thank you for sharing your resources, I would kindly like to you up on the offer too with the new Unit 7 Specification. The email is: kvyas@Whtc.co.uk
Please feel free if you would like any help or materials for the other current or old spec units from the following: 1, 2, 4, 6, 7, 20, 21, 22 & 23.
Many Thanks
Komal
I would like to take you up on the offer for resources for U7 New Spec. The entire collection that you have would be great.
Thnks in advance for your support on this.
email is: pramnarain@sponneschool.northants.sch.uk